[Home] [Help]
194: l_priority_code VARCHAR2(10);
195:
196: CURSOR priorities IS
197: SELECT *
198: FROM ENG_CHANGE_TYPE_PRIORITIES
199: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
200: BEGIN
201: FOR cl in priorities
202: LOOP
199: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
200: BEGIN
201: FOR cl in priorities
202: LOOP
203: INSERT INTO ENG_CHANGE_TYPE_PRIORITIES
204: (CHANGE_TYPE_ID,
205: PRIORITY_CODE,
206: CREATION_DATE,
207: CREATED_BY,