DBA Data[Home] [Help]

APPS.PQP_ABSVAL_PKG dependencies on HR_API

Line 4726: IF l_end_date = hr_api.g_eot THEN

4722: debug('l_end_date:');
4723: debug(l_end_date);
4724: END IF;
4725:
4726: IF l_end_date = hr_api.g_eot THEN
4727: -- this is the first day of No Pay
4728: l_proc_step := 95;
4729: IF g_debug THEN
4730: debug(l_proc_name, 95);

Line 5062: l_absence_end_date := NVL(p_absence_date_end,hr_api.g_eot);

5058: END IF;
5059:
5060:
5061:
5062: l_absence_end_date := NVL(p_absence_date_end,hr_api.g_eot);
5063: --NVL(l_absence_dates.date_end,hr_api.g_eot);
5064:
5065: --IF p_absence_date_start IS NOT NULL THEN -- ie absence not deleted
5066:

Line 5063: --NVL(l_absence_dates.date_end,hr_api.g_eot);

5059:
5060:
5061:
5062: l_absence_end_date := NVL(p_absence_date_end,hr_api.g_eot);
5063: --NVL(l_absence_dates.date_end,hr_api.g_eot);
5064:
5065: --IF p_absence_date_start IS NOT NULL THEN -- ie absence not deleted
5066:
5067: l_proc_step := 31;

Line 5081: IF l_absence_end_date = hr_api.g_eot -- if its an open ended absence

5077: IF g_debug THEN
5078: debug(l_proc_name, 32);
5079: END IF;
5080:
5081: IF l_absence_end_date = hr_api.g_eot -- if its an open ended absence
5082: THEN
5083:
5084: l_proc_step := 33;
5085: IF g_debug THEN

Line 5148: END IF; -- IF l_absence_end_date = hr_api.g_eot

5144: END IF;
5145:
5146: CLOSE csr_first_entitled_day_of_band;
5147:
5148: END IF; -- IF l_absence_end_date = hr_api.g_eot
5149:
5150: l_proc_step := 40;
5151: IF g_debug THEN
5152: debug(l_proc_name, 40);

Line 5526: LEAST(NVL(p_create_end_date,hr_api.g_eot),p_absence_date_end);

5522: l_generate_start_date :=
5523: GREATEST(p_create_start_date,p_absence_date_start);
5524: --
5525: l_generate_end_date :=
5526: LEAST(NVL(p_create_end_date,hr_api.g_eot),p_absence_date_end);
5527: --
5528: -- If daily absences exist for the given range for this plan then
5529: -- don't continue with the create process. Exit without error.
5530: -- This would happen in almost every absence, ie when the end