DBA Data[Home] [Help]

APPS.SSP_APAB_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 474: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (

470: hr_utility.set_location (l_proc,1);
471: --
472: check_parameters;
473: --
474: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
475: g_APAB_element.element_type_id,
476: p_reason);
477: --
478: if not ssp_smp_support_pkg.stoppage_overridden (

Line 478: if not ssp_smp_support_pkg.stoppage_overridden (

474: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
475: g_APAB_element.element_type_id,
476: p_reason);
477: --
478: if not ssp_smp_support_pkg.stoppage_overridden (
479: p_maternity_id => p_maternity_id,
480: p_reason_id => l_reason_id)
481: then
482: --

Line 714: create_stoppage (p_withhold_from => ssp_smp_support_pkg.end_of_rolling_week(

710: fetch csr_check_death into l_death_date;
711: close csr_check_death;
712: --
713: if l_death_date is not null then
714: create_stoppage (p_withhold_from => ssp_smp_support_pkg.end_of_rolling_week(
715: person.ASPP_start_date, l_death_date) +1,
716: p_reason => 'Employee died');
717: end if;
718: --

Line 733: l_stop_from := ssp_smp_support_pkg.end_of_rolling_week(

729: then
730: if person.ASPP_start_date > person.death_of_child then
731: l_stop_from := person.ASPP_start_date;
732: else
733: l_stop_from := ssp_smp_support_pkg.end_of_rolling_week(
734: person.ASPP_start_date, person.death_of_child) +1;
735: end if;
736: create_stoppage (p_withhold_from => l_stop_from,
737: p_reason => 'Death of the child');

Line 764: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;

760: -- generated average earnings when the earnings could not be derived
761: -- for some reason, but to allow this procedure to continue, no error
762: -- will be raised.
763: --
764: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;
765: --
766: if l_reason_for_no_earnings is not null then
767: create_stoppage (p_withhold_from => person.ASPP_start_date,
768: p_reason => l_reason_for_no_earnings);

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

771: end if;
772: end if;
773: --
774: if l_average_earnings
775: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (person.QW)
776: then
777: --
778: -- Stop ASPP payment from the ASPP start date
779: --

Line 923: p_withhold_from => ssp_smp_support_pkg.start_of_week

919: )
920: then
921: -- Stop ASPPB payment. Need to verify is any end is required for this stoppage
922: create_stoppage (
923: p_withhold_from => ssp_smp_support_pkg.start_of_week
924: (absence.date_start),
925: -- p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
926: p_reason => 'Late absence notification');
927: end if;*/

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

921: -- Stop ASPPB payment. Need to verify is any end is required for this stoppage
922: create_stoppage (
923: p_withhold_from => ssp_smp_support_pkg.start_of_week
924: (absence.date_start),
925: -- p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
926: p_reason => 'Late absence notification');
927: end if;*/
928: --
929: hr_utility.set_location ('ssp_apab_pkg.entitled_to_apab',3);

Line 1048: to_date (ssp_smp_support_pkg.value

1044: entry.effective_end_date,
1045: -- if in future we get two different rates then a decode can be added here
1046: l_high_rate RATE,
1047: /* Bug Fix 8692219 begin
1048: to_date (ssp_smp_support_pkg.value
1049: (entry.element_entry_id,
1050: ssp_sap_pkg.c_week_commencing_name),
1051: 'DD-MON-YYYY') WEEK_COMMENCING,
1052: */

Line 1053: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

1049: (entry.element_entry_id,
1050: ssp_sap_pkg.c_week_commencing_name),
1051: 'DD-MON-YYYY') WEEK_COMMENCING,
1052: */
1053: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1054: (entry.element_entry_id,
1055: ssp_apab_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1056: -- Bug Fix 8692219 End
1057: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

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

1053: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1054: (entry.element_entry_id,
1055: ssp_apab_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1056: -- Bug Fix 8692219 End
1057: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1058: ssp_apab_pkg.c_amount_name)) AMOUNT,
1059: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1060: ssp_apab_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1061: from pay_element_entries_f ENTRY,

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

1055: ssp_apab_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1056: -- Bug Fix 8692219 End
1057: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1058: ssp_apab_pkg.c_amount_name)) AMOUNT,
1059: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1060: ssp_apab_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1061: from pay_element_entries_f ENTRY,
1062: per_all_assignments_f asg
1063: where creator_type = c_APAB_creator_type

Line 1213: if ssp_smp_support_pkg.entry_already_processed

1209: -- don't create a new entry
1210: hypothetical_entry.dealt_with (entry_number) := 'TRUE';
1211: hr_utility.trace (l_proc||' leave unchanged');
1212: else
1213: if ssp_smp_support_pkg.entry_already_processed
1214: (old_entry.element_entry_id)
1215: then
1216: l_ins_corr_ele := TRUE;
1217: hr_utility.trace (l_proc||' processed - correct it');

Line 1250: if ssp_smp_support_pkg.entry_already_processed

1246: hr_utility.trace (l_proc||' Rate: '||old_entry.rate);
1247: hr_utility.trace (l_proc||' Amount: '||old_entry.amount);
1248: hr_utility.trace (l_proc||' Recoverable: '
1249: ||old_entry.recoverable_amount);
1250: if ssp_smp_support_pkg.entry_already_processed
1251: (old_entry.element_entry_id)
1252: then l_ins_corr_ele := TRUE;
1253: hr_utility.trace (l_proc||' Old entry already processed');
1254: else

Line 1294: ssp_smp_support_pkg.get_entry_details (

1290: --
1291: -- Determine the next available period in which to place the
1292: -- correction entry
1293: --
1294: ssp_smp_support_pkg.get_entry_details (
1295: p_date_earned => old_entry.week_commencing,
1296: p_last_process_date => person.final_process_date,
1297: p_person_id => person.person_id,
1298: p_element_type_id => g_APAB_Correction_element.element_type_id,

Line 1656: ssp_smp_support_pkg.get_entry_details (

1652: -- Get the entry details unless the entry has been stopped (in which case
1653: -- we do not need the entry details and errors may occur if we call the
1654: -- procedure; eg the woman's assignment ends)
1655: --
1656: ssp_smp_support_pkg.get_entry_details (
1657: p_date_earned => hypothetical_entry.week_commencing
1658: (week_number),
1659: p_pay_as_lump_sum => person.pay_APAB_as_lump_sum,
1660: p_last_process_date => person.final_process_date,