APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_SMP_PKG

Line 48: SSP_SSP_PKG/SSP_SMP_PKG on the actual

44: 24-Mar-98 RThirlby 563202 30.25 Performance fix to csr_stoppage.
45: 19-AUG-98 A.Myers 701750 30.26 Amended cursors for affected rows, as
46: the "where not exists" did not work.
47: This existence checking is now done in
48: SSP_SSP_PKG/SSP_SMP_PKG on the actual
49: row insert. Added p_deleting to SMP call
50: to SMP_control.
51: 06-JAN-2000 ILeath 30.27/ Add call to stop_if_director and
52: 110.7 check_payroll_installed within

Line 587: ssp_SMP_pkg.SMP_control (each_maternity.maternity_id, l_deleting);

583: fetch csr_leave_type into l_leave_type;
584: close csr_leave_type;
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);

Line 1736: ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,

1732: for r_affected_maternities in csr_affected_leave('MA') loop
1733: /* SMP Control call block */
1734: begin
1735: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);
1736: ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
1737: p_deleting => FALSE);
1738: l_mat_count := l_mat_count + 1;
1739: exception
1740: when others then

Line 2793: -- ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,

2789: /* SMP Control call block */
2790: begin
2791: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);
2792: --6800788 begin
2793: -- ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
2794: -- p_deleting => FALSE);
2795:
2796: DBMS_JOB.SUBMIT(l_job_no,'ssp_smp_pkg.smp_control('||r_affected_maternities.maternity_id||',FALSE);');
2797: l_mat_count := l_mat_count + 1;

Line 2796: DBMS_JOB.SUBMIT(l_job_no,'ssp_smp_pkg.smp_control('||r_affected_maternities.maternity_id||',FALSE);');

2792: --6800788 begin
2793: -- ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
2794: -- p_deleting => FALSE);
2795:
2796: DBMS_JOB.SUBMIT(l_job_no,'ssp_smp_pkg.smp_control('||r_affected_maternities.maternity_id||',FALSE);');
2797: l_mat_count := l_mat_count + 1;
2798: l_count := l_count + 1;
2799: l_tbl_job(l_count).job_no := l_job_no;
2800: l_tbl_job(l_count).person_id := r_affected_maternities.person_id;