APPS.CZ_IMP_IM_KRS dependencies on CZ_ITEM_PROPERTY_VALUES

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

303: iItemId tItemId;
304: iPropertyId tPropertyId;
305:
306:
307: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);
308: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
309: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
310:
311: -- passing records

Line 404: AND EXISTS (SELECT NULL FROM cz_item_property_values

400: disposition='M',
401: rec_status='PASS'
402: WHERE run_id=inRUN_ID
403: AND orig_sys_ref=iOrigSysRef(i)
404: AND EXISTS (SELECT NULL FROM cz_item_property_values
405: WHERE orig_sys_ref = a.orig_sys_ref);
406:
407: UPDATES := UPDATES + SQL%ROWCOUNT;
408: COMMIT;

Line 437: AND EXISTS (SELECT NULL FROM cz_item_property_values

433: rec_status='PASS' /*VIGRAMAK EDIT*/
434: WHERE run_id=inRUN_ID
435: AND disposition = 'M'
436: AND orig_sys_ref=iOrigSysRef(i)
437: AND EXISTS (SELECT NULL FROM cz_item_property_values
438: WHERE orig_sys_ref = a.orig_sys_ref
439: AND property_id= iPropertyId(i)
440: AND nvl(property_num_value,0) = nvl(a.property_num_value,0)
441: AND nvl(property_value,' ')=nvl(a.property_value,' '));

Line 456: AND NOT EXISTS (SELECT NULL FROM cz_item_property_values

452: disposition='I',
453: rec_status='PASS'
454: WHERE run_id=inRUN_ID
455: AND orig_sys_ref=iOrigSysRef(i)
456: AND NOT EXISTS (SELECT NULL FROM cz_item_property_values
457: WHERE orig_sys_ref = a.orig_sys_ref);
458:
459: INSERTS := INSERTS + SQL%ROWCOUNT;
460: COMMIT;

Line 558: UPDATE cz_item_property_values iv

554:
555:
556: /* Check if any properties have been deleted in APPS */
557:
558: UPDATE cz_item_property_values iv
559: SET deleted_flag = '1'
560: WHERE deleted_flag = '0'
561: AND NOT EXISTS
562: (SELECT NULL FROM cz_imp_item_property_value

Line 949: UPDATE CZ_ITEM_PROPERTY_VALUES

945: AND DELETED_FLAG = '0')
946: AND ORIG_SYS_REF IS NOT NULL
947: AND DELETED_FLAG = '0';
948:
949: UPDATE CZ_ITEM_PROPERTY_VALUES
950: SET DELETED_FLAG = '1'
951: WHERE ITEM_ID IN (SELECT IM.ITEM_ID
952: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP
953: WHERE IM.ITEM_TYPE_ID = IT.ITEM_TYPE_ID

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

952: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP
953: WHERE IM.ITEM_TYPE_ID = IT.ITEM_TYPE_ID
954: AND IT.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
955: AND ITP.DELETED_FLAG = '1'
956: AND CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID = ITP.PROPERTY_ID);
957:
958:
959:
960: END;