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_SMP_PKG dependencies on SSP_SMP_PKG

Line 1: package body SSP_SMP_PKG as

1: package body SSP_SMP_PKG as
2: /*$Header: spsmpapi.pkb 120.13 2011/09/12 15:03:17 npannamp ship $
3: +==============================================================================+
4: | Copyright (c) 1994 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 183: g_package varchar2(33) := ' ssp_smp_pkg.'; -- Global package name

179: 20-May-2009 npannamp 115.38 12949461 check_average_earnings procedure modified to get
180: NI Lel value as on QW + 6 instead of as on QW.
181: */
182: --------------------------------------------------------------------------------
183: g_package varchar2(33) := ' ssp_smp_pkg.'; -- Global package name
184: --
185: cursor csr_absence_details (p_maternity_id in number) is
186: --
187: -- Get details of maternity leave for a maternity, in chronological

Line 206: ssp_smp_pkg.qualifying_week (due_date) QW,

202: -- Get details of the maternal woman
203: --
204: select maternity.person_id,
205: maternity.due_date,
206: ssp_smp_pkg.qualifying_week (due_date) QW,
207: ssp_smp_pkg.expected_week_of_confinement (due_date) EWC,
208: maternity.maternity_id,
209: maternity.actual_birth_date,
210: maternity.live_birth_flag,

Line 207: ssp_smp_pkg.expected_week_of_confinement (due_date) EWC,

203: --
204: select maternity.person_id,
205: maternity.due_date,
206: ssp_smp_pkg.qualifying_week (due_date) QW,
207: ssp_smp_pkg.expected_week_of_confinement (due_date) EWC,
208: maternity.maternity_id,
209: maternity.actual_birth_date,
210: maternity.live_birth_flag,
211: maternity.start_date_with_new_employer,

Line 672: and ssp_smp_pkg.continuous_employment_date(woman.due_date) >=

668: -- 5210118 starts
669: select 1
670: from per_periods_of_service
671: where person_id = woman.person_id
672: and ssp_smp_pkg.continuous_employment_date(woman.due_date) >=
673: (select max(date_start)
674: from per_periods_of_service
675: where person_id = woman.person_id
676: );

Line 718: and ssp_smp_pkg.continuous_employment_date(woman.due_date)

714: select nvl(ser.actual_termination_date, hr_general.end_of_time) termination_date
715: ,leaving_reason leaving_reason
716: from per_periods_of_service ser
717: where ser.person_id = woman.person_id
718: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
719: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
720: --
721: l_proc varchar2(72) := g_package||'check_employment_qw';
722: l_termination_date per_periods_of_service.actual_termination_date%type;

Line 777: ,ssp_smp_pkg.earliest_mpp_start_date(woman.due_date)) )

773: hr_utility.set_location(l_proc,5);
774: if (l_termination_date
775: between woman.qw
776: and nvl(woman.MPP_start_date
777: ,ssp_smp_pkg.earliest_mpp_start_date(woman.due_date)) )
778: and
779: (l_leaving_reason <> 'MATERNITY')
780: then
781: hr_utility.set_location(l_proc,6);

Line 889: ,ssp_smp_pkg.earliest_mpp_start_date

885: mpp_pay_period_end date;
886: current_mpp_period number := 126;
887: new_mpp_period number := 182;
888: mpp_start_date date := nvl(woman.MPP_start_date
889: ,ssp_smp_pkg.earliest_mpp_start_date
890: (woman.due_date));
891: -- Bug 2663899 End
892: cursor csr_get_week_day is
893: select to_char(mpp_start_date,'DAY')

Line 1175: hr_utility.set_location ('ssp_smp_pkg.entitled_to_SMP',2);

1171: --
1172: -- Having established a prima facia entitlement to SMP, perform checks which
1173: -- may lead to creation of stoppages for particular periods.
1174: --
1175: hr_utility.set_location ('ssp_smp_pkg.entitled_to_SMP',2);
1176: --
1177: -- Get the SMP legislative parameters.
1178: --
1179: get_SMP_element (woman.due_date);

Line 1227: hr_utility.set_location ('ssp_smp_pkg.entitled_to_SMP',3);

1223: p_withhold_from => woman.MPP_start_date,
1224: p_reason => 'Late absence notification');
1225: end if;
1226: --
1227: hr_utility.set_location ('ssp_smp_pkg.entitled_to_SMP',3);
1228:
1229: --8470655 begin
1230: if to_char(absence.date_start-1,'DAY') = to_char(woman.MPP_start_date - 1,'DAY')
1231: then

