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.8 2006/12/09 16:49:27 kthampan ship $
3: +==============================================================================+
4: | Copyright (c) 1994 Oracle Corporation |
5: | Redwood Shores, California, USA |

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

172: 09-DEC-2006 kthampan 115.33 5706912 Amend procedure ins_ssp_temp_affected_rows_mat
173: and person_control
174: */
175: --------------------------------------------------------------------------------
176: g_package varchar2(33) := ' ssp_smp_pkg.'; -- Global package name
177: --
178: cursor csr_absence_details (p_maternity_id in number) is
179: --
180: -- Get details of maternity leave for a maternity, in chronological

Line 199: ssp_smp_pkg.qualifying_week (due_date) QW,

195: -- Get details of the maternal woman
196: --
197: select maternity.person_id,
198: maternity.due_date,
199: ssp_smp_pkg.qualifying_week (due_date) QW,
200: ssp_smp_pkg.expected_week_of_confinement (due_date) EWC,
201: maternity.maternity_id,
202: maternity.actual_birth_date,
203: maternity.live_birth_flag,

Line 200: ssp_smp_pkg.expected_week_of_confinement (due_date) EWC,

196: --
197: select maternity.person_id,
198: maternity.due_date,
199: ssp_smp_pkg.qualifying_week (due_date) QW,
200: ssp_smp_pkg.expected_week_of_confinement (due_date) EWC,
201: maternity.maternity_id,
202: maternity.actual_birth_date,
203: maternity.live_birth_flag,
204: maternity.start_date_with_new_employer,

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

661: -- 5210118 starts
662: select 1
663: from per_periods_of_service
664: where person_id = woman.person_id
665: and ssp_smp_pkg.continuous_employment_date(woman.due_date) >=
666: (select max(date_start)
667: from per_periods_of_service
668: where person_id = woman.person_id
669: );

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

707: select nvl(ser.actual_termination_date, hr_general.end_of_time) termination_date
708: ,leaving_reason leaving_reason
709: from per_periods_of_service ser
710: where ser.person_id = woman.person_id
711: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
712: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
713: --
714: l_proc varchar2(72) := g_package||'check_employment_qw';
715: l_termination_date per_periods_of_service.actual_termination_date%type;

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

766: hr_utility.set_location(l_proc,5);
767: if (l_termination_date
768: between woman.qw
769: and nvl(woman.MPP_start_date
770: ,ssp_smp_pkg.earliest_mpp_start_date(woman.due_date)) )
771: and
772: (l_leaving_reason <> 'MATERNITY')
773: then
774: hr_utility.set_location(l_proc,6);

Line 882: ,ssp_smp_pkg.earliest_mpp_start_date

878: mpp_pay_period_end date;
879: current_mpp_period number := 126;
880: new_mpp_period number := 182;
881: mpp_start_date date := nvl(woman.MPP_start_date
882: ,ssp_smp_pkg.earliest_mpp_start_date
883: (woman.due_date));
884: -- Bug 2663899 End
885: cursor csr_get_week_day is
886: select to_char(mpp_start_date,'DAY')

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

1156: --
1157: -- Having established a prima facia entitlement to SMP, perform checks which
1158: -- may lead to creation of stoppages for particular periods.
1159: --
1160: hr_utility.set_location ('ssp_smp_pkg.entitled_to_SMP',2);
1161: --
1162: -- Get the SMP legislative parameters.
1163: --
1164: get_SMP_element (woman.due_date);

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

1208: p_withhold_from => woman.MPP_start_date,
1209: p_reason => 'Late absence notification');
1210: end if;
1211: --
1212: hr_utility.set_location ('ssp_smp_pkg.entitled_to_SMP',3);
1213: --
1214: -- Check for any work done during the MPP.
1215: --
1216: if

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

1282: exception
1283: --
1284: when invalid_absence_date then
1285: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1286: fnd_message.set_token ('PROCEDURE','ssp_smp_pkg.entitled_to_SMP');
1287: fnd_message.set_token ('STEP','3');
1288: --
1289: when no_prima_facia_entitlement then
1290: --

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

1438: entry.assignment_id,
1439: entry.effective_start_date,
1440: entry.effective_end_date,
1441: decode(ssp_smp_support_pkg.value(entry.element_entry_id,
1442: ssp_smp_pkg.c_rate_name),'HIGH',l_high_rate,l_low_rate) RATE,
1443: /*to_date (ssp_smp_support_pkg.value
1444: (entry.element_entry_id,
1445: ssp_smp_pkg.c_week_commencing_name),
1446: 'DD-MON-YYYY') WEEK_COMMENCING,*/

Line 1445: ssp_smp_pkg.c_week_commencing_name),

