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 250: X_CREATED_BY => FND_GLOBAL.user_id,

246: X_ROWID => l_hist_rec_row_id,
247: X_BATCH_ID => batch_id,
248: X_CHANGE_ID => x_change_id,
249: X_CREATION_DATE => SYSDATE,
250: X_CREATED_BY => FND_GLOBAL.user_id,
251: X_LAST_UPDATE_DATE => SYSDATE,
252: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
253: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
254: ) ;

Line 252: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

248: X_CHANGE_ID => x_change_id,
249: X_CREATION_DATE => SYSDATE,
250: X_CREATED_BY => FND_GLOBAL.user_id,
251: X_LAST_UPDATE_DATE => SYSDATE,
252: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
253: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
254: ) ;
255: END IF ;
256:

Line 253: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

249: X_CREATION_DATE => SYSDATE,
250: X_CREATED_BY => FND_GLOBAL.user_id,
251: X_LAST_UPDATE_DATE => SYSDATE,
252: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
253: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
254: ) ;
255: END IF ;
256:
257: END IF ;

Line 319: FND_GLOBAL.USER_ID created_by,

315: CURSOR cur_change_lines IS
316: select
317: change_line_id,
318: change_id,
319: FND_GLOBAL.USER_ID created_by,
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,

Line 321: FND_GLOBAL.USER_ID last_updated_by,

317: change_line_id,
318: change_id,
319: FND_GLOBAL.USER_ID created_by,
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,

Line 323: FND_GLOBAL.USER_ID last_update_login,

319: FND_GLOBAL.USER_ID created_by,
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

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

392: micgb.item_catalog_group_id = heir.PARENT_CATALOG_GROUP_ID
393: ORDER BY organization_id;
394:
395:
396: select party_name into l_req_name from ego_user_v where user_name = FND_GLOBAL.USER_NAME;
397:
398: if P_NIR_OPTION = G_NIR_ICC_OPTION
399: then
400: l_change_ids_array := NIR_CHANGE_TABLE();

Line 445: FND_GLOBAL.USER_ID,

