[Home] [Help]
1794: l_old_effectivity_date DATE;
1795: component_seq_id NUMBER;
1796: St_Number NUMBER;
1797:
1798: l_eco_status_name eng_change_statuses_vl.status_name%TYPE; -- bug 3571079
1799:
1800: -- Added for Bug-5725081
1801:
1802: v_component_quantity_to NUMBER ;
2150: -- Fetch the status corresponding to status_code =4 i.e 'Scheduled'
2151: BEGIN
2152: SELECT status_name
2153: INTO l_eco_status_name
2154: FROM eng_change_statuses_vl
2155: WHERE status_code = l_status_type;
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: l_eco_status_name := eco_rec.eco_status;
3974: WHERE els.entity_id1 = p_local_change_id
3975: AND els.entity_name = 'ENG_CHANGE'
3976: AND els.sequence_number =
3977: (SELECT min(sequence_number)
3978: FROM eng_lifecycle_statuses els1, eng_change_statuses_vl ecs1
3979: WHERE els1.entity_id1 = p_local_change_id
3980: AND els1.entity_name = 'ENG_CHANGE'
3981: AND els1.status_code = ecs1.status_code
3982: AND ((ecs1.status_type = 4 AND l_schedule_immediately = 'Y')
4005: );
4006:
4007: SELECT status_type
4008: INTO l_new_status_type
4009: FROM eng_change_statuses
4010: WHERE status_code = l_status_code
4011: AND rownum = 1;
4012: -- The following update should be moved to init lifecycle
4013: UPDATE eng_revised_items
4069: l_party_id NUMBER;
4070: l_party_type VARCHAR2(30);
4071: l_default_assignee_type eng_change_order_types.default_assignee_type%TYPE;
4072: l_assignee_role_id NUMBER;
4073: l_status_name eng_change_statuses_tl.status_name%TYPE;
4074: l_department_name VARCHAR2(240);
4075: l_change_type_id NUMBER;
4076: -- Variables for error handling
4077: l_msg_count NUMBER;
4367: END IF;
4368: -- Fetch status details
4369: SELECT ecs.status_name
4370: INTO l_status_name
4371: FROM eng_change_statuses_vl ecs
4372: WHERE ecs.status_code = 0;
4373:
4374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Status = ' || l_status_name);
4375: