DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_DATAPUMP_ENTITY dependencies on PER_RI_CONFIG_UTILITIES

Line 37: per_ri_config_utilities.return_config_entity_name(enterprise_name),

33: select configuration_code,
34: config_information_id,
35: config_sequence,
36: config_information_category,
37: per_ri_config_utilities.return_config_entity_name(enterprise_name),
38: enterprise_name, -- for other processing
39: enterprise_short_name,
40: enterprise_headquarter_country,
41: enterprise_primary_industry,

Line 119: l_business_group_country_code := per_ri_config_utilities.get_enterprise_bg_name

115: if csr_config_enterprise%FOUND then
116: hr_utility.set_location(l_proc, 20);
117:
118: -- decide on business group for enterprise
119: l_business_group_country_code := per_ri_config_utilities.get_enterprise_bg_name
120: (p_configuration_code => p_configuration_code
121: ,p_enterprise_name => l_enterprise_name_original);
122:
123: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);

Line 133: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name

129: THEN
130: hr_utility.set_location('BG Matches', 91000);
131: l_business_group_name := l_selected_country_name;
132: ELSE
133: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
134: (p_configuration_code => p_configuration_code)
135: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
136: END IF;
137: hr_utility.trace('l_business_group_name = ' || l_business_group_name);

Line 139: l_ent_location_code := per_ri_config_utilities.get_config_location_code

135: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
136: END IF;
137: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
138: hr_utility.set_location(l_business_group_name, 92000);
139: l_ent_location_code := per_ri_config_utilities.get_config_location_code
140: (p_configuration_code => p_configuration_code
141: ,p_location_id => l_enterprise_location_id);
142: -- get entity name for multiple configuration
143: --

Line 148: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;

