DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_TYPE_APPLICATIONS

Line 800: FROM ENG_CHANGE_TYPE_APPLICATIONS A,

796: IS
797:
798: CURSOR get_applications IS
799: SELECT A.APPLICATION_ID
800: FROM ENG_CHANGE_TYPE_APPLICATIONS A,
801: ENG_CHANGE_ORDER_TYPES C
802: WHERE C.CHANGE_ORDER_TYPE_ID = A.CHANGE_TYPE_ID
803: AND C.TYPE_CLASSIFICATION = 'CATEGORY'
804: AND C.CHANGE_MGMT_TYPE_CODE = X_BASE_CHANGE_MGMT_TYPE_CODE;

Line 817: -- Copying the entries for ENG_CHANGE_TYPE_APPLICATIONS

813: AND CHANGE_MGMT_TYPE_CODE = X_BASE_CHANGE_MGMT_TYPE_CODE;
814:
815: BEGIN
816:
817: -- Copying the entries for ENG_CHANGE_TYPE_APPLICATIONS
818: FOR appl IN get_applications
819: LOOP
820: INSERT INTO ENG_CHANGE_TYPE_APPLICATIONS
821: (CHANGE_TYPE_ID,

Line 820: INSERT INTO ENG_CHANGE_TYPE_APPLICATIONS

816:
817: -- Copying the entries for ENG_CHANGE_TYPE_APPLICATIONS
818: FOR appl IN get_applications
819: LOOP
820: INSERT INTO ENG_CHANGE_TYPE_APPLICATIONS
821: (CHANGE_TYPE_ID,
822: APPLICATION_ID,
823: CREATION_DATE,
824: CREATED_BY,