DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_TYPE_REASONS

Line 233: FROM ENG_CHANGE_TYPE_REASONS

229: l_reason_code VARCHAR2(10);
230:
231: CURSOR REASONS IS
232: SELECT *
233: FROM ENG_CHANGE_TYPE_REASONS
234: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
235: BEGIN
236: FOR cl in REASONS
237: LOOP

Line 238: INSERT INTO ENG_CHANGE_TYPE_REASONS

234: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
235: BEGIN
236: FOR cl in REASONS
237: LOOP
238: INSERT INTO ENG_CHANGE_TYPE_REASONS
239: (CHANGE_TYPE_ID,
240: REASON_CODE,
241: CREATION_DATE,
242: CREATED_BY,