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: BEGIN
145: FOR cl in lifecycles

Line 147: SELECT eng_lifecycle_statuses_s.nextval

143: AND ENTITY_ID1 = X_PARENT_CHANGE_TYPE_ID;
144: BEGIN
145: FOR cl in lifecycles
146: LOOP
147: SELECT eng_lifecycle_statuses_s.nextval
148: INTO l_lifecycle_phase_id
149: FROM dual;
150:
151: ENG_LC_STATUSES_INSERT (

Line 471: SELECT eng_lifecycle_statuses_s.nextval

467: LOOP
468: l_seq_no := l_seq_no +10;
469: l_route_id := null;
470:
471: SELECT eng_lifecycle_statuses_s.nextval
472: INTO l_lifecycle_phase_id
473: FROM dual;
474:
475: IF (phase_types(l_phase_id) = 8) -- approval status code