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.

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 1355: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string

1351: if NOT (p_technical_summary_mode) then
1352: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield
1353: (p_appl_short_Name => 'PER'
1354: ,p_flex_code => 'JOB'
1355: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1356: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1357: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1358: || per_ri_config_main.g_description_suffix_string);
1359: else

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

1352: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield
1353: (p_appl_short_Name => 'PER'
1354: ,p_flex_code => 'JOB'
1355: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1356: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1357: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1358: || per_ri_config_main.g_description_suffix_string);
1359: else
1360: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';

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

1353: (p_appl_short_Name => 'PER'
1354: ,p_flex_code => 'JOB'
1355: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1356: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1357: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1358: || per_ri_config_main.g_description_suffix_string);
1359: else
1360: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1361: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';

Line 1358: || per_ri_config_main.g_description_suffix_string);

1354: ,p_flex_code => 'JOB'
1355: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1356: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1357: ,p_description => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1358: || per_ri_config_main.g_description_suffix_string);
1359: else
1360: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1361: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1362: 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 1362: 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;

1358: || per_ri_config_main.g_description_suffix_string);
1359: else
1360: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1361: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1362: 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;
1363: 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;
1364: 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
1365: || per_ri_config_main.g_description_suffix_string;
1366: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;

Line 1363: 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;

1359: else
1360: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1361: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1362: 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;
1363: 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;
1364: 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
1365: || per_ri_config_main.g_description_suffix_string;
1366: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;
1367: end if;

Line 1364: 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

1360: p_kf_job_rv_tab(l_kf_job_rv_count).appl_short_name := 'PER';
1361: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1362: 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;
1363: 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;
1364: 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
1365: || per_ri_config_main.g_description_suffix_string;
1366: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;
1367: end if;
1368:

Line 1365: || per_ri_config_main.g_description_suffix_string;

1361: p_kf_job_rv_tab(l_kf_job_rv_count).flex_code := 'JOB';
1362: 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;
1363: 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;
1364: 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
1365: || per_ri_config_main.g_description_suffix_string;
1366: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;
1367: end if;
1368:
1369: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name

Line 1370: || per_ri_config_main.g_job_rv_struct_def_string );

1366: l_kf_job_rv_count := l_kf_job_rv_count + 1 ;
1367: end if;
1368:
1369: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name
1370: || per_ri_config_main.g_job_rv_struct_def_string );
1371: hr_utility.trace('Created Jobs RV Keyflex ' || l_jobs_rv_name
1372: || per_ri_config_main.g_job_rv_struct_def_string);
1373:
1374: open csr_config_jobs_rv_seg(p_configuration_code

Line 1372: || per_ri_config_main.g_job_rv_struct_def_string);

1368:
1369: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name
1370: || per_ri_config_main.g_job_rv_struct_def_string );
1371: hr_utility.trace('Created Jobs RV Keyflex ' || l_jobs_rv_name
1372: || per_ri_config_main.g_job_rv_struct_def_string);
1373:
1374: open csr_config_jobs_rv_seg(p_configuration_code
1375: ,l_jobs_rv_name_orig);
1376: l_jobs_segment_count := 0;

Line 1390: || per_ri_config_main.g_job_rv_struct_def_string

1386: per_ri_config_utilities.create_flex_segments
1387: (p_appl_short_Name => 'PER'
1388: ,p_flex_code => 'JOB'
1389: ,p_structure_code => l_jobs_rv_name
1390: || per_ri_config_main.g_job_rv_struct_def_string
1391: ,p_segment_name => l_rv_jobs_segment_name
1392: ,p_column_name => 'SEGMENT' || l_jobs_segment_count
1393: ,p_segment_number => l_jobs_segment_no --l_jobs_segment_count
1394: ,p_value_set => null

Line 1402: || per_ri_config_main.g_job_rv_struct_def_string;

1398: else
1399: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).appl_short_name := 'PER';
1400: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).flex_code := 'JOB';
1401: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).structure_code := l_jobs_rv_name
1402: || per_ri_config_main.g_job_rv_struct_def_string;
1403: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).segment_name := l_rv_jobs_segment_name;
1404: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).column_name := 'SEGMENT' || l_jobs_segment_count;
1405: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).segment_number := l_jobs_segment_no;
1406: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).value_set := null;

