APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_PAB_PKG

Line 593: ssp_pab_pkg.pab_control (each_maternity.maternity_id, l_deleting);

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: --
596: -- RT entries prob
597: --

Line 1888: ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,

1884: for r_affected_pat_Birth in csr_affected_leave('PB') loop
1885: /* SPP Birth Control call block */
1886: begin
1887: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
1888: ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
1889: p_deleting => FALSE);
1890: l_pat_Birth_count := l_pat_birth_count + 1;
1891: exception
1892: when others then

Line 2987: -- ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,

2983: /* SPP Birth Control call block */
2984: begin
2985: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
2986: --6800788 begin
2987: -- ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
2988: -- p_deleting => FALSE);
2989:
2990: DBMS_JOB.SUBMIT(l_job_no,'ssp_pab_pkg.pab_control('||r_affected_pat_Birth.maternity_id||',FALSE);');
2991: l_pat_Birth_count := l_pat_birth_count + 1;

Line 2990: DBMS_JOB.SUBMIT(l_job_no,'ssp_pab_pkg.pab_control('||r_affected_pat_Birth.maternity_id||',FALSE);');

2986: --6800788 begin
2987: -- ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
2988: -- p_deleting => FALSE);
2989:
2990: DBMS_JOB.SUBMIT(l_job_no,'ssp_pab_pkg.pab_control('||r_affected_pat_Birth.maternity_id||',FALSE);');
2991: l_pat_Birth_count := l_pat_birth_count + 1;
2992: l_count := l_count + 1;
2993: l_tbl_job(l_count).job_no := l_job_no;
2994: l_tbl_job(l_count).person_id := r_affected_pat_Birth.person_id;