APPS.CZ_IMP_IM_XFR dependencies on CZ_ITEM_TYPE_PROPERTIES

Line 615: sOrigSysRef cz_item_type_properties.orig_sys_ref%TYPE;

611: NOUPDATE_LAST_UPDATED_BY NUMBER;
612: NOUPDATE_SECURITY_MASK NUMBER;
613: NOUPDATE_CHECKOUT_USER NUMBER;
614:
615: sOrigSysRef cz_item_type_properties.orig_sys_ref%TYPE;
616:
617: -- Make sure that the DataSet exists
618: BEGIN
619: -- Get the Update Flags for each column

Line 654: INSERT INTO CZ_ITEM_TYPE_PROPERTIES (ITEM_TYPE_ID,PROPERTY_ID,

650: END IF;
651:
652: IF (p_xfr_itemtypeprop.DISPOSITION = 'I') THEN
653: BEGIN
654: INSERT INTO CZ_ITEM_TYPE_PROPERTIES (ITEM_TYPE_ID,PROPERTY_ID,
655: /* USER_NUM01,USER_NUM02, USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04,*/
656: CREATION_DATE, LAST_UPDATE_DATE, DELETED_FLAG ,CREATED_BY, LAST_UPDATED_BY,
657: SECURITY_MASK, ORIG_SYS_REF, SRC_APPLICATION_ID) VALUES
658: (p_xfr_itemtypeprop.ITEM_TYPE_ID,p_xfr_itemtypeprop.PROPERTY_ID,

Line 684: UPDATE CZ_ITEM_TYPE_PROPERTIES SET

680: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_XFR.XFR_ITEM_TYPE_PROP',11276,inRUN_ID);
681: END ;
682: ELSIF (p_xfr_itemtypeprop.DISPOSITION = 'M') THEN
683: BEGIN
684: UPDATE CZ_ITEM_TYPE_PROPERTIES SET
685: DELETED_FLAG= DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_itemtypeprop.DELETED_FLAG ,DELETED_FLAG),
686: /* USER_NUM01= DECODE(NOUPDATE_USER_NUM01, 0,p_xfr_itemtypeprop.USER_NUM01,USER_NUM01),
687: USER_NUM02= DECODE(NOUPDATE_USER_NUM02, 0,p_xfr_itemtypeprop.USER_NUM02,USER_NUM02),
688: USER_NUM03= DECODE(NOUPDATE_USER_NUM03, 0,p_xfr_itemtypeprop.USER_NUM03,USER_NUM03),