eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_RI_CONFIG_MAIN

Line 31: and industry_attribute = per_ri_config_main.g_global_fed_job_non_fed_att

27: industry_attribute,
28: CONFIG_SEQUENCE
29: from per_ri_config_job_kf_seg_v
30: where configuration_code = cp_configuration_code
31: and industry_attribute = per_ri_config_main.g_global_fed_job_non_fed_att
32: order by CONFIG_SEQUENCE;
33:
34: l_proc varchar2(72) := g_package || 'create_jobs_no_rv_keyflex';
35: l_log_message varchar2(360);

Line 63: (per_ri_config_main.g_global_job_structure_name);

59: BEGIN
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61:
62: l_global_job_structure_name := per_ri_config_utilities.return_config_entity_name
63: (per_ri_config_main.g_global_job_structure_name);
64: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
65: (p_configuration_code => p_configuration_code);
66:
67: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);

Line 77: || per_ri_config_main.g_description_suffix_string);

73: ,p_flex_code => 'JOB'
74: ,p_structure_code => l_global_job_structure_name
75: ,p_structure_title => l_global_job_structure_name
76: ,p_description => l_global_job_structure_name
77: || per_ri_config_main.g_description_suffix_string);
78:
79: else
80: p_kf_job_no_rv_tab(l_kf_job_no_rv_count).appl_short_name := 'PER';
81: p_kf_job_no_rv_tab(l_kf_job_no_rv_count).flex_code := 'JOB';

Line 85: || per_ri_config_main.g_description_suffix_string;

81: p_kf_job_no_rv_tab(l_kf_job_no_rv_count).flex_code := 'JOB';
82: p_kf_job_no_rv_tab(l_kf_job_no_rv_count).structure_code := l_global_job_structure_name;
83: p_kf_job_no_rv_tab(l_kf_job_no_rv_count).structure_title := l_global_job_structure_name;
84: p_kf_job_no_rv_tab(l_kf_job_no_rv_count).description := l_global_job_structure_name
85: || per_ri_config_main.g_description_suffix_string;
86: l_kf_job_no_rv_count := l_kf_job_no_rv_count + 1 ;
87: end if;
88:
89: hr_utility.set_location(l_proc, 30);

Line 248: l_jobs_segment_count_fixed := per_ri_config_main.g_global_fed_job_seg_count;

244:
245: --
246: -- one segment is always defined for fedral
247: --
248: l_jobs_segment_count_fixed := per_ri_config_main.g_global_fed_job_seg_count;
249: l_jobs_segment_count := 0;
250: LOOP
251: fetch csr_config_job_no_rv into l_job_segment_name
252: ,l_job_segment_type

Line 258: if l_industry_attribute = per_ri_config_main.g_global_fed_job_non_fed_att then

254: ,l_jobs_segment_no;
255: exit when csr_config_job_no_rv%NOTFOUND;
256: hr_utility.trace('l_jobs_segment_count = ' || to_char(l_jobs_segment_count));
257:
258: if l_industry_attribute = per_ri_config_main.g_global_fed_job_non_fed_att then
259:
260: l_jobs_segment_count := l_jobs_segment_count_fixed + csr_config_job_no_rv%ROWCOUNT;
261:
262:

Line 374: and industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att

370: industry_attribute,
371: CONFIG_SEQUENCE
372: from per_ri_config_pos_kf_seg_v
373: where configuration_code = cp_configuration_code
374: and industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att
375: order by CONFIG_SEQUENCE;
376:
377: cursor csr_config_position_no_rv_cnt (cp_configuration_code in varchar2) IS
378: select count(*)

Line 381: and industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att;

377: cursor csr_config_position_no_rv_cnt (cp_configuration_code in varchar2) IS
378: select count(*)
379: from per_ri_config_pos_kf_seg_v
380: where configuration_code = cp_configuration_code
381: and industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att;
382:
383: l_proc varchar2(72) := g_package || 'create_positions_no_rv_keyflex';
384: l_log_message varchar2(360);
385: l_error_message varchar2(360);

Line 413: (per_ri_config_main.g_global_pos_structure_name);

409: BEGIN
410: hr_utility.set_location('Entering:'|| l_proc, 10);
411:
412: l_global_pos_structure_name := per_ri_config_utilities.return_config_entity_name
413: (per_ri_config_main.g_global_pos_structure_name);
414:
415: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
416: (p_configuration_code => p_configuration_code);
417:

Line 428: || per_ri_config_main.g_description_suffix_string);

424: ,p_flex_code => 'POS'
425: ,p_structure_code => l_global_pos_structure_name
426: ,p_structure_title => l_global_pos_structure_name
427: ,p_description => l_global_pos_structure_name
428: || per_ri_config_main.g_description_suffix_string);
429: else
430: p_kf_pos_no_rv_tab(l_kf_pos_no_rv_count).appl_short_name := 'PER';
431: p_kf_pos_no_rv_tab(l_kf_pos_no_rv_count).flex_code := 'POS';
432: p_kf_pos_no_rv_tab(l_kf_pos_no_rv_count).structure_code := l_global_pos_structure_name;

Line 435: || per_ri_config_main.g_description_suffix_string;

