DBA Data[Home] [Help]

APPS.HRI_OPL_ASGN_EVENTS dependencies on HR_GENERAL

Line 282: -- Global end of time date initialization from the package hr_general

278: g_collect_hdc VARCHAR2(5);
279: g_full_refresh VARCHAR2(5);
280: g_assignment_id NUMBER;
281: --
282: -- Global end of time date initialization from the package hr_general
283: --
284: g_end_of_time DATE;
285: --
286: -- Global DBI collection start date initialization

Line 2848: IF p_asg_dates.start_date_active <= nvl(l_pow_band_end_date,hr_general.end_of_time) AND

2844: 'pow_end='||to_char(l_pow_band_end_date,'DD-MON-RRRR'));
2845: --
2846: -- Do not create any events if the end date is null or end of time
2847: --
2848: IF p_asg_dates.start_date_active <= nvl(l_pow_band_end_date,hr_general.end_of_time) AND
2849: l_pow_band_start_date <= nvl(p_asg_dates.termination_date,hr_general.end_of_time)
2850: THEN
2851: --
2852: l_date_index := greatest(l_pow_band_start_date,p_asg_dates.start_date_active) - g_refresh_start_date;

Line 2849: l_pow_band_start_date <= nvl(p_asg_dates.termination_date,hr_general.end_of_time)

2845: --
2846: -- Do not create any events if the end date is null or end of time
2847: --
2848: IF p_asg_dates.start_date_active <= nvl(l_pow_band_end_date,hr_general.end_of_time) AND
2849: l_pow_band_start_date <= nvl(p_asg_dates.termination_date,hr_general.end_of_time)
2850: THEN
2851: --
2852: l_date_index := greatest(l_pow_band_start_date,p_asg_dates.start_date_active) - g_refresh_start_date;
2853: --

Line 2895: nvl(l_pow_band_end_date,hr_general.end_of_time)

2891: l_pow_extn_strt_dt := l_prjctd_end_dt + 1;
2892: p_date_master_tab(nvl(l_date_index,0)).pow_extn_strt_dt := l_pow_extn_strt_dt;
2893: --
2894: ELSIF l_prjctd_end_dt + 1 BETWEEN l_pow_band_start_date AND
2895: nvl(l_pow_band_end_date,hr_general.end_of_time)
2896: THEN
2897: --
2898: l_pow_extn_strt_dt := l_prjctd_end_dt + 1;
2899: --

Line 4809: g_refresh_end_date := hr_general.end_of_time;

4805: (p_mthd_action_id);
4806: --
4807: g_full_refresh := g_mthd_action_array.full_refresh_flag;
4808: g_refresh_start_date := g_mthd_action_array.collect_from_date;
4809: g_refresh_end_date := hr_general.end_of_time;
4810:
4811: -- Set FTE/HDC parameters from profiles
4812: IF (fnd_profile.value('HRI_COLLECT_FTE') = 'Y') THEN
4813: g_collect_fte := 'Y';

Line 5456: g_refresh_end_date := hr_general.end_of_time;

5452: --
5453: BEGIN
5454: --
5455: g_refresh_start_date := g_dbi_collection_start_date;
5456: g_refresh_end_date := hr_general.end_of_time;
5457: g_full_refresh := 'Y';
5458: g_collect_fte := 'N';
5459: g_collect_hdc := 'Y';
5460: g_perf_query := hri_bpl_perf_rating.get_perf_sql;

Line 5480: g_end_of_time := hr_general.end_of_time;

5476: --
5477: BEGIN
5478: --
5479: g_dbi_collection_start_date := bis_common_parameters.get_global_start_date;
5480: g_end_of_time := hr_general.end_of_time;
5481: --
5482: -- This profile is used for POW calculations.
5483: --
5484: g_adj_svc_profile := NVL(fnd_profile.value('HRI_POW_DT_STRT_SRC'),'STRT_DT');