1 package pay_kr_entries_pkg AUTHID CURRENT_USER as
2 /* $Header: pykretr.pkh 120.9.12020000.3 2012/08/31 13:15:14 scireddy ship $ */
3 -- size limit of input value in one element = 15
4 g_iv_max constant integer := 15;
5
6 type ev_rec is record
7 (
8 input_value_id pay_input_values_f.input_value_id%TYPE,
9 entry_value pay_element_entry_values_f.screen_entry_value%TYPE,
10 d_entry_value hr_lookups.meaning%TYPE
11 );
12
13 type ev_rec_tbl is table of ev_rec index by binary_integer;
14
18 -- elm_tbl(element_type_id).element_code
15 --
16 -- For Forms cache.
17 -- <How to use>
19 -- iv_tbl(input_value_id).display_sequence
20 --
21 type elm_code_tbl is table of pay_element_types_f.element_name%TYPE index by binary_integer;
22 type elm_rec is record
23 (
24 element_code pay_element_types_f.element_name%TYPE,
25 input_currency_code pay_element_types_f.input_currency_code%TYPE,
26 multiple_entries_allowed_flag pay_element_types_f.multiple_entries_allowed_flag%TYPE
27 );
28 type elm_rec_tbl is table of elm_rec index by binary_integer;
29
30 type iv_rec is record
31 (
32 element_type_id pay_input_values_f.element_type_id%TYPE,
33 display_sequence pay_input_values_f.display_sequence%TYPE,
34 uom pay_input_values_f.uom%TYPE,
35 mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
36 max_length number,
37 format_mask varchar2(80)
38 );
39
40 type iv_rec_tbl is table of iv_rec index by binary_integer;
41
42 -- ---------------------------------------------------------------------
43 -- |------------------------< calc_age >-------------------------------|
44 -- ---------------------------------------------------------------------
45 -- Calculation age of person from registration number
46 function calc_age
47 (
48 p_national_identifier in varchar2,
49 p_date_of_birth in date,
50 p_effective_date in date
51 ) return number;
52
53 -- ---------------------------------------------------------------------
54 -- ---------------------------------------------------------------------
55 -- |------------------------< derive_attributes >----------------------|
56 -- ---------------------------------------------------------------------
57 -- Call this procedure in the following triggers.
58 -- 1) PRE-FORM
59 -- 2) INIT_DATE_DEPENDENT
60 -- On Forms, set properties using output variables.
61 Procedure derive_attributes
62 (
63 p_elm_code_tbl in elm_code_tbl,
64 p_effective_date in date,
65 p_business_group_id in number,
66 p_elm_rec_tbl out NOCOPY elm_rec_tbl,
67 p_iv_rec_tbl out NOCOPY iv_rec_tbl
68 );
69
70 -- ---------------------------------------------------------------------
71 -- |------------------------< derive_format_mask >---------------------|
72 -- ---------------------------------------------------------------------
73 -- Call this procedure in the following triggers.
74 -- 1) PRE-FORM
75 -- On Forms, set properties using output variables.
76 Procedure derive_format_mask
77 (
78 p_elm_rec_tbl in elm_rec_tbl,
79 p_iv_rec_tbl in out NOCOPY iv_rec_tbl
80 );
81
82 -- ---------------------------------------------------------------------
83 -- |-----------------------------< chk_entry >-------------------------|
84 -- ---------------------------------------------------------------------
85 -- This procedure must be called "once" on the following Forms trigger.
86 -- 1) WHEN-DATABASE-RECORD(when INSERTING)
87 -- Not necessary to call this procedure on WHEN-VALIDATE-ITEM trigger
88 -- when updating.
89 -- When deleting, this procedure is called in part of API.
90 -- Call derive_default_values procedure instead of this procedure chk_entry.
91 Procedure chk_entry
92 (
93 p_element_entry_id in number,
94 p_assignment_id in number,
95 p_element_link_id in number,
96 p_entry_type in varchar2,
97 p_original_entry_id in number default null,
98 p_target_entry_id in number default null,
99 p_effective_date in date,
100 p_validation_start_date in date,
101 p_validation_end_date in date,
102 p_effective_start_date in out NOCOPY date,
103 p_effective_end_date in out NOCOPY date,
104 p_usage in varchar2,
105 p_dt_update_mode in varchar2,
106 p_dt_delete_mode in varchar2
107 );
108
109 -- ---------------------------------------------------------------------
110 -- |---------------------< derive_default_values >---------------------|
111 -- ---------------------------------------------------------------------
112 -- This procedure must be called in the following trigger.
113 -- 1) WHEN-DATABASE-RECORD(when INSERTING)
114 -- This procedure includes chk_entry procedure.
115 Procedure derive_default_values
116 (
117 p_assignment_id in number,
118 p_element_code in varchar2,
119 p_business_group_id in varchar2,
120 p_entry_type in varchar2,
121 p_element_link_id out NOCOPY number,
122 p_ev_rec_tbl out NOCOPY ev_rec_tbl,
123 p_effective_date in date,
124 p_effective_start_date in out NOCOPY date,
125 p_effective_end_date in out NOCOPY date
126 );
127
128 -- ---------------------------------------------------------------------
129 -- |---------------------------< chk_entry_value >---------------------|
130 -- ---------------------------------------------------------------------
131 -- This procedure must be called every time before dtcsapi call.
132 Procedure chk_entry_value
133 (
134 p_element_link_id in number,
135 p_input_value_id in number,
136 p_effective_date in date,
137 p_business_group_id in number,
138 p_assignment_id in number,
139 p_user_value in out NOCOPY varchar2,
140 p_canonical_value out NOCOPY varchar2,
141 p_hot_defaulted out NOCOPY boolean,
142 p_min_max_warning out NOCOPY boolean,
146 p_formula_message out NOCOPY varchar2
143 p_user_min_value out NOCOPY varchar2,
144 p_user_max_value out NOCOPY varchar2,
145 p_formula_warning out NOCOPY boolean,
147 );
148
149 -- ---------------------------------------------------------------------
150 -- |--------------------------< find_dt_upd_modes >--------------------|
151 -- ---------------------------------------------------------------------
152 Procedure find_dt_upd_modes
153 (
154 p_effective_date in date,
155 p_base_key_value in number,
156 p_correction out NOCOPY boolean,
157 p_update out NOCOPY boolean,
158 p_update_override out NOCOPY boolean,
159 p_update_change_insert out NOCOPY boolean
160 );
161
162 -- ---------------------------------------------------------------------
163 -- |--------------------------< find_dt_del_modes >--------------------|
164 -- ---------------------------------------------------------------------
165 Procedure find_dt_del_modes
166 (
167 p_effective_date in date,
168 p_base_key_value in number,
169 p_zap out NOCOPY boolean,
170 p_delete out NOCOPY boolean,
171 p_future_change out NOCOPY boolean,
172 p_delete_next_change out NOCOPY boolean
173 );
174
175 -- ---------------------------------------------------------------------
176 -- |-------------------------------< ins_lck >-------------------------|
177 -- ---------------------------------------------------------------------
178 Procedure ins_lck
179 (
180 p_effective_date in date,
181 p_datetrack_mode in varchar2,
182 p_rec in pay_element_entries_f%ROWTYPE,
183 p_validation_start_date out NOCOPY date,
184 p_validation_end_date out NOCOPY date
185 );
186
187 -- ---------------------------------------------------------------------
188 -- |---------------------------------< lck >---------------------------|
189 -- ---------------------------------------------------------------------
190 Procedure lck
191 (
192 p_effective_date in date,
193 p_datetrack_mode in varchar2,
194 p_element_entry_id in number,
195 p_object_version_number in number,
196 p_validation_start_date out NOCOPY date,
197 p_validation_end_date out NOCOPY date
198 );
199
200 -- ---------------------------------------------------------------------
201 -- |-------------------------------< ins >-----------------------------|
202 -- ---------------------------------------------------------------------
203 Procedure ins
204 (
205 p_validate in boolean,
206 p_effective_date in date,
207 p_assignment_id in number,
208 p_element_link_id in number,
209 p_ev_rec_tbl in ev_rec_tbl,
210 p_business_group_id in number,
211 p_element_entry_id out NOCOPY number,
212 p_effective_start_date out NOCOPY date,
213 p_effective_end_date out NOCOPY date,
214 p_object_version_number out NOCOPY number
215 );
216
217 -- ---------------------------------------------------------------------
218 -- |-------------------------------< upd >-----------------------------|
219 -- ---------------------------------------------------------------------
220 Procedure upd
221 (
222 p_validate in boolean,
223 p_effective_date in date,
224 p_datetrack_update_mode in varchar2,
225 p_element_entry_id in number,
226 p_object_version_number in out NOCOPY number,
227 p_ev_rec_tbl in ev_rec_tbl,
228 p_business_group_id in number,
229 p_effective_start_date out NOCOPY date,
230 p_effective_end_date out NOCOPY date
231 );
232
233 -- ---------------------------------------------------------------------
234 -- |-------------------------------< del >-----------------------------|
235 -- ---------------------------------------------------------------------
236 Procedure del
237 (
238 p_validate in boolean,
239 p_effective_date in date,
240 p_datetrack_delete_mode in varchar2,
241 p_element_entry_id in number,
242 p_object_version_number in out NOCOPY number,
243 p_effective_start_date out NOCOPY date,
244 p_effective_end_date out NOCOPY date
245 );
246
247 -- ---------------------------------------------------------------------
248 -- Function to handle contact relationship data
249 -- ---------------------------------------------------------------------
250 -- upd_contact_info
251 -- ---------------------------------------------------------------------
252 procedure upd_contact_info
253 ( p_validate in boolean default null
254 ,p_effective_date in date
255 ,p_contact_relationship_id in number
256 ,p_object_version_number in out NOCOPY number
257 ,p_cont_information2 in varchar2 default null
258 ,p_cont_information3 in varchar2 default null
259 ,p_cont_information4 in varchar2 default null
260 ,p_cont_information5 in varchar2 default null
261 ,p_cont_information7 in varchar2 default null
262 ,p_cont_information8 in varchar2 default null
263 ,p_cont_information10 in varchar2 default null
264 ,p_cont_information12 in varchar2 default null
265 ,p_cont_information13 in varchar2 default null
266 ,p_cont_information14 in varchar2 default null
267 );
268
272 -- upd_contact_info
269 -- ---------------------------------------------------------------------
270 -- Procedure to handle contact Extra Information Data
271 -- ---------------------------------------------------------------------
273 -- ---------------------------------------------------------------------
274 procedure upd_contact_extra_info
275 ( p_effective_date IN DATE,
276 p_contact_extra_info_id IN NUMBER,
277 p_contact_relationship_id IN NUMBER,
278 p_contact_ovn IN OUT NOCOPY NUMBER,
279 p_cei_information1 IN VARCHAR2,
280 p_cei_information2 IN VARCHAR2,
281 p_cei_information3 IN VARCHAR2,
282 p_cei_information4 IN VARCHAR2,
283 p_cei_information5 IN VARCHAR2,
284 p_cei_information6 IN VARCHAR2,
285 p_cei_information7 IN VARCHAR2,
286 p_cei_information8 IN VARCHAR2,
287 p_cei_information9 IN VARCHAR2,
288 p_cei_information10 IN VARCHAR2, -- Bug 5667762
289 p_cei_information11 IN VARCHAR2,
290 p_cei_information12 IN VARCHAR2, -- Bug 6630135
291 p_cei_information13 IN VARCHAR2, -- Bug 6705170
292 p_cei_information14 IN VARCHAR2, -- Bug 7142612
293 p_cei_information15 IN VARCHAR2, -- Bug 7142612
294 p_cei_information16 IN VARCHAR2, -- Bug 9737699
295 p_cei_information17 IN VARCHAR2, -- Bug 9737699
296 p_cei_information18 IN VARCHAR2, -- Bug 14219478
297 p_cei_information19 IN VARCHAR2, -- Bug 14219478
298 p_cei_information20 IN VARCHAR2, -- Bug 14219478
299 p_cei_information21 IN VARCHAR2, -- Bug 14219478
300 p_cei_information22 IN VARCHAR2, -- Bug 14502155
301 p_cei_information23 IN VARCHAR2, -- Bug 14502155
302 p_cei_information24 IN VARCHAR2, -- Bug 14502155
303 p_cei_effective_start_date OUT NOCOPY DATE,
304 p_cei_effective_end_date OUT NOCOPY DATE
305 );
306
307 -- ---------------------------------------------------------------------
308 -- Procedure to handle contact Extra Information Data
309 -- ---------------------------------------------------------------------
310 -- create_contact_extra_info
311 -- ---------------------------------------------------------------------
312
313 procedure create_contact_extra_info
314 ( p_effective_date IN DATE,
315 p_contact_extra_info_id OUT NOCOPY NUMBER,
316 p_contact_relationship_id IN NUMBER,
317 p_contact_ovn OUT NOCOPY NUMBER,
318 p_cei_information1 IN VARCHAR2,
319 p_cei_information2 IN VARCHAR2,
320 p_cei_information3 IN VARCHAR2,
321 p_cei_information4 IN VARCHAR2,
322 p_cei_information5 IN VARCHAR2,
323 p_cei_information6 IN VARCHAR2,
324 p_cei_information7 IN VARCHAR2,
325 p_cei_information8 IN VARCHAR2,
326 p_cei_information9 IN VARCHAR2,
327 p_cei_information10 IN VARCHAR2, -- Bug 5667762
331 p_cei_information14 IN VARCHAR2, -- Bug 7142612
328 p_cei_information11 IN VARCHAR2,
329 p_cei_information12 IN VARCHAR2, -- Bug 6630135
330 p_cei_information13 IN VARCHAR2, -- Bug 6705170
332 p_cei_information15 IN VARCHAR2, -- Bug 7142612
333 p_cei_information16 IN VARCHAR2, -- Bug 9737699
334 p_cei_information17 IN VARCHAR2, -- Bug 9737699
335 p_cei_information18 IN VARCHAR2, -- Bug 14219478
336 p_cei_information19 IN VARCHAR2, -- Bug 14219478
337 p_cei_information20 IN VARCHAR2, -- Bug 14219478
338 p_cei_information21 IN VARCHAR2, -- Bug 14219478
339 p_cei_information22 IN VARCHAR2, -- Bug 14502155
340 p_cei_information23 IN VARCHAR2, -- Bug 14502155
341 p_cei_information24 IN VARCHAR2, -- Bug 14502155
342 p_cei_effective_start_date OUT NOCOPY DATE,
343 p_cei_effective_end_date OUT NOCOPY DATE
344 );
345
346 end pay_kr_entries_pkg;