APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_LIFECYCLE_STATUSES

Line 32: cursor C is select ROWID from ENG_LIFECYCLE_STATUSES

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER)
31: IS
32: cursor C is select ROWID from ENG_LIFECYCLE_STATUSES
33: where CHANGE_LIFECYCLE_STATUS_ID = X_CHANGE_LIFECYCLE_STATUS_ID;
34: BEGIN
35: insert into ENG_LIFECYCLE_STATUSES (
36: CHANGE_WF_ROUTE_ID,

Line 35: insert into ENG_LIFECYCLE_STATUSES (

31: IS
32: cursor C is select ROWID from ENG_LIFECYCLE_STATUSES
33: where CHANGE_LIFECYCLE_STATUS_ID = X_CHANGE_LIFECYCLE_STATUS_ID;
34: BEGIN
35: insert into ENG_LIFECYCLE_STATUSES (
36: CHANGE_WF_ROUTE_ID,
37: AUTO_PROMOTE_STATUS,
38: AUTO_DEMOTE_STATUS,
39: WORKFLOW_STATUS,

Line 141: FROM ENG_LIFECYCLE_STATUSES

137: l_lifecycle_phase_id NUMBER;
138:
139: CURSOR lifecycles IS
140: SELECT *
141: FROM ENG_LIFECYCLE_STATUSES
142: WHERE ENTITY_NAME = 'ENG_CHANGE_TYPE'
143: AND ENTITY_ID1 = X_PARENT_CHANGE_TYPE_ID;
144: -- Bug 12617831 start
145: CURSOR typeroutes (l_CHANGE_LIFECYCLE_STATUS_ID in NUMBER) IS

Line 154: SELECT eng_lifecycle_statuses_s.nextval

150:
151: BEGIN
152: FOR cl in lifecycles
153: LOOP
154: SELECT eng_lifecycle_statuses_s.nextval
155: INTO l_lifecycle_phase_id
156: FROM dual;
157:
158: ENG_LC_STATUSES_INSERT (

Line 508: SELECT eng_lifecycle_statuses_s.nextval

504: LOOP
505: l_seq_no := l_seq_no +10;
506: l_route_id := null;
507:
508: SELECT eng_lifecycle_statuses_s.nextval
509: INTO l_lifecycle_phase_id
510: FROM dual;
511:
512: IF (phase_types(l_phase_id) = 8) -- approval status code