DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_STATUS_PROPERTIES

Line 104: FROM ENG_STATUS_PROPERTIES

100: X_LAST_UPDATE_LOGIN in NUMBER )
101: IS
102: CURSOR status_properties IS
103: SELECT *
104: FROM ENG_STATUS_PROPERTIES
105: WHERE CHANGE_LIFECYCLE_STATUS_ID = X_LIFECYCLE_PARENT_ID;
106: BEGIN
107: FOR sp in status_properties
108: LOOP

Line 109: INSERT INTO ENG_STATUS_PROPERTIES (

105: WHERE CHANGE_LIFECYCLE_STATUS_ID = X_LIFECYCLE_PARENT_ID;
106: BEGIN
107: FOR sp in status_properties
108: LOOP
109: INSERT INTO ENG_STATUS_PROPERTIES (
110: CHANGE_LIFECYCLE_STATUS_ID,
111: STATUS_CODE,
112: PROMOTION_STATUS_FLAG,
113: CREATION_DATE,