DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_DATAPUMP_ENTITY dependencies on PER_RI_CONFIG_MAIN

Line 135: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;

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

Line 152: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 166: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 205: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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'

Line 235: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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'

Line 255: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 433: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;

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

Line 451: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 467: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 498: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 542: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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'

Line 706: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;

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

Line 722: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 735: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 772: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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'

Line 809: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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'

Line 847: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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'

Line 886: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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'

Line 923: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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'

Line 952: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 1136: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 1339: || ' ' || l_bg_country_name || per_ri_config_main.g_bg_name_suffix_string;

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

Line 1405: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

Line 1425: ,p_group_flex_stru_code => per_ri_config_main.g_global_pea_structure_name

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

Line 1427: ,p_cost_flex_stru_code => per_ri_config_main.g_global_cst_structure_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

Line 1430: ,p_competence_flex_stru_code => per_ri_config_main.g_global_cmp_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
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;

Line 1450: p_bg_tab(l_bg_count).group_flex_stru_code := per_ri_config_main.g_global_pea_structure_name;

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;

Line 1452: p_bg_tab(l_bg_count).cost_flex_stru_code := per_ri_config_main.g_global_cst_structure_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:

Line 1455: p_bg_tab(l_bg_count).competence_flex_stru_code := per_ri_config_main.g_global_cmp_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:
1457: l_bg_count := l_bg_count +1 ;
1458:
1459: -- also populate secuity profiles table