1441: decode(ssp_smp_support_pkg.value(entry.element_entry_id,
1442: ssp_smp_pkg.c_rate_name),'HIGH',l_high_rate,l_low_rate) RATE,
1443: /*to_date (ssp_smp_support_pkg.value
1444: (entry.element_entry_id,
1445: ssp_smp_pkg.c_week_commencing_name),
1446: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1447: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1448: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1449: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

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

1444: (entry.element_entry_id,
1445: ssp_smp_pkg.c_week_commencing_name),
1446: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1447: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1448: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1449: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1450: ssp_smp_pkg.c_amount_name)) AMOUNT,
1451: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1452: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT

Line 1450: ssp_smp_pkg.c_amount_name)) AMOUNT,

1446: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1447: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1448: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1449: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1450: ssp_smp_pkg.c_amount_name)) AMOUNT,
1451: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1452: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1453: from pay_element_entries_f ENTRY,
1454: per_all_assignments_f asg

Line 1452: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT

1448: (entry.element_entry_id,ssp_smp_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1449: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1450: ssp_smp_pkg.c_amount_name)) AMOUNT,
1451: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1452: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1453: from pay_element_entries_f ENTRY,
1454: per_all_assignments_f asg
1455: where creator_type = c_SMP_creator_type
1456: and creator_id = p_maternity_id

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

1817: -- we are and finding the offset from the start date.
1818: --
1819: begin
1820: --
1821: hr_utility.set_location ('Entering: ssp_smp_pkg.derive_SMP_week',1);
1822: hr_utility.trace ('Entry number = '||to_char (p_week_number));
1823: --
1824: hypothetical_entry.week_commencing (p_week_number)
1825: := (woman.MPP_start_date + ((p_week_number -1) * 7));

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

1831: --
1832: hr_utility.trace ('week_commencing = '
1833: ||to_char (hypothetical_entry.week_commencing (p_week_number)));
1834: --
1835: hr_utility.set_location ('Leaving : ssp_smp_pkg.derive_SMP_week',100);
1836: --
1837: end derive_SMP_week;
1838: --
1839: procedure Check_SMP_stoppages (p_week_number in integer) is

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

1869: l_dummy integer (1);
1870: --
1871: begin
1872: --
1873: hr_utility.set_location ('ssp_smp_pkg.Check_SMP_stoppages',1);
1874: --
1875: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1876: --
1877: open csr_stoppages (

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

1897: end if;
1898: --
1899: close csr_stoppages;
1900: --
1901: hr_utility.set_location ('ssp_smp_pkg.Check_SMP_stoppages',10);
1902: --
1903: end Check_SMP_stoppages;
1904: --
1905: procedure Calculate_correct_SMP_rate (p_week_number in number) is

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

1915: and lookup_code = p_rate_band;
1916: --
1917: begin
1918: --
1919: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',1);
1920: --
1921: if l_high_rate is null then
1922: --
1923: -- Get the meanings for the rate bands

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

1937: --
1938: if (p_week_number - l_stopped_weeks)
1939: <= g_SMP_element.period_at_higher_rate
1940: then
1941: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',1);
1942: --
1943: -- We have not yet given the employee all their higher rate weeks
1944: --
1945: hypothetical_entry.rate (p_week_number) := l_high_rate;

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

1949: --
1950: hr_utility.trace ('SMP Rate = '
1951: ||hypothetical_entry.rate (p_week_number));
1952: --
1953: hr_utility.set_location ('ssp_smp_pkg.Calculate_correct_SMP_rate',10);
1954: --
1955: end Calculate_correct_SMP_rate;
1956: --
1957: procedure Calculate_SMP_amounts (p_week_number in integer, p_MPP_start_date in date) is

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

1957: procedure Calculate_SMP_amounts (p_week_number in integer, p_MPP_start_date in date) is
1958: --
1959: begin
1960: --
1961: hr_utility.set_location('Entering: ssp_smp_pkg.Calculate_SMP_amounts',1);
1962: --
1963: -- Get the SMP element for each week in case the SMP rate has changed
1964: --
1965: get_SMP_element (hypothetical_entry.week_commencing (p_week_number));

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

2034: ||to_char (hypothetical_entry.amount (p_week_number)));
2035: hr_utility.trace ('Recoverable amount = '
2036: ||to_char (hypothetical_entry.recoverable_amount (p_week_number)));
2037: --
2038: hr_utility.set_location('Leaving : ssp_smp_pkg.Calculate_SMP_amounts',100);
2039: --
2040: end calculate_SMP_amounts;
2041: --
2042: procedure check_parameters is

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

2049: end check_parameters;
2050: --
2051: begin
2052: --
2053: hr_utility.set_location ('ssp_smp_pkg.generate_payments',1);
2054: --
2055: check_parameters;
2056: --
2057: <>

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

2295: and p_effective_date = decode(mat.leave_type,
2296: 'AD',ssp_sap_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),
2297: 'PA',ssp_pad_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),
2298: 'PB',ssp_pab_pkg.QUALIFYING_WEEK(mat.due_date),
2299: ssp_smp_pkg.QUALIFYING_WEEK(mat.due_date))
2300: and exists (select 1
2301: from per_absence_attendances abs
2302: where abs.person_id = p_person_id
2303: and abs.maternity_id = mat.maternity_id);

Line 2454: end ssp_SMP_pkg;

2450: return p_due_date;
2451: end if;
2452: end;
2453: --------------------------------------------------------------------------------
2454: end ssp_SMP_pkg;