1 package PAY_PAYWSMEE2_PKG AUTHID CURRENT_USER as
2 /* $Header: pywsmee2.pkh 115.3 2003/02/13 17:18:13 swinton ship $ */
3
4 --------------------------------------------------------------------------------
5 procedure get_input_value_details (
6 --
7 p_element_link_id number,
8 p_element_type_id number,
9 p_effective_date date,
10 p_input_currency_code varchar2,
11 p_contributions_used varchar2,
12 p_input_value_id1 in out nocopy number,
13 p_input_value_id2 in out nocopy number,
14 p_input_value_id3 in out nocopy number,
15 p_input_value_id4 in out nocopy number,
16 p_input_value_id5 in out nocopy number,
17 p_input_value_id6 in out nocopy number,
18 p_input_value_id7 in out nocopy number,
19 p_input_value_id8 in out nocopy number,
20 p_input_value_id9 in out nocopy number,
21 p_input_value_id10 in out nocopy number,
22 p_input_value_id11 in out nocopy number,
23 p_input_value_id12 in out nocopy number,
24 p_input_value_id13 in out nocopy number,
25 p_input_value_id14 in out nocopy number,
26 p_input_value_id15 in out nocopy number,
27 p_name1 in out nocopy varchar2,
28 p_name2 in out nocopy varchar2,
29 p_name3 in out nocopy varchar2,
30 p_name4 in out nocopy varchar2,
31 p_name5 in out nocopy varchar2,
32 p_name6 in out nocopy varchar2,
33 p_name7 in out nocopy varchar2,
34 p_name8 in out nocopy varchar2,
35 p_name9 in out nocopy varchar2,
36 p_name10 in out nocopy varchar2,
37 p_name11 in out nocopy varchar2,
38 p_name12 in out nocopy varchar2,
39 p_name13 in out nocopy varchar2,
40 p_name14 in out nocopy varchar2,
41 p_name15 in out nocopy varchar2,
42 p_uom1 in out nocopy varchar2,
43 p_uom2 in out nocopy varchar2,
44 p_uom3 in out nocopy varchar2,
45 p_uom4 in out nocopy varchar2,
46 p_uom5 in out nocopy varchar2,
47 p_uom6 in out nocopy varchar2,
48 p_uom7 in out nocopy varchar2,
49 p_uom8 in out nocopy varchar2,
50 p_uom9 in out nocopy varchar2,
51 p_uom10 in out nocopy varchar2,
52 p_uom11 in out nocopy varchar2,
53 p_uom12 in out nocopy varchar2,
54 p_uom13 in out nocopy varchar2,
55 p_uom14 in out nocopy varchar2,
56 p_uom15 in out nocopy varchar2,
57 p_hot_default_flag1 in out nocopy varchar2,
58 p_hot_default_flag2 in out nocopy varchar2,
59 p_hot_default_flag3 in out nocopy varchar2,
60 p_hot_default_flag4 in out nocopy varchar2,
61 p_hot_default_flag5 in out nocopy varchar2,
62 p_hot_default_flag6 in out nocopy varchar2,
63 p_hot_default_flag7 in out nocopy varchar2,
64 p_hot_default_flag8 in out nocopy varchar2,
65 p_hot_default_flag9 in out nocopy varchar2,
66 p_hot_default_flag10 in out nocopy varchar2,
67 p_hot_default_flag11 in out nocopy varchar2,
68 p_hot_default_flag12 in out nocopy varchar2,
69 p_hot_default_flag13 in out nocopy varchar2,
70 p_hot_default_flag14 in out nocopy varchar2,
71 p_hot_default_flag15 in out nocopy varchar2,
72 p_mandatory_flag1 in out nocopy varchar2,
73 p_mandatory_flag2 in out nocopy varchar2,
74 p_mandatory_flag3 in out nocopy varchar2,
75 p_mandatory_flag4 in out nocopy varchar2,
76 p_mandatory_flag5 in out nocopy varchar2,
77 p_mandatory_flag6 in out nocopy varchar2,
78 p_mandatory_flag7 in out nocopy varchar2,
79 p_mandatory_flag8 in out nocopy varchar2,
80 p_mandatory_flag9 in out nocopy varchar2,
81 p_mandatory_flag10 in out nocopy varchar2,
82 p_mandatory_flag11 in out nocopy varchar2,
83 p_mandatory_flag12 in out nocopy varchar2,
84 p_mandatory_flag13 in out nocopy varchar2,
85 p_mandatory_flag14 in out nocopy varchar2,
86 p_mandatory_flag15 in out nocopy varchar2,
87 p_formula_id1 in out nocopy number,
88 p_formula_id2 in out nocopy number,
89 p_formula_id3 in out nocopy number,
90 p_formula_id4 in out nocopy number,
91 p_formula_id5 in out nocopy number,
92 p_formula_id6 in out nocopy number,
93 p_formula_id7 in out nocopy number,
94 p_formula_id8 in out nocopy number,
95 p_formula_id9 in out nocopy number,
96 p_formula_id10 in out nocopy number,
97 p_formula_id11 in out nocopy number,
98 p_formula_id12 in out nocopy number,
99 p_formula_id13 in out nocopy number,
100 p_formula_id14 in out nocopy number,
101 p_formula_id15 in out nocopy number,
102 p_lookup_type1 in out nocopy varchar2,
103 p_lookup_type2 in out nocopy varchar2,
104 p_lookup_type3 in out nocopy varchar2,
105 p_lookup_type4 in out nocopy varchar2,
106 p_lookup_type5 in out nocopy varchar2,
107 p_lookup_type6 in out nocopy varchar2,
108 p_lookup_type7 in out nocopy varchar2,
109 p_lookup_type8 in out nocopy varchar2,
110 p_lookup_type9 in out nocopy varchar2,
111 p_lookup_type10 in out nocopy varchar2,
112 p_lookup_type11 in out nocopy varchar2,
113 p_lookup_type12 in out nocopy varchar2,
114 p_lookup_type13 in out nocopy varchar2,
115 p_lookup_type14 in out nocopy varchar2,
116 p_lookup_type15 in out nocopy varchar2,
117 p_value_set_id1 in out nocopy number,
118 p_value_set_id2 in out nocopy number,
119 p_value_set_id3 in out nocopy number,
120 p_value_set_id4 in out nocopy number,
121 p_value_set_id5 in out nocopy number,
122 p_value_set_id6 in out nocopy number,
123 p_value_set_id7 in out nocopy number,
124 p_value_set_id8 in out nocopy number,
125 p_value_set_id9 in out nocopy number,
126 p_value_set_id10 in out nocopy number,
127 p_value_set_id11 in out nocopy number,
128 p_value_set_id12 in out nocopy number,
129 p_value_set_id13 in out nocopy number,
130 p_value_set_id14 in out nocopy number,
131 p_value_set_id15 in out nocopy number,
132 p_min_value1 in out nocopy varchar2,
133 p_min_value2 in out nocopy varchar2,
134 p_min_value3 in out nocopy varchar2,
135 p_min_value4 in out nocopy varchar2,
136 p_min_value5 in out nocopy varchar2,
137 p_min_value6 in out nocopy varchar2,
138 p_min_value7 in out nocopy varchar2,
139 p_min_value8 in out nocopy varchar2,
140 p_min_value9 in out nocopy varchar2,
141 p_min_value10 in out nocopy varchar2,
142 p_min_value11 in out nocopy varchar2,
143 p_min_value12 in out nocopy varchar2,
144 p_min_value13 in out nocopy varchar2,
145 p_min_value14 in out nocopy varchar2,
146 p_min_value15 in out nocopy varchar2,
147 p_max_value1 in out nocopy varchar2,
148 p_max_value2 in out nocopy varchar2,
149 p_max_value3 in out nocopy varchar2,
150 p_max_value4 in out nocopy varchar2,
151 p_max_value5 in out nocopy varchar2,
152 p_max_value6 in out nocopy varchar2,
153 p_max_value7 in out nocopy varchar2,
154 p_max_value8 in out nocopy varchar2,
155 p_max_value9 in out nocopy varchar2,
156 p_max_value10 in out nocopy varchar2,
157 p_max_value11 in out nocopy varchar2,
158 p_max_value12 in out nocopy varchar2,
159 p_max_value13 in out nocopy varchar2,
160 p_max_value14 in out nocopy varchar2,
161 p_max_value15 in out nocopy varchar2,
162 p_default_value1 in out nocopy varchar2,
163 p_default_value2 in out nocopy varchar2,
164 p_default_value3 in out nocopy varchar2,
165 p_default_value4 in out nocopy varchar2,
166 p_default_value5 in out nocopy varchar2,
167 p_default_value6 in out nocopy varchar2,
168 p_default_value7 in out nocopy varchar2,
169 p_default_value8 in out nocopy varchar2,
170 p_default_value9 in out nocopy varchar2,
171 p_default_value10 in out nocopy varchar2,
172 p_default_value11 in out nocopy varchar2,
173 p_default_value12 in out nocopy varchar2,
174 p_default_value13 in out nocopy varchar2,
175 p_default_value14 in out nocopy varchar2,
176 p_default_value15 in out nocopy varchar2,
177 p_warning_or_error1 in out nocopy varchar2,
178 p_warning_or_error2 in out nocopy varchar2,
179 p_warning_or_error3 in out nocopy varchar2,
180 p_warning_or_error4 in out nocopy varchar2,
181 p_warning_or_error5 in out nocopy varchar2,
182 p_warning_or_error6 in out nocopy varchar2,
183 p_warning_or_error7 in out nocopy varchar2,
184 p_warning_or_error8 in out nocopy varchar2,
185 p_warning_or_error9 in out nocopy varchar2,
186 p_warning_or_error10 in out nocopy varchar2,
187 p_warning_or_error11 in out nocopy varchar2,
188 p_warning_or_error12 in out nocopy varchar2,
189 p_warning_or_error13 in out nocopy varchar2,
190 p_warning_or_error14 in out nocopy varchar2,
191 p_warning_or_error15 in out nocopy varchar2);
192
193
194
195 procedure lock_row(p_effective_date date,
196 p_element_entry_id number,
197 p_effective_start_date date,
198 p_effective_end_date date,
199 p_cost_allocation_keyflex_id number,
200 p_assignment_id number,
201 p_element_link_id number,
202 p_original_entry_id number,
203 p_creator_type varchar2,
204 p_entry_type varchar2,
205 p_comment_id number,
206 p_creator_id number,
207 p_reason varchar2,
208 p_target_entry_id number,
209 p_date_earned date,
210 p_personal_payment_method_id number,
211 p_attribute_category varchar2,
212 p_attribute1 varchar2,
213 p_attribute2 varchar2,
214 p_attribute3 varchar2,
215 p_attribute4 varchar2,
216 p_attribute5 varchar2,
217 p_attribute6 varchar2,
218 p_attribute7 varchar2,
219 p_attribute8 varchar2,
220 p_attribute9 varchar2,
221 p_attribute10 varchar2,
222 p_attribute11 varchar2,
223 p_attribute12 varchar2,
224 p_attribute13 varchar2,
225 p_attribute14 varchar2,
226 p_attribute15 varchar2,
227 p_attribute16 varchar2,
228 p_attribute17 varchar2,
229 p_attribute18 varchar2,
230 p_attribute19 varchar2,
231 p_attribute20 varchar2
232 -- --
233 ,
234 p_entry_information_category varchar2,
235 p_entry_information1 varchar2,
236 p_entry_information2 varchar2,
237 p_entry_information3 varchar2,
238 p_entry_information4 varchar2,
239 p_entry_information5 varchar2,
240 p_entry_information6 varchar2,
241 p_entry_information7 varchar2,
242 p_entry_information8 varchar2,
243 p_entry_information9 varchar2,
244 p_entry_information10 varchar2,
245 p_entry_information11 varchar2,
246 p_entry_information12 varchar2,
247 p_entry_information13 varchar2,
248 p_entry_information14 varchar2,
249 p_entry_information15 varchar2,
250 p_entry_information16 varchar2,
251 p_entry_information17 varchar2,
252 p_entry_information18 varchar2,
253 p_entry_information19 varchar2,
254 p_entry_information20 varchar2,
255 p_entry_information21 varchar2,
256 p_entry_information22 varchar2,
257 p_entry_information23 varchar2,
258 p_entry_information24 varchar2,
259 p_entry_information25 varchar2,
260 p_entry_information26 varchar2,
261 p_entry_information27 varchar2,
262 p_entry_information28 varchar2,
263 p_entry_information29 varchar2,
264 p_entry_information30 varchar2
265 );
266 end PAY_PAYWSMEE2_PKG;