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_MTL_VARIANCE_PKG dependencies on FND_GLOBAL

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

11: g_row_count NUMBER;
12:
13: -- WHO column information
14: g_sysdate DATE := SYSDATE;
15: g_user_id NUMBER := nvl(fnd_global.user_id, -1);
16: g_login_id NUMBER := nvl(fnd_global.login_id, -1);
17: g_last_collection_date DATE;
18: g_program_id NUMBER;
19: g_program_login_id NUMBER;

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

12:
13: -- WHO column information
14: g_sysdate DATE := SYSDATE;
15: g_user_id NUMBER := nvl(fnd_global.user_id, -1);
16: g_login_id NUMBER := nvl(fnd_global.login_id, -1);
17: g_last_collection_date DATE;
18: g_program_id NUMBER;
19: g_program_login_id NUMBER;
20: g_program_application_id NUMBER;

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

220:
221: l_stmt_num := 10;
222: -- WHO column variable initialization
223: g_sysdate := trunc (SYSDATE);
224: g_user_id := nvl(fnd_global.user_id, -1);
225: g_login_id := nvl(fnd_global.login_id, -1);
226:
227:
228: l_stmt_num := 12;

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

221: l_stmt_num := 10;
222: -- WHO column variable initialization
223: g_sysdate := trunc (SYSDATE);
224: g_user_id := nvl(fnd_global.user_id, -1);
225: g_login_id := nvl(fnd_global.login_id, -1);
226:
227:
228: l_stmt_num := 12;
229: -- Global currency codes -- already checked if primary is set up

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

741: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
742:
743: -- WHO column variable initialization
744: g_sysdate := SYSDATE;
745: g_user_id := nvl(fnd_global.user_id, -1);
746: g_login_id := nvl(fnd_global.login_id, -1);
747: g_program_id := nvl (fnd_global.conc_program_id, -1);
748: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
749: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);

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

742:
743: -- WHO column variable initialization
744: g_sysdate := SYSDATE;
745: g_user_id := nvl(fnd_global.user_id, -1);
746: g_login_id := nvl(fnd_global.login_id, -1);
747: g_program_id := nvl (fnd_global.conc_program_id, -1);
748: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
749: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
750: g_request_id := nvl (fnd_global.conc_request_id, -1);

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

743: -- WHO column variable initialization
744: g_sysdate := SYSDATE;
745: g_user_id := nvl(fnd_global.user_id, -1);
746: g_login_id := nvl(fnd_global.login_id, -1);
747: g_program_id := nvl (fnd_global.conc_program_id, -1);
748: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
749: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
750: g_request_id := nvl (fnd_global.conc_request_id, -1);
751:

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

744: g_sysdate := SYSDATE;
745: g_user_id := nvl(fnd_global.user_id, -1);
746: g_login_id := nvl(fnd_global.login_id, -1);
747: g_program_id := nvl (fnd_global.conc_program_id, -1);
748: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
749: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
750: g_request_id := nvl (fnd_global.conc_request_id, -1);
751:
752:

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

745: g_user_id := nvl(fnd_global.user_id, -1);
746: g_login_id := nvl(fnd_global.login_id, -1);
747: g_program_id := nvl (fnd_global.conc_program_id, -1);
748: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
749: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
750: g_request_id := nvl (fnd_global.conc_request_id, -1);
751:
752:
753: /* Check For Setup */

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

746: g_login_id := nvl(fnd_global.login_id, -1);
747: g_program_id := nvl (fnd_global.conc_program_id, -1);
748: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
749: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
750: g_request_id := nvl (fnd_global.conc_request_id, -1);
751:
752:
753: /* Check For Setup */
754: l_stmt_num := 10;

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

1045: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1046:
1047: -- WHO column variable initialization
1048: g_sysdate := SYSDATE;
1049: g_user_id := nvl(fnd_global.user_id, -1);
1050: g_login_id := nvl(fnd_global.login_id, -1);
1051: g_program_id := nvl (fnd_global.conc_program_id, -1);
1052: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1053: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);

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

