APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_ITEM_MASTER

Line 23: FROM CZ_IMP_ITEM_MASTER

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

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

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

Line 140: UPDATE CZ_IMP_item_master

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

Line 149: UPDATE CZ_IMP_item_master

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

Line 191: UPDATE CZ_IMP_item_master

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

Line 201: UPDATE CZ_IMP_item_master

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