APPS.HRI_OPL_SUP_STATUS_HST dependencies on FND_PROFILE

Line 1324: IF fnd_profile.value('HRI_IMPL_DBI') = 'Y' THEN

1320: --
1321: --
1322: --Insert new supervisor status history records for DBI
1323: --
1324: IF fnd_profile.value('HRI_IMPL_DBI') = 'Y' THEN
1325: --
1326: -- Disable/drop objects (indexes and triggers)
1327: --
1328: disable_objects(p_schema => l_schema,

Line 1356: IF fnd_profile.value('HRI_IMPL_OBIEE') = 'Y' THEN

1352: END IF;
1353: --
1354: --Insert new supervisor status history records for OBIEE
1355: --
1356: IF fnd_profile.value('HRI_IMPL_OBIEE') = 'Y' THEN
1357: --
1358: -- Disable/drop objects (indexes and triggers)
1359: --
1360: run_sql_stmt_noerr('ALTER TRIGGER HRI_CL_WKR_SUP_STATUS_ASG_WHO DISABLE');

Line 1464: IF fnd_profile.value('HRI_IMPL_DBI') = 'Y' THEN

1460: -- Set start time
1461: --
1462: g_current_time := SYSDATE;
1463: --
1464: IF fnd_profile.value('HRI_IMPL_DBI') = 'Y' THEN
1465: --
1466: -- Delete the status records of people whose status could have changed
1467: --
1468: dbg('Calling delete_old_supervisor_status...');

Line 1479: IF fnd_profile.value('HRI_IMPL_OBIEE') = 'Y' THEN

1475: collect_incremental_data;
1476: --
1477: END IF;
1478: --
1479: IF fnd_profile.value('HRI_IMPL_OBIEE') = 'Y' THEN
1480: --
1481: -- Delete the status records of people whose status could have changed
1482: --
1483: dbg('Calling delete_asg_supervisor_status...');

Line 1544: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');

1540: --
1541: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');
1542: --
1543: l_is_hr_installed := hr_general.chk_product_installed(800);
1544: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
1545: --
1546: IF l_is_hr_installed = 'FALSE'
1547: OR l_frc_shrd_hr_prfl_val = 'Y' THEN
1548: --

Line 1655: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');

1651: -- Processes has been set, then the force the process to run in
1652: -- full refresh mode and from SYSDATE
1653: --
1654: l_is_hr_installed := hr_general.chk_product_installed(800);
1655: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
1656: --
1657: IF l_is_hr_installed = 'FALSE'
1658: OR l_frc_shrd_hr_prfl_val = 'Y'
1659: THEN

Line 1784: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');

1780: --
1781: -- Determine if the process needs to be run in Foundation HR mode
1782: --
1783: l_is_hr_installed := hr_general.chk_product_installed(800);
1784: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
1785: --
1786: l_end_date := fnd_date.canonical_to_date(p_end_date);
1787: --
1788: IF l_is_hr_installed = 'FALSE'