DBA Data[Home] [Help]

APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_APAB_PKG

Line 636: ssp_apab_pkg.apab_control (each_maternity.maternity_id, l_deleting);

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);
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: --

Line 2181: ssp_apab_pkg.apab_control(p_maternity_id => r_affected_apat_birth.maternity_id,

2177: /* ASPP Adoption Control call block */
2178: begin
2179: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
2180:
2181: ssp_apab_pkg.apab_control(p_maternity_id => r_affected_apat_birth.maternity_id,
2182: p_deleting => FALSE);
2183: l_apab_count := l_apab_count + 1;
2184:
2185: exception

Line 3547: DBMS_JOB.SUBMIT(l_job_no,'ssp_apab_pkg.apab_control('||r_affected_apat_birth.maternity_id||',FALSE);');

3543: /* ASPP Adoption Control call block */
3544: begin
3545: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
3546:
3547: DBMS_JOB.SUBMIT(l_job_no,'ssp_apab_pkg.apab_control('||r_affected_apat_birth.maternity_id||',FALSE);');
3548: l_apat_birth_count := l_apat_birth_count + 1;
3549: l_count := l_count + 1;
3550: l_tbl_job(l_count).job_no := l_job_no;
3551: l_tbl_job(l_count).person_id := r_affected_apat_birth.person_id;