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_DATAPUMP_ENTITY dependencies on PER_RI_CONFIG_LOCATIONS

Line 59: l_ent_location_code per_ri_config_locations.description%type; -- fix for 4457389

55: l_enterprise_location_id per_ri_config_information.config_information1%type;
56:
57: l_business_group_country_code per_business_groups.name%type;
58: l_business_group_name per_business_groups.name%type;
59: l_ent_location_code per_ri_config_locations.description%type; -- fix for 4457389
60:
61:
62: l_hr_legal_mand_org_info_types boolean;
63: l_ent_count number(10) := 0;

Line 359: l_oc_location_code per_ri_config_locations.description%type; -- fix for 4457389

355: l_operating_comp_location_id per_ri_config_information.config_information1%type;
356:
357: l_business_group_country_code per_business_groups.name%type;
358: l_business_group_name per_business_groups.name%type;
359: l_oc_location_code per_ri_config_locations.description%type; -- fix for 4457389
360: l_enterprise_name per_ri_config_information.config_information1%type;
361:
362: l_oc_count number(10) := 0;
363: l_oc_class_count number(10) := 0;

Line 635: l_le_location_code per_ri_config_locations.description%type; -- fix for 4457389

631: l_error_message varchar2(360);
632:
633: l_business_group_country_code per_business_groups.name%type;
634: l_business_group_name per_business_groups.name%type;
635: l_le_location_code per_ri_config_locations.description%type; -- fix for 4457389
636: l_mandatory_org_info_types boolean default true;
637: l_multi_tenancy boolean := false;
638: l_system_model varchar2(10) := 'N';
639: l_sec_group_id varchar2(10);

Line 1043: from per_ri_config_locations

1039: loc_information18,
1040: loc_information19,
1041: loc_information20,
1042: object_version_number
1043: from per_ri_config_locations
1044: where configuration_code = cp_configuration_code;
1045:
1046: -- Get the Country Code when style is generic
1047: CURSOR csr_get_country_code(cp_country_name in varchar2) IS

Line 1052: l_configuration_code per_ri_config_locations.configuration_code%type;

1048: SELECT territory_code
1049: FROM fnd_territories_vl
1050: WHERE territory_short_name = cp_country_name;
1051:
1052: l_configuration_code per_ri_config_locations.configuration_code%type;
1053: l_configuration_context per_ri_config_locations.configuration_context%type;
1054: l_location_id per_ri_config_locations.location_id%type;
1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389
1056: l_description per_ri_config_locations.description %type;

Line 1053: l_configuration_context per_ri_config_locations.configuration_context%type;

1049: FROM fnd_territories_vl
1050: WHERE territory_short_name = cp_country_name;
1051:
1052: l_configuration_code per_ri_config_locations.configuration_code%type;
1053: l_configuration_context per_ri_config_locations.configuration_context%type;
1054: l_location_id per_ri_config_locations.location_id%type;
1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389
1056: l_description per_ri_config_locations.description %type;
1057: l_style per_ri_config_locations.style%type;

Line 1054: l_location_id per_ri_config_locations.location_id%type;

1050: WHERE territory_short_name = cp_country_name;
1051:
1052: l_configuration_code per_ri_config_locations.configuration_code%type;
1053: l_configuration_context per_ri_config_locations.configuration_context%type;
1054: l_location_id per_ri_config_locations.location_id%type;
1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389
1056: l_description per_ri_config_locations.description %type;
1057: l_style per_ri_config_locations.style%type;
1058: l_address_line_1 per_ri_config_locations.address_line_1%type;

Line 1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389

1051:
1052: l_configuration_code per_ri_config_locations.configuration_code%type;
1053: l_configuration_context per_ri_config_locations.configuration_context%type;
1054: l_location_id per_ri_config_locations.location_id%type;
1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389
1056: l_description per_ri_config_locations.description %type;
1057: l_style per_ri_config_locations.style%type;
1058: l_address_line_1 per_ri_config_locations.address_line_1%type;
1059: l_address_line_2 per_ri_config_locations.address_line_2%type;

Line 1056: l_description per_ri_config_locations.description %type;

1052: l_configuration_code per_ri_config_locations.configuration_code%type;
1053: l_configuration_context per_ri_config_locations.configuration_context%type;
1054: l_location_id per_ri_config_locations.location_id%type;
1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389
1056: l_description per_ri_config_locations.description %type;
1057: l_style per_ri_config_locations.style%type;
1058: l_address_line_1 per_ri_config_locations.address_line_1%type;
1059: l_address_line_2 per_ri_config_locations.address_line_2%type;
1060: l_address_line_3 per_ri_config_locations.address_line_3%type;

