DBA Data[Home] [Help]

APPS.PQP_ABSVAL_PKG dependencies on HR_API

Line 4698: IF l_end_date = hr_api.g_eot THEN

4694: debug('l_end_date:');
4695: debug(l_end_date);
4696: END IF;
4697:
4698: IF l_end_date = hr_api.g_eot THEN
4699: -- this is the first day of No Pay
4700: l_proc_step := 95;
4701: IF g_debug THEN
4702: debug(l_proc_name, 95);

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

5030: END IF;
5031:
5032:
5033:
5034: l_absence_end_date := NVL(p_absence_date_end,hr_api.g_eot);
5035: --NVL(l_absence_dates.date_end,hr_api.g_eot);
5036:
5037: --IF p_absence_date_start IS NOT NULL THEN -- ie absence not deleted
5038:

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

5031:
5032:
5033:
5034: l_absence_end_date := NVL(p_absence_date_end,hr_api.g_eot);
5035: --NVL(l_absence_dates.date_end,hr_api.g_eot);
5036:
5037: --IF p_absence_date_start IS NOT NULL THEN -- ie absence not deleted
5038:
5039: l_proc_step := 31;

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

5049: IF g_debug THEN
5050: debug(l_proc_name, 32);
5051: END IF;
5052:
5053: IF l_absence_end_date = hr_api.g_eot -- if its an open ended absence
5054: THEN
5055:
5056: l_proc_step := 33;
5057: IF g_debug THEN

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

5116: END IF;
5117:
5118: CLOSE csr_first_entitled_day_of_band;
5119:
5120: END IF; -- IF l_absence_end_date = hr_api.g_eot
5121:
5122: l_proc_step := 40;
5123: IF g_debug THEN
5124: debug(l_proc_name, 40);

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

5494: l_generate_start_date :=
5495: GREATEST(p_create_start_date,p_absence_date_start);
5496: --
5497: l_generate_end_date :=
5498: LEAST(NVL(p_create_end_date,hr_api.g_eot),p_absence_date_end);
5499: --
5500: -- If daily absences exist for the given range for this plan then
5501: -- don't continue with the create process. Exit without error.
5502: -- This would happen in almost every absence, ie when the end