DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_TYPE_PRIORITIES

Line 198: FROM ENG_CHANGE_TYPE_PRIORITIES

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

Line 203: INSERT INTO ENG_CHANGE_TYPE_PRIORITIES

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,