APPS.PA_PAGE_LAYOUT_UTILS dependencies on FND_PROFILE

Line 520: FROM fnd_profile_options po,

516:
517: /*
518: CURSOR c_profile_refernce IS
519: SELECT 'X'
520: FROM fnd_profile_options po,
521: fnd_profile_option_values pov
522: WHERE po.application_id = 275
523: AND po.profile_option_name = 'PA_TEAM_HOME_PAGELAYOUT'
524: AND po.profile_option_id = pov.profile_option_id

Line 521: fnd_profile_option_values pov

517: /*
518: CURSOR c_profile_refernce IS
519: SELECT 'X'
520: FROM fnd_profile_options po,
521: fnd_profile_option_values pov
522: WHERE po.application_id = 275
523: AND po.profile_option_name = 'PA_TEAM_HOME_PAGELAYOUT'
524: AND po.profile_option_id = pov.profile_option_id
525: AND pov.application_id = 275

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

631: x_msg_count := 0;
632: x_return_status:=fnd_api.g_ret_sts_success;
633: savepoint populate_pers_functions;
634:
635: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
636:
637: IF l_debug_mode = 'Y' THEN
638: pa_debug.set_curr_function( p_function => 'PERS_FUNCTIONS',
639: p_debug_mode => l_debug_mode );