APPS.CZ_IMP_IM_XFR dependencies on CZ_ITEM_TYPE_PROPERTIES

Line 653: sOrigSysRef cz_item_type_properties.orig_sys_ref%TYPE;

649: NOUPDATE_LAST_UPDATED_BY NUMBER;
650: NOUPDATE_SECURITY_MASK NUMBER;
651: NOUPDATE_CHECKOUT_USER NUMBER;
652:
653: sOrigSysRef cz_item_type_properties.orig_sys_ref%TYPE;
654:
655: -- Make sure that the DataSet exists
656: BEGIN
657: -- Get the Update Flags for each column

Line 692: INSERT INTO CZ_ITEM_TYPE_PROPERTIES (ITEM_TYPE_ID,PROPERTY_ID,

688: END IF;
689:
690: IF (p_xfr_itemtypeprop.DISPOSITION = 'I') THEN
691: BEGIN
692: INSERT INTO CZ_ITEM_TYPE_PROPERTIES (ITEM_TYPE_ID,PROPERTY_ID,
693: /* USER_NUM01,USER_NUM02, USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04,*/
694: CREATION_DATE, LAST_UPDATE_DATE, DELETED_FLAG ,CREATED_BY, LAST_UPDATED_BY,
695: SECURITY_MASK, ORIG_SYS_REF, SRC_APPLICATION_ID) VALUES
696: (p_xfr_itemtypeprop.ITEM_TYPE_ID,p_xfr_itemtypeprop.PROPERTY_ID,

Line 722: UPDATE CZ_ITEM_TYPE_PROPERTIES SET

718: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_XFR.XFR_ITEM_TYPE_PROP',11276,inRUN_ID);
719: END ;
720: ELSIF (p_xfr_itemtypeprop.DISPOSITION = 'M') THEN
721: BEGIN
722: UPDATE CZ_ITEM_TYPE_PROPERTIES SET
723: DELETED_FLAG= DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_itemtypeprop.DELETED_FLAG ,DELETED_FLAG),
724: /* USER_NUM01= DECODE(NOUPDATE_USER_NUM01, 0,p_xfr_itemtypeprop.USER_NUM01,USER_NUM01),
725: USER_NUM02= DECODE(NOUPDATE_USER_NUM02, 0,p_xfr_itemtypeprop.USER_NUM02,USER_NUM02),
726: USER_NUM03= DECODE(NOUPDATE_USER_NUM03, 0,p_xfr_itemtypeprop.USER_NUM03,USER_NUM03),