APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on SSP_SMP_PKG

Line 316: ssp_smp_pkg.earliest_MPP_start_date (due_date))

312: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
313: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
314: 'AB',ssp_apab_pkg.earliest_ASPPP_start_date(actual_birth_date),
315: 'AA',ssp_apad_pkg.earliest_ASPPP_start_date(placement_date),
316: ssp_smp_pkg.earliest_MPP_start_date (due_date))
317: earliest_MPP_start_date
318: from ssp_maternities
319: where maternity_id = p_maternity_id;
320: --

Line 395: ssp_smp_pkg.earliest_MPP_start_date (due_date))

391: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
392: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
393: 'AB',ssp_apab_pkg.earliest_ASPPP_start_date(actual_birth_date),
394: 'AA',ssp_apad_pkg.earliest_ASPPP_start_date(placement_date),
395: ssp_smp_pkg.earliest_MPP_start_date (due_date))
396: earliest_MPP_start_date,
397: ssp_smp_pkg.qualifying_week (due_date) QW,
398: nvl(mpp_start_date,hr_general.end_of_time) MPP,
399: person_id,

Line 397: ssp_smp_pkg.qualifying_week (due_date) QW,

393: 'AB',ssp_apab_pkg.earliest_ASPPP_start_date(actual_birth_date),
394: 'AA',ssp_apad_pkg.earliest_ASPPP_start_date(placement_date),
395: ssp_smp_pkg.earliest_MPP_start_date (due_date))
396: earliest_MPP_start_date,
397: ssp_smp_pkg.qualifying_week (due_date) QW,
398: nvl(mpp_start_date,hr_general.end_of_time) MPP,
399: person_id,
400: leave_type,
401: placement_date,

Line 2940: select ssp_smp_pkg.qualifying_week (mat.due_date) QW,

2936: --
2937: Procedure check_val_abs_start (p_date_start in date,
2938: p_maternity_id in number) is
2939: Cursor csr_maternity is
2940: select ssp_smp_pkg.qualifying_week (mat.due_date) QW,
2941: nvl(mat.mpp_start_date,hr_general.end_of_time) MPP,
2942: nvl(mat.leave_type,'MA') leave_type
2943: from ssp_maternities MAT
2944: where mat.maternity_id = p_maternity_id;

Line 3114: l_element_details ssp_SMP_pkg.csr_SMP_element_details%rowtype;

3110: p_date_start in date,
3111: p_effective_date in date,
3112: p_element_name in varchar2) return boolean is
3113:
3114: l_element_details ssp_SMP_pkg.csr_SMP_element_details%rowtype;
3115:
3116: BEGIN
3117: hr_utility.set_location
3118: ('per_absence_attendances_pkg.late_abs_notification',1);

Line 3119: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,

3115:
3116: BEGIN
3117: hr_utility.set_location
3118: ('per_absence_attendances_pkg.late_abs_notification',1);
3119: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
3120: p_element_name);
3121: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;
3122: close ssp_SMP_pkg.csr_SMP_element_details;
3123: if p_date_notification >

Line 3121: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;

3117: hr_utility.set_location
3118: ('per_absence_attendances_pkg.late_abs_notification',1);
3119: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
3120: p_element_name);
3121: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;
3122: close ssp_SMP_pkg.csr_SMP_element_details;
3123: if p_date_notification >
3124: (p_date_start -
3125: to_number(l_element_details.mpp_notice_requirement)) then

Line 3122: close ssp_SMP_pkg.csr_SMP_element_details;

3118: ('per_absence_attendances_pkg.late_abs_notification',1);
3119: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
3120: p_element_name);
3121: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;
3122: close ssp_SMP_pkg.csr_SMP_element_details;
3123: if p_date_notification >
3124: (p_date_start -
3125: to_number(l_element_details.mpp_notice_requirement)) then
3126: -- Added explicit number conversion above. Bug 3111653