[Home] [Help]
PACKAGE: APPS.PAY_ITERATE
Source
1 package pay_iterate AUTHID CURRENT_USER as
2 /* $Header: pyiterat.pkh 120.4.12010000.1 2008/07/27 22:56:37 appldev ship $ */
3 /*
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
8 * Chertsey, England. *
9 * *
10 * All rights reserved. *
11 * *
12 * This material has been provided pursuant to an agreement *
13 * containing restrictions on its use. The material is also *
14 * protected by copyright law. No part of this material may *
15 * be copied or distributed, transmitted or transcribed, in *
16 * any form or by any means, electronic, mechanical, magnetic, *
17 * manual, or otherwise, or disclosed to third parties without *
18 * the express written permission of Oracle Corporation UK Ltd, *
19 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
20 * England. *
21 * *
22 ******************************************************************
23
24 Name Date Vers Description
25 ---------------- ----------- ------ -----------------------------------
26 alogue 17-MAY-2007 115.17 Added p_assignment_action_id to
27 is_amount_set.
28 alogue 26-MAR-2007 115.16 Added p_assignment_action_id to
29 is_first_setting.
30 nbristow 25-JUl-2006 115.14 Added new functions for DEFAULT
31 GROSSUP formula.
32 nbristow 02-MAR-2004 115.13 Added get_high_gross_factor.
33 rthirlby 26-FEB-2003 115.12 Bug 2823132 - New function
34 order_cumulative used to determine
35 the order run types should be
36 downloaded. Called from the lct
37 pycoiter.lct.
38 prsundar 06-FEB-2003 115.11 Added parameters inclusion_flag &
39 usage_type to up_element_type_usage
40 procedure. Bug 2764101
41 prsundar 30-JAN-2003 115.10 Renamed attribute_category to
42 run_informatIon_category and
43 attribute1....30 to
47 procedure up_run_type. Bug 2577516
44 run_information1....run_information30
45 prsundar 23-jan-2003 115.9 Added parameters attribute_category
46 and attribute1....attribute30 to
48 Scchakra 04-DEC-2002 115.8 Added default 'Y' to parameter
49 p_srs_flag in up_run_type.
50 Scchakra 03-DEC-2002 115.7 Added parameter srs_flag to procedure
51 up_run_type. Bug 2607325.
52 RThirlby 10-DEC-2001 115.6 Added checkfile line
53 RThirlby 01-DEC-2001 115.5 Added dbdrv line
54 RThirlby 14-AUG-2001 115.4 Amended upload procedures for
55 pay_run_types and pay_run_type_usages.
56 Added upload procedure translate_row
57 for run type translations.
58 JTOMKINS 10-JUL-2001 115.3 Amended upload procedures for
59 element_type_usages and
60 run_type_org_methods to use
61 apis and reflect table changes.
62 NBRISTOW 19-MAY-2000 115.2 Added upload procedures.
63 NBRISTOW 12-JAN-2000 115.1 Changes made for NTG.
64 NBRISTOW 26-MAY-1999 115.0 Created.
65
66 */
67 TYPE number_tbl IS TABLE OF NUMBER INDEX BY binary_integer;
68 TYPE varchar_60_tbl IS TABLE OF VARCHAR(60) INDEX BY binary_integer;
69 --
70 TYPE rt_record IS RECORD(rt_id number
71 ,rt_name varchar2(80)
72 ,rt_shortname varchar2(30)
73 ,rt_srs_flag varchar2(30)
74 ,rt_run_information_category varchar2(30)
75 ,rt_run_information1 varchar2(150)
76 ,rt_run_information2 varchar2(150)
77 ,rt_run_information3 varchar2(150)
78 ,rt_run_information4 varchar2(150)
79 ,rt_run_information5 varchar2(150)
80 ,rt_run_information6 varchar2(150)
81 ,rt_run_information7 varchar2(150)
82 ,rt_run_information8 varchar2(150)
83 ,rt_run_information9 varchar2(150)
84 ,rt_run_information10 varchar2(150)
85 ,rt_run_information11 varchar2(150)
86 ,rt_run_information12 varchar2(150)
87 ,rt_run_information13 varchar2(150)
88 ,rt_run_information14 varchar2(150)
89 ,rt_run_information15 varchar2(150)
90 ,rt_run_information16 varchar2(150)
91 ,rt_run_information17 varchar2(150)
92 ,rt_run_information18 varchar2(150)
93 ,rt_run_information19 varchar2(150)
94 ,rt_run_information20 varchar2(150)
95 ,rt_run_information21 varchar2(150)
96 ,rt_run_information22 varchar2(150)
97 ,rt_run_information23 varchar2(150)
98 ,rt_run_information24 varchar2(150)
99 ,rt_run_information25 varchar2(150)
100 ,rt_run_information26 varchar2(150)
101 ,rt_run_information27 varchar2(150)
102 ,rt_run_information28 varchar2(150)
103 ,rt_run_information29 varchar2(150)
104 ,rt_run_information30 varchar2(150)
105 ,rt_leg_code varchar2(30)
106 ,rt_bg number
107 ,rt_esd date
108 ,rt_eed date
109 ,rt_ovn number
110 ,rt_mode varchar2(10)
111 );
112 --
113 g_old_rt_id number := -1;
114 g_to_be_uploaded_eed date := hr_api.g_eot;
115 rec_uploaded rt_record;
116 l_call_set_end_date boolean := true;
117 --
118 TYPE rtu_record IS RECORD(rtu_id number
119 ,rtu_parent_rt_id varchar2(80)
120 ,rtu_child_rt_id varchar2(80)
121 ,rtu_sequence number
122 ,rtu_leg_code varchar2(30)
123 ,rtu_bg number
124 ,rtu_esd date
125 ,rtu_eed date
126 ,rtu_ovn number
127 ,rtu_mode varchar2(10)
128 );
129 --
130 g_old_rtu_id number := -1;
131 g_rtu_to_be_uploaded_eed date := hr_api.g_eot;
132 rec_rtu_uploaded rtu_record;
133 l_call_rtu_set_end_date boolean := true;
134 --
135 TYPE g_rtopm_record IS RECORD
136 (old_rom_id number(9) default -1
137 ,new_rom_id number(9) default -1
138 ,new_esd date
139 ,old_esd date
140 ,new_eed date default hr_api.g_eot
141 ,old_eed date default hr_api.g_eot
142 ,ovn number(9)
143 );
144 --
145 G_ROM_REC g_rtopm_record;
146 --
147 TYPE g_et_usage_record IS RECORD
148 (old_etu_id number(9) default -1
149 ,new_etu_id number(9) default -1
150 ,new_esd date
151 ,old_esd date
152 ,new_eed date default hr_api.g_eot
153 ,old_eed date default hr_api.g_eot
154 ,ovn number(9)
155 ,l_mode varchar2(30)
156 );
157 --
158 G_ETU_REC g_et_usage_record;
159 --
160 function initialise_amount (
161 p_bg_id in number,
162 p_entry_id in number,
163 p_assignment_action_id in number default null,
164 p_target_value in number default null
165 ) return number;
166 function initialise (p_entry_id in number,
167 p_assignment_action_id in number default null,
168 p_high_value in number,
169 p_low_value in number,
170 p_target_value in number default null
171 ) return number;
172 --
173 function get_binary_guess(p_entry_id in number,
174 p_mode in varchar2) return number;
175 --
176 function get_interpolation_guess (p_entry_id in number,
177 p_result in number default null)
178 return number;
179 function is_amount_set (p_entry_id in number,
180 p_assignment_action_id in number default null)
181 return number;
182 function is_first_setting (p_entry_id in number,
183 p_assignment_action_id in number default null)
184 return number;
185 function get_high_value (p_entry_id in number)
186 return number;
187 function get_target_value (p_entry_id in number)
188 return number;
189 function get_low_value (p_entry_id in number)
190 return number;
191 function get_high_gross_factor (p_bg_id in number)
192 return number;
193 --
194 PROCEDURE up_run_type (p_rt_id number
195 ,p_rt_name varchar2
196 ,p_effective_start_date date
197 ,p_effective_end_date date
198 ,p_legislative_code varchar2
199 ,p_business_group varchar2
200 ,p_shortname varchar2
201 ,p_method varchar2
202 ,p_rt_name_tl varchar2
203 ,p_shortname_tl varchar2
204 ,p_eof_number number
205 ,p_srs_flag varchar2 default 'Y'
206 ,p_run_information_category varchar2 default null
207 ,p_run_information1 varchar2 default null
208 ,p_run_information2 varchar2 default null
209 ,p_run_information3 varchar2 default null
210 ,p_run_information4 varchar2 default null
211 ,p_run_information5 varchar2 default null
212 ,p_run_information6 varchar2 default null
213 ,p_run_information7 varchar2 default null
214 ,p_run_information8 varchar2 default null
215 ,p_run_information9 varchar2 default null
216 ,p_run_information10 varchar2 default null
217 ,p_run_information11 varchar2 default null
218 ,p_run_information12 varchar2 default null
219 ,p_run_information13 varchar2 default null
220 ,p_run_information14 varchar2 default null
221 ,p_run_information15 varchar2 default null
222 ,p_run_information16 varchar2 default null
223 ,p_run_information17 varchar2 default null
224 ,p_run_information18 varchar2 default null
225 ,p_run_information19 varchar2 default null
226 ,p_run_information20 varchar2 default null
227 ,p_run_information21 varchar2 default null
228 ,p_run_information22 varchar2 default null
229 ,p_run_information23 varchar2 default null
230 ,p_run_information24 varchar2 default null
231 ,p_run_information25 varchar2 default null
232 ,p_run_information26 varchar2 default null
233 ,p_run_information27 varchar2 default null
234 ,p_run_information28 varchar2 default null
235 ,p_run_information29 varchar2 default null
236 ,p_run_information30 varchar2 default null
237 );
238 --
239 PROCEDURE up_run_type_usage(p_rtu_id number
240 ,p_parent_run_type_name varchar2
241 ,p_child_run_type_name varchar2
242 ,p_child_leg_code varchar2
243 ,p_child_bg varchar2
244 ,p_effective_start_date date
245 ,p_effective_end_date date
246 ,p_legislation_code varchar2
247 ,p_business_group varchar2
248 ,p_sequence number
249 ,p_rtu_eof_number number
250 );
251 --
252 PROCEDURE translate_row(p_base_rt_name varchar2
253 ,p_rt_leg_code varchar2
254 ,p_rt_bg varchar2
255 ,p_rt_name_tl varchar2
256 ,p_shortname_tl varchar2
257 );
258 --
259 procedure up_run_type_org_method (
260 p_rt_opm_id number,
261 p_rt_name varchar2,
262 p_opm_name varchar2,
263 p_effective_start_date date,
264 p_effective_end_date date,
265 p_priority number,
266 p_percentage number default null,
267 p_amount number default null,
268 p_business_group varchar2,
269 p_rt_bg varchar2 default null,
270 p_rt_lc varchar2 default null,
271 p_eof_number number
272 );
273 --
274 procedure up_element_type_usage (
275 p_etu_id number,
276 p_rt_name varchar2,
277 p_element_name varchar2,
278 p_effective_start_date date,
279 p_effective_end_date date,
280 p_business_group varchar2 default null,
281 p_legislative_code varchar2 default null,
282 p_rt_bg_name varchar2 default null,
283 p_rt_leg_code varchar2 default null,
284 p_et_bg_name varchar2 default null,
285 p_et_leg_code varchar2 default null,
286 p_inclusion_flag varchar2 default 'N',
287 p_usage_type varchar2,
288 p_eof_number number
289 );
290 function order_cumulative (p_run_type_name in varchar2
291 ,p_business_grp_name in varchar2
292 ,p_legislation_code in varchar2)
293 return VARCHAR2;
294 --
295 end pay_iterate;