[Home] [Help]
231: l_priority_code VARCHAR2(10);
232:
233: CURSOR priorities IS
234: SELECT *
235: FROM ENG_CHANGE_TYPE_PRIORITIES
236: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
237: BEGIN
238: FOR cl in priorities
239: LOOP
236: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
237: BEGIN
238: FOR cl in priorities
239: LOOP
240: INSERT INTO ENG_CHANGE_TYPE_PRIORITIES
241: (CHANGE_TYPE_ID,
242: PRIORITY_CODE,
243: CREATION_DATE,
244: CREATED_BY,