DBA Data[Home] [Help]

APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_PAD_PKG

Line 632: ssp_pad_pkg.pad_control (each_maternity.maternity_id, l_deleting);

628: ssp_SMP_pkg.SMP_control (each_maternity.maternity_id, l_deleting);
629: elsif l_leave_type ='AD' then
630: ssp_sap_pkg.sap_control (each_maternity.maternity_id, l_deleting);
631: elsif l_leave_type ='PA' then
632: ssp_pad_pkg.pad_control (each_maternity.maternity_id, l_deleting);
633: elsif l_leave_type ='PB' then
634: ssp_pab_pkg.pab_control (each_maternity.maternity_id, l_deleting);
635: elsif l_leave_type ='AB' then -- Additional Paterntiy Pay Birth
636: ssp_apab_pkg.apab_control (each_maternity.maternity_id, l_deleting);

Line 2020: ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,

2016: for r_affected_pat_adop in csr_affected_leave('PA') loop
2017: /* SPP Adoption Control call block */
2018: begin
2019: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
2020: ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
2021: p_deleting => FALSE);
2022: l_pat_adop_count := l_pat_adop_count + 1;
2023: exception
2024: when others then

Line 3353: -- ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,

3349: /* SPP Adoption Control call block */
3350: begin
3351: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
3352: --6800788 begin
3353: -- ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
3354: -- p_deleting => FALSE);
3355:
3356: DBMS_JOB.SUBMIT(l_job_no,'ssp_pad_pkg.pad_control('||r_affected_pat_adop.maternity_id||',FALSE);');
3357: l_pat_adop_count := l_pat_adop_count + 1;

Line 3356: DBMS_JOB.SUBMIT(l_job_no,'ssp_pad_pkg.pad_control('||r_affected_pat_adop.maternity_id||',FALSE);');

3352: --6800788 begin
3353: -- ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
3354: -- p_deleting => FALSE);
3355:
3356: DBMS_JOB.SUBMIT(l_job_no,'ssp_pad_pkg.pad_control('||r_affected_pat_adop.maternity_id||',FALSE);');
3357: l_pat_adop_count := l_pat_adop_count + 1;
3358: l_count := l_count + 1;
3359: l_tbl_job(l_count).job_no := l_job_no;
3360: l_tbl_job(l_count).person_id := r_affected_pat_adop.person_id;