APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_SSP_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 501: -- Exclusion of duplicates now done in ssp_ssp_pkg.SSP-Control as

497: cursor csr_affected_PIWs is
498: --
499: -- Find all PIW IDs which have been inserted by row triggers
500: -- because a change to one of their SSP parameters occurred.
501: -- Exclusion of duplicates now done in ssp_ssp_pkg.SSP-Control as
502: -- the previous "not exists" did not work... the data is already
503: -- selected before they can be updated.
504: --
505: select tar1.PIW_id, nvl(tar1.locked,'NULL') locked

Line 537: if ssp_ssp_pkg.ssp_is_installed

533: BEGIN
534: --
535: hr_utility.set_location('Entering:'||l_proc,1);
536: --
537: if ssp_ssp_pkg.ssp_is_installed
538: then
539: if csr_affected_PIWs%IsOpen then
540: close csr_affected_PIWs;
541: end if;

Line 550: ssp_ssp_pkg.update_linked_absence_IDs;

546: --
547: -- Recalculate SSP for all PIWs affected by row inserts/updates/deletes
548: --
549: -- Make sure all the linked PIWs are correctly defined.
550: ssp_ssp_pkg.update_linked_absence_IDs;
551: --
552: for each_PIW in csr_affected_PIWs LOOP
553: hr_utility.trace (' Recalculate SSP for PIW #'||
554: to_char(each_PIW.PIW_ID));

Line 562: ssp_ssp_pkg.ssp_control(each_PIW.piw_id);

558: update ssp_temp_affected_rows
559: set locked = 'Y'
560: where current of csr_affected_PIWs;
561: --
562: ssp_ssp_pkg.ssp_control(each_PIW.piw_id);
563: end if;
564: end loop;
565: --
566: -- Recalculate SMP for all maternities affected by inserts/updates/deletes

Line 1667: ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);

1663: begin
1664:
1665: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
1666:
1667: ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
1668:
1669: l_count := l_count + 1;
1670:
1671: exception

Line 2717: --ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);

2713: begin
2714:
2715: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
2716: --6800788 begin
2717: --ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
2718: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');
2719: l_count := l_count + 1;
2720: l_tbl_job(l_count).job_no := l_job_no;
2721: l_tbl_job(l_count).person_id := r_affected_absences.person_id;

Line 2718: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');

2714:
2715: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
2716: --6800788 begin
2717: --ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
2718: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');
2719: l_count := l_count + 1;
2720: l_tbl_job(l_count).job_no := l_job_no;
2721: l_tbl_job(l_count).person_id := r_affected_absences.person_id;
2722: l_tbl_job(l_count).absence_id := r_affected_absences.absence_id;