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.

[Home] [Help]

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 131: l_inventory_item_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK1_VALUE

127: l_msg_data VARCHAR2(200);
128: l_action_id eng_change_actions.action_id%TYPE;
129: l_chk_fn_ret_val VARCHAR2(10);
130: l_party_id NUMBER;
131: l_inventory_item_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK1_VALUE
132: l_organization_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK2_VALUE
133:
134: BEGIN
135:

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

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

Line 158: FROM ENG_CHANGE_SUBJECTS

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

Line 285: FROM ENG_CHANGE_SUBJECTS A,

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

Line 697: SELECT change_line_id INTO l_change_line_id FROM eng_change_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
698: WHERE change_id = p_change_id
699: AND pk1_value = p_item_id
700: AND pk2_value = p_org_id
701: AND entity_name = 'EGO_ITEM';

Line 703: DELETE FROM eng_change_subjects WHERE change_id = p_change_id ;

699: AND pk1_value = p_item_id
700: AND pk2_value = p_org_id
701: AND entity_name = 'EGO_ITEM';
702:
703: DELETE FROM eng_change_subjects WHERE change_id = p_change_id ;
704: -- AND pk1_value = p_item_id
705: -- AND pk2_value = p_org_id
706: -- AND entity_name = 'EGO_ITEM';
707:

Line 712: SELECT change_line_id INTO l_change_line_id FROM eng_change_subjects

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
714: AND pk1_value = p_item_id
715: AND pk2_value = p_org_id
716: AND entity_name = 'EGO_ITEM';

Line 787: FROM eng_change_subjects

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

Line 843: select to_number(pk1_value) from eng_change_subjects where entity_name =

839: l_change_id number;
840: l_style_item_id NUMBER;
841: l_valid_ind boolean DEFAULT TRUE;
842: CURSOR c_line_item_cursor IS
843: select to_number(pk1_value) from eng_change_subjects where entity_name =
844: 'EGO_ITEM' and change_id = p_change_id;
845: BEGIN
846: OPEN c_line_item_cursor;
847: loop

Line 860: change_id in (SELECT change_id FROM eng_change_subjects WHERE entity_name =

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
864: l_valid_ind := false;

Line 891: from eng_change_subjects

887: */
888: FUNCTION checkSTYLENIRValidForDemote(p_change_id IN NUMBER) return varchar is
889: CURSOR c_line_item_cursor IS
890: select to_number(pk1_value) item_id
891: from eng_change_subjects
892: where entity_name = 'EGO_ITEM'
893: and change_id = p_change_id;
894: cursor c_sku_items(item_id varchar2) is
895: select distinct inventory_item_id

Line 918: FROM eng_change_subjects

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'
920: AND pk1_value = sku_items.inventory_item_id)
921: AND APPROVAL_STATUS_TYPE = 5;
922: if nums > 0 then

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

952: x_sfa_line_items_exists OUT NOCOPY VARCHAR2
953: )
954: IS
955: CURSOR cur_line_items_in_nir IS
956: SELECT change_line_id, pk1_value, pk2_value, pk3_value FROM ENG_CHANGE_SUBJECTS WHERE change_id = p_change_id
957: AND ENTITY_NAME='EGO_ITEM';
958:
959: l_ret_status VARCHAR2(10);
960: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;

Line 960: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;

956: SELECT change_line_id, pk1_value, pk2_value, pk3_value FROM ENG_CHANGE_SUBJECTS WHERE change_id = p_change_id
957: AND ENTITY_NAME='EGO_ITEM';
958:
959: l_ret_status VARCHAR2(10);
960: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
961: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
962: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
963: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
964: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;

Line 961: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;

957: AND ENTITY_NAME='EGO_ITEM';
958:
959: l_ret_status VARCHAR2(10);
960: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
961: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
962: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
963: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
964: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;
965: l_sfa_item VARCHAR2(1000);

Line 962: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;

958:
959: l_ret_status VARCHAR2(10);
960: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
961: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
962: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
963: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
964: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;
965: l_sfa_item VARCHAR2(1000);
966:

Line 963: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;

959: l_ret_status VARCHAR2(10);
960: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
961: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
962: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
963: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
964: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;
965: l_sfa_item VARCHAR2(1000);
966:
967: BEGIN