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_UTILITIES

Line 62: l_global_job_structure_name := per_ri_config_utilities.return_config_entity_name

58:
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:

Line 64: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

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

Line 71: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield

67: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);
68:
69: -- Create Global Jobs Key flex
70: if NOT (p_technical_summary_mode) then
71: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield
72: (p_appl_short_name => 'PER'
73: ,p_flex_code => 'JOB'
74: ,p_structure_code => l_global_job_structure_name
75: ,p_structure_title => l_global_job_structure_name

Line 91: per_ri_config_utilities.write_log(p_message => l_log_message);

87: end if;
88:
89: hr_utility.set_location(l_proc, 30);
90: l_log_message := 'Created KEYFLEX PER JOB ' || l_global_job_structure_name;
91: per_ri_config_utilities.write_log(p_message => l_log_message);
92:
93: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
94: hr_utility.set_location(l_proc, 20);
95: -- create segments

Line 111: per_ri_config_utilities.create_flex_segments

107: -- create job flex segment
108: --
109: l_jobs_segment_count := csr_config_job_no_rv%ROWCOUNT;
110: if NOT (p_technical_summary_mode) then
111: per_ri_config_utilities.create_flex_segments
112: (p_appl_short_Name => 'PER'
113: ,p_flex_code => 'JOB'
114: ,p_structure_code => l_global_job_structure_name
115: ,p_segment_name => l_job_segment_name

Line 137: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

133: p_kf_job_no_rv_seg_tab(l_kf_job_no_rv_seg_count).window_prompt := l_job_segment_name;
134:
135:
136: --create technical summary data for valueset
137: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
138: ,p_valueset_type => l_job_segment_type
139: ,p_structure_code => l_global_job_structure_name
140: ,p_segment_name => l_job_segment_name
141: ,p_segment_number => l_jobs_segment_no --l_jobs_segment_count

Line 173: per_ri_config_utilities.write_log(p_message => l_log_message);

169: l_kf_job_no_rv_seg_count := l_kf_job_no_rv_seg_count + 1 ;
170:
171: end if;
172: l_log_message := 'Created KEYFLEX SEGMENT : PER JOB ' || l_job_segment_name;
173: per_ri_config_utilities.write_log(p_message => l_log_message);
174: END LOOP;
175: close csr_config_job_no_rv;
176: else
177: hr_utility.set_location(l_proc, 100);

Line 183: per_ri_config_utilities.create_flex_segments

179:
180: -- create only federal job segments with specified value segment name valuesets.
181: -- First Segment 'Name' valueset '60 Characters'
182: if NOT (p_technical_summary_mode) then
183: per_ri_config_utilities.create_flex_segments
184: (p_appl_short_Name => 'PER'
185: ,p_flex_code => 'JOB'
186: ,p_structure_code => l_global_job_structure_name
187: ,p_segment_name => 'Name'

Line 209: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => '60 Characters'

205: p_kf_job_no_rv_seg_tab(l_kf_job_no_rv_seg_count).window_prompt := 'Name';
206:
207:
208: --create technical summary data for valueset
209: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => '60 Characters'
210: ,p_valueset_type => 'Char'
211: ,p_structure_code => l_global_job_structure_name
212: ,p_segment_name => 'Name'
213: ,p_segment_number => 1

Line 265: per_ri_config_utilities.create_flex_segments

261:
262:
263: hr_utility.trace('l_jobs_segment_count = ' || to_char(l_jobs_segment_count));
264: if NOT (p_technical_summary_mode) then
265: per_ri_config_utilities.create_flex_segments
266: (p_appl_short_Name => 'PER'
267: ,p_flex_code => 'JOB'
268: ,p_structure_code => l_global_job_structure_name
269: ,p_segment_name => l_job_segment_name

Line 290: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

286: p_kf_job_no_rv_seg_tab(l_kf_job_no_rv_seg_count).segment_type := l_job_segment_type;
287: p_kf_job_no_rv_seg_tab(l_kf_job_no_rv_seg_count).window_prompt := l_job_segment_name;
288:
289: --create technical summary data for valueset
290: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
291: ,p_valueset_type => l_job_segment_type
292: ,p_structure_code => l_global_job_structure_name
293: ,p_segment_name => l_job_segment_name
294: ,p_segment_number => l_jobs_segment_no --l_jobs_segment_count

Line 325: per_ri_config_utilities.write_log(p_message => l_log_message);

321: l_kf_job_no_rv_seg_count := l_kf_job_no_rv_seg_count + 1 ;
322: end if;
323:
324: l_log_message := 'Created KEYFLEX SEGMENT : PER JOB ' || l_job_segment_name;
325: per_ri_config_utilities.write_log(p_message => l_log_message);
326: end if;
327: END LOOP;
328: close csr_config_job_no_rv;
329:

Line 335: per_ri_config_utilities.freeze_and_compile_flexfield

331: --
332: -- freeze and compile this flexfield
333: --
334: if NOT (p_technical_summary_mode) then
335: per_ri_config_utilities.freeze_and_compile_flexfield
336: (p_appl_short_Name => 'PER'
337: ,p_flex_code => 'JOB'
338: ,p_structure_code => l_global_job_structure_name);
339: end if;

Line 412: l_global_pos_structure_name := per_ri_config_utilities.return_config_entity_name

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

Line 415: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

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:
418: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);
419:

Line 422: l_pos_keyflex_number := per_ri_config_utilities.create_key_flexfield

418: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);
419:
420: -- Create Global Position Key flex
421: if NOT (p_technical_summary_mode) then
422: l_pos_keyflex_number := per_ri_config_utilities.create_key_flexfield
423: (p_appl_short_Name => 'PER'
424: ,p_flex_code => 'POS'
425: ,p_structure_code => l_global_pos_structure_name
426: ,p_structure_title => l_global_pos_structure_name

Line 442: per_ri_config_utilities.write_log(p_message => l_log_message);

438:
439:
440: hr_utility.set_location(l_proc, 30);
441: l_log_message := 'Created KEYFLEX PER POS ' || l_global_pos_structure_name;
442: per_ri_config_utilities.write_log(p_message => l_log_message);
443:
444: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
445: hr_utility.set_location(l_proc, 20);
446:

Line 461: per_ri_config_utilities.create_flex_segments

457:
458: -- Create Jobs Key Flex Segments
459: l_pos_segment_count := csr_config_position_no_rv%ROWCOUNT;
460: if NOT (p_technical_summary_mode) then
461: per_ri_config_utilities.create_flex_segments
462: (p_appl_short_Name => 'PER'
463: ,p_flex_code => 'POS'
464: ,p_structure_code => l_global_pos_structure_name
465: ,p_segment_name => l_pos_segment_name

Line 485: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

481: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).segment_type := l_pos_segment_type;
482: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).window_prompt := l_pos_segment_name;
483:
484: --create technical summary data for valueset
485: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
486: ,p_valueset_type => l_pos_segment_type
487: ,p_structure_code => l_global_pos_structure_name
488: ,p_segment_name => l_pos_segment_name
489: ,p_segment_number => l_pos_segment_no

Line 519: per_ri_config_utilities.write_log(p_message => 'Created Global Position Key Flex Segment' || l_pos_segment_name);

515: := l_kf_pos_no_rv_valueset_tab(l_value_set_tab_count).max_value;
516: l_kf_pos_no_rv_seg_count := l_kf_pos_no_rv_seg_count + 1 ;
517: end if;
518:
519: per_ri_config_utilities.write_log(p_message => 'Created Global Position Key Flex Segment' || l_pos_segment_name);
520: hr_utility.trace('Created Position Key Flex NO RV Segment: ' || l_pos_segment_name);
521: END LOOP;
522: --
523: -- freeze and compile this flexfield

Line 526: per_ri_config_utilities.freeze_and_compile_flexfield

522: --
523: -- freeze and compile this flexfield
524: --
525: if NOT (p_technical_summary_mode) then
526: per_ri_config_utilities.freeze_and_compile_flexfield
527: (p_appl_short_Name => 'PER'
528: ,p_flex_code => 'POS'
529: ,p_structure_code => l_global_pos_structure_name);
530: end if;

Line 538: per_ri_config_utilities.create_flex_segments

534:
535: -- create only federal job segments with specified value segment name valuesets.
536: -- First Segment
537: if NOT (p_technical_summary_mode) then
538: per_ri_config_utilities.create_flex_segments
539: (p_appl_short_Name => 'PER'
540: ,p_flex_code => 'POS'
541: ,p_structure_code => l_global_pos_structure_name
542: ,p_segment_name => 'Position Title'

Line 564: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'

560: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).segment_type := 'Char';
561: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).window_prompt := 'Position Title';
562:
563: --create technical summary data for valueset
564: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'
565: ,p_valueset_type => 'Char'
566: ,p_structure_code => l_global_pos_structure_name
567: ,p_segment_name => 'Position Title'
568: ,p_segment_number => 1

Line 600: per_ri_config_utilities.write_log(p_message => l_log_message);

596: end if;
597:
598:
599: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Position Title';
600: per_ri_config_utilities.write_log(p_message => l_log_message);
601:
602: -- Second Segment
603: if NOT (p_technical_summary_mode) then
604: per_ri_config_utilities.create_flex_segments

Line 604: per_ri_config_utilities.create_flex_segments

600: per_ri_config_utilities.write_log(p_message => l_log_message);
601:
602: -- Second Segment
603: if NOT (p_technical_summary_mode) then
604: per_ri_config_utilities.create_flex_segments
605: (p_appl_short_Name => 'PER'
606: ,p_flex_code => 'POS'
607: ,p_structure_code => l_global_pos_structure_name
608: ,p_segment_name => 'Description'

Line 629: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POS_DESC_NUM'

625: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).segment_type := 'Char';
626: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).window_prompt := 'Description';
627:
628: --create technical summary data for valueset
629: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POS_DESC_NUM'
630: ,p_valueset_type => 'Char'
631: ,p_structure_code => l_global_pos_structure_name
632: ,p_segment_name => 'Description'
633: ,p_segment_number => 2

