DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on ENG_STATUS_PROPERTIES

Line 13801: INSERT INTO eng_status_properties(

13797: , cls.CHANGE_WF_ROUTE_ID -- cls.CHANGE_WF_ROUTE_TEMPLATE_ID
13798: );
13799:
13800: -- Inserting the status properties
13801: INSERT INTO eng_status_properties(
13802: CHANGE_LIFECYCLE_STATUS_ID
13803: , STATUS_CODE
13804: , PROMOTION_STATUS_FLAG
13805: , CREATION_DATE

Line 13812: FROM eng_status_properties

13808: , LAST_UPDATED_BY
13809: , LAST_UPDATE_LOGIN
13810: ) SELECT l_lifecycle_status_id, status_code, PROMOTION_STATUS_FLAG,
13811: sysdate, p_user_id, sysdate, p_user_id, p_login_id
13812: FROM eng_status_properties
13813: WHERE CHANGE_LIFECYCLE_STATUS_ID = cls.CHANGE_LIFECYCLE_STATUS_ID;
13814: END LOOP; -- End loop c_lifecycle_statuses
13815: EXCEPTION
13816: WHEN OTHERS THEN