431: p_kf_pos_no_rv_tab(l_kf_pos_no_rv_count).flex_code := 'POS';
432: p_kf_pos_no_rv_tab(l_kf_pos_no_rv_count).structure_code := l_global_pos_structure_name;
433: p_kf_pos_no_rv_tab(l_kf_pos_no_rv_count).structure_title := l_global_pos_structure_name;
434: p_kf_pos_no_rv_tab(l_kf_pos_no_rv_count).description := l_global_pos_structure_name
435: || per_ri_config_main.g_description_suffix_string;
436: l_kf_pos_no_rv_count := l_kf_pos_no_rv_count + 1 ;
437: end if;
438:
439:

Line 801: l_pos_segment_count_fixed := per_ri_config_main.g_global_fed_pos_seg_count;

797: --
798: -- four segment is always defined for fedral
799: --
800:
801: l_pos_segment_count_fixed := per_ri_config_main.g_global_fed_pos_seg_count;
802: l_pos_segment_count := 0;
803: LOOP
804: fetch csr_config_position_no_rv into l_pos_segment_name
805: ,l_pos_segment_type

Line 811: if l_industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att then

807: ,l_pos_segment_no;
808: exit when csr_config_position_no_rv%NOTFOUND;
809: hr_utility.trace('l_pos_segment_count = ' || to_char(l_pos_segment_count));
810:
811: if l_industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att then
812:
813: l_pos_segment_count := l_pos_segment_count_fixed + csr_config_position_no_rv%ROWCOUNT;
814:
815:

Line 967: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || per_ri_config_main.g_global_pos_structure_name;

963: := l_kf_pos_no_rv_valueset_tab(l_value_set_tab_count).max_value;
964: l_kf_pos_no_rv_seg_count := l_kf_pos_no_rv_seg_count + 1 ;
965: end if;
966:
967: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || per_ri_config_main.g_global_pos_structure_name;
968: per_ri_config_utilities.write_log(p_message => l_log_message);
969: --
970: -- freeze and compile this flexfield
971: --

Line 1014: and industry_attribute = per_ri_config_main.g_global_fed_grd_non_fed_att

1010: industry_attribute,
1011: CONFIG_SEQUENCE
1012: from per_ri_config_grade_kf_seg_v
1013: where configuration_code = cp_configuration_code
1014: and industry_attribute = per_ri_config_main.g_global_fed_grd_non_fed_att
1015: order by CONFIG_SEQUENCE;
1016:
1017: l_proc varchar2(72) := g_package || 'create_grades_no_rv_keyflex';
1018: l_log_message varchar2(360);

Line 1052: (per_ri_config_main.g_global_grd_structure_name);

1048: (p_configuration_code => p_configuration_code);
1049: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);
1050:
1051: l_global_grd_structure_name := per_ri_config_utilities.return_config_entity_name
1052: (per_ri_config_main.g_global_grd_structure_name);
1053: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
1054: hr_utility.set_location(l_proc, 20);
1055: -- Create Global Grades Key flex
1056: if NOT (p_technical_summary_mode) then

Line 1063: || per_ri_config_main.g_description_suffix_string);

1059: ,p_flex_code => 'GRD'
1060: ,p_structure_code => l_global_grd_structure_name
1061: ,p_structure_title => l_global_grd_structure_name
1062: ,p_description => l_global_grd_structure_name
1063: || per_ri_config_main.g_description_suffix_string);
1064: else
1065: p_kf_grd_no_rv_tab(l_kf_grd_no_rv_count).appl_short_name := 'PER';
1066: p_kf_grd_no_rv_tab(l_kf_grd_no_rv_count).flex_code := 'GRD';
1067: p_kf_grd_no_rv_tab(l_kf_grd_no_rv_count).structure_code := l_global_grd_structure_name;

Line 1070: || per_ri_config_main.g_description_suffix_string;

1066: p_kf_grd_no_rv_tab(l_kf_grd_no_rv_count).flex_code := 'GRD';
1067: p_kf_grd_no_rv_tab(l_kf_grd_no_rv_count).structure_code := l_global_grd_structure_name;
1068: p_kf_grd_no_rv_tab(l_kf_grd_no_rv_count).structure_title := l_global_grd_structure_name;
1069: p_kf_grd_no_rv_tab(l_kf_grd_no_rv_count).description := l_global_grd_structure_name
1070: || per_ri_config_main.g_description_suffix_string;
1071: l_kf_grd_no_rv_count := l_kf_grd_no_rv_count + 1 ;
1072: end if;
1073:
1074:

Line 1178: l_grade_segment_count_fixed := per_ri_config_main.g_global_fed_grd_seg_count;

1174:
1175: open csr_config_grade_no_rv(p_configuration_code);
1176:
1177: -- some segments (2 for now) are always defined for fedral
1178: l_grade_segment_count_fixed := per_ri_config_main.g_global_fed_grd_seg_count;
1179: l_grade_segment_count := 0;
1180: LOOP
1181: fetch csr_config_grade_no_rv into l_grade_segment_name
1182: ,l_grade_segment_type

Line 1188: hr_utility.trace('p_structure_code = ' || per_ri_config_main.g_global_fed_grd_struct_name);