Line 1057: l_style per_ri_config_locations.style%type;

1053: l_configuration_context per_ri_config_locations.configuration_context%type;
1054: l_location_id per_ri_config_locations.location_id%type;
1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389
1056: l_description per_ri_config_locations.description %type;
1057: l_style per_ri_config_locations.style%type;
1058: l_address_line_1 per_ri_config_locations.address_line_1%type;
1059: l_address_line_2 per_ri_config_locations.address_line_2%type;
1060: l_address_line_3 per_ri_config_locations.address_line_3%type;
1061: l_town_or_city per_ri_config_locations.town_or_city%type;

Line 1058: l_address_line_1 per_ri_config_locations.address_line_1%type;

1054: l_location_id per_ri_config_locations.location_id%type;
1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389
1056: l_description per_ri_config_locations.description %type;
1057: l_style per_ri_config_locations.style%type;
1058: l_address_line_1 per_ri_config_locations.address_line_1%type;
1059: l_address_line_2 per_ri_config_locations.address_line_2%type;
1060: l_address_line_3 per_ri_config_locations.address_line_3%type;
1061: l_town_or_city per_ri_config_locations.town_or_city%type;
1062: l_country per_ri_config_locations.country%type;

Line 1059: l_address_line_2 per_ri_config_locations.address_line_2%type;

1055: l_location_code per_ri_config_locations.description%type; -- fix for 4457389
1056: l_description per_ri_config_locations.description %type;
1057: l_style per_ri_config_locations.style%type;
1058: l_address_line_1 per_ri_config_locations.address_line_1%type;
1059: l_address_line_2 per_ri_config_locations.address_line_2%type;
1060: l_address_line_3 per_ri_config_locations.address_line_3%type;
1061: l_town_or_city per_ri_config_locations.town_or_city%type;
1062: l_country per_ri_config_locations.country%type;
1063: l_postal_code per_ri_config_locations.postal_code%type;

Line 1060: l_address_line_3 per_ri_config_locations.address_line_3%type;

1056: l_description per_ri_config_locations.description %type;
1057: l_style per_ri_config_locations.style%type;
1058: l_address_line_1 per_ri_config_locations.address_line_1%type;
1059: l_address_line_2 per_ri_config_locations.address_line_2%type;
1060: l_address_line_3 per_ri_config_locations.address_line_3%type;
1061: l_town_or_city per_ri_config_locations.town_or_city%type;
1062: l_country per_ri_config_locations.country%type;
1063: l_postal_code per_ri_config_locations.postal_code%type;
1064: l_region_1 per_ri_config_locations.region_1%type;

Line 1061: l_town_or_city per_ri_config_locations.town_or_city%type;

1057: l_style per_ri_config_locations.style%type;
1058: l_address_line_1 per_ri_config_locations.address_line_1%type;
1059: l_address_line_2 per_ri_config_locations.address_line_2%type;
1060: l_address_line_3 per_ri_config_locations.address_line_3%type;
1061: l_town_or_city per_ri_config_locations.town_or_city%type;
1062: l_country per_ri_config_locations.country%type;
1063: l_postal_code per_ri_config_locations.postal_code%type;
1064: l_region_1 per_ri_config_locations.region_1%type;
1065: l_region_2 per_ri_config_locations.region_2%type;

Line 1062: l_country per_ri_config_locations.country%type;

1058: l_address_line_1 per_ri_config_locations.address_line_1%type;
1059: l_address_line_2 per_ri_config_locations.address_line_2%type;
1060: l_address_line_3 per_ri_config_locations.address_line_3%type;
1061: l_town_or_city per_ri_config_locations.town_or_city%type;
1062: l_country per_ri_config_locations.country%type;
1063: l_postal_code per_ri_config_locations.postal_code%type;
1064: l_region_1 per_ri_config_locations.region_1%type;
1065: l_region_2 per_ri_config_locations.region_2%type;
1066: l_region_3 per_ri_config_locations.region_3%type;

Line 1063: l_postal_code per_ri_config_locations.postal_code%type;

1059: l_address_line_2 per_ri_config_locations.address_line_2%type;
1060: l_address_line_3 per_ri_config_locations.address_line_3%type;
1061: l_town_or_city per_ri_config_locations.town_or_city%type;
1062: l_country per_ri_config_locations.country%type;
1063: l_postal_code per_ri_config_locations.postal_code%type;
1064: l_region_1 per_ri_config_locations.region_1%type;
1065: l_region_2 per_ri_config_locations.region_2%type;
1066: l_region_3 per_ri_config_locations.region_3%type;
1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;