Line 664: per_ri_config_utilities.write_log(p_message => l_log_message);

660: l_kf_pos_no_rv_seg_count := l_kf_pos_no_rv_seg_count + 1 ;
661: end if;
662:
663: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Description';
664: per_ri_config_utilities.write_log(p_message => l_log_message);
665:
666: -- Third Segment
667: if NOT (p_technical_summary_mode) then
668: per_ri_config_utilities.create_flex_segments

Line 668: per_ri_config_utilities.create_flex_segments

664: per_ri_config_utilities.write_log(p_message => l_log_message);
665:
666: -- Third Segment
667: if NOT (p_technical_summary_mode) then
668: per_ri_config_utilities.create_flex_segments
669: (p_appl_short_Name => 'PER'
670: ,p_flex_code => 'POS'
671: ,p_structure_code => l_global_pos_structure_name
672: ,p_segment_name => 'Sequence'

Line 694: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'

690: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).segment_type := 'Char';
691: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).window_prompt := 'Sequence';
692:
693: --create technical summary data for valueset
694: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'
695: ,p_valueset_type => 'Char'
696: ,p_structure_code => l_global_pos_structure_name
697: ,p_segment_name => 'Sequence'
698: ,p_segment_number => 3

Line 729: per_ri_config_utilities.write_log(p_message => l_log_message);

725: l_kf_pos_no_rv_seg_count := l_kf_pos_no_rv_seg_count + 1 ;
726: end if;
727:
728: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
729: per_ri_config_utilities.write_log(p_message => l_log_message);
730: -- Fourth Segment
731: if NOT (p_technical_summary_mode) then
732: per_ri_config_utilities.create_flex_segments
733: (p_appl_short_Name => 'PER'

Line 732: per_ri_config_utilities.create_flex_segments

728: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
729: per_ri_config_utilities.write_log(p_message => l_log_message);
730: -- Fourth Segment
731: if NOT (p_technical_summary_mode) then
732: per_ri_config_utilities.create_flex_segments
733: (p_appl_short_Name => 'PER'
734: ,p_flex_code => 'POS'
735: ,p_structure_code => l_global_pos_structure_name
736: ,p_segment_name => 'Agency Code'

Line 757: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_AGENCY_CODE'

753: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).segment_type := 'Char';
754: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).window_prompt := 'Agency Code';
755:
756: --create technical summary data for valueset
757: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_AGENCY_CODE'
758: ,p_valueset_type => 'Char'
759: ,p_structure_code => l_global_pos_structure_name
760: ,p_segment_name => 'Agency Code'
761: ,p_segment_number => 4

Line 793: per_ri_config_utilities.write_log(p_message => l_log_message);

789: end if;
790:
791:
792: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
793: per_ri_config_utilities.write_log(p_message => l_log_message);
794:
795: open csr_config_position_no_rv(p_configuration_code);
796:
797: --

Line 819: per_ri_config_utilities.create_flex_segments

815:
816: hr_utility.trace('l_pos_segment_count = ' || to_char(l_pos_segment_count));
817:
818: if NOT (p_technical_summary_mode) then
819: per_ri_config_utilities.create_flex_segments
820: (p_appl_short_Name => 'PER'
821: ,p_flex_code => 'POS'
822: ,p_structure_code => l_global_pos_structure_name
823: ,p_segment_name => l_pos_segment_name

Line 843: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

839: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).segment_type := l_pos_segment_name;
840: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).window_prompt := l_pos_segment_name;
841:
842: --create technical summary data for valueset
843: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
844: ,p_valueset_type => l_pos_segment_type
845: ,p_structure_code => l_global_pos_structure_name
846: ,p_segment_name => l_pos_segment_name
847: ,p_segment_number => l_pos_segment_no

Line 878: per_ri_config_utilities.write_log(p_message => l_log_message);

874: l_kf_pos_no_rv_seg_count := l_kf_pos_no_rv_seg_count + 1 ;
875: end if;
876:
877: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_segment_name;
878: per_ri_config_utilities.write_log(p_message => l_log_message);
879: end if;
880: END LOOP;
881: close csr_config_position_no_rv;
882:

Line 887: per_ri_config_utilities.freeze_and_compile_flexfield

883: --
884: -- freeze and compile this flexfield
885: --
886: if NOT (p_technical_summary_mode) then
887: per_ri_config_utilities.freeze_and_compile_flexfield
888: (p_appl_short_Name => 'PER'
889: ,p_flex_code => 'POS'
890: ,p_structure_code => l_global_pos_structure_name);
891: end if;

Line 910: per_ri_config_utilities.create_flex_segments

906: hr_utility.set_location(l_proc, 110);
907:
908: -- Create Position Key Flex Segments
909: if NOT (p_technical_summary_mode) then
910: per_ri_config_utilities.create_flex_segments
911: (p_appl_short_Name => 'PER'
912: ,p_flex_code => 'POS'
913: ,p_structure_code => l_global_pos_structure_name
914: ,p_segment_name => 'Position Name'

Line 933: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'

929: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).segment_type := null;
930: p_kf_pos_no_rv_seg_tab(l_kf_pos_no_rv_seg_count).window_prompt := 'Position Name';
931:
932: --create technical summary data for valueset
933: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'
934: ,p_valueset_type => null
935: ,p_structure_code => l_global_pos_structure_name
936: ,p_segment_name => 'Position Name'
937: ,p_segment_number => 1

