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.18.12010000.2 2008/10/08 06:26:51 pbalu ship $
3: +==============================================================================+
4: | Copyright (c) 1994 Oracle Corporation |
5: | Redwood Shores, California, USA |

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

237: 115.58 19-Sep-08 6860926 EMUNISEK Changed the less than zero condition on weeks_remaining to
238: account for the rounding error of decimal values
239: ===============================================================================
240: */
241: g_package constant varchar2 (31) := 'SSP_SSP_pkg.';
242: g_SSP_is_installed boolean;
243: g_SSP_legislation ssp_SSP_pkg.csr_SSP_element_details%rowtype;
244: g_SSP_correction ssp_SSP_pkg.csr_SSP_element_details%rowtype;
245: g_PIW_id number := null;

Line 243: g_SSP_legislation ssp_SSP_pkg.csr_SSP_element_details%rowtype;

239: ===============================================================================
240: */
241: g_package constant varchar2 (31) := 'SSP_SSP_pkg.';
242: g_SSP_is_installed boolean;
243: g_SSP_legislation ssp_SSP_pkg.csr_SSP_element_details%rowtype;
244: g_SSP_correction ssp_SSP_pkg.csr_SSP_element_details%rowtype;
245: g_PIW_id number := null;
246: g_absence_del varchar2(1) := 'N';
247: PIW_start_date date;

Line 244: g_SSP_correction ssp_SSP_pkg.csr_SSP_element_details%rowtype;

240: */
241: g_package constant varchar2 (31) := 'SSP_SSP_pkg.';
242: g_SSP_is_installed boolean;
243: g_SSP_legislation ssp_SSP_pkg.csr_SSP_element_details%rowtype;
244: g_SSP_correction ssp_SSP_pkg.csr_SSP_element_details%rowtype;
245: g_PIW_id number := null;
246: g_absence_del varchar2(1) := 'N';
247: PIW_start_date date;
248: PIW_end_date date;

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

376: -- The cursor unexpectedly returned no rows.
377: --
378: close csr_absence_details;
379: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
380: fnd_message.set_token ('PROCEDURE','ssp_ssp_pkg.get_absence_details');
381: fnd_message.set_token ('STEP','1');
382: fnd_message.raise_error;
383: else
384: close csr_absence_details;

Line 452: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date);

448: then
449: --
450: -- If we have not already done so, do the following:
451: --
452: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date);
453: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_legislation;
454: close ssp_SSP_pkg.csr_SSP_element_details;
455: end if;
456: --

Line 453: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_legislation;

