DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_TYPE_APPLICATIONS

Line 763: FROM ENG_CHANGE_TYPE_APPLICATIONS A,

759: IS
760:
761: CURSOR get_applications IS
762: SELECT A.APPLICATION_ID
763: FROM ENG_CHANGE_TYPE_APPLICATIONS A,
764: ENG_CHANGE_ORDER_TYPES C
765: WHERE C.CHANGE_ORDER_TYPE_ID = A.CHANGE_TYPE_ID
766: AND C.TYPE_CLASSIFICATION = 'CATEGORY'
767: AND C.CHANGE_MGMT_TYPE_CODE = X_BASE_CHANGE_MGMT_TYPE_CODE;

Line 780: -- Copying the entries for ENG_CHANGE_TYPE_APPLICATIONS

776: AND CHANGE_MGMT_TYPE_CODE = X_BASE_CHANGE_MGMT_TYPE_CODE;
777:
778: BEGIN
779:
780: -- Copying the entries for ENG_CHANGE_TYPE_APPLICATIONS
781: FOR appl IN get_applications
782: LOOP
783: INSERT INTO ENG_CHANGE_TYPE_APPLICATIONS
784: (CHANGE_TYPE_ID,

Line 783: INSERT INTO ENG_CHANGE_TYPE_APPLICATIONS

779:
780: -- Copying the entries for ENG_CHANGE_TYPE_APPLICATIONS
781: FOR appl IN get_applications
782: LOOP
783: INSERT INTO ENG_CHANGE_TYPE_APPLICATIONS
784: (CHANGE_TYPE_ID,
785: APPLICATION_ID,
786: CREATION_DATE,
787: CREATED_BY,