132: END IF;
133:
134: l_stmt_id := 30;
135: -- Package level variables for the user logged in
136: s_user_id := nvl(fnd_global.user_id, -1);
137: s_login_id := nvl(fnd_global.login_id, -1);
138: s_program_id := nvl (fnd_global.conc_program_id, -1);
139: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
140: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
133:
134: l_stmt_id := 30;
135: -- Package level variables for the user logged in
136: s_user_id := nvl(fnd_global.user_id, -1);
137: s_login_id := nvl(fnd_global.login_id, -1);
138: s_program_id := nvl (fnd_global.conc_program_id, -1);
139: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
140: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
141: s_request_id := nvl (fnd_global.conc_request_id, -1);
134: l_stmt_id := 30;
135: -- Package level variables for the user logged in
136: s_user_id := nvl(fnd_global.user_id, -1);
137: s_login_id := nvl(fnd_global.login_id, -1);
138: s_program_id := nvl (fnd_global.conc_program_id, -1);
139: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
140: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
141: s_request_id := nvl (fnd_global.conc_request_id, -1);
142:
135: -- Package level variables for the user logged in
136: s_user_id := nvl(fnd_global.user_id, -1);
137: s_login_id := nvl(fnd_global.login_id, -1);
138: s_program_id := nvl (fnd_global.conc_program_id, -1);
139: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
140: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
141: s_request_id := nvl (fnd_global.conc_request_id, -1);
142:
143: l_stmt_id := 40;
136: s_user_id := nvl(fnd_global.user_id, -1);
137: s_login_id := nvl(fnd_global.login_id, -1);
138: s_program_id := nvl (fnd_global.conc_program_id, -1);
139: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
140: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
141: s_request_id := nvl (fnd_global.conc_request_id, -1);
142:
143: l_stmt_id := 40;
144: -- check for the DBI global currency setup
137: s_login_id := nvl(fnd_global.login_id, -1);
138: s_program_id := nvl (fnd_global.conc_program_id, -1);
139: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
140: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
141: s_request_id := nvl (fnd_global.conc_request_id, -1);
142:
143: l_stmt_id := 40;
144: -- check for the DBI global currency setup
145: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';