Line 1415: || per_ri_config_main.g_job_rv_struct_def_string

1411: --create technical summary data for valueset
1412: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1413: ,p_valueset_type => l_rv_jobs_segment_type
1414: ,p_structure_code => l_jobs_rv_name
1415: || per_ri_config_main.g_job_rv_struct_def_string
1416: ,p_segment_name => l_jobs_rv_name
1417: ,p_segment_number => l_jobs_segment_no
1418: ,p_valueset_tab => l_kf_job_rv_valueset_tab);
1419:

Line 1458: || per_ri_config_main.g_job_rv_struct_def_string);

1454: per_ri_config_utilities.freeze_and_compile_flexfield
1455: (p_appl_short_Name => 'PER'
1456: ,p_flex_code => 'JOB'
1457: ,p_structure_code => l_jobs_rv_name
1458: || per_ri_config_main.g_job_rv_struct_def_string);
1459: end if;
1460: close csr_config_jobs_rv_seg;
1461: END LOOP;
1462: close csr_config_jobs_rv;

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

1540: if NOT (p_technical_summary_mode) then
1541: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield
1542: (p_appl_short_Name => 'PER'
1543: ,p_flex_code => 'POS'
1544: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1545: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1546: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1547: || per_ri_config_main.g_description_suffix_string);
1548:

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

1541: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield
1542: (p_appl_short_Name => 'PER'
1543: ,p_flex_code => 'POS'
1544: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1545: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1546: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1547: || per_ri_config_main.g_description_suffix_string);
1548:
1549: else

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

1542: (p_appl_short_Name => 'PER'
1543: ,p_flex_code => 'POS'
1544: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1545: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1546: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1547: || per_ri_config_main.g_description_suffix_string);
1548:
1549: else
1550: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';

Line 1547: || per_ri_config_main.g_description_suffix_string);

1543: ,p_flex_code => 'POS'
1544: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1545: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1546: ,p_description => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1547: || per_ri_config_main.g_description_suffix_string);
1548:
1549: else
1550: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';
1551: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';

Line 1552: 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;

1548:
1549: else
1550: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';
1551: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';
1552: 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;
1553: 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;
1554: 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
1555: || per_ri_config_main.g_description_suffix_string;
1556: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;

Line 1553: 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;

1549: else
1550: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';
1551: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';
1552: 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;
1553: 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;
1554: 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
1555: || per_ri_config_main.g_description_suffix_string;
1556: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1557: end if;

Line 1554: 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

1550: p_kf_pos_rv_tab(l_kf_pos_rv_count).appl_short_name := 'PER';
1551: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';
1552: 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;
1553: 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;
1554: 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
1555: || per_ri_config_main.g_description_suffix_string;
1556: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1557: end if;
1558: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name

Line 1555: || per_ri_config_main.g_description_suffix_string;

1551: p_kf_pos_rv_tab(l_kf_pos_rv_count).flex_code := 'POS';
1552: 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;
1553: 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;
1554: 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
1555: || per_ri_config_main.g_description_suffix_string;
1556: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1557: end if;
1558: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name
1559: || per_ri_config_main.g_pos_rv_struct_def_string );

Line 1559: || per_ri_config_main.g_pos_rv_struct_def_string );

1555: || per_ri_config_main.g_description_suffix_string;
1556: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1557: end if;
1558: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name
1559: || per_ri_config_main.g_pos_rv_struct_def_string );
1560: hr_utility.trace('Created Positions RV Keyflex ' || l_positions_rv_name
1561: || per_ri_config_main.g_pos_rv_struct_def_string);
1562:
1563: open csr_config_positions_rv_seg(p_configuration_code

Line 1561: || per_ri_config_main.g_pos_rv_struct_def_string);

1557: end if;
1558: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name
1559: || per_ri_config_main.g_pos_rv_struct_def_string );
1560: hr_utility.trace('Created Positions RV Keyflex ' || l_positions_rv_name
1561: || per_ri_config_main.g_pos_rv_struct_def_string);
1562:
1563: open csr_config_positions_rv_seg(p_configuration_code
1564: ,l_positions_rv_name_orig);
1565: l_positions_segment_count := 0;