1184: ,l_grade_segment_no;
1185:
1186: exit when csr_config_grade_no_rv%NOTFOUND;
1187: hr_utility.trace('l_grade_segment_count = ' || to_char(l_grade_segment_count));
1188: hr_utility.trace('p_structure_code = ' || per_ri_config_main.g_global_fed_grd_struct_name);
1189:
1190: if l_industry_attribute = per_ri_config_main.g_global_fed_grd_non_fed_att then
1191:
1192: l_grade_segment_count := l_grade_segment_count_fixed + csr_config_grade_no_rv%ROWCOUNT;

Line 1190: if l_industry_attribute = per_ri_config_main.g_global_fed_grd_non_fed_att then

1186: exit when csr_config_grade_no_rv%NOTFOUND;
1187: hr_utility.trace('l_grade_segment_count = ' || to_char(l_grade_segment_count));
1188: hr_utility.trace('p_structure_code = ' || per_ri_config_main.g_global_fed_grd_struct_name);
1189:
1190: if l_industry_attribute = per_ri_config_main.g_global_fed_grd_non_fed_att then
1191:
1192: l_grade_segment_count := l_grade_segment_count_fixed + csr_config_grade_no_rv%ROWCOUNT;
1193:
1194:

Line 1202: ,p_structure_code => per_ri_config_main.g_global_fed_grd_struct_name

1198: if NOT (p_technical_summary_mode) then
1199: per_ri_config_utilities.create_flex_segments
1200: (p_appl_short_Name => 'PER'
1201: ,p_flex_code => 'GRD'
1202: ,p_structure_code => per_ri_config_main.g_global_fed_grd_struct_name
1203: ,p_segment_name => l_grade_segment_name
1204: ,p_column_name => 'SEGMENT' || l_grade_segment_count
1205: ,p_segment_number => l_grade_segment_no
1206: ,p_value_set => null

Line 1213: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).structure_code := per_ri_config_main.g_global_fed_grd_struct_name;

1209: ,p_window_prompt => l_grade_segment_name);
1210: else
1211: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).appl_short_name := 'PER';
1212: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).flex_code := 'GRD';
1213: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).structure_code := per_ri_config_main.g_global_fed_grd_struct_name;
1214: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).segment_name := l_grade_segment_name;
1215: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).column_name := 'SEGMENT' || l_grade_segment_count;
1216: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).segment_number := l_grade_segment_no;
1217: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).value_set := null;

Line 1225: ,p_structure_code => per_ri_config_main.g_global_fed_grd_struct_name

1221:
1222: --create technical summary data for valueset
1223: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1224: ,p_valueset_type => l_grade_segment_type
1225: ,p_structure_code => per_ri_config_main.g_global_fed_grd_struct_name
1226: ,p_segment_name => l_grade_segment_name
1227: ,p_segment_number => l_grade_segment_no
1228: ,p_valueset_tab => l_kf_grd_no_rv_valueset_tab);
1229:

Line 1269: ,p_structure_code => per_ri_config_main.g_global_fed_grd_struct_name);

1265: if NOT (p_technical_summary_mode) then
1266: per_ri_config_utilities.freeze_and_compile_flexfield
1267: (p_appl_short_Name => 'PER'
1268: ,p_flex_code => 'GRD'
1269: ,p_structure_code => per_ri_config_main.g_global_fed_grd_struct_name);
1270: end if;
1271: close csr_config_grade_no_rv;
1272: end if;
1273:

Line 1374: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string

1370: if NOT (p_technical_summary_mode) then
1371: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield
1372: (p_appl_short_Name => 'PER'
1373: ,p_flex_code => 'JOB'
1374: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1375: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1376: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1377: || per_ri_config_main.g_description_suffix_string);
1378: else

Line 1375: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string

1371: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield
1372: (p_appl_short_Name => 'PER'
1373: ,p_flex_code => 'JOB'
1374: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1375: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1376: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1377: || per_ri_config_main.g_description_suffix_string);
1378: else
1379: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';

Line 1376: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string

1372: (p_appl_short_Name => 'PER'
1373: ,p_flex_code => 'JOB'
1374: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1375: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1376: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1377: || per_ri_config_main.g_description_suffix_string);
1378: else
1379: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1380: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';

Line 1377: || per_ri_config_main.g_description_suffix_string);

1373: ,p_flex_code => 'JOB'
1374: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1375: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1376: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1377: || per_ri_config_main.g_description_suffix_string);
1378: else
1379: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1380: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1381: p_kf_job_rv_tab(l_kf_job_rv_count).structure_code := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;

Line 1381: p_kf_job_rv_tab(l_kf_job_rv_count).structure_code := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;

1377: || per_ri_config_main.g_description_suffix_string);
1378: else
1379: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1380: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1381: p_kf_job_rv_tab(l_kf_job_rv_count).structure_code := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;
1382: p_kf_job_rv_tab(l_kf_job_rv_count).structure_title := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;
1383: p_kf_job_rv_tab(l_kf_job_rv_count).description := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1384: || per_ri_config_main.g_description_suffix_string;
1385: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;