441: for trans_i in l_transaction_array.FIRST .. l_transaction_array.LAST
442: LOOP
443: dumm_status := INVPUOPI.mtl_log_interface_err(
444: l_org_array(i), -- Row specific
445: FND_GLOBAL.USER_ID,
446: FND_GLOBAL.LOGIN_ID,
447: FND_GLOBAL.PROG_APPL_ID,
448: FND_GLOBAL.CONC_PROGRAM_ID,
449: FND_GLOBAL.CONC_REQUEST_ID

Line 446: FND_GLOBAL.LOGIN_ID,

442: LOOP
443: dumm_status := INVPUOPI.mtl_log_interface_err(
444: l_org_array(i), -- Row specific
445: FND_GLOBAL.USER_ID,
446: FND_GLOBAL.LOGIN_ID,
447: FND_GLOBAL.PROG_APPL_ID,
448: FND_GLOBAL.CONC_PROGRAM_ID,
449: FND_GLOBAL.CONC_REQUEST_ID
450: ,l_transaction_array(i) -- Row specific

Line 447: FND_GLOBAL.PROG_APPL_ID,

443: dumm_status := INVPUOPI.mtl_log_interface_err(
444: l_org_array(i), -- Row specific
445: FND_GLOBAL.USER_ID,
446: FND_GLOBAL.LOGIN_ID,
447: FND_GLOBAL.PROG_APPL_ID,
448: FND_GLOBAL.CONC_PROGRAM_ID,
449: FND_GLOBAL.CONC_REQUEST_ID
450: ,l_transaction_array(i) -- Row specific
451: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it

Line 448: FND_GLOBAL.CONC_PROGRAM_ID,

444: l_org_array(i), -- Row specific
445: FND_GLOBAL.USER_ID,
446: FND_GLOBAL.LOGIN_ID,
447: FND_GLOBAL.PROG_APPL_ID,
448: FND_GLOBAL.CONC_PROGRAM_ID,
449: FND_GLOBAL.CONC_REQUEST_ID
450: ,l_transaction_array(i) -- Row specific
451: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
452: ,'ITEM_NUMBER' -- Column Name on which error occured

Line 449: FND_GLOBAL.CONC_REQUEST_ID

445: FND_GLOBAL.USER_ID,
446: FND_GLOBAL.LOGIN_ID,
447: FND_GLOBAL.PROG_APPL_ID,
448: FND_GLOBAL.CONC_PROGRAM_ID,
449: FND_GLOBAL.CONC_REQUEST_ID
450: ,l_transaction_array(i) -- Row specific
451: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
452: ,'ITEM_NUMBER' -- Column Name on which error occured
453: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 516: FND_GLOBAL.USER_ID,

512: if l_return_status = 'G'
513: then
514: dumm_status := INVPUOPI.mtl_log_interface_err(
515: l_org_array(i), -- Row specific
516: FND_GLOBAL.USER_ID,
517: FND_GLOBAL.LOGIN_ID,
518: FND_GLOBAL.PROG_APPL_ID,
519: FND_GLOBAL.CONC_PROGRAM_ID,
520: FND_GLOBAL.CONC_REQUEST_ID

Line 517: FND_GLOBAL.LOGIN_ID,

513: then
514: dumm_status := INVPUOPI.mtl_log_interface_err(
515: l_org_array(i), -- Row specific
516: FND_GLOBAL.USER_ID,
517: FND_GLOBAL.LOGIN_ID,
518: FND_GLOBAL.PROG_APPL_ID,
519: FND_GLOBAL.CONC_PROGRAM_ID,
520: FND_GLOBAL.CONC_REQUEST_ID
521: ,l_transaction_array(i) -- Row specific

Line 518: FND_GLOBAL.PROG_APPL_ID,

514: dumm_status := INVPUOPI.mtl_log_interface_err(
515: l_org_array(i), -- Row specific
516: FND_GLOBAL.USER_ID,
517: FND_GLOBAL.LOGIN_ID,
518: FND_GLOBAL.PROG_APPL_ID,
519: FND_GLOBAL.CONC_PROGRAM_ID,
520: FND_GLOBAL.CONC_REQUEST_ID
521: ,l_transaction_array(i) -- Row specific
522: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it

Line 519: FND_GLOBAL.CONC_PROGRAM_ID,

515: l_org_array(i), -- Row specific
516: FND_GLOBAL.USER_ID,
517: FND_GLOBAL.LOGIN_ID,
518: FND_GLOBAL.PROG_APPL_ID,
519: FND_GLOBAL.CONC_PROGRAM_ID,
520: FND_GLOBAL.CONC_REQUEST_ID
521: ,l_transaction_array(i) -- Row specific
522: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
523: ,'ITEM_NUMBER' -- Column Name on which error occured

Line 520: FND_GLOBAL.CONC_REQUEST_ID

516: FND_GLOBAL.USER_ID,
517: FND_GLOBAL.LOGIN_ID,
518: FND_GLOBAL.PROG_APPL_ID,
519: FND_GLOBAL.CONC_PROGRAM_ID,
520: FND_GLOBAL.CONC_REQUEST_ID
521: ,l_transaction_array(i) -- Row specific
522: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
523: ,'ITEM_NUMBER' -- Column Name on which error occured
524: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 572: FND_GLOBAL.USER_ID,

568: (
569: select
570: msii.change_line_id,
571: msii.change_id,
572: FND_GLOBAL.USER_ID,
573: sysdate,
574: FND_GLOBAL.USER_ID,
575: sysdate,
576: FND_GLOBAL.USER_ID,

Line 574: FND_GLOBAL.USER_ID,

570: msii.change_line_id,
571: msii.change_id,
572: FND_GLOBAL.USER_ID,
573: sysdate,
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'

Line 576: FND_GLOBAL.USER_ID,

572: FND_GLOBAL.USER_ID,
573: sysdate,
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 ,

Line 635: FND_GLOBAL.USER_ID,

631: )
632: (
633: select
634: msii.change_line_id,
635: FND_GLOBAL.USER_ID,
636: sysdate,
637: FND_GLOBAL.USER_ID,
638: sysdate,
639: FND_GLOBAL.USER_ID,

Line 637: FND_GLOBAL.USER_ID,

633: select
634: msii.change_line_id,
635: FND_GLOBAL.USER_ID,
636: sysdate,
637: FND_GLOBAL.USER_ID,
638: sysdate,
639: FND_GLOBAL.USER_ID,
640: LANGS.LANGUAGE_CODE,
641: USERENV('LANG'),

Line 639: FND_GLOBAL.USER_ID,

635: FND_GLOBAL.USER_ID,
636: sysdate,
637: FND_GLOBAL.USER_ID,
638: sysdate,
639: FND_GLOBAL.USER_ID,
640: LANGS.LANGUAGE_CODE,
641: USERENV('LANG'),
642: msii.change_line_id
643: from mtl_system_items_interface msii,

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

684: l_dynamic_sql := l_dynamic_sql || 'MSII.INVENTORY_ITEM_ID,MSII.ORGANIZATION_ID,MIRI.REVISION_ID ';
685: end if;
686: l_dynamic_sql := l_dynamic_sql ||
687: ' , ' || l_sub_desc_array(sub_count).SUBJECT_LEVEL ||
688: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||
689: ' , FND_GLOBAL.USER_ID, SYSDATE'||
690: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';
691:
692: if l_sub_desc_array(sub_count).ENTITY_NAME = 'EGO_ITEM_REVISION'

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

685: end if;
686: l_dynamic_sql := l_dynamic_sql ||
687: ' , ' || l_sub_desc_array(sub_count).SUBJECT_LEVEL ||
688: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||
689: ' , FND_GLOBAL.USER_ID, SYSDATE'||
690: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';
691:
692: if l_sub_desc_array(sub_count).ENTITY_NAME = 'EGO_ITEM_REVISION'
693: then

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

686: l_dynamic_sql := l_dynamic_sql ||
687: ' , ' || l_sub_desc_array(sub_count).SUBJECT_LEVEL ||
688: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||
689: ' , FND_GLOBAL.USER_ID, SYSDATE'||
690: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';
691:
692: if l_sub_desc_array(sub_count).ENTITY_NAME = 'EGO_ITEM_REVISION'
693: then
694: l_dynamic_sql := l_dynamic_sql ||' ,MTL_ITEM_REVISIONS_INTERFACE MIRI '||