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 FND_GLOBAL

Line 264: X_CREATED_BY => FND_GLOBAL.user_id,

260: X_ROWID => l_hist_rec_row_id,
261: X_BATCH_ID => batch_id,
262: X_CHANGE_ID => x_change_id,
263: X_CREATION_DATE => SYSDATE,
264: X_CREATED_BY => FND_GLOBAL.user_id,
265: X_LAST_UPDATE_DATE => SYSDATE,
266: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
267: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
268: ) ;

Line 266: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

262: X_CHANGE_ID => x_change_id,
263: X_CREATION_DATE => SYSDATE,
264: X_CREATED_BY => FND_GLOBAL.user_id,
265: X_LAST_UPDATE_DATE => SYSDATE,
266: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
267: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
268: ) ;
269: END IF ;
270:

Line 267: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

263: X_CREATION_DATE => SYSDATE,
264: X_CREATED_BY => FND_GLOBAL.user_id,
265: X_LAST_UPDATE_DATE => SYSDATE,
266: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
267: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
268: ) ;
269: END IF ;
270:
271: END IF ;

Line 336: FND_GLOBAL.USER_ID created_by,

332: CURSOR cur_change_lines IS
333: select
334: change_line_id,
335: change_id,
336: FND_GLOBAL.USER_ID created_by,
337: sysdate creation_date,
338: FND_GLOBAL.USER_ID last_updated_by,
339: sysdate last_update_date,
340: FND_GLOBAL.USER_ID last_update_login,

Line 338: FND_GLOBAL.USER_ID last_updated_by,

334: change_line_id,
335: change_id,
336: FND_GLOBAL.USER_ID created_by,
337: sysdate creation_date,
338: FND_GLOBAL.USER_ID last_updated_by,
339: sysdate last_update_date,
340: FND_GLOBAL.USER_ID last_update_login,
341: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
342: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) change_type_id,

Line 340: FND_GLOBAL.USER_ID last_update_login,

336: FND_GLOBAL.USER_ID created_by,
337: sysdate creation_date,
338: FND_GLOBAL.USER_ID last_updated_by,
339: sysdate last_update_date,
340: FND_GLOBAL.USER_ID last_update_login,
341: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
342: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) change_type_id,
343: 1 status_code,
344: 1 APPROVAL_STATUS_TYPE

Line 443: --select party_name into l_req_name from ego_user_v where user_name = FND_GLOBAL.USER_NAME;

439:
440:
441:
442: -- Bug 10412328, change the l_req_name initialization part from party_name to user_name
443: --select party_name into l_req_name from ego_user_v where user_name = FND_GLOBAL.USER_NAME;
444: l_req_name := FND_GLOBAL.USER_NAME;
445:
446: if P_NIR_OPTION = G_NIR_ICC_OPTION
447: then

Line 444: l_req_name := FND_GLOBAL.USER_NAME;

440:
441:
442: -- Bug 10412328, change the l_req_name initialization part from party_name to user_name
443: --select party_name into l_req_name from ego_user_v where user_name = FND_GLOBAL.USER_NAME;
444: l_req_name := FND_GLOBAL.USER_NAME;
445:
446: if P_NIR_OPTION = G_NIR_ICC_OPTION
447: then
448: l_change_ids_array := NIR_CHANGE_TABLE();

Line 496: FND_GLOBAL.USER_ID,

