DBA Data[Home] [Help]

APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_SAP_PKG

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

626:
627: if l_leave_type is null or l_leave_type = 'MA' then
628: ssp_SMP_pkg.SMP_control (each_maternity.maternity_id, l_deleting);
629: elsif l_leave_type ='AD' then
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);

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

1966: for r_affected_adoption in csr_affected_leave('AD') loop
1967: /* SAP Control call block */
1968: begin
1969: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);
1970: ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
1971: p_deleting => FALSE);
1972: l_adop_count := l_adop_count + 1;
1973: exception
1974: when others then

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

3286: /* SAP Control call block */
3287: begin
3288: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);
3289: --6800788 begin
3290: -- ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
3291: -- p_deleting => FALSE);
3292:
3293: DBMS_JOB.SUBMIT(l_job_no,'ssp_sap_pkg.sap_control('||r_affected_adoption.maternity_id||',FALSE);');
3294: l_adop_count := l_adop_count + 1;

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

3289: --6800788 begin
3290: -- ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
3291: -- p_deleting => FALSE);
3292:
3293: DBMS_JOB.SUBMIT(l_job_no,'ssp_sap_pkg.sap_control('||r_affected_adoption.maternity_id||',FALSE);');
3294: l_adop_count := l_adop_count + 1;
3295: l_count := l_count + 1;
3296: l_tbl_job(l_count).job_no := l_job_no;
3297: l_tbl_job(l_count).person_id := r_affected_adoption.person_id;