1 PACKAGE hr_no_utility AUTHID CURRENT_USER AS
2 /* $Header: hrnoutil.pkh 120.6.12020000.2 2012/07/04 23:17:09 amnaraya ship $ */
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 FUNCTION validate_account_entered
93 (p_acc_no IN VARCHAR2,
94 p_is_iban_acc IN varchar2 ) RETURN NUMBER;
95
96
97 FUNCTION chk_valid_date
98 (p_nat_id IN VARCHAR2) RETURN NUMBER ;
99
100
101
102 -- Function : get_employment_information
103 -- Parameters : assignment_id - p_assignment_id,
104 -- employment information code - l_information_code.
105 -- Description : The function returns the employment information based on the assignment id
106 -- and the information code parameters. The information is first searced for at
107 -- the assignment level through the HR_Organization level , Local Unit level ,
108 -- Legal Employer Level to the Business group level.
109 --
110 -- The values for p_emp_information_code can be
111 -- JOB_STATUS for Job Status
112 -- COND_OF_EMP for Condition of Employment
113 -- PART_FULL_TIME for Full/Part Time
114 -- SHIFT_WORK for Shift Work
115 -- PAYROLL_PERIOD for Payroll Period
116 -- AGREED_WORKING_HOURS for Agreed working hours
117
118 FUNCTION get_employment_information
119 ( p_assignment_id IN NUMBER, p_emp_information_code IN VARCHAR2 ) RETURN VARCHAR2;
120
121 -- Loan Start Date
122 FUNCTION Get_LOAN_START_DATE
123 (p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
124 p_date_earned DATE)
125 return DATE;
126
127
128 -- function for Norway BIK to get element entry effective start date
129
130 FUNCTION Get_EE_EFF_START_DATE
131 (p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
132 p_date_earned DATE)
133 return DATE;
134
135 -- function for Norway BIK to get element entry effective end date
136
137 FUNCTION Get_EE_EFF_END_DATE
138 (p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
139 p_date_earned DATE)
140 return DATE;
141
142 -- function for Norway BIK Company Cars to get vehile information
143
144 FUNCTION get_vehicle_info
145 ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
146 p_date_earned DATE,
147 p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
148 p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
149 p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
150 )
151 return NUMBER;
152
153 -- function for Norway BIK Company Cars to get number of periods and months
154
155 FUNCTION get_num_of_periods_n_months
156 ( p_payroll_id IN PAY_PAYROLLS_F.PAYROLL_ID%TYPE ,
157 p_start_date IN DATE,
158 p_end_date IN DATE,
159 p_curr_pay_start_date IN DATE,
160 p_curr_per_pay_date IN DATE,
161 p_num_of_periods OUT NOCOPY VARCHAR2,
162 p_num_of_months OUT NOCOPY VARCHAR2
163 )
164 RETURN NUMBER;
165
166
167 -- For BIK , to get number of pay periods with pay date
168 -- in the current payroll year for Preferential Loans
169
170 FUNCTION get_num_of_periods
171 ( p_payroll_id IN PAY_PAYROLLS_F.PAYROLL_ID%TYPE ,
172 p_curr_per_pay_date IN DATE
173 )
174 RETURN NUMBER;
175
176
177 /* For BIK , to get the regular payment date
178 for the current payroll period */
179
180 FUNCTION get_regular_pay_date
181 ( p_payroll_id IN PAY_PAYROLLS_F.PAYROLL_ID%TYPE ,
182 p_Curr_Pay_Start_Date IN DATE
183 )
184 RETURN DATE;
185
186
187
188 /* Function to get the message text */
189
190 FUNCTION get_msg_text
191 ( p_applid IN NUMBER,
192 p_msg_name IN VARCHAR2
193 )
194 RETURN varchar2;
195
196 ------------------------------------------------------------------------
197 -- Function GET_TABLE_BANDS
198 ------------------------------------------------------------------------
199 FUNCTION get_table_value
200 (p_Date_Earned IN DATE
201 ,p_table_name IN VARCHAR2
202 ,p_column_name IN VARCHAR2
203 ,p_return_type IN VARCHAR2) RETURN NUMBER;
204 PROCEDURE CREATE_NO_DEI_INFO
205 (P_PERSON_ID IN NUMBER DEFAULT NULL,
206 P_ISSUED_DATE IN DATE DEFAULT NULL,
207 P_DATE_FROM IN DATE,
208 P_DATE_TO IN DATE,
209 P_DOCUMENT_NUMBER IN VARCHAR2 DEFAULT NULL,
210 P_DOCUMENT_TYPE_ID IN NUMBER
211 );
212
213 PROCEDURE UPDATE_NO_DEI_INFO
214 (P_PERSON_ID IN NUMBER DEFAULT NULL,
215 P_ISSUED_DATE IN DATE DEFAULT NULL,
216 P_DATE_FROM IN DATE,
217 P_DATE_TO IN DATE,
218 P_DOCUMENT_NUMBER IN VARCHAR2 DEFAULT NULL,
219 P_DOCUMENT_EXTRA_INFO_ID IN NUMBER,
220 P_DOCUMENT_TYPE_ID IN NUMBER
221 );
222
223
224 FUNCTION get_IANA_charset RETURN VARCHAR2;
225
226 --Function to display messages after payroll run.
227 FUNCTION get_message
228 (p_product IN VARCHAR2,
229 p_message_name IN VARCHAR2,
230 p_token1 IN VARCHAR2 DEFAULT NULL,
231 p_token2 IN VARCHAR2 DEFAULT NULL,
232 p_token3 IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
233
234
235 ---------------------------------------------------------------------------
236 -- Function : get_global_value
237 -- Function returns the global value for the given date.
238 ---------------------------------------------------------------------------
239
240 FUNCTION get_global_value (l_global_name VARCHAR2 , l_date DATE ) RETURN VARCHAR2 ;
241
242
243 END hr_no_utility;