Line 1064: l_region_1 per_ri_config_locations.region_1%type;

1060: l_address_line_3 per_ri_config_locations.address_line_3%type;
1061: l_town_or_city per_ri_config_locations.town_or_city%type;
1062: l_country per_ri_config_locations.country%type;
1063: l_postal_code per_ri_config_locations.postal_code%type;
1064: l_region_1 per_ri_config_locations.region_1%type;
1065: l_region_2 per_ri_config_locations.region_2%type;
1066: l_region_3 per_ri_config_locations.region_3%type;
1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;
1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;

Line 1065: l_region_2 per_ri_config_locations.region_2%type;

1061: l_town_or_city per_ri_config_locations.town_or_city%type;
1062: l_country per_ri_config_locations.country%type;
1063: l_postal_code per_ri_config_locations.postal_code%type;
1064: l_region_1 per_ri_config_locations.region_1%type;
1065: l_region_2 per_ri_config_locations.region_2%type;
1066: l_region_3 per_ri_config_locations.region_3%type;
1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;
1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;
1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;

Line 1066: l_region_3 per_ri_config_locations.region_3%type;

1062: l_country per_ri_config_locations.country%type;
1063: l_postal_code per_ri_config_locations.postal_code%type;
1064: l_region_1 per_ri_config_locations.region_1%type;
1065: l_region_2 per_ri_config_locations.region_2%type;
1066: l_region_3 per_ri_config_locations.region_3%type;
1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;
1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;
1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;
1070: l_loc_information13 per_ri_config_locations.loc_information13%type;

Line 1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;

1063: l_postal_code per_ri_config_locations.postal_code%type;
1064: l_region_1 per_ri_config_locations.region_1%type;
1065: l_region_2 per_ri_config_locations.region_2%type;
1066: l_region_3 per_ri_config_locations.region_3%type;
1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;
1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;
1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;
1070: l_loc_information13 per_ri_config_locations.loc_information13%type;
1071: l_loc_information14 per_ri_config_locations.loc_information14%type;

Line 1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;

1064: l_region_1 per_ri_config_locations.region_1%type;
1065: l_region_2 per_ri_config_locations.region_2%type;
1066: l_region_3 per_ri_config_locations.region_3%type;
1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;
1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;
1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;
1070: l_loc_information13 per_ri_config_locations.loc_information13%type;
1071: l_loc_information14 per_ri_config_locations.loc_information14%type;
1072: l_loc_information15 per_ri_config_locations.loc_information15%type;

Line 1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;

1065: l_region_2 per_ri_config_locations.region_2%type;
1066: l_region_3 per_ri_config_locations.region_3%type;
1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;
1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;
1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;
1070: l_loc_information13 per_ri_config_locations.loc_information13%type;
1071: l_loc_information14 per_ri_config_locations.loc_information14%type;
1072: l_loc_information15 per_ri_config_locations.loc_information15%type;
1073: l_loc_information16 per_ri_config_locations.loc_information16%type;

Line 1070: l_loc_information13 per_ri_config_locations.loc_information13%type;

1066: l_region_3 per_ri_config_locations.region_3%type;
1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;
1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;
1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;
1070: l_loc_information13 per_ri_config_locations.loc_information13%type;
1071: l_loc_information14 per_ri_config_locations.loc_information14%type;
1072: l_loc_information15 per_ri_config_locations.loc_information15%type;
1073: l_loc_information16 per_ri_config_locations.loc_information16%type;
1074: l_loc_information17 per_ri_config_locations.loc_information17%type;

Line 1071: l_loc_information14 per_ri_config_locations.loc_information14%type;

1067: l_telephone_number_1 per_ri_config_locations.telephone_number_1%type;
1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;
1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;
1070: l_loc_information13 per_ri_config_locations.loc_information13%type;
1071: l_loc_information14 per_ri_config_locations.loc_information14%type;
1072: l_loc_information15 per_ri_config_locations.loc_information15%type;
1073: l_loc_information16 per_ri_config_locations.loc_information16%type;
1074: l_loc_information17 per_ri_config_locations.loc_information17%type;
1075: l_loc_information18 per_ri_config_locations.loc_information18%type;

Line 1072: l_loc_information15 per_ri_config_locations.loc_information15%type;

