APPS.CZ_IMP_IM_KRS dependencies on CZ_ITEM_PROPERTY_VALUES

Line 256: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);

252: iOrigSysRef tOrigSysRef;
253: iItemId tItemId;
254: iPropertyId tPropertyId;
255:
256: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);
257: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
258: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
259:
260: -- passing records

Line 351: AND EXISTS (SELECT NULL FROM cz_item_property_values

347: disposition='M',
348: rec_status='PASS'
349: WHERE run_id=inRUN_ID
350: AND orig_sys_ref=iOrigSysRef(i)
351: AND EXISTS (SELECT NULL FROM cz_item_property_values
352: WHERE orig_sys_ref = a.orig_sys_ref);
353:
354: UPDATES := UPDATES + SQL%ROWCOUNT;
355: COMMIT;

Line 387: AND NOT EXISTS (SELECT NULL FROM cz_item_property_values

383: disposition='I',
384: rec_status='PASS'
385: WHERE run_id=inRUN_ID
386: AND orig_sys_ref=iOrigSysRef(i)
387: AND NOT EXISTS (SELECT NULL FROM cz_item_property_values
388: WHERE orig_sys_ref = a.orig_sys_ref);
389:
390: INSERTS := INSERTS + SQL%ROWCOUNT;
391: COMMIT;

Line 489: UPDATE cz_item_property_values iv

485:
486:
487: /* Check if any properties have been deleted in APPS */
488:
489: UPDATE cz_item_property_values iv
490: SET deleted_flag = '1'
491: WHERE deleted_flag = '0'
492: AND NOT EXISTS
493: (SELECT NULL FROM cz_imp_item_property_value

Line 845: UPDATE CZ_ITEM_PROPERTY_VALUES

841: AND DELETED_FLAG = '0')
842: AND ORIG_SYS_REF IS NOT NULL
843: AND DELETED_FLAG = '0';
844:
845: UPDATE CZ_ITEM_PROPERTY_VALUES
846: SET DELETED_FLAG = '1'
847: WHERE ITEM_ID IN (SELECT IM.ITEM_ID
848: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP
849: WHERE IM.ITEM_TYPE_ID = IT.ITEM_TYPE_ID

Line 852: AND CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID = ITP.PROPERTY_ID);

848: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP
849: WHERE IM.ITEM_TYPE_ID = IT.ITEM_TYPE_ID
850: AND IT.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
851: AND ITP.DELETED_FLAG = '1'
852: AND CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID = ITP.PROPERTY_ID);
853:
854: END;
855: COMMIT;
856: INSERTS:=nInsertCount;