1 package ssp_smp_support_pkg as
2 /* $Header: spsspbsi.pkh 120.0.12010000.2 2008/08/13 13:31:39 ubhat ship $
3 +==============================================================================+
4 | Copyright (c) 1994 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +==============================================================================+
8
9 Name
10 SSP/SMP Common Code
11 Purpose
12 To provide routines common to both SSP and SMP processes.
13 History
14 31 Aug 95 N Simpson Created
15 15 Sep 95 N Simpson Added function stoppage_overridden
16 16 Nov 95 N Simpson Renamed p_last_standard_process_date
17 in procedure get_entry_details to
18 p_last_process_date because it may
19 be the last_standard_process_date (SSP)
20 or the final_close_date (SMP).
21 5 Dec 95 N Simpson Added function average_earnings_error.
22 6 Dec 95 N Simpson Added global variable reason_for_no_earnings
23 19 Jan 96 N Simpson Added functions start_of_week and
24 end_of_week.
25 08-Jan-98 RThirlby 608724 110.0 Parameter p_deleting added to procedure
26 recalculate_ssp_and_smp - part of fix
27 for SMP element entries problem.
28 19-AUG-99 MVilrokx 855830 110.3 The testing of the bug bust revealed a
29 problem with a pragma setting. It
30 appeared that the pragma in the value
31 function was commented out for no apparent
32 reasoning causing the error. I uncommented
33 the pragma to fix the problem.
34 05-DEC-01 GButler 1759066 115.3 Added new procedure update_ssp_smp_entries
35 to allow automatic recalculation of SSP/
36 SMP entries over tax year end following
37 legislative updates to the corresponding
38 SSP/SMP rates
39 25-FEB-02 GButler 115.4 Added P_UPDATE_ERROR out parameter to
40 update_ssp_smp_entries
41 17-DEC-02 ABlinko 115.6 gscc fix
42 24-JAN-03 GButler 115.7 nocopy fixes
43 21-FEB-09 pbalu 115.8 Added multithreaded version of update_ssp_smp_entries
44 */
45 --------------------------------------------------------------------------------
46 /*This variable should be set by the ssp_ern_bus.calculate_average_earnings
47 procedure if the average earnings cannot be calculated. */
48 --
49 reason_for_no_earnings varchar2(80);
50 Type l_job_err_typ is table of varchar2(4000) index by binary_integer;
51 --
52 function entry_already_processed (p_element_entry_id in number) return boolean;
53 --
54 function NI_Lower_Earnings_Limit (p_effective_date in date) return number;
55 --
56 function value (
57 p_element_entry_id number,
58 p_input_value_name varchar2)
59 return varchar2;
60 -- put pragma back in place.
61 pragma restrict_references (value, WNDS, WNPS);
62 --
63 function element_input_value_id (
64 p_element_type_id number,
65 p_input_value_name varchar2)
66 return number;
67 --
68 pragma restrict_references (element_input_value_id, WNDS, WNPS);
69 --
70 function stoppage_overridden (
71 p_reason_id in number,
72 p_absence_attendance_id in number default null,
73 p_maternity_id in number default null) return boolean;
74 --
75 function withholding_reason_id (
76 p_element_type_id in number,
77 p_reason in varchar2) return number;
78 --
79 function start_of_week (p_date date) return date;
80 --
81 function end_of_week (p_date date) return date;
82 --
83 procedure recalculate_SSP_and_SMP (p_deleting in boolean default FALSE);
84 --
85 procedure get_entry_details (
86 p_date_earned in date,
87 p_last_process_date in date,
88 p_person_id in number,
89 p_element_type_id in number,
90 p_element_link_id in out nocopy number,
91 p_assignment_id in out nocopy number,
92 p_effective_start_date out nocopy date,
93 p_effective_end_date out nocopy date,
94 p_pay_as_lump_sum in varchar2 default 'N');
95 --
96 function average_earnings_error return varchar2;
97
98 /* Bug 1759066 */
99 procedure update_ssp_smp_entries (P_UPDATE_ERROR out nocopy BOOLEAN);
100 --
101 procedure update_ssp_smp_entries (P_UPDATE_ERROR OUT NOCOPY boolean, p_job_err OUT NOCOPY l_job_err_typ);
102 --
103 end ssp_smp_support_pkg;