Line 968: per_ri_config_utilities.write_log(p_message => l_log_message);

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: --
972: if NOT (p_technical_summary_mode) then

Line 973: per_ri_config_utilities.freeze_and_compile_flexfield

969: --
970: -- freeze and compile this flexfield
971: --
972: if NOT (p_technical_summary_mode) then
973: per_ri_config_utilities.freeze_and_compile_flexfield
974: (p_appl_short_Name => 'PER'
975: ,p_flex_code => 'POS'
976: ,p_structure_code => l_global_pos_structure_name);
977: end if;

Line 1047: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

1043: BEGIN
1044:
1045: hr_utility.set_location('Entering:'|| l_proc, 10);
1046:
1047: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
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

Line 1051: l_global_grd_structure_name := per_ri_config_utilities.return_config_entity_name

1047: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
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

Line 1057: l_grade_keyflex_number := per_ri_config_utilities.create_key_flexfield

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
1057: l_grade_keyflex_number := per_ri_config_utilities.create_key_flexfield
1058: (p_appl_short_Name => 'PER'
1059: ,p_flex_code => 'GRD'
1060: ,p_structure_code => l_global_grd_structure_name
1061: ,p_structure_title => l_global_grd_structure_name

Line 1077: per_ri_config_utilities.write_log(p_message => l_log_message);

1073:
1074:
1075: hr_utility.set_location(l_proc, 30);
1076: l_log_message := 'Created KEYFLEX PER GRD ' || l_global_grd_structure_name;
1077: per_ri_config_utilities.write_log(p_message => l_log_message);
1078:
1079: -- create segments
1080: open csr_config_grade_no_rv(p_configuration_code);
1081: l_grade_segment_count := 0;

Line 1093: per_ri_config_utilities.create_flex_segments

1089:
1090: -- Create Jobs Key Flex Segments
1091: l_grade_segment_count := csr_config_grade_no_rv%ROWCOUNT;
1092: if NOT (p_technical_summary_mode) then
1093: per_ri_config_utilities.create_flex_segments
1094: (p_appl_short_Name => 'PER'
1095: ,p_flex_code => 'GRD'
1096: ,p_structure_code => l_global_grd_structure_name
1097: ,p_segment_name => l_grade_segment_name

Line 1118: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1114: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).segment_type := l_grade_segment_type;
1115: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).window_prompt := l_grade_segment_name;
1116:
1117: --create technical summary data for valueset
1118: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1119: ,p_valueset_type => l_grade_segment_type
1120: ,p_structure_code => l_global_grd_structure_name
1121: ,p_segment_name => l_grade_segment_name
1122: ,p_segment_number => l_grade_segment_no

Line 1154: per_ri_config_utilities.write_log(p_message => l_log_message);

1150: l_kf_grd_no_rv_seg_count := l_kf_grd_no_rv_seg_count + 1 ;
1151: end if;
1152:
1153: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || l_grade_segment_name;
1154: per_ri_config_utilities.write_log(p_message => l_log_message);
1155: END LOOP;
1156: hr_utility.set_location(l_proc, 50);
1157: --
1158: -- freeze and compile this flexfield

Line 1161: per_ri_config_utilities.freeze_and_compile_flexfield

1157: --
1158: -- freeze and compile this flexfield
1159: --
1160: if NOT (p_technical_summary_mode) then
1161: per_ri_config_utilities.freeze_and_compile_flexfield
1162: (p_appl_short_Name => 'PER'
1163: ,p_flex_code => 'GRD'
1164: ,p_structure_code => l_global_grd_structure_name);
1165: end if;

Line 1199: per_ri_config_utilities.create_flex_segments

1195: hr_utility.trace('l_grade_segment_count = ' || to_char(l_grade_segment_count));
1196:
1197:
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

Line 1223: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1219: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).segment_type := l_grade_segment_type;
1220: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).window_prompt := l_grade_segment_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

Line 1259: per_ri_config_utilities.write_log(p_message => l_log_message);

1255: end if;
1256:
1257:
1258: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || l_grade_segment_name;
1259: per_ri_config_utilities.write_log(p_message => l_log_message);
1260: end if;
1261: END LOOP;
1262: --
1263: -- freeze and compile this flexfield

Line 1266: per_ri_config_utilities.freeze_and_compile_flexfield

1262: --
1263: -- freeze and compile this flexfield
1264: --
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;

Line 1299: select distinct per_ri_config_utilities.return_config_entity_name(rv.regional_variance_name),

1295: ,p_kf_job_rv_seg_tab in out nocopy
1296: per_ri_config_tech_summary.kf_job_rv_seg_tab) IS
1297:
1298: cursor csr_config_jobs_rv (cp_configuration_code in varchar2) IS
1299: select distinct per_ri_config_utilities.return_config_entity_name(rv.regional_variance_name),
1300: rv.regional_variance_name
1301: from per_ri_config_jp_rv_v rv,
1302: per_ri_config_job_rv_seg_v seg
1303: where rv.configuration_code = cp_configuration_code

Line 1352: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield

1348:
1349: hr_utility.set_location(l_proc, 20);
1350: -- Create Jobs RV Key flex
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

Line 1369: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name

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

Line 1386: per_ri_config_utilities.create_flex_segments

1382:
1383: -- Create Jobs Key Flex Segments
1384: l_jobs_segment_count := csr_config_jobs_rv_seg%ROWCOUNT;
1385: if NOT (p_technical_summary_mode) then
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

Line 1412: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1408: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).segment_type := l_rv_jobs_segment_type;
1409: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).window_prompt := l_rv_jobs_segment_name;
1410:
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

Line 1447: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_jobs_segment_name);

1443: := l_kf_job_rv_valueset_tab(l_value_set_tab_count).max_value;
1444: l_kf_job_rv_seg_count := l_kf_job_rv_seg_count + 1 ;
1445: end if;
1446:
1447: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_jobs_segment_name);
1448: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_jobs_segment_name);
1449: END LOOP;
1450: --
1451: -- freeze and compile this flexfield

Line 1454: per_ri_config_utilities.freeze_and_compile_flexfield

1450: --
1451: -- freeze and compile this flexfield
1452: --
1453: if NOT (p_technical_summary_mode) then
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);

Line 1490: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),

1486: ,p_kf_pos_rv_seg_tab in out nocopy
1487: per_ri_config_tech_summary.kf_pos_rv_seg_tab) IS
1488:
1489: cursor csr_config_positions_rv (cp_configuration_code in varchar2) IS
1490: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1491: regional_variance_name
1492: from per_ri_config_jp_rv_v
1493: where configuration_code = cp_configuration_code
1494: and exists (select configuration_code

Line 1541: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield

1537:
1538: hr_utility.set_location(l_proc, 20);
1539: -- Create Jobs RV Key flex
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

Line 1558: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name

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 );
1560: hr_utility.trace('Created Positions RV Keyflex ' || l_positions_rv_name
1561: || per_ri_config_main.g_pos_rv_struct_def_string);
1562:

Line 1575: per_ri_config_utilities.create_flex_segments

1571:
1572: -- Create Jobs Key Flex Segments
1573: l_positions_segment_count := csr_config_positions_rv_seg%ROWCOUNT;
1574: if NOT (p_technical_summary_mode) then
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

