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
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
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
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:
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
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
369: ,app_gen_method per_business_groups.method_of_generation_apl_num%type
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
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
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
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
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