449: --
450: -- If we have not already done so, do the following:
451: --
452: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date);
453: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_legislation;
454: close ssp_SSP_pkg.csr_SSP_element_details;
455: end if;
456: --
457: /* Commented out to comply with pragma

Line 454: close ssp_SSP_pkg.csr_SSP_element_details;

450: -- If we have not already done so, do the following:
451: --
452: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date);
453: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_legislation;
454: close ssp_SSP_pkg.csr_SSP_element_details;
455: end if;
456: --
457: /* Commented out to comply with pragma
458: -- Check element returned expected values (this is belt and braces checking

Line 542: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date,

538: then
539: --
540: -- If we have not already done so, do the following:
541: --
542: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date,
543: c_SSP_correction_element_name);
544: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_correction;
545: close ssp_SSP_pkg.csr_SSP_element_details;
546: end if;

Line 544: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_correction;

540: -- If we have not already done so, do the following:
541: --
542: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date,
543: c_SSP_correction_element_name);
544: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_correction;
545: close ssp_SSP_pkg.csr_SSP_element_details;
546: end if;
547: --
548: -- Check element returned expected values (this is belt and braces checking,

Line 545: close ssp_SSP_pkg.csr_SSP_element_details;

541: --
542: open ssp_SSP_pkg.csr_SSP_element_details (p_effective_date,
543: c_SSP_correction_element_name);
544: fetch ssp_SSP_pkg.csr_SSP_element_details into g_SSP_correction;
545: close ssp_SSP_pkg.csr_SSP_element_details;
546: end if;
547: --
548: -- Check element returned expected values (this is belt and braces checking,
549: -- if the check fails then it was seed data which has been incorrectly set up.

Line 634: l_new_linked_absence_id := ssp_ssp_pkg.linked_absence_id (

630: -- For each absence affected by the current transaction, check that it has
631: -- the correct linked_absence_id.
632: --
633: -- Get the linked_absence_id the absence SHOULD have.
634: l_new_linked_absence_id := ssp_ssp_pkg.linked_absence_id (
635: new_link.person_id,
636: new_link.sickness_start_date,
637: new_link.sickness_end_date);
638: --

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

728: -- Return null as no linked absence is possible.
729: l_PIW_id := null;
730: else
731: -- Get the absence_attendance_id of the first PIW in the series
732: l_PIW_start := (ssp_ssp_pkg.linked_PIW_start_date(p_person_id => p_person_id,
733: p_sickness_start_date => p_sickness_start_date,
734: p_sickness_end_date => p_sickness_end_date));
735: -- if there is a PIW start date
736: -- and the PIW start date is not the start date for the current absence

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

1354: if p_sickness_start_date is not null then
1355: --
1356: -- This is a sickness absence
1357: --
1358: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1359: p_sickness_start_date => p_sickness_start_date,
1360: p_sickness_end_date => p_sickness_end_date) then
1361: -- The current absence is a PIW
1362: --

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

1370: -----------------------------------------
1371: if l_age < 16 and p_sickness_start_date >= l_01_October_06 then
1372: for preceeding in PIW_series(l_01_October_06) LOOP
1373: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1374: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1375: p_sickness_end_date => preceeding.sickness_end_date,
1376: p_person_id => p_person_id) then
1377: --
1378: -- The previous absence links to the current one

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

1393: ---------------
1394: if (l_age >= 16) or (p_sickness_start_date < l_01_October_06) then
1395: for preceeding in PIW_series(null) LOOP
1396: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1397: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1398: p_sickness_end_date => preceeding.sickness_end_date,
1399: p_person_id => p_person_id) then
1400: --
1401: -- The previous absence links to the current one

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

1449: if p_sickness_start_date is not null then
1450: --
1451: -- This is a sickness absence
1452: --
1453: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1454: p_sickness_start_date => p_sickness_start_date,
1455: p_sickness_end_date => p_sickness_end_date) then
1456: -- The current absence is a PIW
1457: --

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

1465: -----------------------------------------
1466: if l_age < 16 and p_sickness_start_date >= l_01_October_06 then
1467: for preceeding in PIW_series(l_01_October_06) LOOP
1468: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1469: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1470: p_sickness_end_date => preceeding.sickness_end_date,
1471: p_person_id => p_person_id) then
1472: --
1473: -- The previous absence links to the current one

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

1488: ---------------
1489: if (l_age >= 16) or (p_sickness_start_date < l_01_October_06) then
1490: for preceeding in PIW_series(null) LOOP
1491: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1492: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1493: p_sickness_end_date => preceeding.sickness_end_date,
1494: p_person_id => p_person_id) then
1495: --
1496: -- The previous absence links to the current one

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

1546: if p_sickness_start_date is not null then
1547: --
1548: -- This is a sickness absence
1549: --
1550: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1551: p_sickness_start_date => p_sickness_start_date,
1552: p_sickness_end_date => p_sickness_end_date,
1553: p_absence_attendance_id => p_absence_attendance_id) then
1554: -- The current absence is a PIW

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

1563: -----------------------------------------
1564: if l_age < 16 and p_sickness_start_date >= l_01_October_06 then
1565: for preceeding in PIW_series(l_01_October_06) LOOP
1566: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1567: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1568: p_sickness_end_date => preceeding.sickness_end_date,
1569: p_person_id => p_person_id,
1570: p_absence_attendance_id => preceeding.absence_attendance_id) then
1571: --

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

1587: ---------------
1588: if (l_age >= 16) or (p_sickness_start_date < l_01_October_06) then
1589: for preceeding in PIW_series(null) LOOP
1590: if (PIW_start - preceeding.sickness_end_date) <= g_SSP_legislation.linking_period_days and
1591: ssp_ssp_pkg.absence_is_a_PIW(p_sickness_start_date => preceeding.sickness_start_date,
1592: p_sickness_end_date => preceeding.sickness_end_date,
1593: p_person_id => p_person_id,
1594: p_absence_attendance_id => preceeding.absence_attendance_id) then
1595: --

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

1640: begin
1641: if (p_sickness_start_date is null or p_sickness_end_date is null) then
1642: PIW_end := null;
1643: else
1644: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1645: p_sickness_start_date => p_sickness_start_date,
1646: p_sickness_end_date => p_sickness_end_date) then
1647: PIW_end := p_sickness_end_date;
1648: --

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

1658: for next in PIW_series(l_limit_date) LOOP
1659: -- if the next sickness period links to the current one
1660: -- and the next sickness period is a PIW
1661: if (next.sickness_start_date - PIW_end) <= g_SSP_legislation.linking_period_days and
1662: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,
1663: p_sickness_start_date => next.sickness_start_date,
1664: p_sickness_end_date => next.sickness_end_date)then
1665: --
1666: -- Increment the end date to that of the next sickness period

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

1705: begin
1706: if (p_sickness_start_date is null or p_sickness_end_date is null) then
1707: PIW_end := null;
1708: else
1709: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1710: p_sickness_start_date => p_sickness_start_date,
1711: p_sickness_end_date => p_sickness_end_date) then
1712: PIW_end := p_sickness_end_date;
1713: --

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

1724: for next in PIW_series(l_limit_date) LOOP
1725: -- if the next sickness period links to the current one
1726: -- and the next sickness period is a PIW
1727: if (next.sickness_start_date - PIW_end) <= g_SSP_legislation.linking_period_days and
1728: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,
1729: p_sickness_start_date => next.sickness_start_date,
1730: p_sickness_end_date => next.sickness_end_date)then
1731: --
1732: -- Increment the end date to that of the next sickness period

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

1774: begin
1775: if (p_sickness_start_date is null or p_sickness_end_date is null) then
1776: PIW_end := null;
1777: else
1778: if ssp_ssp_pkg.absence_is_a_PIW(p_person_id => p_person_id,
1779: p_sickness_start_date => p_sickness_start_date,
1780: p_sickness_end_date => p_sickness_end_date,
1781: p_absence_attendance_id => p_absence_attendance_id) then
1782: PIW_end := p_sickness_end_date;

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

1794: for next in PIW_series(l_limit_date) LOOP
1795: -- if the next sickness period links to the current one
1796: -- and the next sickness period is a PIW
1797: if (next.sickness_start_date - PIW_end) <= g_SSP_legislation.linking_period_days and
1798: ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_person_id,
1799: p_sickness_start_date => next.sickness_start_date,
1800: p_sickness_end_date => next.sickness_end_date,
1801: p_absence_attendance_id => next.absence_attendance_id)then
1802: --

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

2921: hr_utility.trace(' for sickness dated: ' ||
2922: to_char(l_sickness_start_date) || ' -> ' ||
2923: to_char(l_sickness_end_date));
2924: --
2925: if ssp_ssp_pkg.absence_is_a_PIW (p_person_id => p_absence.person_id,
2926: p_sickness_start_date => l_sickness_start_date,
2927: p_sickness_end_date => l_sickness_end_date,
2928: p_absence_attendance_id => l_absence_attendance_id) then
2929: --

Line 4392: end ssp_SSP_pkg;

4388: hr_utility.set_location('Leaving :'||l_proc,100);
4389: --
4390: end SSP_control;
4391: --------------------------------------------------------------------------------
4392: end ssp_SSP_pkg;