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, rv.REG_VARIANCE_COUNTRY_CODE
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 1371: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield

1367: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1368: ELSE
1369: -- Create Jobs RV Key flex
1370: if NOT (p_technical_summary_mode) then
1371: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield
1372: (p_appl_short_Name => 'PER'
1373: ,p_flex_code => 'JOB'
1374: ,p_structure_code => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string
1375: ,p_structure_title => l_jobs_rv_name || per_ri_config_main.g_job_rv_struct_def_string

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

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

Line 1405: per_ri_config_utilities.create_flex_segments

1401:
1402: -- Create Jobs Key Flex Segments
1403: l_jobs_segment_count := csr_config_jobs_rv_seg%ROWCOUNT;
1404: if NOT (p_technical_summary_mode) then
1405: per_ri_config_utilities.create_flex_segments
1406: (p_appl_short_Name => 'PER'
1407: ,p_flex_code => 'JOB'
1408: ,p_structure_code => l_jobs_rv_name
1409: || per_ri_config_main.g_job_rv_struct_def_string

Line 1431: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1427: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).segment_type := l_rv_jobs_segment_type;
1428: p_kf_job_rv_seg_tab(l_kf_job_rv_seg_count).window_prompt := l_rv_jobs_segment_name;
1429:
1430: --create technical summary data for valueset
1431: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1432: ,p_valueset_type => l_rv_jobs_segment_type
1433: ,p_structure_code => l_jobs_rv_name
1434: || per_ri_config_main.g_job_rv_struct_def_string
1435: ,p_segment_name => l_jobs_rv_name

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

1462: := l_kf_job_rv_valueset_tab(l_value_set_tab_count).max_value;
1463: l_kf_job_rv_seg_count := l_kf_job_rv_seg_count + 1 ;
1464: end if;
1465:
1466: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_jobs_segment_name);
1467: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_jobs_segment_name);
1468: END LOOP;
1469: --
1470: -- freeze and compile this flexfield

Line 1473: per_ri_config_utilities.freeze_and_compile_flexfield

1469: --
1470: -- freeze and compile this flexfield
1471: --
1472: if NOT (p_technical_summary_mode) then
1473: per_ri_config_utilities.freeze_and_compile_flexfield
1474: (p_appl_short_Name => 'PER'
1475: ,p_flex_code => 'JOB'
1476: ,p_structure_code => l_jobs_rv_name
1477: || per_ri_config_main.g_job_rv_struct_def_string);

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

1506: ,p_kf_pos_rv_seg_tab in out nocopy
1507: per_ri_config_tech_summary.kf_pos_rv_seg_tab) IS
1508:
1509: cursor csr_config_positions_rv (cp_configuration_code in varchar2) IS
1510: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1511: regional_variance_name, REG_VARIANCE_COUNTRY_CODE
1512: from per_ri_config_jp_rv_v
1513: where configuration_code = cp_configuration_code
1514: and exists (select configuration_code

Line 1580: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield

1576: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1577: ELSE
1578: -- Create Jobs RV Key flex
1579: if NOT (p_technical_summary_mode) then
1580: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield
1581: (p_appl_short_Name => 'PER'
1582: ,p_flex_code => 'POS'
1583: ,p_structure_code => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string
1584: ,p_structure_title => l_positions_rv_name || per_ri_config_main.g_pos_rv_struct_def_string

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

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

Line 1614: per_ri_config_utilities.create_flex_segments

1610:
1611: -- Create Jobs Key Flex Segments
1612: l_positions_segment_count := csr_config_positions_rv_seg%ROWCOUNT;
1613: if NOT (p_technical_summary_mode) then
1614: per_ri_config_utilities.create_flex_segments
1615: (p_appl_short_Name => 'PER'
1616: ,p_flex_code => 'POS'
1617: ,p_structure_code => l_positions_rv_name
1618: || per_ri_config_main.g_pos_rv_struct_def_string

Line 1641: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1637: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).segment_type := l_rv_positions_segment_type;
1638: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).window_prompt := l_rv_positions_segment_name;
1639:
1640: --create technical summary data for valueset
1641: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1642: ,p_valueset_type => l_rv_positions_segment_type
1643: ,p_structure_code => l_positions_rv_name
1644: || per_ri_config_main.g_pos_rv_struct_def_string
1645: ,p_segment_name => l_rv_positions_segment_name

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

1671: p_kf_pos_rv_seg_tab(l_kf_pos_rv_seg_count).vs_max_value
1672: := l_kf_pos_rv_valueset_tab(l_value_set_tab_count).max_value;
1673: l_kf_pos_rv_seg_count := l_kf_pos_rv_seg_count + 1 ;
1674: end if;
1675: per_ri_config_utilities.write_log(p_message => 'Created Positions Key Flex RV Segment' || l_rv_positions_segment_name);
1676: hr_utility.trace('Created Positions Key Flex RV Segment: ' || l_rv_positions_segment_name);
1677: END LOOP;
1678: --
1679: -- freeze and compile this flexfield

Line 1682: per_ri_config_utilities.freeze_and_compile_flexfield

1678: --
1679: -- freeze and compile this flexfield
1680: --
1681: if NOT (p_technical_summary_mode) then
1682: per_ri_config_utilities.freeze_and_compile_flexfield
1683: (p_appl_short_Name => 'PER'
1684: ,p_flex_code => 'POS'
1685: ,p_structure_code => l_positions_rv_name
1686: || per_ri_config_main.g_pos_rv_struct_def_string);

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

1715: ,p_kf_grd_rv_seg_tab in out nocopy
1716: per_ri_config_tech_summary.kf_grd_rv_seg_tab) IS
1717:
1718: cursor csr_config_grade_rv (cp_configuration_code in varchar2) IS
1719: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1720: regional_variance_name, REG_VARIANCE_COUNTRY_CODE
1721: from per_ri_config_grd_rv_v
1722: where configuration_code = cp_configuration_code;
1723:

Line 1787: per_ri_config_utilities.create_key_flexfield

1783: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1784: ELSE
1785: if NOT (p_technical_summary_mode) then
1786: l_grades_keyflex_number :=
1787: per_ri_config_utilities.create_key_flexfield
1788: (p_appl_short_Name => 'PER'
1789: ,p_flex_code => 'GRD'
1790: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1791: ,p_structure_title => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string

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

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

Line 1820: per_ri_config_utilities.create_flex_segments

1816:
1817: -- Create Jobs Key Flex Segments
1818: l_grades_segment_count := csr_config_grade_rv_seg%ROWCOUNT;
1819: if NOT (p_technical_summary_mode) then
1820: per_ri_config_utilities.create_flex_segments
1821: (p_appl_short_Name => 'PER'
1822: ,p_flex_code => 'GRD'
1823: ,p_structure_code => l_grade_rv_name || per_ri_config_main.g_grd_rv_struct_def_string
1824: ,p_segment_name => l_rv_grade_segment_name

Line 1845: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

1841: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).segment_type := l_rv_grade_segment_type;
1842: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).window_prompt := l_rv_grade_segment_name;
1843:
1844: --create technical summary data for valueset
1845: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
1846: ,p_valueset_type => l_rv_grade_segment_type
1847: ,p_structure_code => l_grade_rv_name
1848: || per_ri_config_main.g_grd_rv_struct_def_string
1849: ,p_segment_name => l_rv_grade_segment_name

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

1875: p_kf_grd_rv_seg_tab(l_kf_grd_rv_seg_count).vs_max_value
1876: := l_kf_grd_rv_valueset_tab(l_value_set_tab_count).max_value;
1877: l_kf_grd_rv_seg_count := l_kf_grd_rv_seg_count + 1 ;
1878: end if;
1879: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_grade_segment_name);
1880: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_grade_segment_name);
1881: END LOOP;
1882: close csr_config_grade_rv_seg;
1883: --

Line 1887: per_ri_config_utilities.freeze_and_compile_flexfield

1883: --
1884: -- freeze and compile this flexfield
1885: --
1886: if NOT (p_technical_summary_mode) then
1887: per_ri_config_utilities.freeze_and_compile_flexfield
1888: (p_appl_short_Name => 'PER'
1889: ,p_flex_code => 'GRD'
1890: ,p_structure_code => l_grade_rv_name
1891: || per_ri_config_main.g_grd_rv_struct_def_string);

Line 1971: l_people_group_fk_number := per_ri_config_utilities.create_key_flexfield

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

Line 1992: per_ri_config_utilities.create_flex_segments

