DBA Data[Home] [Help]

APPS.ENG_VALIDATE_ECO dependencies on ENG_LIFECYCLE_STATUSES

Line 1208: FROM eng_lifecycle_statuses

1204: --11.5.10
1205:
1206: cursor GetValidStatusCodes(p_change_order_type_id NUMBER) IS
1207: SELECT status_code
1208: FROM eng_lifecycle_statuses
1209: where ENTITY_NAME='CHANGE_TYPE'
1210: and entity_id1 = p_change_order_type_id;
1211:
1212:

Line 2331: from eng_lifecycle_statuses

2327: AND organization_id = p_organization_id;
2328: --bug no 3591968 by Rashmi
2329: /*CURSOR c_CheckProcessInProgress(cp_change_id NUMBER,cp_status_code NUMBER) IS
2330: select status_code
2331: from eng_lifecycle_statuses
2332: where entity_id1 = cp_change_id
2333: and status_code =cp_status_code
2334: and entity_name ='ENG_CHANGE'
2335: and active_flag='Y'

Line 2343: from eng_lifecycle_statuses els, eng_change_statuses_vl ecs

2339: CURSOR c_lifecycle_status(cp_change_id NUMBER,cp_status_code NUMBER) IS
2340: select els.status_code, els.workflow_status, els.change_wf_route_id,
2341: ecs.status_type orig_status_type, els.CHANGE_EDITABLE_FLAG ,
2342: ecs.status_name
2343: from eng_lifecycle_statuses els, eng_change_statuses_vl ecs
2344: where els.ENTITY_NAME = 'ENG_CHANGE'
2345: and els.ENTITY_ID1 = cp_change_id
2346: and els.STATUS_CODE = cp_STATUS_CODE
2347: and els.active_flag = 'Y'