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 473: l_effective_date := least (greatest(woman.QW, woman.date_start), ssp_smp_support_pkg.start_of_week

469: --
470: hr_utility.set_location ('Entering '||l_proc,1);
471: --
472: if woman.actual_birth_date is not null then
473: l_effective_date := least (greatest(woman.QW, woman.date_start), ssp_smp_support_pkg.start_of_week
474: (woman.actual_birth_date));
475: else
476: l_effective_date := greatest(woman.QW, woman.date_start);
477: end if;

Line 604: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (

600: hr_utility.set_location (l_proc,1);
601: --
602: check_parameters;
603: --
604: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
605: g_SMP_element.element_type_id,
606: p_reason);
607: --
608: if not ssp_smp_support_pkg.stoppage_overridden (

Line 608: if not ssp_smp_support_pkg.stoppage_overridden (

604: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
605: g_SMP_element.element_type_id,
606: p_reason);
607: --
608: if not ssp_smp_support_pkg.stoppage_overridden (
609: p_maternity_id => p_maternity_id,
610: p_reason_id => l_reason_id)
611: then
612: --

Line 842: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

838: --
839: -- Stop SMP payment from the start of the week in which the woman
840: -- started work for a new employer after the birth of her child.
841: --
842: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
843: (woman.start_date_with_new_employer),
844: p_reason => 'Worked for another employer');
845: end if;
846: --

Line 866: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

862: --
863: -- Stop SMP payment from the start of the week in which SMA was first
864: -- paid.
865: --
866: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
867: (woman.start_date_maternity_allowance),
868: p_reason => 'Employee is receiving SMA');
869: end if;
870: --

Line 960: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;

956: -- generated average earnings when the earnings could not be derived
957: -- for some reason, but to allow this procedure to continue, no error
958: -- will be raised.
959: --
960: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;
961: --
962: if l_reason_for_no_earnings is not null then
963: create_stoppage (p_withhold_from => woman.MPP_start_date,
964: p_reason => l_reason_for_no_earnings);

Line 976: -- < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (woman.QW)

972: -- If QW is 03-APR-2011, then average earnings as on 03-APR-2011 should
973: -- be compared with NI LEL value as on 09-APR-2011 which is the last
974: -- day of the QW. Modified the below code to get LEL value as on QW + 6.
975: -- if l_average_earnings
976: -- < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (woman.QW)
977:
978: if l_average_earnings
979: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (woman.QW + 6)
980: then

Line 979: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (woman.QW + 6)

975: -- if l_average_earnings
976: -- < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (woman.QW)
977:
978: if l_average_earnings
979: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (woman.QW + 6)
980: then
981: --
982: -- Stop SMP payment from the MPP start date
983: --

Line 1220: --p_withhold_from => ssp_smp_support_pkg.start_of_week

1216: stoppage_end_date := g_SMP_element.MPP_notice_requirement
1217: + absence.date_start - 1;
1218: --
1219: create_stoppage (
1220: --p_withhold_from => ssp_smp_support_pkg.start_of_week
1221: -- (absence.date_start),
1222: -- p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
1223: p_withhold_from => woman.MPP_start_date,
1224: p_reason => 'Late absence notification');

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

1218: --
1219: create_stoppage (
1220: --p_withhold_from => ssp_smp_support_pkg.start_of_week
1221: -- (absence.date_start),
1222: -- p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
1223: p_withhold_from => woman.MPP_start_date,
1224: p_reason => 'Late absence notification');
1225: end if;
1226: --

Line 1250: p_withhold_to => ssp_smp_support_pkg.end_of_week

