DBA Data[Home] [Help]

APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_PAD_PKG

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

587: ssp_SMP_pkg.SMP_control (each_maternity.maternity_id, l_deleting);
588: elsif l_leave_type ='AD' then
589: ssp_sap_pkg.sap_control (each_maternity.maternity_id, l_deleting);
590: elsif l_leave_type ='PA' then
591: ssp_pad_pkg.pad_control (each_maternity.maternity_id, l_deleting);
592: elsif l_leave_type ='PB' then
593: ssp_pab_pkg.pab_control (each_maternity.maternity_id, l_deleting);
594: end if;
595: --

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

1834: for r_affected_pat_adop in csr_affected_leave('PA') loop
1835: /* SPP Adoption Control call block */
1836: begin
1837: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
1838: ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
1839: p_deleting => FALSE);
1840: l_pat_adop_count := l_pat_adop_count + 1;
1841: exception
1842: when others then

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

2917: /* SPP Adoption Control call block */
2918: begin
2919: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
2920: --6800788 begin
2921: -- ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
2922: -- p_deleting => FALSE);
2923:
2924: DBMS_JOB.SUBMIT(l_job_no,'ssp_pad_pkg.pad_control('||r_affected_pat_adop.maternity_id||',FALSE);');
2925: l_pat_adop_count := l_pat_adop_count + 1;

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

2920: --6800788 begin
2921: -- ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
2922: -- p_deleting => FALSE);
2923:
2924: DBMS_JOB.SUBMIT(l_job_no,'ssp_pad_pkg.pad_control('||r_affected_pat_adop.maternity_id||',FALSE);');
2925: l_pat_adop_count := l_pat_adop_count + 1;
2926: l_count := l_count + 1;
2927: l_tbl_job(l_count).job_no := l_job_no;
2928: l_tbl_job(l_count).person_id := r_affected_pat_adop.person_id;