DBA Data[Home] [Help]

APPS.SSP_PAB_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 445: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (

441: hr_utility.set_location (l_proc,1);
442: --
443: check_parameters;
444: --
445: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
446: g_PAB_element.element_type_id,
447: p_reason);
448: --
449: if not ssp_smp_support_pkg.stoppage_overridden (

Line 449: if not ssp_smp_support_pkg.stoppage_overridden (

445: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
446: g_PAB_element.element_type_id,
447: p_reason);
448: --
449: if not ssp_smp_support_pkg.stoppage_overridden (
450: p_maternity_id => p_maternity_id,
451: p_reason_id => l_reason_id)
452: then
453: --

Line 649: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

645: --
646: -- Stop SAP payment from the start of the week in which the person
647: -- started work for a new employer after the placement of her child.
648: --
649: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
650: (person.start_date_with_new_employer),
651: p_reason => 'Worked for another employer');
652: end if;
653: --

Line 673: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

669: --
670: -- Stop SAP payment from the start of the week in which SMA was first
671: -- paid.
672: --
673: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
674: (person.start_date_maternity_allowance),
675: p_reason => 'Employee is receiving SMA');
676: end if;
677: --

Line 740: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;

736: -- generated average earnings when the earnings could not be derived
737: -- for some reason, but to allow this procedure to continue, no error
738: -- will be raised.
739: --
740: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;
741: --
742: if l_reason_for_no_earnings is not null then
743: create_stoppage (p_withhold_from => person.aPP_start_date,
744: p_reason => l_reason_for_no_earnings);

Line 751: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (person.QW)

747: end if;
748: end if;
749: --
750: if l_average_earnings
751: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (person.QW)
752: then
753: --
754: -- Stop SAP payment from the APP start date
755: --

Line 907: p_withhold_from => ssp_smp_support_pkg.start_of_week

903: --
904: /* Bug 2772479 - Stoppage no longer required but may be reintroduced
905:
906: create_stoppage (
907: p_withhold_from => ssp_smp_support_pkg.start_of_week
908: (absence.date_start),
909: p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
910: p_reason => 'Late absence notification');
911: */

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

905:
906: create_stoppage (
907: p_withhold_from => ssp_smp_support_pkg.start_of_week
908: (absence.date_start),
909: p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
910: p_reason => 'Late absence notification');
911: */
912: end if;
913: --

Line 925: p_withhold_to => ssp_smp_support_pkg.end_of_week

921: and absence.date_start > person.APP_start_date
922: then
923: create_stoppage (p_reason => 'Some work was done',
924: p_withhold_from => person.APP_start_date,
925: p_withhold_to => ssp_smp_support_pkg.end_of_week
926: (absence.date_start -1));
927: end if;
928: --
929: -- If this is the last absence period in the MPP

Line 940: p_withhold_from => ssp_smp_support_pkg.start_of_week

936:
937:
938: --Commented code for Bug Fix 3509432
939: /* create_stoppage (p_reason => 'Some work was done',
940: p_withhold_from => ssp_smp_support_pkg.start_of_week
941: (absence.date_end+1));*/
942:
943: --Bug 3509432 start
944: --Only one week is paid, if absence is for > 1 week but < 2 weeks

Line 976: p_withhold_from => ssp_smp_support_pkg.start_of_week

972: and l_work_start_date < (g_PAB_element.maximum_PPP_weeks * 7)
973: + person.APP_start_date
974: then
975: create_stoppage (p_reason => 'Some work was done',
976: p_withhold_from => ssp_smp_support_pkg.start_of_week
977: (l_work_start_date),
978: p_withhold_to => ssp_smp_support_pkg.end_of_week
979: (absence.date_start -1));
980: --

Line 978: p_withhold_to => ssp_smp_support_pkg.end_of_week

