APPS.PA_PAGE_LAYOUT_UTILS dependencies on FND_PROFILE

Line 529: FROM fnd_profile_options po,

525:
526: /*
527: CURSOR c_profile_refernce IS
528: SELECT 'X'
529: FROM fnd_profile_options po,
530: fnd_profile_option_values pov
531: WHERE po.application_id = 275
532: AND po.profile_option_name = 'PA_TEAM_HOME_PAGELAYOUT'
533: AND po.profile_option_id = pov.profile_option_id

Line 530: fnd_profile_option_values pov

526: /*
527: CURSOR c_profile_refernce IS
528: SELECT 'X'
529: FROM fnd_profile_options po,
530: fnd_profile_option_values pov
531: WHERE po.application_id = 275
532: AND po.profile_option_name = 'PA_TEAM_HOME_PAGELAYOUT'
533: AND po.profile_option_id = pov.profile_option_id
534: AND pov.application_id = 275

Line 644: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

640: x_msg_count := 0;
641: x_return_status:=fnd_api.g_ret_sts_success;
642: savepoint populate_pers_functions;
643:
644: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
645:
646: IF l_debug_mode = 'Y' THEN
647: pa_debug.set_curr_function( p_function => 'PERS_FUNCTIONS',
648: p_debug_mode => l_debug_mode );