Line 1579: || per_ri_config_main.g_pos_rv_struct_def_string

1575: per_ri_config_utilities.create_flex_segments
1576: (p_appl_short_Name => 'PER'
1577: ,p_flex_code => 'POS'
1578: ,p_structure_code => l_positions_rv_name
1579: || per_ri_config_main.g_pos_rv_struct_def_string
1580: ,p_segment_name => l_rv_positions_segment_name
1581: ,p_column_name => 'SEGMENT' || l_positions_segment_count
1582: ,p_segment_number => l_positions_segment_no
1583: ,p_value_set => null

Line 1592: || per_ri_config_main.g_pos_rv_struct_def_string;

1588: else
1589: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).appl_short_name := 'PER';
1590: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).flex_code := 'POS';
1591: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).structure_code := l_positions_rv_name
1592: || per_ri_config_main.g_pos_rv_struct_def_string;
1593: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).segment_name := l_rv_positions_segment_name;
1594: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).column_name := 'SEGMENT' || l_positions_segment_count;
1595: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).segment_number := l_positions_segment_no;
1596: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).value_set := null;

Line 1605: || per_ri_config_main.g_pos_rv_struct_def_string

1601: --create technical summary data for valueset
1602: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1603: ,p_valueset_type => l_rv_positions_segment_type
1604: ,p_structure_code => l_positions_rv_name
1605: || per_ri_config_main.g_pos_rv_struct_def_string
1606: ,p_segment_name => l_rv_positions_segment_name
1607: ,p_segment_number => l_positions_segment_no
1608: ,p_valueset_tab => l_kf_pos_rv_valueset_tab);
1609:

Line 1647: || per_ri_config_main.g_pos_rv_struct_def_string);

1643: per_ri_config_utilities.freeze_and_compile_flexfield
1644: (p_appl_short_Name => 'PER'
1645: ,p_flex_code => 'POS'
1646: ,p_structure_code => l_positions_rv_name
1647: || per_ri_config_main.g_pos_rv_struct_def_string);
1648: end if;
1649: close csr_config_positions_rv_seg;
1650: END LOOP;
1651: close csr_config_positions_rv;

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

1727: l_grades_keyflex_number :=
1728: per_ri_config_utilities.create_key_flexfield
1729: (p_appl_short_Name => 'PER'
1730: ,p_flex_code => 'GRD'
1731: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1732: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1733: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1734: || per_ri_config_main.g_description_suffix_string);
1735:

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

1728: per_ri_config_utilities.create_key_flexfield
1729: (p_appl_short_Name => 'PER'
1730: ,p_flex_code => 'GRD'
1731: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1732: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1733: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1734: || per_ri_config_main.g_description_suffix_string);
1735:
1736: else

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

1729: (p_appl_short_Name => 'PER'
1730: ,p_flex_code => 'GRD'
1731: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1732: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1733: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1734: || per_ri_config_main.g_description_suffix_string);
1735:
1736: else
1737: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';

Line 1734: || per_ri_config_main.g_description_suffix_string);

1730: ,p_flex_code => 'GRD'
1731: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1732: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1733: ,p_description => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1734: || per_ri_config_main.g_description_suffix_string);
1735:
1736: else
1737: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';
1738: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';

Line 1739: 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;

1735:
1736: else
1737: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';
1738: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';
1739: 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;
1740: 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;
1741: 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
1742: || per_ri_config_main.g_description_suffix_string;
1743: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;

Line 1740: 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;

1736: else
1737: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';
1738: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';
1739: 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;
1740: 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;
1741: 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
1742: || per_ri_config_main.g_description_suffix_string;
1743: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1744: end if;

Line 1741: 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

1737: p_kf_grd_rv_tab(l_kf_grd_rv_count).appl_short_name := 'PER';
1738: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';
1739: 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;
1740: 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;
1741: 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
1742: || per_ri_config_main.g_description_suffix_string;
1743: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1744: end if;
1745: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '

Line 1742: || per_ri_config_main.g_description_suffix_string;

1738: p_kf_grd_rv_tab(l_kf_grd_rv_count).flex_code := 'GRD';
1739: 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;
1740: 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;
1741: 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
1742: || per_ri_config_main.g_description_suffix_string;
1743: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1744: end if;
1745: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '
1746: || per_ri_config_main.g_grd_rv_struct_def_string );