492: for trans_i in l_transaction_array.FIRST .. l_transaction_array.LAST
493: LOOP
494: dumm_status := INVPUOPI.mtl_log_interface_err(
495: l_org_array(i), -- Row specific
496: FND_GLOBAL.USER_ID,
497: FND_GLOBAL.LOGIN_ID,
498: FND_GLOBAL.PROG_APPL_ID,
499: FND_GLOBAL.CONC_PROGRAM_ID,
500: FND_GLOBAL.CONC_REQUEST_ID

Line 497: FND_GLOBAL.LOGIN_ID,

493: LOOP
494: dumm_status := INVPUOPI.mtl_log_interface_err(
495: l_org_array(i), -- Row specific
496: FND_GLOBAL.USER_ID,
497: FND_GLOBAL.LOGIN_ID,
498: FND_GLOBAL.PROG_APPL_ID,
499: FND_GLOBAL.CONC_PROGRAM_ID,
500: FND_GLOBAL.CONC_REQUEST_ID
501: ,l_transaction_array(i) -- Row specific

Line 498: FND_GLOBAL.PROG_APPL_ID,

494: dumm_status := INVPUOPI.mtl_log_interface_err(
495: l_org_array(i), -- Row specific
496: FND_GLOBAL.USER_ID,
497: FND_GLOBAL.LOGIN_ID,
498: FND_GLOBAL.PROG_APPL_ID,
499: FND_GLOBAL.CONC_PROGRAM_ID,
500: FND_GLOBAL.CONC_REQUEST_ID
501: ,l_transaction_array(i) -- Row specific
502: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it

Line 499: FND_GLOBAL.CONC_PROGRAM_ID,

495: l_org_array(i), -- Row specific
496: FND_GLOBAL.USER_ID,
497: FND_GLOBAL.LOGIN_ID,
498: FND_GLOBAL.PROG_APPL_ID,
499: FND_GLOBAL.CONC_PROGRAM_ID,
500: FND_GLOBAL.CONC_REQUEST_ID
501: ,l_transaction_array(i) -- Row specific
502: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
503: ,'ITEM_NUMBER' -- Column Name on which error occured

Line 500: FND_GLOBAL.CONC_REQUEST_ID

496: FND_GLOBAL.USER_ID,
497: FND_GLOBAL.LOGIN_ID,
498: FND_GLOBAL.PROG_APPL_ID,
499: FND_GLOBAL.CONC_PROGRAM_ID,
500: FND_GLOBAL.CONC_REQUEST_ID
501: ,l_transaction_array(i) -- Row specific
502: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
503: ,'ITEM_NUMBER' -- Column Name on which error occured
504: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 571: FND_GLOBAL.USER_ID,

567: if l_return_status = 'G'
568: then
569: dumm_status := INVPUOPI.mtl_log_interface_err(
570: l_org_array(i), -- Row specific
571: FND_GLOBAL.USER_ID,
572: FND_GLOBAL.LOGIN_ID,
573: FND_GLOBAL.PROG_APPL_ID,
574: FND_GLOBAL.CONC_PROGRAM_ID,
575: FND_GLOBAL.CONC_REQUEST_ID

Line 572: FND_GLOBAL.LOGIN_ID,

568: then
569: dumm_status := INVPUOPI.mtl_log_interface_err(
570: l_org_array(i), -- Row specific
571: FND_GLOBAL.USER_ID,
572: FND_GLOBAL.LOGIN_ID,
573: FND_GLOBAL.PROG_APPL_ID,
574: FND_GLOBAL.CONC_PROGRAM_ID,
575: FND_GLOBAL.CONC_REQUEST_ID
576: ,l_transaction_array(i) -- Row specific

Line 573: FND_GLOBAL.PROG_APPL_ID,

569: dumm_status := INVPUOPI.mtl_log_interface_err(
570: l_org_array(i), -- Row specific
571: FND_GLOBAL.USER_ID,
572: FND_GLOBAL.LOGIN_ID,
573: FND_GLOBAL.PROG_APPL_ID,
574: FND_GLOBAL.CONC_PROGRAM_ID,
575: FND_GLOBAL.CONC_REQUEST_ID
576: ,l_transaction_array(i) -- Row specific
577: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it

Line 574: FND_GLOBAL.CONC_PROGRAM_ID,

570: l_org_array(i), -- Row specific
571: FND_GLOBAL.USER_ID,
572: FND_GLOBAL.LOGIN_ID,
573: FND_GLOBAL.PROG_APPL_ID,
574: FND_GLOBAL.CONC_PROGRAM_ID,
575: FND_GLOBAL.CONC_REQUEST_ID
576: ,l_transaction_array(i) -- Row specific
577: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
578: ,'ITEM_NUMBER' -- Column Name on which error occured

Line 575: FND_GLOBAL.CONC_REQUEST_ID

571: FND_GLOBAL.USER_ID,
572: FND_GLOBAL.LOGIN_ID,
573: FND_GLOBAL.PROG_APPL_ID,
574: FND_GLOBAL.CONC_PROGRAM_ID,
575: FND_GLOBAL.CONC_REQUEST_ID
576: ,l_transaction_array(i) -- Row specific
577: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
578: ,'ITEM_NUMBER' -- Column Name on which error occured
579: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 630: FND_GLOBAL.USER_ID,

626: (
627: select
628: msii.change_line_id,
629: msii.change_id,
630: FND_GLOBAL.USER_ID,
631: sysdate,
632: FND_GLOBAL.USER_ID,
633: sysdate,
634: FND_GLOBAL.USER_ID,

Line 632: FND_GLOBAL.USER_ID,

628: msii.change_line_id,
629: msii.change_id,
630: FND_GLOBAL.USER_ID,
631: sysdate,
632: FND_GLOBAL.USER_ID,
633: sysdate,
634: FND_GLOBAL.USER_ID,
635: 10,
636: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'

Line 634: FND_GLOBAL.USER_ID,

630: FND_GLOBAL.USER_ID,
631: sysdate,
632: FND_GLOBAL.USER_ID,
633: sysdate,
634: FND_GLOBAL.USER_ID,
635: 10,
636: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
637: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) TYPE_ID,
638: 1 ,

Line 693: FND_GLOBAL.USER_ID,

689: )
690: (
691: select
692: msii.change_line_id,
693: FND_GLOBAL.USER_ID,
694: sysdate,
695: FND_GLOBAL.USER_ID,
696: sysdate,
697: FND_GLOBAL.USER_ID,

Line 695: FND_GLOBAL.USER_ID,

691: select
692: msii.change_line_id,
693: FND_GLOBAL.USER_ID,
694: sysdate,
695: FND_GLOBAL.USER_ID,
696: sysdate,
697: FND_GLOBAL.USER_ID,
698: LANGS.LANGUAGE_CODE,
699: USERENV('LANG'),

Line 697: FND_GLOBAL.USER_ID,

693: FND_GLOBAL.USER_ID,
694: sysdate,
695: FND_GLOBAL.USER_ID,
696: sysdate,
697: FND_GLOBAL.USER_ID,
698: LANGS.LANGUAGE_CODE,
699: USERENV('LANG'),
700: msii.change_line_id
701: from mtl_system_items_interface msii,

Line 746: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||

742: l_dynamic_sql := l_dynamic_sql || 'MSII.INVENTORY_ITEM_ID,MSII.ORGANIZATION_ID,MIRI.REVISION_ID ';
743: end if;
744: l_dynamic_sql := l_dynamic_sql ||
745: ' , ' || l_sub_desc_array(sub_count).SUBJECT_LEVEL ||
746: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||
747: ' , FND_GLOBAL.USER_ID, SYSDATE'||
748: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';
749:
750: if l_sub_desc_array(sub_count).ENTITY_NAME = 'EGO_ITEM_REVISION'

Line 747: ' , FND_GLOBAL.USER_ID, SYSDATE'||

743: end if;
744: l_dynamic_sql := l_dynamic_sql ||
745: ' , ' || l_sub_desc_array(sub_count).SUBJECT_LEVEL ||
746: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||
747: ' , FND_GLOBAL.USER_ID, SYSDATE'||
748: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';
749:
750: if l_sub_desc_array(sub_count).ENTITY_NAME = 'EGO_ITEM_REVISION'
751: then

Line 748: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';

744: l_dynamic_sql := l_dynamic_sql ||
745: ' , ' || l_sub_desc_array(sub_count).SUBJECT_LEVEL ||
746: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||
747: ' , FND_GLOBAL.USER_ID, SYSDATE'||
748: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';
749:
750: if l_sub_desc_array(sub_count).ENTITY_NAME = 'EGO_ITEM_REVISION'
751: then
752: l_dynamic_sql := l_dynamic_sql ||' ,MTL_ITEM_REVISIONS_INTERFACE MIRI '||