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:
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
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:
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
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
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
372: ,currency_code per_business_groups.currency_code%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
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
372: ,currency_code per_business_groups.currency_code%type
373: ,fiscal_year_start date
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
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
372: ,currency_code per_business_groups.currency_code%type
373: ,fiscal_year_start date
374: ,min_work_age number(8)
367: ,short_name hr_all_organization_units.name%type
368: ,emp_gen_method per_business_groups.method_of_generation_emp_num%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
372: ,currency_code per_business_groups.currency_code%type
373: ,fiscal_year_start date
374: ,min_work_age number(8)
375: ,max_work_age number(8)
368: ,emp_gen_method per_business_groups.method_of_generation_emp_num%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
372: ,currency_code per_business_groups.currency_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
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
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
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);
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:
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
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
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;
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;
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