eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_NIR_UTIL_PKG dependencies on ENG_CHANGE_LINES

Line 38: eng_change_lines lines

34: sub.pk2_value
35: BULK COLLECT into l_items_array,
36: l_org_id_array
37: from eng_change_subjects sub ,
38: eng_change_lines lines
39: where lines.change_id = p_change_id
40: and lines.change_id = sub.change_id
41: and lines.change_line_id = sub.change_line_id
42: and lines.STATUS_CODE not in (G_ENG_NEW_ITEM_REJECTED, G_ENG_NEW_ITEM_CANCELLED)

Line 52: eng_change_lines lines

48: BULK COLLECT into l_items_array,
49: l_org_id_array
50: -- l_appr_statuses_array
51: from eng_change_subjects sub ,
52: eng_change_lines lines
53: where lines.change_id = p_change_id
54: and lines.change_id = sub.change_id
55: and lines.STATUS_CODE not in (5, 14)
56: and entity_name='EGO_ITEM';*/

Line 71: UPDATE eng_change_lines

67: --
68: IF l_items_array IS NOT NULL AND l_items_array.COUNT >0 THEN
69:
70: IF p_approval_status IN (4,8) THEN
71: UPDATE eng_change_lines
72: SET STATUS_CODE = G_ENG_NEW_ITEM_REJECTED
73: WHERE change_id = p_change_id
74: AND status_CODE not in(G_ENG_NEW_ITEM_REJECTED,G_ENG_NEW_ITEM_CANCELLED);
75: ELSIF p_approval_status = 3 THEN

Line 76: UPDATE eng_change_lines

72: SET STATUS_CODE = G_ENG_NEW_ITEM_REJECTED
73: WHERE change_id = p_change_id
74: AND status_CODE not in(G_ENG_NEW_ITEM_REJECTED,G_ENG_NEW_ITEM_CANCELLED);
75: ELSIF p_approval_status = 3 THEN
76: UPDATE eng_change_lines
77: SET STATUS_CODE = G_ENG_NEW_ITEM_SFA
78: WHERE change_id = p_change_id
79: AND status_CODE not in(G_ENG_NEW_ITEM_REJECTED,G_ENG_NEW_ITEM_CANCELLED);
80: ELSIF p_approval_status IN (5) THEN

Line 81: UPDATE eng_change_lines

77: SET STATUS_CODE = G_ENG_NEW_ITEM_SFA
78: WHERE change_id = p_change_id
79: AND status_CODE not in(G_ENG_NEW_ITEM_REJECTED,G_ENG_NEW_ITEM_CANCELLED);
80: ELSIF p_approval_status IN (5) THEN
81: UPDATE eng_change_lines
82: SET STATUS_CODE = G_ENG_NEW_ITEM_APPROVED
83: WHERE change_id = p_change_id
84: AND status_CODE not in(G_ENG_NEW_ITEM_REJECTED,G_ENG_NEW_ITEM_CANCELLED);
85:

Line 287: ENG_CHANGE_LINES LINES

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'
291: AND A.CHANGE_LINE_ID = LINES.CHANGE_LINE_ID

Line 364: from eng_change_lines where change_id = nirs.change_id

360: P_COMMIT => FND_API.G_FALSE,
361: x_return_status => x_nir_cancel_status
362: );
363: select count(change_id) into l_uncancelled_change_id
364: from eng_change_lines where change_id = nirs.change_id
365: and status_code <> 5;
366: if l_uncancelled_change_id = 0
367: then
368:

Line 708: DELETE FROM eng_change_lines WHERE change_id = p_change_id and change_line_id = l_change_line_id;

704: -- AND pk1_value = p_item_id
705: -- AND pk2_value = p_org_id
706: -- AND entity_name = 'EGO_ITEM';
707:
708: DELETE FROM eng_change_lines WHERE change_id = p_change_id and change_line_id = l_change_line_id;
709: DELETE FROM eng_change_lines_tl WHERE change_line_id = l_change_line_id;
710: ELSE
711: -- Query change line id
712: SELECT change_line_id INTO l_change_line_id FROM eng_change_subjects

Line 709: DELETE FROM eng_change_lines_tl WHERE change_line_id = l_change_line_id;

705: -- AND pk2_value = p_org_id
706: -- AND entity_name = 'EGO_ITEM';
707:
708: DELETE FROM eng_change_lines WHERE change_id = p_change_id and change_line_id = l_change_line_id;
709: DELETE FROM eng_change_lines_tl WHERE change_line_id = l_change_line_id;
710: ELSE
711: -- Query change line id
712: SELECT change_line_id INTO l_change_line_id FROM eng_change_subjects
713: WHERE change_id = p_change_id

Line 718: UPDATE ENG_CHANGE_LINES SET status_code = 5 -- Cancelled

714: AND pk1_value = p_item_id
715: AND pk2_value = p_org_id
716: AND entity_name = 'EGO_ITEM';
717: -- Set change line status to Cancelled
718: UPDATE ENG_CHANGE_LINES SET status_code = 5 -- Cancelled
719: WHERE change_id = p_change_id AND change_line_id = l_change_line_id;
720: -- Update the Action Log of the NIR.
721: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
722: (

Line 813: from eng_change_lines

809: l_change_line_id number;
810: BEGIN
811: select change_line_id
812: into l_change_line_id
813: from eng_change_lines
814: where change_id = p_change_id
815: and status_code in( 1,3)
816: and rownum=1;
817:

Line 984: UPDATE eng_change_lines SET STATUS_CODE = 1 WHERE change_line_id = l_change_line_id;

980: IF 'R' = l_item_approval_status THEN
981: -- Update Item Approval Status
982: Update_Item_Approval_Status(p_change_id, line_items.change_line_id, p_item_approval_status, l_ret_status);
983: -- Update Line Item Status
984: UPDATE eng_change_lines SET STATUS_CODE = 1 WHERE change_line_id = l_change_line_id;
985: ELSE
986: SELECT CONCATENATED_SEGMENTS INTO l_sfa_item
987: FROM MTL_SYSTEM_ITEMS_KFV
988: WHERE inventory_item_id = l_pk1_value