XinYu_RZMES/.svn/pristine/04/04bd60243c38300b39e45e6d26a418e22695c05e.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">

	<query id="NIG020630_CHARGE_COM.select" desc="  " fetchSize="10">
		<![CDATA[
			  
      SELECT   BEF_PROG_CD,CUR_PROG_CD  
       FROM TBG02_CHARGE_COMM 
      WHERE CHARGE_NO = ?  				  
        ]]>
	</query> 
	
   <query id="NIG020630_HCR_MILL_FL.select" desc="  " fetchSize="10">
		<![CDATA[
			  
			SELECT D.SLAB_NO
			  FROM TBG02_CHARGE_COMM   A
				   ,TBF01_SPEC_CHARGE  B
				   ,TBF01_SPEC_SLAB    C
				   ,TBG02_SLAB_COMM    D
			WHERE  A.PLAN_CHARGE_NO    = B.CHARGE_MANA_NO
			  AND  B.CHARGE_EDT_SEQ    = C.CHARGE_EDT_SEQ
			  AND  C.SLAB_MANA_NO      = D.PLAN_SLAB_NO
			  AND  A.CHARGE_STAT       = '2'
			  AND  A.HCR_CLF           = 'H'
			  AND  A.CHARGE_NO         = ?
			  AND  C.MILL_FL           = 'Y'
						  
        ]]>
	</query> 
	
	<query id="NIG020630_CHARGE_COM.update" desc=" " fetchSize="10">
		<![CDATA[	
			update TBG02_CHARGE_COMM set 
			   CHARGE_STAT = '3' 
              ,MATRL_END_DTIME       = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
			  ,RTN_CHARGE_OCR_DTIME  = ?  
			  ,RTN_CHARGE_CAUSE_CD   = ?
			  ,RTN_CHARGE_WGT        = ?
			  ,RTN_CHARGE_OCR_PROC   = ?	
			  ,RTN_CHARGE_CLF = 'Y'	 
			where CHARGE_NO=?	
		]]>
	</query>  
    <query id="NIG020630_SLAB_COMM.update" desc="     " fetchSize="10">
        <![CDATA[
            UPDATE TBG02_SLAB_COMM SET 
              SLAB_STAT = '3'
            WHERE SUBSTR(SLAB_NO,1,10) = ?    
        ]]>
    </query> 
	<query id="NIG020630_CHARGE_NO_INIT" desc="     " fetchSize="10">
        <![CDATA[
            select t.CHARGE_NO,t.CHARGE_NO,t.RTN_CHARGE_CLF from tbg02_charge_comm  t where t.CHARGE_STAT = '2'  
        ]]>
    </query>
	<query id="CALL_RTN_CHARGE_AUTO" desc="사원추가" fetchSize="1">
        <![CDATA[
						
            {call RTN_CHARGE_AUTO.RTN_CHARGE_AUT0_SEND_F01(?,?,?)}
			
        ]]>
    </query>
</queryMap>