Line 1382: p_kf_job_rv_tab(l_kf_job_rv_count).structure_title := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;

1378: else
1379: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1380: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1381: p_kf_job_rv_tab(l_kf_job_rv_count).structure_code := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;
1382: p_kf_job_rv_tab(l_kf_job_rv_count).structure_title := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;
1383: p_kf_job_rv_tab(l_kf_job_rv_count).description := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1384: || per_ri_config_main.g_description_suffix_string;
1385: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;
1386: end if;

Line 1383: p_kf_job_rv_tab(l_kf_job_rv_count).description := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string

1379: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1380: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1381: p_kf_job_rv_tab(l_kf_job_rv_count).structure_code := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;
1382: p_kf_job_rv_tab(l_kf_job_rv_count).structure_title := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;
1383: p_kf_job_rv_tab(l_kf_job_rv_count).description := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1384: || per_ri_config_main.g_description_suffix_string;
1385: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;
1386: end if;
1387:

Line 1384: || per_ri_config_main.g_description_suffix_string;

1380: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1381: p_kf_job_rv_tab(l_kf_job_rv_count).structure_code := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;
1382: p_kf_job_rv_tab(l_kf_job_rv_count).structure_title := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string;
1383: p_kf_job_rv_tab(l_kf_job_rv_count).description := l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1384: || per_ri_config_main.g_description_suffix_string;
1385: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;
1386: end if;
1387:
1388: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name

Line 1389: || per_ri_config_main.g_job_rv_struct_def_string );

1385: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;
1386: end if;
1387:
1388: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name
1389: || per_ri_config_main.g_job_rv_struct_def_string );
1390: hr_utility.trace('Created Jobs RV Keyflex ' || l_jobs_rv_name
1391: || per_ri_config_main.g_job_rv_struct_def_string);
1392:
1393: open csr_config_jobs_rv_seg(p_configuration_code

Line 1391: || per_ri_config_main.g_job_rv_struct_def_string);

1387:
1388: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name
1389: || per_ri_config_main.g_job_rv_struct_def_string );
1390: hr_utility.trace('Created Jobs RV Keyflex ' || l_jobs_rv_name
1391: || per_ri_config_main.g_job_rv_struct_def_string);
1392:
1393: open csr_config_jobs_rv_seg(p_configuration_code
1394: ,l_jobs_rv_name_orig);
1395: l_jobs_segment_count := 0;

Line 1409: || per_ri_config_main.g_job_rv_struct_def_string

1405: per_ri_config_utilities.create_flex_segments
1406: (p_appl_short_Name => 'PER'
1407: ,p_flex_code => 'JOB'
1408: ,p_structure_code => l_jobs_rv_name
1409: || per_ri_config_main.g_job_rv_struct_def_string
1410: ,p_segment_name => l_rv_jobs_segment_name
1411: ,p_column_name => 'SEGMENT' || l_jobs_segment_count
1412: ,p_segment_number => l_jobs_segment_no --l_jobs_segment_count
1413: ,p_value_set => null

Line 1421: || per_ri_config_main.g_job_rv_struct_def_string;

1417: else
1418: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).appl_short_name := 'PER';
1419: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).flex_code := 'JOB';
1420: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).structure_code := l_jobs_rv_name
1421: || per_ri_config_main.g_job_rv_struct_def_string;
1422: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).segment_name := l_rv_jobs_segment_name;
1423: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).column_name := 'SEGMENT' || l_jobs_segment_count;
1424: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).segment_number := l_jobs_segment_no;
1425: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).value_set := null;

Line 1434: || per_ri_config_main.g_job_rv_struct_def_string

1430: --create technical summary data for valueset
1431: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1432: ,p_valueset_type => l_rv_jobs_segment_type
1433: ,p_structure_code => l_jobs_rv_name
1434: || per_ri_config_main.g_job_rv_struct_def_string
1435: ,p_segment_name => l_jobs_rv_name
1436: ,p_segment_number => l_jobs_segment_no
1437: ,p_valueset_tab => l_kf_job_rv_valueset_tab);
1438:

Line 1477: || per_ri_config_main.g_job_rv_struct_def_string);

1473: per_ri_config_utilities.freeze_and_compile_flexfield
1474: (p_appl_short_Name => 'PER'
1475: ,p_flex_code => 'JOB'
1476: ,p_structure_code => l_jobs_rv_name
1477: || per_ri_config_main.g_job_rv_struct_def_string);
1478: end if;
1479: close csr_config_jobs_rv_seg;
1480: END IF;
1481: END LOOP;

Line 1583: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string

1579: if NOT (p_technical_summary_mode) then
1580: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield
1581: (p_appl_short_Name => 'PER'
1582: ,p_flex_code => 'POS'
1583: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1584: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1585: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1586: || per_ri_config_main.g_description_suffix_string);
1587:

Line 1584: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string

1580: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield
1581: (p_appl_short_Name => 'PER'
1582: ,p_flex_code => 'POS'
1583: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1584: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1585: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1586: || per_ri_config_main.g_description_suffix_string);
1587:
1588: else

Line 1585: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string

