DBA Data[Home] [Help]

APPS.SSP_PAD_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 406: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (

402: hr_utility.set_location (l_proc,1);
403: --
404: check_parameters;
405: --
406: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
407: g_PAD_element.element_type_id,
408: p_reason);
409: --
410: if not ssp_smp_support_pkg.stoppage_overridden (

Line 410: if not ssp_smp_support_pkg.stoppage_overridden (

406: l_reason_id := ssp_smp_support_pkg.withholding_reason_id (
407: g_PAD_element.element_type_id,
408: p_reason);
409: --
410: if not ssp_smp_support_pkg.stoppage_overridden (
411: p_maternity_id => p_maternity_id,
412: p_reason_id => l_reason_id)
413: then
414: --

Line 582: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

578: -- Stop PAD payment from the start of the week in which the person
579: -- started work for a new employer after the placement of her child.
580: --
581: if person.start_date_with_new_employer >= person.placement_date then
582: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
583: (person.start_date_with_new_employer),
584: p_reason => 'Worked for another employer');
585: end if;
586: --

Line 605: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week

601: -- Stop PAD payment from the start of the week in which SMA was first
602: -- paid.
603: --
604: if person.start_date_maternity_allowance is not null then
605: create_stoppage (p_withhold_from => ssp_smp_support_pkg.start_of_week
606: (person.start_date_maternity_allowance),
607: p_reason => 'Employee is receiving SMA');
608: end if;
609: --

Line 671: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;

667: -- will be raised.
668: --
669: if l_average_earnings = 0
670: then
671: l_reason_for_no_earnings:=ssp_smp_support_pkg.average_earnings_error;
672: --
673: if l_reason_for_no_earnings is not null then
674: create_stoppage (p_withhold_from => person.aPP_start_date,
675: p_reason => l_reason_for_no_earnings);

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

680: --
681: -- Stop PAD payment from the APP start date
682: --
683: if l_average_earnings
684: < ssp_smp_support_pkg.NI_Lower_Earnings_Limit (person.MW)
685: then
686: create_stoppage (p_withhold_from => person.APP_start_date,
687: p_reason => 'Earnings too low');
688: end if;

Line 817: p_withhold_from => ssp_smp_support_pkg.start_of_week

813: --
814: /* Bug 2772479 - stoppage no longer required, but may be reintroduced
815:
816: create_stoppage (
817: p_withhold_from => ssp_smp_support_pkg.start_of_week
818: (absence.date_start),
819: p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
820: p_reason => 'Late absence notification');
821: */

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

815:
816: create_stoppage (
817: p_withhold_from => ssp_smp_support_pkg.start_of_week
818: (absence.date_start),
819: p_withhold_to => ssp_smp_support_pkg.end_of_week (stoppage_end_date),
820: p_reason => 'Late absence notification');
821: */
822: end if;
823: --

Line 838: p_withhold_to => ssp_smp_support_pkg.end_of_week

834: then
835:
836: create_stoppage (p_reason => 'Some work was done',
837: p_withhold_from => person.APP_start_date,
838: p_withhold_to => ssp_smp_support_pkg.end_of_week
839: (absence.date_start -1));
840: end if;
841: --
842: -- this is the last absence period in the MPP

Line 879: p_withhold_from => ssp_smp_support_pkg.start_of_week

875: --Bug 2959482 End
876:
877: --Commented code for Bug Fix 2959482
878: /*create_stoppage (p_reason => 'Some work was done',
879: p_withhold_from => ssp_smp_support_pkg.start_of_week
880: (absence.date_end+1));*/
881: elsif
882: -- there is a period of work between two absences
883: l_work_start_date < absence.date_start

Line 890: p_withhold_from => ssp_smp_support_pkg.start_of_week

886:
887: then
888:
889: create_stoppage (p_reason => 'Some work was done',
890: p_withhold_from => ssp_smp_support_pkg.start_of_week
891: (l_work_start_date),
892: p_withhold_to => ssp_smp_support_pkg.end_of_week
893: (absence.date_start -1));
894: --

Line 892: p_withhold_to => ssp_smp_support_pkg.end_of_week

888:
889: create_stoppage (p_reason => 'Some work was done',
890: p_withhold_from => ssp_smp_support_pkg.start_of_week
891: (l_work_start_date),
892: p_withhold_to => ssp_smp_support_pkg.end_of_week
893: (absence.date_start -1));
894: --
895: if absence.date_end <> hr_general.end_of_time
896: then

Line 1001: /*to_date (ssp_smp_support_pkg.value

997: entry.effective_start_date,
998: entry.effective_end_date,
999: -- if in future we get two different rates then a decode can be added here
1000: l_high_rate RATE,
1001: /*to_date (ssp_smp_support_pkg.value
1002: (entry.element_entry_id,
1003: ssp_pad_pkg.c_week_commencing_name),
1004: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1005: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

Line 1005: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

1001: /*to_date (ssp_smp_support_pkg.value
1002: (entry.element_entry_id,
1003: ssp_pad_pkg.c_week_commencing_name),
1004: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1005: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1006: (entry.element_entry_id,
1007: ssp_pad_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1008: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1009: ssp_pad_pkg.c_amount_name)) AMOUNT,

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

1004: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1005: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1006: (entry.element_entry_id,
1007: ssp_pad_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1008: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1009: ssp_pad_pkg.c_amount_name)) AMOUNT,
1010: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1011: ssp_pad_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1012: from pay_element_entries_f ENTRY,

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

1006: (entry.element_entry_id,
1007: ssp_pad_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1008: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1009: ssp_pad_pkg.c_amount_name)) AMOUNT,
1010: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1011: ssp_pad_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1012: from pay_element_entries_f ENTRY,
1013: per_all_assignments_f asg
1014: where creator_type = c_PAD_creator_type

Line 1160: if ssp_smp_support_pkg.entry_already_processed

1156: -- don't create a new entry
1157: hypothetical_entry.dealt_with (entry_number) := 'TRUE';
1158: hr_utility.trace (l_proc||' leave unchanged');
1159: else
1160: if ssp_smp_support_pkg.entry_already_processed
1161: (old_entry.element_entry_id)
1162: then l_ins_corr_ele := TRUE;
1163: hr_utility.trace (l_proc||' processed - correct it');
1164: else

Line 1196: if ssp_smp_support_pkg.entry_already_processed

1192: hr_utility.trace (l_proc||' Rate: '||old_entry.rate);
1193: hr_utility.trace (l_proc||' Amount: '||old_entry.amount);
1194: hr_utility.trace (l_proc||' Recoverable: '
1195: ||old_entry.recoverable_amount);
1196: if ssp_smp_support_pkg.entry_already_processed
1197: (old_entry.element_entry_id)
1198: then l_ins_corr_ele := TRUE;
1199: hr_utility.trace (l_proc||' Old entry already processed');
1200: else

Line 1240: ssp_smp_support_pkg.get_entry_details (

1236: --
1237: -- Determine the next available period in which to place the
1238: -- correction entry
1239: --
1240: ssp_smp_support_pkg.get_entry_details (
1241: p_date_earned => old_entry.week_commencing,
1242: p_last_process_date => person.final_process_date,
1243: p_person_id => person.person_id,
1244: p_element_type_id => g_PAD_Correction_element.element_type_id,

Line 1410: ssp_smp_support_pkg.end_of_week

1406: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1407: --
1408: open csr_stoppages (
1409: hypothetical_entry.week_commencing (p_week_number),
1410: ssp_smp_support_pkg.end_of_week
1411: (hypothetical_entry.week_commencing (p_week_number)));
1412: --
1413: fetch csr_stoppages into l_dummy;
1414: --

Line 1553: ssp_smp_support_pkg.get_entry_details (

1549: -- Get the entry details unless the entry has been stopped (in which case
1550: -- we do not need the entry details and errors may occur if we call the
1551: -- procedure; eg the woman's assignment ends)
1552: --
1553: ssp_smp_support_pkg.get_entry_details (
1554: p_date_earned => hypothetical_entry.week_commencing
1555: (week_number),
1556: p_pay_as_lump_sum => person.pay_PAD_as_lump_sum,
1557: p_last_process_date => person.final_process_date,