eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SSP_SSP_PKG dependencies on SSP_SSP_PKG

Line 1: package body SSP_SSP_PKG as

1: package body SSP_SSP_PKG as
2: /* $Header: spsspapi.pkb 120.22 2011/09/23 05:57:05 pbalu ship $
3: +==============================================================================+
4: | Copyright (c) 1994 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 247: g_package constant varchar2 (31) := 'SSP_SSP_pkg.';

243: not resetting when used in OA Pages.
244: 115.62 23-Sep-11 12552547 PBALU Sickness absence should not be linked with absences taken in different period of service.
245: ===============================================================================
246: */
247: g_package constant varchar2 (31) := 'SSP_SSP_pkg.';
248: g_SSP_is_installed boolean;
249: g_SSP_legislation ssp_SSP_pkg.csr_SSP_element_details%rowtype;
250: g_SSP_correction ssp_SSP_pkg.csr_SSP_element_details%rowtype;
251: g_PIW_id number := null;

Line 249: g_SSP_legislation ssp_SSP_pkg.csr_SSP_element_details%rowtype;

245: ===============================================================================
246: */
247: g_package constant varchar2 (31) := 'SSP_SSP_pkg.';
248: g_SSP_is_installed boolean;
249: g_SSP_legislation ssp_SSP_pkg.csr_SSP_element_details%rowtype;
250: g_SSP_correction ssp_SSP_pkg.csr_SSP_element_details%rowtype;
251: g_PIW_id number := null;
252: g_absence_del varchar2(1) := 'N';
253: PIW_start_date date;

Line 250: g_SSP_correction ssp_SSP_pkg.csr_SSP_element_details%rowtype;

246: */
247: g_package constant varchar2 (31) := 'SSP_SSP_pkg.';
248: g_SSP_is_installed boolean;
249: g_SSP_legislation ssp_SSP_pkg.csr_SSP_element_details%rowtype;
250: g_SSP_correction ssp_SSP_pkg.csr_SSP_element_details%rowtype;
251: g_PIW_id number := null;
252: g_absence_del varchar2(1) := 'N';
253: PIW_start_date date;
254: PIW_end_date date;

Line 393: fnd_message.set_token ('PROCEDURE','ssp_ssp_pkg.get_absence_details');

389: -- The cursor unexpectedly returned no rows.
390: --
391: close csr_absence_details;
392: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token ('PROCEDURE','ssp_ssp_pkg.get_absence_details');
394: fnd_message.set_token ('STEP','1');
395: fnd_message.raise_error;
396: else
397: close csr_absence_details;

Line 465: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date);

461: then
462: --
463: -- If we have not already done so, do the following:
464: --
465: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date);
466: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_legislation;
467: close ssp_SSP_pkg.csr_SSP_element_details;
468: end if;
469: --

Line 466: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_legislation;

