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

Line 633: g_user_id := nvl(fnd_global.user_id, -1);

629: retcode := to_char(l_ret_code);
630:
631: -- session parameters
632: g_sysdate := SYSDATE;
633: g_user_id := nvl(fnd_global.user_id, -1);
634: g_login_id := nvl(fnd_global.login_id, -1);
635: g_program_id := nvl (fnd_global.conc_program_id, -1);
636: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
637: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);

Line 634: g_login_id := nvl(fnd_global.login_id, -1);

630:
631: -- session parameters
632: g_sysdate := SYSDATE;
633: g_user_id := nvl(fnd_global.user_id, -1);
634: g_login_id := nvl(fnd_global.login_id, -1);
635: g_program_id := nvl (fnd_global.conc_program_id, -1);
636: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
637: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
638: g_request_id := nvl (fnd_global.conc_request_id, -1);

Line 635: g_program_id := nvl (fnd_global.conc_program_id, -1);

631: -- session parameters
632: g_sysdate := SYSDATE;
633: g_user_id := nvl(fnd_global.user_id, -1);
634: g_login_id := nvl(fnd_global.login_id, -1);
635: g_program_id := nvl (fnd_global.conc_program_id, -1);
636: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
637: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
638: g_request_id := nvl (fnd_global.conc_request_id, -1);
639:

Line 636: g_program_login_id := nvl (fnd_global.conc_login_id, -1);

632: g_sysdate := SYSDATE;
633: g_user_id := nvl(fnd_global.user_id, -1);
634: g_login_id := nvl(fnd_global.login_id, -1);
635: g_program_id := nvl (fnd_global.conc_program_id, -1);
636: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
637: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
638: g_request_id := nvl (fnd_global.conc_request_id, -1);
639:
640: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';

Line 637: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);

633: g_user_id := nvl(fnd_global.user_id, -1);
634: g_login_id := nvl(fnd_global.login_id, -1);
635: g_program_id := nvl (fnd_global.conc_program_id, -1);
636: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
637: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
638: g_request_id := nvl (fnd_global.conc_request_id, -1);
639:
640: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
641: l_list(2) := 'BIS_GLOBAL_START_DATE';

Line 638: g_request_id := nvl (fnd_global.conc_request_id, -1);

634: g_login_id := nvl(fnd_global.login_id, -1);
635: g_program_id := nvl (fnd_global.conc_program_id, -1);
636: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
637: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
638: g_request_id := nvl (fnd_global.conc_request_id, -1);
639:
640: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
641: l_list(2) := 'BIS_GLOBAL_START_DATE';
642: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';

Line 1096: g_user_id := nvl(fnd_global.user_id, -1);

1092: BEGIN
1093:
1094: -- session parameters
1095: g_sysdate := SYSDATE;
1096: g_user_id := nvl(fnd_global.user_id, -1);
1097: g_login_id := nvl(fnd_global.login_id, -1);
1098: g_program_id := nvl (fnd_global.conc_program_id, -1);
1099: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1100: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);

Line 1097: g_login_id := nvl(fnd_global.login_id, -1);

1093:
1094: -- session parameters
1095: g_sysdate := SYSDATE;
1096: g_user_id := nvl(fnd_global.user_id, -1);
1097: g_login_id := nvl(fnd_global.login_id, -1);
1098: g_program_id := nvl (fnd_global.conc_program_id, -1);
1099: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1100: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1101: g_request_id := nvl (fnd_global.conc_request_id, -1);

Line 1098: g_program_id := nvl (fnd_global.conc_program_id, -1);

1094: -- session parameters
1095: g_sysdate := SYSDATE;
1096: g_user_id := nvl(fnd_global.user_id, -1);
1097: g_login_id := nvl(fnd_global.login_id, -1);
1098: g_program_id := nvl (fnd_global.conc_program_id, -1);
1099: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1100: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1101: g_request_id := nvl (fnd_global.conc_request_id, -1);
1102:

Line 1099: g_program_login_id := nvl (fnd_global.conc_login_id, -1);

1095: g_sysdate := SYSDATE;
1096: g_user_id := nvl(fnd_global.user_id, -1);
1097: g_login_id := nvl(fnd_global.login_id, -1);
1098: g_program_id := nvl (fnd_global.conc_program_id, -1);
1099: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1100: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1101: g_request_id := nvl (fnd_global.conc_request_id, -1);
1102:
1103: l_stmt_num :=3;

Line 1100: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);

1096: g_user_id := nvl(fnd_global.user_id, -1);
1097: g_login_id := nvl(fnd_global.login_id, -1);
1098: g_program_id := nvl (fnd_global.conc_program_id, -1);
1099: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1100: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1101: g_request_id := nvl (fnd_global.conc_request_id, -1);
1102:
1103: l_stmt_num :=3;
1104: OPEN OPI_DBI_RUN_LOG_CURR_CSR;

Line 1101: g_request_id := nvl (fnd_global.conc_request_id, -1);

1097: g_login_id := nvl(fnd_global.login_id, -1);
1098: g_program_id := nvl (fnd_global.conc_program_id, -1);
1099: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1100: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1101: g_request_id := nvl (fnd_global.conc_request_id, -1);
1102:
1103: l_stmt_num :=3;
1104: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1105: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;

Line 1482: g_user_id := nvl(fnd_global.user_id, -1);

1478: retcode := to_char(l_ret_code);
1479:
1480: -- session parameters
1481: g_sysdate := SYSDATE;
1482: g_user_id := nvl(fnd_global.user_id, -1);
1483: g_login_id := nvl(fnd_global.login_id, -1);
1484:
1485: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
1486: l_list(2) := 'BIS_GLOBAL_START_DATE';

Line 1483: g_login_id := nvl(fnd_global.login_id, -1);

1479:
1480: -- session parameters
1481: g_sysdate := SYSDATE;
1482: g_user_id := nvl(fnd_global.user_id, -1);
1483: g_login_id := nvl(fnd_global.login_id, -1);
1484:
1485: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
1486: l_list(2) := 'BIS_GLOBAL_START_DATE';
1487: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';