[Home] [Help]
225: login => p_fnd_user_id
226: );
227:
228: -- We need to set the status of the NIR Manually. Even in the UI flow it is set manually.
229: UPDATE ENG_ENGINEERING_CHANGES
230: SET STATUS_TYPE = 5, STATUS_CODE = 5, CANCELLATION_DATE = sysdate, CANCELLATION_COMMENTS = p_cancel_comments
231: WHERE CHANGE_ID = p_change_id;
232:
233: x_nir_cancel_status := 'TRUE';
278: l_uncancelled_change_id NUMBER;
279: CURSOR c_nirs_for_this_item IS
280: SELECT A.CHANGE_ID, B.CHANGE_NOTICE
281: FROM ENG_CHANGE_SUBJECTS A,
282: ENG_ENGINEERING_CHANGES B,
283: ENG_CHANGE_LINES LINES
284: WHERE A.PK1_VALUE = p_item_id
285: AND A.PK2_VALUE = p_org_id
286: AND A.ENTITY_NAME = 'EGO_ITEM'
677: )
678: IS
679: l_change_line_id NUMBER;
680: l_lines_count NUMBER;
681: l_change_notice ENG_ENGINEERING_CHANGES.CHANGE_NOTICE%TYPE;
682: l_return_status VARCHAR2(1);
683: l_msg_count NUMBER ;
684: l_msg_data VARCHAR2(200);
685: l_action_id eng_change_actions.action_id%TYPE;
682: l_return_status VARCHAR2(1);
683: l_msg_count NUMBER ;
684: l_msg_data VARCHAR2(200);
685: l_action_id eng_change_actions.action_id%TYPE;
686: l_change_status_code eng_engineering_changes.status_code%TYPE;
687: BEGIN
688: -- First check whether the change(NIR) is in Draft status. If so the remove the line and subjects
689: SELECT status_code INTO l_change_status_code FROM eng_engineering_changes WHERE change_id = p_change_id;
690:
685: l_action_id eng_change_actions.action_id%TYPE;
686: l_change_status_code eng_engineering_changes.status_code%TYPE;
687: BEGIN
688: -- First check whether the change(NIR) is in Draft status. If so the remove the line and subjects
689: SELECT status_code INTO l_change_status_code FROM eng_engineering_changes WHERE change_id = p_change_id;
690:
691: IF l_change_status_code = 0 THEN -- If Draft then
692: -- Delete the line and subject in the NIR since it is in draft
693: SELECT change_line_id INTO l_change_line_id FROM eng_change_subjects