974: then
975: create_stoppage (p_reason => 'Some work was done',
976: p_withhold_from => ssp_smp_support_pkg.start_of_week
977: (l_work_start_date),
978: p_withhold_to => ssp_smp_support_pkg.end_of_week
979: (absence.date_start -1));
980: --
981: if absence.date_end <> hr_general.end_of_time
982: then

Line 1086: to_date (ssp_smp_support_pkg.value

1082: entry.effective_start_date,
1083: entry.effective_end_date,
1084: -- if in future we get two different rates then a decode can be added here
1085: l_high_rate RATE,
1086: to_date (ssp_smp_support_pkg.value
1087: (entry.element_entry_id,
1088: ssp_sap_pkg.c_week_commencing_name),
1089: 'DD-MON-YYYY') WEEK_COMMENCING,
1090: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

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

1086: to_date (ssp_smp_support_pkg.value
1087: (entry.element_entry_id,
1088: ssp_sap_pkg.c_week_commencing_name),
1089: 'DD-MON-YYYY') WEEK_COMMENCING,
1090: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1091: ssp_sap_pkg.c_amount_name)) AMOUNT,
1092: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1093: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1094: from pay_element_entries_f ENTRY,

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

1088: ssp_sap_pkg.c_week_commencing_name),
1089: 'DD-MON-YYYY') WEEK_COMMENCING,
1090: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1091: ssp_sap_pkg.c_amount_name)) AMOUNT,
1092: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1093: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1094: from pay_element_entries_f ENTRY,
1095: per_all_assignments_f asg
1096: where creator_type = c_PAB_creator_type

Line 1246: if ssp_smp_support_pkg.entry_already_processed

1242: -- don't create a new entry
1243: hypothetical_entry.dealt_with (entry_number) := 'TRUE';
1244: hr_utility.trace (l_proc||' leave unchanged');
1245: else
1246: if ssp_smp_support_pkg.entry_already_processed
1247: (old_entry.element_entry_id)
1248: then
1249: l_ins_corr_ele := TRUE;
1250: hr_utility.trace (l_proc||' processed - correct it');

Line 1283: if ssp_smp_support_pkg.entry_already_processed

1279: hr_utility.trace (l_proc||' Rate: '||old_entry.rate);
1280: hr_utility.trace (l_proc||' Amount: '||old_entry.amount);
1281: hr_utility.trace (l_proc||' Recoverable: '
1282: ||old_entry.recoverable_amount);
1283: if ssp_smp_support_pkg.entry_already_processed
1284: (old_entry.element_entry_id)
1285: then l_ins_corr_ele := TRUE;
1286: hr_utility.trace (l_proc||' Old entry already processed');
1287: else

Line 1327: ssp_smp_support_pkg.get_entry_details (

1323: --
1324: -- Determine the next available period in which to place the
1325: -- correction entry
1326: --
1327: ssp_smp_support_pkg.get_entry_details (
1328: p_date_earned => old_entry.week_commencing,
1329: p_last_process_date => person.final_process_date,
1330: p_person_id => person.person_id,
1331: p_element_type_id => g_PAB_Correction_element.element_type_id,

Line 1498: ssp_smp_support_pkg.end_of_week

1494: --
1495: --
1496: open csr_stoppages (
1497: hypothetical_entry.week_commencing (p_week_number),
1498: ssp_smp_support_pkg.end_of_week
1499: (hypothetical_entry.week_commencing (p_week_number)));
1500:
1501: fetch csr_stoppages into l_dummy;
1502: --

Line 1641: ssp_smp_support_pkg.get_entry_details (

1637: -- Get the entry details unless the entry has been stopped (in which case
1638: -- we do not need the entry details and errors may occur if we call the
1639: -- procedure; eg the woman's assignment ends)
1640: --
1641: ssp_smp_support_pkg.get_entry_details (
1642: p_date_earned => hypothetical_entry.week_commencing
1643: (week_number),
1644: p_pay_as_lump_sum => person.pay_PAB_as_lump_sum,
1645: p_last_process_date => person.final_process_date,