144: hr_utility.trace('l_ent_location_code = ' || l_ent_location_code);
145: hr_utility.set_location(l_proc, 30);
146: if NOT (p_technical_summary_mode) then
147: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then
148: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;
149: -- end if;
150: hrdpp_create_organization.insert_batch_lines
151: (p_batch_id => p_batch_header_id
152: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

183:
184: end if;
185:
186: l_log_message := 'Created ENTERPRISE ' || l_enterprise_name;
187: per_ri_config_utilities.write_log(p_message => l_log_message);
188: hr_utility.set_location(l_proc, 50);
189:
190: --
191: -- Create HR_LEGAL classification for corporate LE

Line 195: if per_ri_config_utilities.check_org_class_lookup_tag

191: -- Create HR_LEGAL classification for corporate LE
192: -- For all Localizations where no mandatory org info is defined.
193: -- and this classification is visible.
194: --
195: if per_ri_config_utilities.check_org_class_lookup_tag
196: (p_legislation_code => l_business_group_country_code
197: ,p_lookup_code => 'HR_LEGAL')
198: and NOT per_ri_config_utilities.mandatory_org_info_types
199: (p_legislation_code => l_business_group_country_code

Line 198: and NOT per_ri_config_utilities.mandatory_org_info_types

194: --
195: if per_ri_config_utilities.check_org_class_lookup_tag
196: (p_legislation_code => l_business_group_country_code
197: ,p_lookup_code => 'HR_LEGAL')
198: and NOT per_ri_config_utilities.mandatory_org_info_types
199: (p_legislation_code => l_business_group_country_code
200: ,p_org_classification => 'HR_LEGAL') then
201: hr_utility.trace('l_mandatory_org_info_types = ' || 'TRUE');
202: if NOT (p_technical_summary_mode) then

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

220:
221: end if;
222: hr_utility.set_location(l_proc, 60);
223: l_log_message := 'Created CLASSIFICATION HR_LEGAL ' || l_enterprise_name;
224: per_ri_config_utilities.write_log(p_message => l_log_message);
225: end if;
226:
227: hr_utility.set_location(l_proc, 70);
228:

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

244: p_org_hierarchy_tab(l_org_hierarchy_count).name := substr(l_enterprise_name,1,30);
245: end if;
246:
247: l_log_message := 'Created HIERARCHY STRUCTURE ' || l_enterprise_name;
248: per_ri_config_utilities.write_log(p_message => l_log_message);
249:
250: if NOT (p_technical_summary_mode) then
251: hrdpp_create_org_structure_ver.insert_batch_lines
252: (p_batch_id => p_batch_header_id

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

267: p_org_hierarchy_tab(l_org_hierarchy_count).org_structure_version_id := 1;
268: end if;
269:
270: l_log_message := 'Created HIERARCHY VERSION ' || to_char(1);
271: per_ri_config_utilities.write_log(p_message => l_log_message);
272: hr_utility.set_location(l_proc, 80);
273: else
274: null; -- report error
275: end if;

Line 282: per_ri_config_utilities.set_profile_option_value

278:
279: -- Create BIS profile option
280: --BIS_PRIMARY_RATE_TYPE
281: if NOT (p_technical_summary_mode) then
282: per_ri_config_utilities.set_profile_option_value
283: (p_level => 10001
284: ,p_level_value => 0
285: ,p_level_value_app => 'BIS'
286: ,p_profile_name => 'BIS_PRIMARY_CURRENCY_CODE'

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

295: l_profile_dpe_ent_count := l_profile_dpe_ent_count + 1;
296:
297: end if;
298: l_log_message := 'Created PROFILE_OPTION ' || 'BIS_PRIMARY_RATE_TYPE';
299: per_ri_config_utilities.write_log(p_message => l_log_message);
300: hr_utility.set_location(l_proc, 60);
301: hr_utility.set_location(' Leaving:'|| l_proc, 100);
302:
303: EXCEPTION

Line 339: per_ri_config_utilities.return_config_entity_name(operating_company_name),

335: select configuration_code,
336: config_information_id,
337: config_sequence,
338: config_information_category,
339: per_ri_config_utilities.return_config_entity_name(operating_company_name),
340: operating_company_name,
341: operating_company_short_name,
342: operating_company_hq_country,
343: operating_company_location_id

Line 419: l_business_group_country_code := per_ri_config_utilities.get_oc_bg_name

415: if csr_config_oper_comp%FOUND then
416: hr_utility.set_location(l_proc, 20);
417:
418: hr_utility.trace('l_operating_company_name = ' || l_operating_company_name);
419: l_business_group_country_code := per_ri_config_utilities.get_oc_bg_name
420: (p_configuration_code => p_configuration_code
421: ,p_operating_company_name => l_operating_company_name_orig);
422: hr_utility.set_location(l_business_group_country_code, 93000);
423: hr_utility.set_location(l_selected_country_code, 94000);

Line 431: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name

427: THEN
428: hr_utility.set_location('BG Matches', 91000);
429: l_business_group_name := l_selected_country_name;
430: ELSE
431: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
432: (p_configuration_code => p_configuration_code)
433: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
434: END IF;
435: hr_utility.trace('l_business_group_name = ' || l_business_group_name);

Line 437: l_oc_location_code := per_ri_config_utilities.get_config_location_code

433: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
434: END IF;
435: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
436:
437: l_oc_location_code := per_ri_config_utilities.get_config_location_code
438: (p_configuration_code => p_configuration_code
439: ,p_location_id => l_operating_comp_location_id);
440:
441: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);

Line 447: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;

443: hr_utility.trace('l_oc_location_code = ' || l_oc_location_code);
444:
445: if NOT (p_technical_summary_mode) then
446: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then
447: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;
448: -- end if;
449: hrdpp_create_organization.insert_batch_lines
450: (p_batch_id => p_batch_header_id
451: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

484: end if;
485:
486:
487: l_log_message := 'Created OPERATING COMPANY ' || l_operating_company_name;
488: per_ri_config_utilities.write_log(p_message => l_log_message);
489: hr_utility.set_location(l_proc, 40);
490:
491: -- create org hierarchy elements
492: --

Line 493: l_enterprise_name := per_ri_config_utilities.get_enterprise_name

489: hr_utility.set_location(l_proc, 40);
490:
491: -- create org hierarchy elements
492: --
493: l_enterprise_name := per_ri_config_utilities.get_enterprise_name
494: (p_configuration_code => p_configuration_code);
495: if NOT (p_technical_summary_mode) then
496: hrdpp_create_hierarchy_element.insert_batch_lines
497: (p_batch_id => p_batch_header_id

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

523: l_org_hierarchy_ele_oc_count := l_org_hierarchy_ele_oc_count + 1 ;
524: end if;
525:
526: l_log_message := 'Created HIERARCHY ELEMENT ENTERPRISE ' || l_enterprise_name || ' ' || l_operating_company_name;
527: per_ri_config_utilities.write_log(p_message => l_log_message);
528: --
529: -- Create HR_LEGAL classification
530: -- For all Localizations where no mandatory org info is defined.
531: -- and this classification is visible.

Line 533: if per_ri_config_utilities.check_org_class_lookup_tag

529: -- Create HR_LEGAL classification
530: -- For all Localizations where no mandatory org info is defined.
531: -- and this classification is visible.
532: --
533: if per_ri_config_utilities.check_org_class_lookup_tag
534: (p_legislation_code => l_business_group_country_code
535: ,p_lookup_code => 'HR_OPC')
536: and NOT per_ri_config_utilities.mandatory_org_info_types
537: (p_legislation_code => l_business_group_country_code

Line 536: and NOT per_ri_config_utilities.mandatory_org_info_types

532: --
533: if per_ri_config_utilities.check_org_class_lookup_tag
534: (p_legislation_code => l_business_group_country_code
535: ,p_lookup_code => 'HR_OPC')
536: and NOT per_ri_config_utilities.mandatory_org_info_types
537: (p_legislation_code => l_business_group_country_code
538: ,p_org_classification => 'HR_OPC') then
539: if NOT (p_technical_summary_mode) then
540: hrdpp_create_org_classificatio.insert_batch_lines

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

558:
559: end if;
560: hr_utility.set_location(l_proc, 50);
561: l_log_message := 'Created CLASSIFICATION HR_OPC ' || l_operating_company_name;
562: per_ri_config_utilities.write_log(p_message => l_log_message);
563: end if;
564: end if;
565: end loop;
566: close csr_config_oper_comp;

Line 604: per_ri_config_utilities.return_config_entity_name(legal_entity_name),

600: select configuration_code,
601: config_information_id,
602: config_sequence,
603: config_information_category,
604: per_ri_config_utilities.return_config_entity_name(legal_entity_name),
605: legal_entity_name,
606: legal_entity_short_name,
607: legal_entity_country,
608: legal_entity_parent_oper_comp,

Line 671: l_enterprise_name := per_ri_config_utilities.get_enterprise_name

667: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
668:
669: open csr_config_legal_entity(p_configuration_code);
670:
671: l_enterprise_name := per_ri_config_utilities.get_enterprise_name
672: (p_configuration_code => p_configuration_code);
673: loop
674: fetch csr_config_legal_entity into
675: l_configuration_code,

Line 692: l_business_group_country_code := per_ri_config_utilities.get_le_bg_name

688:
689: hr_utility.trace('l_legal_entity_name = ' || l_legal_entity_name);
690: hr_utility.trace('l_legal_entity_country = ' || l_legal_entity_country);
691:
692: l_business_group_country_code := per_ri_config_utilities.get_le_bg_name
693: (p_configuration_code => p_configuration_code
694: ,p_legal_entity_name => l_legal_entity_name_original);
695: hr_utility.set_location(l_business_group_country_code, 93000);
696: hr_utility.set_location(l_selected_country_code, 94000);

Line 704: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name

700: THEN
701: hr_utility.set_location('BG Matches', 91000);
702: l_business_group_name := l_selected_country_name;
703: ELSE
704: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
705: (p_configuration_code => p_configuration_code)
706: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
707: END IF;
708: hr_utility.trace('l_business_group_name = ' || l_business_group_name);

Line 710: l_le_location_code := per_ri_config_utilities.get_config_location_code

706: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
707: END IF;
708: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
709:
710: l_le_location_code := per_ri_config_utilities.get_config_location_code
711: (p_configuration_code => p_configuration_code
712: ,p_location_id => l_legal_entity_location_id);
713: hr_utility.trace('l_legal_entity_location_id = ' || l_legal_entity_location_id);
714: hr_utility.set_location(l_proc, 30);

Line 718: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;

714: hr_utility.set_location(l_proc, 30);
715:
716: if NOT (p_technical_summary_mode) then
717: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then
718: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;
719: -- end if;
720: hrdpp_create_organization.insert_batch_lines
721: (p_batch_id => p_batch_header_id
722: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

752: l_le_count := l_le_count + 1;
753: end if;
754:
755: l_log_message := 'Created LEGAL ENTITY ' || l_legal_entity_name;
756: per_ri_config_utilities.write_log(p_message => l_log_message);
757:
758: --
759: -- Create CC classification
760: -- For all localization if no mandatory org info is defined.

Line 763: if per_ri_config_utilities.check_org_class_lookup_tag

759: -- Create CC classification
760: -- For all localization if no mandatory org info is defined.
761: -- and this classification is visible.
762: --
763: if per_ri_config_utilities.check_org_class_lookup_tag
764: (p_legislation_code => l_business_group_country_code
765: ,p_lookup_code => 'CC')
766: and NOT per_ri_config_utilities.mandatory_org_info_types
767: (p_legislation_code => l_business_group_country_code

Line 766: and NOT per_ri_config_utilities.mandatory_org_info_types

762: --
763: if per_ri_config_utilities.check_org_class_lookup_tag
764: (p_legislation_code => l_business_group_country_code
765: ,p_lookup_code => 'CC')
766: and NOT per_ri_config_utilities.mandatory_org_info_types
767: (p_legislation_code => l_business_group_country_code
768: ,p_org_classification => 'CC') then
769: if NOT (p_technical_summary_mode) then
770: hrdpp_create_org_classificatio.insert_batch_lines

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

788:
789: end if;
790: hr_utility.set_location(l_proc, 50);
791: l_log_message := 'Created CLASSIFICATION CC ' || l_legal_entity_name;
792: per_ri_config_utilities.write_log(p_message => l_log_message);
793: end if;
794:
795: --
796: -- Create HR_LEGAL_EMPLOYER classification

Line 800: if per_ri_config_utilities.check_org_class_lookup_tag

796: -- Create HR_LEGAL_EMPLOYER classification
797: -- For all localization if no mandatory org info is defined.
798: -- and this classification is visible.
799: --
800: if per_ri_config_utilities.check_org_class_lookup_tag
801: (p_legislation_code => l_business_group_country_code
802: ,p_lookup_code => 'HR_LEGAL_EMPLOYER')
803: and NOT per_ri_config_utilities.mandatory_org_info_types
804: (p_legislation_code => l_business_group_country_code

Line 803: and NOT per_ri_config_utilities.mandatory_org_info_types

799: --
800: if per_ri_config_utilities.check_org_class_lookup_tag
801: (p_legislation_code => l_business_group_country_code
802: ,p_lookup_code => 'HR_LEGAL_EMPLOYER')
803: and NOT per_ri_config_utilities.mandatory_org_info_types
804: (p_legislation_code => l_business_group_country_code
805: ,p_org_classification => 'HR_LEGAL_EMPLOYER') then
806: if NOT (p_technical_summary_mode) then
807: hrdpp_create_org_classificatio.insert_batch_lines

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

825: end if;
826:
827: hr_utility.set_location(l_proc, 60);
828: l_log_message := 'Created CLASSIFICATION HR_LEGAL_EMPLOYER ' || l_legal_entity_name;
829: per_ri_config_utilities.write_log(p_message => l_log_message);
830: end if;
831:
832: --
833: -- Create FR_SOCIETE classification

Line 838: per_ri_config_utilities.check_org_class_lookup_tag

834: -- For FR localization if no mandatory org info is defined.
835: -- and this classification is visible.
836: --
837: if l_business_group_country_code = 'FR' and
838: per_ri_config_utilities.check_org_class_lookup_tag
839: (p_legislation_code => l_business_group_country_code
840: ,p_lookup_code => 'FR_SOCIETE')
841: and NOT per_ri_config_utilities.mandatory_org_info_types
842: (p_legislation_code => l_business_group_country_code

Line 841: and NOT per_ri_config_utilities.mandatory_org_info_types

837: if l_business_group_country_code = 'FR' and
838: per_ri_config_utilities.check_org_class_lookup_tag
839: (p_legislation_code => l_business_group_country_code
840: ,p_lookup_code => 'FR_SOCIETE')
841: and NOT per_ri_config_utilities.mandatory_org_info_types
842: (p_legislation_code => l_business_group_country_code
843: ,p_org_classification => 'FR_SOCIETE') then
844: if NOT (p_technical_summary_mode) then
845: hrdpp_create_org_classificatio.insert_batch_lines

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

863:
864: end if;
865: hr_utility.set_location(l_proc, 70);
866: l_log_message := 'Created CLASSIFICATION FR_SOCIETE ' || l_legal_entity_name;
867: per_ri_config_utilities.write_log(p_message => l_log_message);
868: end if;
869:
870: --
871: -- Create IN_COMPANY classification

Line 877: per_ri_config_utilities.check_org_class_lookup_tag

873: -- and this classification is visible.
874: --
875:
876: if l_business_group_country_code = 'IN' and
877: per_ri_config_utilities.check_org_class_lookup_tag
878: (p_legislation_code => l_business_group_country_code
879: ,p_lookup_code => 'IN_COMPANY')
880: and NOT per_ri_config_utilities.mandatory_org_info_types
881: (p_legislation_code => l_business_group_country_code

Line 880: and NOT per_ri_config_utilities.mandatory_org_info_types

876: if l_business_group_country_code = 'IN' and
877: per_ri_config_utilities.check_org_class_lookup_tag
878: (p_legislation_code => l_business_group_country_code
879: ,p_lookup_code => 'IN_COMPANY')
880: and NOT per_ri_config_utilities.mandatory_org_info_types
881: (p_legislation_code => l_business_group_country_code
882: ,p_org_classification => 'IN_COMPANY')then
883: if NOT (p_technical_summary_mode) then
884: hrdpp_create_org_classificatio.insert_batch_lines

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

902:
903: end if;
904: hr_utility.set_location(l_proc, 80);
905: l_log_message := 'Created CLASSIFICATION IN_COMPANY ' || l_legal_entity_name;
906: per_ri_config_utilities.write_log(p_message => l_log_message);
907: end if;
908:
909: --
910: -- Create HR_LEGAL classification

Line 914: if per_ri_config_utilities.check_org_class_lookup_tag

910: -- Create HR_LEGAL classification
911: -- For all Localizations where no mandatory org info is defined.
912: -- and this classification is visible.
913: --
914: if per_ri_config_utilities.check_org_class_lookup_tag
915: (p_legislation_code => l_business_group_country_code
916: ,p_lookup_code => 'HR_LEGAL')
917: and NOT per_ri_config_utilities.mandatory_org_info_types
918: (p_legislation_code => l_business_group_country_code

Line 917: and NOT per_ri_config_utilities.mandatory_org_info_types

913: --
914: if per_ri_config_utilities.check_org_class_lookup_tag
915: (p_legislation_code => l_business_group_country_code
916: ,p_lookup_code => 'HR_LEGAL')
917: and NOT per_ri_config_utilities.mandatory_org_info_types
918: (p_legislation_code => l_business_group_country_code
919: ,p_org_classification => 'HR_LEGAL') then
920: if NOT (p_technical_summary_mode) then
921: hrdpp_create_org_classificatio.insert_batch_lines

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

939: end if;
940:
941: hr_utility.set_location(l_proc, 90);
942: l_log_message := 'Created CLASSIFICATION HR_LEGAL ' || l_legal_entity_name;
943: per_ri_config_utilities.write_log(p_message => l_log_message);
944: end if;
945:
946: --
947: -- create org hierarchy elements

Line 964: ,p_parent_organization_name => per_ri_config_utilities.return_config_entity_name

960: ,p_hr_installed => null
961: ,p_pa_installed => null
962: ,p_pos_control_enabled_flag => null
963: ,p_warning_raised => null
964: ,p_parent_organization_name => per_ri_config_utilities.return_config_entity_name
965: (l_le_parent_oper_comp)
966: ,p_child_organization_name => l_legal_entity_name
967: ,p_language_code => hr_api.userenv_lang
968: ,p_org_str_version_user_key => p_configuration_code || ' ' || l_enterprise_name

Line 974: p_org_hierarchy_ele_le_tab(l_org_hierarchy_ele_le_count).parent_organization_name := per_ri_config_utilities.return_config_entity_name

970: --,p_security_profile_name => l_business_group_name);
971: ,p_security_profile_name => null);
972: else
973: p_org_hierarchy_ele_le_tab(l_org_hierarchy_ele_le_count).org_structure_version_id := 1;
974: p_org_hierarchy_ele_le_tab(l_org_hierarchy_ele_le_count).parent_organization_name := per_ri_config_utilities.return_config_entity_name
975: (l_le_parent_oper_comp);
976: p_org_hierarchy_ele_le_tab(l_org_hierarchy_ele_le_count).child_organization_name := l_legal_entity_name;
977:
978: l_org_hierarchy_ele_le_count := l_org_hierarchy_ele_le_count + 1 ;

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

978: l_org_hierarchy_ele_le_count := l_org_hierarchy_ele_le_count + 1 ;
979: end if;
980:
981: l_log_message := 'Created HIERARCHY ELEMENT OPERATING_COMPANY ' || l_le_parent_oper_comp || ' ' || l_legal_entity_name;
982: per_ri_config_utilities.write_log(p_message => l_log_message);
983:
984: hr_utility.set_location(l_proc, 100);
985: end loop;
986: close csr_config_legal_entity;

Line 1120: l_location_code := per_ri_config_utilities.return_config_entity_name(l_location_code);

1116: l_loc_information20,
1117: l_object_version_number;
1118:
1119: exit when csr_config_location%NOTFOUND;
1120: l_location_code := per_ri_config_utilities.return_config_entity_name(l_location_code);
1121:
1122: if l_style = 'GENERIC' then
1123:
1124: OPEN csr_get_country_code(l_country);

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

1197: l_locations_count := l_locations_count + 1;
1198: end if;
1199:
1200: l_log_message := 'Created LOCATION ' || l_location_code;
1201: per_ri_config_utilities.write_log(p_message => l_log_message);
1202: hr_utility.set_location(l_proc, 40);
1203: END LOOP;
1204: close csr_config_location;
1205: hr_utility.set_location(' Leaving :' || l_proc, 50);

Line 1243: per_ri_config_utilities.business_group_decision(configuration_code,country_code)

1239: per_ri_config_fnd_hr_entity.int_bg_resp_tab) IS
1240:
1241: cursor csr_config_business_groups(cp_configuration_code in varchar2) IS
1242: select distinct configuration_code,
1243: per_ri_config_utilities.business_group_decision(configuration_code,country_code)
1244: from per_ri_config_country_v
1245: where configuration_code = cp_configuration_code;
1246:
1247: -- Bugfix 4133935

Line 1337: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name

1333: l_bg_country_name;
1334:
1335: exit when csr_config_business_groups%NOTFOUND;
1336:
1337: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
1338: (p_configuration_code => p_configuration_code)
1339: || ' ' || l_bg_country_name || per_ri_config_main.g_bg_name_suffix_string;
1340:
1341: hr_utility.set_location('The name selected is '|| l_bg_country_name, 44) ;

Line 1352: l_currency_code := per_ri_config_utilities.get_country_currency

1348:
1349: if l_bg_country_name = 'INT' then
1350: l_currency_code := 'USD'; -- chnage it out corporate LE bg currency.
1351: else
1352: l_currency_code := per_ri_config_utilities.get_country_currency
1353: (p_legislation_code => l_bg_country_name);
1354: end if;
1355:
1356: -- For those BG legislations that do not have a currency code defined

Line 1362: l_currency_code := per_ri_config_utilities.get_country_currency

1358: -- at the Enterprise
1359: -- ii. If a currency code does not exist for the BG legislation at the
1360: -- Enterprise, default to USD
1361: if l_currency_code is null then
1362: l_currency_code := per_ri_config_utilities.get_country_currency
1363: (p_legislation_code => l_enterprise_bg_country_code);
1364: end if;
1365:
1366: if l_currency_code is null then

Line 1370: l_job_flex_stru_code := per_ri_config_utilities.get_bg_job_keyflex_name

1366: if l_currency_code is null then
1367: l_currency_code := 'USD';
1368: end if;
1369:
1370: l_job_flex_stru_code := per_ri_config_utilities.get_bg_job_keyflex_name
1371: (p_configuration_code => p_configuration_code
1372: ,p_bg_country_code => l_bg_country_name);
1373: hr_utility.trace('Job Name ' || l_job_flex_stru_code);
1374:

Line 1375: l_position_flex_stru_code := per_ri_config_utilities.get_bg_pos_keyflex_name

1371: (p_configuration_code => p_configuration_code
1372: ,p_bg_country_code => l_bg_country_name);
1373: hr_utility.trace('Job Name ' || l_job_flex_stru_code);
1374:
1375: l_position_flex_stru_code := per_ri_config_utilities.get_bg_pos_keyflex_name
1376: (p_configuration_code => p_configuration_code
1377: ,p_bg_country_code => l_bg_country_name);
1378:
1379: hr_utility.trace('Position Name ' || l_position_flex_stru_code);

Line 1380: l_grade_flex_stru_code := per_ri_config_utilities.get_bg_grd_keyflex_name

1376: (p_configuration_code => p_configuration_code
1377: ,p_bg_country_code => l_bg_country_name);
1378:
1379: hr_utility.trace('Position Name ' || l_position_flex_stru_code);
1380: l_grade_flex_stru_code := per_ri_config_utilities.get_bg_grd_keyflex_name
1381: (p_configuration_code => p_configuration_code
1382: ,p_bg_country_code => l_bg_country_name);
1383:
1384: hr_utility.trace('Grade Name ' || l_grade_flex_stru_code);

Line 1388: l_currecny_flag := per_ri_config_utilities.check_currency_enabled (p_legislation_code => l_legislation_code);

1384: hr_utility.trace('Grade Name ' || l_grade_flex_stru_code);
1385:
1386: hr_utility.trace('l_legislation_code = ' || l_legislation_code);
1387:
1388: l_currecny_flag := per_ri_config_utilities.check_currency_enabled (p_legislation_code => l_legislation_code);
1389: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);
1390: if l_currecny_flag = 'X' then
1391: per_ri_config_utilities.enable_country_currency (p_legislation_code => l_legislation_code);
1392: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);

Line 1391: per_ri_config_utilities.enable_country_currency (p_legislation_code => l_legislation_code);

1387:
1388: l_currecny_flag := per_ri_config_utilities.check_currency_enabled (p_legislation_code => l_legislation_code);
1389: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);
1390: if l_currecny_flag = 'X' then
1391: per_ri_config_utilities.enable_country_currency (p_legislation_code => l_legislation_code);
1392: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);
1393: end if;
1394:
1395: IF l_bg_country_name = l_country_selected AND

Line 1466: if per_ri_config_utilities.check_selected_product

1462:
1463: l_sg_count := l_sg_count +1 ;
1464:
1465: -- determine post install steps for PER and PAY
1466: if per_ri_config_utilities.check_selected_product
1467: (p_configuration_code => p_configuration_code
1468: ,p_product_name => 'PER') then
1469: l_per_post_install := per_ri_config_utilities.legislation_support
1470: (p_legislation_code => l_legislation_code

Line 1469: l_per_post_install := per_ri_config_utilities.legislation_support

1465: -- determine post install steps for PER and PAY
1466: if per_ri_config_utilities.check_selected_product
1467: (p_configuration_code => p_configuration_code
1468: ,p_product_name => 'PER') then
1469: l_per_post_install := per_ri_config_utilities.legislation_support
1470: (p_legislation_code => l_legislation_code
1471: ,p_application_short_name => 'PER');
1472: if l_per_post_install or l_legislation_code = 'BF' then
1473: p_post_install_tab(l_post_install_count).legislation_code := l_legislation_code;

Line 1480: if per_ri_config_utilities.check_selected_product

1476: l_post_install_count := l_post_install_count + 1 ;
1477: end if;
1478: end if;
1479:
1480: if per_ri_config_utilities.check_selected_product
1481: (p_configuration_code => p_configuration_code
1482: ,p_product_name => 'PAY') then
1483: l_per_post_install := per_ri_config_utilities.legislation_support
1484: (p_legislation_code => l_legislation_code

Line 1483: l_per_post_install := per_ri_config_utilities.legislation_support

1479:
1480: if per_ri_config_utilities.check_selected_product
1481: (p_configuration_code => p_configuration_code
1482: ,p_product_name => 'PAY') then
1483: l_per_post_install := per_ri_config_utilities.legislation_support
1484: (p_legislation_code => l_legislation_code
1485: ,p_application_short_name => 'PAY');
1486: if l_per_post_install then
1487: p_post_install_tab(l_post_install_count).legislation_code := l_legislation_code;

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

1493: end if;
1494: END IF;
1495:
1496: l_log_message := 'Created BUSINESS GROUP ' || l_business_group_name;
1497: per_ri_config_utilities.write_log(p_message => l_log_message);
1498: hr_utility.set_location(l_proc, 40);
1499:
1500: p_country_tab_out(csr_config_business_groups%ROWCOUNT).territory_code := l_legislation_code;
1501: