1 package PAY_PAYWSMEE_PKG AUTHID CURRENT_USER as
2 /* $Header: paywsmee.pkh 120.1 2005/07/13 08:08:25 swinton noship $ */
3 --
4 function formatted_default ( p_link_default varchar2,
5 p_type_default varchar2,
6 p_uom varchar2,
7 p_hot_default varchar2,
8 p_contributions_used varchar2,
9 p_input_value_name varchar2,
10 p_input_currency_code varchar2,
11 p_lookup_type varchar2,
12 p_value_set_id number default null) return varchar2;
13 --pragma restrict_references (formatted_default, WNDS, WNPS);
14 --
15 procedure get_entry_value_details (
16 --
17 p_element_entry_id number,
18 p_element_link_id number,
19 p_effective_date date,
20 p_ee_effective_start_date date,
21 p_ee_effective_end_date date,
22 p_element_type_id number,
23 p_business_group_id number,
24 p_contributions_used varchar2,
25 p_input_currency_code varchar2,
26 p_input_value_id1 in out nocopy number,
27 p_input_value_id2 in out nocopy number,
28 p_input_value_id3 in out nocopy number,
29 p_input_value_id4 in out nocopy number,
30 p_input_value_id5 in out nocopy number,
31 p_input_value_id6 in out nocopy number,
32 p_input_value_id7 in out nocopy number,
33 p_input_value_id8 in out nocopy number,
34 p_input_value_id9 in out nocopy number,
35 p_input_value_id10 in out nocopy number,
36 p_input_value_id11 in out nocopy number,
37 p_input_value_id12 in out nocopy number,
38 p_input_value_id13 in out nocopy number,
39 p_input_value_id14 in out nocopy number,
40 p_input_value_id15 in out nocopy number,
41 p_name1 in out nocopy varchar2,
42 p_name2 in out nocopy varchar2,
43 p_name3 in out nocopy varchar2,
44 p_name4 in out nocopy varchar2,
45 p_name5 in out nocopy varchar2,
46 p_name6 in out nocopy varchar2,
47 p_name7 in out nocopy varchar2,
48 p_name8 in out nocopy varchar2,
49 p_name9 in out nocopy varchar2,
50 p_name10 in out nocopy varchar2,
51 p_name11 in out nocopy varchar2,
52 p_name12 in out nocopy varchar2,
53 p_name13 in out nocopy varchar2,
54 p_name14 in out nocopy varchar2,
55 p_name15 in out nocopy varchar2,
56 p_uom1 in out nocopy varchar2,
57 p_uom2 in out nocopy varchar2,
58 p_uom3 in out nocopy varchar2,
59 p_uom4 in out nocopy varchar2,
60 p_uom5 in out nocopy varchar2,
61 p_uom6 in out nocopy varchar2,
62 p_uom7 in out nocopy varchar2,
63 p_uom8 in out nocopy varchar2,
64 p_uom9 in out nocopy varchar2,
65 p_uom10 in out nocopy varchar2,
66 p_uom11 in out nocopy varchar2,
67 p_uom12 in out nocopy varchar2,
68 p_uom13 in out nocopy varchar2,
69 p_uom14 in out nocopy varchar2,
70 p_uom15 in out nocopy varchar2,
71 p_hot_default_flag1 in out nocopy varchar2,
72 p_hot_default_flag2 in out nocopy varchar2,
73 p_hot_default_flag3 in out nocopy varchar2,
74 p_hot_default_flag4 in out nocopy varchar2,
75 p_hot_default_flag5 in out nocopy varchar2,
76 p_hot_default_flag6 in out nocopy varchar2,
77 p_hot_default_flag7 in out nocopy varchar2,
78 p_hot_default_flag8 in out nocopy varchar2,
79 p_hot_default_flag9 in out nocopy varchar2,
80 p_hot_default_flag10 in out nocopy varchar2,
81 p_hot_default_flag11 in out nocopy varchar2,
82 p_hot_default_flag12 in out nocopy varchar2,
83 p_hot_default_flag13 in out nocopy varchar2,
84 p_hot_default_flag14 in out nocopy varchar2,
85 p_hot_default_flag15 in out nocopy varchar2,
86 p_mandatory_flag1 in out nocopy varchar2,
87 p_mandatory_flag2 in out nocopy varchar2,
88 p_mandatory_flag3 in out nocopy varchar2,
89 p_mandatory_flag4 in out nocopy varchar2,
90 p_mandatory_flag5 in out nocopy varchar2,
91 p_mandatory_flag6 in out nocopy varchar2,
92 p_mandatory_flag7 in out nocopy varchar2,
93 p_mandatory_flag8 in out nocopy varchar2,
94 p_mandatory_flag9 in out nocopy varchar2,
95 p_mandatory_flag10 in out nocopy varchar2,
96 p_mandatory_flag11 in out nocopy varchar2,
97 p_mandatory_flag12 in out nocopy varchar2,
98 p_mandatory_flag13 in out nocopy varchar2,
99 p_mandatory_flag14 in out nocopy varchar2,
100 p_mandatory_flag15 in out nocopy varchar2,
101 p_formula_id1 in out nocopy number,
102 p_formula_id2 in out nocopy number,
103 p_formula_id3 in out nocopy number,
104 p_formula_id4 in out nocopy number,
105 p_formula_id5 in out nocopy number,
106 p_formula_id6 in out nocopy number,
107 p_formula_id7 in out nocopy number,
108 p_formula_id8 in out nocopy number,
109 p_formula_id9 in out nocopy number,
110 p_formula_id10 in out nocopy number,
111 p_formula_id11 in out nocopy number,
112 p_formula_id12 in out nocopy number,
113 p_formula_id13 in out nocopy number,
114 p_formula_id14 in out nocopy number,
115 p_formula_id15 in out nocopy number,
116 p_lookup_type1 in out nocopy varchar2,
117 p_lookup_type2 in out nocopy varchar2,
118 p_lookup_type3 in out nocopy varchar2,
119 p_lookup_type4 in out nocopy varchar2,
120 p_lookup_type5 in out nocopy varchar2,
121 p_lookup_type6 in out nocopy varchar2,
122 p_lookup_type7 in out nocopy varchar2,
123 p_lookup_type8 in out nocopy varchar2,
124 p_lookup_type9 in out nocopy varchar2,
125 p_lookup_type10 in out nocopy varchar2,
126 p_lookup_type11 in out nocopy varchar2,
127 p_lookup_type12 in out nocopy varchar2,
128 p_lookup_type13 in out nocopy varchar2,
129 p_lookup_type14 in out nocopy varchar2,
130 p_lookup_type15 in out nocopy varchar2,
131 p_value_set_id1 in out nocopy number,
132 p_value_set_id2 in out nocopy number,
133 p_value_set_id3 in out nocopy number,
134 p_value_set_id4 in out nocopy number,
135 p_value_set_id5 in out nocopy number,
136 p_value_set_id6 in out nocopy number,
137 p_value_set_id7 in out nocopy number,
138 p_value_set_id8 in out nocopy number,
139 p_value_set_id9 in out nocopy number,
140 p_value_set_id10 in out nocopy number,
141 p_value_set_id11 in out nocopy number,
142 p_value_set_id12 in out nocopy number,
143 p_value_set_id13 in out nocopy number,
144 p_value_set_id14 in out nocopy number,
145 p_value_set_id15 in out nocopy number,
146 p_min_value1 in out nocopy varchar2,
147 p_min_value2 in out nocopy varchar2,
148 p_min_value3 in out nocopy varchar2,
149 p_min_value4 in out nocopy varchar2,
150 p_min_value5 in out nocopy varchar2,
151 p_min_value6 in out nocopy varchar2,
152 p_min_value7 in out nocopy varchar2,
153 p_min_value8 in out nocopy varchar2,
154 p_min_value9 in out nocopy varchar2,
155 p_min_value10 in out nocopy varchar2,
156 p_min_value11 in out nocopy varchar2,
157 p_min_value12 in out nocopy varchar2,
158 p_min_value13 in out nocopy varchar2,
159 p_min_value14 in out nocopy varchar2,
160 p_min_value15 in out nocopy varchar2,
161 p_max_value1 in out nocopy varchar2,
162 p_max_value2 in out nocopy varchar2,
163 p_max_value3 in out nocopy varchar2,
164 p_max_value4 in out nocopy varchar2,
165 p_max_value5 in out nocopy varchar2,
166 p_max_value6 in out nocopy varchar2,
167 p_max_value7 in out nocopy varchar2,
168 p_max_value8 in out nocopy varchar2,
169 p_max_value9 in out nocopy varchar2,
170 p_max_value10 in out nocopy varchar2,
171 p_max_value11 in out nocopy varchar2,
172 p_max_value12 in out nocopy varchar2,
173 p_max_value13 in out nocopy varchar2,
174 p_max_value14 in out nocopy varchar2,
175 p_max_value15 in out nocopy varchar2,
176 p_screen_entry_value1 in out nocopy varchar2,
177 p_screen_entry_value2 in out nocopy varchar2,
178 p_screen_entry_value3 in out nocopy varchar2,
179 p_screen_entry_value4 in out nocopy varchar2,
180 p_screen_entry_value5 in out nocopy varchar2,
181 p_screen_entry_value6 in out nocopy varchar2,
182 p_screen_entry_value7 in out nocopy varchar2,
183 p_screen_entry_value8 in out nocopy varchar2,
184 p_screen_entry_value9 in out nocopy varchar2,
185 p_screen_entry_value10 in out nocopy varchar2,
186 p_screen_entry_value11 in out nocopy varchar2,
187 p_screen_entry_value12 in out nocopy varchar2,
188 p_screen_entry_value13 in out nocopy varchar2,
189 p_screen_entry_value14 in out nocopy varchar2,
190 p_screen_entry_value15 in out nocopy varchar2,
191 p_entry_value_id1 in out nocopy number,
192 p_entry_value_id2 in out nocopy number,
193 p_entry_value_id3 in out nocopy number,
194 p_entry_value_id4 in out nocopy number,
195 p_entry_value_id5 in out nocopy number,
196 p_entry_value_id6 in out nocopy number,
197 p_entry_value_id7 in out nocopy number,
198 p_entry_value_id8 in out nocopy number,
199 p_entry_value_id9 in out nocopy number,
200 p_entry_value_id10 in out nocopy number,
201 p_entry_value_id11 in out nocopy number,
202 p_entry_value_id12 in out nocopy number,
203 p_entry_value_id13 in out nocopy number,
204 p_entry_value_id14 in out nocopy number,
205 p_entry_value_id15 in out nocopy number,
206 p_default_value1 in out nocopy varchar2,
207 p_default_value2 in out nocopy varchar2,
208 p_default_value3 in out nocopy varchar2,
209 p_default_value4 in out nocopy varchar2,
210 p_default_value5 in out nocopy varchar2,
211 p_default_value6 in out nocopy varchar2,
212 p_default_value7 in out nocopy varchar2,
213 p_default_value8 in out nocopy varchar2,
214 p_default_value9 in out nocopy varchar2,
215 p_default_value10 in out nocopy varchar2,
216 p_default_value11 in out nocopy varchar2,
217 p_default_value12 in out nocopy varchar2,
218 p_default_value13 in out nocopy varchar2,
219 p_default_value14 in out nocopy varchar2,
220 p_default_value15 in out nocopy varchar2,
221 p_warning_or_error1 in out nocopy varchar2,
222 p_warning_or_error2 in out nocopy varchar2,
223 p_warning_or_error3 in out nocopy varchar2,
224 p_warning_or_error4 in out nocopy varchar2,
225 p_warning_or_error5 in out nocopy varchar2,
226 p_warning_or_error6 in out nocopy varchar2,
227 p_warning_or_error7 in out nocopy varchar2,
228 p_warning_or_error8 in out nocopy varchar2,
229 p_warning_or_error9 in out nocopy varchar2,
230 p_warning_or_error10 in out nocopy varchar2,
231 p_warning_or_error11 in out nocopy varchar2,
232 p_warning_or_error12 in out nocopy varchar2,
233 p_warning_or_error13 in out nocopy varchar2,
234 p_warning_or_error14 in out nocopy varchar2,
235 p_warning_or_error15 in out nocopy varchar2);
236 --
237 procedure populate_context_items (
238 --
239 p_effective_date in date,
240 p_business_group_id in number,
241 p_customized_restriction_id in number,
242 p_assignment_id in number,
243 p_payroll_id in out nocopy number,
244 p_display_period in out nocopy varchar2,
245 p_period_status in out nocopy varchar2,
246 p_start_date in out nocopy date,
247 p_end_date in out nocopy date,
248 p_cost_allocation_structure in out nocopy varchar2,
249 p_pay_value_name in out nocopy varchar2,
250 p_processing_type in out nocopy varchar2,
251 p_entry_type in out nocopy varchar2,
252 p_element_set in out nocopy number);
253
254 function processed (
255
256 p_element_entry_id number,
257 p_original_entry_id number,
258 p_processing_type varchar2,
259 p_entry_type varchar2,
260 p_effective_date date) return varchar2;
261 pragma restrict_references (processed, WNDS, WNPS);
262
263 procedure delete_entry_caches;
264
265 function personal_payment_method (
266 --
267 p_personal_payment_method_id number,
268 p_assignment_id number,
269 p_effective_date date) return varchar2;
270 pragma restrict_references (personal_payment_method, WNDS, WNPS);
271
272 function is_entry_included (
273
274 p_assignment_action_id number,
275 p_element_entry_id number) return varchar2;
276
277 function adjusted (
278
279 p_element_link_id number,
280 p_assignment_id number,
281 p_effective_date date) return varchar2;
282
283 function overridden (
284
285 p_element_link_id number,
286 p_assignment_id number,
287 p_effective_date date) return varchar2;
288
289 function normal_exists (
290
291 p_element_link_id number,
292 p_assignment_id number,
293 p_effective_date date) return varchar2;
294
295 function additional_exists (
296
297 p_element_link_id number,
298 p_assignment_id number,
299 p_effective_date date) return varchar2;
300
301 procedure update_original_if_MIX(
302
303 p_assignment_id number,
304 p_element_type_id number,
305 p_effective_start_date date,
306 p_session_date date);
307
308 function get_original_date_earned(
309 p_element_entry_id in number) return date;
310
311 end PAY_PAYWSMEE_PKG;