eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SSP_SSP_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 126: ssp_smp_support_pkg.value

122: 30.52 19-Jun-98 563202 AParkes Re-wrote absence_is_a_PIW to avoid
123: calling unnecessary sql.
124: Changed csr_existing_entries to avoid
125: using dt views and stop calling
126: ssp_smp_support_pkg.value
127: Added history for 30.51
128: 30.53 19-AUG-98 563202 A.Myers Loads of changes to improve efficiency,
129: /701750 such as using pl/sql tables, creating
130: calendar for the whole PIW, not just

Line 162: the ssp_smp_support_pkg.reason_for_no_earnings

158: in 10.7 and was causing incorrect results
159: to be returned when checking for SSP
160: installation
161: 115.16 22-FEB-02 1310170 ABhaduri Added cursor csr_previous_reason to populate
162: the ssp_smp_support_pkg.reason_for_no_earnings
163: variable when the employee is rehired and the
164: absence is getting saved for the second time.
165: 115.21 05-NOV-02 2620894 srjadhav Changed the code so that MPP start date is
166: the next day after first working day

Line 2300: l_reason_id := ssp_smp_support_pkg.withholding_reason_id(

2296: hr_utility.set_location('Entering:'||l_proc,1);
2297: --
2298: check_parameters;
2299: --
2300: l_reason_id := ssp_smp_support_pkg.withholding_reason_id(
2301: g_SSP_legislation.element_type_id,p_reason);
2302: --
2303: if not ssp_smp_support_pkg.stoppage_overridden(p_absence_attendance_id => g_PIW_id,
2304: p_reason_id => l_reason_id) then

Line 2303: if not ssp_smp_support_pkg.stoppage_overridden(p_absence_attendance_id => g_PIW_id,

2299: --
2300: l_reason_id := ssp_smp_support_pkg.withholding_reason_id(
2301: g_SSP_legislation.element_type_id,p_reason);
2302: --
2303: if not ssp_smp_support_pkg.stoppage_overridden(p_absence_attendance_id => g_PIW_id,
2304: p_reason_id => l_reason_id) then
2305: -- the withholding reason is not overridden for this PIW
2306: --
2307: -- Create a stoppage for the PIW

Line 3116: cal_end_date := ssp_smp_support_pkg.end_of_week(l_max_absence_end_date);

3112: if cal_end_date is null or cal_end_date = hr_general.end_of_time then
3113: cal_end_date := l_max_absence_start_date +
3114: ((nvl(g_SSP_legislation.MAXIMUM_SSP_PERIOD,28) + 1) * 7);
3115: else
3116: cal_end_date := ssp_smp_support_pkg.end_of_week(l_max_absence_end_date);
3117: end if;
3118: --
3119: hr_utility.trace('Calendar end date: '||to_char(cal_end_date));
3120: cal_start_date := ssp_smp_support_pkg.start_of_week(nvl(PIW_start_date, start_date));

Line 3120: cal_start_date := ssp_smp_support_pkg.start_of_week(nvl(PIW_start_date, start_date));

3116: cal_end_date := ssp_smp_support_pkg.end_of_week(l_max_absence_end_date);
3117: end if;
3118: --
3119: hr_utility.trace('Calendar end date: '||to_char(cal_end_date));
3120: cal_start_date := ssp_smp_support_pkg.start_of_week(nvl(PIW_start_date, start_date));
3121: --
3122: if cal_end_date > max_cal_end_date or
3123: cal_start_date < min_cal_start_date then
3124: all_pat_calendar_days := qualifying_days_in_period(

Line 3187: ssp_smp_support_pkg.start_of_week(start_date),

3183: -- Find number of qualifying days in the current calendar week.
3184: --
3185: hr_utility.trace('Finding qualifying days in current week...');
3186: qualifying_days := greatest (1,qualifying_days_in_period(
3187: ssp_smp_support_pkg.start_of_week(start_date),
3188: ssp_smp_support_pkg.end_of_week(start_date),
3189: p_absence.person_id,
3190: p_absence.business_group_id,
3191: p_processing_level => 2));

Line 3188: ssp_smp_support_pkg.end_of_week(start_date),

3184: --
3185: hr_utility.trace('Finding qualifying days in current week...');
3186: qualifying_days := greatest (1,qualifying_days_in_period(
3187: ssp_smp_support_pkg.start_of_week(start_date),
3188: ssp_smp_support_pkg.end_of_week(start_date),
3189: p_absence.person_id,
3190: p_absence.business_group_id,
3191: p_processing_level => 2));
3192: --

Line 3288: ssp_smp_support_pkg.get_entry_details(p_date_earned => this_week.start_date,

3284: --
3285: new_entry.assignment_id (N) := null;
3286: new_entry.element_link_id (N) := null;
3287: --
3288: ssp_smp_support_pkg.get_entry_details(p_date_earned => this_week.start_date,
3289: /*p_date_earned => this_week.end_date,*/
3290: p_last_process_date => absentee.last_standard_process_date,
3291: p_person_id => p_absence.person_id,
3292: p_element_type_id => g_SSP_legislation.element_type_id,

Line 3395: end_date := least (ssp_smp_support_pkg.end_of_week (start_date),

3391: --
3392: -- The end of the next period to be examined is the lesser of
3393: -- the end of the week and the first permanent stoppage date.
3394: --
3395: end_date := least (ssp_smp_support_pkg.end_of_week (start_date),
3396: last_entitled_day);
3397: --
3398: else
3399: --

Line 3504: l_reason_for_no_earnings :=ssp_smp_support_pkg.average_earnings_error;

3500: -- for system-generated average earnings when the earnings could not
3501: -- be derived for some reason, but to allow this procedure to
3502: -- continue, no error will be raised.
3503: --
3504: l_reason_for_no_earnings :=ssp_smp_support_pkg.average_earnings_error;
3505: --
3506: if l_reason_for_no_earnings is not null then
3507: create_stoppage (p_withhold_from => PIW_start_date,
3508: p_reason => l_reason_for_no_earnings,

Line 3518: if l_average_earnings < ssp_smp_support_pkg.NI_Lower_Earnings_Limit(PIW_start_date) then

3514: end if;
3515: end if;
3516: --
3517: -- the average earnings are lower than the NI Lower Earnings Limit
3518: if l_average_earnings < ssp_smp_support_pkg.NI_Lower_Earnings_Limit(PIW_start_date) then
3519: --
3520: -- The person does not earn enough to qualify for SSP
3521: --
3522: create_stoppage (p_withhold_from => PIW_start_date,

Line 3980: if (ssp_smp_support_pkg.entry_already_processed(old_entry.element_entry_id))

3976: --
3977: -- The existing entry has been superseded by a new one.
3978: --
3979: hr_utility.set_location(l_proc,5);
3980: if (ssp_smp_support_pkg.entry_already_processed(old_entry.element_entry_id))
3981: then
3982: --
3983: -- The processed entry must be reversed, its values are superseded.
3984: --

Line 3991: ssp_smp_support_pkg.get_entry_details (

3987: -- will cancel out the old entry.
3988: --
3989: --Changed the last_process_date to FINAL_PROCESS_DATE for debug purpose
3990: hr_utility.set_location(l_proc,6);
3991: ssp_smp_support_pkg.get_entry_details (
3992: p_date_earned => old_entry.date_from,
3993: p_person_id => absentee.person_id,
3994: p_last_process_date => absentee.final_process_date, /*7688727 changed from LSP date to FPD */
3995: p_element_type_id => g_SSP_correction.element_type_id,

Line 4308: -- Call the ssp_smp_support_pkg.recalculate_ssp_and_smp directly.

4304: end if;
4305: end if;
4306: end loop;
4307: --
4308: -- Call the ssp_smp_support_pkg.recalculate_ssp_and_smp directly.
4309: ssp_smp_support_pkg.recalculate_ssp_and_smp(p_deleting => FALSE);
4310: --
4311: hr_utility.set_location('Leaving :'||l_proc,100);
4312: --

Line 4309: ssp_smp_support_pkg.recalculate_ssp_and_smp(p_deleting => FALSE);

4305: end if;
4306: end loop;
4307: --
4308: -- Call the ssp_smp_support_pkg.recalculate_ssp_and_smp directly.
4309: ssp_smp_support_pkg.recalculate_ssp_and_smp(p_deleting => FALSE);
4310: --
4311: hr_utility.set_location('Leaving :'||l_proc,100);
4312: --
4313: end person_control;

Line 4519: ssp_smp_support_pkg.reason_for_no_earnings:='SSP_36076_EMP_REHIRED';

4515: open csr_previous_reason;
4516: fetch csr_previous_reason into l_rows_reason;
4517: if l_rows_reason > 0 then
4518: hr_utility.set_location(l_proc,3);
4519: ssp_smp_support_pkg.reason_for_no_earnings:='SSP_36076_EMP_REHIRED';
4520: hr_utility.set_location(l_proc,4);
4521: end if;
4522: close csr_previous_reason;
4523: --