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_NEW_ITEM_REQ_UTIL dependencies on ENG_CHANGE_ORDER_TYPES

Line 79: l_auto_number_method eng_change_order_types.AUTO_NUMBERING_METHOD%TYPE;

75: l_change_order_type_id number;
76: stat_name varchar2(80);
77:
78: l_type_id NUMBER;
79: l_auto_number_method eng_change_order_types.AUTO_NUMBERING_METHOD%TYPE;
80: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
81:
82: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;
83: l_hist_rec_row_id VARCHAR2(100);

Line 82: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;

78: l_type_id NUMBER;
79: l_auto_number_method eng_change_order_types.AUTO_NUMBERING_METHOD%TYPE;
80: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
81:
82: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;
83: l_hist_rec_row_id VARCHAR2(100);
84: l_change_mgmt_type_id eng_change_order_types_tl.change_order_type_id%TYPE;
85:
86: CURSOR c_change_type_detail(l_change_order_type_id IN NUMBER)

Line 84: l_change_mgmt_type_id eng_change_order_types_tl.change_order_type_id%TYPE;

80: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
81:
82: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;
83: l_hist_rec_row_id VARCHAR2(100);
84: l_change_mgmt_type_id eng_change_order_types_tl.change_order_type_id%TYPE;
85:
86: CURSOR c_change_type_detail(l_change_order_type_id IN NUMBER)
87: IS
88: SELECT ecotv1.change_order_type_id change_mgmt_type_id,

Line 92: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2

88: SELECT ecotv1.change_order_type_id change_mgmt_type_id,
89: ecotv2.change_order_type_id,
90: ecotv2.auto_numbering_method,
91: ecotv1.auto_numbering_method change_mgmt_method
92: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2
93: WHERE ecotv1.change_order_type_id = l_change_order_type_id
94: AND ecotv1.TYPE_CLASSIFICATION= 'CATEGORY'
95: AND ecotv1.change_mgmt_type_code = ecotv2.change_mgmt_type_code
96: AND ecotv2.type_name = change_type_code

Line 110: CURSOR c_first_status (cp_change_mgmt_type_id IN eng_change_order_types_tl.change_order_type_id%TYPE)

106: WHERE eng_change.change_notice = p_change_notice
107: AND eng_change.organization_id = org_param.organization_id
108: AND org_param.organization_code = p_org_code;
109:
110: CURSOR c_first_status (cp_change_mgmt_type_id IN eng_change_order_types_tl.change_order_type_id%TYPE)
111: IS
112: SELECT a.status_name INTO stat_name
113: FROM eng_change_statuses_vl a, eng_lifecycle_statuses b
114: WHERE a.status_code = b.status_code

Line 133: select change_order_type_id into l_change_mgmt_type_id from eng_change_order_types_tl where type_name = change_type_code and language = userenv('LANG');

129: -- Bug : 5140579 Removed the hardcoding and getting following values from database. Priority need not be hardcoded.
130: -- select status_name into stat_name FROM ENG_CHANGE_STATUSES_VL where status_code=1; -- 1 = Open
131:
132: -- Bug : 5282713 We need to get the first status of this change type.
133: select change_order_type_id into l_change_mgmt_type_id from eng_change_order_types_tl where type_name = change_type_code and language = userenv('LANG');
134: -- Get the first phase
135:
136: OPEN c_first_status(l_change_mgmt_type_id);
137: LOOP

Line 154: FROM ENG_CHANGE_ORDER_TYPES_VL

150:
151:
152: select change_order_type, change_order_type_id
153: into change_mgmt_type_name, l_change_order_type_id
154: FROM ENG_CHANGE_ORDER_TYPES_VL
155: WHERE change_mgmt_type_code='NEW_ITEM_REQUEST'
156: AND type_classification='CATEGORY';
157:
158: l_eco_rec.change_management_type := change_mgmt_type_name;

Line 324: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'

320: sysdate creation_date,
321: FND_GLOBAL.USER_ID last_updated_by,
322: sysdate last_update_date,
323: FND_GLOBAL.USER_ID last_update_login,
324: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
325: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) change_type_id,
326: 1 status_code,
327: 1 APPROVAL_STATUS_TYPE
328: from mtl_system_items_interface msii

Line 347: ENG_CHANGE_ORDER_TYPES_VL eng_types,

343: l_change_type_array,
344: l_org_array
345: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
346: MTL_ITEM_CATALOG_GROUPS_VL micg,
347: ENG_CHANGE_ORDER_TYPES_VL eng_types,
348: MTL_PARAMETERS mp
349: WHERE msii.set_process_id=P_BATCH_ID
350: AND PROCESS_FLAG = l_process_flag
351: AND msii.ITEM_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID

Line 383: ENG_CHANGE_ORDER_TYPES_VL eng_types,

379: BULK COLLECT INTO l_icc_array ,
380: l_change_type_array,
381: l_org_array
382: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
383: ENG_CHANGE_ORDER_TYPES_VL eng_types,
384: MTL_PARAMETERS mp,
385: ego_item_cat_denorm_hier heir,
386: mtl_item_catalog_groups_b micgb
387: WHERE msii.set_process_id = P_BATCH_ID

Line 578: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'

574: FND_GLOBAL.USER_ID,
575: sysdate,
576: FND_GLOBAL.USER_ID,
577: 10,
578: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
579: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) TYPE_ID,
580: 1 ,
581: 1
582: from mtl_system_items_interface msii