APPS.ENGPKIMP dependencies on ENG_LIFECYCLE_STATUSES

Line 162: FROM eng_lifecycle_statuses els

158: -- if current phase of the header is the second last phase of the lifecycle of the change
159: -- and if workflow is associated to the phase then , it is in completed or approved phase
160: CURSOR c_check_phase IS
161: SELECT 1
162: FROM eng_lifecycle_statuses els
163: WHERE els.entity_id1 = p_change_id
164: AND els.entity_name = 'ENG_CHANGE'
165: AND els.status_code = p_curr_status_code
166: AND els.active_flag = 'Y'

Line 169: FROM eng_lifecycle_statuses els_in

165: AND els.status_code = p_curr_status_code
166: AND els.active_flag = 'Y'
167: AND ( 1 = l_eco_impl_mode
168: OR ( 1 = ( SELECT count(*)
169: FROM eng_lifecycle_statuses els_in
170: WHERE els_in.entity_id1 = p_change_id
171: AND els_in.entity_name = 'ENG_CHANGE'
172: AND els_in.active_flag = 'Y'
173: AND els_in.sequence_number > els.sequence_number)

Line 7729: UPDATE eng_lifecycle_statuses

7725: IF (l_implement_header = 'T')
7726: THEN
7727: -- setting the end-date to the current phase if null
7728: -- added for bug 3482152
7729: UPDATE eng_lifecycle_statuses
7730: SET completion_date = sysdate,
7731: last_update_date = sysdate,
7732: last_updated_by = userid,
7733: last_update_login = loginid

Line 7762: UPDATE eng_lifecycle_statuses

7758: where organization_id = item.organization_id
7759: and change_notice = item.change_notice;
7760:
7761: -- Complete the last phase in the lifecycle
7762: UPDATE eng_lifecycle_statuses
7763: SET start_date = nvl(start_date,sysdate), -- set the start date on implemented phase after promoting the header to implemented phase
7764: -- added for bug 3482152
7765: completion_date = sysdate,
7766: last_update_date = sysdate,

Line 7777: FROM eng_lifecycle_statuses

7773: AND change_notice = item.change_notice
7774: )
7775: AND active_flag = 'Y'
7776: AND sequence_number = (SELECT max(sequence_number)
7777: FROM eng_lifecycle_statuses
7778: WHERE entity_name = 'ENG_CHANGE'
7779: AND entity_id1 = (SELECT change_id
7780: FROM eng_engineering_changes
7781: WHERE organization_id = item.organization_id

Line 7871: FROM eng_lifecycle_statuses

7867: -- Bug: 3479509
7868: -- Starting the workflow associated to implemented status
7869: SELECT change_wf_route_id
7870: INTO l_wf_route_id
7871: FROM eng_lifecycle_statuses
7872: WHERE entity_name = 'ENG_CHANGE'
7873: AND entity_id1 = item.change_id
7874: AND status_code = p_status_code
7875: AND active_flag = 'Y'

Line 8894: FROM eng_lifecycle_statuses els1

8890: -- All scheduled revised items will be picked for implementation on auto-implement
8891:
8892: SELECT els1.status_code
8893: INTO l_status_code
8894: FROM eng_lifecycle_statuses els1
8895: WHERE els1.entity_id1 = l_change_id
8896: AND els1.entity_name = 'ENG_CHANGE'
8897: AND els1.active_flag = 'Y' -- added for bug 3553682
8898: AND els1.sequence_number = (SELECT max(els2.sequence_number)

Line 8899: FROM eng_lifecycle_statuses els2

8895: WHERE els1.entity_id1 = l_change_id
8896: AND els1.entity_name = 'ENG_CHANGE'
8897: AND els1.active_flag = 'Y' -- added for bug 3553682
8898: AND els1.sequence_number = (SELECT max(els2.sequence_number)
8899: FROM eng_lifecycle_statuses els2
8900: WHERE els2.entity_id1 = l_change_id
8901: AND els2.entity_name = 'ENG_CHANGE'
8902: AND els2.active_flag = 'Y'); -- added for bug 3553682
8903:

Line 9152: eng_lifecycle_statuses

9148:
9149: -- Complete the last phase in the lifecycle
9150:
9151: UPDATE
9152: eng_lifecycle_statuses
9153: SET start_date = nvl(start_date,sysdate), -- set the start date on implemented phase after promoting the header to implemented phase
9154: completion_date = sysdate,
9155: last_update_date = sysdate,
9156: last_updated_by = fnd_global.user_id,

Line 9172: FROM eng_lifecycle_statuses

9168: AND sequence_number =
9169: (
9170: SELECT
9171: max(sequence_number)
9172: FROM eng_lifecycle_statuses
9173: WHERE entity_name = 'ENG_CHANGE'
9174: AND entity_id1 =
9175: (
9176: SELECT