DBA Data[Home] [Help]

APPS.SSP_SAP_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 414: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (

410: hr_utility.set_location (l_proc,1);
411: --
412: check_parameters;
413: --
414: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
415: g_SAP_element.element_type_id,
416: p_reason);
417: --
418: if not ssp_smp_support_pkg.stoppage_overridden (

Line 418: if not ssp_smp_support_pkg.stoppage_overridden (

414: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
415: g_SAP_element.element_type_id,
416: p_reason);
417: --
418: if not ssp_smp_support_pkg.stoppage_overridden (
419: p_maternity_id => p_maternity_id,
420: p_reason_id => l_reason_id)
421: then
422: --

Line 559: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

555: --
556: -- Stop SAP payment from the start of the week in which the person
557: -- started work for a new employer after the placement of her child.
558: --
559: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
560: (person.start_date_with_new_employer),
561: p_reason => 'Worked for another employer');
562: end if;
563: --

Line 583: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

579: --
580: -- Stop SAP payment from the start of the week in which SMA was first
581: -- paid.
582: --
583: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
584: (person.start_date_maternity_allowance),
585: p_reason => 'Employee is receiving SMA');
586: end if;
587: --

Line 674: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;

670: -- generated average earnings when the earnings could not be derived
671: -- for some reason, but to allow this procedure to continue, no error
672: -- will be raised.
673: --
674: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;
675: --
676: if l_reason_for_no_earnings is not null then
677: create_stoppage (p_withhold_from => person.aPP_start_date,
678: p_reason => l_reason_for_no_earnings);

Line 685: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (person.MW)

681: end if;
682: end if;
683: --
684: if l_average_earnings
685: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (person.MW)
686: then
687: --
688: -- Stop SAP payment from the APP start date
689: --

Line 921: p_withhold_from => ssp_smp_support_pkg.start_of_week

917: Bug 2772479 - Late absence notification is no longer required for SAP. This may be reintroduced
918: so all code has been left in, with only the creation of the stoppage commented out.
919:
920: create_stoppage (
921: p_withhold_from => ssp_smp_support_pkg.start_of_week
922: (absence.date_start),
923: p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
924: p_reason => 'Late absence notification');
925: */

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

919:
920: create_stoppage (
921: p_withhold_from => ssp_smp_support_pkg.start_of_week
922: (absence.date_start),
923: p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
924: p_reason => 'Late absence notification');
925: */
926: end if;
927: --

Line 941: p_withhold_to => ssp_smp_support_pkg.end_of_week

937: and absence.date_start > person.APP_start_date
938: then
939: create_stoppage (p_reason => 'Some work was done',
940: p_withhold_from => person.APP_start_date,
941: p_withhold_to => ssp_smp_support_pkg.end_of_week
942: (absence.date_start -1));
943: end if;
944: --
945: if

Line 955: p_withhold_from => ssp_smp_support_pkg.start_of_week

951: + person.APP_start_date
952: and person.date_of_death is null
953: then
954: create_stoppage (p_reason => 'Some work was done',
955: p_withhold_from => ssp_smp_support_pkg.start_of_week
956: (absence.date_end+1));
957: elsif
958: -- there is a period of work between two absences
959: l_work_start_date < absence.date_start

Line 964: p_withhold_from => ssp_smp_support_pkg.start_of_week

960: and l_work_start_date < (g_SAP_element.maximum_APP * 7)
961: + person.APP_start_date
962: then
963: create_stoppage (p_reason => 'Some work was done',
964: p_withhold_from => ssp_smp_support_pkg.start_of_week
965: (l_work_start_date),
966: p_withhold_to => ssp_smp_support_pkg.end_of_week
967: (absence.date_start -1));
968: --

Line 966: p_withhold_to => ssp_smp_support_pkg.end_of_week

962: then
963: create_stoppage (p_reason => 'Some work was done',
964: p_withhold_from => ssp_smp_support_pkg.start_of_week
965: (l_work_start_date),
966: p_withhold_to => ssp_smp_support_pkg.end_of_week
967: (absence.date_start -1));
968: --
969: if absence.date_end <> hr_general.end_of_time
970: then

