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 542: -- Exclusion of duplicates now done in ssp_ssp_pkg.SSP-Control as

538: cursor csr_affected_PIWs is
539: --
540: -- Find all PIW IDs which have been inserted by row triggers
541: -- because a change to one of their SSP parameters occurred.
542: -- Exclusion of duplicates now done in ssp_ssp_pkg.SSP-Control as
543: -- the previous "not exists" did not work... the data is already
544: -- selected before they can be updated.
545: --
546: select tar1.PIW_id, nvl(tar1.locked,'NULL') locked

Line 578: if ssp_ssp_pkg.ssp_is_installed

574: BEGIN
575: --
576: hr_utility.set_location('Entering:'||l_proc,1);
577: --
578: if ssp_ssp_pkg.ssp_is_installed
579: then
580: if csr_affected_PIWs%IsOpen then
581: close csr_affected_PIWs;
582: end if;

Line 591: ssp_ssp_pkg.update_linked_absence_IDs;

587: --
588: -- Recalculate SSP for all PIWs affected by row inserts/updates/deletes
589: --
590: -- Make sure all the linked PIWs are correctly defined.
591: ssp_ssp_pkg.update_linked_absence_IDs;
592: --
593: for each_PIW in csr_affected_PIWs LOOP
594: hr_utility.trace (' Recalculate SSP for PIW #'||
595: to_char(each_PIW.PIW_ID));

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

599: update ssp_temp_affected_rows
600: set locked = 'Y'
601: where current of csr_affected_PIWs;
602: --
603: ssp_ssp_pkg.ssp_control(each_PIW.piw_id);
604: end if;
605: end loop;
606: --
607: -- Recalculate SMP for all maternities affected by inserts/updates/deletes

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

1845: begin
1846:
1847: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
1848:
1849: ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
1850:
1851: l_count := l_count + 1;
1852:
1853: exception

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

3145: begin
3146:
3147: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
3148: --6800788 begin
3149: --ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
3150: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');
3151: l_count := l_count + 1;
3152: l_tbl_job(l_count).job_no := l_job_no;
3153: l_tbl_job(l_count).person_id := r_affected_absences.person_id;

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

3146:
3147: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
3148: --6800788 begin
3149: --ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
3150: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');
3151: l_count := l_count + 1;
3152: l_tbl_job(l_count).job_no := l_job_no;
3153: l_tbl_job(l_count).person_id := r_affected_absences.person_id;
3154: l_tbl_job(l_count).absence_id := r_affected_absences.absence_id;