1 Package BEN_EXT_ADV_CONDITIONS AUTHID CURRENT_USER as
2 /* $Header: benxadvc.pkh 120.3 2006/04/27 11:28:14 tjesumic noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name:
11 Extract Advanced Conditions.
12 Purpose:
13 This package determines if a record or person should be excluded from
14 the extract. It uses dynamic sql.
15 History:
16 Date Version Who What?
17 ---- ------- ----------- -------------------------------------------
18 07/29/99 115.0 Ty Hayden Created.
19 09/27/99 115.1 Ty Hayden Added prevent_duplicates.
20 10/07/99 115.2 Ty Hayden Added chg_evt_incl procedure.
21 01/21/00 115.3 Ty Hayden Fix for data element conditions.
22 12/23/02 115.6 rpgupta Nocopy changes
23 06/21/05 115.7 tjesumic pernnserver , chg_rcd_merge added
24 06/21/05 115.8 tjesumic nocopy added to chg_rcd_merge
25 04/25/06 115.6 tjesumic new global qdded g_ext_adv_ct_validation
26 */
27 -----------------------------------------------------------------------------------
28 --
29 g_ext_adv_ct_validation varchar2(1) ;
30
31 Procedure rcd_in_file(p_ext_rcd_in_file_id in number,
32 p_sprs_cd in varchar2,
33 p_exclude_this_rcd_flag out nocopy boolean);
34
35 Procedure data_elmt_in_rcd(p_ext_rcd_id in number,
36 p_exclude_this_rcd_flag out nocopy boolean);
37
38 Procedure prevent_duplicates(p_ext_rslt_id in number,
39 p_person_id in number,
40 p_any_or_all_cd in varchar2,
41 p_ext_rcd_id in number,
42 p_exclude_this_rcd_flag out nocopy boolean);
43
44 Procedure chg_evt_incl
45 (p_ext_rcd_in_file_id in number default null,
46 p_rcd_seq_num in number default null,
47 p_ext_data_elmt_in_rcd_id in number default null,
48 p_data_elmt_seq_num in number default null,
49 p_chg_evt_cd in varchar2,
50 p_exclude_flag out nocopy boolean);
51
52
53 procedure chg_rcd_merge (
54 p_ext_rslt_id in number default null
55 ,p_ext_rcd_id in number default null
56 ,p_person_id in number default null
57 ,p_business_group_id in number default null
58 ,p_val_01 in out nocopy varchar2
59 ,p_val_02 in out nocopy varchar2
60 ,p_val_03 in out nocopy varchar2
61 ,p_val_04 in out nocopy varchar2
62 ,p_val_05 in out nocopy varchar2
63 ,p_val_06 in out nocopy varchar2
64 ,p_val_07 in out nocopy varchar2
65 ,p_val_08 in out nocopy varchar2
66 ,p_val_09 in out nocopy varchar2
67 ,p_val_10 in out nocopy varchar2
68 ,p_val_11 in out nocopy varchar2
69 ,p_val_12 in out nocopy varchar2
70 ,p_val_13 in out nocopy varchar2
71 ,p_val_14 in out nocopy varchar2
72 ,p_val_15 in out nocopy varchar2
73 ,p_val_16 in out nocopy varchar2
74 ,p_val_17 in out nocopy varchar2
75 ,p_val_19 in out nocopy varchar2
76 ,p_val_18 in out nocopy varchar2
77 ,p_val_20 in out nocopy varchar2
78 ,p_val_21 in out nocopy varchar2
79 ,p_val_22 in out nocopy varchar2
80 ,p_val_23 in out nocopy varchar2
81 ,p_val_24 in out nocopy varchar2
82 ,p_val_25 in out nocopy varchar2
83 ,p_val_26 in out nocopy varchar2
84 ,p_val_27 in out nocopy varchar2
85 ,p_val_28 in out nocopy varchar2
86 ,p_val_29 in out nocopy varchar2
87 ,p_val_30 in out nocopy varchar2
88 ,p_val_31 in out nocopy varchar2
89 ,p_val_32 in out nocopy varchar2
90 ,p_val_33 in out nocopy varchar2
91 ,p_val_34 in out nocopy varchar2
92 ,p_val_35 in out nocopy varchar2
93 ,p_val_36 in out nocopy varchar2
94 ,p_val_37 in out nocopy varchar2
95 ,p_val_38 in out nocopy varchar2
96 ,p_val_39 in out nocopy varchar2
97 ,p_val_40 in out nocopy varchar2
98 ,p_val_41 in out nocopy varchar2
99 ,p_val_42 in out nocopy varchar2
100 ,p_val_43 in out nocopy varchar2
101 ,p_val_44 in out nocopy varchar2
102 ,p_val_45 in out nocopy varchar2
103 ,p_val_46 in out nocopy varchar2
104 ,p_val_47 in out nocopy varchar2
105 ,p_val_48 in out nocopy varchar2
106 ,p_val_49 in out nocopy varchar2
107 ,p_val_50 in out nocopy varchar2
108 ,p_val_51 in out nocopy varchar2
109 ,p_val_52 in out nocopy varchar2
110 ,p_val_53 in out nocopy varchar2
111 ,p_val_54 in out nocopy varchar2
112 ,p_val_55 in out nocopy varchar2
113 ,p_val_56 in out nocopy varchar2
114 ,p_val_57 in out nocopy varchar2
115 ,p_val_58 in out nocopy varchar2
116 ,p_val_59 in out nocopy varchar2
117 ,p_val_60 in out nocopy varchar2
118 ,p_val_61 in out nocopy varchar2
119 ,p_val_62 in out nocopy varchar2
120 ,p_val_63 in out nocopy varchar2
121 ,p_val_64 in out nocopy varchar2
122 ,p_val_65 in out nocopy varchar2
123 ,p_val_66 in out nocopy varchar2
124 ,p_val_67 in out nocopy varchar2
125 ,p_val_68 in out nocopy varchar2
126 ,p_val_69 in out nocopy varchar2
127 ,p_val_70 in out nocopy varchar2
128 ,p_val_71 in out nocopy varchar2
129 ,p_val_72 in out nocopy varchar2
130 ,p_val_73 in out nocopy varchar2
131 ,p_val_74 in out nocopy varchar2
132 ,p_val_75 in out nocopy varchar2
133 ,p_val_76 in out nocopy varchar2
134 ,p_val_77 in out nocopy varchar2
135 ,p_val_78 in out nocopy varchar2
136 ,p_val_79 in out nocopy varchar2
137 ,p_val_80 in out nocopy varchar2
138 ,p_val_81 in out nocopy varchar2
139 ,p_val_82 in out nocopy varchar2
140 ,p_val_83 in out nocopy varchar2
141 ,p_val_84 in out nocopy varchar2
142 ,p_val_85 in out nocopy varchar2
143 ,p_val_86 in out nocopy varchar2
144 ,p_val_87 in out nocopy varchar2
145 ,p_val_88 in out nocopy varchar2
146 ,p_val_89 in out nocopy varchar2
147 ,p_val_90 in out nocopy varchar2
148 ,p_val_91 in out nocopy varchar2
149 ,p_val_92 in out nocopy varchar2
150 ,p_val_93 in out nocopy varchar2
151 ,p_val_94 in out nocopy varchar2
152 ,p_val_95 in out nocopy varchar2
153 ,p_val_96 in out nocopy varchar2
154 ,p_val_97 in out nocopy varchar2
155 ,p_val_98 in out nocopy varchar2
156 ,p_val_99 in out nocopy varchar2
157 ,p_val_100 in out nocopy varchar2
158 ,p_val_101 in out nocopy varchar2
159 ,p_val_102 in out nocopy varchar2
160 ,p_val_103 in out nocopy varchar2
161 ,p_val_104 in out nocopy varchar2
162 ,p_val_105 in out nocopy varchar2
163 ,p_val_106 in out nocopy varchar2
164 ,p_val_107 in out nocopy varchar2
165 ,p_val_108 in out nocopy varchar2
166 ,p_val_109 in out nocopy varchar2
167 ,p_val_110 in out nocopy varchar2
168 ,p_val_111 in out nocopy varchar2
169 ,p_val_112 in out nocopy varchar2
170 ,p_val_113 in out nocopy varchar2
171 ,p_val_114 in out nocopy varchar2
172 ,p_val_115 in out nocopy varchar2
173 ,p_val_116 in out nocopy varchar2
174 ,p_val_117 in out nocopy varchar2
175 ,p_val_119 in out nocopy varchar2
176 ,p_val_118 in out nocopy varchar2
177 ,p_val_120 in out nocopy varchar2
178 ,p_val_121 in out nocopy varchar2
179 ,p_val_122 in out nocopy varchar2
180 ,p_val_123 in out nocopy varchar2
181 ,p_val_124 in out nocopy varchar2
182 ,p_val_125 in out nocopy varchar2
183 ,p_val_126 in out nocopy varchar2
184 ,p_val_127 in out nocopy varchar2
185 ,p_val_128 in out nocopy varchar2
186 ,p_val_129 in out nocopy varchar2
187 ,p_val_130 in out nocopy varchar2
188 ,p_val_131 in out nocopy varchar2
189 ,p_val_132 in out nocopy varchar2
190 ,p_val_133 in out nocopy varchar2
191 ,p_val_134 in out nocopy varchar2
192 ,p_val_135 in out nocopy varchar2
193 ,p_val_136 in out nocopy varchar2
194 ,p_val_137 in out nocopy varchar2
195 ,p_val_138 in out nocopy varchar2
196 ,p_val_139 in out nocopy varchar2
197 ,p_val_140 in out nocopy varchar2
198 ,p_val_141 in out nocopy varchar2
199 ,p_val_142 in out nocopy varchar2
200 ,p_val_143 in out nocopy varchar2
201 ,p_val_144 in out nocopy varchar2
202 ,p_val_145 in out nocopy varchar2
203 ,p_val_146 in out nocopy varchar2
204 ,p_val_147 in out nocopy varchar2
205 ,p_val_148 in out nocopy varchar2
206 ,p_val_149 in out nocopy varchar2
207 ,p_val_150 in out nocopy varchar2
208 ,p_val_151 in out nocopy varchar2
209 ,p_val_152 in out nocopy varchar2
210 ,p_val_153 in out nocopy varchar2
211 ,p_val_154 in out nocopy varchar2
212 ,p_val_155 in out nocopy varchar2
213 ,p_val_156 in out nocopy varchar2
214 ,p_val_157 in out nocopy varchar2
215 ,p_val_158 in out nocopy varchar2
216 ,p_val_159 in out nocopy varchar2
217 ,p_val_160 in out nocopy varchar2
218 ,p_val_161 in out nocopy varchar2
219 ,p_val_162 in out nocopy varchar2
220 ,p_val_163 in out nocopy varchar2
221 ,p_val_164 in out nocopy varchar2
222 ,p_val_165 in out nocopy varchar2
223 ,p_val_166 in out nocopy varchar2
224 ,p_val_167 in out nocopy varchar2
225 ,p_val_168 in out nocopy varchar2
226 ,p_val_169 in out nocopy varchar2
227 ,p_val_170 in out nocopy varchar2
228 ,p_val_171 in out nocopy varchar2
229 ,p_val_172 in out nocopy varchar2
230 ,p_val_173 in out nocopy varchar2
231 ,p_val_174 in out nocopy varchar2
232 ,p_val_175 in out nocopy varchar2
233 ,p_val_176 in out nocopy varchar2
234 ,p_val_177 in out nocopy varchar2
235 ,p_val_178 in out nocopy varchar2
236 ,p_val_179 in out nocopy varchar2
237 ,p_val_180 in out nocopy varchar2
238 ,p_val_181 in out nocopy varchar2
242 ,p_val_185 in out nocopy varchar2
239 ,p_val_182 in out nocopy varchar2
240 ,p_val_183 in out nocopy varchar2
241 ,p_val_184 in out nocopy varchar2
243 ,p_val_186 in out nocopy varchar2
244 ,p_val_187 in out nocopy varchar2
245 ,p_val_188 in out nocopy varchar2
246 ,p_val_189 in out nocopy varchar2
247 ,p_val_190 in out nocopy varchar2
248 ,p_val_191 in out nocopy varchar2
249 ,p_val_192 in out nocopy varchar2
250 ,p_val_193 in out nocopy varchar2
251 ,p_val_194 in out nocopy varchar2
252 ,p_val_195 in out nocopy varchar2
253 ,p_val_196 in out nocopy varchar2
254 ,p_val_197 in out nocopy varchar2
255 ,p_val_198 in out nocopy varchar2
256 ,p_val_199 in out nocopy varchar2
257 ,p_val_200 in out nocopy varchar2
258 ,p_val_201 in out nocopy varchar2
259 ,p_val_202 in out nocopy varchar2
260 ,p_val_203 in out nocopy varchar2
261 ,p_val_204 in out nocopy varchar2
262 ,p_val_205 in out nocopy varchar2
263 ,p_val_206 in out nocopy varchar2
264 ,p_val_207 in out nocopy varchar2
265 ,p_val_208 in out nocopy varchar2
266 ,p_val_209 in out nocopy varchar2
267 ,p_val_210 in out nocopy varchar2
268 ,p_val_211 in out nocopy varchar2
269 ,p_val_212 in out nocopy varchar2
270 ,p_val_213 in out nocopy varchar2
271 ,p_val_214 in out nocopy varchar2
272 ,p_val_215 in out nocopy varchar2
273 ,p_val_216 in out nocopy varchar2
274 ,p_val_217 in out nocopy varchar2
275 ,p_val_219 in out nocopy varchar2
276 ,p_val_218 in out nocopy varchar2
277 ,p_val_220 in out nocopy varchar2
278 ,p_val_221 in out nocopy varchar2
279 ,p_val_222 in out nocopy varchar2
280 ,p_val_223 in out nocopy varchar2
281 ,p_val_224 in out nocopy varchar2
282 ,p_val_225 in out nocopy varchar2
283 ,p_val_226 in out nocopy varchar2
284 ,p_val_227 in out nocopy varchar2
285 ,p_val_228 in out nocopy varchar2
286 ,p_val_229 in out nocopy varchar2
287 ,p_val_230 in out nocopy varchar2
288 ,p_val_231 in out nocopy varchar2
289 ,p_val_232 in out nocopy varchar2
290 ,p_val_233 in out nocopy varchar2
291 ,p_val_234 in out nocopy varchar2
292 ,p_val_235 in out nocopy varchar2
293 ,p_val_236 in out nocopy varchar2
294 ,p_val_237 in out nocopy varchar2
295 ,p_val_238 in out nocopy varchar2
296 ,p_val_239 in out nocopy varchar2
297 ,p_val_240 in out nocopy varchar2
298 ,p_val_241 in out nocopy varchar2
299 ,p_val_242 in out nocopy varchar2
300 ,p_val_243 in out nocopy varchar2
301 ,p_val_244 in out nocopy varchar2
302 ,p_val_245 in out nocopy varchar2
303 ,p_val_246 in out nocopy varchar2
304 ,p_val_247 in out nocopy varchar2
305 ,p_val_248 in out nocopy varchar2
306 ,p_val_249 in out nocopy varchar2
307 ,p_val_250 in out nocopy varchar2
308 ,p_val_251 in out nocopy varchar2
309 ,p_val_252 in out nocopy varchar2
310 ,p_val_253 in out nocopy varchar2
311 ,p_val_254 in out nocopy varchar2
312 ,p_val_255 in out nocopy varchar2
313 ,p_val_256 in out nocopy varchar2
314 ,p_val_257 in out nocopy varchar2
315 ,p_val_258 in out nocopy varchar2
316 ,p_val_259 in out nocopy varchar2
317 ,p_val_260 in out nocopy varchar2
318 ,p_val_261 in out nocopy varchar2
319 ,p_val_262 in out nocopy varchar2
320 ,p_val_263 in out nocopy varchar2
321 ,p_val_264 in out nocopy varchar2
322 ,p_val_265 in out nocopy varchar2
323 ,p_val_266 in out nocopy varchar2
324 ,p_val_267 in out nocopy varchar2
325 ,p_val_268 in out nocopy varchar2
326 ,p_val_269 in out nocopy varchar2
327 ,p_val_270 in out nocopy varchar2
328 ,p_val_271 in out nocopy varchar2
329 ,p_val_272 in out nocopy varchar2
330 ,p_val_273 in out nocopy varchar2
331 ,p_val_274 in out nocopy varchar2
332 ,p_val_275 in out nocopy varchar2
333 ,p_val_276 in out nocopy varchar2
334 ,p_val_277 in out nocopy varchar2
335 ,p_val_278 in out nocopy varchar2
336 ,p_val_279 in out nocopy varchar2
337 ,p_val_280 in out nocopy varchar2
338 ,p_val_281 in out nocopy varchar2
339 ,p_val_282 in out nocopy varchar2
340 ,p_val_283 in out nocopy varchar2
341 ,p_val_284 in out nocopy varchar2
342 ,p_val_285 in out nocopy varchar2
343 ,p_val_286 in out nocopy varchar2
344 ,p_val_287 in out nocopy varchar2
345 ,p_val_288 in out nocopy varchar2
346 ,p_val_289 in out nocopy varchar2
347 ,p_val_290 in out nocopy varchar2
348 ,p_val_291 in out nocopy varchar2
349 ,p_val_292 in out nocopy varchar2
350 ,p_val_293 in out nocopy varchar2
351 ,p_val_294 in out nocopy varchar2
352 ,p_val_295 in out nocopy varchar2
353 ,p_val_296 in out nocopy varchar2
354 ,p_val_297 in out nocopy varchar2
355 ,p_val_298 in out nocopy varchar2
356 ,p_val_299 in out nocopy varchar2
357 ,p_val_300 in out nocopy varchar2
358 ,p_ext_rcd_in_file_id in number default null
359 ,p_object_version_number out nocopy number
360 ,p_ext_rslt_dtl_id out nocopy number
361 ,p_ext_chg_rcd_mode out nocopy varchar2
362 ) ;
363
364
365 Procedure WRITE_WARNING
366 (p_err_name in varchar2,
367 p_err_no in number default null,
368 p_element in varchar2 default null ) ;
369
370 END; -- Package spec