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.MSC_SNO_PKG dependencies on FND_GLOBAL

Line 8: l_appl_id number := fnd_global.prog_appl_id;

4: procedure populate_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
5: p_plan_id number, p_plan_run_id number)
6: is
7: l_api_name varchar2(100) := 'msc_sno_pkg.populate_details';
8: l_appl_id number := fnd_global.prog_appl_id;
9: l_cp_login_id number := fnd_global.conc_login_id;
10: l_program_id number := fnd_global.conc_program_id;
11: l_request_id number := fnd_global.conc_request_id;
12: l_sysdate date := sysdate;

Line 9: l_cp_login_id number := fnd_global.conc_login_id;

5: p_plan_id number, p_plan_run_id number)
6: is
7: l_api_name varchar2(100) := 'msc_sno_pkg.populate_details';
8: l_appl_id number := fnd_global.prog_appl_id;
9: l_cp_login_id number := fnd_global.conc_login_id;
10: l_program_id number := fnd_global.conc_program_id;
11: l_request_id number := fnd_global.conc_request_id;
12: l_sysdate date := sysdate;
13: l_user_id number := fnd_global.user_id;

Line 10: l_program_id number := fnd_global.conc_program_id;

6: is
7: l_api_name varchar2(100) := 'msc_sno_pkg.populate_details';
8: l_appl_id number := fnd_global.prog_appl_id;
9: l_cp_login_id number := fnd_global.conc_login_id;
10: l_program_id number := fnd_global.conc_program_id;
11: l_request_id number := fnd_global.conc_request_id;
12: l_sysdate date := sysdate;
13: l_user_id number := fnd_global.user_id;
14: l_user_login_id number := fnd_global.login_id;

Line 11: l_request_id number := fnd_global.conc_request_id;

7: l_api_name varchar2(100) := 'msc_sno_pkg.populate_details';
8: l_appl_id number := fnd_global.prog_appl_id;
9: l_cp_login_id number := fnd_global.conc_login_id;
10: l_program_id number := fnd_global.conc_program_id;
11: l_request_id number := fnd_global.conc_request_id;
12: l_sysdate date := sysdate;
13: l_user_id number := fnd_global.user_id;
14: l_user_login_id number := fnd_global.login_id;
15:

Line 13: l_user_id number := fnd_global.user_id;

9: l_cp_login_id number := fnd_global.conc_login_id;
10: l_program_id number := fnd_global.conc_program_id;
11: l_request_id number := fnd_global.conc_request_id;
12: l_sysdate date := sysdate;
13: l_user_id number := fnd_global.user_id;
14: l_user_login_id number := fnd_global.login_id;
15:
16: l_qid_vmi_item number := 0;
17: l_plan_constrained number := 0;

Line 14: l_user_login_id number := fnd_global.login_id;

10: l_program_id number := fnd_global.conc_program_id;
11: l_request_id number := fnd_global.conc_request_id;
12: l_sysdate date := sysdate;
13: l_user_id number := fnd_global.user_id;
14: l_user_login_id number := fnd_global.login_id;
15:
16: l_qid_vmi_item number := 0;
17: l_plan_constrained number := 0;
18: l_plan_type number := msc_phub_util.get_plan_type(p_plan_id);

Line 98: fnd_global.user_id,

94: exception_tbl.exception_value * decode(exception_tbl.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1, nvl(mcc.CONV_RATE,0)) exception_value2,
95: exception_tbl.exception_days,
96: exception_tbl.exception_quantity,
97: exception_tbl.exception_ratio,
98: fnd_global.user_id,
99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,

Line 101: fnd_global.user_id,

97: exception_tbl.exception_ratio,
98: fnd_global.user_id,
99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,

Line 102: fnd_global.login_id,

98: fnd_global.user_id,
99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id

Line 103: fnd_global.conc_program_id,

99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
107: from

Line 104: fnd_global.conc_login_id,

