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_SUPPORT_PKG

Line 466: l_effective_date := least (greatest(woman.QW, woman.date_start), ssp_smp_support_pkg.start_of_week

462: --
463: hr_utility.set_location ('Entering '||l_proc,1);
464: --
465: if woman.actual_birth_date is not null then
466: l_effective_date := least (greatest(woman.QW, woman.date_start), ssp_smp_support_pkg.start_of_week
467: (woman.actual_birth_date));
468: else
469: l_effective_date := greatest(woman.QW, woman.date_start);
470: end if;

Line 597: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (

593: hr_utility.set_location (l_proc,1);
594: --
595: check_parameters;
596: --
597: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
598: g_SMP_element.element_type_id,
599: p_reason);
600: --
601: if not ssp_smp_support_pkg.stoppage_overridden (

Line 601: if not ssp_smp_support_pkg.stoppage_overridden (

597: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
598: g_SMP_element.element_type_id,
599: p_reason);
600: --
601: if not ssp_smp_support_pkg.stoppage_overridden (
602: p_maternity_id => p_maternity_id,
603: p_reason_id => l_reason_id)
604: then
605: --

Line 835: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

831: --
832: -- Stop SMP payment from the start of the week in which the woman
833: -- started work for a new employer after the birth of her child.
834: --
835: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
836: (woman.start_date_with_new_employer),
837: p_reason => 'Worked for another employer');
838: end if;
839: --

Line 859: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

855: --
856: -- Stop SMP payment from the start of the week in which SMA was first
857: -- paid.
858: --
859: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
860: (woman.start_date_maternity_allowance),
861: p_reason => 'Employee is receiving SMA');
862: end if;
863: --

Line 953: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;

949: -- generated average earnings when the earnings could not be derived
950: -- for some reason, but to allow this procedure to continue, no error
951: -- will be raised.
952: --
953: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;
954: --
955: if l_reason_for_no_earnings is not null then
956: create_stoppage (p_withhold_from => woman.MPP_start_date,
957: p_reason => l_reason_for_no_earnings);

Line 964: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (woman.QW)

960: end if;
961: end if;
962: --
963: if l_average_earnings
964: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (woman.QW)
965: then
966: --
967: -- Stop SMP payment from the MPP start date
968: --

Line 1205: --p_withhold_from => ssp_smp_support_pkg.start_of_week

1201: stoppage_end_date := g_SMP_element.MPP_notice_requirement
1202: + absence.date_start - 1;
1203: --
1204: create_stoppage (
1205: --p_withhold_from => ssp_smp_support_pkg.start_of_week
1206: -- (absence.date_start),
1207: -- p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
1208: p_withhold_from => woman.MPP_start_date,
1209: p_reason => 'Late absence notification');

Line 1207: -- p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),

1203: --
1204: create_stoppage (
1205: --p_withhold_from => ssp_smp_support_pkg.start_of_week
1206: -- (absence.date_start),
1207: -- p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
1208: p_withhold_from => woman.MPP_start_date,
1209: p_reason => 'Late absence notification');
1210: end if;
1211: --

Line 1225: p_withhold_to => ssp_smp_support_pkg.end_of_week

1221: and absence.date_start > woman.MPP_start_date
1222: then
1223: create_stoppage (p_reason => 'Some work was done',
1224: p_withhold_from => woman.MPP_start_date,
1225: p_withhold_to => ssp_smp_support_pkg.end_of_week
1226: (absence.date_start -1));
1227: end if;
1228: --
1229: if

Line 1239: p_withhold_from => ssp_smp_support_pkg.start_of_week

1235: + woman.MPP_start_date
1236: and woman.date_of_death is null -- Added the condition 3429978
1237: then
1238: create_stoppage (p_reason => 'Some work was done',
1239: p_withhold_from => ssp_smp_support_pkg.start_of_week
1240: (absence.date_end+1));
1241: elsif
1242: -- there is a period of work between two absences
1243: l_work_start_date < absence.date_start

Line 1248: p_withhold_from => ssp_smp_support_pkg.start_of_week

