APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_ITEM_MASTER

Line 24: FROM CZ_IMP_ITEM_MASTER

20: CHECKOUT_USER,USER_STR01,USER_STR02,
21: USER_STR03,USER_STR04,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,
22: ORIG_SYS_REF,PRIMARY_UOM_CODE,DECIMAL_QTY_FLAG,
23: SRC_APPLICATION_ID, SRC_TYPE_CODE
24: FROM CZ_IMP_ITEM_MASTER
25: WHERE CZ_IMP_ITEM_MASTER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
26:
27: x_xfr_itemmaster_f BOOLEAN:=FALSE;
28: x_error BOOLEAN:=FALSE;

Line 25: WHERE CZ_IMP_ITEM_MASTER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

21: USER_STR03,USER_STR04,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,
22: ORIG_SYS_REF,PRIMARY_UOM_CODE,DECIMAL_QTY_FLAG,
23: SRC_APPLICATION_ID, SRC_TYPE_CODE
24: FROM CZ_IMP_ITEM_MASTER
25: WHERE CZ_IMP_ITEM_MASTER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
26:
27: x_xfr_itemmaster_f BOOLEAN:=FALSE;
28: x_error BOOLEAN:=FALSE;
29:

Line 142: UPDATE CZ_IMP_item_master

138: NVL(p_xfr_itemmaster.SRC_APPLICATION_ID,cnDefSrcAppId),
139: NVL(p_xfr_itemmaster.SRC_TYPE_CODE,cnDefSrcTypeCode));
140: nInsertCount:=nInsertCount+1;
141:
142: UPDATE CZ_IMP_item_master
143: SET REC_STATUS='OK'
144: WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
145: AND DISPOSITION='I';
146:

Line 151: UPDATE CZ_IMP_item_master

147: EXCEPTION
148: WHEN OTHERS THEN
149: FAILED:=FAILED +1;
150:
151: UPDATE CZ_IMP_item_master
152: SET REC_STATUS='ERR'
153: WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
154: AND DISPOSITION='I';
155:

Line 193: UPDATE CZ_IMP_item_master

189: FAILED:=FAILED+1;
190: ELSE
191: nUpdateCount:=nUpdateCount+1;
192:
193: UPDATE CZ_IMP_item_master
194: SET REC_STATUS='OK'
195: WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
196: AND DISPOSITION='M';
197:

Line 203: UPDATE CZ_IMP_item_master

199: EXCEPTION
200: WHEN OTHERS THEN
201: FAILED:=FAILED +1;
202:
203: UPDATE CZ_IMP_item_master
204: SET REC_STATUS='ERR'
205: WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
206: AND DISPOSITION='M';
207:

Line 213: UPDATE CZ_IMP_item_master

209: END ;
210:
211: ELSIF (p_xfr_itemmaster.DISPOSITION = 'N')THEN
212:
213: UPDATE CZ_IMP_item_master
214: SET REC_STATUS='OK'
215: WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
216: AND DISPOSITION='N';
217: nNoChangeCount:=nNoChangeCount+(sql%rowcount);