1988: --
1989: -- create people group flex segments
1990: --
1991: if NOT (p_technical_summary_mode) then
1992: per_ri_config_utilities.create_flex_segments
1993: (p_appl_short_Name => 'PAY'
1994: ,p_flex_code => 'GRP'
1995: ,p_structure_code => l_grp_structures_code
1996: ,p_segment_name => 'People Group Name'

Line 2016: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2012: p_kf_grp_seg_tab(l_kf_grp_seg_count).segment_type := null;
2013: p_kf_grp_seg_tab(l_kf_grp_seg_count).window_prompt := 'People Group';
2014:
2015: --create technical summary data for valueset
2016: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2017: ,p_valueset_type => null
2018: ,p_structure_code => l_grp_structures_code
2019: ,p_segment_name => 'People Group Name'
2020: ,p_segment_number => 1

Line 2057: per_ri_config_utilities.freeze_and_compile_flexfield

2053: --
2054: -- freeze and compile this flexfield
2055: --
2056: if NOT (p_technical_summary_mode) then
2057: per_ri_config_utilities.freeze_and_compile_flexfield
2058: (p_appl_short_Name => 'PAY'
2059: ,p_flex_code => 'GRP'
2060: ,p_structure_code => l_grp_structures_code);
2061: end if;

Line 2070: l_competence_fk_number := per_ri_config_utilities.create_key_flexfield

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

Line 2091: per_ri_config_utilities.create_flex_segments

2087: --
2088: -- create competence flex segments
2089: --
2090: if NOT (p_technical_summary_mode) then
2091: per_ri_config_utilities.create_flex_segments
2092: (p_appl_short_Name => 'PER'
2093: ,p_flex_code => 'CMP'
2094: ,p_structure_code => l_cmp_structures_code
2095: ,p_segment_name => 'Competence Name'

Line 2114: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2110: p_kf_cmp_seg_tab(l_kf_cmp_seg_count).segment_type := null;
2111: p_kf_cmp_seg_tab(l_kf_cmp_seg_count).window_prompt := 'Competence Name';
2112:
2113: --create technical summary data for valueset
2114: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2115: ,p_valueset_type => null
2116: ,p_structure_code => l_cmp_structures_code
2117: ,p_segment_name => 'Competence Name'
2118: ,p_segment_number => 1

Line 2154: per_ri_config_utilities.freeze_and_compile_flexfield

2150: --
2151: -- freeze and compile this flexfield
2152: --
2153: if NOT (p_technical_summary_mode) then
2154: per_ri_config_utilities.freeze_and_compile_flexfield
2155: (p_appl_short_Name => 'PER'
2156: ,p_flex_code => 'CMP'
2157: ,p_structure_code => l_cmp_structures_code);
2158: end if;

Line 2165: l_cost_allocation_number := per_ri_config_utilities.create_key_flexfield

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

Line 2186: per_ri_config_utilities.create_flex_segments

2182: --
2183: -- create cost allocation flex segments
2184: --
2185: if NOT (p_technical_summary_mode) then
2186: per_ri_config_utilities.create_flex_segments
2187: (p_appl_short_Name => 'PAY'
2188: ,p_flex_code => 'COST'
2189: ,p_structure_code => l_cost_structures_code
2190: ,p_segment_name => 'Account'

Line 2209: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

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

Line 2245: per_ri_config_utilities.create_flex_segments

2241: hr_utility.trace('ENABLELONGLIST := ' || l_kf_cost_valueset_tab(l_value_set_tab_count).enable_longlist);
2242: end if;
2243:
2244: if NOT (p_technical_summary_mode) then
2245: per_ri_config_utilities.create_flex_segments
2246: (p_appl_short_Name => 'PAY'
2247: ,p_flex_code => 'COST'
2248: ,p_structure_code => l_cost_structures_code
2249: ,p_segment_name => 'Company'

Line 2268: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

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

Line 2303: per_ri_config_utilities.create_flex_segments

2299: l_kf_cost_seg_count := l_kf_cost_seg_count + 1 ;
2300: end if;
2301:
2302: if NOT (p_technical_summary_mode) then
2303: per_ri_config_utilities.create_flex_segments
2304: (p_appl_short_Name => 'PAY'
2305: ,p_flex_code => 'COST'
2306: ,p_structure_code => l_cost_structures_code
2307: ,p_segment_name => 'Cost Center'

Line 2327: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2323: p_kf_cost_seg_tab(l_kf_cost_seg_count).segment_type := null;
2324: p_kf_cost_seg_tab(l_kf_cost_seg_count).window_prompt := 'Cost Center';
2325:
2326: --create technical summary data for valueset
2327: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2328: ,p_valueset_type => null
2329: ,p_structure_code => l_cost_structures_code
2330: ,p_segment_name => 'Cost Center'
2331: ,p_segment_number => 3

Line 2365: per_ri_config_utilities.freeze_and_compile_flexfield

2361: --
2362: -- freeze and compile this flexfield
2363: --
2364: if NOT (p_technical_summary_mode) then
2365: per_ri_config_utilities.freeze_and_compile_flexfield
2366: (p_appl_short_Name => 'PAY'
2367: ,p_flex_code => 'COST'
2368: ,p_structure_code => l_cost_structures_code);
2369: end if;

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

2425:
2426: BEGIN
2427: hr_utility.set_location('Entering:'|| l_proc, 10);
2428:
2429: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
2430:
2431: -- Create Global Jobs Key flex
2432: hr_utility.set_location(l_proc, 20);
2433: l_job_structures_code := per_ri_config_utilities.return_config_entity_name

Line 2433: l_job_structures_code := per_ri_config_utilities.return_config_entity_name

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

Line 2438: l_jobs_fk_number := per_ri_config_utilities.create_key_flexfield

2434: (per_ri_config_main.g_global_job_structure_name);
2435:
2436:
2437: if NOT (p_technical_summary_mode) then
2438: l_jobs_fk_number := per_ri_config_utilities.create_key_flexfield
2439: (p_appl_short_name => 'PER'
2440: ,p_flex_code => 'JOB'
2441: ,p_structure_code => l_job_structures_code
2442: ,p_structure_title => l_job_structures_code

Line 2455: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

2451: p_kf_job_tab(l_kf_job_count).description := l_job_structures_code;
2452: l_kf_job_count := l_kf_job_count + 1 ;
2453: end if;
2454:
2455: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
2456: (p_configuration_code => p_configuration_code);
2457:
2458: l_log_message := 'Created KEYFLEX PER JOB ' || l_job_structures_code;
2459: per_ri_config_utilities.write_log(p_message => l_log_message);

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

2455: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
2456: (p_configuration_code => p_configuration_code);
2457:
2458: l_log_message := 'Created KEYFLEX PER JOB ' || l_job_structures_code;
2459: per_ri_config_utilities.write_log(p_message => l_log_message);
2460:
2461: -- Create Position Key flex
2462: hr_utility.set_location(l_proc, 30);
2463: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name

Line 2463: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name

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

Line 2466: l_position_fk_number := per_ri_config_utilities.create_key_flexfield

2462: hr_utility.set_location(l_proc, 30);
2463: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
2464: (per_ri_config_main.g_global_pos_structure_name);
2465: if NOT (p_technical_summary_mode) then
2466: l_position_fk_number := per_ri_config_utilities.create_key_flexfield
2467: (p_appl_short_Name => 'PER'
2468: ,p_flex_code => 'POS'
2469: ,p_structure_code => l_pos_structures_code
2470: ,p_structure_title => l_pos_structures_code

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

2479: end if;
2480:
2481:
2482: l_log_message := 'Created KEYFLEX PER POS ' || l_pos_structures_code;
2483: per_ri_config_utilities.write_log(p_message => l_log_message);
2484:
2485: hr_utility.set_location(l_proc, 40);
2486:
2487: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then

Line 2493: per_ri_config_utilities.create_flex_segments

2489:
2490: -- Create Jobs Key Flex Segments
2491:
2492: if NOT (p_technical_summary_mode) then
2493: per_ri_config_utilities.create_flex_segments
2494: (p_appl_short_Name => 'PER'
2495: ,p_flex_code => 'JOB'
2496: ,p_structure_code => l_job_structures_code
2497: ,p_segment_name => 'Job Name'

Line 2516: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2512: p_kf_job_seg_tab(l_kf_job_seg_count).segment_type := null;
2513: p_kf_job_seg_tab(l_kf_job_seg_count).window_prompt := 'Job Name';
2514:
2515: --create technical summary data for valueset
2516: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2517: ,p_valueset_type => null
2518: ,p_structure_code => l_job_structures_code
2519: ,p_segment_name => 'Job Name'
2520: ,p_segment_number => 1

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

2547: l_kf_job_seg_count := l_kf_job_seg_count + 1 ;
2548: end if;
2549:
2550: l_log_message := 'Created KEYFLEX SEGMENT : PER JOB ' || 'Job Name';
2551: per_ri_config_utilities.write_log(p_message => l_log_message);
2552:
2553: -- Create Position Key Flex Segments
2554: if NOT (p_technical_summary_mode) then
2555: per_ri_config_utilities.create_flex_segments

Line 2555: per_ri_config_utilities.create_flex_segments

2551: per_ri_config_utilities.write_log(p_message => l_log_message);
2552:
2553: -- Create Position Key Flex Segments
2554: if NOT (p_technical_summary_mode) then
2555: per_ri_config_utilities.create_flex_segments
2556: (p_appl_short_Name => 'PER'
2557: ,p_flex_code => 'POS'
2558: ,p_structure_code => l_pos_structures_code
2559: ,p_segment_name => 'Position Name'

Line 2578: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2574: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := null;
2575: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Position Name';
2576:
2577: --create technical summary data for valueset
2578: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2579: ,p_valueset_type => null
2580: ,p_structure_code => l_pos_structures_code
2581: ,p_segment_name => 'Position Name'
2582: ,p_segment_number => 1

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

2609: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2610: end if;
2611:
2612: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_structures_code;
2613: per_ri_config_utilities.write_log(p_message => l_log_message);
2614:
2615: hr_utility.set_location(l_proc, 60);
2616: else
2617: hr_utility.set_location(l_proc, 70);

Line 2623: per_ri_config_utilities.create_flex_segments

2619:
2620: -- create only federal job segments with specified value segment name valuesets.
2621: -- First Segment 'Name' valueset '60 Characters'
2622: if NOT (p_technical_summary_mode) then
2623: per_ri_config_utilities.create_flex_segments
2624: (p_appl_short_Name => 'PER'
2625: ,p_flex_code => 'JOB'
2626: ,p_structure_code => l_job_structures_code
2627: ,p_segment_name => 'Name'

Line 2649: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

2645: p_kf_job_seg_tab(l_kf_job_seg_count).segment_type := 'Char';
2646: p_kf_job_seg_tab(l_kf_job_seg_count).window_prompt := 'Name';
2647:
2648: --create technical summary data for valueset
2649: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
2650: ,p_valueset_type => 'Char'
2651: ,p_structure_code => l_job_structures_code
2652: ,p_segment_name => 'Name'
2653: ,p_segment_number => 1

Line 2686: per_ri_config_utilities.create_flex_segments

2682:
2683: -- create only federal position segments with specified value segment name valuesets.
2684: -- First Segment
2685: if NOT (p_technical_summary_mode) then
2686: per_ri_config_utilities.create_flex_segments
2687: (p_appl_short_Name => 'PER'
2688: ,p_flex_code => 'POS'
2689: ,p_structure_code => l_pos_structures_code
2690: ,p_segment_name => 'Position Title'

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

2708: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
2709: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Position Title';
2710:
2711: --create technical summary data for valueset
2712: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'
2713: ,p_valueset_type => 'Char'
2714: ,p_structure_code => l_pos_structures_code
2715: ,p_segment_name => 'Position Title'
2716: ,p_segment_number => 1

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

2743: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2744: end if;
2745:
2746: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Position Title';
2747: per_ri_config_utilities.write_log(p_message => l_log_message);
2748:
2749: -- Second Segment
2750: if NOT (p_technical_summary_mode) then
2751: per_ri_config_utilities.create_flex_segments

Line 2751: per_ri_config_utilities.create_flex_segments

2747: per_ri_config_utilities.write_log(p_message => l_log_message);
2748:
2749: -- Second Segment
2750: if NOT (p_technical_summary_mode) then
2751: per_ri_config_utilities.create_flex_segments
2752: (p_appl_short_Name => 'PER'
2753: ,p_flex_code => 'POS'
2754: ,p_structure_code => l_pos_structures_code
2755: ,p_segment_name => 'Description'

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

2772: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
2773: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Description';
2774:
2775: --create technical summary data for valueset
2776: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POS_DESC_NUM'
2777: ,p_valueset_type => 'Char'
2778: ,p_structure_code => l_pos_structures_code
2779: ,p_segment_name => 'Description'
2780: ,p_segment_number => 2

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

2807: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2808: end if;
2809:
2810: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Description';
2811: per_ri_config_utilities.write_log(p_message => l_log_message);
2812:
2813: -- Third Segment
2814: if NOT (p_technical_summary_mode) then
2815: per_ri_config_utilities.create_flex_segments

Line 2815: per_ri_config_utilities.create_flex_segments

2811: per_ri_config_utilities.write_log(p_message => l_log_message);
2812:
2813: -- Third Segment
2814: if NOT (p_technical_summary_mode) then
2815: per_ri_config_utilities.create_flex_segments
2816: (p_appl_short_Name => 'PER'
2817: ,p_flex_code => 'POS'
2818: ,p_structure_code => l_pos_structures_code
2819: ,p_segment_name => 'Sequence'

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

2836: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
2837: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Sequence';
2838:
2839: --create technical summary data for valueset
2840: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_SEQUENCE_NUM'
2841: ,p_valueset_type => 'Char'
2842: ,p_structure_code => l_pos_structures_code
2843: ,p_segment_name => 'Sequence'
2844: ,p_segment_number => 3

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

2871: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2872: end if;
2873:
2874: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
2875: per_ri_config_utilities.write_log(p_message => l_log_message);
2876: -- Fourth Segment
2877: if NOT (p_technical_summary_mode) then
2878: per_ri_config_utilities.create_flex_segments
2879: (p_appl_short_Name => 'PER'

Line 2878: per_ri_config_utilities.create_flex_segments

2874: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
2875: per_ri_config_utilities.write_log(p_message => l_log_message);
2876: -- Fourth Segment
2877: if NOT (p_technical_summary_mode) then
2878: per_ri_config_utilities.create_flex_segments
2879: (p_appl_short_Name => 'PER'
2880: ,p_flex_code => 'POS'
2881: ,p_structure_code => l_pos_structures_code
2882: ,p_segment_name => 'Agency Code'

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

2899: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
2900: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Agency Code';
2901:
2902: --create technical summary data for valueset
2903: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_AGENCY_CODE'
2904: ,p_valueset_type => 'Char'
2905: ,p_structure_code => l_pos_structures_code
2906: ,p_segment_name => 'Agency Code'
2907: ,p_segment_number => 4

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

2934: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
2935: end if;
2936:
2937: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
2938: per_ri_config_utilities.write_log(p_message => l_log_message);
2939: hr_utility.set_location(l_proc, 90);
2940: end if;
2941:
2942: --

Line 2946: per_ri_config_utilities.freeze_and_compile_flexfield

2942: --
2943: -- freeze and compile this flexfield
2944: --
2945: if NOT (p_technical_summary_mode) then
2946: per_ri_config_utilities.freeze_and_compile_flexfield
2947: (p_appl_short_Name => 'PER'
2948: ,p_flex_code => 'JOB'
2949: ,p_structure_code => l_job_structures_code);
2950: end if;

Line 2956: per_ri_config_utilities.freeze_and_compile_flexfield

2952: --
2953: -- freeze and compile this flexfield
2954: --
2955: if NOT (p_technical_summary_mode) then
2956: per_ri_config_utilities.freeze_and_compile_flexfield
2957: (p_appl_short_Name => 'PER'
2958: ,p_flex_code => 'POS'
2959: ,p_structure_code => l_pos_structures_code);
2960: end if;

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

3007:
3008: BEGIN
3009: hr_utility.set_location('Entering:'|| l_proc, 10);
3010:
3011: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3012:
3013: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3014: (p_configuration_code => p_configuration_code);
3015:

Line 3013: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

3009: hr_utility.set_location('Entering:'|| l_proc, 10);
3010:
3011: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3012:
3013: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3014: (p_configuration_code => p_configuration_code);
3015:
3016: -- Create Position Key flex
3017: hr_utility.set_location(l_proc, 20);

Line 3019: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name

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

Line 3022: l_position_fk_number := per_ri_config_utilities.create_key_flexfield

3018:
3019: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
3020: (per_ri_config_main.g_global_pos_structure_name);
3021: if NOT (p_technical_summary_mode) then
3022: l_position_fk_number := per_ri_config_utilities.create_key_flexfield
3023: (p_appl_short_Name => 'PER'
3024: ,p_flex_code => 'POS'
3025: ,p_structure_code => l_pos_structures_code
3026: ,p_structure_title => l_pos_structures_code

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

3034: l_kf_pos_count := l_kf_pos_count + 1 ;
3035: end if;
3036:
3037: l_log_message := 'Created KEYFLEX PER POS ' || l_pos_structures_code;
3038: per_ri_config_utilities.write_log(p_message => l_log_message);
3039:
3040: hr_utility.set_location(l_proc, 30);
3041:
3042: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then

Line 3047: per_ri_config_utilities.create_flex_segments

3043: hr_utility.set_location(l_proc, 50);
3044:
3045: -- Create Position Key Flex Segments
3046: if NOT (p_technical_summary_mode) then
3047: per_ri_config_utilities.create_flex_segments
3048: (p_appl_short_Name => 'PER'
3049: ,p_flex_code => 'POS'
3050: ,p_structure_code => l_pos_structures_code
3051: ,p_segment_name => 'Position Name'

Line 3070: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

3066: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := null;
3067: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Position Name';
3068:
3069: --create technical summary data for valueset
3070: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
3071: ,p_valueset_type => null
3072: ,p_structure_code => l_pos_structures_code
3073: ,p_segment_name => 'Position Name'
3074: ,p_segment_number => 1

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

3101: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3102: end if;
3103:
3104: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_structures_code;
3105: per_ri_config_utilities.write_log(p_message => l_log_message);
3106:
3107: hr_utility.set_location(l_proc, 60);
3108: else
3109: hr_utility.set_location(l_proc, 70);

Line 3115: per_ri_config_utilities.create_flex_segments

3111:
3112: -- create only federal position segments with specified value segment name valuesets.
3113: -- First Segment
3114: if NOT (p_technical_summary_mode) then
3115: per_ri_config_utilities.create_flex_segments
3116: (p_appl_short_Name => 'PER'
3117: ,p_flex_code => 'POS'
3118: ,p_structure_code => l_pos_structures_code
3119: ,p_segment_name => 'Position Title'

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

3136: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
3137: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Position Title';
3138:
3139: --create technical summary data for valueset
3140: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POSITION_TITLE'
3141: ,p_valueset_type => 'Char'
3142: ,p_structure_code => l_pos_structures_code
3143: ,p_segment_name => 'Position Title'
3144: ,p_segment_number => 1

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

3171: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3172: end if;
3173:
3174: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Position Title';
3175: per_ri_config_utilities.write_log(p_message => l_log_message);
3176:
3177: -- Second Segment
3178: if NOT (p_technical_summary_mode) then
3179: per_ri_config_utilities.create_flex_segments

Line 3179: per_ri_config_utilities.create_flex_segments

3175: per_ri_config_utilities.write_log(p_message => l_log_message);
3176:
3177: -- Second Segment
3178: if NOT (p_technical_summary_mode) then
3179: per_ri_config_utilities.create_flex_segments
3180: (p_appl_short_Name => 'PER'
3181: ,p_flex_code => 'POS'
3182: ,p_structure_code => l_pos_structures_code
3183: ,p_segment_name => 'Description'

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

3200: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
3201: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Description';
3202:
3203: --create technical summary data for valueset
3204: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_POS_DESC_NUM'
3205: ,p_valueset_type => 'Char'
3206: ,p_structure_code => l_pos_structures_code
3207: ,p_segment_name => 'Description'
3208: ,p_segment_number => 2

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

3235: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3236: end if;
3237:
3238: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Description';
3239: per_ri_config_utilities.write_log(p_message => l_log_message);
3240:
3241: -- Third Segment
3242: if NOT (p_technical_summary_mode) then
3243: per_ri_config_utilities.create_flex_segments

Line 3243: per_ri_config_utilities.create_flex_segments

3239: per_ri_config_utilities.write_log(p_message => l_log_message);
3240:
3241: -- Third Segment
3242: if NOT (p_technical_summary_mode) then
3243: per_ri_config_utilities.create_flex_segments
3244: (p_appl_short_Name => 'PER'
3245: ,p_flex_code => 'POS'
3246: ,p_structure_code => l_pos_structures_code
3247: ,p_segment_name => 'Sequence'

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

3265: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
3266: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Sequence';
3267:
3268: --create technical summary data for valueset
3269: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_SEQUENCE_NUM'
3270: ,p_valueset_type => 'Char'
3271: ,p_structure_code => l_pos_structures_code
3272: ,p_segment_name => 'Sequence'
3273: ,p_segment_number => 3

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

3299: := l_kf_pos_valueset_tab(l_value_set_tab_count).max_value;
3300: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3301: end if;
3302: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
3303: per_ri_config_utilities.write_log(p_message => l_log_message);
3304: -- Fourth Segment
3305: if NOT (p_technical_summary_mode) then
3306: per_ri_config_utilities.create_flex_segments
3307: (p_appl_short_Name => 'PER'

Line 3306: per_ri_config_utilities.create_flex_segments

3302: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Sequence';
3303: per_ri_config_utilities.write_log(p_message => l_log_message);
3304: -- Fourth Segment
3305: if NOT (p_technical_summary_mode) then
3306: per_ri_config_utilities.create_flex_segments
3307: (p_appl_short_Name => 'PER'
3308: ,p_flex_code => 'POS'
3309: ,p_structure_code => l_pos_structures_code
3310: ,p_segment_name => 'Agency Code'

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

3327: p_kf_pos_seg_tab(l_kf_pos_seg_count).segment_type := 'Char';
3328: p_kf_pos_seg_tab(l_kf_pos_seg_count).window_prompt := 'Agency Code';
3329:
3330: --create technical summary data for valueset
3331: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => 'GHR_US_AGENCY_CODE'
3332: ,p_valueset_type => 'Char'
3333: ,p_structure_code => l_pos_structures_code
3334: ,p_segment_name => 'Agency Code'
3335: ,p_segment_number => 4

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

3362: l_kf_pos_seg_count := l_kf_pos_seg_count + 1 ;
3363: end if;
3364:
3365: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
3366: per_ri_config_utilities.write_log(p_message => l_log_message);
3367: hr_utility.set_location(l_proc, 90);
3368: end if;
3369:
3370: --

Line 3373: per_ri_config_utilities.freeze_and_compile_flexfield

3369:
3370: --
3371: -- freeze and compile this flexfield
3372: --
3373: per_ri_config_utilities.freeze_and_compile_flexfield
3374: (p_appl_short_Name => 'PER'
3375: ,p_flex_code => 'POS'
3376: ,p_structure_code => l_pos_structures_code);
3377:

Line 3425: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

3421:
3422: BEGIN
3423: hr_utility.set_location('Entering:'|| l_proc, 10);
3424:
3425: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3426: (p_configuration_code => p_configuration_code);
3427:
3428: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3429:

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

3424:
3425: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3426: (p_configuration_code => p_configuration_code);
3427:
3428: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3429:
3430: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
3431: hr_utility.set_location(l_proc, 20);
3432: -- Create Grade Key Flex

Line 3433: l_grd_structures_code := per_ri_config_utilities.return_config_entity_name

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

Line 3436: l_grade_number := per_ri_config_utilities.create_key_flexfield

3432: -- Create Grade Key Flex
3433: l_grd_structures_code := per_ri_config_utilities.return_config_entity_name
3434: (per_ri_config_main.g_global_grd_structure_name);
3435: if NOT (p_technical_summary_mode) then
3436: l_grade_number := per_ri_config_utilities.create_key_flexfield
3437: (p_appl_short_Name => 'PER'
3438: ,p_flex_code => 'GRD'
3439: ,p_structure_code => l_grd_structures_code
3440: ,p_structure_title => l_grd_structures_code

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

3449:
3450: l_kf_grd_count := l_kf_grd_count + 1 ;
3451: end if;
3452: l_log_message := 'Created KEYFLEX PER GRD ' || l_grd_structures_code;
3453: per_ri_config_utilities.write_log(p_message => l_log_message);
3454:
3455: -- Create Grade Key Flex Segments
3456: if NOT (p_technical_summary_mode) then
3457: per_ri_config_utilities.create_flex_segments

Line 3457: per_ri_config_utilities.create_flex_segments

3453: per_ri_config_utilities.write_log(p_message => l_log_message);
3454:
3455: -- Create Grade Key Flex Segments
3456: if NOT (p_technical_summary_mode) then
3457: per_ri_config_utilities.create_flex_segments
3458: (p_appl_short_Name => 'PER'
3459: ,p_flex_code => 'GRD'
3460: ,p_structure_code => l_grd_structures_code
3461: ,p_segment_name => 'Grade'

Line 3480: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

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

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

3512: l_kf_grd_seg_count := l_kf_grd_seg_count + 1 ;
3513: end if;
3514:
3515: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || 'Grade';
3516: per_ri_config_utilities.write_log(p_message => l_log_message);
3517:
3518: if NOT (p_technical_summary_mode) then
3519: per_ri_config_utilities.create_flex_segments
3520: (p_appl_short_Name => 'PER'

Line 3519: per_ri_config_utilities.create_flex_segments

3515: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || 'Grade';
3516: per_ri_config_utilities.write_log(p_message => l_log_message);
3517:
3518: if NOT (p_technical_summary_mode) then
3519: per_ri_config_utilities.create_flex_segments
3520: (p_appl_short_Name => 'PER'
3521: ,p_flex_code => 'GRD'
3522: ,p_structure_code => l_grd_structures_code
3523: ,p_segment_name => 'Level'

Line 3542: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null

3538: p_kf_grd_seg_tab(l_kf_grd_seg_count).segment_type := 'Level';
3539: p_kf_grd_seg_tab(l_kf_grd_seg_count).window_prompt := 'Level';
3540:
3541: --create technical summary data for valueset
3542: per_ri_config_utilities.create_valueset_ts_data(p_valueset_name => null
3543: ,p_valueset_type => null
3544: ,p_structure_code => l_grd_structures_code
3545: ,p_segment_name => 'Level'
3546: ,p_segment_number => 2

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

3574: l_kf_grd_seg_count := l_kf_grd_seg_count + 1 ;
3575: end if;
3576:
3577: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || 'Level';
3578: per_ri_config_utilities.write_log(p_message => l_log_message);
3579: --
3580: -- freeze and compile this flexfield
3581: --
3582: if NOT (p_technical_summary_mode) then

Line 3583: per_ri_config_utilities.freeze_and_compile_flexfield

3579: --
3580: -- freeze and compile this flexfield
3581: --
3582: if NOT (p_technical_summary_mode) then
3583: per_ri_config_utilities.freeze_and_compile_flexfield
3584: (p_appl_short_Name => 'PER'
3585: ,p_flex_code => 'GRD'
3586: ,p_structure_code => l_grd_structures_code);
3587: end if;

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

3650: ,right_justify_zero_fill => l_right_justify_zero_fill
3651: ,min_value => l_min_value
3652: ,max_value => l_max_value);
3653: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_GRADES';
3654: per_ri_config_utilities.write_log(p_message => l_log_message);
3655: end if;
3656: hr_utility.set_location(l_proc, 30);
3657: -- Create PER_RI_DEFAULT_GRADES
3658: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_LEVELS');

Line 3783: and country_code in (select per_ri_config_utilities.business_group_decision

3779: from per_ri_config_country_v
3780: where configuration_code = cp_configuration_code
3781: and country_code in (select distinct territory_code
3782: from per_ri_config_responsibility)
3783: and country_code in (select per_ri_config_utilities.business_group_decision
3784: (cp_configuration_code
3785: ,country_code)
3786: from per_ri_config_country_v where configuration_code = cp_configuration_code);
3787:

Line 3826: and per_ri_config_utilities.business_group_decision

3822: from per_ri_config_country_v con
3823: where con.configuration_code = cp_configuration_code
3824: and con.country_code not in (select distinct territory_code
3825: from per_ri_config_responsibility)
3826: and per_ri_config_utilities.business_group_decision
3827: (cp_configuration_code
3828: ,country_code) <> 'INT' ;
3829:
3830: l_proc varchar2(72) := g_package || 'create_hrms_responsibility';

Line 3868: l_configuration_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre

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

Line 3973: := per_ri_config_utilities.determine_country_resp

3969: fetch csr_get_country into l_country_code;
3970: exit when csr_get_country%NOTFOUND;
3971:
3972: l_assign_determined_resp
3973: := per_ri_config_utilities.determine_country_resp
3974: (p_country_code => l_country_code
3975: ,p_assign_responsibility => l_assign_responsibility);
3976:
3977: hr_utility.trace('l_assign_responsibility = ' || l_assign_responsibility);

Line 4009: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name

4005: x_description => per_ri_config_main.g_description_string);
4006: hr_utility.trace('Assigned Responsibility:' || l_responsibility_key || ':' || l_fnd_application_short_name);
4007: */
4008: -- get business group name for given country code
4009: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name
4010: (p_configuration_code => p_configuration_code)
4011: || ' ' || l_country_code || per_ri_config_main.g_bg_name_suffix_string;
4012:
4013: per_ri_config_fnd_hr_entity.create_resp_level_profile

Line 4101: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name

4097: hr_utility.trace('Assigned Global Responsibility:' || l_assign_global_resp_key );
4098:
4099: -- get business group name for given country code
4100: -- business group name and security profile names are same
4101: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name
4102: (p_configuration_code => p_configuration_code)
4103: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;
4104:
4105: p_security_profile_tab(l_earlier_row_count).security_profile_name

Line 4155: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name

4151: ,p_technical_summary_mode => p_technical_summary_mode
4152: ,p_profile_resp_tab => l_profile_resp_main_tab);
4153:
4154: -- get business group name for given country code
4155: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name
4156: (p_configuration_code => p_configuration_code)
4157: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;
4158:
4159: hr_utility.trace('Security Group Removal Changes');

Line 4218: per_ri_config_utilities.set_profile_option_value

4214: -- ENABLE_SECURITY_GROUPS
4215: if l_product_name in ('PER','PAY','BEN') then
4216: hr_utility.trace('l_product_name ' || l_product_name);
4217: if NOT (p_technical_summary_mode) then
4218: per_ri_config_utilities.set_profile_option_value
4219: (p_level => 10002
4220: ,p_level_value => l_product_name
4221: ,p_level_value_app => l_product_name
4222: ,p_profile_name => 'ENABLE_SECURITY_GROUPS'

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

4232:
4233: end if;
4234:
4235: l_log_message := 'Created PROFILE_OPTION ENABLE_SECURITY_GROUPS ' || l_product_name;
4236: per_ri_config_utilities.write_log(p_message => l_log_message);
4237: end if;
4238: ** */
4239: end loop;
4240: close csr_get_product;

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

4260: else
4261: l_log_message := 'The profile setting has errored out for application '
4262: || rec.application_id;
4263: end if;
4264: per_ri_config_utilities.write_log(p_message => l_log_message);
4265: hr_utility.trace(l_log_message);
4266: end loop;
4267: --
4268: */

Line 4345: per_ri_config_utilities.set_profile_option_value

4341:
4342: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4343: hr_utility.trace('l_hr_user_type ' || l_hr_user_type);
4344: if NOT (p_technical_summary_mode) then
4345: per_ri_config_utilities.set_profile_option_value
4346: (p_level => 10003
4347: ,p_level_value => p_responsibility_key
4348: ,p_level_value_app => l_application_short_name
4349: ,p_profile_name => 'HR_USER_TYPE'

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

4463: '800') then
4464: null;
4465: end if;
4466: l_log_message := 'Created Profile Option Value PER_BUSINESS_GROUP_ID ' || l_bg_id;
4467: per_ri_config_utilities.write_log(p_message => l_log_message);
4468: hr_utility.set_location(l_proc, 20);
4469:
4470: --
4471: -- Create PER_SECURITY_PROFILE_ID

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

4477: '800') then
4478: null;
4479: end if;
4480: l_log_message := 'Created Profile Option Value PER_SECURITY_PROFILE_ID ' || l_sg_id;
4481: per_ri_config_utilities.write_log(p_message => l_log_message);
4482: hr_utility.set_location(l_proc, 30);
4483:
4484: open csr_get_product(p_configuration_code);
4485: loop

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

4509: '800') then
4510: null;
4511: end if;
4512: l_log_message := 'Created Profile Option Value HR_USER_TYPE ' || l_hr_user_type;
4513: per_ri_config_utilities.write_log(p_message => l_log_message);
4514: hr_utility.set_location(' Leaving:'|| l_proc, 50);
4515:
4516: else
4517: hr_utility.set_location(l_proc, 110);