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

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

157: s_secondary_curr_code := NULL;
158: s_secondary_rate_type := NULL;
159:
160: -- Package level variables for the user logged in
161: s_user_id := nvl(fnd_global.user_id, -1);
162: s_login_id := nvl(fnd_global.login_id, -1);
163: s_program_id := nvl(fnd_global.conc_program_id, -1);
164: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
165: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);

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

158: s_secondary_rate_type := NULL;
159:
160: -- Package level variables for the user logged in
161: s_user_id := nvl(fnd_global.user_id, -1);
162: s_login_id := nvl(fnd_global.login_id, -1);
163: s_program_id := nvl(fnd_global.conc_program_id, -1);
164: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
165: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
166: s_request_id := nvl(fnd_global.conc_request_id, -1);

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

159:
160: -- Package level variables for the user logged in
161: s_user_id := nvl(fnd_global.user_id, -1);
162: s_login_id := nvl(fnd_global.login_id, -1);
163: s_program_id := nvl(fnd_global.conc_program_id, -1);
164: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
165: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
166: s_request_id := nvl(fnd_global.conc_request_id, -1);
167:

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

160: -- Package level variables for the user logged in
161: s_user_id := nvl(fnd_global.user_id, -1);
162: s_login_id := nvl(fnd_global.login_id, -1);
163: s_program_id := nvl(fnd_global.conc_program_id, -1);
164: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
165: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
166: s_request_id := nvl(fnd_global.conc_request_id, -1);
167:
168: -- Parameters we want to check for

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

161: s_user_id := nvl(fnd_global.user_id, -1);
162: s_login_id := nvl(fnd_global.login_id, -1);
163: s_program_id := nvl(fnd_global.conc_program_id, -1);
164: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
165: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
166: s_request_id := nvl(fnd_global.conc_request_id, -1);
167:
168: -- Parameters we want to check for
169: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';

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

162: s_login_id := nvl(fnd_global.login_id, -1);
163: s_program_id := nvl(fnd_global.conc_program_id, -1);
164: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
165: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
166: s_request_id := nvl(fnd_global.conc_request_id, -1);
167:
168: -- Parameters we want to check for
169: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
170: l_list(2) := 'BIS_GLOBAL_START_DATE';

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

707:
708:
709: l_stmt_id := 180;
710: -- User and login id's
711: s_user_id := nvl(fnd_global.user_id, -1);
712: s_login_id := nvl(fnd_global.login_id, -1);
713: s_program_id := nvl(fnd_global.conc_program_id, -1);
714: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
715: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);

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

708:
709: l_stmt_id := 180;
710: -- User and login id's
711: s_user_id := nvl(fnd_global.user_id, -1);
712: s_login_id := nvl(fnd_global.login_id, -1);
713: s_program_id := nvl(fnd_global.conc_program_id, -1);
714: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
715: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
716: s_request_id := nvl(fnd_global.conc_request_id, -1);

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

709: l_stmt_id := 180;
710: -- User and login id's
711: s_user_id := nvl(fnd_global.user_id, -1);
712: s_login_id := nvl(fnd_global.login_id, -1);
713: s_program_id := nvl(fnd_global.conc_program_id, -1);
714: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
715: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
716: s_request_id := nvl(fnd_global.conc_request_id, -1);
717:

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

710: -- User and login id's
711: s_user_id := nvl(fnd_global.user_id, -1);
712: s_login_id := nvl(fnd_global.login_id, -1);
713: s_program_id := nvl(fnd_global.conc_program_id, -1);
714: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
715: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
716: s_request_id := nvl(fnd_global.conc_request_id, -1);
717:
718: l_stmt_id := 190;

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

711: s_user_id := nvl(fnd_global.user_id, -1);
712: s_login_id := nvl(fnd_global.login_id, -1);
713: s_program_id := nvl(fnd_global.conc_program_id, -1);
714: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
715: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
716: s_request_id := nvl(fnd_global.conc_request_id, -1);
717:
718: l_stmt_id := 190;
719: -- Initial load requires lots of memory for OLTP table

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

712: s_login_id := nvl(fnd_global.login_id, -1);
713: s_program_id := nvl(fnd_global.conc_program_id, -1);
714: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
715: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
716: s_request_id := nvl(fnd_global.conc_request_id, -1);
717:
718: l_stmt_id := 190;
719: -- Initial load requires lots of memory for OLTP table
720: -- hash joins. Performance team recommends the following

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

2605:
2606:
2607: l_stmt_id := 140;
2608: -- User and login id's
2609: s_user_id := nvl(fnd_global.user_id, -1);
2610: s_login_id := nvl(fnd_global.login_id, -1);
2611: s_program_id := nvl(fnd_global.conc_program_id, -1);
2612: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
2613: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);

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

2606:
2607: l_stmt_id := 140;
2608: -- User and login id's
2609: s_user_id := nvl(fnd_global.user_id, -1);
2610: s_login_id := nvl(fnd_global.login_id, -1);
2611: s_program_id := nvl(fnd_global.conc_program_id, -1);
2612: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
2613: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
2614: s_request_id := nvl(fnd_global.conc_request_id, -1);

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

2607: l_stmt_id := 140;
2608: -- User and login id's
2609: s_user_id := nvl(fnd_global.user_id, -1);
2610: s_login_id := nvl(fnd_global.login_id, -1);
2611: s_program_id := nvl(fnd_global.conc_program_id, -1);
2612: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
2613: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
2614: s_request_id := nvl(fnd_global.conc_request_id, -1);
2615:

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

2608: -- User and login id's
2609: s_user_id := nvl(fnd_global.user_id, -1);
2610: s_login_id := nvl(fnd_global.login_id, -1);
2611: s_program_id := nvl(fnd_global.conc_program_id, -1);
2612: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
2613: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
2614: s_request_id := nvl(fnd_global.conc_request_id, -1);
2615:
2616: RETURN;

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

2609: s_user_id := nvl(fnd_global.user_id, -1);
2610: s_login_id := nvl(fnd_global.login_id, -1);
2611: s_program_id := nvl(fnd_global.conc_program_id, -1);
2612: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
2613: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
2614: s_request_id := nvl(fnd_global.conc_request_id, -1);
2615:
2616: RETURN;
2617:

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

2610: s_login_id := nvl(fnd_global.login_id, -1);
2611: s_program_id := nvl(fnd_global.conc_program_id, -1);
2612: s_program_login_id := nvl(fnd_global.conc_login_id , -1);
2613: s_program_application_id := nvl(fnd_global.prog_appl_id , -1);
2614: s_request_id := nvl(fnd_global.conc_request_id, -1);
2615:
2616: RETURN;
2617:
2618: EXCEPTION