1 PACKAGE per_ri_config_tech_summary AUTHID CURRENT_USER AS
2 /* $Header: perricts.pkh 120.1.12000000.2 2007/09/21 11:07:22 vdabgar noship $ */
3
4 -- Keyflex Value Set Record
5 TYPE tech_summary_keyflex_value_set IS RECORD
9 ,enable_longlist fnd_flex_value_sets.longlist_flag%type
6 (value_set_name fnd_flex_value_sets.flex_value_set_name%type
7 ,description fnd_flex_value_sets.description%type
8 ,security_available fnd_flex_value_sets.security_enabled_flag%type
10 ,format_type fnd_flex_value_sets.format_type%type
11 ,maximum_size fnd_flex_value_sets.maximum_size%type
12 ,precision fnd_flex_value_sets.number_precision%type
13 ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14 ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
15 ,right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
16 ,min_value fnd_flex_value_sets.minimum_value%type
17 ,max_value fnd_flex_value_sets.maximum_value%type);
18
19 TYPE valueset_tab IS TABLE OF
20 tech_summary_keyflex_value_set
21 INDEX BY BINARY_INTEGER;
22
23 -- Keyflex Segment Record
24 TYPE tech_summary_keyflex_segment IS RECORD
25 (appl_short_name fnd_application.application_short_name%type
26 ,flex_code fnd_id_flex_structures_vl.id_flex_structure_code%type
27 ,structure_code fnd_id_flex_structures_vl.id_flex_structure_name%type
28 ,segment_name fnd_id_flex_segments_vl.segment_name%type
29 ,column_name fnd_id_flex_segments_vl.application_column_name%type
30 ,segment_number number(8)
31 ,value_set fnd_flex_value_sets.flex_value_set_name%type
32 ,lov_prompt fnd_id_flex_segments_vl.segment_name%type
33 ,segment_type varchar2(80)
34 ,window_prompt fnd_id_flex_segments_vl.segment_name%type
35 --
36 ,vs_value_set_name fnd_flex_value_sets.flex_value_set_name%type
37 ,vs_description fnd_flex_value_sets.description%type
38 ,vs_security_available fnd_flex_value_sets.security_enabled_flag%type
39 ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40 ,vs_format_type fnd_flex_value_sets.format_type%type
41 ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42 ,vs_precision fnd_flex_value_sets.number_precision%type
43 ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44 ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
45 ,vs_right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
46 ,vs_min_value fnd_flex_value_sets.minimum_value%type
47 ,vs_max_value fnd_flex_value_sets.maximum_value%type
48 );
49
50 TYPE kf_segment_tab IS TABLE OF
51 tech_summary_keyflex_segment
52 INDEX BY BINARY_INTEGER;
53
54 TYPE kf_job_seg_tab IS TABLE OF
55 tech_summary_keyflex_segment
56 INDEX BY BINARY_INTEGER;
57
58 TYPE kf_job_rv_seg_tab IS TABLE OF
59 tech_summary_keyflex_segment
60 INDEX BY BINARY_INTEGER;
61
62 TYPE kf_pos_rv_seg_tab IS TABLE OF
63 tech_summary_keyflex_segment
64 INDEX BY BINARY_INTEGER;
65
66 TYPE kf_grd_rv_seg_tab IS TABLE OF
67 tech_summary_keyflex_segment
68 INDEX BY BINARY_INTEGER;
69
70 TYPE kf_grd_seg_tab IS TABLE OF
71 tech_summary_keyflex_segment
72 INDEX BY BINARY_INTEGER;
73
74 TYPE kf_pos_seg_tab IS TABLE OF
75 tech_summary_keyflex_segment
76 INDEX BY BINARY_INTEGER;
77
78 TYPE kf_grp_seg_tab IS TABLE OF
79 tech_summary_keyflex_segment
80 INDEX BY BINARY_INTEGER;
81
82 TYPE kf_grd_no_rv_seg_tab IS TABLE OF
83 tech_summary_keyflex_segment
84 INDEX BY BINARY_INTEGER;
85
86 TYPE kf_cmp_seg_tab IS TABLE OF
87 tech_summary_keyflex_segment
88 INDEX BY BINARY_INTEGER;
89
90 TYPE kf_cost_seg_tab IS TABLE OF
91 tech_summary_keyflex_segment
92 INDEX BY BINARY_INTEGER;
93
94 TYPE kf_pos_no_rv_seg_tab IS TABLE OF
95 tech_summary_keyflex_segment
96 INDEX BY BINARY_INTEGER;
97
98
99 -- Keyflex Structure Record
100 TYPE tech_summary_keyflex_structure IS RECORD
101 (appl_short_name fnd_application.application_short_name%type
102 ,flex_code fnd_id_flex_structures_vl.id_flex_structure_code%type
103 ,structure_code fnd_id_flex_structures_vl.id_flex_structure_name%type
104 ,structure_title fnd_id_flex_structures_vl.id_flex_structure_name%type
105 ,description fnd_id_flex_structures_vl.description%type
106 );
107
108 -- Keyflex Structure Table
109 TYPE kf_structure_tab IS TABLE OF
110 tech_summary_keyflex_structure
111 INDEX BY BINARY_INTEGER;
112
113 -- Keyflex Structure JOB Table
114 TYPE kf_job_tab IS TABLE OF
115 tech_summary_keyflex_structure
116 INDEX BY BINARY_INTEGER;
117
118 -- Keyflex Structure JOB Table (create_jobs_no_rv_keyflex)
119 TYPE kf_job_no_rv_tab IS TABLE OF
120 tech_summary_keyflex_structure
121 INDEX BY BINARY_INTEGER;
122
123 -- Keyflex Segments JOB Table (create_jobs_no_rv_keyflex)
124 TYPE kf_job_no_rv_seg_tab IS TABLE OF
125 tech_summary_keyflex_segment
126 INDEX BY BINARY_INTEGER;
127
128 -- Keyflex Structure POS Table (create_positions_no_rv_keyflex)
129 TYPE kf_pos_no_rv_tab IS TABLE OF
130 tech_summary_keyflex_structure
131 INDEX BY BINARY_INTEGER;
132
133 -- Keyflex Structure GRD Table (create_grades_no_rv_keyflex)
137
134 TYPE kf_grd_no_rv_tab IS TABLE OF
135 tech_summary_keyflex_structure
136 INDEX BY BINARY_INTEGER;
138 -- Keyflex Structure GRD Table (create_grades_rv_keyflex)
139 TYPE kf_grd_rv_tab IS TABLE OF
140 tech_summary_keyflex_structure
141 INDEX BY BINARY_INTEGER;
142
143 -- Keyflex Structure JOB Table (create_jobs_rv_keyflex)
144 TYPE kf_job_rv_tab IS TABLE OF
145 tech_summary_keyflex_structure
146 INDEX BY BINARY_INTEGER;
147
148 -- Keyflex Structure POS Table (create_positions_rv_keyflex)
149 TYPE kf_pos_rv_tab IS TABLE OF
150 tech_summary_keyflex_structure
151 INDEX BY BINARY_INTEGER;
152
153 -- Keyflex Structure POS Table
154 TYPE kf_pos_tab IS TABLE OF
155 tech_summary_keyflex_structure
156 INDEX BY BINARY_INTEGER;
157
158 -- Keyflex Structure GRD Table
159 TYPE kf_grd_tab IS TABLE OF
160 tech_summary_keyflex_structure
161 INDEX BY BINARY_INTEGER;
162
163 -- Keyflex Structure CMP Table
164 TYPE kf_cmp_tab IS TABLE OF
165 tech_summary_keyflex_structure
166 INDEX BY BINARY_INTEGER;
167
168 -- Keyflex Structure GRP Table
169 TYPE kf_grp_tab IS TABLE OF
170 tech_summary_keyflex_structure
171 INDEX BY BINARY_INTEGER;
172
173 -- Keyflex Structure COST Table
174 TYPE kf_cost_tab IS TABLE OF
175 tech_summary_keyflex_structure
176 INDEX BY BINARY_INTEGER;
177
178 -- Users Record
179 TYPE tech_summary_user_rec IS RECORD
180 (user_name fnd_user.user_name%type
181 ,start_date date
182 ,description fnd_user.description%type
183 );
184
185
186 -- Users Table
187 TYPE user_tab IS TABLE OF
188 tech_summary_user_rec
189 INDEX BY BINARY_INTEGER;
190
191
192 -- User Responsibility Record
193 TYPE tech_summary_resp_rec IS RECORD
194 (user_name fnd_user.user_name%type
195 ,resp_key fnd_responsibility_vl.responsibility_name%type
196 ,app_short_name fnd_application.application_short_name%type
197 ,security_group fnd_security_groups_vl.security_group_name%type
198 ,owner varchar2(100)
199 ,start_date varchar2(80)
200 ,end_date varchar2(80)
201 --,start_date fnd_responsibility_vl.start_date%type
202 --,end_date fnd_responsibility_vl.end_date%type
203 ,description fnd_responsibility_vl.description%type);
204
205 --User Responsibility Table
206 TYPE resp_tab IS TABLE OF
207 tech_summary_resp_rec
208 INDEX BY BINARY_INTEGER;
209
210 --User HRMS Responsibility Table
211 TYPE hrms_resp_tab IS TABLE OF
212 tech_summary_resp_rec
213 INDEX BY BINARY_INTEGER;
214
215 --User Misc HRMS Responsibility Table
216 TYPE hrms_misc_resp_tab IS TABLE OF
217 tech_summary_resp_rec
218 INDEX BY BINARY_INTEGER;
219
220 -- Profile Options Record
221 TYPE tech_summary_profile_rec IS RECORD
222 (level varchar2(80)
223 ,level_value varchar2(80)
224 ,level_value_app varchar2(80)
225 ,profile_name fnd_profile_options.profile_option_name%type
226 ,profile_option_value fnd_profile_option_values.profile_option_value%type);
227
228 --Profile Options Table Site Level
229 TYPE profile_tab IS TABLE OF
230 tech_summary_profile_rec
231 INDEX BY BINARY_INTEGER;
232
233 --Profile Options Table Application Level
234 TYPE profile_apps_tab IS TABLE OF
235 tech_summary_profile_rec
236 INDEX BY BINARY_INTEGER;
237
238 --Profile Options Table Resposibility Level
239 TYPE profile_resp_tab IS TABLE OF
240 tech_summary_profile_rec
241 INDEX BY BINARY_INTEGER;
242
243 --Profile Options Table Site Level
244 TYPE profile_dpe_ent_tab IS TABLE OF
245 tech_summary_profile_rec
246 INDEX BY BINARY_INTEGER;
247
248 -- Organizations Record
249 TYPE tech_summary_org_rec IS RECORD
250 (effective_date date
251 ,date_from date
252 ,business_grp_name per_business_groups.name%type
253 ,name per_business_groups.name%type
254 ,location_code per_ri_config_locations.description%type -- fix for 4457389
255 ,internal_external_flag hr_all_organization_units.internal_external_flag%type);
256
257 -- Enterprise Table
258 TYPE org_ent_tab IS TABLE OF
259 tech_summary_org_rec
260 INDEX BY BINARY_INTEGER;
261
262 -- Operating Company table
263 TYPE org_oc_tab IS TABLE OF
264 tech_summary_org_rec
265 INDEX BY BINARY_INTEGER;
266
267 -- Legal Entity table
268 TYPE org_le_tab IS TABLE OF
269 tech_summary_org_rec
270 INDEX BY BINARY_INTEGER;
271
272 -- Organizations Hierarchy Record
273 TYPE org_hierarchy_rec IS RECORD
274 (name per_organization_structures.name%type
275 ,org_structure_version_id per_org_structure_versions.org_structure_version_id%type);
276
277 -- Organizations Hierarchy Table
278 TYPE org_hierarchy_tab IS TABLE OF
279 org_hierarchy_rec
280 INDEX BY BINARY_INTEGER;
281
282 -- Organizations Hierarchy Elements Record
283 TYPE org_hierarchy_ele_rec IS RECORD
284 (org_structure_version_id per_org_structure_versions.org_structure_version_id%type
285 ,parent_organization_name hr_all_organization_units.name%type
286 ,child_organization_name hr_all_organization_units.name%type);
287
288 -- Organizations Hierarchy Elements OC Table
289 TYPE org_hierarchy_ele_oc_tab IS TABLE OF
290 org_hierarchy_ele_rec
291 INDEX BY BINARY_INTEGER;
292
293 -- Organizations Hierarchy Elements LE Table
294 TYPE org_hierarchy_ele_le_tab IS TABLE OF
295 org_hierarchy_ele_rec
296 INDEX BY BINARY_INTEGER;
297
298
299 -- Organizations Classification Record
300 TYPE org_class_rec IS RECORD
301 (effective_date date
302 ,date_from date
303 ,business_grp_name per_business_groups.name%type
304 ,org_classif_code per_business_groups.name%type
305 ,organization_name hr_all_organization_units.name%type);
306
307
308 -- Organizations Classification Record
309
310 -- Enterprise Org Class Table
311 TYPE org_ent_class_tab IS TABLE OF
312 org_class_rec
313 INDEX BY BINARY_INTEGER;
314
315 -- Operating Company Org Class table
316 TYPE org_oc_class_tab IS TABLE OF
317 org_class_rec
318 INDEX BY BINARY_INTEGER;
319
320 -- Legal Entity Org Class table
321 TYPE org_le_class_tab IS TABLE OF
322 org_class_rec
323 INDEX BY BINARY_INTEGER;
324
325
326 TYPE location_rec IS RECORD
327 (location_code per_ri_config_locations.description%type --fix for 4457389
328 ,description per_ri_config_locations.description%type
329 ,address_line_1 per_ri_config_locations.address_line_1%type
330 ,address_line_2 per_ri_config_locations.address_line_2%type
331 ,address_line_3 per_ri_config_locations.address_line_3%type
332 ,bill_to_site_flag hr_locations_all.bill_to_site_flag%type
333 ,country per_ri_config_locations.country%type
334 ,in_organization_flag hr_locations_all.in_organization_flag%type
335 ,postal_code per_ri_config_locations.postal_code%type
336 ,receiving_site_flag hr_locations_all.receiving_site_flag%type
337 ,region_1 per_ri_config_locations.region_1%type
338 ,region_2 per_ri_config_locations.region_2%type
339 ,region_3 per_ri_config_locations.region_3%type
340 ,ship_to_site_flag hr_locations_all.ship_to_site_flag%type
341 ,style per_ri_config_locations.style%type
342 ,telephone_number_1 per_ri_config_locations.telephone_number_1%type
343 ,telephone_number_2 per_ri_config_locations.telephone_number_2%type
344 ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345 ,town_or_city per_ri_config_locations.town_or_city%type
346 ,loc_information13 per_ri_config_locations.loc_information13%type
347 ,loc_information14 per_ri_config_locations.loc_information14%type
348 ,loc_information15 per_ri_config_locations.loc_information15%type
349 ,loc_information16 per_ri_config_locations.loc_information16%type
350 ,loc_information17 per_ri_config_locations.loc_information17%type
351 ,loc_information18 per_ri_config_locations.loc_information18%type
352 ,loc_information19 per_ri_config_locations.loc_information19%type
353 ,loc_information20 per_ri_config_locations.loc_information20%type
354 ,ship_to_location_code per_ri_config_locations.description%type); -- fix for 4457389
355
356 TYPE location_tab IS TABLE OF
357 location_rec
358 INDEX BY BINARY_INTEGER;
359
360 TYPE bg_rec IS RECORD
361 (effective_date date
362 ,language_code fnd_languages.language_code%type
363 ,date_from date
364 ,name hr_all_organization_units.name%type
365 ,type hr_all_organization_units.type%type
366 ,internal_external_flag hr_all_organization_units.internal_external_flag%type
367 ,short_name hr_all_organization_units.name%type
368 ,emp_gen_method per_business_groups.method_of_generation_emp_num%type
372 ,currency_code per_business_groups.currency_code%type
369 ,app_gen_method per_business_groups.method_of_generation_apl_num%type
370 ,cwk_gen_method per_business_groups.method_of_generation_cwk_num%type
371 ,legislation_code per_business_groups.legislation_code%type
373 ,fiscal_year_start date
374 ,min_work_age number(8)
375 ,max_work_age number(8)
376 ,location_code hr_all_organization_units.name%type
377 ,grade_flex_stru_code per_business_groups.grade_structure%type
378 ,group_flex_stru_code per_business_groups.people_group_structure%type
379 ,job_flex_stru_code per_business_groups.job_structure%type
380 ,cost_flex_stru_code per_business_groups.cost_allocation_structure%type
381 ,position_flex_stru_code per_business_groups.position_structure%type
382 ,security_group_name per_business_groups.security_group_id%type
383 ,competence_flex_stru_code per_business_groups.competence_structure%type);
384
385 TYPE bg_tab IS TABLE OF
386 bg_rec
387 INDEX BY BINARY_INTEGER;
388
389 TYPE sg_rec IS RECORD
390 (security_group_name fnd_security_groups_vl.security_group_name%type
391 ,business_group_name per_business_groups.name%type);
392
393 TYPE sg_tab IS TABLE OF
394 sg_rec
395 INDEX BY BINARY_INTEGER;
396
397 TYPE l_clob_rec_type is RECORD
398 (table_name varchar2(30),
399 xmldoc clob);
400
401
402 -- International HRMS Setup Record
403 TYPE tech_summary_int_hrms_setup IS RECORD
404 (legislation_code pay_leg_setup_defaults.legislation_code%type
405 ,currency_code pay_leg_setup_defaults.currency_code%type
406 ,tax_start_date pay_leg_setup_defaults.tax_start_date%type
407 ,install_tax_unit pay_leg_setup_defaults.tax_unit_flag%type);
408
409 --International HRMS Setup Table
410 TYPE int_hrms_setup_tab IS TABLE OF
411 tech_summary_int_hrms_setup
412 INDEX BY BINARY_INTEGER;
413
414 -- Post Install Steps Record
415 TYPE tech_summary_post_install IS RECORD
416 (legislation_code per_business_groups.legislation_code%type
417 ,applicaton_short_name fnd_application.application_short_name%type);
418
419 --Post Install Steps Table
420 TYPE post_install_tab IS TABLE OF
421 tech_summary_post_install
422 INDEX BY BINARY_INTEGER;
423
424 -- Get SQLS for various entities
425 FUNCTION get_business_grp_sql
426 (p_business_grp_tab in out nocopy per_ri_config_tech_summary.bg_tab)
427 return clob;
428
429
430 FUNCTION get_org_sql (p_org_ent_tab in out nocopy
431 per_ri_config_tech_summary.org_ent_tab
432 ,p_org_oc_tab in out nocopy
433 per_ri_config_tech_summary.org_oc_tab
434 ,p_org_le_tab in out nocopy
435 per_ri_config_tech_summary.org_le_tab)
436 return clob ;
437
438 FUNCTION get_org_class_sql (p_org_ent_class_tab in out nocopy
439 per_ri_config_tech_summary.org_ent_class_tab
440 ,p_org_oc_class_tab in out nocopy
441 per_ri_config_tech_summary.org_oc_class_tab
442 ,p_org_le_class_tab in out nocopy
443 per_ri_config_tech_summary.org_le_class_tab)
444 return clob ;
445
446 FUNCTION get_org_class_sql_for_pv ( p_org_ent_tab in per_ri_config_tech_summary.org_ent_tab
447 ,p_org_oc_tab in per_ri_config_tech_summary.org_oc_tab
448 ,p_org_le_tab in per_ri_config_tech_summary.org_le_tab
449 ,p_org_ent_class_tab in per_ri_config_tech_summary.org_ent_class_tab
450 ,p_org_oc_class_tab in per_ri_config_tech_summary.org_oc_class_tab
451 ,p_org_le_class_tab in per_ri_config_tech_summary.org_le_class_tab)
452 return clob;
453
454
455 FUNCTION get_locations_sql (p_location_tab in out nocopy
456 per_ri_config_tech_summary.location_tab)
457 return clob;
458
459 FUNCTION get_user_sql (p_user_tab in out nocopy per_ri_config_tech_summary.user_tab)
460
461 return clob;
462
463 FUNCTION get_resp_sql (
464 p_resp_tab in out nocopy per_ri_config_tech_summary.resp_tab
465 ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
466 ,p_hrms_misc_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
467 )
468 return clob;
469
470 FUNCTION get_profile_sql (
471 p_profile_tab in out nocopy per_ri_config_tech_summary.profile_tab,
472 p_profile_dpe_ent_tab in out nocopy per_ri_config_tech_summary.profile_dpe_ent_tab
473 )
474 return clob;
475
476 FUNCTION get_profile_apps_sql (
477 p_profile_apps_tab in out nocopy per_ri_config_tech_summary.profile_apps_tab
478 )
479 return clob;
480
481
482 FUNCTION get_profile_resp_sql (
486
483 p_profile_resp_tab in out nocopy per_ri_config_tech_summary.profile_resp_tab
484 )
485 return clob ;
487 FUNCTION get_keyflex_structure_sql
488 (
489 p_kf_job_tab in out nocopy per_ri_config_tech_summary.kf_job_tab,
490 p_kf_job_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_tab,
491 p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,
492 p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
493 p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
494 p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
495 p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
496 p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
497 p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,
498 p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,
499 p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab,
500 p_kf_cost_tab in out nocopy per_ri_config_tech_summary.kf_cost_tab,
501 p_kf_job_str_clob out nocopy clob,
502 p_kf_job_rv_str_clob out nocopy clob,
503 p_kf_job_no_rv_str_clob out nocopy clob,
504 p_kf_pos_str_clob out nocopy clob,
505 p_kf_pos_rv_str_clob out nocopy clob,
506 p_kf_pos_no_rv_str_clob out nocopy clob,
507 p_kf_grd_str_clob out nocopy clob,
508 p_kf_cmp_str_clob out nocopy clob,
509 p_kf_grp_str_clob out nocopy clob,
510 p_kf_cost_str_clob out nocopy clob
511 )
512 return clob ;
513
514 FUNCTION get_keyflex_segment_sql
515 (
516 p_kf_job_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_seg_tab,
517 p_kf_job_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_seg_tab,
518 p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
519 p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
520 p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
521 p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
522 p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
523 p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
524 p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
525 p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,
526 p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab,
527 p_kf_cost_seg_tab in out nocopy per_ri_config_tech_summary.kf_cost_seg_tab,
528 p_kf_job_seg_clob out nocopy clob,
529 p_kf_job_rv_seg_clob out nocopy clob,
530 p_kf_job_no_rv_seg_clob out nocopy clob,
531 p_kf_pos_seg_clob out nocopy clob,
532 p_kf_pos_rv_seg_clob out nocopy clob,
533 p_kf_pos_no_rv_seg_clob out nocopy clob,
534 p_kf_grd_seg_clob out nocopy clob,
535 p_kf_grd_rv_seg_clob out nocopy clob,
536 p_kf_grd_no_rv_seg_clob out nocopy clob,
537 p_kf_grp_seg_clob out nocopy clob,
538 p_kf_cmp_seg_clob out nocopy clob,
539 p_kf_cost_seg_clob out nocopy clob
540 )
541 return clob;
542
543 FUNCTION get_keyflex_str_seg_sql_for_pv
544 ( p_kf_job_tab in per_ri_config_tech_summary.kf_job_tab,
545 p_kf_job_rv_tab in per_ri_config_tech_summary.kf_job_rv_tab,
546 p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,
547 p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
548 p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
549 p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
550 p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
551 p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
552 p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
553 p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
554 p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
555 p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
556 p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
557 p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
558 p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
559 p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
560 p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
561 p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
562 p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
563 p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
564 p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
565 p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,
566 p_kf_cmp_seg_tab in per_ri_config_tech_summary.kf_cmp_seg_tab,
567 p_kf_cost_seg_tab in per_ri_config_tech_summary.kf_cost_seg_tab
568 ) return clob;
569
570 FUNCTION get_int_hrms_setup_sql (
571 p_int_hrms_setup_tab in out nocopy per_ri_config_tech_summary.int_hrms_setup_tab
572 )
573 return clob ;
574
575
576
577 FUNCTION get_security_profile_sql (
578 p_security_profile_tab in out nocopy per_ri_config_tech_summary.sg_tab
579 )
580 return clob ;
581
582 FUNCTION get_org_hierarchy_sql (
583 p_org_hierarchy_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_tab
584 )
585 return clob ;
586
587 FUNCTION get_org_hierarchy_ele_sql (
588 p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab
589 ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab
590 )
591 return clob ;
592
593 FUNCTION get_org_hier_ele_sql_for_pv (
594 p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab
595 ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab
596 )
597 return clob ;
598
599 FUNCTION get_post_install_sql (
600 p_post_install_tab in out nocopy per_ri_config_tech_summary.post_install_tab
601 )return clob ;
602
603
604 FUNCTION fetch_clob(p_in_clob IN CLOB,
605 p_row_tag IN VARCHAR2,
606 p_row_set_tag IN VARCHAR2)
607 return clob ;
608
609 FUNCTION form_xml(P_NODE_TYPE IN varchar2, -- Indicates the node type (i.e start_tag/end_tag/value)
610 P_NODE IN VARCHAR2, -- Indicates the node value
611 P_DATA IN VARCHAR2) -- Indicates the data value
612 return clob;
613
614 FUNCTION get_keyflex_str_seg_dat_for_pv
615 ( p_kf_structure_tab in per_ri_config_tech_summary.kf_structure_tab,
616 p_kf_segment_tab in per_ri_config_tech_summary.kf_segment_tab,
617 p_keyflex_name in varchar2
618 ) return clob;
619
620 END per_ri_config_tech_summary;
621