Line 1746: || per_ri_config_main.g_grd_rv_struct_def_string );

1742: || per_ri_config_main.g_description_suffix_string;
1743: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1744: end if;
1745: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '
1746: || per_ri_config_main.g_grd_rv_struct_def_string );
1747: hr_utility.trace('Created Grades RV Keyflex ' || per_ri_config_main.g_grd_rv_struct_def_string);
1748:
1749: open csr_config_grade_rv_seg(p_configuration_code
1750: ,l_grade_rv_name_orig);

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

1743: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1744: end if;
1745: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '
1746: || per_ri_config_main.g_grd_rv_struct_def_string );
1747: hr_utility.trace('Created Grades RV Keyflex ' || per_ri_config_main.g_grd_rv_struct_def_string);
1748:
1749: open csr_config_grade_rv_seg(p_configuration_code
1750: ,l_grade_rv_name_orig);
1751: l_grades_segment_count := 0;

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

1760: if NOT (p_technical_summary_mode) then
1761: per_ri_config_utilities.create_flex_segments
1762: (p_appl_short_Name => 'PER'
1763: ,p_flex_code => 'GRD'
1764: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1765: ,p_segment_name => l_rv_grade_segment_name
1766: ,p_column_name => 'SEGMENT' || l_grades_segment_count
1767: ,p_segment_number => l_grades_segment_no
1768: ,p_value_set => null

Line 1776: || per_ri_config_main.g_grd_rv_struct_def_string;

1772: else
1773: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).appl_short_name := 'PER';
1774: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).flex_code := 'GRD';
1775: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).structure_code := l_grade_rv_name
1776: || per_ri_config_main.g_grd_rv_struct_def_string;
1777: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).segment_name := l_rv_grade_segment_name;
1778: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).column_name := 'SEGMENT' || l_grades_segment_count;
1779: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).segment_number := l_grades_segment_no;
1780: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).value_set := null;

Line 1789: || per_ri_config_main.g_grd_rv_struct_def_string

1785: --create technical summary data for valueset
1786: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1787: ,p_valueset_type => l_rv_grade_segment_type
1788: ,p_structure_code => l_grade_rv_name
1789: || per_ri_config_main.g_grd_rv_struct_def_string
1790: ,p_segment_name => l_rv_grade_segment_name
1791: ,p_segment_number => l_grades_segment_no
1792: ,p_valueset_tab => l_kf_grd_rv_valueset_tab);
1793:

Line 1832: || per_ri_config_main.g_grd_rv_struct_def_string);

1828: per_ri_config_utilities.freeze_and_compile_flexfield
1829: (p_appl_short_Name => 'PER'
1830: ,p_flex_code => 'GRD'
1831: ,p_structure_code => l_grade_rv_name
1832: || per_ri_config_main.g_grd_rv_struct_def_string);
1833: end if;
1834: END LOOP;
1835: close csr_config_grade_rv;
1836:

Line 1909: l_grp_structures_code := per_ri_config_main.g_global_pea_structure_name;