1581: (p_appl_short_Name => 'PER'
1582: ,p_flex_code => 'POS'
1583: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1584: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1585: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1586: || per_ri_config_main.g_description_suffix_string);
1587:
1588: else
1589: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';

Line 1586: || per_ri_config_main.g_description_suffix_string);

1582: ,p_flex_code => 'POS'
1583: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1584: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1585: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1586: || per_ri_config_main.g_description_suffix_string);
1587:
1588: else
1589: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';
1590: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';

Line 1591: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_code := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;

1587:
1588: else
1589: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';
1590: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';
1591: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_code := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;
1592: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_title := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;
1593: p_kf_pos_rv_tab(l_kf_pos_rv_count).description := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1594: || per_ri_config_main.g_description_suffix_string;
1595: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;

Line 1592: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_title := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;

1588: else
1589: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';
1590: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';
1591: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_code := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;
1592: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_title := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;
1593: p_kf_pos_rv_tab(l_kf_pos_rv_count).description := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1594: || per_ri_config_main.g_description_suffix_string;
1595: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1596: end if;

Line 1593: p_kf_pos_rv_tab(l_kf_pos_rv_count).description := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string

1589: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';
1590: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';
1591: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_code := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;
1592: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_title := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;
1593: p_kf_pos_rv_tab(l_kf_pos_rv_count).description := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1594: || per_ri_config_main.g_description_suffix_string;
1595: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1596: end if;
1597: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name

Line 1594: || per_ri_config_main.g_description_suffix_string;

1590: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';
1591: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_code := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;
1592: p_kf_pos_rv_tab(l_kf_pos_rv_count).structure_title := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string;
1593: p_kf_pos_rv_tab(l_kf_pos_rv_count).description := l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1594: || per_ri_config_main.g_description_suffix_string;
1595: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1596: end if;
1597: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name
1598: || per_ri_config_main.g_pos_rv_struct_def_string );

Line 1598: || per_ri_config_main.g_pos_rv_struct_def_string );

1594: || per_ri_config_main.g_description_suffix_string;
1595: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1596: end if;
1597: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name
1598: || per_ri_config_main.g_pos_rv_struct_def_string );
1599: hr_utility.trace('Created Positions RV Keyflex ' || l_positions_rv_name
1600: || per_ri_config_main.g_pos_rv_struct_def_string);
1601:
1602: open csr_config_positions_rv_seg(p_configuration_code

Line 1600: || per_ri_config_main.g_pos_rv_struct_def_string);

1596: end if;
1597: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name
1598: || per_ri_config_main.g_pos_rv_struct_def_string );
1599: hr_utility.trace('Created Positions RV Keyflex ' || l_positions_rv_name
1600: || per_ri_config_main.g_pos_rv_struct_def_string);
1601:
1602: open csr_config_positions_rv_seg(p_configuration_code
1603: ,l_positions_rv_name_orig);
1604: l_positions_segment_count := 0;

Line 1618: || per_ri_config_main.g_pos_rv_struct_def_string

1614: per_ri_config_utilities.create_flex_segments
1615: (p_appl_short_Name => 'PER'
1616: ,p_flex_code => 'POS'
1617: ,p_structure_code => l_positions_rv_name
1618: || per_ri_config_main.g_pos_rv_struct_def_string
1619: ,p_segment_name => l_rv_positions_segment_name
1620: ,p_column_name => 'SEGMENT' || l_positions_segment_count
1621: ,p_segment_number => l_positions_segment_no
1622: ,p_value_set => null

Line 1631: || per_ri_config_main.g_pos_rv_struct_def_string;

1627: else
1628: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).appl_short_name := 'PER';
1629: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).flex_code := 'POS';
1630: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).structure_code := l_positions_rv_name
1631: || per_ri_config_main.g_pos_rv_struct_def_string;
1632: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).segment_name := l_rv_positions_segment_name;
1633: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).column_name := 'SEGMENT' || l_positions_segment_count;
1634: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).segment_number := l_positions_segment_no;
1635: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).value_set := null;

Line 1644: || per_ri_config_main.g_pos_rv_struct_def_string

1640: --create technical summary data for valueset
1641: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1642: ,p_valueset_type => l_rv_positions_segment_type
1643: ,p_structure_code => l_positions_rv_name
1644: || per_ri_config_main.g_pos_rv_struct_def_string
1645: ,p_segment_name => l_rv_positions_segment_name
1646: ,p_segment_number => l_positions_segment_no
1647: ,p_valueset_tab => l_kf_pos_rv_valueset_tab);
1648:

Line 1686: || per_ri_config_main.g_pos_rv_struct_def_string);

1682: per_ri_config_utilities.freeze_and_compile_flexfield
1683: (p_appl_short_Name => 'PER'
1684: ,p_flex_code => 'POS'
1685: ,p_structure_code => l_positions_rv_name
1686: || per_ri_config_main.g_pos_rv_struct_def_string);
1687: end if;
1688: close csr_config_positions_rv_seg;
1689: END IF;
1690: END LOOP;

Line 1790: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string

1786: l_grades_keyflex_number :=
1787: per_ri_config_utilities.create_key_flexfield
1788: (p_appl_short_Name => 'PER'
1789: ,p_flex_code => 'GRD'
1790: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1791: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1792: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1793: || per_ri_config_main.g_description_suffix_string);
1794:

