DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on ENG_LIFECYCLE_STATUSES

Line 13734: FROM eng_lifecycle_statuses

13730:
13731: /* Cursor to Fetch all the life cycle Statuses for corresponding Type. */
13732: CURSOR c_lifecycle_statuses IS
13733: SELECT *
13734: FROM eng_lifecycle_statuses
13735: WHERE entity_name = 'ENG_CHANGE_TYPE'
13736: AND entity_id1 = p_change_type_id;
13737:
13738: BEGIN

Line 13742: SELECT ENG_LIFECYCLE_STATUSES_S.NEXTVAL

13738: BEGIN
13739: FOR cls IN c_lifecycle_statuses
13740: LOOP
13741: -- fetch the CHANGE_LIFECYCLE_STATUS_ID from sequence
13742: SELECT ENG_LIFECYCLE_STATUSES_S.NEXTVAL
13743: INTO l_lifecycle_status_id
13744: FROM dual;
13745:
13746: -- Insert the Statuses data

Line 13747: INSERT INTO ENG_LIFECYCLE_STATUSES

13743: INTO l_lifecycle_status_id
13744: FROM dual;
13745:
13746: -- Insert the Statuses data
13747: INSERT INTO ENG_LIFECYCLE_STATUSES
13748: ( CHANGE_LIFECYCLE_STATUS_ID
13749: , ENTITY_NAME
13750: , ENTITY_ID1
13751: , ENTITY_ID2