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 628: ssp_SMP_pkg.SMP_control (each_maternity.maternity_id, l_deleting);

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

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

1914: for r_affected_maternities in csr_affected_leave('MA') loop
1915: /* SMP Control call block */
1916: begin
1917: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);
1918: ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
1919: p_deleting => FALSE);
1920: l_mat_count := l_mat_count + 1;
1921: exception
1922: when others then

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

3221: /* SMP Control call block */
3222: begin
3223: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);
3224: --6800788 begin
3225: -- ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
3226: -- p_deleting => FALSE);
3227:
3228: DBMS_JOB.SUBMIT(l_job_no,'ssp_smp_pkg.smp_control('||r_affected_maternities.maternity_id||',FALSE);');
3229: l_mat_count := l_mat_count + 1;

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

3224: --6800788 begin
3225: -- ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
3226: -- p_deleting => FALSE);
3227:
3228: DBMS_JOB.SUBMIT(l_job_no,'ssp_smp_pkg.smp_control('||r_affected_maternities.maternity_id||',FALSE);');
3229: l_mat_count := l_mat_count + 1;
3230: l_count := l_count + 1;
3231: l_tbl_job(l_count).job_no := l_job_no;
3232: l_tbl_job(l_count).person_id := r_affected_maternities.person_id;