Line 1791: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string

1787: per_ri_config_utilities.create_key_flexfield
1788: (p_appl_short_Name => 'PER'
1789: ,p_flex_code => 'GRD'
1790: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1791: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1792: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1793: || per_ri_config_main.g_description_suffix_string);
1794:
1795: else

Line 1792: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string

1788: (p_appl_short_Name => 'PER'
1789: ,p_flex_code => 'GRD'
1790: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1791: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1792: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1793: || per_ri_config_main.g_description_suffix_string);
1794:
1795: else
1796: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';

Line 1793: || per_ri_config_main.g_description_suffix_string);

1789: ,p_flex_code => 'GRD'
1790: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1791: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1792: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1793: || per_ri_config_main.g_description_suffix_string);
1794:
1795: else
1796: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';
1797: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';

Line 1798: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_code := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;

1794:
1795: else
1796: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';
1797: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';
1798: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_code := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;
1799: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_title := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;
1800: p_kf_grd_rv_tab(l_kf_grd_rv_count).description := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1801: || per_ri_config_main.g_description_suffix_string;
1802: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;

Line 1799: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_title := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;

1795: else
1796: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';
1797: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';
1798: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_code := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;
1799: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_title := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;
1800: p_kf_grd_rv_tab(l_kf_grd_rv_count).description := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1801: || per_ri_config_main.g_description_suffix_string;
1802: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1803: end if;

Line 1800: p_kf_grd_rv_tab(l_kf_grd_rv_count).description := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string

1796: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';
1797: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';
1798: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_code := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;
1799: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_title := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;
1800: p_kf_grd_rv_tab(l_kf_grd_rv_count).description := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1801: || per_ri_config_main.g_description_suffix_string;
1802: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1803: end if;
1804: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '

Line 1801: || per_ri_config_main.g_description_suffix_string;

1797: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';
1798: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_code := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;
1799: p_kf_grd_rv_tab(l_kf_grd_rv_count).structure_title := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string;
1800: p_kf_grd_rv_tab(l_kf_grd_rv_count).description := l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1801: || per_ri_config_main.g_description_suffix_string;
1802: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1803: end if;
1804: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '
1805: || per_ri_config_main.g_grd_rv_struct_def_string );

Line 1805: || per_ri_config_main.g_grd_rv_struct_def_string );

1801: || per_ri_config_main.g_description_suffix_string;
1802: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1803: end if;
1804: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '
1805: || per_ri_config_main.g_grd_rv_struct_def_string );
1806: hr_utility.trace('Created Grades RV Keyflex ' || per_ri_config_main.g_grd_rv_struct_def_string);
1807:
1808: open csr_config_grade_rv_seg(p_configuration_code
1809: ,l_grade_rv_name_orig);

Line 1806: hr_utility.trace('Created Grades RV Keyflex ' || per_ri_config_main.g_grd_rv_struct_def_string);

1802: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1803: end if;
1804: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '
1805: || per_ri_config_main.g_grd_rv_struct_def_string );
1806: hr_utility.trace('Created Grades RV Keyflex ' || per_ri_config_main.g_grd_rv_struct_def_string);
1807:
1808: open csr_config_grade_rv_seg(p_configuration_code
1809: ,l_grade_rv_name_orig);
1810: l_grades_segment_count := 0;

Line 1823: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string

1819: if NOT (p_technical_summary_mode) then
1820: per_ri_config_utilities.create_flex_segments
1821: (p_appl_short_Name => 'PER'
1822: ,p_flex_code => 'GRD'
1823: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1824: ,p_segment_name => l_rv_grade_segment_name
1825: ,p_column_name => 'SEGMENT' || l_grades_segment_count
1826: ,p_segment_number => l_grades_segment_no
1827: ,p_value_set => null

Line 1835: || per_ri_config_main.g_grd_rv_struct_def_string;

1831: else
1832: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).appl_short_name := 'PER';
1833: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).flex_code := 'GRD';
1834: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).structure_code := l_grade_rv_name
1835: || per_ri_config_main.g_grd_rv_struct_def_string;
1836: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).segment_name := l_rv_grade_segment_name;
1837: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).column_name := 'SEGMENT' || l_grades_segment_count;
1838: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).segment_number := l_grades_segment_no;
1839: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).value_set := null;

Line 1848: || per_ri_config_main.g_grd_rv_struct_def_string

1844: --create technical summary data for valueset
1845: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1846: ,p_valueset_type => l_rv_grade_segment_type
1847: ,p_structure_code => l_grade_rv_name
1848: || per_ri_config_main.g_grd_rv_struct_def_string
1849: ,p_segment_name => l_rv_grade_segment_name
1850: ,p_segment_number => l_grades_segment_no
1851: ,p_valueset_tab => l_kf_grd_rv_valueset_tab);
1852:

Line 1891: || per_ri_config_main.g_grd_rv_struct_def_string);

1887: per_ri_config_utilities.freeze_and_compile_flexfield
1888: (p_appl_short_Name => 'PER'
1889: ,p_flex_code => 'GRD'
1890: ,p_structure_code => l_grade_rv_name
1891: || per_ri_config_main.g_grd_rv_struct_def_string);
1892: end if;
1893: END IF;
1894: END LOOP;
1895: close csr_config_grade_rv;

Line 1969: l_grp_structures_code := per_ri_config_main.g_global_pea_structure_name;

1965:
1966: --
1967: -- create people group key flex
1968: --
1969: l_grp_structures_code := per_ri_config_main.g_global_pea_structure_name;
1970: if NOT (p_technical_summary_mode) then
1971: l_people_group_fk_number := per_ri_config_utilities.create_key_flexfield
1972: (p_appl_short_Name => 'PAY'
1973: ,p_flex_code => 'GRP'

Line 2068: l_cmp_structures_code := per_ri_config_main.g_global_cmp_structure_name;

2064:
2065: --
2066: -- create competence key flex
2067: --
2068: l_cmp_structures_code := per_ri_config_main.g_global_cmp_structure_name;
2069: if NOT (p_technical_summary_mode) then
2070: l_competence_fk_number := per_ri_config_utilities.create_key_flexfield
2071: (p_appl_short_Name => 'PER'
2072: ,p_flex_code => 'CMP'

Line 2163: l_cost_structures_code := per_ri_config_main.g_global_cst_structure_name;

2159:
2160: --
2161: -- create cost allocation key flex
2162: --
2163: l_cost_structures_code := per_ri_config_main.g_global_cst_structure_name;
2164: if NOT (p_technical_summary_mode) then
2165: l_cost_allocation_number := per_ri_config_utilities.create_key_flexfield
2166: (p_appl_short_Name => 'PAY'
2167: ,p_flex_code => 'COST'

Line 2434: (per_ri_config_main.g_global_job_structure_name);

2430:
2431: -- Create Global Jobs Key flex
2432: hr_utility.set_location(l_proc, 20);
2433: l_job_structures_code := per_ri_config_utilities.return_config_entity_name
2434: (per_ri_config_main.g_global_job_structure_name);
2435:
2436:
2437: if NOT (p_technical_summary_mode) then
2438: l_jobs_fk_number := per_ri_config_utilities.create_key_flexfield

Line 2464: (per_ri_config_main.g_global_pos_structure_name);

2460:
2461: -- Create Position Key flex
2462: hr_utility.set_location(l_proc, 30);
2463: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
2464: (per_ri_config_main.g_global_pos_structure_name);
2465: if NOT (p_technical_summary_mode) then
2466: l_position_fk_number := per_ri_config_utilities.create_key_flexfield
2467: (p_appl_short_Name => 'PER'
2468: ,p_flex_code => 'POS'

Line 3020: (per_ri_config_main.g_global_pos_structure_name);

3016: -- Create Position Key flex
3017: hr_utility.set_location(l_proc, 20);
3018:
3019: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
3020: (per_ri_config_main.g_global_pos_structure_name);
3021: if NOT (p_technical_summary_mode) then
3022: l_position_fk_number := per_ri_config_utilities.create_key_flexfield
3023: (p_appl_short_Name => 'PER'
3024: ,p_flex_code => 'POS'

Line 3434: (per_ri_config_main.g_global_grd_structure_name);

3430: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
3431: hr_utility.set_location(l_proc, 20);
3432: -- Create Grade Key Flex
3433: l_grd_structures_code := per_ri_config_utilities.return_config_entity_name
3434: (per_ri_config_main.g_global_grd_structure_name);
3435: if NOT (p_technical_summary_mode) then
3436: l_grade_number := per_ri_config_utilities.create_key_flexfield
3437: (p_appl_short_Name => 'PER'
3438: ,p_flex_code => 'GRD'

Line 3869: (per_ri_config_main.g_configuration_user_name));

3865:
3866: hr_utility.set_location('Entering:'|| l_proc, 10);
3867:
3868: l_configuration_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
3869: (per_ri_config_main.g_configuration_user_name));
3870: open csr_get_product(p_configuration_code);
3871:
3872: loop
3873: fetch csr_get_product into l_product_name;

Line 3910: x_description => per_ri_config_main.g_description_string);

3906: x_security_group => 'STANDARD',
3907: x_owner => 'SEED',
3908: x_start_date => l_start_date,
3909: x_end_date => l_end_date,
3910: x_description => per_ri_config_main.g_description_string);
3911: hr_utility.trace('Assigned Responsibility: ' || 'EMPLOYEE_DIRECT_ACCESS');
3912: hr_utility.set_location(l_proc, 40);
3913: else
3914: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;

Line 3921: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;

3917: p_hrms_resp_tab(l_hrms_resp_count).security_group := 'STANDARD';
3918: p_hrms_resp_tab(l_hrms_resp_count).owner := 'SEED';
3919: p_hrms_resp_tab(l_hrms_resp_count).start_date := l_start_date;
3920: p_hrms_resp_tab(l_hrms_resp_count).end_date := l_end_date;
3921: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
3922:
3923: l_hrms_resp_count := l_hrms_resp_count + 1 ;
3924: end if;
3925:

Line 3935: x_description => per_ri_config_main.g_description_string);

3931: x_security_group => 'STANDARD',
3932: x_owner => 'SEED',
3933: x_start_date => l_start_date,
3934: x_end_date => l_end_date,
3935: x_description => per_ri_config_main.g_description_string);
3936: else
3937: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;
3938: p_hrms_resp_tab(l_hrms_resp_count).resp_key := 'LINE_MANAGER_ACCESS_V4';
3939: p_hrms_resp_tab(l_hrms_resp_count).app_short_name := 'PER';

