DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_TYPE_REASONS

Line 270: FROM ENG_CHANGE_TYPE_REASONS

266: l_reason_code VARCHAR2(10);
267:
268: CURSOR REASONS IS
269: SELECT *
270: FROM ENG_CHANGE_TYPE_REASONS
271: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
272: BEGIN
273: FOR cl in REASONS
274: LOOP

Line 275: INSERT INTO ENG_CHANGE_TYPE_REASONS

271: WHERE CHANGE_TYPE_ID = X_PARENT_CHANGE_TYPE_ID;
272: BEGIN
273: FOR cl in REASONS
274: LOOP
275: INSERT INTO ENG_CHANGE_TYPE_REASONS
276: (CHANGE_TYPE_ID,
277: REASON_CODE,
278: CREATION_DATE,
279: CREATED_BY,