APPS.PSA_BC_XLA_PVT dependencies on FND_PROFILE

Line 748: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value

744: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of function get_sla_notupgraded_flag' );
745:
746: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch PSA: R12 Upgrade Date profile value');
747:
748: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
749:
750: IF l_r12_upgrade_date IS NULL THEN
751: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');
752: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');

Line 845: l_industry fnd_profile_option_values.profile_option_value%TYPE;

841: l_gms_enabled INTEGER;
842: l_prepare_stmt VARCHAR2(2000);
843: l_ret_code VARCHAR2(100);
844: l_bc_mode VARCHAR2(1);
845: l_industry fnd_profile_option_values.profile_option_value%TYPE;
846:
847: BEGIN
848:
849: l_path_name := g_path_name||'.pa_gms_integration_api';

Line 972: l_industry fnd_profile_option_values.profile_option_value%TYPE;

968: l_pa_enabled INTEGER;
969: l_gms_status VARCHAR2(1);
970: l_gms_enabled INTEGER;
971: l_prepare_stmt VARCHAR2(2000);
972: l_industry fnd_profile_option_values.profile_option_value%TYPE;
973: l_bc_mode VARCHAR2(1);
974:
975: BEGIN
976: l_path_name := g_path_name||'.pa_gms_tieback_api';