1905:
1906: --
1907: -- create people group key flex
1908: --
1909: l_grp_structures_code := per_ri_config_main.g_global_pea_structure_name;
1910: if NOT (p_technical_summary_mode) then
1911: l_people_group_fk_number := per_ri_config_utilities.create_key_flexfield
1912: (p_appl_short_Name => 'PAY'
1913: ,p_flex_code => 'GRP'

Line 2008: l_cmp_structures_code := per_ri_config_main.g_global_cmp_structure_name;

2004:
2005: --
2006: -- create competence key flex
2007: --
2008: l_cmp_structures_code := per_ri_config_main.g_global_cmp_structure_name;
2009: if NOT (p_technical_summary_mode) then
2010: l_competence_fk_number := per_ri_config_utilities.create_key_flexfield
2011: (p_appl_short_Name => 'PER'
2012: ,p_flex_code => 'CMP'

Line 2103: l_cost_structures_code := per_ri_config_main.g_global_cst_structure_name;

2099:
2100: --
2101: -- create cost allocation key flex
2102: --
2103: l_cost_structures_code := per_ri_config_main.g_global_cst_structure_name;
2104: if NOT (p_technical_summary_mode) then
2105: l_cost_allocation_number := per_ri_config_utilities.create_key_flexfield
2106: (p_appl_short_Name => 'PAY'
2107: ,p_flex_code => 'COST'

Line 2374: (per_ri_config_main.g_global_job_structure_name);

2370:
2371: -- Create Global Jobs Key flex
2372: hr_utility.set_location(l_proc, 20);
2373: l_job_structures_code := per_ri_config_utilities.return_config_entity_name
2374: (per_ri_config_main.g_global_job_structure_name);
2375:
2376:
2377: if NOT (p_technical_summary_mode) then
2378: l_jobs_fk_number := per_ri_config_utilities.create_key_flexfield

Line 2404: (per_ri_config_main.g_global_pos_structure_name);

2400:
2401: -- Create Position Key flex
2402: hr_utility.set_location(l_proc, 30);
2403: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
2404: (per_ri_config_main.g_global_pos_structure_name);
2405: if NOT (p_technical_summary_mode) then
2406: l_position_fk_number := per_ri_config_utilities.create_key_flexfield
2407: (p_appl_short_Name => 'PER'
2408: ,p_flex_code => 'POS'

Line 2960: (per_ri_config_main.g_global_pos_structure_name);

2956: -- Create Position Key flex
2957: hr_utility.set_location(l_proc, 20);
2958:
2959: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
2960: (per_ri_config_main.g_global_pos_structure_name);
2961: if NOT (p_technical_summary_mode) then
2962: l_position_fk_number := per_ri_config_utilities.create_key_flexfield
2963: (p_appl_short_Name => 'PER'
2964: ,p_flex_code => 'POS'

Line 3374: (per_ri_config_main.g_global_grd_structure_name);

3370: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
3371: hr_utility.set_location(l_proc, 20);
3372: -- Create Grade Key Flex
3373: l_grd_structures_code := per_ri_config_utilities.return_config_entity_name
3374: (per_ri_config_main.g_global_grd_structure_name);
3375: if NOT (p_technical_summary_mode) then
3376: l_grade_number := per_ri_config_utilities.create_key_flexfield
3377: (p_appl_short_Name => 'PER'
3378: ,p_flex_code => 'GRD'

Line 3809: (per_ri_config_main.g_configuration_user_name));

3805:
3806: hr_utility.set_location('Entering:'|| l_proc, 10);
3807:
3808: l_configuration_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
3809: (per_ri_config_main.g_configuration_user_name));
3810: open csr_get_product(p_configuration_code);
3811:
3812: loop
3813: fetch csr_get_product into l_product_name;

Line 3850: x_description => per_ri_config_main.g_description_string);

3846: x_security_group => 'STANDARD',
3847: x_owner => 'SEED',
3848: x_start_date => l_start_date,
3849: x_end_date => l_end_date,
3850: x_description => per_ri_config_main.g_description_string);
3851: hr_utility.trace('Assigned Responsibility: ' || 'EMPLOYEE_DIRECT_ACCESS');
3852: hr_utility.set_location(l_proc, 40);
3853: else
3854: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;

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

3857: p_hrms_resp_tab(l_hrms_resp_count).security_group := 'STANDARD';
3858: p_hrms_resp_tab(l_hrms_resp_count).owner := 'SEED';
3859: p_hrms_resp_tab(l_hrms_resp_count).start_date := l_start_date;
3860: p_hrms_resp_tab(l_hrms_resp_count).end_date := l_end_date;
3861: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
3862:
3863: l_hrms_resp_count := l_hrms_resp_count + 1 ;
3864: end if;
3865:

Line 3875: x_description => per_ri_config_main.g_description_string);

3871: x_security_group => 'STANDARD',
3872: x_owner => 'SEED',
3873: x_start_date => l_start_date,
3874: x_end_date => l_end_date,
3875: x_description => per_ri_config_main.g_description_string);
3876: else
3877: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;
3878: p_hrms_resp_tab(l_hrms_resp_count).resp_key := 'LINE_MANAGER_ACCESS_V4';
3879: p_hrms_resp_tab(l_hrms_resp_count).app_short_name := 'PER';

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