1244: and l_work_start_date < (g_SMP_element.maximum_MPP * 7)
1245: + woman.MPP_start_date
1246: then
1247: create_stoppage (p_reason => 'Some work was done',
1248: p_withhold_from => ssp_smp_support_pkg.start_of_week
1249: (l_work_start_date),
1250: p_withhold_to => ssp_smp_support_pkg.end_of_week
1251: (absence.date_start -1));
1252: --

Line 1250: p_withhold_to => ssp_smp_support_pkg.end_of_week

1246: then
1247: create_stoppage (p_reason => 'Some work was done',
1248: p_withhold_from => ssp_smp_support_pkg.start_of_week
1249: (l_work_start_date),
1250: p_withhold_to => ssp_smp_support_pkg.end_of_week
1251: (absence.date_start -1));
1252: --
1253: if absence.date_end <> hr_general.end_of_time
1254: then

Line 1441: decode(ssp_smp_support_pkg.value(entry.element_entry_id,

1437: entry.element_link_id,
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),

Line 1443: /*to_date (ssp_smp_support_pkg.value

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,*/
1447: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

Line 1447: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

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,
1450: ssp_smp_pkg.c_amount_name)) AMOUNT,
1451: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

Line 1449: to_number(ssp_smp_support_pkg.value (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
1453: from pay_element_entries_f ENTRY,

Line 1451: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

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
1455: where creator_type = c_SMP_creator_type

Line 1619: if ssp_smp_support_pkg.entry_already_processed

1615: -- don't create a new entry
1616: hypothetical_entry.dealt_with (entry_number) := 'TRUE';
1617: hr_utility.trace (l_proc||' leave unchanged');
1618: else
1619: if ssp_smp_support_pkg.entry_already_processed
1620: (old_entry.element_entry_id)
1621: then l_ins_corr_ele := TRUE;
1622: hr_utility.trace (l_proc||' processed - correct it');
1623: else

Line 1656: if ssp_smp_support_pkg.entry_already_processed

1652: hr_utility.trace (l_proc||' Rate: '||old_entry.rate);
1653: hr_utility.trace (l_proc||' Amount: '||old_entry.amount);
1654: hr_utility.trace (l_proc||' Recoverable: '
1655: ||old_entry.recoverable_amount);
1656: if ssp_smp_support_pkg.entry_already_processed
1657: (old_entry.element_entry_id)
1658: then l_ins_corr_ele := TRUE;
1659: hr_utility.trace (l_proc||' Old entry already processed');
1660: else

Line 1706: ssp_smp_support_pkg.get_entry_details (

1702: --
1703:
1704: hr_utility.trace('Correction Entry');
1705:
1706: ssp_smp_support_pkg.get_entry_details (
1707: p_date_earned => old_entry.week_commencing,
1708: p_last_process_date => woman.final_process_date,
1709: p_person_id => woman.person_id,
1710: p_element_type_id => g_SMP_Correction_element.element_type_id,

Line 1879: ssp_smp_support_pkg.end_of_week

1875: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1876: --
1877: open csr_stoppages (
1878: hypothetical_entry.week_commencing (p_week_number),
1879: ssp_smp_support_pkg.end_of_week
1880: (hypothetical_entry.week_commencing (p_week_number)));
1881: --
1882: fetch csr_stoppages into l_dummy;
1883: --

Line 2079: ssp_smp_support_pkg.get_entry_details (

2075: -- Get the entry details unless the entry has been stopped (in which case
2076: -- we do not need the entry details and errors may occur if we call the
2077: -- procedure; eg the woman's assignment ends)
2078: --
2079: ssp_smp_support_pkg.get_entry_details (
2080: p_date_earned => hypothetical_entry.week_commencing
2081: (week_number),
2082: p_pay_as_lump_sum => woman.pay_SMP_as_lump_sum,
2083: p_last_process_date => woman.final_process_date,

Line 2371: ssp_smp_support_pkg.recalculate_ssp_and_smp(p_deleting => FALSE);

2367: end if;
2368: --
2369: close csr_maternity;
2370: --
2371: ssp_smp_support_pkg.recalculate_ssp_and_smp(p_deleting => FALSE);
2372: --
2373: hr_utility.set_location (l_proc,100);
2374: --
2375: end person_control;