Line 1350: fnd_message.set_token ('PROCEDURE','ssp_smp_pkg.entitled_to_SMP');

1346: exception
1347: --
1348: when invalid_absence_date then
1349: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1350: fnd_message.set_token ('PROCEDURE','ssp_smp_pkg.entitled_to_SMP');
1351: fnd_message.set_token ('STEP','3');
1352: --
1353: when no_prima_facia_entitlement then
1354: --

Line 1513: ssp_smp_pkg.c_rate_name),'HIGH',l_high_rate,l_low_rate) RATE,

1509: entry.assignment_id,
1510: entry.effective_start_date,
1511: entry.effective_end_date,
1512: decode(ssp_smp_support_pkg.value(entry.element_entry_id,
1513: ssp_smp_pkg.c_rate_name),'HIGH',l_high_rate,l_low_rate) RATE,
1514: /*to_date (ssp_smp_support_pkg.value
1515: (entry.element_entry_id,
1516: ssp_smp_pkg.c_week_commencing_name),
1517: 'DD-MON-YYYY') WEEK_COMMENCING,*/

Line 1516: ssp_smp_pkg.c_week_commencing_name),

1512: decode(ssp_smp_support_pkg.value(entry.element_entry_id,
1513: ssp_smp_pkg.c_rate_name),'HIGH',l_high_rate,l_low_rate) RATE,
1514: /*to_date (ssp_smp_support_pkg.value
1515: (entry.element_entry_id,
1516: ssp_smp_pkg.c_week_commencing_name),
1517: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1518: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1519: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1520: -- Start Bug Fix for 7680593

Line 1519: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,

1515: (entry.element_entry_id,
1516: ssp_smp_pkg.c_week_commencing_name),
1517: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1518: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1519: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1520: -- Start Bug Fix for 7680593
1521: /*
1522: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1523: ssp_smp_pkg.c_amount_name)) AMOUNT,

Line 1523: ssp_smp_pkg.c_amount_name)) AMOUNT,

1519: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1520: -- Start Bug Fix for 7680593
1521: /*
1522: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1523: ssp_smp_pkg.c_amount_name)) AMOUNT,
1524: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1525: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1526: */
1527: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,

Line 1525: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT

1521: /*
1522: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1523: ssp_smp_pkg.c_amount_name)) AMOUNT,
1524: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1525: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1526: */
1527: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,
1528: ssp_smp_pkg.c_amount_name), l_group_separator, '')) AMOUNT,
1529: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,

Line 1528: ssp_smp_pkg.c_amount_name), l_group_separator, '')) AMOUNT,

1524: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1525: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1526: */
1527: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,
1528: ssp_smp_pkg.c_amount_name), l_group_separator, '')) AMOUNT,
1529: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,
1530: ssp_smp_pkg.c_recoverable_amount_name), l_group_separator, '')) RECOVERABLE_AMOUNT
1531: -- End Bug Fix for 7680593
1532: from pay_element_entries_f ENTRY,

Line 1530: ssp_smp_pkg.c_recoverable_amount_name), l_group_separator, '')) RECOVERABLE_AMOUNT

1526: */
1527: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,
1528: ssp_smp_pkg.c_amount_name), l_group_separator, '')) AMOUNT,
1529: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,
1530: ssp_smp_pkg.c_recoverable_amount_name), l_group_separator, '')) RECOVERABLE_AMOUNT
1531: -- End Bug Fix for 7680593
1532: from pay_element_entries_f ENTRY,
1533: per_all_assignments_f asg
1534: where creator_type = c_SMP_creator_type

Line 1900: hr_utility.set_location ('Entering: ssp_smp_pkg.derive_SMP_week',1);

1896: -- we are and finding the offset from the start date.
1897: --
1898: begin
1899: --
1900: hr_utility.set_location ('Entering: ssp_smp_pkg.derive_SMP_week',1);
1901: hr_utility.trace ('Entry number = '||to_char (p_week_number));
1902: --
1903: hypothetical_entry.week_commencing (p_week_number)
1904: := (woman.MPP_start_date + ((p_week_number -1) * 7));

Line 1914: hr_utility.set_location ('Leaving : ssp_smp_pkg.derive_SMP_week',100);

