[Home] [Help]
1812: l_old_effectivity_date DATE;
1813: component_seq_id NUMBER;
1814: St_Number NUMBER;
1815:
1816: l_eco_status_name eng_change_statuses_vl.status_name%TYPE; -- bug 3571079
1817:
1818: -- Added for Bug-5725081
1819:
1820: v_component_quantity_to NUMBER ;
2169: -- Fetch the status corresponding to status_code =4 i.e 'Scheduled'
2170: BEGIN
2171: SELECT status_name
2172: INTO l_eco_status_name
2173: FROM eng_change_statuses_vl
2174: WHERE status_code = l_status_type;
2175: EXCEPTION
2176: WHEN OTHERS THEN
2177: l_eco_status_name := eco_rec.eco_status;
4099: WHERE els.entity_id1 = p_local_change_id
4100: AND els.entity_name = 'ENG_CHANGE'
4101: AND els.sequence_number =
4102: (SELECT min(sequence_number)
4103: FROM eng_lifecycle_statuses els1, eng_change_statuses_vl ecs1
4104: WHERE els1.entity_id1 = p_local_change_id
4105: AND els1.entity_name = 'ENG_CHANGE'
4106: AND els1.status_code = ecs1.status_code
4107: AND ((ecs1.status_type = 4 AND l_schedule_immediately = 'Y')
4130: );
4131:
4132: SELECT status_type
4133: INTO l_new_status_type
4134: FROM eng_change_statuses
4135: WHERE status_code = l_status_code
4136: AND rownum = 1;
4137: -- The following update should be moved to init lifecycle
4138: UPDATE eng_revised_items
4194: l_party_id NUMBER;
4195: l_party_type VARCHAR2(30);
4196: l_default_assignee_type eng_change_order_types.default_assignee_type%TYPE;
4197: l_assignee_role_id NUMBER;
4198: l_status_name eng_change_statuses_tl.status_name%TYPE;
4199: l_department_name VARCHAR2(240);
4200: l_change_type_id NUMBER;
4201: -- Variables for error handling
4202: l_msg_count NUMBER;
4492: END IF;
4493: -- Fetch status details
4494: SELECT ecs.status_name
4495: INTO l_status_name
4496: FROM eng_change_statuses_vl ecs
4497: WHERE ecs.status_code = 0;
4498:
4499: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Status = ' || l_status_name);
4500: