45: l_job_segment_name per_ri_config_information.config_information1%type;
46: l_job_segment_type per_ri_config_information.config_information1%type;
47: l_industry_attribute per_ri_config_information.config_information1%type;
48: l_jobs_keyflex_number number(9);
49: l_job_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
50:
51: l_valueset_name fnd_flex_value_sets.flex_value_set_name%type;
52: l_jobs_segment_count number(9);
53: l_jobs_segment_no number(9);
53: l_jobs_segment_no number(9);
54: l_jobs_segment_count_fixed number(9) := 0;
55: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
56:
57: l_global_job_structure_name fnd_id_flex_structures.id_flex_structure_code%type;
58:
59: BEGIN
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61:
395: l_pos_segment_name per_ri_config_information.config_information1%type;
396: l_pos_segment_type per_ri_config_information.config_information1%type;
397: l_industry_attribute per_ri_config_information.config_information1%type;
398: l_pos_keyflex_number number(9);
399: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
400:
401: l_valueset_name fnd_flex_value_sets.flex_value_set_name%type;
402: l_pos_segment_count number(9);
403: l_pos_segment_no number(9);
403: l_pos_segment_no number(9);
404: l_pos_segment_count_fixed number(9);
405: l_position_no_rv_no_seg_count number(9);
406: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
407: l_global_pos_structure_name fnd_id_flex_structures.id_flex_structure_code%type;
408:
409: BEGIN
410: hr_utility.set_location('Entering:'|| l_proc, 10);
411:
1029: l_grade_segment_name per_ri_config_information.config_information1%type;
1030: l_grade_segment_type per_ri_config_information.config_information1%type;
1031: l_industry_attribute per_ri_config_information.config_information1%type;
1032: l_grade_keyflex_number number(9);
1033: l_grade_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1034:
1035: l_grade_segment_count number(9) := 0;
1036: l_grade_segment_no number(9) := 0;
1037: l_grade_segment_count_fixed number(9) := 0;
1037: l_grade_segment_count_fixed number(9) := 0;
1038:
1039: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
1040:
1041: l_global_grd_structure_name fnd_id_flex_structures.id_flex_structure_code%type;
1042:
1043: BEGIN
1044:
1045: hr_utility.set_location('Entering:'|| l_proc, 10);
1331:
1332: l_rv_jobs_segment_type per_ri_config_information.config_information1%type;
1333: l_rv_jobs_segment_name per_ri_config_information.config_information1%type;
1334: l_jobs_keyflex_number number(9);
1335: l_jobs_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1336:
1337: l_jobs_segment_count number(9);
1338: l_jobs_segment_no number(9);
1339:
1541:
1542: l_rv_positions_segment_type per_ri_config_information.config_information1%type;
1543: l_rv_positions_segment_name per_ri_config_information.config_information1%type;
1544: l_positions_keyflex_number number(9);
1545: l_positions_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1546:
1547: l_positions_segment_count number(9);
1548: l_positions_segment_no number(9);
1549:
1747:
1748: l_rv_grade_segment_name per_ri_config_information.config_information1%type;
1749: l_rv_grade_segment_type per_ri_config_information.config_information1%type;
1750: l_grades_keyflex_number number(9);
1751: l_grade_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1752:
1753: l_grades_segment_count number(9);
1754: l_grades_segment_no number(9);
1755:
1947: l_cost_allocation_number number(9);
1948:
1949: l_enterprise_short_name per_ri_config_information.configuration_code%type;
1950:
1951: l_grp_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1952: l_cmp_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1953: l_cost_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1954:
1955: l_kf_grp_count number(8) := 0;
1948:
1949: l_enterprise_short_name per_ri_config_information.configuration_code%type;
1950:
1951: l_grp_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1952: l_cmp_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1953: l_cost_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1954:
1955: l_kf_grp_count number(8) := 0;
1956: l_kf_cmp_count number(8) := 0;
1949: l_enterprise_short_name per_ri_config_information.configuration_code%type;
1950:
1951: l_grp_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1952: l_cmp_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1953: l_cost_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1954:
1955: l_kf_grp_count number(8) := 0;
1956: l_kf_cmp_count number(8) := 0;
1957: l_kf_cost_count number(8) := 0;
2401: l_position_fk_number number(9);
2402:
2403: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2404:
2405: l_job_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2406: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2407: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2408:
2409: l_kf_job_tab per_ri_config_tech_summary.kf_job_tab;
2402:
2403: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2404:
2405: l_job_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2406: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2407: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2408:
2409: l_kf_job_tab per_ri_config_tech_summary.kf_job_tab;
2410: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2990: l_position_fk_number number(9);
2991:
2992: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2993:
2994: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2995: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2996: l_log_message varchar2(360);
2997: l_error_message varchar2(360);
2998:
3415: l_value_set_tab_count number(9) := 1;
3416:
3417: l_enterprise_short_name per_ri_config_information.configuration_code%type;
3418:
3419: l_grd_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
3420: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
3421:
3422: BEGIN
3423: hr_utility.set_location('Entering:'|| l_proc, 10);