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 8052: UPDATE eng_lifecycle_statuses

8048: IF (l_implement_header = 'T')
8049: THEN
8050: -- setting the end-date to the current phase if null
8051: -- added for bug 3482152
8052: UPDATE eng_lifecycle_statuses
8053: SET completion_date = sysdate,
8054: last_update_date = sysdate,
8055: last_updated_by = userid,
8056: last_update_login = loginid

Line 8085: UPDATE eng_lifecycle_statuses

8081: where organization_id = item.organization_id
8082: and change_notice = item.change_notice;
8083:
8084: -- Complete the last phase in the lifecycle
8085: UPDATE eng_lifecycle_statuses
8086: SET start_date = nvl(start_date,sysdate), -- set the start date on implemented phase after promoting the header to implemented phase
8087: -- added for bug 3482152
8088: completion_date = sysdate,
8089: last_update_date = sysdate,

Line 8100: FROM eng_lifecycle_statuses

8096: AND change_notice = item.change_notice
8097: )
8098: AND active_flag = 'Y'
8099: AND sequence_number = (SELECT max(sequence_number)
8100: FROM eng_lifecycle_statuses
8101: WHERE entity_name = 'ENG_CHANGE'
8102: AND entity_id1 = (SELECT change_id
8103: FROM eng_engineering_changes
8104: WHERE organization_id = item.organization_id

Line 8212: FROM eng_lifecycle_statuses

8208: -- Bug: 3479509
8209: -- Starting the workflow associated to implemented status
8210: SELECT change_wf_route_id
8211: INTO l_wf_route_id
8212: FROM eng_lifecycle_statuses
8213: WHERE entity_name = 'ENG_CHANGE'
8214: AND entity_id1 = item.change_id
8215: AND status_code = p_status_code
8216: AND active_flag = 'Y'

Line 9239: FROM eng_lifecycle_statuses els1

9235: -- All scheduled revised items will be picked for implementation on auto-implement
9236:
9237: SELECT els1.status_code
9238: INTO l_status_code
9239: FROM eng_lifecycle_statuses els1
9240: WHERE els1.entity_id1 = l_change_id
9241: AND els1.entity_name = 'ENG_CHANGE'
9242: AND els1.active_flag = 'Y' -- added for bug 3553682
9243: AND els1.sequence_number = (SELECT max(els2.sequence_number)

Line 9244: FROM eng_lifecycle_statuses els2

9240: WHERE els1.entity_id1 = l_change_id
9241: AND els1.entity_name = 'ENG_CHANGE'
9242: AND els1.active_flag = 'Y' -- added for bug 3553682
9243: AND els1.sequence_number = (SELECT max(els2.sequence_number)
9244: FROM eng_lifecycle_statuses els2
9245: WHERE els2.entity_id1 = l_change_id
9246: AND els2.entity_name = 'ENG_CHANGE'
9247: AND els2.active_flag = 'Y'); -- added for bug 3553682
9248:

Line 9497: eng_lifecycle_statuses

9493:
9494: -- Complete the last phase in the lifecycle
9495:
9496: UPDATE
9497: eng_lifecycle_statuses
9498: SET start_date = nvl(start_date,sysdate), -- set the start date on implemented phase after promoting the header to implemented phase
9499: completion_date = sysdate,
9500: last_update_date = sysdate,
9501: last_updated_by = fnd_global.user_id,

Line 9517: FROM eng_lifecycle_statuses

9513: AND sequence_number =
9514: (
9515: SELECT
9516: max(sequence_number)
9517: FROM eng_lifecycle_statuses
9518: WHERE entity_name = 'ENG_CHANGE'
9519: AND entity_id1 =
9520: (
9521: SELECT