APPS.ARI_SELF_REGISTRATION_PKG dependencies on FND_PROFILE

Line 66: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

62:
63: --------------------------------------------------------------------------
64: -- Local Procedure Signature
65: --------------------------------------------------------------------------
66: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
67:
68: PROCEDURE InformSysAdminError(p_procedure_name IN VARCHAR2,
69: p_debug_info IN VARCHAR2,
70: p_error IN VARCHAR2);

Line 2443: from fnd_profile_option_values fpov, fnd_profile_options fpo

2439: IF p_user_id IS NOT NULL THEN
2440: BEGIN
2441: select fpov.profile_option_value
2442: into l_reg_sec_profile
2443: from fnd_profile_option_values fpov, fnd_profile_options fpo
2444: where fpov.profile_option_id = fpo.profile_option_id
2445: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2446: and fpov.level_id = 10004 -- user level
2447: and fpov.level_value = p_user_id;

Line 2463: from fnd_profile_option_values fpov, fnd_profile_options fpo

2459: --Get the security profile value set up for the
2460: --iReceivables Registration responsibility
2461: select fpov.profile_option_value
2462: into l_reg_sec_profile
2463: from fnd_profile_option_values fpov, fnd_profile_options fpo
2464: where fpov.profile_option_id = fpo.profile_option_id
2465: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2466: and fpov.level_id = 10003 -- responsibility level
2467: and fpov.level_value_application_id = 222

Line 2474: from fnd_profile_option_values fpov, fnd_profile_options fpo

2470: WHEN NO_DATA_FOUND THEN
2471: --Get the security profile set up at the site level
2472: select fpov.profile_option_value
2473: into l_reg_sec_profile
2474: from fnd_profile_option_values fpov, fnd_profile_options fpo
2475: where fpov.profile_option_id = fpo.profile_option_id
2476: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2477: and fpov.level_id = 10001; -- Site level
2478: