1 package PAY_PAYWSQEE_PKG AUTHID CURRENT_USER as
2 /* $Header: paywsqee.pkh 120.1.12010000.1 2008/07/27 21:58:00 appldev ship $ */
3 --------------------------------------------------------------------------------
4 procedure get_batch_element_type (
5 --
6 p_batch_id number,
7 p_element_type_id in out nocopy number,
8 p_element_name in out nocopy varchar2);
9 --------------------------------------------------------------------------------
10 function paylink_request_id (
11 --
12 p_business_group_id number,
13 p_mode varchar2,
14 p_batch_id number,
15 p_wait varchar2 default 'N',
16 p_act_parameter_group_id number default null) return number;
17 --------------------------------------------------------------------------------
18 procedure check_name_uniqueness (
19 --
20 p_business_group_id number,
21 p_batch_name varchar2,
22 p_batch_id number);
23 --------------------------------------------------------------------------------
24 function next_batch_sequence (p_batch_id number) return number;
25 --------------------------------------------------------------------------------
26 function batch_overall_status (p_batch_id number) return varchar2;
27 --------------------------------------------------------------------------------
28 function assignment_number (p_assignment_id number) return varchar2;
29 --------------------------------------------------------------------------------
30 procedure GET_INPUT_VALUE_DETAILS (
31 --
32 -- Returns the input value details for the element selected by an LOV
33 --
34 p_element_type_id number,
35 p_effective_date date,
36 p_input_value_id1 in out nocopy number,
37 p_input_value_id2 in out nocopy number,
38 p_input_value_id3 in out nocopy number,
39 p_input_value_id4 in out nocopy number,
40 p_input_value_id5 in out nocopy number,
41 p_input_value_id6 in out nocopy number,
42 p_input_value_id7 in out nocopy number,
43 p_input_value_id8 in out nocopy number,
44 p_input_value_id9 in out nocopy number,
45 p_input_value_id10 in out nocopy number,
46 p_input_value_id11 in out nocopy number,
47 p_input_value_id12 in out nocopy number,
48 p_input_value_id13 in out nocopy number,
49 p_input_value_id14 in out nocopy number,
50 p_input_value_id15 in out nocopy number,
51 p_name1 in out nocopy varchar2,
52 p_name2 in out nocopy varchar2,
53 p_name3 in out nocopy varchar2,
54 p_name4 in out nocopy varchar2,
55 p_name5 in out nocopy varchar2,
56 p_name6 in out nocopy varchar2,
57 p_name7 in out nocopy varchar2,
58 p_name8 in out nocopy varchar2,
59 p_name9 in out nocopy varchar2,
60 p_name10 in out nocopy varchar2,
61 p_name11 in out nocopy varchar2,
62 p_name12 in out nocopy varchar2,
63 p_name13 in out nocopy varchar2,
64 p_name14 in out nocopy varchar2,
65 p_name15 in out nocopy varchar2,
66 p_lookup_type1 in out nocopy varchar2,
67 p_lookup_type2 in out nocopy varchar2,
68 p_lookup_type3 in out nocopy varchar2,
69 p_lookup_type4 in out nocopy varchar2,
70 p_lookup_type5 in out nocopy varchar2,
71 p_lookup_type6 in out nocopy varchar2,
72 p_lookup_type7 in out nocopy varchar2,
73 p_lookup_type8 in out nocopy varchar2,
74 p_lookup_type9 in out nocopy varchar2,
75 p_lookup_type10 in out nocopy varchar2,
76 p_lookup_type11 in out nocopy varchar2,
77 p_lookup_type12 in out nocopy varchar2,
78 p_lookup_type13 in out nocopy varchar2,
79 p_lookup_type14 in out nocopy varchar2,
80 p_lookup_type15 in out nocopy varchar2);
81 ---------------------------------
82 procedure GET_INPUT_VALUE_DETAILS (
83 --
84 -- Returns the input value details for the element selected by an LOV
85 --
86 p_element_type_id number,
87 p_effective_date date,
88 p_input_value_id1 in out nocopy number,
89 p_input_value_id2 in out nocopy number,
90 p_input_value_id3 in out nocopy number,
91 p_input_value_id4 in out nocopy number,
92 p_input_value_id5 in out nocopy number,
93 p_input_value_id6 in out nocopy number,
94 p_input_value_id7 in out nocopy number,
95 p_input_value_id8 in out nocopy number,
96 p_input_value_id9 in out nocopy number,
97 p_input_value_id10 in out nocopy number,
98 p_input_value_id11 in out nocopy number,
99 p_input_value_id12 in out nocopy number,
100 p_input_value_id13 in out nocopy number,
101 p_input_value_id14 in out nocopy number,
102 p_input_value_id15 in out nocopy number,
103 p_name1 in out nocopy varchar2,
104 p_name2 in out nocopy varchar2,
105 p_name3 in out nocopy varchar2,
106 p_name4 in out nocopy varchar2,
107 p_name5 in out nocopy varchar2,
108 p_name6 in out nocopy varchar2,
109 p_name7 in out nocopy varchar2,
110 p_name8 in out nocopy varchar2,
111 p_name9 in out nocopy varchar2,
112 p_name10 in out nocopy varchar2,
113 p_name11 in out nocopy varchar2,
114 p_name12 in out nocopy varchar2,
115 p_name13 in out nocopy varchar2,
116 p_name14 in out nocopy varchar2,
117 p_name15 in out nocopy varchar2,
118 p_lookup_type1 in out nocopy varchar2,
119 p_lookup_type2 in out nocopy varchar2,
120 p_lookup_type3 in out nocopy varchar2,
121 p_lookup_type4 in out nocopy varchar2,
122 p_lookup_type5 in out nocopy varchar2,
123 p_lookup_type6 in out nocopy varchar2,
124 p_lookup_type7 in out nocopy varchar2,
125 p_lookup_type8 in out nocopy varchar2,
126 p_lookup_type9 in out nocopy varchar2,
127 p_lookup_type10 in out nocopy varchar2,
128 p_lookup_type11 in out nocopy varchar2,
129 p_lookup_type12 in out nocopy varchar2,
130 p_lookup_type13 in out nocopy varchar2,
131 p_lookup_type14 in out nocopy varchar2,
132 p_lookup_type15 in out nocopy varchar2,
133 -- UOM
134 p_uom1 in out nocopy varchar2,
135 p_uom2 in out nocopy varchar2,
136 p_uom3 in out nocopy varchar2,
137 p_uom4 in out nocopy varchar2,
138 p_uom5 in out nocopy varchar2,
139 p_uom6 in out nocopy varchar2,
140 p_uom7 in out nocopy varchar2,
141 p_uom8 in out nocopy varchar2,
142 p_uom9 in out nocopy varchar2,
143 p_uom10 in out nocopy varchar2,
144 p_uom11 in out nocopy varchar2,
145 p_uom12 in out nocopy varchar2,
146 p_uom13 in out nocopy varchar2,
147 p_uom14 in out nocopy varchar2,
148 p_uom15 in out nocopy varchar2,
149 -- Value Set Id
150 p_value_set_id1 in out nocopy number,
151 p_value_set_id2 in out nocopy number,
152 p_value_set_id3 in out nocopy number,
153 p_value_set_id4 in out nocopy number,
154 p_value_set_id5 in out nocopy number,
155 p_value_set_id6 in out nocopy number,
156 p_value_set_id7 in out nocopy number,
157 p_value_set_id8 in out nocopy number,
158 p_value_set_id9 in out nocopy number,
159 p_value_set_id10 in out nocopy number,
160 p_value_set_id11 in out nocopy number,
161 p_value_set_id12 in out nocopy number,
162 p_value_set_id13 in out nocopy number,
163 p_value_set_id14 in out nocopy number,
164 p_value_set_id15 in out nocopy number
165 );
166 --------------------------------------------------------------------------------
167 procedure populate_context_items (
168 --
169 --******************************************************************************
170 -- Populate form initialisation information
171 --******************************************************************************
172 --
173 p_business_group_id in number, -- User's business group
174 p_cost_allocation_structure in out nocopy varchar2 -- Keyflex structure
175 );
176 --------------------------------------------------------------------------------
177 function create_batches_request_id (
178 --
179 p_header_name varchar2,
180 p_header_id number,
181 p_reason varchar2,
182 p_business_group_id number,
183 p_effective_start_date date,
184 p_effective_s_date date,
185 p_effective_e_date date,
186 p_element_type_id number,
187 p_payroll_id number,
188 p_assignment_set_id number,
189 p_cost_allocation_keyflex_id number,
190 p_mix_transfer_flag varchar2,
191 p_value_1 varchar2,
192 p_value_2 varchar2,
193 p_value_3 varchar2,
194 p_value_4 varchar2,
195 p_value_5 varchar2,
196 p_value_6 varchar2,
197 p_value_7 varchar2,
198 p_value_8 varchar2,
199 p_value_9 varchar2,
200 p_value_10 varchar2,
201 p_value_11 varchar2,
202 p_value_12 varchar2,
203 p_value_13 varchar2,
204 p_value_14 varchar2,
205 p_value_15 varchar2,
206 p_attribute_category varchar2,
207 p_attribute1 varchar2,
208 p_attribute2 varchar2,
209 p_attribute3 varchar2,
210 p_attribute4 varchar2,
211 p_attribute5 varchar2,
212 p_attribute6 varchar2,
213 p_attribute7 varchar2,
214 p_attribute8 varchar2,
215 p_attribute9 varchar2,
216 p_attribute10 varchar2,
217 p_attribute11 varchar2,
218 p_attribute12 varchar2,
219 p_attribute13 varchar2,
220 p_attribute14 varchar2,
221 p_attribute15 varchar2,
222 p_attribute16 varchar2,
223 p_attribute17 varchar2,
224 p_attribute18 varchar2,
225 p_attribute19 varchar2,
226 p_attribute20 varchar2,
227 p_entry_information_category varchar2,
228 p_entry_information1 varchar2,
229 p_entry_information2 varchar2,
230 p_entry_information3 varchar2,
231 p_entry_information4 varchar2,
232 p_entry_information5 varchar2,
233 p_entry_information6 varchar2,
234 p_entry_information7 varchar2,
235 p_entry_information8 varchar2,
236 p_entry_information9 varchar2,
237 p_entry_information10 varchar2,
238 p_entry_information11 varchar2,
239 p_entry_information12 varchar2,
240 p_entry_information13 varchar2,
241 p_entry_information14 varchar2,
242 p_entry_information15 varchar2,
243 p_entry_information16 varchar2,
244 p_entry_information17 varchar2,
245 p_entry_information18 varchar2,
246 p_entry_information19 varchar2,
247 p_entry_information20 varchar2,
248 p_entry_information21 varchar2,
249 p_entry_information22 varchar2,
250 p_entry_information23 varchar2,
251 p_entry_information24 varchar2,
252 p_entry_information25 varchar2,
253 p_entry_information26 varchar2,
254 p_entry_information27 varchar2,
255 p_entry_information28 varchar2,
256 p_entry_information29 varchar2,
257 p_entry_information30 varchar2,
258 p_date_earned date,
259 p_subpriority number,
260 p_element_set_id number default null,
261 p_customized_restriction_id number default null,
262 p_act_parameter_group_id number default null
263 )
264 return number;
265 --------------------------------------------------------------------------------
266 --
267 function convert_internal_to_display
268 (p_element_type_id in varchar2,
269 p_input_value in varchar2,
270 p_input_value_number in number,
271 p_session_date in date,
272 p_batch_id in number
273 ) return varchar2;
274 --
275 end PAY_PAYWSQEE_PKG;