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_SUBJECTS

Line 37: from eng_change_subjects sub ,

33: Select sub.pk1_value,
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

Line 51: from eng_change_subjects sub ,

47: sub.pk2_value
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)

Line 127: l_inventory_item_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK1_VALUE

123: l_msg_data VARCHAR2(200);
124: l_action_id eng_change_actions.action_id%TYPE;
125: l_chk_fn_ret_val VARCHAR2(10);
126: l_party_id NUMBER;
127: l_inventory_item_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK1_VALUE
128: l_organization_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK2_VALUE
129:
130: BEGIN
131:

Line 128: l_organization_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK2_VALUE

124: l_action_id eng_change_actions.action_id%TYPE;
125: l_chk_fn_ret_val VARCHAR2(10);
126: l_party_id NUMBER;
127: l_inventory_item_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK1_VALUE
128: l_organization_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK2_VALUE
129:
130: BEGIN
131:
132: x_nir_cancel_status := 'TRUE';

Line 154: FROM ENG_CHANGE_SUBJECTS

150: -- If the User does not have direct roles for Editing this NIR, We have to check for Inherited roles.
151: IF NOT 'T' = l_chk_fn_ret_val THEN
152: -- Get the Inventory Item Id and Organization Id of the Item
153: SELECT PK1_VALUE, PK2_VALUE INTO l_inventory_item_id, l_organization_id
154: FROM ENG_CHANGE_SUBJECTS
155: WHERE ENTITY_NAME = 'EGO_ITEM' AND CHANGE_ID = p_change_id;
156:
157: l_chk_fn_ret_val := EGO_DATA_SECURITY.check_inherited_function
158: (

Line 281: FROM ENG_CHANGE_SUBJECTS A,

277: IS
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

Line 693: SELECT change_line_id INTO l_change_line_id FROM eng_change_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
694: WHERE change_id = p_change_id
695: AND pk1_value = p_item_id
696: AND pk2_value = p_org_id
697: AND entity_name = 'EGO_ITEM';

Line 699: DELETE FROM eng_change_subjects WHERE change_id = p_change_id ;

695: AND pk1_value = p_item_id
696: AND pk2_value = p_org_id
697: AND entity_name = 'EGO_ITEM';
698:
699: DELETE FROM eng_change_subjects WHERE change_id = p_change_id ;
700: -- AND pk1_value = p_item_id
701: -- AND pk2_value = p_org_id
702: -- AND entity_name = 'EGO_ITEM';
703:

Line 708: SELECT change_line_id INTO l_change_line_id FROM eng_change_subjects

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
710: AND pk1_value = p_item_id
711: AND pk2_value = p_org_id
712: AND entity_name = 'EGO_ITEM';

Line 783: FROM eng_change_subjects

779: LOOP
780: /* get item_id and organization_id */
781: SELECT to_number(pk1_value), to_number(pk2_value)
782: INTO l_item_id, l_organization_id
783: FROM eng_change_subjects
784: WHERE change_line_id = p_change_line_id
785: AND entity_name='EGO_ITEM';
786: /* call API to update approval status on the Item to approved*/
787:

Line 845: SELECT change_line_id, pk1_value, pk2_value, pk3_value FROM ENG_CHANGE_SUBJECTS WHERE change_id = p_change_id

841: x_sfa_line_items_exists OUT NOCOPY VARCHAR2
842: )
843: IS
844: CURSOR cur_line_items_in_nir IS
845: SELECT change_line_id, pk1_value, pk2_value, pk3_value FROM ENG_CHANGE_SUBJECTS WHERE change_id = p_change_id
846: AND ENTITY_NAME='EGO_ITEM';
847:
848: l_ret_status VARCHAR2(10);
849: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;

Line 849: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;

845: SELECT change_line_id, pk1_value, pk2_value, pk3_value FROM ENG_CHANGE_SUBJECTS WHERE change_id = p_change_id
846: AND ENTITY_NAME='EGO_ITEM';
847:
848: l_ret_status VARCHAR2(10);
849: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
850: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
851: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
852: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
853: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;

Line 850: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;

846: AND ENTITY_NAME='EGO_ITEM';
847:
848: l_ret_status VARCHAR2(10);
849: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
850: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
851: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
852: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
853: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;
854: l_sfa_item VARCHAR2(1000);

Line 851: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;

847:
848: l_ret_status VARCHAR2(10);
849: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
850: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
851: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
852: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
853: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;
854: l_sfa_item VARCHAR2(1000);
855:

Line 852: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;

848: l_ret_status VARCHAR2(10);
849: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
850: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
851: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
852: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
853: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;
854: l_sfa_item VARCHAR2(1000);
855:
856: BEGIN