Line 1602: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1598: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).segment_type := l_rv_positions_segment_type;
1599: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).window_prompt := l_rv_positions_segment_name;
1600:
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

Line 1636: per_ri_config_utilities.write_log(p_message => 'Created Positions Key Flex RV Segment' || l_rv_positions_segment_name);

1632: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).vs_max_value
1633: := l_kf_pos_rv_valueset_tab(l_value_set_tab_count).max_value;
1634: l_kf_pos_rv_seg_count := l_kf_pos_rv_seg_count + 1 ;
1635: end if;
1636: per_ri_config_utilities.write_log(p_message => 'Created Positions Key Flex RV Segment' || l_rv_positions_segment_name);
1637: hr_utility.trace('Created Positions Key Flex RV Segment: ' || l_rv_positions_segment_name);
1638: END LOOP;
1639: --
1640: -- freeze and compile this flexfield

Line 1643: per_ri_config_utilities.freeze_and_compile_flexfield

1639: --
1640: -- freeze and compile this flexfield
1641: --
1642: if NOT (p_technical_summary_mode) then
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);

Line 1679: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),

1675: ,p_kf_grd_rv_seg_tab in out nocopy
1676: per_ri_config_tech_summary.kf_grd_rv_seg_tab) IS
1677:
1678: cursor csr_config_grade_rv (cp_configuration_code in varchar2) IS
1679: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1680: regional_variance_name
1681: from per_ri_config_grd_rv_v
1682: where configuration_code = cp_configuration_code;
1683:

Line 1728: per_ri_config_utilities.create_key_flexfield

1724: -- Create Grades RV Key Flex
1725: hr_utility.set_location(l_proc, 20);
1726: if NOT (p_technical_summary_mode) then
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

Line 1745: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '

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

Line 1761: per_ri_config_utilities.create_flex_segments

1757:
1758: -- Create Jobs Key Flex Segments
1759: l_grades_segment_count := csr_config_grade_rv_seg%ROWCOUNT;
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

Line 1786: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1782: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).segment_type := l_rv_grade_segment_type;
1783: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).window_prompt := l_rv_grade_segment_name;
1784:
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

Line 1820: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_grade_segment_name);

1816: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).vs_max_value
1817: := l_kf_grd_rv_valueset_tab(l_value_set_tab_count).max_value;
1818: l_kf_grd_rv_seg_count := l_kf_grd_rv_seg_count + 1 ;
1819: end if;
1820: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_grade_segment_name);
1821: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_grade_segment_name);
1822: END LOOP;
1823: close csr_config_grade_rv_seg;
1824: --

Line 1828: per_ri_config_utilities.freeze_and_compile_flexfield

1824: --
1825: -- freeze and compile this flexfield
1826: --
1827: if NOT (p_technical_summary_mode) then
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);

Line 1911: l_people_group_fk_number := per_ri_config_utilities.create_key_flexfield

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'
1914: ,p_structure_code => l_grp_structures_code
1915: ,p_structure_title => l_grp_structures_code

Line 1932: per_ri_config_utilities.create_flex_segments