1068: l_telephone_number_2 per_ri_config_locations.telephone_number_2%type;
1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;
1070: l_loc_information13 per_ri_config_locations.loc_information13%type;
1071: l_loc_information14 per_ri_config_locations.loc_information14%type;
1072: l_loc_information15 per_ri_config_locations.loc_information15%type;
1073: l_loc_information16 per_ri_config_locations.loc_information16%type;
1074: l_loc_information17 per_ri_config_locations.loc_information17%type;
1075: l_loc_information18 per_ri_config_locations.loc_information18%type;
1076: l_loc_information19 per_ri_config_locations.loc_information19%type;

Line 1073: l_loc_information16 per_ri_config_locations.loc_information16%type;

1069: l_telephone_number_3 per_ri_config_locations.telephone_number_3%type;
1070: l_loc_information13 per_ri_config_locations.loc_information13%type;
1071: l_loc_information14 per_ri_config_locations.loc_information14%type;
1072: l_loc_information15 per_ri_config_locations.loc_information15%type;
1073: l_loc_information16 per_ri_config_locations.loc_information16%type;
1074: l_loc_information17 per_ri_config_locations.loc_information17%type;
1075: l_loc_information18 per_ri_config_locations.loc_information18%type;
1076: l_loc_information19 per_ri_config_locations.loc_information19%type;
1077: l_loc_information20 per_ri_config_locations.loc_information20%type;

Line 1074: l_loc_information17 per_ri_config_locations.loc_information17%type;

1070: l_loc_information13 per_ri_config_locations.loc_information13%type;
1071: l_loc_information14 per_ri_config_locations.loc_information14%type;
1072: l_loc_information15 per_ri_config_locations.loc_information15%type;
1073: l_loc_information16 per_ri_config_locations.loc_information16%type;
1074: l_loc_information17 per_ri_config_locations.loc_information17%type;
1075: l_loc_information18 per_ri_config_locations.loc_information18%type;
1076: l_loc_information19 per_ri_config_locations.loc_information19%type;
1077: l_loc_information20 per_ri_config_locations.loc_information20%type;
1078: l_object_version_number per_ri_config_locations.object_version_number%type;

Line 1075: l_loc_information18 per_ri_config_locations.loc_information18%type;

1071: l_loc_information14 per_ri_config_locations.loc_information14%type;
1072: l_loc_information15 per_ri_config_locations.loc_information15%type;
1073: l_loc_information16 per_ri_config_locations.loc_information16%type;
1074: l_loc_information17 per_ri_config_locations.loc_information17%type;
1075: l_loc_information18 per_ri_config_locations.loc_information18%type;
1076: l_loc_information19 per_ri_config_locations.loc_information19%type;
1077: l_loc_information20 per_ri_config_locations.loc_information20%type;
1078: l_object_version_number per_ri_config_locations.object_version_number%type;
1079:

Line 1076: l_loc_information19 per_ri_config_locations.loc_information19%type;

1072: l_loc_information15 per_ri_config_locations.loc_information15%type;
1073: l_loc_information16 per_ri_config_locations.loc_information16%type;
1074: l_loc_information17 per_ri_config_locations.loc_information17%type;
1075: l_loc_information18 per_ri_config_locations.loc_information18%type;
1076: l_loc_information19 per_ri_config_locations.loc_information19%type;
1077: l_loc_information20 per_ri_config_locations.loc_information20%type;
1078: l_object_version_number per_ri_config_locations.object_version_number%type;
1079:
1080: l_locations_count number(10) := 0;

Line 1077: l_loc_information20 per_ri_config_locations.loc_information20%type;

1073: l_loc_information16 per_ri_config_locations.loc_information16%type;
1074: l_loc_information17 per_ri_config_locations.loc_information17%type;
1075: l_loc_information18 per_ri_config_locations.loc_information18%type;
1076: l_loc_information19 per_ri_config_locations.loc_information19%type;
1077: l_loc_information20 per_ri_config_locations.loc_information20%type;
1078: l_object_version_number per_ri_config_locations.object_version_number%type;
1079:
1080: l_locations_count number(10) := 0;
1081: l_proc varchar2(72) := g_package || 'create_locations_batch_lines';

Line 1078: l_object_version_number per_ri_config_locations.object_version_number%type;

1074: l_loc_information17 per_ri_config_locations.loc_information17%type;
1075: l_loc_information18 per_ri_config_locations.loc_information18%type;
1076: l_loc_information19 per_ri_config_locations.loc_information19%type;
1077: l_loc_information20 per_ri_config_locations.loc_information20%type;
1078: l_object_version_number per_ri_config_locations.object_version_number%type;
1079:
1080: l_locations_count number(10) := 0;
1081: l_proc varchar2(72) := g_package || 'create_locations_batch_lines';
1082: l_log_message varchar2(360);