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 288: nvl (service.last_standard_process_date,

284: nvl (service.projected_termination_date,
285: hr_general.end_of_time) PROJECTED_TERMINATION_DATE,
286: nvl (service.actual_termination_date,
287: hr_general.end_of_time) ACTUAL_TERMINATION_DATE,
288: nvl (service.last_standard_process_date,
289: hr_general.end_of_time) LAST_STANDARD_PROCESS_DATE,
290: /* 7688727 begin */
291: nvl (service.final_process_date,
292: hr_general.end_of_time) FINAL_PROCESS_DATE,

Line 289: hr_general.end_of_time) LAST_STANDARD_PROCESS_DATE,

285: hr_general.end_of_time) PROJECTED_TERMINATION_DATE,
286: nvl (service.actual_termination_date,
287: hr_general.end_of_time) ACTUAL_TERMINATION_DATE,
288: nvl (service.last_standard_process_date,
289: hr_general.end_of_time) LAST_STANDARD_PROCESS_DATE,
290: /* 7688727 begin */
291: nvl (service.final_process_date,
292: hr_general.end_of_time) FINAL_PROCESS_DATE,
293: /* 7688727 End */

Line 404: function Standard_week_fraction (

400: hr_utility.set_location('Leaving :'||l_proc,100);
401: --
402: end get_absence_details;
403: --------------------------------------------------------------------------------
404: function Standard_week_fraction (
405: --
406: -- Returns the legislative standard fraction to be used for a specified number
407: -- of qualifying days in a week.
408: --

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

402: end get_absence_details;
403: --------------------------------------------------------------------------------
404: function Standard_week_fraction (
405: --
406: -- Returns the legislative standard fraction to be used for a specified number
407: -- of qualifying days in a week.
408: --
409: p_qualifying_days in integer)
410: --

Line 413: standard_fraction number;

409: p_qualifying_days in integer)
410: --
411: return number is
412: --
413: standard_fraction number;
414: l_proc varchar2 (72) := g_package||'Standard_week_fraction';
415: --
416: procedure check_parameters is
417: --

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

410: --
411: return number is
412: --
413: standard_fraction number;
414: l_proc varchar2 (72) := g_package||'Standard_week_fraction';
415: --
416: procedure check_parameters is
417: --
418: all_parameters_valid constant boolean := (p_qualifying_days is not null

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

432: hr_utility.set_location('Entering:'||l_proc,1);
433: --
434: check_parameters;
435: --
436: if p_qualifying_days = 1 then standard_fraction := 1;
437: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
438: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
439: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
440: elsif p_qualifying_days = 5 then standard_fraction := 0.2;

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

433: --
434: check_parameters;
435: --
436: if p_qualifying_days = 1 then standard_fraction := 1;
437: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
438: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
439: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
440: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
441: elsif p_qualifying_days = 6 then standard_fraction := 0.167;

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

434: check_parameters;
435: --
436: if p_qualifying_days = 1 then standard_fraction := 1;
437: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
438: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
439: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
440: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
441: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
442: elsif p_qualifying_days = 7 then standard_fraction := 0.143;

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

435: --
436: if p_qualifying_days = 1 then standard_fraction := 1;
437: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
438: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
439: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
440: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
441: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
442: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
443: end if;

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

436: if p_qualifying_days = 1 then standard_fraction := 1;
437: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
438: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
439: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
440: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
441: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
442: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
443: end if;
444: --

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

437: elsif p_qualifying_days = 2 then standard_fraction := 0.5;
438: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
439: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
440: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
441: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
442: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
443: end if;
444: --
445: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));

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

438: elsif p_qualifying_days = 3 then standard_fraction := 0.334;
439: elsif p_qualifying_days = 4 then standard_fraction := 0.25;
440: elsif p_qualifying_days = 5 then standard_fraction := 0.2;
441: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
442: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
443: end if;
444: --
445: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));
446: hr_utility.set_location('Leaving :'||l_proc,100);

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

441: elsif p_qualifying_days = 6 then standard_fraction := 0.167;
442: elsif p_qualifying_days = 7 then standard_fraction := 0.143;
443: end if;
444: --
445: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));
446: hr_utility.set_location('Leaving :'||l_proc,100);
447: --
448: return standard_fraction;
449: --

Line 448: return standard_fraction;

444: --
445: hr_utility.trace (l_proc||' standard_fraction = '||to_char(standard_fraction));
446: hr_utility.set_location('Leaving :'||l_proc,100);
447: --
448: return standard_fraction;
449: --
450: end standard_week_fraction;
451: --------------------------------------------------------------------------------
452: procedure get_SSP_element (p_effective_date in date) is

Line 450: end standard_week_fraction;

446: hr_utility.set_location('Leaving :'||l_proc,100);
447: --
448: return standard_fraction;
449: --
450: end standard_week_fraction;
451: --------------------------------------------------------------------------------
452: procedure get_SSP_element (p_effective_date in date) is
453: --
454: -- Get the SSP element legislative parameters

Line 3200: standard_week_fraction (qualifying_days));

3196: -- We must work out how many days of liability remain.
3197: --
3198: days_remaining := ceil(weeks_remaining /
3199: ---------------------------------------
3200: standard_week_fraction (qualifying_days));
3201: --
3202: -- Now drag the end date back to the date on which
3203: -- SSP ceases to be payable.
3204: --

Line 3290: p_last_process_date => absentee.last_standard_process_date,

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