1910: --
1911: hr_utility.trace ('week_commencing = '
1912: ||to_char (hypothetical_entry.week_commencing (p_week_number)));
1913: --
1914: hr_utility.set_location ('Leaving : ssp_smp_pkg.derive_SMP_week',100);
1915: --
1916: end derive_SMP_week;
1917: --
1918: procedure Check_SMP_stoppages (p_week_number in integer) is

Line 1952: hr_utility.set_location ('ssp_smp_pkg.Check_SMP_stoppages',1);

1948: l_dummy integer (1);
1949: --
1950: begin
1951: --
1952: hr_utility.set_location ('ssp_smp_pkg.Check_SMP_stoppages',1);
1953: --
1954: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1955: --
1956: open csr_stoppages (

Line 1980: hr_utility.set_location ('ssp_smp_pkg.Check_SMP_stoppages',10);

1976: end if;
1977: --
1978: close csr_stoppages;
1979: --
1980: hr_utility.set_location ('ssp_smp_pkg.Check_SMP_stoppages',10);
1981: --
1982: end Check_SMP_stoppages;
1983: --
1984: procedure Calculate_correct_SMP_rate (p_week_number in number) is

Line 1998: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',1);

1994: and lookup_code = p_rate_band;
1995: --
1996: begin
1997: --
1998: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',1);
1999: --
2000: if l_high_rate is null then
2001: --
2002: -- Get the meanings for the rate bands

Line 2020: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',1);

2016: --
2017: if (p_week_number - l_stopped_weeks)
2018: <= g_SMP_element.period_at_higher_rate
2019: then
2020: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',1);
2021: --
2022: -- We have not yet given the employee all their higher rate weeks
2023: --
2024: hypothetical_entry.rate (p_week_number) := l_high_rate;

Line 2032: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',10);

2028: --
2029: hr_utility.trace ('SMP Rate = '
2030: ||hypothetical_entry.rate (p_week_number));
2031: --
2032: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',10);
2033: --
2034: end Calculate_correct_SMP_rate;
2035: --
2036: procedure Calculate_SMP_amounts (p_week_number in integer, p_MPP_start_date in date) is

Line 2040: hr_utility.set_location('Entering: ssp_smp_pkg.Calculate_SMP_amounts',1);

2036: procedure Calculate_SMP_amounts (p_week_number in integer, p_MPP_start_date in date) is
2037: --
2038: begin
2039: --
2040: hr_utility.set_location('Entering: ssp_smp_pkg.Calculate_SMP_amounts',1);
2041: --
2042: -- Get the SMP element for each week in case the SMP rate has changed
2043: --
2044: get_SMP_element (hypothetical_entry.week_commencing (p_week_number));

Line 2117: hr_utility.set_location('Leaving : ssp_smp_pkg.Calculate_SMP_amounts',100);

2113: ||to_char (hypothetical_entry.amount (p_week_number)));
2114: hr_utility.trace ('Recoverable amount = '
2115: ||to_char (hypothetical_entry.recoverable_amount (p_week_number)));
2116: --
2117: hr_utility.set_location('Leaving : ssp_smp_pkg.Calculate_SMP_amounts',100);
2118: --
2119: end calculate_SMP_amounts;
2120: --
2121: procedure check_parameters is

Line 2132: hr_utility.set_location ('ssp_smp_pkg.generate_payments',1);

2128: end check_parameters;
2129: --
2130: begin
2131: --
2132: hr_utility.set_location ('ssp_smp_pkg.generate_payments',1);
2133: --
2134: check_parameters;
2135: --
2136: <>

Line 2380: ssp_smp_pkg.QUALIFYING_WEEK(mat.due_date))

2376: 'PA',ssp_pad_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),
2377: 'PB',ssp_pab_pkg.QUALIFYING_WEEK(mat.due_date),
2378: 'AA',ssp_apad_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),
2379: 'AB',ssp_apab_pkg.QUALIFYING_WEEK(mat.due_date),
2380: ssp_smp_pkg.QUALIFYING_WEEK(mat.due_date))
2381: and exists (select 1
2382: from per_absence_attendances abs
2383: where abs.person_id = p_person_id
2384: and abs.maternity_id = mat.maternity_id);

Line 2535: end ssp_SMP_pkg;

2531: return p_due_date;
2532: end if;
2533: end;
2534: --------------------------------------------------------------------------------
2535: end ssp_SMP_pkg;