1246: then
1247: /* 8470655 Begin
1248: create_stoppage (p_reason => 'Some work was done',
1249: p_withhold_from => woman.MPP_start_date,
1250: p_withhold_to => ssp_smp_support_pkg.end_of_week
1251: (absence.date_start -1));
1252: The Stoppage should be created on a '7 days rolling week'
1253: */
1254: create_stoppage (p_reason => 'Some work was done',

Line 1271: p_withhold_from => ssp_smp_support_pkg.start_of_week

1267: and woman.date_of_death is null -- Added the condition 3429978
1268: then
1269: /* 8470655 Begin
1270: create_stoppage (p_reason => 'Some work was done',
1271: p_withhold_from => ssp_smp_support_pkg.start_of_week
1272: (absence.date_end+1));
1273: The Stoppage should be created on a '7 days rolling week'
1274: */
1275:

Line 1289: p_withhold_from => ssp_smp_support_pkg.start_of_week

1285: + woman.MPP_start_date
1286: then
1287: /*8470655 Begin
1288: create_stoppage (p_reason => 'Some work was done',
1289: p_withhold_from => ssp_smp_support_pkg.start_of_week
1290: (l_work_start_date),
1291: p_withhold_to => ssp_smp_support_pkg.end_of_week
1292: (absence.date_start -1));
1293: */

Line 1291: p_withhold_to => ssp_smp_support_pkg.end_of_week

1287: /*8470655 Begin
1288: create_stoppage (p_reason => 'Some work was done',
1289: p_withhold_from => ssp_smp_support_pkg.start_of_week
1290: (l_work_start_date),
1291: p_withhold_to => ssp_smp_support_pkg.end_of_week
1292: (absence.date_start -1));
1293: */
1294:
1295: create_stoppage (p_reason => 'Some work was done',

Line 1492: -- When 'HR: Number Separator' profile is set to 'Y', then ssp_smp_support_pkg.value

1488: -- Having generated the potential SMP entries, reconcile them with any
1489: -- previously granted entries for the same maternity.
1490: --
1491: --Start Bug Fix for 7680593
1492: -- When 'HR: Number Separator' profile is set to 'Y', then ssp_smp_support_pkg.value
1493: -- returns amount with Group Seperator. Group seperator character has to be trimmed
1494: -- before calling to_number.
1495:
1496: l_group_separator VARCHAR2(2) := substr(ltrim(to_char(1032,'0G999')),2,1);

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

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

Line 1514: /*to_date (ssp_smp_support_pkg.value

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

Line 1518: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

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
1521: /*
1522: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

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

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,
1524: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1525: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1526: */

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

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,
1528: ssp_smp_pkg.c_amount_name), l_group_separator, '')) AMOUNT,

Line 1527: to_number(replace(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,
1530: ssp_smp_pkg.c_recoverable_amount_name), l_group_separator, '')) RECOVERABLE_AMOUNT
1531: -- End Bug Fix for 7680593

Line 1529: to_number(replace(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,
1533: per_all_assignments_f asg

Line 1698: if ssp_smp_support_pkg.entry_already_processed

1694: -- don't create a new entry
1695: hypothetical_entry.dealt_with (entry_number) := 'TRUE';
1696: hr_utility.trace (l_proc||' leave unchanged');
1697: else
1698: if ssp_smp_support_pkg.entry_already_processed
1699: (old_entry.element_entry_id)
1700: then l_ins_corr_ele := TRUE;
1701: hr_utility.trace (l_proc||' processed - correct it');
1702: else

Line 1735: if ssp_smp_support_pkg.entry_already_processed

1731: hr_utility.trace (l_proc||' Rate: '||old_entry.rate);
1732: hr_utility.trace (l_proc||' Amount: '||old_entry.amount);
1733: hr_utility.trace (l_proc||' Recoverable: '
1734: ||old_entry.recoverable_amount);
1735: if ssp_smp_support_pkg.entry_already_processed
1736: (old_entry.element_entry_id)
1737: then l_ins_corr_ele := TRUE;
1738: hr_utility.trace (l_proc||' Old entry already processed');
1739: else

Line 1785: ssp_smp_support_pkg.get_entry_details (

1781: --
1782:
1783: hr_utility.trace('Correction Entry');
1784:
1785: ssp_smp_support_pkg.get_entry_details (
1786: p_date_earned => old_entry.week_commencing,
1787: p_last_process_date => woman.final_process_date,
1788: p_person_id => woman.person_id,
1789: p_element_type_id => g_SMP_Correction_element.element_type_id,

Line 1958: ssp_smp_support_pkg.end_of_week

1954: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1955: --
1956: open csr_stoppages (
1957: hypothetical_entry.week_commencing (p_week_number),
1958: ssp_smp_support_pkg.end_of_week
1959: (hypothetical_entry.week_commencing (p_week_number)));
1960: --
1961: fetch csr_stoppages into l_dummy;
1962: --

Line 2158: ssp_smp_support_pkg.get_entry_details (

2154: -- Get the entry details unless the entry has been stopped (in which case
2155: -- we do not need the entry details and errors may occur if we call the
2156: -- procedure; eg the woman's assignment ends)
2157: --
2158: ssp_smp_support_pkg.get_entry_details (
2159: p_date_earned => hypothetical_entry.week_commencing
2160: (week_number),
2161: p_pay_as_lump_sum => woman.pay_SMP_as_lump_sum,
2162: p_last_process_date => woman.final_process_date,

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

2448: end if;
2449: --
2450: close csr_maternity;
2451: --
2452: ssp_smp_support_pkg.recalculate_ssp_and_smp(p_deleting => FALSE);
2453: --
2454: hr_utility.set_location (l_proc,100);
2455: --
2456: end person_control;