Line 1160: /* to_date (ssp_smp_support_pkg.value

1156: entry.effective_end_date,
1157: -- if in future we get two different rates then a decode can be added here
1158: l_high_rate RATE,
1159: --BUG 6271407 begin
1160: /* to_date (ssp_smp_support_pkg.value
1161: (entry.element_entry_id,
1162: ssp_sap_pkg.c_week_commencing_name),
1163: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1164: fnd_date.canonical_to_date(ssp_smp_support_pkg.value

Line 1164: fnd_date.canonical_to_date(ssp_smp_support_pkg.value

1160: /* to_date (ssp_smp_support_pkg.value
1161: (entry.element_entry_id,
1162: ssp_sap_pkg.c_week_commencing_name),
1163: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1164: fnd_date.canonical_to_date(ssp_smp_support_pkg.value
1165: (entry.element_entry_id,
1166: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1167: --BUG 6271407 end
1168: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

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

1164: fnd_date.canonical_to_date(ssp_smp_support_pkg.value
1165: (entry.element_entry_id,
1166: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1167: --BUG 6271407 end
1168: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1169: ssp_sap_pkg.c_amount_name)) AMOUNT,
1170: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1171: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1172: from pay_element_entries_f ENTRY,

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

1166: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1167: --BUG 6271407 end
1168: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1169: ssp_sap_pkg.c_amount_name)) AMOUNT,
1170: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1171: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1172: from pay_element_entries_f ENTRY,
1173: per_all_assignments_f asg
1174: where creator_type = c_SAP_creator_type

Line 1318: if ssp_smp_support_pkg.entry_already_processed

1314: -- don't create a new entry
1315: hypothetical_entry.dealt_with (entry_number) := 'TRUE';
1316: hr_utility.trace (l_proc||' leave unchanged');
1317: else
1318: if ssp_smp_support_pkg.entry_already_processed
1319: (old_entry.element_entry_id)
1320: then l_ins_corr_ele := TRUE;
1321: hr_utility.trace (l_proc||' processed - correct it');
1322: else

Line 1354: if ssp_smp_support_pkg.entry_already_processed

1350: hr_utility.trace (l_proc||' Rate: '||old_entry.rate);
1351: hr_utility.trace (l_proc||' Amount: '||old_entry.amount);
1352: hr_utility.trace (l_proc||' Recoverable: '
1353: ||old_entry.recoverable_amount);
1354: if ssp_smp_support_pkg.entry_already_processed
1355: (old_entry.element_entry_id)
1356: then l_ins_corr_ele := TRUE;
1357: hr_utility.trace (l_proc||' Old entry already processed');
1358: else

Line 1398: ssp_smp_support_pkg.get_entry_details (

1394: --
1395: -- Determine the next available period in which to place the
1396: -- correction entry
1397: --
1398: ssp_smp_support_pkg.get_entry_details (
1399: p_date_earned => old_entry.week_commencing,
1400: p_last_process_date => person.final_process_date,
1401: p_person_id => person.person_id,
1402: p_element_type_id => g_SAP_Correction_element.element_type_id,

Line 1567: ssp_smp_support_pkg.end_of_week

1563: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1564: --
1565: open csr_stoppages (
1566: hypothetical_entry.week_commencing (p_week_number),
1567: ssp_smp_support_pkg.end_of_week
1568: (hypothetical_entry.week_commencing (p_week_number)));
1569: --
1570: fetch csr_stoppages into l_dummy;
1571: --

Line 1710: ssp_smp_support_pkg.get_entry_details (

1706: -- Get the entry details unless the entry has been stopped (in which case
1707: -- we do not need the entry details and errors may occur if we call the
1708: -- procedure; eg the woman's assignment ends)
1709: --
1710: ssp_smp_support_pkg.get_entry_details (
1711: p_date_earned => hypothetical_entry.week_commencing
1712: (week_number),
1713: p_pay_as_lump_sum => person.pay_SAP_as_lump_sum,
1714: p_last_process_date => person.final_process_date,