3880: p_hrms_resp_tab(l_hrms_resp_count).security_group := 'STANDARD';
3881: p_hrms_resp_tab(l_hrms_resp_count).owner := 'SEED';
3882: p_hrms_resp_tab(l_hrms_resp_count).start_date := l_start_date;
3883: p_hrms_resp_tab(l_hrms_resp_count).end_date := l_end_date;
3884: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
3885:
3886: l_hrms_resp_count := l_hrms_resp_count + 1 ;
3887: end if;
3888: hr_utility.trace('Assigned Responsibility: ' || 'LINE_MANAGER_DIRECT_ACCESS');

Line 3945: x_description => per_ri_config_main.g_description_string);

3941: x_security_group => 'STANDARD',
3942: x_owner => 'SEED',
3943: x_start_date => l_start_date,
3944: x_end_date => l_end_date,
3945: x_description => per_ri_config_main.g_description_string);
3946: hr_utility.trace('Assigned Responsibility:' || l_responsibility_key || ':' || l_fnd_application_short_name);
3947: */
3948: -- get business group name for given country code
3949: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name

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

3947: */
3948: -- get business group name for given country code
3949: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name
3950: (p_configuration_code => p_configuration_code)
3951: || ' ' || l_country_code || per_ri_config_main.g_bg_name_suffix_string;
3952:
3953: per_ri_config_fnd_hr_entity.create_resp_level_profile
3954: (p_configuration_code => p_configuration_code
3955: ,p_responsibility_key => l_responsibility_key

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

3979: p_hrms_resp_tab(l_hrms_resp_count).security_group := l_business_group_name_main;
3980: p_hrms_resp_tab(l_hrms_resp_count).owner := null;
3981: p_hrms_resp_tab(l_hrms_resp_count).start_date := l_start_date;
3982: p_hrms_resp_tab(l_hrms_resp_count).end_date := l_end_date;
3983: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
3984:
3985: l_hrms_resp_count := l_hrms_resp_count + 1;
3986: end if;
3987:

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

4039: -- get business group name for given country code
4040: -- business group name and security profile names are same
4041: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name
4042: (p_configuration_code => p_configuration_code)
4043: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;
4044:
4045: p_security_profile_tab(l_earlier_row_count).security_profile_name
4046: := l_business_group_name_global;
4047: p_security_profile_tab(l_earlier_row_count).responsibility_key

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

4053: p_hrms_resp_tab(l_earlier_row_count).security_group := null;
4054: p_hrms_resp_tab(l_earlier_row_count).owner := null;
4055: p_hrms_resp_tab(l_earlier_row_count).start_date := l_start_date;
4056: p_hrms_resp_tab(l_earlier_row_count).end_date := l_end_date;
4057: p_hrms_resp_tab(l_earlier_row_count).description := per_ri_config_main.g_description_string;
4058:
4059: l_earlier_row_count := 1 + l_earlier_row_count;
4060: end loop;
4061: close csr_global_responsibility;

Line 4074: x_description => per_ri_config_main.g_description_string);

4070: x_security_group => 'STANDARD',
4071: x_owner => 'SEED',
4072: x_start_date => l_start_date,
4073: x_end_date => l_end_date,
4074: x_description => per_ri_config_main.g_description_string);
4075: else
4076: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;
4077: p_hrms_resp_tab(l_hrms_resp_count).resp_key := l_assign_global_resp_key;
4078: p_hrms_resp_tab(l_hrms_resp_count).app_short_name := l_assign_glb_resp_key_app_name;

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

4079: p_hrms_resp_tab(l_hrms_resp_count).security_group := 'STANDARD';
4080: p_hrms_resp_tab(l_hrms_resp_count).owner := 'SEED';
4081: p_hrms_resp_tab(l_hrms_resp_count).start_date := l_start_date;
4082: p_hrms_resp_tab(l_hrms_resp_count).end_date := l_end_date;
4083: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
4084:
4085: l_hrms_resp_count := l_hrms_resp_count + 1 ;
4086: end if;
4087:

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

4093:
4094: -- get business group name for given country code
4095: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name
4096: (p_configuration_code => p_configuration_code)
4097: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;
4098:
4099: hr_utility.trace('Security Group Removal Changes');
4100: per_ri_config_fnd_hr_entity.create_bg_id_and_sg_id_profile
4101: (p_configuration_code => p_configuration_code