DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_RI_CONFIG_INFORMATION

Line 45: l_job_segment_name per_ri_config_information.config_information1%type;

41:
42: l_kf_job_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
43: l_value_set_tab_count number(9) := 1;
44:
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;

Line 46: l_job_segment_type per_ri_config_information.config_information1%type;

42: l_kf_job_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
43: l_value_set_tab_count number(9) := 1;
44:
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:

Line 47: l_industry_attribute per_ri_config_information.config_information1%type;

43: l_value_set_tab_count number(9) := 1;
44:
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;

Line 55: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

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);
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

Line 395: l_pos_segment_name per_ri_config_information.config_information1%type;

391:
392: l_kf_pos_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
393: l_value_set_tab_count number(9) := 1;
394:
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;

Line 396: l_pos_segment_type per_ri_config_information.config_information1%type;

392: l_kf_pos_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
393: l_value_set_tab_count number(9) := 1;
394:
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:

Line 397: l_industry_attribute per_ri_config_information.config_information1%type;

393: l_value_set_tab_count number(9) := 1;
394:
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;

Line 406: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

402: l_pos_segment_count 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);

Line 1029: l_grade_segment_name per_ri_config_information.config_information1%type;

1025:
1026: l_kf_grd_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1027: l_value_set_tab_count number(9) := 1;
1028:
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;

Line 1030: l_grade_segment_type per_ri_config_information.config_information1%type;

1026: l_kf_grd_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1027: l_value_set_tab_count number(9) := 1;
1028:
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:

Line 1031: l_industry_attribute per_ri_config_information.config_information1%type;

1027: l_value_set_tab_count number(9) := 1;
1028:
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;

Line 1039: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

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;
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

Line 1326: l_jobs_rv_name per_ri_config_information.config_information1%type;

1322:
1323: l_kf_job_rv_seg_count number(8) := 0;
1324: l_kf_job_rv_seg_tab per_ri_config_tech_summary.kf_job_rv_tab;
1325:
1326: l_jobs_rv_name per_ri_config_information.config_information1%type;
1327: l_jobs_rv_name_orig per_ri_config_information.config_information1%type;
1328:
1329: l_kf_job_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1330: l_value_set_tab_count number(9) := 1;

Line 1327: l_jobs_rv_name_orig per_ri_config_information.config_information1%type;

1323: l_kf_job_rv_seg_count number(8) := 0;
1324: l_kf_job_rv_seg_tab per_ri_config_tech_summary.kf_job_rv_tab;
1325:
1326: l_jobs_rv_name per_ri_config_information.config_information1%type;
1327: l_jobs_rv_name_orig per_ri_config_information.config_information1%type;
1328:
1329: l_kf_job_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1330: l_value_set_tab_count number(9) := 1;
1331:

Line 1332: l_rv_jobs_segment_type per_ri_config_information.config_information1%type;

1328:
1329: l_kf_job_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1330: l_value_set_tab_count number(9) := 1;
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:

Line 1333: l_rv_jobs_segment_name per_ri_config_information.config_information1%type;

1329: l_kf_job_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1330: l_value_set_tab_count number(9) := 1;
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);

Line 1539: l_positions_rv_name per_ri_config_information.config_information1%type;

1535:
1536: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1537: l_value_set_tab_count number(9) := 1;
1538:
1539: l_positions_rv_name per_ri_config_information.config_information1%type;
1540: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
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;

Line 1540: l_positions_rv_name_orig per_ri_config_information.config_information1%type;

1536: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1537: l_value_set_tab_count number(9) := 1;
1538:
1539: l_positions_rv_name per_ri_config_information.config_information1%type;
1540: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
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);

Line 1542: l_rv_positions_segment_type per_ri_config_information.config_information1%type;

1538:
1539: l_positions_rv_name per_ri_config_information.config_information1%type;
1540: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
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:

Line 1543: l_rv_positions_segment_name per_ri_config_information.config_information1%type;

1539: l_positions_rv_name per_ri_config_information.config_information1%type;
1540: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
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);

Line 1745: l_grade_rv_name per_ri_config_information.config_information1%type;

1741:
1742: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1743: l_value_set_tab_count number(9) := 1;
1744:
1745: l_grade_rv_name per_ri_config_information.config_information1%type;
1746: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
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;

Line 1746: l_grade_rv_name_orig per_ri_config_information.config_information1%type;

1742: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1743: l_value_set_tab_count number(9) := 1;
1744:
1745: l_grade_rv_name per_ri_config_information.config_information1%type;
1746: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
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);

Line 1748: l_rv_grade_segment_name per_ri_config_information.config_information1%type;

1744:
1745: l_grade_rv_name per_ri_config_information.config_information1%type;
1746: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
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:

Line 1749: l_rv_grade_segment_type per_ri_config_information.config_information1%type;

1745: l_grade_rv_name per_ri_config_information.config_information1%type;
1746: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
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);

Line 1944: l_configuration_code per_ri_config_information.configuration_code%type;

1940: l_value_set_tab_count number(9) := 1;
1941:
1942: l_proc varchar2(72) := g_package || 'create_global_grp_cmp_cost_kf';
1943: l_error_message varchar2(360);
1944: l_configuration_code per_ri_config_information.configuration_code%type;
1945: l_people_group_fk_number number(9);
1946: l_competence_fk_number number(9);
1947: l_cost_allocation_number number(9);
1948:

Line 1949: l_enterprise_short_name per_ri_config_information.configuration_code%type;

1945: l_people_group_fk_number number(9);
1946: l_competence_fk_number number(9);
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;

Line 2399: l_configuration_code per_ri_config_information.configuration_code%type;

2395: ,p_kf_pos_seg_tab in out nocopy
2396: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2397:
2398: l_proc varchar2(72) := g_package || 'create_global_job_pos_kf';
2399: l_configuration_code per_ri_config_information.configuration_code%type;
2400: l_jobs_fk_number number(9);
2401: l_position_fk_number number(9);
2402:
2403: l_enterprise_short_name per_ri_config_information.configuration_code%type;

Line 2403: l_enterprise_short_name per_ri_config_information.configuration_code%type;

2399: l_configuration_code per_ri_config_information.configuration_code%type;
2400: l_jobs_fk_number number(9);
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;

Line 2407: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

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;
2411: l_kf_job_count number(8) :=0;

Line 2989: l_configuration_code per_ri_config_information.configuration_code%type;

2985: ,p_kf_pos_seg_tab in out nocopy
2986: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2987:
2988: l_proc varchar2(72) := g_package || 'create_global_pos_kf';
2989: l_configuration_code per_ri_config_information.configuration_code%type;
2990: l_position_fk_number number(9);
2991:
2992: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2993:

Line 2992: l_enterprise_short_name per_ri_config_information.configuration_code%type;

2988: l_proc varchar2(72) := g_package || 'create_global_pos_kf';
2989: l_configuration_code per_ri_config_information.configuration_code%type;
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);

Line 2995: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

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:
2999: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;

Line 3411: l_configuration_code per_ri_config_information.configuration_code%type;

3407: l_error_message varchar2(360);
3408: l_kf_grd_seg_tab per_ri_config_tech_summary.kf_grd_seg_tab;
3409: l_kf_grd_seg_count number(8) := 0;
3410:
3411: l_configuration_code per_ri_config_information.configuration_code%type;
3412: l_grade_number number(9);
3413:
3414: l_kf_grd_valueset_tab per_ri_config_tech_summary.valueset_tab;
3415: l_value_set_tab_count number(9) := 1;

Line 3417: l_enterprise_short_name per_ri_config_information.configuration_code%type;

3413:
3414: l_kf_grd_valueset_tab per_ri_config_tech_summary.valueset_tab;
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:

Line 3420: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

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);
3424:

Line 3832: l_country_code per_ri_config_information.config_information1%type;

3828: ,country_code) <> 'INT' ;
3829:
3830: l_proc varchar2(72) := g_package || 'create_hrms_responsibility';
3831: l_error_message varchar2(360);
3832: l_country_code per_ri_config_information.config_information1%type;
3833: l_product_name per_ri_config_information.config_information1%type;
3834: l_fnd_application_short_name varchar2(30);
3835:
3836: l_country_code_global per_ri_config_information.config_information1%type;

Line 3833: l_product_name per_ri_config_information.config_information1%type;

3829:
3830: l_proc varchar2(72) := g_package || 'create_hrms_responsibility';
3831: l_error_message varchar2(360);
3832: l_country_code per_ri_config_information.config_information1%type;
3833: l_product_name per_ri_config_information.config_information1%type;
3834: l_fnd_application_short_name varchar2(30);
3835:
3836: l_country_code_global per_ri_config_information.config_information1%type;
3837: l_responsibility_key varchar2(60);

Line 3836: l_country_code_global per_ri_config_information.config_information1%type;

3832: l_country_code per_ri_config_information.config_information1%type;
3833: l_product_name per_ri_config_information.config_information1%type;
3834: l_fnd_application_short_name varchar2(30);
3835:
3836: l_country_code_global per_ri_config_information.config_information1%type;
3837: l_responsibility_key varchar2(60);
3838: l_application_short_name per_ri_config_information.configuration_code%type;
3839: l_assign_responsibility varchar2(30);
3840: l_assign_global_responsibility boolean default FALSE;

Line 3838: l_application_short_name per_ri_config_information.configuration_code%type;

3834: l_fnd_application_short_name varchar2(30);
3835:
3836: l_country_code_global per_ri_config_information.config_information1%type;
3837: l_responsibility_key varchar2(60);
3838: l_application_short_name per_ri_config_information.configuration_code%type;
3839: l_assign_responsibility varchar2(30);
3840: l_assign_global_responsibility boolean default FALSE;
3841: l_assign_global_resp_key varchar2(60);
3842: l_assign_glb_resp_key_app_name varchar2(30);

Line 4195: l_product_name per_ri_config_information.config_information1%type;

4191: select product_name
4192: from per_ri_config_prod_selection_v
4193: where configuration_code = cp_configuration_code;
4194:
4195: l_product_name per_ri_config_information.config_information1%type;
4196:
4197: l_profile_apps_count number(8) := 0;
4198: l_proc varchar2(72) := g_package || 'create_application_level_resp';
4199: l_log_message varchar2(360);