462: --
463: -- If we have not already done so, do the following:
464: --
465: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date);
466: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_legislation;
467: close ssp_SSP_pkg.csr_SSP_element_details;
468: end if;
469: --
470: /* Commented out to comply with pragma

Line 467: close ssp_SSP_pkg.csr_SSP_element_details;

463: -- If we have not already done so, do the following:
464: --
465: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date);
466: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_legislation;
467: close ssp_SSP_pkg.csr_SSP_element_details;
468: end if;
469: --
470: /* Commented out to comply with pragma
471: -- Check element returned expected values (this is belt and braces checking

Line 557: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date,

553: --
554: -- If we have not already done so, do the following:
555: --
556: hr_utility.set_location(l_proc,3);
557: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date,
558: c_SSP_correction_element_name);
559: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_correction;
560: close ssp_SSP_pkg.csr_SSP_element_details;
561: end if;

Line 559: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_correction;

555: --
556: hr_utility.set_location(l_proc,3);
557: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date,
558: c_SSP_correction_element_name);
559: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_correction;
560: close ssp_SSP_pkg.csr_SSP_element_details;
561: end if;
562: hr_utility.trace(l_proc||' g_SSP_correction.element_type_id :'||g_SSP_correction.element_type_id);
563: hr_utility.trace(l_proc||' g_SSP_correction.effective_start_date :'||g_SSP_correction.effective_start_date);

Line 560: close ssp_SSP_pkg.csr_SSP_element_details;

556: hr_utility.set_location(l_proc,3);
557: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date,
558: c_SSP_correction_element_name);
559: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_correction;
560: close ssp_SSP_pkg.csr_SSP_element_details;
561: end if;
562: hr_utility.trace(l_proc||' g_SSP_correction.element_type_id :'||g_SSP_correction.element_type_id);
563: hr_utility.trace(l_proc||' g_SSP_correction.effective_start_date :'||g_SSP_correction.effective_start_date);
564: hr_utility.trace(l_proc||' g_SSP_correction.effective_end_date :'||g_SSP_correction.effective_end_date);

Line 669: l_new_linked_absence_id := ssp_ssp_pkg.linked_absence_id (

665: -- For each absence affected by the current transaction, check that it has
666: -- the correct linked_absence_id.
667: --
668: -- Get the linked_absence_id the absence SHOULD have.
669: l_new_linked_absence_id := ssp_ssp_pkg.linked_absence_id (
670: new_link.person_id,
671: new_link.sickness_start_date,
672: new_link.sickness_end_date);
673: --

Line 767: l_PIW_start := (ssp_ssp_pkg.linked_PIW_start_date(p_person_id => p_person_id,

763: -- Return null as no linked absence is possible.
764: l_PIW_id := null;
765: else
766: -- Get the absence_attendance_id of the first PIW in the series
767: l_PIW_start := (ssp_ssp_pkg.linked_PIW_start_date(p_person_id => p_person_id,
768: p_sickness_start_date => p_sickness_start_date,
769: p_sickness_end_date => p_sickness_end_date));
770: -- if there is a PIW start date
771: -- and the PIW start date is not the start date for the current absence

Line 1393: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,

1389: if p_sickness_start_date is not null then
1390: --
1391: -- This is a sickness absence
1392: --
1393: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1394: p_sickness_start_date => p_sickness_start_date,
1395: p_sickness_end_date => p_sickness_end_date) then
1396: -- The current absence is a PIW
1397: --

Line 1409: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,

1405: -----------------------------------------
1406: if l_age < 16 and p_sickness_start_date >= l_01_October_06 then
1407: for preceeding in PIW_series(l_01_October_06) LOOP
1408: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1409: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1410: p_sickness_end_date => preceeding.sickness_end_date,
1411: p_person_id => p_person_id) then
1412: --
1413: -- The previous absence links to the current one

Line 1432: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,

1428: ---------------
1429: if (l_age >= 16) or (p_sickness_start_date < l_01_October_06) then
1430: for preceeding in PIW_series(null) LOOP
1431: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1432: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1433: p_sickness_end_date => preceeding.sickness_end_date,
1434: p_person_id => p_person_id) then
1435: --
1436: -- The previous absence links to the current one

Line 1516: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,

1512: if p_sickness_start_date is not null then
1513: --
1514: -- This is a sickness absence
1515: --
1516: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1517: p_sickness_start_date => p_sickness_start_date,
1518: p_sickness_end_date => p_sickness_end_date) then
1519: -- The current absence is a PIW
1520: --

Line 1538: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,

1534: -----------------------------------------
1535: if l_age < 16 and p_sickness_start_date >= l_01_October_06 then
1536: for preceeding in PIW_series(l_01_October_06) LOOP
1537: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1538: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1539: p_sickness_end_date => preceeding.sickness_end_date,
1540: p_person_id => p_person_id) then
1541: --
1542: -- The previous absence links to the current one

Line 1561: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,

1557: ---------------
1558: if (l_age >= 16) or (p_sickness_start_date < l_01_October_06) then
1559: for preceeding in PIW_series(null) LOOP
1560: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1561: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1562: p_sickness_end_date => preceeding.sickness_end_date,
1563: p_person_id => p_person_id) then
1564: --
1565: -- The previous absence links to the current one

Line 1651: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,

1647: if p_sickness_start_date is not null then
1648: --
1649: -- This is a sickness absence
1650: --
1651: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1652: p_sickness_start_date => p_sickness_start_date,
1653: p_sickness_end_date => p_sickness_end_date,
1654: p_absence_attendance_id => p_absence_attendance_id) then
1655: -- The current absence is a PIW

Line 1673: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,

1669: -----------------------------------------
1670: if l_age < 16 and p_sickness_start_date >= l_01_October_06 then
1671: for preceeding in PIW_series(l_01_October_06) LOOP
1672: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1673: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1674: p_sickness_end_date => preceeding.sickness_end_date,
1675: p_person_id => p_person_id,
1676: p_absence_attendance_id => preceeding.absence_attendance_id) then
1677: --

Line 1697: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,

1693: ---------------
1694: if (l_age >= 16) or (p_sickness_start_date < l_01_October_06) then
1695: for preceeding in PIW_series(null) LOOP
1696: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1697: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1698: p_sickness_end_date => preceeding.sickness_end_date,
1699: p_person_id => p_person_id,
1700: p_absence_attendance_id => preceeding.absence_attendance_id) then
1701: --

Line 1750: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,

1746: begin
1747: if (p_sickness_start_date is null or p_sickness_end_date is null) then
1748: PIW_end := null;
1749: else
1750: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1751: p_sickness_start_date => p_sickness_start_date,
1752: p_sickness_end_date => p_sickness_end_date) then
1753: PIW_end := p_sickness_end_date;
1754: --

Line 1768: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,

1764: for next in PIW_series(l_limit_date) LOOP
1765: -- if the next sickness period links to the current one
1766: -- and the next sickness period is a PIW
1767: if (next.sickness_start_date - PIW_end) <= g_SSP_legislation.linking_period_days and
1768: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,
1769: p_sickness_start_date => next.sickness_start_date,
1770: p_sickness_end_date => next.sickness_end_date)then
1771: --
1772: -- Increment the end date to that of the next sickness period

Line 1815: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,

1811: begin
1812: if (p_sickness_start_date is null or p_sickness_end_date is null) then
1813: PIW_end := null;
1814: else
1815: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1816: p_sickness_start_date => p_sickness_start_date,
1817: p_sickness_end_date => p_sickness_end_date) then
1818: PIW_end := p_sickness_end_date;
1819: --

Line 1834: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,

1830: for next in PIW_series(l_limit_date) LOOP
1831: -- if the next sickness period links to the current one
1832: -- and the next sickness period is a PIW
1833: if (next.sickness_start_date - PIW_end) <= g_SSP_legislation.linking_period_days and
1834: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,
1835: p_sickness_start_date => next.sickness_start_date,
1836: p_sickness_end_date => next.sickness_end_date)then
1837: --
1838: -- Increment the end date to that of the next sickness period

Line 1884: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,

1880: begin
1881: if (p_sickness_start_date is null or p_sickness_end_date is null) then
1882: PIW_end := null;
1883: else
1884: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1885: p_sickness_start_date => p_sickness_start_date,
1886: p_sickness_end_date => p_sickness_end_date,
1887: p_absence_attendance_id => p_absence_attendance_id) then
1888: PIW_end := p_sickness_end_date;

Line 1904: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,

1900: for next in PIW_series(l_limit_date) LOOP
1901: -- if the next sickness period links to the current one
1902: -- and the next sickness period is a PIW
1903: if (next.sickness_start_date - PIW_end) <= g_SSP_legislation.linking_period_days and
1904: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,
1905: p_sickness_start_date => next.sickness_start_date,
1906: p_sickness_end_date => next.sickness_end_date,
1907: p_absence_attendance_id => next.absence_attendance_id)then
1908: --

Line 3039: if ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_absence.person_id,

3035: hr_utility.trace(' for sickness dated: ' ||
3036: to_char(l_sickness_start_date) || ' -> ' ||
3037: to_char(l_sickness_end_date));
3038: --
3039: if ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_absence.person_id,
3040: p_sickness_start_date => l_sickness_start_date,
3041: p_sickness_end_date => l_sickness_end_date,
3042: p_absence_attendance_id => l_absence_attendance_id) then
3043: --

Line 4531: end ssp_SSP_pkg;

4527: hr_utility.set_location('Leaving :'||l_proc,100);
4528: --
4529: end SSP_control;
4530: --------------------------------------------------------------------------------
4531: end ssp_SSP_pkg;