[Home] [Help]
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);
637: elsif l_leave_type ='AA' then -- Additional Paterntiy Pay Adoption
638: ssp_apad_pkg.apad_control (each_maternity.maternity_id, l_deleting);
2066: for r_affected_pat_Birth in csr_affected_leave('PB') loop
2067: /* SPP Birth Control call block */
2068: begin
2069: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
2070: ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
2071: p_deleting => FALSE);
2072: l_pat_Birth_count := l_pat_birth_count + 1;
2073: exception
2074: when others then
3415: /* SPP Birth Control call block */
3416: begin
3417: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
3418: --6800788 begin
3419: -- ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
3420: -- p_deleting => FALSE);
3421:
3422: DBMS_JOB.SUBMIT(l_job_no,'ssp_pab_pkg.pab_control('||r_affected_pat_Birth.maternity_id||',FALSE);');
3423: l_pat_Birth_count := l_pat_birth_count + 1;
3418: --6800788 begin
3419: -- ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
3420: -- p_deleting => FALSE);
3421:
3422: DBMS_JOB.SUBMIT(l_job_no,'ssp_pab_pkg.pab_control('||r_affected_pat_Birth.maternity_id||',FALSE);');
3423: l_pat_Birth_count := l_pat_birth_count + 1;
3424: l_count := l_count + 1;
3425: l_tbl_job(l_count).job_no := l_job_no;
3426: l_tbl_job(l_count).person_id := r_affected_pat_Birth.person_id;