1 PACKAGE hr_no_utility AS
2 /* $Header: hrnoutil.pkh 120.5 2006/12/21 10:26:43 sugarg noship $ */
3
4 --
5 --
6 -- Formats the full name for the Norway legislation.
7 --
8 FUNCTION per_no_full_name
9 (p_first_name IN VARCHAR2
10 ,p_middle_name IN VARCHAR2
11 ,p_last_name IN VARCHAR2
12 ,p_known_as IN VARCHAR2
13 ,p_title IN VARCHAR2
14 ,p_suffix IN VARCHAR2
15 ,p_pre_name_adjunct IN VARCHAR2
16 ,p_per_information1 IN VARCHAR2
17 ,p_per_information2 IN VARCHAR2
18 ,p_per_information3 IN VARCHAR2
19 ,p_per_information4 IN VARCHAR2
20 ,p_per_information5 IN VARCHAR2
21 ,p_per_information6 IN VARCHAR2
22 ,p_per_information7 IN VARCHAR2
23 ,p_per_information8 IN VARCHAR2
24 ,p_per_information9 IN VARCHAR2
25 ,p_per_information10 IN VARCHAR2
26 ,p_per_information11 IN VARCHAR2
27 ,p_per_information12 IN VARCHAR2
28 ,p_per_information13 IN VARCHAR2
29 ,p_per_information14 IN VARCHAR2
30 ,p_per_information15 IN VARCHAR2
31 ,p_per_information16 IN VARCHAR2
32 ,p_per_information17 IN VARCHAR2
33 ,p_per_information18 IN VARCHAR2
34 ,p_per_information19 IN VARCHAR2
35 ,p_per_information20 IN VARCHAR2
36 ,p_per_information21 IN VARCHAR2
37 ,p_per_information22 IN VARCHAR2
38 ,p_per_information23 IN VARCHAR2
39 ,p_per_information24 IN VARCHAR2
40 ,p_per_information25 IN VARCHAR2
41 ,p_per_information26 IN VARCHAR2
42 ,p_per_information27 IN VARCHAR2
43 ,p_per_information28 IN VARCHAR2
44 ,p_per_information29 IN VARCHAR2
45 ,p_per_information30 in VARCHAR2) RETURN VARCHAR2;
46 --
47 --
48 -- Formats the order name for the Norway legislation.
49 --
50 FUNCTION per_no_order_name
51 (p_first_name IN VARCHAR2
52 ,p_middle_name IN VARCHAR2
53 ,p_last_name IN VARCHAR2
54 ,p_known_as IN VARCHAR2
55 ,p_title IN VARCHAR2
56 ,p_suffix IN VARCHAR2
57 ,p_pre_name_adjunct IN VARCHAR2
58 ,p_per_information1 IN VARCHAR2
59 ,p_per_information2 IN VARCHAR2
60 ,p_per_information3 IN VARCHAR2
61 ,p_per_information4 IN VARCHAR2
62 ,p_per_information5 IN VARCHAR2
63 ,p_per_information6 IN VARCHAR2
64 ,p_per_information7 IN VARCHAR2
65 ,p_per_information8 IN VARCHAR2
66 ,p_per_information9 IN VARCHAR2
67 ,p_per_information10 IN VARCHAR2
68 ,p_per_information11 IN VARCHAR2
69 ,p_per_information12 IN VARCHAR2
70 ,p_per_information13 IN VARCHAR2
71 ,p_per_information14 IN VARCHAR2
72 ,p_per_information15 IN VARCHAR2
73 ,p_per_information16 IN VARCHAR2
74 ,p_per_information17 IN VARCHAR2
75 ,p_per_information18 IN VARCHAR2
76 ,p_per_information19 IN VARCHAR2
77 ,p_per_information20 IN VARCHAR2
78 ,p_per_information21 IN VARCHAR2
79 ,p_per_information22 IN VARCHAR2
80 ,p_per_information23 IN VARCHAR2
81 ,p_per_information24 IN VARCHAR2
82 ,p_per_information25 IN VARCHAR2
83 ,p_per_information26 IN VARCHAR2
84 ,p_per_information27 IN VARCHAR2
85 ,p_per_information28 IN VARCHAR2
86 ,p_per_information29 IN VARCHAR2
87 ,p_per_information30 IN VARCHAR2) RETURN VARCHAR2;
88
89 FUNCTION validate_account_number
90 (p_account_number IN VARCHAR2) RETURN NUMBER ;
91
92
93 FUNCTION chk_valid_date
94 (p_nat_id IN VARCHAR2) RETURN NUMBER ;
95
96
97
98 -- Function : get_employment_information
99 -- Parameters : assignment_id - p_assignment_id,
100 -- employment information code - l_information_code.
101 -- Description : The function returns the employment information based on the assignment id
102 -- and the information code parameters. The information is first searced for at
103 -- the assignment level through the HR_Organization level , Local Unit level ,
104 -- Legal Employer Level to the Business group level.
105 --
106 -- The values for p_emp_information_code can be
107 -- JOB_STATUS for Job Status
108 -- COND_OF_EMP for Condition of Employment
109 -- PART_FULL_TIME for Full/Part Time
110 -- SHIFT_WORK for Shift Work
111 -- PAYROLL_PERIOD for Payroll Period
112 -- AGREED_WORKING_HOURS for Agreed working hours
113
114 FUNCTION get_employment_information
115 ( p_assignment_id IN NUMBER, p_emp_information_code IN VARCHAR2 ) RETURN VARCHAR2;
116
117
118 -- function for Norway BIK to get element entry effective start date
119
120 FUNCTION Get_EE_EFF_START_DATE
121 (p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
122 p_date_earned DATE)
123 return DATE;
124
125 -- function for Norway BIK to get element entry effective end date
126
127 FUNCTION Get_EE_EFF_END_DATE
128 (p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
129 p_date_earned DATE)
130 return DATE;
131
132 -- function for Norway BIK Company Cars to get vehile information
133
134 FUNCTION get_vehicle_info
135 ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
136 p_date_earned DATE,
137 p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
138 p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
139 p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
140 )
141 return NUMBER;
142
143 -- function for Norway BIK Company Cars to get number of periods and months
144
145 FUNCTION get_num_of_periods_n_months
146 ( p_payroll_id IN PAY_PAYROLLS_F.PAYROLL_ID%TYPE ,
147 p_start_date IN DATE,
148 p_end_date IN DATE,
149 p_curr_pay_start_date IN DATE,
150 p_curr_per_pay_date IN DATE,
151 p_num_of_periods OUT NOCOPY VARCHAR2,
152 p_num_of_months OUT NOCOPY VARCHAR2
153 )
154 RETURN NUMBER;
155
156
157 -- For BIK , to get number of pay periods with pay date
158 -- in the current payroll year for Preferential Loans
159
160 FUNCTION get_num_of_periods
161 ( p_payroll_id IN PAY_PAYROLLS_F.PAYROLL_ID%TYPE ,
162 p_curr_per_pay_date IN DATE
163 )
164 RETURN NUMBER;
165
166
167 /* For BIK , to get the regular payment date
168 for the current payroll period */
169
170 FUNCTION get_regular_pay_date
171 ( p_payroll_id IN PAY_PAYROLLS_F.PAYROLL_ID%TYPE ,
172 p_Curr_Pay_Start_Date IN DATE
173 )
174 RETURN DATE;
175
176
177
178 /* Function to get the message text */
179
180 FUNCTION get_msg_text
181 ( p_applid IN NUMBER,
182 p_msg_name IN VARCHAR2
183 )
184 RETURN varchar2;
185
186 ------------------------------------------------------------------------
187 -- Function GET_TABLE_BANDS
188 ------------------------------------------------------------------------
189 FUNCTION get_table_value
190 (p_Date_Earned IN DATE
191 ,p_table_name IN VARCHAR2
192 ,p_column_name IN VARCHAR2
193 ,p_return_type IN VARCHAR2) RETURN NUMBER;
194 PROCEDURE CREATE_NO_DEI_INFO
195 (P_PERSON_ID IN NUMBER DEFAULT NULL,
196 P_ISSUED_DATE IN DATE DEFAULT NULL,
197 P_DATE_FROM IN DATE,
198 P_DATE_TO IN DATE,
199 P_DOCUMENT_NUMBER IN VARCHAR2 DEFAULT NULL,
200 P_DOCUMENT_TYPE_ID IN NUMBER
201 );
202
203 PROCEDURE UPDATE_NO_DEI_INFO
204 (P_PERSON_ID IN NUMBER DEFAULT NULL,
205 P_ISSUED_DATE IN DATE DEFAULT NULL,
206 P_DATE_FROM IN DATE,
207 P_DATE_TO IN DATE,
208 P_DOCUMENT_NUMBER IN VARCHAR2 DEFAULT NULL,
209 P_DOCUMENT_EXTRA_INFO_ID IN NUMBER,
210 P_DOCUMENT_TYPE_ID IN NUMBER
211 );
212
213
214 FUNCTION get_IANA_charset RETURN VARCHAR2;
215
216 --Function to display messages after payroll run.
217 FUNCTION get_message
218 (p_product IN VARCHAR2,
219 p_message_name IN VARCHAR2,
220 p_token1 IN VARCHAR2 DEFAULT NULL,
221 p_token2 IN VARCHAR2 DEFAULT NULL,
222 p_token3 IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
223
224
225 ---------------------------------------------------------------------------
226 -- Function : get_global_value
227 -- Function returns the global value for the given date.
228 ---------------------------------------------------------------------------
229
230 FUNCTION get_global_value (l_global_name VARCHAR2 , l_date DATE ) RETURN VARCHAR2 ;
231
232
233 END hr_no_utility;