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

Line 8: s_user_id NUMBER := nvl(fnd_global.user_id, -1);

4: /* Non planned items have an mrp_planning_code of 6 */
5: NON_PLANNED_ITEM CONSTANT NUMBER := 6;
6:
7:
8: s_user_id NUMBER := nvl(fnd_global.user_id, -1);
9: s_login_id NUMBER := nvl(fnd_global.login_id, -1);
10: s_global_start_date DATE := NULL;
11: s_r12_migration_date DATE := NULL;
12: s_sysdate DATE := NULL;

Line 9: s_login_id NUMBER := nvl(fnd_global.login_id, -1);

5: NON_PLANNED_ITEM CONSTANT NUMBER := 6;
6:
7:
8: s_user_id NUMBER := nvl(fnd_global.user_id, -1);
9: s_login_id NUMBER := nvl(fnd_global.login_id, -1);
10: s_global_start_date DATE := NULL;
11: s_r12_migration_date DATE := NULL;
12: s_sysdate DATE := NULL;
13: s_program_id NUMBER:= nvl (fnd_global.conc_program_id, -1);

Line 13: s_program_id NUMBER:= nvl (fnd_global.conc_program_id, -1);

9: s_login_id NUMBER := nvl(fnd_global.login_id, -1);
10: s_global_start_date DATE := NULL;
11: s_r12_migration_date DATE := NULL;
12: s_sysdate DATE := NULL;
13: s_program_id NUMBER:= nvl (fnd_global.conc_program_id, -1);
14: s_program_login_id NUMBER := nvl (fnd_global.conc_login_id, -1);
15: s_program_application_id NUMBER := nvl (fnd_global.prog_appl_id, -1);
16: s_request_id NUMBER := nvl (fnd_global.conc_request_id, -1);
17:

Line 14: s_program_login_id NUMBER := nvl (fnd_global.conc_login_id, -1);

10: s_global_start_date DATE := NULL;
11: s_r12_migration_date DATE := NULL;
12: s_sysdate DATE := NULL;
13: s_program_id NUMBER:= nvl (fnd_global.conc_program_id, -1);
14: s_program_login_id NUMBER := nvl (fnd_global.conc_login_id, -1);
15: s_program_application_id NUMBER := nvl (fnd_global.prog_appl_id, -1);
16: s_request_id NUMBER := nvl (fnd_global.conc_request_id, -1);
17:
18: -- currency types

Line 15: s_program_application_id NUMBER := nvl (fnd_global.prog_appl_id, -1);

11: s_r12_migration_date DATE := NULL;
12: s_sysdate DATE := NULL;
13: s_program_id NUMBER:= nvl (fnd_global.conc_program_id, -1);
14: s_program_login_id NUMBER := nvl (fnd_global.conc_login_id, -1);
15: s_program_application_id NUMBER := nvl (fnd_global.prog_appl_id, -1);
16: s_request_id NUMBER := nvl (fnd_global.conc_request_id, -1);
17:
18: -- currency types
19: g_global_rate_type VARCHAR2(15);

Line 16: s_request_id NUMBER := nvl (fnd_global.conc_request_id, -1);

12: s_sysdate DATE := NULL;
13: s_program_id NUMBER:= nvl (fnd_global.conc_program_id, -1);
14: s_program_login_id NUMBER := nvl (fnd_global.conc_login_id, -1);
15: s_program_application_id NUMBER := nvl (fnd_global.prog_appl_id, -1);
16: s_request_id NUMBER := nvl (fnd_global.conc_request_id, -1);
17:
18: -- currency types
19: g_global_rate_type VARCHAR2(15);
20: g_global_currency_code VARCHAR2(10);

Line 4468: s_user_id := nvl(fnd_global.user_id, -1);

4464:
4465: -- WHO column variable initialization
4466: l_stmt_num := 0;
4467: s_sysdate := SYSDATE;
4468: s_user_id := nvl(fnd_global.user_id, -1);
4469: s_login_id := nvl(fnd_global.login_id, -1);
4470:
4471: --Check Setup
4472: l_stmt_num := 5;

Line 4469: s_login_id := nvl(fnd_global.login_id, -1);

4465: -- WHO column variable initialization
4466: l_stmt_num := 0;
4467: s_sysdate := SYSDATE;
4468: s_user_id := nvl(fnd_global.user_id, -1);
4469: s_login_id := nvl(fnd_global.login_id, -1);
4470:
4471: --Check Setup
4472: l_stmt_num := 5;
4473: CHECK_OPI_JOB_TXN_SETUP(errbuf => errbuf,retcode => retcode, init_incr => 1);

Line 4601: s_user_id := nvl(fnd_global.user_id, -1);

4597:
4598: -- WHO column variable initialization
4599: l_stmt_num := 0;
4600: s_sysdate := SYSDATE;
4601: s_user_id := nvl(fnd_global.user_id, -1);
4602: s_login_id := nvl(fnd_global.login_id, -1);
4603:
4604: --Check Setup
4605: l_stmt_num := 10;

Line 4602: s_login_id := nvl(fnd_global.login_id, -1);

4598: -- WHO column variable initialization
4599: l_stmt_num := 0;
4600: s_sysdate := SYSDATE;
4601: s_user_id := nvl(fnd_global.user_id, -1);
4602: s_login_id := nvl(fnd_global.login_id, -1);
4603:
4604: --Check Setup
4605: l_stmt_num := 10;
4606: CHECK_OPI_JOB_TXN_SETUP(errbuf => errbuf,retcode => retcode, init_incr => 2);