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 69: UPDATE eng_change_lines

65: l_org_id_array(i),
66: l_approval_status,
67: p_change_id);
68: IF p_approval_status IN (4,8) THEN
69: UPDATE eng_change_lines
70: SET STATUS_CODE = G_ENG_NEW_ITEM_REJECTED
71: WHERE change_id = p_change_id
72: AND status_CODE not in(G_ENG_NEW_ITEM_REJECTED,G_ENG_NEW_ITEM_CANCELLED);
73: ELSIF p_approval_status = 3 THEN

Line 74: UPDATE eng_change_lines

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

Line 79: UPDATE eng_change_lines

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

Line 283: ENG_CHANGE_LINES LINES

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

Line 360: from eng_change_lines where change_id = nirs.change_id

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

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

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

Line 705: DELETE FROM eng_change_lines_tl WHERE change_line_id = l_change_line_id;

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

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

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

Line 809: from eng_change_lines

805: l_change_line_id number;
806: BEGIN
807: select change_line_id
808: into l_change_line_id
809: from eng_change_lines
810: where change_id = p_change_id
811: and status_code in( 1,3)
812: and rownum=1;
813:

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

869: IF 'R' = l_item_approval_status THEN
870: -- Update Item Approval Status
871: Update_Item_Approval_Status(p_change_id, line_items.change_line_id, p_item_approval_status, l_ret_status);
872: -- Update Line Item Status
873: UPDATE eng_change_lines SET STATUS_CODE = 1 WHERE change_line_id = l_change_line_id;
874: ELSE
875: SELECT CONCATENATED_SEGMENTS INTO l_sfa_item
876: FROM MTL_SYSTEM_ITEMS_KFV
877: WHERE inventory_item_id = l_pk1_value