DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on ENG_STATUS_PROPERTIES

Line 13875: INSERT INTO eng_status_properties(

13871: , cls.CHANGE_WF_ROUTE_ID -- cls.CHANGE_WF_ROUTE_TEMPLATE_ID
13872: );
13873:
13874: -- Inserting the status properties
13875: INSERT INTO eng_status_properties(
13876: CHANGE_LIFECYCLE_STATUS_ID
13877: , STATUS_CODE
13878: , PROMOTION_STATUS_FLAG
13879: , CREATION_DATE

Line 13886: FROM eng_status_properties

13882: , LAST_UPDATED_BY
13883: , LAST_UPDATE_LOGIN
13884: ) SELECT l_lifecycle_status_id, status_code, PROMOTION_STATUS_FLAG,
13885: sysdate, p_user_id, sysdate, p_user_id, p_login_id
13886: FROM eng_status_properties
13887: WHERE CHANGE_LIFECYCLE_STATUS_ID = cls.CHANGE_LIFECYCLE_STATUS_ID;
13888: END LOOP; -- End loop c_lifecycle_statuses
13889: EXCEPTION
13890: WHEN OTHERS THEN