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 STANDARD

Line 95: comply with PKM standards.

91: from 30.12) ****
92: This is the latest version of package
93: for any latest Prod releases. ****
94: Also added new 'Change List' header to
95: comply with PKM standards.
96: 30.43 09-jun-97 502108 RThirlby Forced SSP_rate_figure to be based
97: on the sickness_start_date instead
98: of the PIW_start_date.
99: 30.44 18-jul-97 513292 RThirlby Altered qualifying_days_in_period to

Line 131: for each absence. Also added standard

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
131: for each absence. Also added standard
132: trace.
133: 110.13 16-AUG-99 886707 MVilrokx The initialisation of l_stopage_found
134: parameter was not correct. Moved it
135: inside the loop so it is reset every

Line 279: nvl (service.last_standard_process_date,

275: nvl (service.projected_termination_date,
276: hr_general.end_of_time) PROJECTED_TERMINATION_DATE,
277: nvl (service.actual_termination_date,
278: hr_general.end_of_time) ACTUAL_TERMINATION_DATE,
279: nvl (service.last_standard_process_date,
280: hr_general.end_of_time) LAST_STANDARD_PROCESS_DATE,
281: service.leaving_reason
282: from per_all_people_f PERSON,
283: per_periods_of_service SERVICE

Line 280: hr_general.end_of_time) LAST_STANDARD_PROCESS_DATE,

276: hr_general.end_of_time) PROJECTED_TERMINATION_DATE,
277: nvl (service.actual_termination_date,
278: hr_general.end_of_time) ACTUAL_TERMINATION_DATE,
279: nvl (service.last_standard_process_date,
280: hr_general.end_of_time) LAST_STANDARD_PROCESS_DATE,
281: service.leaving_reason
282: from per_all_people_f PERSON,
283: per_periods_of_service SERVICE
284: where person.person_id = p_person_id

Line 391: function Standard_week_fraction (

387: hr_utility.set_location('Leaving :'||l_proc,100);
388: --
389: end get_absence_details;
390: --------------------------------------------------------------------------------
391: function Standard_week_fraction (
392: --
393: -- Returns the legislative standard fraction to be used for a specified number
394: -- of qualifying days in a week.
395: --

Line 393: -- Returns the legislative standard fraction to be used for a specified number

389: end get_absence_details;
390: --------------------------------------------------------------------------------
391: function Standard_week_fraction (
392: --
393: -- Returns the legislative standard fraction to be used for a specified number
394: -- of qualifying days in a week.
395: --
396: p_qualifying_days in integer)
397: --

Line 400: standard_fraction number;

396: p_qualifying_days in integer)
397: --
398: return number is
399: --
400: standard_fraction number;
401: l_proc varchar2 (72) := g_package||'Standard_week_fraction';
402: --
403: procedure check_parameters is
404: --

Line 401: l_proc varchar2 (72) := g_package||'Standard_week_fraction';

397: --
398: return number is
399: --
400: standard_fraction number;
401: l_proc varchar2 (72) := g_package||'Standard_week_fraction';
402: --
403: procedure check_parameters is
404: --
405: all_parameters_valid constant boolean := (p_qualifying_days is not null

Line 423: if p_qualifying_days = 1 then standard_fraction := 1;

419: hr_utility.set_location('Entering:'||l_proc,1);
420: --
421: check_parameters;
422: --
423: if p_qualifying_days = 1 then standard_fraction := 1;
424: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
425: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
426: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
427: elsif p_qualifying_days = 5 then standard_fraction := 0.2;

Line 424: elsif p_qualifying_days = 2 then standard_fraction := 0.5;

420: --
421: check_parameters;
422: --
423: if p_qualifying_days = 1 then standard_fraction := 1;
424: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
425: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
426: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
427: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
428: elsif p_qualifying_days = 6 then standard_fraction := 0.167;

Line 425: elsif p_qualifying_days = 3 then standard_fraction := 0.334;

421: check_parameters;
422: --
423: if p_qualifying_days = 1 then standard_fraction := 1;
424: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
425: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
426: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
427: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
428: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
429: elsif p_qualifying_days = 7 then standard_fraction := 0.143;

Line 426: elsif p_qualifying_days = 4 then standard_fraction := 0.25;

422: --
423: if p_qualifying_days = 1 then standard_fraction := 1;
424: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
425: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
426: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
427: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
428: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
429: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
430: end if;

Line 427: elsif p_qualifying_days = 5 then standard_fraction := 0.2;

423: if p_qualifying_days = 1 then standard_fraction := 1;
424: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
425: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
426: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
427: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
428: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
429: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
430: end if;
431: --

Line 428: elsif p_qualifying_days = 6 then standard_fraction := 0.167;

424: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
425: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
426: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
427: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
428: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
429: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
430: end if;
431: --
432: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));

Line 429: elsif p_qualifying_days = 7 then standard_fraction := 0.143;

425: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
426: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
427: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
428: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
429: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
430: end if;
431: --
432: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));
433: hr_utility.set_location('Leaving :'||l_proc,100);

Line 432: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));

428: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
429: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
430: end if;
431: --
432: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));
433: hr_utility.set_location('Leaving :'||l_proc,100);
434: --
435: return standard_fraction;
436: --

Line 435: return standard_fraction;

431: --
432: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));
433: hr_utility.set_location('Leaving :'||l_proc,100);
434: --
435: return standard_fraction;
436: --
437: end standard_week_fraction;
438: --------------------------------------------------------------------------------
439: procedure get_SSP_element (p_effective_date in date) is

Line 437: end standard_week_fraction;

433: hr_utility.set_location('Leaving :'||l_proc,100);
434: --
435: return standard_fraction;
436: --
437: end standard_week_fraction;
438: --------------------------------------------------------------------------------
439: procedure get_SSP_element (p_effective_date in date) is
440: --
441: -- Get the SSP element legislative parameters

Line 3086: standard_week_fraction (qualifying_days));

3082: -- We must work out how many days of liability remain.
3083: --
3084: days_remaining := ceil(weeks_remaining /
3085: ---------------------------------------
3086: standard_week_fraction (qualifying_days));
3087: --
3088: -- Now drag the end date back to the date on which
3089: -- SSP ceases to be payable.
3090: --

Line 3176: p_last_process_date => absentee.last_standard_process_date,

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,
3179: p_assignment_id => new_entry.assignment_id (N),
3180: p_element_link_id => new_entry.element_link_id (N),

Line 3868: p_last_process_date => absentee.last_standard_process_date,

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,
3870: p_element_link_id => old_entry.element_link_id,
3871: p_assignment_id => old_entry.assignment_id,
3872: p_effective_start_date => old_entry.effective_start_date,