APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_APAD_PKG

Line 638: ssp_apad_pkg.apad_control (each_maternity.maternity_id, l_deleting);

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);
637: elsif l_leave_type ='AA' then -- Additional Paterntiy Pay Adoption
638: ssp_apad_pkg.apad_control (each_maternity.maternity_id, l_deleting);
639: end if;
640: --
641: -- RT entries prob
642: --

Line 2125: ssp_apad_pkg.apad_control(p_maternity_id => r_affected_apat_adop.maternity_id,

2121: /* ASPP Adoption Control call block */
2122: begin
2123: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
2124:
2125: ssp_apad_pkg.apad_control(p_maternity_id => r_affected_apat_adop.maternity_id,
2126:
2127:
2128: p_deleting => FALSE);
2129: l_apad_count := l_apad_count + 1;

Line 3487: DBMS_JOB.SUBMIT(l_job_no,'ssp_apad_pkg.apad_control('||r_affected_apat_adop.maternity_id||',FALSE);');

3483: begin
3484: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
3485:
3486:
3487: DBMS_JOB.SUBMIT(l_job_no,'ssp_apad_pkg.apad_control('||r_affected_apat_adop.maternity_id||',FALSE);');
3488: l_apat_adop_count := l_apat_adop_count + 1;
3489: l_count := l_count + 1;
3490: l_tbl_job(l_count).job_no := l_job_no;
3491: l_tbl_job(l_count).person_id := r_affected_apat_adop.person_id;