1928: --
1929: -- create people group flex segments
1930: --
1931: if NOT (p_technical_summary_mode) then
1932: per_ri_config_utilities.create_flex_segments
1933: (p_appl_short_Name => 'PAY'
1934: ,p_flex_code => 'GRP'
1935: ,p_structure_code => l_grp_structures_code
1936: ,p_segment_name => 'People Group Name'

Line 1956: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1952: p_kf_grp_seg_tab(l_kf_grp_seg_count).segment_type := null;
1953: p_kf_grp_seg_tab(l_kf_grp_seg_count).window_prompt := 'People Group';
1954:
1955: --create technical summary data for valueset
1956: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1957: ,p_valueset_type => null
1958: ,p_structure_code => l_grp_structures_code
1959: ,p_segment_name => 'People Group Name'
1960: ,p_segment_number => 1

Line 1997: per_ri_config_utilities.freeze_and_compile_flexfield

1993: --
1994: -- freeze and compile this flexfield
1995: --
1996: if NOT (p_technical_summary_mode) then
1997: per_ri_config_utilities.freeze_and_compile_flexfield
1998: (p_appl_short_Name => 'PAY'
1999: ,p_flex_code => 'GRP'
2000: ,p_structure_code => l_grp_structures_code);
2001: end if;

Line 2010: l_competence_fk_number := per_ri_config_utilities.create_key_flexfield

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'
2013: ,p_structure_code => l_cmp_structures_code
2014: ,p_structure_title => l_cmp_structures_code

Line 2031: per_ri_config_utilities.create_flex_segments

2027: --
2028: -- create competence flex segments
2029: --
2030: if NOT (p_technical_summary_mode) then
2031: per_ri_config_utilities.create_flex_segments
2032: (p_appl_short_Name => 'PER'
2033: ,p_flex_code => 'CMP'
2034: ,p_structure_code => l_cmp_structures_code
2035: ,p_segment_name => 'Competence Name'

Line 2054: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2050: p_kf_cmp_seg_tab(l_kf_cmp_seg_count).segment_type := null;
2051: p_kf_cmp_seg_tab(l_kf_cmp_seg_count).window_prompt := 'Competence Name';
2052:
2053: --create technical summary data for valueset
2054: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2055: ,p_valueset_type => null
2056: ,p_structure_code => l_cmp_structures_code
2057: ,p_segment_name => 'Competence Name'
2058: ,p_segment_number => 1

Line 2094: per_ri_config_utilities.freeze_and_compile_flexfield

2090: --
2091: -- freeze and compile this flexfield
2092: --
2093: if NOT (p_technical_summary_mode) then
2094: per_ri_config_utilities.freeze_and_compile_flexfield
2095: (p_appl_short_Name => 'PER'
2096: ,p_flex_code => 'CMP'
2097: ,p_structure_code => l_cmp_structures_code);
2098: end if;

Line 2105: l_cost_allocation_number := per_ri_config_utilities.create_key_flexfield

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'
2108: ,p_structure_code => l_cost_structures_code
2109: ,p_structure_title => l_cost_structures_code

Line 2126: per_ri_config_utilities.create_flex_segments

2122: --
2123: -- create cost allocation flex segments
2124: --
2125: if NOT (p_technical_summary_mode) then
2126: per_ri_config_utilities.create_flex_segments
2127: (p_appl_short_Name => 'PAY'
2128: ,p_flex_code => 'COST'
2129: ,p_structure_code => l_cost_structures_code
2130: ,p_segment_name => 'Account'

Line 2149: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2145: p_kf_cost_seg_tab(l_kf_cost_seg_count).segment_type := null;
2146: p_kf_cost_seg_tab(l_kf_cost_seg_count).window_prompt := 'Account';
2147:
2148: --create technical summary data for valueset
2149: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2150: ,p_valueset_type => null
2151: ,p_structure_code => l_cost_structures_code
2152: ,p_segment_name => 'Account'
2153: ,p_segment_number => 1

Line 2185: per_ri_config_utilities.create_flex_segments

2181: hr_utility.trace('ENABLELONGLIST := ' || l_kf_cost_valueset_tab(l_value_set_tab_count).enable_longlist);
2182: end if;
2183:
2184: if NOT (p_technical_summary_mode) then
2185: per_ri_config_utilities.create_flex_segments
2186: (p_appl_short_Name => 'PAY'
2187: ,p_flex_code => 'COST'
2188: ,p_structure_code => l_cost_structures_code
2189: ,p_segment_name => 'Company'

Line 2208: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2204: p_kf_cost_seg_tab(l_kf_cost_seg_count).segment_type := null;
2205: p_kf_cost_seg_tab(l_kf_cost_seg_count).window_prompt := 'Company';
2206:
2207: --create technical summary data for valueset
2208: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2209: ,p_valueset_type => null
2210: ,p_structure_code => l_cost_structures_code
2211: ,p_segment_name => 'Company'
2212: ,p_segment_number => 2

Line 2243: per_ri_config_utilities.create_flex_segments

2239: l_kf_cost_seg_count := l_kf_cost_seg_count + 1 ;
2240: end if;
2241:
2242: if NOT (p_technical_summary_mode) then
2243: per_ri_config_utilities.create_flex_segments
2244: (p_appl_short_Name => 'PAY'
2245: ,p_flex_code => 'COST'
2246: ,p_structure_code => l_cost_structures_code
2247: ,p_segment_name => 'Cost Center'

Line 2267: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2263: p_kf_cost_seg_tab(l_kf_cost_seg_count).segment_type := null;
2264: p_kf_cost_seg_tab(l_kf_cost_seg_count).window_prompt := 'Cost Center';
2265:
2266: --create technical summary data for valueset
2267: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2268: ,p_valueset_type => null
2269: ,p_structure_code => l_cost_structures_code
2270: ,p_segment_name => 'Cost Center'
2271: ,p_segment_number => 3

Line 2305: per_ri_config_utilities.freeze_and_compile_flexfield

2301: --
2302: -- freeze and compile this flexfield
2303: --
2304: if NOT (p_technical_summary_mode) then
2305: per_ri_config_utilities.freeze_and_compile_flexfield
2306: (p_appl_short_Name => 'PAY'
2307: ,p_flex_code => 'COST'
2308: ,p_structure_code => l_cost_structures_code);
2309: end if;

Line 2369: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);

2365:
2366: BEGIN
2367: hr_utility.set_location('Entering:'|| l_proc, 10);
2368:
2369: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
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

Line 2373: l_job_structures_code := per_ri_config_utilities.return_config_entity_name

2369: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
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

Line 2378: l_jobs_fk_number := per_ri_config_utilities.create_key_flexfield

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
2379: (p_appl_short_name => 'PER'
2380: ,p_flex_code => 'JOB'
2381: ,p_structure_code => l_job_structures_code
2382: ,p_structure_title => l_job_structures_code

Line 2395: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

2391: p_kf_job_tab(l_kf_job_count).description := l_job_structures_code;
2392: l_kf_job_count := l_kf_job_count + 1 ;
2393: end if;
2394:
2395: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
2396: (p_configuration_code => p_configuration_code);
2397:
2398: l_log_message := 'Created KEYFLEX PER JOB ' || l_job_structures_code;
2399: per_ri_config_utilities.write_log(p_message => l_log_message);

Line 2399: per_ri_config_utilities.write_log(p_message => l_log_message);

2395: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
2396: (p_configuration_code => p_configuration_code);
2397:
2398: l_log_message := 'Created KEYFLEX PER JOB ' || l_job_structures_code;
2399: per_ri_config_utilities.write_log(p_message => l_log_message);
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

Line 2403: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name

2399: per_ri_config_utilities.write_log(p_message => l_log_message);
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'

Line 2406: l_position_fk_number := per_ri_config_utilities.create_key_flexfield

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'
2409: ,p_structure_code => l_pos_structures_code
2410: ,p_structure_title => l_pos_structures_code

Line 2423: per_ri_config_utilities.write_log(p_message => l_log_message);

2419: end if;
2420:
2421:
2422: l_log_message := 'Created KEYFLEX PER POS ' || l_pos_structures_code;
2423: per_ri_config_utilities.write_log(p_message => l_log_message);
2424:
2425: hr_utility.set_location(l_proc, 40);
2426:
2427: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then

Line 2433: per_ri_config_utilities.create_flex_segments

2429:
2430: -- Create Jobs Key Flex Segments
2431:
2432: if NOT (p_technical_summary_mode) then
2433: per_ri_config_utilities.create_flex_segments
2434: (p_appl_short_Name => 'PER'
2435: ,p_flex_code => 'JOB'
2436: ,p_structure_code => l_job_structures_code
2437: ,p_segment_name => 'Job Name'

Line 2456: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2452: p_kf_job_seg_tab(l_kf_job_seg_count).segment_type := null;
2453: p_kf_job_seg_tab(l_kf_job_seg_count).window_prompt := 'Job Name';
2454:
2455: --create technical summary data for valueset
2456: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2457: ,p_valueset_type => null
2458: ,p_structure_code => l_job_structures_code
2459: ,p_segment_name => 'Job Name'
2460: ,p_segment_number => 1

Line 2491: per_ri_config_utilities.write_log(p_message => l_log_message);

2487: l_kf_job_seg_count := l_kf_job_seg_count + 1 ;
2488: end if;
2489:
2490: l_log_message := 'Created KEYFLEX SEGMENT : PER JOB ' || 'Job Name';
2491: per_ri_config_utilities.write_log(p_message => l_log_message);
2492:
2493: -- Create Position Key Flex Segments
2494: if NOT (p_technical_summary_mode) then
2495: per_ri_config_utilities.create_flex_segments

Line 2495: per_ri_config_utilities.create_flex_segments

2491: per_ri_config_utilities.write_log(p_message => l_log_message);
2492:
2493: -- Create Position Key Flex Segments
2494: if NOT (p_technical_summary_mode) then
2495: per_ri_config_utilities.create_flex_segments
2496: (p_appl_short_Name => 'PER'
2497: ,p_flex_code => 'POS'
2498: ,p_structure_code => l_pos_structures_code
2499: ,p_segment_name => 'Position Name'

Line 2518: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2514: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := null;
2515: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Position Name';
2516:
2517: --create technical summary data for valueset
2518: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2519: ,p_valueset_type => null
2520: ,p_structure_code => l_pos_structures_code
2521: ,p_segment_name => 'Position Name'
2522: ,p_segment_number => 1

Line 2553: per_ri_config_utilities.write_log(p_message => l_log_message);

2549: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2550: end if;
2551:
2552: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_structures_code;
2553: per_ri_config_utilities.write_log(p_message => l_log_message);
2554:
2555: hr_utility.set_location(l_proc, 60);
2556: else
2557: hr_utility.set_location(l_proc, 70);

Line 2563: per_ri_config_utilities.create_flex_segments

2559:
2560: -- create only federal job segments with specified value segment name valuesets.
2561: -- First Segment 'Name' valueset '60 Characters'
2562: if NOT (p_technical_summary_mode) then
2563: per_ri_config_utilities.create_flex_segments
2564: (p_appl_short_Name => 'PER'
2565: ,p_flex_code => 'JOB'
2566: ,p_structure_code => l_job_structures_code
2567: ,p_segment_name => 'Name'

Line 2589: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2585: p_kf_job_seg_tab(l_kf_job_seg_count).segment_type := 'Char';
2586: p_kf_job_seg_tab(l_kf_job_seg_count).window_prompt := 'Name';
2587:
2588: --create technical summary data for valueset
2589: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2590: ,p_valueset_type => 'Char'
2591: ,p_structure_code => l_job_structures_code
2592: ,p_segment_name => 'Name'
2593: ,p_segment_number => 1

Line 2626: per_ri_config_utilities.create_flex_segments

2622:
2623: -- create only federal position segments with specified value segment name valuesets.
2624: -- First Segment
2625: if NOT (p_technical_summary_mode) then
2626: per_ri_config_utilities.create_flex_segments
2627: (p_appl_short_Name => 'PER'
2628: ,p_flex_code => 'POS'
2629: ,p_structure_code => l_pos_structures_code
2630: ,p_segment_name => 'Position Title'

Line 2652: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'

2648: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
2649: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Position Title';
2650:
2651: --create technical summary data for valueset
2652: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'
2653: ,p_valueset_type => 'Char'
2654: ,p_structure_code => l_pos_structures_code
2655: ,p_segment_name => 'Position Title'
2656: ,p_segment_number => 1

Line 2687: per_ri_config_utilities.write_log(p_message => l_log_message);

2683: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2684: end if;
2685:
2686: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Position Title';
2687: per_ri_config_utilities.write_log(p_message => l_log_message);
2688:
2689: -- Second Segment
2690: if NOT (p_technical_summary_mode) then
2691: per_ri_config_utilities.create_flex_segments

Line 2691: per_ri_config_utilities.create_flex_segments

2687: per_ri_config_utilities.write_log(p_message => l_log_message);
2688:
2689: -- Second Segment
2690: if NOT (p_technical_summary_mode) then
2691: per_ri_config_utilities.create_flex_segments
2692: (p_appl_short_Name => 'PER'
2693: ,p_flex_code => 'POS'
2694: ,p_structure_code => l_pos_structures_code
2695: ,p_segment_name => 'Description'

Line 2716: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POS_DESC_NUM'

2712: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
2713: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Description';
2714:
2715: --create technical summary data for valueset
2716: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POS_DESC_NUM'
2717: ,p_valueset_type => 'Char'
2718: ,p_structure_code => l_pos_structures_code
2719: ,p_segment_name => 'Description'
2720: ,p_segment_number => 2

Line 2751: per_ri_config_utilities.write_log(p_message => l_log_message);

2747: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2748: end if;
2749:
2750: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Description';
2751: per_ri_config_utilities.write_log(p_message => l_log_message);
2752:
2753: -- Third Segment
2754: if NOT (p_technical_summary_mode) then
2755: per_ri_config_utilities.create_flex_segments

Line 2755: per_ri_config_utilities.create_flex_segments

2751: per_ri_config_utilities.write_log(p_message => l_log_message);
2752:
2753: -- Third Segment
2754: if NOT (p_technical_summary_mode) then
2755: per_ri_config_utilities.create_flex_segments
2756: (p_appl_short_Name => 'PER'
2757: ,p_flex_code => 'POS'
2758: ,p_structure_code => l_pos_structures_code
2759: ,p_segment_name => 'Sequence'

Line 2780: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_SEQUENCE_NUM'

2776: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
2777: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Sequence';
2778:
2779: --create technical summary data for valueset
2780: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_SEQUENCE_NUM'
2781: ,p_valueset_type => 'Char'
2782: ,p_structure_code => l_pos_structures_code
2783: ,p_segment_name => 'Sequence'
2784: ,p_segment_number => 3

Line 2815: per_ri_config_utilities.write_log(p_message => l_log_message);

2811: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2812: end if;
2813:
2814: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
2815: per_ri_config_utilities.write_log(p_message => l_log_message);
2816: -- Fourth Segment
2817: if NOT (p_technical_summary_mode) then
2818: per_ri_config_utilities.create_flex_segments
2819: (p_appl_short_Name => 'PER'

Line 2818: per_ri_config_utilities.create_flex_segments

2814: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
2815: per_ri_config_utilities.write_log(p_message => l_log_message);
2816: -- Fourth Segment
2817: if NOT (p_technical_summary_mode) then
2818: per_ri_config_utilities.create_flex_segments
2819: (p_appl_short_Name => 'PER'
2820: ,p_flex_code => 'POS'
2821: ,p_structure_code => l_pos_structures_code
2822: ,p_segment_name => 'Agency Code'

Line 2843: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_AGENCY_CODE'

2839: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
2840: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Agency Code';
2841:
2842: --create technical summary data for valueset
2843: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_AGENCY_CODE'
2844: ,p_valueset_type => 'Char'
2845: ,p_structure_code => l_pos_structures_code
2846: ,p_segment_name => 'Agency Code'
2847: ,p_segment_number => 4

Line 2878: per_ri_config_utilities.write_log(p_message => l_log_message);

2874: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2875: end if;
2876:
2877: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
2878: per_ri_config_utilities.write_log(p_message => l_log_message);
2879: hr_utility.set_location(l_proc, 90);
2880: end if;
2881:
2882: --

Line 2886: per_ri_config_utilities.freeze_and_compile_flexfield

2882: --
2883: -- freeze and compile this flexfield
2884: --
2885: if NOT (p_technical_summary_mode) then
2886: per_ri_config_utilities.freeze_and_compile_flexfield
2887: (p_appl_short_Name => 'PER'
2888: ,p_flex_code => 'JOB'
2889: ,p_structure_code => l_job_structures_code);
2890: end if;

Line 2896: per_ri_config_utilities.freeze_and_compile_flexfield

2892: --
2893: -- freeze and compile this flexfield
2894: --
2895: if NOT (p_technical_summary_mode) then
2896: per_ri_config_utilities.freeze_and_compile_flexfield
2897: (p_appl_short_Name => 'PER'
2898: ,p_flex_code => 'POS'
2899: ,p_structure_code => l_pos_structures_code);
2900: end if;

Line 2951: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);

2947:
2948: BEGIN
2949: hr_utility.set_location('Entering:'|| l_proc, 10);
2950:
2951: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
2952:
2953: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
2954: (p_configuration_code => p_configuration_code);
2955:

Line 2953: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

2949: hr_utility.set_location('Entering:'|| l_proc, 10);
2950:
2951: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
2952:
2953: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
2954: (p_configuration_code => p_configuration_code);
2955:
2956: -- Create Position Key flex
2957: hr_utility.set_location(l_proc, 20);

Line 2959: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name

2955:
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'

Line 2962: l_position_fk_number := per_ri_config_utilities.create_key_flexfield

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'
2965: ,p_structure_code => l_pos_structures_code
2966: ,p_structure_title => l_pos_structures_code

Line 2978: per_ri_config_utilities.write_log(p_message => l_log_message);

2974: l_kf_pos_count := l_kf_pos_count + 1 ;
2975: end if;
2976:
2977: l_log_message := 'Created KEYFLEX PER POS ' || l_pos_structures_code;
2978: per_ri_config_utilities.write_log(p_message => l_log_message);
2979:
2980: hr_utility.set_location(l_proc, 30);
2981:
2982: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then

Line 2987: per_ri_config_utilities.create_flex_segments

2983: hr_utility.set_location(l_proc, 50);
2984:
2985: -- Create Position Key Flex Segments
2986: if NOT (p_technical_summary_mode) then
2987: per_ri_config_utilities.create_flex_segments
2988: (p_appl_short_Name => 'PER'
2989: ,p_flex_code => 'POS'
2990: ,p_structure_code => l_pos_structures_code
2991: ,p_segment_name => 'Position Name'

Line 3010: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

3006: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := null;
3007: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Position Name';
3008:
3009: --create technical summary data for valueset
3010: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
3011: ,p_valueset_type => null
3012: ,p_structure_code => l_pos_structures_code
3013: ,p_segment_name => 'Position Name'
3014: ,p_segment_number => 1

Line 3045: per_ri_config_utilities.write_log(p_message => l_log_message);

3041: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3042: end if;
3043:
3044: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_structures_code;
3045: per_ri_config_utilities.write_log(p_message => l_log_message);
3046:
3047: hr_utility.set_location(l_proc, 60);
3048: else
3049: hr_utility.set_location(l_proc, 70);

Line 3055: per_ri_config_utilities.create_flex_segments

3051:
3052: -- create only federal position segments with specified value segment name valuesets.
3053: -- First Segment
3054: if NOT (p_technical_summary_mode) then
3055: per_ri_config_utilities.create_flex_segments
3056: (p_appl_short_Name => 'PER'
3057: ,p_flex_code => 'POS'
3058: ,p_structure_code => l_pos_structures_code
3059: ,p_segment_name => 'Position Title'

Line 3080: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'

3076: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
3077: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Position Title';
3078:
3079: --create technical summary data for valueset
3080: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'
3081: ,p_valueset_type => 'Char'
3082: ,p_structure_code => l_pos_structures_code
3083: ,p_segment_name => 'Position Title'
3084: ,p_segment_number => 1

Line 3115: per_ri_config_utilities.write_log(p_message => l_log_message);

3111: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3112: end if;
3113:
3114: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Position Title';
3115: per_ri_config_utilities.write_log(p_message => l_log_message);
3116:
3117: -- Second Segment
3118: if NOT (p_technical_summary_mode) then
3119: per_ri_config_utilities.create_flex_segments

Line 3119: per_ri_config_utilities.create_flex_segments

3115: per_ri_config_utilities.write_log(p_message => l_log_message);
3116:
3117: -- Second Segment
3118: if NOT (p_technical_summary_mode) then
3119: per_ri_config_utilities.create_flex_segments
3120: (p_appl_short_Name => 'PER'
3121: ,p_flex_code => 'POS'
3122: ,p_structure_code => l_pos_structures_code
3123: ,p_segment_name => 'Description'

Line 3144: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POS_DESC_NUM'

3140: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
3141: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Description';
3142:
3143: --create technical summary data for valueset
3144: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POS_DESC_NUM'
3145: ,p_valueset_type => 'Char'
3146: ,p_structure_code => l_pos_structures_code
3147: ,p_segment_name => 'Description'
3148: ,p_segment_number => 2

Line 3179: per_ri_config_utilities.write_log(p_message => l_log_message);

3175: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3176: end if;
3177:
3178: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Description';
3179: per_ri_config_utilities.write_log(p_message => l_log_message);
3180:
3181: -- Third Segment
3182: if NOT (p_technical_summary_mode) then
3183: per_ri_config_utilities.create_flex_segments

Line 3183: per_ri_config_utilities.create_flex_segments

3179: per_ri_config_utilities.write_log(p_message => l_log_message);
3180:
3181: -- Third Segment
3182: if NOT (p_technical_summary_mode) then
3183: per_ri_config_utilities.create_flex_segments
3184: (p_appl_short_Name => 'PER'
3185: ,p_flex_code => 'POS'
3186: ,p_structure_code => l_pos_structures_code
3187: ,p_segment_name => 'Sequence'

Line 3209: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_SEQUENCE_NUM'

3205: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
3206: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Sequence';
3207:
3208: --create technical summary data for valueset
3209: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_SEQUENCE_NUM'
3210: ,p_valueset_type => 'Char'
3211: ,p_structure_code => l_pos_structures_code
3212: ,p_segment_name => 'Sequence'
3213: ,p_segment_number => 3

Line 3243: per_ri_config_utilities.write_log(p_message => l_log_message);

3239: := l_kf_pos_valueset_tab(l_value_set_tab_count).max_value;
3240: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3241: end if;
3242: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
3243: per_ri_config_utilities.write_log(p_message => l_log_message);
3244: -- Fourth Segment
3245: if NOT (p_technical_summary_mode) then
3246: per_ri_config_utilities.create_flex_segments
3247: (p_appl_short_Name => 'PER'

Line 3246: per_ri_config_utilities.create_flex_segments

3242: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
3243: per_ri_config_utilities.write_log(p_message => l_log_message);
3244: -- Fourth Segment
3245: if NOT (p_technical_summary_mode) then
3246: per_ri_config_utilities.create_flex_segments
3247: (p_appl_short_Name => 'PER'
3248: ,p_flex_code => 'POS'
3249: ,p_structure_code => l_pos_structures_code
3250: ,p_segment_name => 'Agency Code'

Line 3271: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_AGENCY_CODE'

3267: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
3268: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Agency Code';
3269:
3270: --create technical summary data for valueset
3271: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_AGENCY_CODE'
3272: ,p_valueset_type => 'Char'
3273: ,p_structure_code => l_pos_structures_code
3274: ,p_segment_name => 'Agency Code'
3275: ,p_segment_number => 4

Line 3306: per_ri_config_utilities.write_log(p_message => l_log_message);

3302: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3303: end if;
3304:
3305: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
3306: per_ri_config_utilities.write_log(p_message => l_log_message);
3307: hr_utility.set_location(l_proc, 90);
3308: end if;
3309:
3310: --

Line 3313: per_ri_config_utilities.freeze_and_compile_flexfield

3309:
3310: --
3311: -- freeze and compile this flexfield
3312: --
3313: per_ri_config_utilities.freeze_and_compile_flexfield
3314: (p_appl_short_Name => 'PER'
3315: ,p_flex_code => 'POS'
3316: ,p_structure_code => l_pos_structures_code);
3317:

Line 3365: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

3361:
3362: BEGIN
3363: hr_utility.set_location('Entering:'|| l_proc, 10);
3364:
3365: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3366: (p_configuration_code => p_configuration_code);
3367:
3368: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3369:

Line 3368: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);

3364:
3365: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3366: (p_configuration_code => p_configuration_code);
3367:
3368: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3369:
3370: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
3371: hr_utility.set_location(l_proc, 20);
3372: -- Create Grade Key Flex

Line 3373: l_grd_structures_code := per_ri_config_utilities.return_config_entity_name

3369:
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'

Line 3376: l_grade_number := per_ri_config_utilities.create_key_flexfield

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'
3379: ,p_structure_code => l_grd_structures_code
3380: ,p_structure_title => l_grd_structures_code

Line 3393: per_ri_config_utilities.write_log(p_message => l_log_message);

3389:
3390: l_kf_grd_count := l_kf_grd_count + 1 ;
3391: end if;
3392: l_log_message := 'Created KEYFLEX PER GRD ' || l_grd_structures_code;
3393: per_ri_config_utilities.write_log(p_message => l_log_message);
3394:
3395: -- Create Grade Key Flex Segments
3396: if NOT (p_technical_summary_mode) then
3397: per_ri_config_utilities.create_flex_segments

Line 3397: per_ri_config_utilities.create_flex_segments

3393: per_ri_config_utilities.write_log(p_message => l_log_message);
3394:
3395: -- Create Grade Key Flex Segments
3396: if NOT (p_technical_summary_mode) then
3397: per_ri_config_utilities.create_flex_segments
3398: (p_appl_short_Name => 'PER'
3399: ,p_flex_code => 'GRD'
3400: ,p_structure_code => l_grd_structures_code
3401: ,p_segment_name => 'Grade'

Line 3420: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

3416: p_kf_grd_seg_tab(l_kf_grd_seg_count).segment_type := 'Grade';
3417: p_kf_grd_seg_tab(l_kf_grd_seg_count).window_prompt := 'Grade';
3418:
3419: --create technical summary data for valueset
3420: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
3421: ,p_valueset_type => null
3422: ,p_structure_code => l_grd_structures_code
3423: ,p_segment_name => 'Grade'
3424: ,p_segment_number => 1

Line 3456: per_ri_config_utilities.write_log(p_message => l_log_message);

3452: l_kf_grd_seg_count := l_kf_grd_seg_count + 1 ;
3453: end if;
3454:
3455: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || 'Grade';
3456: per_ri_config_utilities.write_log(p_message => l_log_message);
3457:
3458: if NOT (p_technical_summary_mode) then
3459: per_ri_config_utilities.create_flex_segments
3460: (p_appl_short_Name => 'PER'

Line 3459: per_ri_config_utilities.create_flex_segments

3455: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || 'Grade';
3456: per_ri_config_utilities.write_log(p_message => l_log_message);
3457:
3458: if NOT (p_technical_summary_mode) then
3459: per_ri_config_utilities.create_flex_segments
3460: (p_appl_short_Name => 'PER'
3461: ,p_flex_code => 'GRD'
3462: ,p_structure_code => l_grd_structures_code
3463: ,p_segment_name => 'Level'

Line 3482: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

3478: p_kf_grd_seg_tab(l_kf_grd_seg_count).segment_type := 'Level';
3479: p_kf_grd_seg_tab(l_kf_grd_seg_count).window_prompt := 'Level';
3480:
3481: --create technical summary data for valueset
3482: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
3483: ,p_valueset_type => null
3484: ,p_structure_code => l_grd_structures_code
3485: ,p_segment_name => 'Level'
3486: ,p_segment_number => 2

Line 3518: per_ri_config_utilities.write_log(p_message => l_log_message);

3514: l_kf_grd_seg_count := l_kf_grd_seg_count + 1 ;
3515: end if;
3516:
3517: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || 'Level';
3518: per_ri_config_utilities.write_log(p_message => l_log_message);
3519: --
3520: -- freeze and compile this flexfield
3521: --
3522: if NOT (p_technical_summary_mode) then

Line 3523: per_ri_config_utilities.freeze_and_compile_flexfield

3519: --
3520: -- freeze and compile this flexfield
3521: --
3522: if NOT (p_technical_summary_mode) then
3523: per_ri_config_utilities.freeze_and_compile_flexfield
3524: (p_appl_short_Name => 'PER'
3525: ,p_flex_code => 'GRD'
3526: ,p_structure_code => l_grd_structures_code);
3527: end if;

Line 3594: per_ri_config_utilities.write_log(p_message => l_log_message);

3590: ,right_justify_zero_fill => l_right_justify_zero_fill
3591: ,min_value => l_min_value
3592: ,max_value => l_max_value);
3593: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_GRADES';
3594: per_ri_config_utilities.write_log(p_message => l_log_message);
3595: end if;
3596: hr_utility.set_location(l_proc, 30);
3597: -- Create PER_RI_DEFAULT_GRADES
3598: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_LEVELS');

Line 3723: and country_code in (select per_ri_config_utilities.business_group_decision

3719: from per_ri_config_country_v
3720: where configuration_code = cp_configuration_code
3721: and country_code in (select distinct territory_code
3722: from per_ri_config_responsibility)
3723: and country_code in (select per_ri_config_utilities.business_group_decision
3724: (cp_configuration_code
3725: ,country_code)
3726: from per_ri_config_country_v where configuration_code = cp_configuration_code);
3727:

Line 3766: and per_ri_config_utilities.business_group_decision

3762: from per_ri_config_country_v con
3763: where con.configuration_code = cp_configuration_code
3764: and con.country_code not in (select distinct territory_code
3765: from per_ri_config_responsibility)
3766: and per_ri_config_utilities.business_group_decision
3767: (cp_configuration_code
3768: ,country_code) <> 'INT' ;
3769:
3770: l_proc varchar2(72) := g_package || 'create_hrms_responsibility';

Line 3808: l_configuration_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre

3804: BEGIN
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

Line 3913: := per_ri_config_utilities.determine_country_resp

3909: fetch csr_get_country into l_country_code;
3910: exit when csr_get_country%NOTFOUND;
3911:
3912: l_assign_determined_resp
3913: := per_ri_config_utilities.determine_country_resp
3914: (p_country_code => l_country_code
3915: ,p_assign_responsibility => l_assign_responsibility);
3916:
3917: hr_utility.trace('l_assign_responsibility = ' || l_assign_responsibility);

Line 3949: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name

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

Line 4041: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name

4037: hr_utility.trace('Assigned Global Responsibility:' || l_assign_global_resp_key );
4038:
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

Line 4095: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name

4091: ,p_technical_summary_mode => p_technical_summary_mode
4092: ,p_profile_resp_tab => l_profile_resp_main_tab);
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');

Line 4158: per_ri_config_utilities.set_profile_option_value

4154: -- ENABLE_SECURITY_GROUPS
4155: if l_product_name in ('PER','PAY','BEN') then
4156: hr_utility.trace('l_product_name ' || l_product_name);
4157: if NOT (p_technical_summary_mode) then
4158: per_ri_config_utilities.set_profile_option_value
4159: (p_level => 10002
4160: ,p_level_value => l_product_name
4161: ,p_level_value_app => l_product_name
4162: ,p_profile_name => 'ENABLE_SECURITY_GROUPS'

Line 4176: per_ri_config_utilities.write_log(p_message => l_log_message);

4172:
4173: end if;
4174:
4175: l_log_message := 'Created PROFILE_OPTION ENABLE_SECURITY_GROUPS ' || l_product_name;
4176: per_ri_config_utilities.write_log(p_message => l_log_message);
4177: end if;
4178: ** */
4179: end loop;
4180: close csr_get_product;

Line 4204: per_ri_config_utilities.write_log(p_message => l_log_message);

4200: else
4201: l_log_message := 'The profile setting has errored out for application '
4202: || rec.application_id;
4203: end if;
4204: per_ri_config_utilities.write_log(p_message => l_log_message);
4205: hr_utility.trace(l_log_message);
4206: end loop;
4207: --
4208: */

Line 4285: per_ri_config_utilities.set_profile_option_value

4281:
4282: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4283: hr_utility.trace('l_hr_user_type ' || l_hr_user_type);
4284: if NOT (p_technical_summary_mode) then
4285: per_ri_config_utilities.set_profile_option_value
4286: (p_level => 10003
4287: ,p_level_value => p_responsibility_key
4288: ,p_level_value_app => l_application_short_name
4289: ,p_profile_name => 'HR_USER_TYPE'

Line 4407: per_ri_config_utilities.write_log(p_message => l_log_message);

4403: '800') then
4404: null;
4405: end if;
4406: l_log_message := 'Created Profile Option Value PER_BUSINESS_GROUP_ID ' || l_bg_id;
4407: per_ri_config_utilities.write_log(p_message => l_log_message);
4408: hr_utility.set_location(l_proc, 20);
4409:
4410: --
4411: -- Create PER_SECURITY_PROFILE_ID

Line 4421: per_ri_config_utilities.write_log(p_message => l_log_message);

4417: '800') then
4418: null;
4419: end if;
4420: l_log_message := 'Created Profile Option Value PER_SECURITY_PROFILE_ID ' || l_sg_id;
4421: per_ri_config_utilities.write_log(p_message => l_log_message);
4422: hr_utility.set_location(l_proc, 30);
4423:
4424: open csr_get_product(p_configuration_code);
4425: loop

Line 4453: per_ri_config_utilities.write_log(p_message => l_log_message);

4449: '800') then
4450: null;
4451: end if;
4452: l_log_message := 'Created Profile Option Value HR_USER_TYPE ' || l_hr_user_type;
4453: per_ri_config_utilities.write_log(p_message => l_log_message);
4454: hr_utility.set_location(' Leaving:'|| l_proc, 50);
4455:
4456: else
4457: hr_utility.set_location(l_proc, 110);