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 645: from fnd_profile_options_vl

641: l_log_module VARCHAR2(240);
642:
643: cursor c_profile_user_name (l_profile_name VARCHAR2) IS
644: select user_profile_option_name
645: from fnd_profile_options_vl
646: where profile_option_name = l_profile_name;
647:
648: BEGIN
649: IF g_log_enabled THEN

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

706:
707: --
708: -- Initialize ledger security information
709: --
710: g_use_ledger_security := NVL(fnd_profile.value('XLA_USE_LEDGER_SECURITY'), 'N');
711:
712: IF (g_use_ledger_security = 'Y') THEN
713: g_pri_access_set_id := fnd_profile.value('GL_ACCESS_SET_ID');
714: g_sec_access_set_id := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');

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

709: --
710: g_use_ledger_security := NVL(fnd_profile.value('XLA_USE_LEDGER_SECURITY'), 'N');
711:
712: IF (g_use_ledger_security = 'Y') THEN
713: g_pri_access_set_id := fnd_profile.value('GL_ACCESS_SET_ID');
714: g_sec_access_set_id := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');
715:
716: ----------------------------------------------------------------------------------------
717: -- 5109176 find the user profile name for the error message XLA_AP_ACCESS_SET_VIOLATION

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

710: g_use_ledger_security := NVL(fnd_profile.value('XLA_USE_LEDGER_SECURITY'), 'N');
711:
712: IF (g_use_ledger_security = 'Y') THEN
713: g_pri_access_set_id := fnd_profile.value('GL_ACCESS_SET_ID');
714: g_sec_access_set_id := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');
715:
716: ----------------------------------------------------------------------------------------
717: -- 5109176 find the user profile name for the error message XLA_AP_ACCESS_SET_VIOLATION
718: ----------------------------------------------------------------------------------------

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

11031: --
11032: --=============================================================================
11033: BEGIN
11034: g_new_line_count := 0;
11035: g_amb_context_code := NVL(fnd_profile.value('XLA_AMB_CONTEXT'), 'DEFAULT');
11036:
11037: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11038: g_log_enabled := fnd_log.test
11039: (log_level => g_log_level