1046:
1047: -- WHO column variable initialization
1048: g_sysdate := SYSDATE;
1049: g_user_id := nvl(fnd_global.user_id, -1);
1050: g_login_id := nvl(fnd_global.login_id, -1);
1051: g_program_id := nvl (fnd_global.conc_program_id, -1);
1052: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1053: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1054: g_request_id := nvl (fnd_global.conc_request_id, -1);

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

1047: -- WHO column variable initialization
1048: g_sysdate := SYSDATE;
1049: g_user_id := nvl(fnd_global.user_id, -1);
1050: g_login_id := nvl(fnd_global.login_id, -1);
1051: g_program_id := nvl (fnd_global.conc_program_id, -1);
1052: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1053: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1054: g_request_id := nvl (fnd_global.conc_request_id, -1);
1055:

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

1048: g_sysdate := SYSDATE;
1049: g_user_id := nvl(fnd_global.user_id, -1);
1050: g_login_id := nvl(fnd_global.login_id, -1);
1051: g_program_id := nvl (fnd_global.conc_program_id, -1);
1052: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1053: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1054: g_request_id := nvl (fnd_global.conc_request_id, -1);
1055:
1056: /* Check For Setup */

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

1049: g_user_id := nvl(fnd_global.user_id, -1);
1050: g_login_id := nvl(fnd_global.login_id, -1);
1051: g_program_id := nvl (fnd_global.conc_program_id, -1);
1052: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1053: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1054: g_request_id := nvl (fnd_global.conc_request_id, -1);
1055:
1056: /* Check For Setup */
1057: l_stmt_num := 10;

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

1050: g_login_id := nvl(fnd_global.login_id, -1);
1051: g_program_id := nvl (fnd_global.conc_program_id, -1);
1052: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1053: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1054: g_request_id := nvl (fnd_global.conc_request_id, -1);
1055:
1056: /* Check For Setup */
1057: l_stmt_num := 10;
1058: CHECK_OPI_MFG_CST_VAR_SETUP(errbuf,retcode);

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

1518: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1519:
1520: -- WHO column variable initialization
1521: g_sysdate := SYSDATE;
1522: g_user_id := nvl(fnd_global.user_id, -1);
1523: g_login_id := nvl(fnd_global.login_id, -1);
1524: g_program_id := nvl (fnd_global.conc_program_id, -1);
1525: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1526: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);

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

1519:
1520: -- WHO column variable initialization
1521: g_sysdate := SYSDATE;
1522: g_user_id := nvl(fnd_global.user_id, -1);
1523: g_login_id := nvl(fnd_global.login_id, -1);
1524: g_program_id := nvl (fnd_global.conc_program_id, -1);
1525: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1526: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1527: g_request_id := nvl (fnd_global.conc_request_id, -1);

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

1520: -- WHO column variable initialization
1521: g_sysdate := SYSDATE;
1522: g_user_id := nvl(fnd_global.user_id, -1);
1523: g_login_id := nvl(fnd_global.login_id, -1);
1524: g_program_id := nvl (fnd_global.conc_program_id, -1);
1525: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1526: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1527: g_request_id := nvl (fnd_global.conc_request_id, -1);
1528:

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

1521: g_sysdate := SYSDATE;
1522: g_user_id := nvl(fnd_global.user_id, -1);
1523: g_login_id := nvl(fnd_global.login_id, -1);
1524: g_program_id := nvl (fnd_global.conc_program_id, -1);
1525: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1526: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1527: g_request_id := nvl (fnd_global.conc_request_id, -1);
1528:
1529: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';

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

1522: g_user_id := nvl(fnd_global.user_id, -1);
1523: g_login_id := nvl(fnd_global.login_id, -1);
1524: g_program_id := nvl (fnd_global.conc_program_id, -1);
1525: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1526: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1527: g_request_id := nvl (fnd_global.conc_request_id, -1);
1528:
1529: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
1530: l_list(2) := 'BIS_GLOBAL_START_DATE';

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

1523: g_login_id := nvl(fnd_global.login_id, -1);
1524: g_program_id := nvl (fnd_global.conc_program_id, -1);
1525: g_program_login_id := nvl (fnd_global.conc_login_id, -1);
1526: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1527: g_request_id := nvl (fnd_global.conc_request_id, -1);
1528:
1529: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
1530: l_list(2) := 'BIS_GLOBAL_START_DATE';
1531: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';