100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
107: from
108: (

Line 105: fnd_global.prog_appl_id,

101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
107: from
108: (
109: select

Line 106: fnd_global.conc_request_id

102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
107: from
108: (
109: select
110: t.plan_id,

Line 254: fnd_global.user_id created_by,

250: nvl(owning_department_id, -23453),
251: resource_id,
252: inventory_item_id,
253: analysis_date,
254: fnd_global.user_id created_by,
255: sysdate creation_date,
256: sysdate last_update_date,
257: fnd_global.user_id last_updated_by,
258: fnd_global.login_id last_update_login,

Line 257: fnd_global.user_id last_updated_by,

253: analysis_date,
254: fnd_global.user_id created_by,
255: sysdate creation_date,
256: sysdate last_update_date,
257: fnd_global.user_id last_updated_by,
258: fnd_global.login_id last_update_login,
259: fnd_global.conc_program_id program_id,
260: fnd_global.conc_login_id program_login_id,
261: fnd_global.prog_appl_id program_application_id,

Line 258: fnd_global.login_id last_update_login,

254: fnd_global.user_id created_by,
255: sysdate creation_date,
256: sysdate last_update_date,
257: fnd_global.user_id last_updated_by,
258: fnd_global.login_id last_update_login,
259: fnd_global.conc_program_id program_id,
260: fnd_global.conc_login_id program_login_id,
261: fnd_global.prog_appl_id program_application_id,
262: fnd_global.conc_request_id request_id,

Line 259: fnd_global.conc_program_id program_id,

255: sysdate creation_date,
256: sysdate last_update_date,
257: fnd_global.user_id last_updated_by,
258: fnd_global.login_id last_update_login,
259: fnd_global.conc_program_id program_id,
260: fnd_global.conc_login_id program_login_id,
261: fnd_global.prog_appl_id program_application_id,
262: fnd_global.conc_request_id request_id,
263: sum(required_hours),

Line 260: fnd_global.conc_login_id program_login_id,

256: sysdate last_update_date,
257: fnd_global.user_id last_updated_by,
258: fnd_global.login_id last_update_login,
259: fnd_global.conc_program_id program_id,
260: fnd_global.conc_login_id program_login_id,
261: fnd_global.prog_appl_id program_application_id,
262: fnd_global.conc_request_id request_id,
263: sum(required_hours),
264: sum(available_hours),

Line 261: fnd_global.prog_appl_id program_application_id,

257: fnd_global.user_id last_updated_by,
258: fnd_global.login_id last_update_login,
259: fnd_global.conc_program_id program_id,
260: fnd_global.conc_login_id program_login_id,
261: fnd_global.prog_appl_id program_application_id,
262: fnd_global.conc_request_id request_id,
263: sum(required_hours),
264: sum(available_hours),
265: sum(setup_time_hrs),

Line 262: fnd_global.conc_request_id request_id,

258: fnd_global.login_id last_update_login,
259: fnd_global.conc_program_id program_id,
260: fnd_global.conc_login_id program_login_id,
261: fnd_global.prog_appl_id program_application_id,
262: fnd_global.conc_request_id request_id,
263: sum(required_hours),
264: sum(available_hours),
265: sum(setup_time_hrs),
266: sum(order_quantity),

Line 383: fnd_global.user_id,

379: sum(t1.po_cancel_count),
380: sum(t1.buy_order_value),
381: sum(t1.buy_order_value * decode(t1.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,nvl(mcc.conv_rate,0))) buy_order_value2,
382: sum(t1.buy_order_count),
383: fnd_global.user_id,
384: sysdate,
385: sysdate,
386: fnd_global.user_id,
387: fnd_global.login_id,

Line 386: fnd_global.user_id,

382: sum(t1.buy_order_count),
383: fnd_global.user_id,
384: sysdate,
385: sysdate,
386: fnd_global.user_id,
387: fnd_global.login_id,
388: fnd_global.conc_program_id,
389: fnd_global.conc_login_id,
390: fnd_global.prog_appl_id,

Line 387: fnd_global.login_id,

383: fnd_global.user_id,
384: sysdate,
385: sysdate,
386: fnd_global.user_id,
387: fnd_global.login_id,
388: fnd_global.conc_program_id,
389: fnd_global.conc_login_id,
390: fnd_global.prog_appl_id,
391: fnd_global.conc_request_id

Line 388: fnd_global.conc_program_id,

384: sysdate,
385: sysdate,
386: fnd_global.user_id,
387: fnd_global.login_id,
388: fnd_global.conc_program_id,
389: fnd_global.conc_login_id,
390: fnd_global.prog_appl_id,
391: fnd_global.conc_request_id
392: from

Line 389: fnd_global.conc_login_id,

385: sysdate,
386: fnd_global.user_id,
387: fnd_global.login_id,
388: fnd_global.conc_program_id,
389: fnd_global.conc_login_id,
390: fnd_global.prog_appl_id,
391: fnd_global.conc_request_id
392: from
393: (

Line 390: fnd_global.prog_appl_id,

386: fnd_global.user_id,
387: fnd_global.login_id,
388: fnd_global.conc_program_id,
389: fnd_global.conc_login_id,
390: fnd_global.prog_appl_id,
391: fnd_global.conc_request_id
392: from
393: (
394: select

Line 391: fnd_global.conc_request_id

387: fnd_global.login_id,
388: fnd_global.conc_program_id,
389: fnd_global.conc_login_id,
390: fnd_global.prog_appl_id,
391: fnd_global.conc_request_id
392: from
393: (
394: select
395: mbid.plan_id plan_id,