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;
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,
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,