APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_CHANGE_LINES

Line 1302: eng_change_lines line,

1298: SELECT DISTINCT route.route_id wf_route_id
1299: , line.change_line_id
1300: FROM eng_change_routes route,
1301: eng_change_statuses s,
1302: eng_change_lines line,
1303: eng_lifecycle_statuses line_start_after,
1304: eng_lifecycle_statuses new_status,
1305: eng_lifecycle_statuses cur_status
1306: WHERE route.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED

Line 2008: eng_change_lines l

2004: l.change_type_id ,
2005: route.status_code wf_status_code
2006: FROM eng_change_routes route,
2007: eng_change_statuses s,
2008: eng_change_lines l
2009: WHERE s.status_code = l.status_code
2010: AND route.route_id(+) = l.route_id
2011: AND l.change_id = p_change_id ;
2012:

Line 2014: l_status_code eng_change_lines.complete_before_status_code%TYPE;

2010: AND route.route_id(+) = l.route_id
2011: AND l.change_id = p_change_id ;
2012:
2013: l_line_status_type eng_change_statuses.status_type%TYPE;
2014: l_status_code eng_change_lines.complete_before_status_code%TYPE;
2015: l_required_flag eng_change_lines.required_flag%TYPE := NULL;
2016: l_change_type_id NUMBER ;
2017: l_wf_status_code eng_change_routes.status_code%TYPE;
2018:

Line 2015: l_required_flag eng_change_lines.required_flag%TYPE := NULL;

2011: AND l.change_id = p_change_id ;
2012:
2013: l_line_status_type eng_change_statuses.status_type%TYPE;
2014: l_status_code eng_change_lines.complete_before_status_code%TYPE;
2015: l_required_flag eng_change_lines.required_flag%TYPE := NULL;
2016: l_change_type_id NUMBER ;
2017: l_wf_status_code eng_change_routes.status_code%TYPE;
2018:
2019: -- Select all revised items

Line 2027: l_ri_status_code eng_change_lines.status_code%TYPE;

2023: WHERE change_id = p_change_id
2024: FOR UPDATE;
2025:
2026:
2027: l_ri_status_code eng_change_lines.status_code%TYPE;
2028: -- revItem's status_code's sequence_number
2029: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
2030:
2031: l_last_imp_flag VARCHAR2(1) := 'N';

Line 3200: l_ri_status_code eng_change_lines.status_code%TYPE;

3196: SELECT status_code
3197: FROM eng_revised_items
3198: WHERE change_id = p_change_id
3199: FOR UPDATE;
3200: l_ri_status_code eng_change_lines.status_code%TYPE;
3201: -- revItem's status_code's sequence_number
3202: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3203: l_ri_status_type eng_change_statuses.status_type%TYPE;
3204:

Line 3911: l_ri_status_code eng_change_lines.status_code%TYPE;

3907:
3908: l_last_imp_flag VARCHAR2(1) := 'N';
3909:
3910: l_new_status_type eng_change_statuses.status_type%TYPE;
3911: l_ri_status_code eng_change_lines.status_code%TYPE;
3912: l_ri_status_type eng_change_statuses.status_type%TYPE;
3913:
3914: l_chg_notice eng_engineering_changes.change_notice%TYPE;
3915: l_org_id eng_engineering_changes.organization_id%TYPE;

Line 4285: l_ri_status_code eng_change_lines.status_code%TYPE;

4281: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4282:
4283: l_new_status_type eng_change_statuses.status_type%TYPE;
4284:
4285: l_ri_status_code eng_change_lines.status_code%TYPE;
4286: -- revItem's status_code's sequence_number
4287: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4288: l_ri_status_type eng_change_statuses.status_type%TYPE;
4289:

Line 4993: FROM eng_change_lines l,

4989: l_nir_update_flag VARCHAR2(1) := 'F';
4990:
4991: CURSOR c_lines IS
4992: SELECT s.status_type
4993: FROM eng_change_lines l,
4994: eng_change_statuses s
4995: WHERE l.change_id = p_change_id
4996: AND s.status_code = l.status_code;
4997: l_line_status_type eng_change_statuses.status_type%TYPE;