DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on FND_PROFILE

Line 142: g_pri_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176

138: g_use_ledger_security VARCHAR2(1);
139: g_pri_access_set_id INTEGER;
140: g_sec_access_set_id INTEGER;
141: g_tmp_access_set_id INTEGER; -- 5109176
142: g_pri_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
143: g_sec_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
144: g_tmp_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
145: g_pri_coa_id INTEGER;
146: g_sec_coa_id INTEGER;

Line 143: g_sec_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176

139: g_pri_access_set_id INTEGER;
140: g_sec_access_set_id INTEGER;
141: g_tmp_access_set_id INTEGER; -- 5109176
142: g_pri_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
143: g_sec_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
144: g_tmp_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
145: g_pri_coa_id INTEGER;
146: g_sec_coa_id INTEGER;
147: g_tmp_coa_id INTEGER;

Line 144: g_tmp_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176

140: g_sec_access_set_id INTEGER;
141: g_tmp_access_set_id INTEGER; -- 5109176
142: g_pri_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
143: g_sec_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
144: g_tmp_access_set_name fnd_profile_options_vl.user_profile_option_name%TYPE; -- 5109176
145: g_pri_coa_id INTEGER;
146: g_sec_coa_id INTEGER;
147: g_tmp_coa_id INTEGER;
148: g_pri_security_seg_code VARCHAR2(1);

Line 380: from fnd_profile_options_vl

376: l_log_module VARCHAR2(240);
377:
378: cursor c_profile_user_name (l_profile_name VARCHAR2) IS
379: select user_profile_option_name
380: from fnd_profile_options_vl
381: where profile_option_name = l_profile_name;
382:
383: BEGIN
384: IF g_log_enabled THEN

Line 445: g_use_ledger_security := NVL(fnd_profile.value('XLA_USE_LEDGER_SECURITY'), 'N');

441:
442: --
443: -- Initialize ledger security information
444: --
445: g_use_ledger_security := NVL(fnd_profile.value('XLA_USE_LEDGER_SECURITY'), 'N');
446:
447: IF (g_use_ledger_security = 'Y') THEN
448: g_pri_access_set_id := fnd_profile.value('GL_ACCESS_SET_ID');
449: g_sec_access_set_id := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');

Line 448: g_pri_access_set_id := fnd_profile.value('GL_ACCESS_SET_ID');

444: --
445: g_use_ledger_security := NVL(fnd_profile.value('XLA_USE_LEDGER_SECURITY'), 'N');
446:
447: IF (g_use_ledger_security = 'Y') THEN
448: g_pri_access_set_id := fnd_profile.value('GL_ACCESS_SET_ID');
449: g_sec_access_set_id := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');
450:
451: ----------------------------------------------------------------------------------------
452: -- 5109176 find the user profile name for the error message XLA_AP_ACCESS_SET_VIOLATION

Line 449: g_sec_access_set_id := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');

445: g_use_ledger_security := NVL(fnd_profile.value('XLA_USE_LEDGER_SECURITY'), 'N');
446:
447: IF (g_use_ledger_security = 'Y') THEN
448: g_pri_access_set_id := fnd_profile.value('GL_ACCESS_SET_ID');
449: g_sec_access_set_id := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');
450:
451: ----------------------------------------------------------------------------------------
452: -- 5109176 find the user profile name for the error message XLA_AP_ACCESS_SET_VIOLATION
453: ----------------------------------------------------------------------------------------

Line 10326: g_amb_context_code := NVL(fnd_profile.value('XLA_AMB_CONTEXT'), 'DEFAULT');

10322: --
10323: --=============================================================================
10324: BEGIN
10325: g_new_line_count := 0;
10326: g_amb_context_code := NVL(fnd_profile.value('XLA_AMB_CONTEXT'), 'DEFAULT');
10327:
10328: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10329: g_log_enabled := fnd_log.test
10330: (log_level => g_log_level