Line 3944: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;

3940: p_hrms_resp_tab(l_hrms_resp_count).security_group := 'STANDARD';
3941: p_hrms_resp_tab(l_hrms_resp_count).owner := 'SEED';
3942: p_hrms_resp_tab(l_hrms_resp_count).start_date := l_start_date;
3943: p_hrms_resp_tab(l_hrms_resp_count).end_date := l_end_date;
3944: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
3945:
3946: l_hrms_resp_count := l_hrms_resp_count + 1 ;
3947: end if;
3948: hr_utility.trace('Assigned Responsibility: ' || 'LINE_MANAGER_DIRECT_ACCESS');

Line 4005: x_description => per_ri_config_main.g_description_string);

4001: x_security_group => 'STANDARD',
4002: x_owner => 'SEED',
4003: x_start_date => l_start_date,
4004: x_end_date => l_end_date,
4005: x_description => per_ri_config_main.g_description_string);
4006: hr_utility.trace('Assigned Responsibility:' || l_responsibility_key || ':' || l_fnd_application_short_name);
4007: */
4008: -- get business group name for given country code
4009: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name

Line 4011: || ' ' || l_country_code || per_ri_config_main.g_bg_name_suffix_string;

4007: */
4008: -- get business group name for given country code
4009: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name
4010: (p_configuration_code => p_configuration_code)
4011: || ' ' || l_country_code || per_ri_config_main.g_bg_name_suffix_string;
4012:
4013: per_ri_config_fnd_hr_entity.create_resp_level_profile
4014: (p_configuration_code => p_configuration_code
4015: ,p_responsibility_key => l_responsibility_key

Line 4043: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;

4039: p_hrms_resp_tab(l_hrms_resp_count).security_group := l_business_group_name_main;
4040: p_hrms_resp_tab(l_hrms_resp_count).owner := null;
4041: p_hrms_resp_tab(l_hrms_resp_count).start_date := l_start_date;
4042: p_hrms_resp_tab(l_hrms_resp_count).end_date := l_end_date;
4043: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
4044:
4045: l_hrms_resp_count := l_hrms_resp_count + 1;
4046: end if;
4047:

Line 4103: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;

4099: -- get business group name for given country code
4100: -- business group name and security profile names are same
4101: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name
4102: (p_configuration_code => p_configuration_code)
4103: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;
4104:
4105: p_security_profile_tab(l_earlier_row_count).security_profile_name
4106: := l_business_group_name_global;
4107: p_security_profile_tab(l_earlier_row_count).responsibility_key

Line 4117: p_hrms_resp_tab(l_earlier_row_count).description := per_ri_config_main.g_description_string;

4113: p_hrms_resp_tab(l_earlier_row_count).security_group := null;
4114: p_hrms_resp_tab(l_earlier_row_count).owner := null;
4115: p_hrms_resp_tab(l_earlier_row_count).start_date := l_start_date;
4116: p_hrms_resp_tab(l_earlier_row_count).end_date := l_end_date;
4117: p_hrms_resp_tab(l_earlier_row_count).description := per_ri_config_main.g_description_string;
4118:
4119: l_earlier_row_count := 1 + l_earlier_row_count;
4120: end loop;
4121: close csr_global_responsibility;

Line 4134: x_description => per_ri_config_main.g_description_string);

4130: x_security_group => 'STANDARD',
4131: x_owner => 'SEED',
4132: x_start_date => l_start_date,
4133: x_end_date => l_end_date,
4134: x_description => per_ri_config_main.g_description_string);
4135: else
4136: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;
4137: p_hrms_resp_tab(l_hrms_resp_count).resp_key := l_assign_global_resp_key;
4138: p_hrms_resp_tab(l_hrms_resp_count).app_short_name := l_assign_glb_resp_key_app_name;

Line 4143: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;

4139: p_hrms_resp_tab(l_hrms_resp_count).security_group := 'STANDARD';
4140: p_hrms_resp_tab(l_hrms_resp_count).owner := 'SEED';
4141: p_hrms_resp_tab(l_hrms_resp_count).start_date := l_start_date;
4142: p_hrms_resp_tab(l_hrms_resp_count).end_date := l_end_date;
4143: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
4144:
4145: l_hrms_resp_count := l_hrms_resp_count + 1 ;
4146: end if;
4147:

Line 4157: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;

4153:
4154: -- get business group name for given country code
4155: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name
4156: (p_configuration_code => p_configuration_code)
4157: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;
4158:
4159: hr_utility.trace('Security Group Removal Changes');
4160: per_ri_config_fnd_hr_entity.create_bg_id_and_sg_id_profile
4161: (p_configuration_code => p_configuration_code