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 1519: l_positions_rv_name per_ri_config_information.config_information1%type;

1515:
1516: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1517: l_value_set_tab_count number(9) := 1;
1518:
1519: l_positions_rv_name per_ri_config_information.config_information1%type;
1520: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
1521:
1522: l_rv_positions_segment_type per_ri_config_information.config_information1%type;
1523: l_rv_positions_segment_name per_ri_config_information.config_information1%type;

Line 1520: l_positions_rv_name_orig per_ri_config_information.config_information1%type;

1516: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1517: l_value_set_tab_count number(9) := 1;
1518:
1519: l_positions_rv_name per_ri_config_information.config_information1%type;
1520: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
1521:
1522: l_rv_positions_segment_type per_ri_config_information.config_information1%type;
1523: l_rv_positions_segment_name per_ri_config_information.config_information1%type;
1524: l_positions_keyflex_number number(9);

Line 1522: l_rv_positions_segment_type per_ri_config_information.config_information1%type;

1518:
1519: l_positions_rv_name per_ri_config_information.config_information1%type;
1520: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
1521:
1522: l_rv_positions_segment_type per_ri_config_information.config_information1%type;
1523: l_rv_positions_segment_name per_ri_config_information.config_information1%type;
1524: l_positions_keyflex_number number(9);
1525: l_positions_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1526:

Line 1523: l_rv_positions_segment_name per_ri_config_information.config_information1%type;

1519: l_positions_rv_name per_ri_config_information.config_information1%type;
1520: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
1521:
1522: l_rv_positions_segment_type per_ri_config_information.config_information1%type;
1523: l_rv_positions_segment_name per_ri_config_information.config_information1%type;
1524: l_positions_keyflex_number number(9);
1525: l_positions_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1526:
1527: l_positions_segment_count number(9);

Line 1705: l_grade_rv_name per_ri_config_information.config_information1%type;

1701:
1702: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1703: l_value_set_tab_count number(9) := 1;
1704:
1705: l_grade_rv_name per_ri_config_information.config_information1%type;
1706: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
1707:
1708: l_rv_grade_segment_name per_ri_config_information.config_information1%type;
1709: l_rv_grade_segment_type per_ri_config_information.config_information1%type;

Line 1706: l_grade_rv_name_orig per_ri_config_information.config_information1%type;

1702: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1703: l_value_set_tab_count number(9) := 1;
1704:
1705: l_grade_rv_name per_ri_config_information.config_information1%type;
1706: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
1707:
1708: l_rv_grade_segment_name per_ri_config_information.config_information1%type;
1709: l_rv_grade_segment_type per_ri_config_information.config_information1%type;
1710: l_grades_keyflex_number number(9);

Line 1708: l_rv_grade_segment_name per_ri_config_information.config_information1%type;

1704:
1705: l_grade_rv_name per_ri_config_information.config_information1%type;
1706: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
1707:
1708: l_rv_grade_segment_name per_ri_config_information.config_information1%type;
1709: l_rv_grade_segment_type per_ri_config_information.config_information1%type;
1710: l_grades_keyflex_number number(9);
1711: l_grade_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1712:

Line 1709: l_rv_grade_segment_type per_ri_config_information.config_information1%type;

1705: l_grade_rv_name per_ri_config_information.config_information1%type;
1706: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
1707:
1708: l_rv_grade_segment_name per_ri_config_information.config_information1%type;
1709: l_rv_grade_segment_type per_ri_config_information.config_information1%type;
1710: l_grades_keyflex_number number(9);
1711: l_grade_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1712:
1713: l_grades_segment_count number(9);

Line 1884: l_configuration_code per_ri_config_information.configuration_code%type;

1880: l_value_set_tab_count number(9) := 1;
1881:
1882: l_proc varchar2(72) := g_package || 'create_global_grp_cmp_cost_kf';
1883: l_error_message varchar2(360);
1884: l_configuration_code per_ri_config_information.configuration_code%type;
1885: l_people_group_fk_number number(9);
1886: l_competence_fk_number number(9);
1887: l_cost_allocation_number number(9);
1888:

Line 1889: l_enterprise_short_name per_ri_config_information.configuration_code%type;

1885: l_people_group_fk_number number(9);
1886: l_competence_fk_number number(9);
1887: l_cost_allocation_number number(9);
1888:
1889: l_enterprise_short_name per_ri_config_information.configuration_code%type;
1890:
1891: l_grp_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1892: l_cmp_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
1893: l_cost_structures_code fnd_id_flex_structures.id_flex_structure_code%type;

Line 2339: l_configuration_code per_ri_config_information.configuration_code%type;

2335: ,p_kf_pos_seg_tab in out nocopy
2336: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2337:
2338: l_proc varchar2(72) := g_package || 'create_global_job_pos_kf';
2339: l_configuration_code per_ri_config_information.configuration_code%type;
2340: l_jobs_fk_number number(9);
2341: l_position_fk_number number(9);
2342:
2343: l_enterprise_short_name per_ri_config_information.configuration_code%type;

Line 2343: l_enterprise_short_name per_ri_config_information.configuration_code%type;

2339: l_configuration_code per_ri_config_information.configuration_code%type;
2340: l_jobs_fk_number number(9);
2341: l_position_fk_number number(9);
2342:
2343: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2344:
2345: l_job_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2346: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2347: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

Line 2347: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

2343: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2344:
2345: l_job_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2346: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2347: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2348:
2349: l_kf_job_tab per_ri_config_tech_summary.kf_job_tab;
2350: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2351: l_kf_job_count number(8) :=0;

Line 2929: l_configuration_code per_ri_config_information.configuration_code%type;

2925: ,p_kf_pos_seg_tab in out nocopy
2926: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2927:
2928: l_proc varchar2(72) := g_package || 'create_global_pos_kf';
2929: l_configuration_code per_ri_config_information.configuration_code%type;
2930: l_position_fk_number number(9);
2931:
2932: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2933:

Line 2932: l_enterprise_short_name per_ri_config_information.configuration_code%type;

2928: l_proc varchar2(72) := g_package || 'create_global_pos_kf';
2929: l_configuration_code per_ri_config_information.configuration_code%type;
2930: l_position_fk_number number(9);
2931:
2932: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2933:
2934: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2935: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2936: l_log_message varchar2(360);

Line 2935: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

2931:
2932: l_enterprise_short_name per_ri_config_information.configuration_code%type;
2933:
2934: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2935: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2936: l_log_message varchar2(360);
2937: l_error_message varchar2(360);
2938:
2939: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;

Line 3351: l_configuration_code per_ri_config_information.configuration_code%type;

3347: l_error_message varchar2(360);
3348: l_kf_grd_seg_tab per_ri_config_tech_summary.kf_grd_seg_tab;
3349: l_kf_grd_seg_count number(8) := 0;
3350:
3351: l_configuration_code per_ri_config_information.configuration_code%type;
3352: l_grade_number number(9);
3353:
3354: l_kf_grd_valueset_tab per_ri_config_tech_summary.valueset_tab;
3355: l_value_set_tab_count number(9) := 1;

Line 3357: l_enterprise_short_name per_ri_config_information.configuration_code%type;

3353:
3354: l_kf_grd_valueset_tab per_ri_config_tech_summary.valueset_tab;
3355: l_value_set_tab_count number(9) := 1;
3356:
3357: l_enterprise_short_name per_ri_config_information.configuration_code%type;
3358:
3359: l_grd_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
3360: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
3361:

Line 3360: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

3356:
3357: l_enterprise_short_name per_ri_config_information.configuration_code%type;
3358:
3359: l_grd_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
3360: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
3361:
3362: BEGIN
3363: hr_utility.set_location('Entering:'|| l_proc, 10);
3364:

Line 3772: l_country_code per_ri_config_information.config_information1%type;

3768: ,country_code) <> 'INT' ;
3769:
3770: l_proc varchar2(72) := g_package || 'create_hrms_responsibility';
3771: l_error_message varchar2(360);
3772: l_country_code per_ri_config_information.config_information1%type;
3773: l_product_name per_ri_config_information.config_information1%type;
3774: l_fnd_application_short_name varchar2(30);
3775:
3776: l_country_code_global per_ri_config_information.config_information1%type;

Line 3773: l_product_name per_ri_config_information.config_information1%type;

3769:
3770: l_proc varchar2(72) := g_package || 'create_hrms_responsibility';
3771: l_error_message varchar2(360);
3772: l_country_code per_ri_config_information.config_information1%type;
3773: l_product_name per_ri_config_information.config_information1%type;
3774: l_fnd_application_short_name varchar2(30);
3775:
3776: l_country_code_global per_ri_config_information.config_information1%type;
3777: l_responsibility_key varchar2(60);

Line 3776: l_country_code_global per_ri_config_information.config_information1%type;

3772: l_country_code per_ri_config_information.config_information1%type;
3773: l_product_name per_ri_config_information.config_information1%type;
3774: l_fnd_application_short_name varchar2(30);
3775:
3776: l_country_code_global per_ri_config_information.config_information1%type;
3777: l_responsibility_key varchar2(60);
3778: l_application_short_name per_ri_config_information.configuration_code%type;
3779: l_assign_responsibility varchar2(30);
3780: l_assign_global_responsibility boolean default FALSE;

Line 3778: l_application_short_name per_ri_config_information.configuration_code%type;

3774: l_fnd_application_short_name varchar2(30);
3775:
3776: l_country_code_global per_ri_config_information.config_information1%type;
3777: l_responsibility_key varchar2(60);
3778: l_application_short_name per_ri_config_information.configuration_code%type;
3779: l_assign_responsibility varchar2(30);
3780: l_assign_global_responsibility boolean default FALSE;
3781: l_assign_global_resp_key varchar2(60);
3782: l_assign_glb_resp_key_app_name varchar2(30);

Line 4135: l_product_name per_ri_config_information.config_information1%type;

4131: select product_name
4132: from per_ri_config_prod_selection_v
4133: where configuration_code = cp_configuration_code;
4134:
4135: l_product_name per_ri_config_information.config_information1%type;
4136:
4137: l_profile_apps_count number(8) := 0;
4138: l_proc varchar2(72) := g_package || 'create_application_level_resp';
4139: l_log_message varchar2(360);