[Home] [Help]
PACKAGE: APPS.BEN_PD_COPY_TO_BEN_ONE
Source
1 Package BEN_PD_COPY_TO_BEN_ONE as
2 /* $Header: bepdccp1.pkh 120.3 2006/03/08 02:43:19 rgajula noship $ */
3 --
4 TYPE g_pk_rec_type Is RECORD(
5 pk_id_column varchar2(80)
6 -- pk_id_column number(15)
7 ,old_value number(15)
8 ,new_value number(15)
9 ,copy_reuse_type varchar2(30)
10 ,table_route_id number(15)
11 );
12 --
13 g_pk_rec g_pk_rec_type ;
14 TYPE pk_table is table of g_pk_rec_type index by binary_integer ;
15 g_pk_tbl pk_table ;
16 g_count number := 1 ;
17 g_mapping_done boolean default true ;
18
19 --
20 -- Start Log additions
21 --
22 TYPE g_log_rec_type Is RECORD(
23 pk_id number(15)
24 ,new_name varchar2(1000)
25 );
26 --
27 TYPE log_table is table of g_log_rec_type index by binary_integer ;
28 --
29 g_pgm_tbl_copied log_table ;
30 g_pgm_tbl_reused log_table ;
31 g_pgm_tbl_copied_count number := 0 ;
32 g_pgm_tbl_reused_count number := 0 ;
33
34 g_pln_tbl_copied log_table ;
35 g_pln_tbl_reused log_table ;
36 g_pln_tbl_copied_count number := 0 ;
37 g_pln_tbl_reused_count number := 0 ;
38
39 g_opt_tbl_copied log_table ;
40 g_opt_tbl_reused log_table ;
41 g_opt_tbl_copied_count number := 0 ;
42 g_opt_tbl_reused_count number := 0 ;
43
44 g_ptp_tbl_copied log_table ;
45 g_ptp_tbl_reused log_table ;
46 g_ptp_tbl_copied_count number := 0 ;
47 g_ptp_tbl_reused_count number := 0 ;
48
49 g_eat_tbl_copied log_table ;
50 g_eat_tbl_reused log_table ;
51 g_eat_tbl_copied_count number := 0 ;
52 g_eat_tbl_reused_count number := 0 ;
53
54 g_bnb_tbl_copied log_table ;
55 g_bnb_tbl_reused log_table ;
56 g_bnb_tbl_copied_count number := 0 ;
57 g_bnb_tbl_reused_count number := 0 ;
58
59 g_clf_tbl_copied log_table ;
60 g_clf_tbl_reused log_table ;
61 g_clf_tbl_copied_count number := 0 ;
62 g_clf_tbl_reused_count number := 0 ;
63
64 g_hwf_tbl_copied log_table ;
65 g_hwf_tbl_reused log_table ;
66 g_hwf_tbl_copied_count number := 0 ;
67 g_hwf_tbl_reused_count number := 0 ;
68
69 g_agf_tbl_copied log_table ;
70 g_agf_tbl_reused log_table ;
71 g_agf_tbl_copied_count number := 0 ;
72 g_agf_tbl_reused_count number := 0 ;
73
74 g_lsf_tbl_copied log_table ;
75 g_lsf_tbl_reused log_table ;
76 g_lsf_tbl_copied_count number := 0 ;
77 g_lsf_tbl_reused_count number := 0 ;
78
79 g_pff_tbl_copied log_table ;
80 g_pff_tbl_reused log_table ;
81 g_pff_tbl_copied_count number := 0 ;
82 g_pff_tbl_reused_count number := 0 ;
83
84 g_cla_tbl_copied log_table ;
85 g_cla_tbl_reused log_table ;
86 g_cla_tbl_copied_count number := 0 ;
87 g_cla_tbl_reused_count number := 0 ;
88
89 g_reg_tbl_copied log_table ;
90 g_reg_tbl_reused log_table ;
91 g_reg_tbl_copied_count number := 0 ;
92 g_reg_tbl_reused_count number := 0 ;
93
94 g_bnr_tbl_copied log_table ;
95 g_bnr_tbl_reused log_table ;
96 g_bnr_tbl_copied_count number := 0 ;
97 g_bnr_tbl_reused_count number := 0 ;
98
99 g_bpp_tbl_copied log_table ;
100 g_bpp_tbl_reused log_table ;
101 g_bpp_tbl_copied_count number := 0 ;
102 g_bpp_tbl_reused_count number := 0 ;
103
104 g_ler_tbl_copied log_table ;
105 g_ler_tbl_reused log_table ;
106 g_ler_tbl_copied_count number := 0 ;
107 g_ler_tbl_reused_count number := 0 ;
108
109 g_psl_tbl_copied log_table ;
110 g_psl_tbl_reused log_table ;
111 g_psl_tbl_copied_count number := 0 ;
112 g_psl_tbl_reused_count number := 0 ;
113
114 g_elp_tbl_copied log_table ;
115 g_elp_tbl_reused log_table ;
116 g_elp_tbl_copied_count number := 0 ;
117 g_elp_tbl_reused_count number := 0 ;
118
119 g_dce_tbl_copied log_table ;
120 g_dce_tbl_reused log_table ;
121 g_dce_tbl_copied_count number := 0 ;
122 g_dce_tbl_reused_count number := 0 ;
123
124 g_gos_tbl_copied log_table ;
125 g_gos_tbl_reused log_table ;
126 g_gos_tbl_copied_count number := 0 ;
127 g_gos_tbl_reused_count number := 0 ;
128
129 g_bng_tbl_copied log_table ;
130 g_bng_tbl_reused log_table ;
131 g_bng_tbl_copied_count number := 0 ;
132 g_bng_tbl_reused_count number := 0 ;
133
134 g_pdl_tbl_copied log_table ;
135 g_pdl_tbl_reused log_table ;
136 g_pdl_tbl_copied_count number := 0 ;
137 g_pdl_tbl_reused_count number := 0 ;
138
139 g_sva_tbl_copied log_table ;
140 g_sva_tbl_reused log_table ;
141 g_sva_tbl_copied_count number := 0 ;
142 g_sva_tbl_reused_count number := 0 ;
143
144 g_cpl_tbl_copied log_table ;
145 g_cpl_tbl_reused log_table ;
146 g_cpl_tbl_copied_count number := 0 ;
147 g_cpl_tbl_reused_count number := 0 ;
148
149 g_cbp_tbl_copied log_table ;
150 g_cbp_tbl_reused log_table ;
151 g_cbp_tbl_copied_count number := 0 ;
152 g_cbp_tbl_reused_count number := 0 ;
153
154 g_cpt_tbl_copied log_table ;
155 g_cpt_tbl_reused log_table ;
156 g_cpt_tbl_copied_count number := 0 ;
157 g_cpt_tbl_reused_count number := 0 ;
158
159 g_fff_tbl_copied log_table ;
160 g_fff_tbl_reused log_table ;
161 g_fff_tbl_copied_count number := 0 ;
162 g_fff_tbl_reused_count number := 0 ;
163
164 g_abr_tbl_copied log_table ;
165 g_abr_tbl_reused log_table ;
166 g_abr_tbl_copied_count number := 0 ;
167 g_abr_tbl_reused_count number := 0 ;
168
169 g_apr_tbl_copied log_table ;
170 g_apr_tbl_reused log_table ;
171 g_apr_tbl_copied_count number := 0 ;
172 g_apr_tbl_reused_count number := 0 ;
173
174 g_vpf_tbl_copied log_table ;
175 g_vpf_tbl_reused log_table ;
176 g_vpf_tbl_copied_count number := 0 ;
177 g_vpf_tbl_reused_count number := 0 ;
178
179 g_ccm_tbl_copied log_table ;
180 g_ccm_tbl_reused log_table ;
181 g_ccm_tbl_copied_count number := 0 ;
182 g_ccm_tbl_reused_count number := 0 ;
183
184 g_acp_tbl_copied log_table ;
185 g_acp_tbl_reused log_table ;
186 g_acp_tbl_copied_count number := 0 ;
187 g_acp_tbl_reused_count number := 0 ;
188
189 g_egl_tbl_copied log_table ;
190 g_egl_tbl_reused log_table ;
191 g_egl_tbl_copied_count number := 0 ;
192 g_egl_tbl_reused_count number := 0 ;
193
194 g_copy_effective_date date;
195 g_transaction_category pqh_transaction_categories.short_name%type;
196
197 --
198 --
199 -- ----------------------------------------------------------------------------
200 -- |------------------------< log_data >--------------------------------------|
201 -- ----------------------------------------------------------------------------
202 --
203 procedure log_data(p_table_alias in varchar2
204 ,p_pk_id in number
205 ,p_new_name in varchar2
206 ,p_copied_reused_cd in varchar2);
207 --
208 --
209 -- ----------------------------------------------------------------------------
210 -- |-----------------------< ben_chk_col_len >--------------------------------|
211 -- ----------------------------------------------------------------------------
212 --
213 procedure ben_chk_col_len(column_type in varchar2
214 ,table_name in varchar2
215 ,column_value in varchar2);
216 --
217 --
218 -- ----------------------------------------------------------------------------
219 -- |------------------------< init_log_tbl >----------------------------------|
220 -- ----------------------------------------------------------------------------
221 --
222 procedure init_log_tbl;
223 --
224 -- End Log additions
225 --
226
227 --
228 -- Start Performance additions
229 --
230 TYPE g_table_data_in_cer_type Is RECORD(
231 table_alias varchar2(30),
232 table_route_id number
233 );
234 --
235 TYPE table_data_in_cer_table is table of g_table_data_in_cer_type index by binary_integer ;
236 --
237 g_table_data_in_cer table_data_in_cer_table;
238 g_table_data_in_cer_count number := 0;
239 --
240 -- ----------------------------------------------------------------------------
241 -- |------------------------< init_copy_tbl >---------------------------------|
242 -- ----------------------------------------------------------------------------
243 --
244 procedure init_table_data_in_cer(p_copy_entity_txn_id in number);
245 --
246 --
247 -- ----------------------------------------------------------------------------
248 -- |------------------------< data_exists >-----------------------------------|
249 -- ----------------------------------------------------------------------------
250 --
251 function data_exists_for_table(p_table_alias in varchar2) return boolean;
252
253 --
254 -- End Performance additions
255 --
256
257 -- ----------------------------------------------------------------------------
258 -- |------------------------< create_or_update_ff >------------------------|
259 -- ----------------------------------------------------------------------------
260 --
261 -- {Start Of Comments}
262 --
263 -- Description: This procedure is used to perform insert/dt update of the FF.
264 --
265 -- Prerequisites:
266 --
267 --
268 -- In Parameters:
269 -- Name Reqd Type Description
270 -- As Below
271 -- Post Success:
272 --
273 -- Out Parameters:
274 -- Name Type Description
275 -- None
276 -- Post Failure:
277 --
278 -- Access Status:
279 -- Public.
280 --
281 -- Working :
282 -- This procedure will alow datetrack update of the FF records
283 -- The 2 Parameters p_dml_operation and p_datetrack_mode will
284 -- be the deciding parameters of what will be done to the FF Table
285 --
286 -- p_dml_operation p_datetrack_mode
287 -- INSERT N/A
288 -- UPDATE UPDATE
289 -- UPDATE CORRECTION
290 -- UPDATE UPDATE_OVERRIDE
291 -- UPDATE UPDATE_CHANGE_INSERT
292
293 -- The datetrack modes may be passed to this externalised procedure using hr_api.g_xxxx constants also.
294
295 -- As of now the p_formula_text is a long parameter and this externalized procedure as of now
296 -- would not support for clob p_formula_text
297 -- {End Of Comments}
298 --
299
300 PROCEDURE create_or_update_ff
301 (p_formula_id in number,
302 p_effective_start_date in date,
303 p_effective_end_date in date,
304 p_business_group_id in number,
305 p_legislation_code in varchar,
306 p_formula_type_id in number,
307 p_formula_name in varchar,
308 p_description in varchar,
309 p_formula_text in long,
310 p_sticky_flag in varchar,
311 p_compile_flag in varchar,
312 p_last_update_date in date,
313 p_last_updated_by in number,
314 p_last_update_login in number,
315 p_created_by in number,
316 p_creation_date in date,
317 p_process_date in date,
318 p_dml_operation in varchar,
319 p_datetrack_mode in varchar);
320
321
322
323
324
325 -- ----------------------------------------------------------------------------
326 -- |------------------------< raise_error_message >------------------------|
327 -- ----------------------------------------------------------------------------
328 --
329 procedure raise_error_message( p_table_alias in varchar2,
330 p_object_name in varchar2 ) ;
331 --
332 -- ----------------------------------------------------------------------------
333 -- |------------------------< create_all_leaf_ben_rows >----------------------|
334 -- ----------------------------------------------------------------------------
335 -- {Start Of Comments}
336 --
337 -- Description:
338 --
339 -- Prerequisites:
340 --
341 --
342 -- In Parameters:
343 -- Name Reqd Type Description
344 -- Post Success:
345 --
346 -- Out Parameters:
347 -- Name Type Description
348 --
349 -- Post Failure:
350 --
351 -- Access Status:
352 -- Public.
353 --
354 -- {End Of Comments}
355 --
356 procedure create_all_leaf_ben_rows(
357 p_validate in number default 0 -- false
358 ,p_copy_entity_txn_id in number
359 ,p_effective_date in date
360 ,p_prefix_suffix_text in varchar2 default null
361 ,p_reuse_object_flag in varchar2 default null
362 ,p_target_business_group_id in varchar2 default null
363 ,p_prefix_suffix_cd in varchar2 default null
364 ,p_txn_row_type_cd in varchar2 default null
365 );
366 --New Parameter p_txn_row_type_cd addedd for TCS PDW Integration Enhancement
367 -- ----------------------------------------------------------------------------
368
369
370 -- ----------------------------------------------------------------------------
371 -- |------------------------< create_fff_rows >------------------------|
372 -- ----------------------------------------------------------------------------
373 PROCEDURE create_fff_rows (
374 p_validate IN NUMBER DEFAULT 0,
375 p_copy_entity_txn_id IN NUMBER,
376 p_effective_date IN DATE,
377 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
378 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
379 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
380 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
381 );
382
383 -- ----------------------------------------------------------------------------
384 -- |------------------------< create_clf_rows >------------------------|
385 -- ----------------------------------------------------------------------------
386
387 PROCEDURE create_clf_rows (
388 p_validate IN NUMBER DEFAULT 0,
389 p_copy_entity_txn_id IN NUMBER,
390 p_effective_date IN DATE,
391 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
392 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
393 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
394 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
395 );
396
397 -- ----------------------------------------------------------------------------
398 -- |------------------------< create_hwf_rows >------------------------|
399 -- ----------------------------------------------------------------------------
400
401 PROCEDURE create_hwf_rows (
402 p_validate IN NUMBER DEFAULT 0,
403 p_copy_entity_txn_id IN NUMBER,
404 p_effective_date IN DATE,
405 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
406 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
407 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
408 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
409 );
410
411 -- ----------------------------------------------------------------------------
412 -- |------------------------< create_agf_rows >------------------------|
413 -- ----------------------------------------------------------------------------
414
415 PROCEDURE create_agf_rows (
416 p_validate IN NUMBER DEFAULT 0,
417 p_copy_entity_txn_id IN NUMBER,
418 p_effective_date IN DATE,
419 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
420 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
421 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
422 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
423 );
424
425 -- ----------------------------------------------------------------------------
426 -- |------------------------< create_lsf_rows >------------------------|
427 -- ----------------------------------------------------------------------------
428
429 PROCEDURE create_lsf_rows (
430 p_validate IN NUMBER DEFAULT 0,
431 p_copy_entity_txn_id IN NUMBER,
432 p_effective_date IN DATE,
433 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
434 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
435 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
436 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
437 );
438
439 -- ----------------------------------------------------------------------------
440 -- |------------------------< create_pff_rows >------------------------|
441 -- ----------------------------------------------------------------------------
442
443 PROCEDURE create_pff_rows (
444 p_validate IN NUMBER DEFAULT 0,
445 p_copy_entity_txn_id IN NUMBER,
446 p_effective_date IN DATE,
447 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
448 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
449 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
450 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
451 );
452
453 -- ----------------------------------------------------------------------------
454 -- |------------------------< create_cla_rows >------------------------|
455 -- ----------------------------------------------------------------------------
456
457 PROCEDURE create_cla_rows (
458 p_validate IN NUMBER DEFAULT 0,
459 p_copy_entity_txn_id IN NUMBER,
460 p_effective_date IN DATE,
461 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
462 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
463 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
464 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
465 );
466
467 -- ----------------------------------------------------------------------------
468 -- |------------------------< create_elp_rows >------------------------|
469 -- ----------------------------------------------------------------------------
470
471 PROCEDURE create_elp_rows (
472 p_validate IN NUMBER DEFAULT 0,
473 p_copy_entity_txn_id IN NUMBER,
474 p_effective_date IN DATE,
475 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
476 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
477 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
478 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
479 );
480
481 -- ----------------------------------------------------------------------------
482 -- |--------------------------< create_egl_rows >------------------------|
483 -- ----------------------------------------------------------------------------
484
485 PROCEDURE create_egl_rows (
486 p_validate IN NUMBER DEFAULT 0,
487 p_copy_entity_txn_id IN NUMBER,
488 p_effective_date IN DATE,
489 p_prefix_suffix_text IN VARCHAR2 DEFAULT NULL,
490 p_reuse_object_flag IN VARCHAR2 DEFAULT NULL,
491 p_target_business_group_id IN VARCHAR2 DEFAULT NULL,
492 p_prefix_suffix_cd IN VARCHAR2 DEFAULT NULL
493 );
494
495 end BEN_PD_COPY_TO_BEN_ONE;