APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_ITEM_PROPERTY_VALUE

Line 241: FROM CZ_IMP_ITEM_PROPERTY_VALUE WHERE

237: USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,
238: ORIG_SYS_REF, NVL(FSK_PROPERTY_1_1, FSK_PROPERTY_1_EXT) AS FSK_PROPERTY,
239: NVL(FSK_ITEMMASTER_2_1, FSK_ITEMMASTER_2_EXT) AS FSK_ITEMMASTER,
240: SRC_APPLICATION_ID
241: FROM CZ_IMP_ITEM_PROPERTY_VALUE WHERE
242: RUN_ID=inRUN_ID AND REC_STATUS IN ('PASS','F3X');
243:
244: x_xfr_itempropertyvalue_f BOOLEAN:=FALSE;
245: x_error BOOLEAN:=FALSE;

Line 328: UPDATE CZ_IMP_item_property_value

324: p_xfr_itempropertyvalue.CHECKOUT_USER, sOrigSysRef, p_xfr_itempropertyvalue.SRC_APPLICATION_ID);
325:
326: nInsertCount:=nInsertCount+1;
327:
328: UPDATE CZ_IMP_item_property_value
329: SET REC_STATUS='OK'
330: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
331: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
332: AND DISPOSITION='I' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;

Line 338: UPDATE CZ_IMP_item_property_value

334: EXCEPTION
335: WHEN OTHERS THEN
336: FAILED:=FAILED +1;
337:
338: UPDATE CZ_IMP_item_property_value
339: SET REC_STATUS='ERR'
340: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
341: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
342: AND DISPOSITION='I' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;

Line 370: UPDATE CZ_IMP_item_property_value

366: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IM_XFR.XFR_ITEM_PROPERTY_VALUE',11276,inRUN_ID);
367: ELSE
368: IF(p_xfr_itempropertyvalue.REC_STATUS<>'F3X')THEN nUpdateCount:=nUpdateCount+1; END IF;
369:
370: UPDATE CZ_IMP_item_property_value
371: SET REC_STATUS=DECODE(p_xfr_itempropertyvalue.REC_STATUS,'PASS','OK',p_xfr_itempropertyvalue.REC_STATUS)
372: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
373: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
374: AND DISPOSITION='M' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;

Line 381: UPDATE CZ_IMP_item_property_value

377: EXCEPTION
378: WHEN OTHERS THEN
379: FAILED:=FAILED +1;
380:
381: UPDATE CZ_IMP_item_property_value
382: SET REC_STATUS='ERR'
383: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
384: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
385: AND DISPOSITION='M' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;