DBA Data[Home] [Help]

APPS.SSP_SAP_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 416: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (

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

Line 420: if not ssp_smp_support_pkg.stoppage_overridden (

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

Line 561: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

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

Line 585: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

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

Line 676: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;

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

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

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

Line 923: p_withhold_from => ssp_smp_support_pkg.start_of_week

919: Bug 2772479 - Late absence notification is no longer required for SAP. This may be reintroduced
920: so all code has been left in, with only the creation of the stoppage commented out.
921:
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: */

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

921:
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: */
928: end if;
929: --

Line 943: p_withhold_to => ssp_smp_support_pkg.end_of_week

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

Line 957: p_withhold_from => ssp_smp_support_pkg.start_of_week

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

Line 966: p_withhold_from => ssp_smp_support_pkg.start_of_week

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

Line 968: p_withhold_to => ssp_smp_support_pkg.end_of_week

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

Line 1162: /* to_date (ssp_smp_support_pkg.value

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

Line 1167: /* fnd_date.canonical_to_date(ssp_smp_support_pkg.value

1163: (entry.element_entry_id,
1164: ssp_sap_pkg.c_week_commencing_name),
1165: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1166: --BUG 7563477 begin
1167: /* fnd_date.canonical_to_date(ssp_smp_support_pkg.value
1168: (entry.element_entry_id,
1169: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,*/
1170: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1171: (entry.element_entry_id,

Line 1170: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

1166: --BUG 7563477 begin
1167: /* fnd_date.canonical_to_date(ssp_smp_support_pkg.value
1168: (entry.element_entry_id,
1169: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,*/
1170: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1171: (entry.element_entry_id,
1172: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1173: --BUG 7563477 end
1174: --BUG 6271407 end

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

1171: (entry.element_entry_id,
1172: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1173: --BUG 7563477 end
1174: --BUG 6271407 end
1175: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1176: ssp_sap_pkg.c_amount_name)) AMOUNT,
1177: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1178: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1179: from pay_element_entries_f ENTRY,

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

1173: --BUG 7563477 end
1174: --BUG 6271407 end
1175: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1176: ssp_sap_pkg.c_amount_name)) AMOUNT,
1177: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1178: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1179: from pay_element_entries_f ENTRY,
1180: per_all_assignments_f asg
1181: where creator_type = c_SAP_creator_type

Line 1325: if ssp_smp_support_pkg.entry_already_processed

1321: -- don't create a new entry
1322: hypothetical_entry.dealt_with (entry_number) := 'TRUE';
1323: hr_utility.trace (l_proc||' leave unchanged');
1324: else
1325: if ssp_smp_support_pkg.entry_already_processed
1326: (old_entry.element_entry_id)
1327: then l_ins_corr_ele := TRUE;
1328: hr_utility.trace (l_proc||' processed - correct it');
1329: else

Line 1361: if ssp_smp_support_pkg.entry_already_processed

1357: hr_utility.trace (l_proc||' Rate: '||old_entry.rate);
1358: hr_utility.trace (l_proc||' Amount: '||old_entry.amount);
1359: hr_utility.trace (l_proc||' Recoverable: '
1360: ||old_entry.recoverable_amount);
1361: if ssp_smp_support_pkg.entry_already_processed
1362: (old_entry.element_entry_id)
1363: then l_ins_corr_ele := TRUE;
1364: hr_utility.trace (l_proc||' Old entry already processed');
1365: else

Line 1405: ssp_smp_support_pkg.get_entry_details (

1401: --
1402: -- Determine the next available period in which to place the
1403: -- correction entry
1404: --
1405: ssp_smp_support_pkg.get_entry_details (
1406: p_date_earned => old_entry.week_commencing,
1407: p_last_process_date => person.final_process_date,
1408: p_person_id => person.person_id,
1409: p_element_type_id => g_SAP_Correction_element.element_type_id,

Line 1574: ssp_smp_support_pkg.end_of_week

1570: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1571: --
1572: open csr_stoppages (
1573: hypothetical_entry.week_commencing (p_week_number),
1574: ssp_smp_support_pkg.end_of_week
1575: (hypothetical_entry.week_commencing (p_week_number)));
1576: --
1577: fetch csr_stoppages into l_dummy;
1578: --

Line 1717: ssp_smp_support_pkg.get_entry_details (

1713: -- Get the entry details unless the entry has been stopped (in which case
1714: -- we do not need the entry details and errors may occur if we call the
1715: -- procedure; eg the woman's assignment ends)
1716: --
1717: ssp_smp_support_pkg.get_entry_details (
1718: p_date_earned => hypothetical_entry.week_commencing
1719: (week_number),
1720: p_pay_as_lump_sum => person.pay_SAP_as_lump_sum,
1721: p_last_process_date => person.final_process_date,