APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_ITEM_PROPERTY_VALUE

Line 254: FROM CZ_IMP_ITEM_PROPERTY_VALUE WHERE

250: USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,
251: ORIG_SYS_REF, NVL(FSK_PROPERTY_1_1, FSK_PROPERTY_1_EXT) AS FSK_PROPERTY,
252: NVL(FSK_ITEMMASTER_2_1, FSK_ITEMMASTER_2_EXT) AS FSK_ITEMMASTER,
253: SRC_APPLICATION_ID
254: FROM CZ_IMP_ITEM_PROPERTY_VALUE WHERE
255: RUN_ID=inRUN_ID AND REC_STATUS IN ('PASS','F3X');
256:
257: x_xfr_itempropertyvalue_f BOOLEAN:=FALSE;
258: x_error BOOLEAN:=FALSE;

Line 342: UPDATE CZ_IMP_item_property_value

338: p_xfr_itempropertyvalue.CHECKOUT_USER, sOrigSysRef, p_xfr_itempropertyvalue.SRC_APPLICATION_ID);
339:
340: nInsertCount:=nInsertCount+1;
341:
342: UPDATE CZ_IMP_item_property_value
343: SET REC_STATUS='OK'
344: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
345: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
346: AND DISPOSITION='I' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;

Line 352: UPDATE CZ_IMP_item_property_value

348: EXCEPTION
349: WHEN OTHERS THEN
350: FAILED:=FAILED +1;
351:
352: UPDATE CZ_IMP_item_property_value
353: SET REC_STATUS='ERR'
354: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
355: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
356: AND DISPOSITION='I' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;

Line 384: UPDATE CZ_IMP_item_property_value

380: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IM_XFR.XFR_ITEM_PROPERTY_VALUE',11276,inRUN_ID);
381: ELSE
382: IF(p_xfr_itempropertyvalue.REC_STATUS<>'F3X')THEN nUpdateCount:=nUpdateCount+1; END IF;
383:
384: UPDATE CZ_IMP_item_property_value
385: SET REC_STATUS=DECODE(p_xfr_itempropertyvalue.REC_STATUS,'PASS','OK',p_xfr_itempropertyvalue.REC_STATUS)
386: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
387: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
388: AND DISPOSITION='M' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;

Line 395: UPDATE CZ_IMP_item_property_value

391: EXCEPTION
392: WHEN OTHERS THEN
393: FAILED:=FAILED +1;
394:
395: UPDATE CZ_IMP_item_property_value
396: SET REC_STATUS='ERR'
397: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
398: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
399: AND DISPOSITION='M' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;

Line 404: UPDATE CZ_IMP_item_property_value

400:
401: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_XFR.XFR_ITEM_PROPERTY_VALUE',11276,inRUN_ID);
402: END;
403: ELSIF (p_xfr_itempropertyvalue.DISPOSITION = 'N' ) THEN /*VIGRAMAK*/
404: UPDATE CZ_IMP_item_property_value
405: SET REC_STATUS=DECODE(p_xfr_itempropertyvalue.REC_STATUS,'PASS','OK',p_xfr_itempropertyvalue.REC_STATUS)
406: WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
407: AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
408: AND DISPOSITION='N' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;