APPS.PSA_BC_XLA_PVT dependencies on FND_PROFILE

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

688: psa_xla_error_cleanup;
689:
690:
691: BEGIN
692: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
693:
694: IF l_r12_upgrade_date IS NULL THEN
695: x_status_code := 'FATAL';
696:

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

1138: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of function get_sla_notupgraded_flag' );
1139:
1140: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch PSA: R12 Upgrade Date profile value');
1141:
1142: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
1143:
1144: IF l_r12_upgrade_date IS NULL THEN
1145: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');
1146: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');

Line 1247: l_industry fnd_profile_option_values.profile_option_value%TYPE;

1243: l_gms_enabled INTEGER;
1244: l_prepare_stmt VARCHAR2(2000);
1245: l_ret_code VARCHAR2(100);
1246: l_bc_mode VARCHAR2(1);
1247: l_industry fnd_profile_option_values.profile_option_value%TYPE;
1248:
1249: BEGIN
1250:
1251: l_path_name := g_path_name||'.pa_gms_integration_api';

Line 1374: l_industry fnd_profile_option_values.profile_option_value%TYPE;

1370: l_pa_enabled INTEGER;
1371: l_gms_status VARCHAR2(1);
1372: l_gms_enabled INTEGER;
1373: l_prepare_stmt VARCHAR2(2000);
1374: l_industry fnd_profile_option_values.profile_option_value%TYPE;
1375: l_bc_mode VARCHAR2(1);
1376:
1377: BEGIN
1378: l_path_name := g_path_name||'.pa_gms_tieback_api';