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);
138: hr_utility.set_location(l_business_group_name, 92000);
139: l_ent_location_code := per_ri_config_utilities.get_config_location_code
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
153: ,p_user_sequence => 30
154: ,p_effective_date => g_config_effective_date
155: ,p_date_from => g_config_effective_date
156: ,p_data_pump_business_grp_name => l_business_group_name
162: hr_utility.set_location(l_proc, 40);
163:
164: hrdpp_update_organization.insert_batch_lines
165: (p_batch_id => p_batch_header_id
166: ,p_link_value => per_ri_config_main.g_global_dp_link_value
167: ,p_user_sequence => 40
168: ,p_effective_date => g_config_effective_date
169: ,p_date_from => g_config_effective_date
170: ,p_data_pump_business_grp_name => l_business_group_name
201: hr_utility.trace('l_mandatory_org_info_types = ' || 'TRUE');
202: if NOT (p_technical_summary_mode) then
203: hrdpp_create_org_classificatio.insert_batch_lines
204: (p_batch_id => p_batch_header_id
205: ,p_link_value => per_ri_config_main.g_global_dp_link_value
206: ,p_user_sequence => 50
207: ,p_effective_date => g_config_effective_date
208: ,p_data_pump_business_grp_name => l_business_group_name
209: ,p_org_classif_code => 'HR_LEGAL'
231: hrdpp_create_organization_stru.insert_batch_lines
232: (p_batch_id => p_batch_header_id
233: --,p_data_pump_business_grp_name => l_business_group_name
234: ,p_data_pump_business_grp_name => null
235: ,p_link_value => per_ri_config_main.g_global_dp_link_value
236: ,p_user_sequence => 60
237: ,p_effective_date => g_config_effective_date
238: ,p_name => substr(l_enterprise_name,1,30)-- name of the hierarchy same
239: ,p_primary_structure_flag => 'N'
251: hrdpp_create_org_structure_ver.insert_batch_lines
252: (p_batch_id => p_batch_header_id
253: --,p_data_pump_business_grp_name => l_business_group_name
254: ,p_data_pump_business_grp_name => null
255: ,p_link_value => per_ri_config_main.g_global_dp_link_value
256: ,p_user_sequence => 70
257: ,p_effective_date => g_config_effective_date
258: ,p_date_from => g_config_effective_date
259: ,p_version_number => 1
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);
436:
437: l_oc_location_code := per_ri_config_utilities.get_config_location_code
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
452: ,p_user_sequence => 30
453: ,p_effective_date => g_config_effective_date
454: ,p_date_from => g_config_effective_date
455: ,p_data_pump_business_grp_name => l_business_group_name
463: hr_utility.set_location(l_proc, 30);
464:
465: hrdpp_update_organization.insert_batch_lines
466: (p_batch_id => p_batch_header_id
467: ,p_link_value => per_ri_config_main.g_global_dp_link_value
468: ,p_user_sequence => 40
469: ,p_effective_date => g_config_effective_date
470: ,p_date_from => g_config_effective_date
471: ,p_data_pump_business_grp_name => l_business_group_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
498: ,p_link_value => per_ri_config_main.g_global_dp_link_value
499: ,p_user_sequence => 80
500: ,p_effective_date => g_config_effective_date
501: ,p_date_from => g_config_effective_date
502: ,p_data_pump_business_grp_name => null
538: ,p_org_classification => 'HR_OPC') then
539: if NOT (p_technical_summary_mode) then
540: hrdpp_create_org_classificatio.insert_batch_lines
541: (p_batch_id => p_batch_header_id
542: ,p_link_value => per_ri_config_main.g_global_dp_link_value
543: ,p_user_sequence => 50
544: ,p_effective_date => g_config_effective_date
545: ,p_data_pump_business_grp_name => l_business_group_name
546: ,p_org_classif_code => 'HR_OPC'
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);
709:
710: l_le_location_code := per_ri_config_utilities.get_config_location_code
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
723: ,p_user_sequence => 30
724: ,p_effective_date => g_config_effective_date
725: ,p_date_from => g_config_effective_date
726: ,p_data_pump_business_grp_name => l_business_group_name
731:
732:
733: hrdpp_update_organization.insert_batch_lines
734: (p_batch_id => p_batch_header_id
735: ,p_link_value => per_ri_config_main.g_global_dp_link_value
736: ,p_user_sequence => 40
737: ,p_effective_date => g_config_effective_date
738: ,p_date_from => g_config_effective_date
739: ,p_data_pump_business_grp_name => l_business_group_name
768: ,p_org_classification => 'CC') then
769: if NOT (p_technical_summary_mode) then
770: hrdpp_create_org_classificatio.insert_batch_lines
771: (p_batch_id => p_batch_header_id
772: ,p_link_value => per_ri_config_main.g_global_dp_link_value
773: ,p_user_sequence => 50
774: ,p_effective_date => g_config_effective_date
775: ,p_data_pump_business_grp_name => l_business_group_name
776: ,p_org_classif_code => 'CC'
805: ,p_org_classification => 'HR_LEGAL_EMPLOYER') then
806: if NOT (p_technical_summary_mode) then
807: hrdpp_create_org_classificatio.insert_batch_lines
808: (p_batch_id => p_batch_header_id
809: ,p_link_value => per_ri_config_main.g_global_dp_link_value
810: ,p_user_sequence => 50
811: ,p_effective_date => g_config_effective_date
812: ,p_data_pump_business_grp_name => l_business_group_name
813: ,p_org_classif_code => 'HR_LEGAL_EMPLOYER'
843: ,p_org_classification => 'FR_SOCIETE') then
844: if NOT (p_technical_summary_mode) then
845: hrdpp_create_org_classificatio.insert_batch_lines
846: (p_batch_id => p_batch_header_id
847: ,p_link_value => per_ri_config_main.g_global_dp_link_value
848: ,p_user_sequence => 50
849: ,p_effective_date => g_config_effective_date
850: ,p_data_pump_business_grp_name => l_business_group_name
851: ,p_org_classif_code => 'FR_SOCIETE'
882: ,p_org_classification => 'IN_COMPANY')then
883: if NOT (p_technical_summary_mode) then
884: hrdpp_create_org_classificatio.insert_batch_lines
885: (p_batch_id => p_batch_header_id
886: ,p_link_value => per_ri_config_main.g_global_dp_link_value
887: ,p_user_sequence => 50
888: ,p_effective_date => g_config_effective_date
889: ,p_data_pump_business_grp_name => l_business_group_name
890: ,p_org_classif_code => 'IN_COMPANY'
919: ,p_org_classification => 'HR_LEGAL') then
920: if NOT (p_technical_summary_mode) then
921: hrdpp_create_org_classificatio.insert_batch_lines
922: (p_batch_id => p_batch_header_id
923: ,p_link_value => per_ri_config_main.g_global_dp_link_value
924: ,p_user_sequence => 50
925: ,p_effective_date => g_config_effective_date
926: ,p_data_pump_business_grp_name => l_business_group_name
927: ,p_org_classif_code => 'HR_LEGAL'
948: --
949: if NOT (p_technical_summary_mode) then
950: hrdpp_create_hierarchy_element.insert_batch_lines
951: (p_batch_id => p_batch_header_id
952: ,p_link_value => per_ri_config_main.g_global_dp_link_value
953: ,p_user_sequence => 90
954: ,p_effective_date => g_config_effective_date
955: ,p_date_from => g_config_effective_date
956: ,p_data_pump_business_grp_name => null
1132: if NOT (p_technical_summary_mode) then
1133: hrdpp_create_location.insert_batch_lines
1134: (p_batch_id => p_batch_header_id
1135: ,p_effective_date => g_config_effective_date
1136: ,p_link_value => per_ri_config_main.g_global_dp_link_value
1137: ,p_user_sequence => 10
1138: ,p_location_code => l_location_code
1139: ,p_description => l_description
1140: ,p_address_line_1 => l_address_line_1
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) ;
1342:
1343: if l_bg_country_name = 'INT' then
1401: if NOT (p_technical_summary_mode) then
1402:
1403: hrdpp_create_business_group.insert_batch_lines
1404: (p_batch_id => p_batch_header_id
1405: ,p_link_value => per_ri_config_main.g_global_dp_link_value
1406: ,p_user_sequence => 20
1407: ,p_effective_date => g_config_effective_date
1408: ,p_language_code => hr_api.userenv_lang
1409: ,p_date_from => g_config_effective_date
1421: ,p_max_work_age => null
1422: ,p_location_code => null
1423: ,p_org_user_key => l_business_group_name || sysdate
1424: ,p_grade_flex_stru_code => l_grade_flex_stru_code
1425: ,p_group_flex_stru_code => per_ri_config_main.g_global_pea_structure_name
1426: ,p_job_flex_stru_code => l_job_flex_stru_code
1427: ,p_cost_flex_stru_code => per_ri_config_main.g_global_cst_structure_name
1428: ,p_position_flex_stru_code => l_position_flex_stru_code
1429: ,p_security_group_name => l_security_group_name
1423: ,p_org_user_key => l_business_group_name || sysdate
1424: ,p_grade_flex_stru_code => l_grade_flex_stru_code
1425: ,p_group_flex_stru_code => per_ri_config_main.g_global_pea_structure_name
1426: ,p_job_flex_stru_code => l_job_flex_stru_code
1427: ,p_cost_flex_stru_code => per_ri_config_main.g_global_cst_structure_name
1428: ,p_position_flex_stru_code => l_position_flex_stru_code
1429: ,p_security_group_name => l_security_group_name
1430: ,p_competence_flex_stru_code => per_ri_config_main.g_global_cmp_structure_name);
1431: else
1426: ,p_job_flex_stru_code => l_job_flex_stru_code
1427: ,p_cost_flex_stru_code => per_ri_config_main.g_global_cst_structure_name
1428: ,p_position_flex_stru_code => l_position_flex_stru_code
1429: ,p_security_group_name => l_security_group_name
1430: ,p_competence_flex_stru_code => per_ri_config_main.g_global_cmp_structure_name);
1431: else
1432: hr_utility.set_location('Entering into the other tab as well ', 89);
1433: p_bg_tab(l_bg_count).effective_date := g_config_effective_date;
1434: p_bg_tab(l_bg_count).language_code := hr_api.userenv_lang;
1446: p_bg_tab(l_bg_count).min_work_age := null;
1447: p_bg_tab(l_bg_count).max_work_age := null ;
1448: p_bg_tab(l_bg_count).location_code := null;
1449: p_bg_tab(l_bg_count).grade_flex_stru_code := l_grade_flex_stru_code;
1450: p_bg_tab(l_bg_count).group_flex_stru_code := per_ri_config_main.g_global_pea_structure_name;
1451: p_bg_tab(l_bg_count).job_flex_stru_code := l_job_flex_stru_code;
1452: p_bg_tab(l_bg_count).cost_flex_stru_code := per_ri_config_main.g_global_cst_structure_name;
1453: p_bg_tab(l_bg_count).position_flex_stru_code:= l_position_flex_stru_code;
1454: p_bg_tab(l_bg_count).security_group_name := l_security_group_name;
1448: p_bg_tab(l_bg_count).location_code := null;
1449: p_bg_tab(l_bg_count).grade_flex_stru_code := l_grade_flex_stru_code;
1450: p_bg_tab(l_bg_count).group_flex_stru_code := per_ri_config_main.g_global_pea_structure_name;
1451: p_bg_tab(l_bg_count).job_flex_stru_code := l_job_flex_stru_code;
1452: p_bg_tab(l_bg_count).cost_flex_stru_code := per_ri_config_main.g_global_cst_structure_name;
1453: p_bg_tab(l_bg_count).position_flex_stru_code:= l_position_flex_stru_code;
1454: p_bg_tab(l_bg_count).security_group_name := l_security_group_name;
1455: p_bg_tab(l_bg_count).competence_flex_stru_code := per_ri_config_main.g_global_cmp_structure_name;
1456:
1451: p_bg_tab(l_bg_count).job_flex_stru_code := l_job_flex_stru_code;
1452: p_bg_tab(l_bg_count).cost_flex_stru_code := per_ri_config_main.g_global_cst_structure_name;
1453: p_bg_tab(l_bg_count).position_flex_stru_code:= l_position_flex_stru_code;
1454: p_bg_tab(l_bg_count).security_group_name := l_security_group_name;
1455: p_bg_tab(l_bg_count).competence_flex_stru_code := per_ri_config_main.g_global_cmp_structure_name;
1456:
1457: l_bg_count := l_bg_count +1 ;
1458:
1459: -- also populate secuity profiles table