APPS.ENG_NIR_UTIL_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 233: UPDATE ENG_ENGINEERING_CHANGES

229: login => p_fnd_user_id
230: );
231:
232: -- We need to set the status of the NIR Manually. Even in the UI flow it is set manually.
233: UPDATE ENG_ENGINEERING_CHANGES
234: SET STATUS_TYPE = 5, STATUS_CODE = 5, CANCELLATION_DATE = sysdate, CANCELLATION_COMMENTS = p_cancel_comments
235: WHERE CHANGE_ID = p_change_id;
236:
237: x_nir_cancel_status := 'TRUE';

Line 286: ENG_ENGINEERING_CHANGES B,

282: l_uncancelled_change_id NUMBER;
283: CURSOR c_nirs_for_this_item IS
284: SELECT A.CHANGE_ID, B.CHANGE_NOTICE
285: FROM ENG_CHANGE_SUBJECTS A,
286: ENG_ENGINEERING_CHANGES B,
287: ENG_CHANGE_LINES LINES
288: WHERE A.PK1_VALUE = p_item_id
289: AND A.PK2_VALUE = p_org_id
290: AND A.ENTITY_NAME = 'EGO_ITEM'

Line 685: l_change_notice ENG_ENGINEERING_CHANGES.CHANGE_NOTICE%TYPE;

681: )
682: IS
683: l_change_line_id NUMBER;
684: l_lines_count NUMBER;
685: l_change_notice ENG_ENGINEERING_CHANGES.CHANGE_NOTICE%TYPE;
686: l_return_status VARCHAR2(1);
687: l_msg_count NUMBER ;
688: l_msg_data VARCHAR2(200);
689: l_action_id eng_change_actions.action_id%TYPE;

Line 690: l_change_status_code eng_engineering_changes.status_code%TYPE;

686: l_return_status VARCHAR2(1);
687: l_msg_count NUMBER ;
688: l_msg_data VARCHAR2(200);
689: l_action_id eng_change_actions.action_id%TYPE;
690: l_change_status_code eng_engineering_changes.status_code%TYPE;
691: BEGIN
692: -- First check whether the change(NIR) is in Draft status. If so the remove the line and subjects
693: SELECT status_code INTO l_change_status_code FROM eng_engineering_changes WHERE change_id = p_change_id;
694:

Line 693: SELECT status_code INTO l_change_status_code FROM eng_engineering_changes WHERE change_id = p_change_id;

689: l_action_id eng_change_actions.action_id%TYPE;
690: l_change_status_code eng_engineering_changes.status_code%TYPE;
691: BEGIN
692: -- First check whether the change(NIR) is in Draft status. If so the remove the line and subjects
693: SELECT status_code INTO l_change_status_code FROM eng_engineering_changes WHERE change_id = p_change_id;
694:
695: IF l_change_status_code = 0 THEN -- If Draft then
696: -- Delete the line and subject in the NIR since it is in draft
697: SELECT change_line_id INTO l_change_line_id FROM eng_change_subjects

Line 859: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE

855: END IF;
856:
857: --if it is a sku item
858: IF (l_sku_item_ind) THEN
859: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE
860: change_id in (SELECT change_id FROM eng_change_subjects WHERE entity_name =
861: 'EGO_ITEM' AND pk1_value = l_style_item_id) AND APPROVAL_STATUS_TYPE = 5 and
862: rownum = 1;
863: IF (l_change_id IS NULL) THEN

Line 899: l_change_id eng_engineering_changes.change_id%type;

895: select distinct inventory_item_id
896: from mtl_system_items_vl
897: where style_item_id = item_id;
898: style_flag mtl_system_items_vl.STYLE_ITEM_FLAG%type;
899: l_change_id eng_engineering_changes.change_id%type;
900: nums number;
901: BEGIN
902:
903: -- Bug 16786283 - r.tst1222: get error when demote change issue.

Line 915: FROM eng_engineering_changes

911: if style_flag = 'Y' then
912: for sku_items in c_sku_items(change_line.item_id) loop
913: SELECT count(1)
914: into nums
915: FROM eng_engineering_changes
916: WHERE change_id in
917: (SELECT change_id
918: FROM eng_change_subjects
919: WHERE entity_name = 'EGO_ITEM'