[Home] [Help]
301: l_code_id NUMBER;
302:
303: CURSOR CLASSCODES IS
304: SELECT *
305: FROM ENG_CHANGE_TYPE_CLASS_CODES
306: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
307: BEGIN
308: FOR cl in CLASSCODES
309: LOOP
306: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
307: BEGIN
308: FOR cl in CLASSCODES
309: LOOP
310: INSERT INTO ENG_CHANGE_TYPE_CLASS_CODES
311: (CHANGE_TYPE_ID,
312: CLASSIFICATION_ID,
313: CREATION_DATE,
314: CREATED_BY,