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 2189: l_reason_id := ssp_smp_support_pkg.withholding_reason_id(

2185: hr_utility.set_location('Entering:'||l_proc,1);
2186: --
2187: check_parameters;
2188: --
2189: l_reason_id := ssp_smp_support_pkg.withholding_reason_id(
2190: g_SSP_legislation.element_type_id,p_reason);
2191: --
2192: if not ssp_smp_support_pkg.stoppage_overridden(p_absence_attendance_id => g_PIW_id,
2193: p_reason_id => l_reason_id) then

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

2188: --
2189: l_reason_id := ssp_smp_support_pkg.withholding_reason_id(
2190: g_SSP_legislation.element_type_id,p_reason);
2191: --
2192: if not ssp_smp_support_pkg.stoppage_overridden(p_absence_attendance_id => g_PIW_id,
2193: p_reason_id => l_reason_id) then
2194: -- the withholding reason is not overridden for this PIW
2195: --
2196: -- Create a stoppage for the PIW

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

2998: if cal_end_date is null or cal_end_date = hr_general.end_of_time then
2999: cal_end_date := l_max_absence_start_date +
3000: ((nvl(g_SSP_legislation.MAXIMUM_SSP_PERIOD,28) + 1) * 7);
3001: else
3002: cal_end_date := ssp_smp_support_pkg.end_of_week(l_max_absence_end_date);
3003: end if;
3004: --
3005: hr_utility.trace('Calendar end date: '||to_char(cal_end_date));
3006: cal_start_date := ssp_smp_support_pkg.start_of_week(nvl(PIW_start_date, start_date));

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

3002: cal_end_date := ssp_smp_support_pkg.end_of_week(l_max_absence_end_date);
3003: end if;
3004: --
3005: hr_utility.trace('Calendar end date: '||to_char(cal_end_date));
3006: cal_start_date := ssp_smp_support_pkg.start_of_week(nvl(PIW_start_date, start_date));
3007: --
3008: if cal_end_date > max_cal_end_date or
3009: cal_start_date < min_cal_start_date then
3010: all_pat_calendar_days := qualifying_days_in_period(

Line 3073: ssp_smp_support_pkg.start_of_week(start_date),

3069: -- Find number of qualifying days in the current calendar week.
3070: --
3071: hr_utility.trace('Finding qualifying days in current week...');
3072: qualifying_days := greatest (1,qualifying_days_in_period(
3073: ssp_smp_support_pkg.start_of_week(start_date),
3074: ssp_smp_support_pkg.end_of_week(start_date),
3075: p_absence.person_id,
3076: p_absence.business_group_id,
3077: p_processing_level => 2));

Line 3074: ssp_smp_support_pkg.end_of_week(start_date),

3070: --
3071: hr_utility.trace('Finding qualifying days in current week...');
3072: qualifying_days := greatest (1,qualifying_days_in_period(
3073: ssp_smp_support_pkg.start_of_week(start_date),
3074: ssp_smp_support_pkg.end_of_week(start_date),
3075: p_absence.person_id,
3076: p_absence.business_group_id,
3077: p_processing_level => 2));
3078: --

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

3170: --
3171: new_entry.assignment_id (N) := null;
3172: new_entry.element_link_id (N) := null;
3173: --
3174: ssp_smp_support_pkg.get_entry_details(p_date_earned => this_week.start_date,
3175: /*p_date_earned => this_week.end_date,*/
3176: p_last_process_date => absentee.last_standard_process_date,
3177: p_person_id => p_absence.person_id,
3178: p_element_type_id => g_SSP_legislation.element_type_id,

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

3277: --
3278: -- The end of the next period to be examined is the lesser of
3279: -- the end of the week and the first permanent stoppage date.
3280: --
3281: end_date := least (ssp_smp_support_pkg.end_of_week (start_date),
3282: last_entitled_day);
3283: --
3284: else
3285: --

Line 3390: l_reason_for_no_earnings :=ssp_smp_support_pkg.average_earnings_error;

3386: -- for system-generated average earnings when the earnings could not
3387: -- be derived for some reason, but to allow this procedure to
3388: -- continue, no error will be raised.
3389: --
3390: l_reason_for_no_earnings :=ssp_smp_support_pkg.average_earnings_error;
3391: --
3392: if l_reason_for_no_earnings is not null then
3393: create_stoppage (p_withhold_from => PIW_start_date,
3394: p_reason => l_reason_for_no_earnings,

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

3400: end if;
3401: end if;
3402: --
3403: -- the average earnings are lower than the NI Lower Earnings Limit
3404: if l_average_earnings < ssp_smp_support_pkg.NI_Lower_Earnings_Limit(PIW_start_date) then
3405: --
3406: -- The person does not earn enough to qualify for SSP
3407: --
3408: create_stoppage (p_withhold_from => PIW_start_date,

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

3852: else
3853: --
3854: -- The existing entry has been superseded by a new one.
3855: --
3856: if (ssp_smp_support_pkg.entry_already_processed(old_entry.element_entry_id))
3857: then
3858: --
3859: -- The processed entry must be reversed, its values are superseded.
3860: --

Line 3865: ssp_smp_support_pkg.get_entry_details (

3861: -- Insert an entry for SSP correction element in the next payroll
3862: -- period, with the old entry's amounts reversed in sign so that it
3863: -- will cancel out the old entry.
3864: --
3865: ssp_smp_support_pkg.get_entry_details (
3866: p_date_earned => old_entry.date_from,
3867: p_person_id => absentee.person_id,
3868: p_last_process_date => absentee.last_standard_process_date,
3869: p_element_type_id => g_SSP_correction.element_type_id,

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

4172: end if;
4173: end if;
4174: end loop;
4175: --
4176: -- Call the ssp_smp_support_pkg.recalculate_ssp_and_smp directly.
4177: ssp_smp_support_pkg.recalculate_ssp_and_smp(p_deleting => FALSE);
4178: --
4179: hr_utility.set_location('Leaving :'||l_proc,100);
4180: --

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

4173: end if;
4174: end loop;
4175: --
4176: -- Call the ssp_smp_support_pkg.recalculate_ssp_and_smp directly.
4177: ssp_smp_support_pkg.recalculate_ssp_and_smp(p_deleting => FALSE);
4178: --
4179: hr_utility.set_location('Leaving :'||l_proc,100);
4180: --
4181: end person_control;

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

4378: --
4379: open csr_previous_reason;
4380: fetch csr_previous_reason into l_rows_reason;
4381: if l_rows_reason > 0 then
4382: ssp_smp_support_pkg.reason_for_no_earnings:='SSP_36076_EMP_REHIRED';
4383: end if;
4384: close csr_previous_reason;
4385: --
4386: generate_payments (entitled_to_SSP (g_absence));