DBA Data[Home] [Help]

APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_SAP_PKG

Line 589: ssp_sap_pkg.sap_control (each_maternity.maternity_id, l_deleting);

585:
586: if l_leave_type is null or l_leave_type = 'MA' then
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);

Line 1788: ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,

1784: for r_affected_adoption in csr_affected_leave('AD') loop
1785: /* SAP Control call block */
1786: begin
1787: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);
1788: ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
1789: p_deleting => FALSE);
1790: l_adop_count := l_adop_count + 1;
1791: exception
1792: when others then

Line 2858: -- ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,

2854: /* SAP Control call block */
2855: begin
2856: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);
2857: --6800788 begin
2858: -- ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
2859: -- p_deleting => FALSE);
2860:
2861: DBMS_JOB.SUBMIT(l_job_no,'ssp_sap_pkg.sap_control('||r_affected_adoption.maternity_id||',FALSE);');
2862: l_adop_count := l_adop_count + 1;

Line 2861: DBMS_JOB.SUBMIT(l_job_no,'ssp_sap_pkg.sap_control('||r_affected_adoption.maternity_id||',FALSE);');

2857: --6800788 begin
2858: -- ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
2859: -- p_deleting => FALSE);
2860:
2861: DBMS_JOB.SUBMIT(l_job_no,'ssp_sap_pkg.sap_control('||r_affected_adoption.maternity_id||',FALSE);');
2862: l_adop_count := l_adop_count + 1;
2863: l_count := l_count + 1;
2864: l_tbl_job(l_count).job_no := l_job_no;
2865: l_tbl_job(l_count).person_id := r_affected_adoption.person_id;