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.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_LOCATIONS

Line 6118: -- location_id is foreign key of hz_locations.location_id.

6114: END IF;
6115:
6116: END IF;
6117:
6118: -- location_id is foreign key of hz_locations.location_id.
6119: -- do not need to check during update because location_id is
6120: -- non-updateable.
6121: IF p_create_update_flag = 'C'
6122: AND

Line 6130: -- was added to hz_party_sites. It is denormalized from hz_locations.

6126: THEN
6127: BEGIN
6128:
6129: -- Bug 2197181: for mix-n-match, column actual_content_source
6130: -- was added to hz_party_sites. It is denormalized from hz_locations.
6131: -- Therefore, it is selected from hz_locations to be passed back
6132: -- to create_party_site API.
6133:
6134: SELECT actual_content_source

Line 6131: -- Therefore, it is selected from hz_locations to be passed back

6127: BEGIN
6128:
6129: -- Bug 2197181: for mix-n-match, column actual_content_source
6130: -- was added to hz_party_sites. It is denormalized from hz_locations.
6131: -- Therefore, it is selected from hz_locations to be passed back
6132: -- to create_party_site API.
6133:
6134: SELECT actual_content_source
6135: INTO x_loc_actual_content_source

Line 6136: FROM HZ_LOCATIONS

6132: -- to create_party_site API.
6133:
6134: SELECT actual_content_source
6135: INTO x_loc_actual_content_source
6136: FROM HZ_LOCATIONS
6137: WHERE LOCATION_ID = p_party_site_rec.location_id;
6138: EXCEPTION
6139: WHEN NO_DATA_FOUND THEN
6140: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 6143: fnd_message.set_token('TABLE', 'hz_locations');

6139: WHEN NO_DATA_FOUND THEN
6140: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6141: fnd_message.set_token('FK', 'location_id');
6142: fnd_message.set_token('COLUMN', 'location_id');
6143: fnd_message.set_token('TABLE', 'hz_locations');
6144: fnd_msg_pub.add;
6145: x_return_status := fnd_api.g_ret_sts_error;
6146: END;
6147:

Line 6150: 'location_id is foreign key of hz_locations. ' ||

6146: END;
6147:
6148: /*IF g_debug THEN
6149: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
6150: 'location_id is foreign key of hz_locations. ' ||
6151: 'x_return_status = ' || x_return_status, l_debug_prefix);
6152: END IF;
6153: */
6154: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 6155: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'location_id is foreign key of hz_locations. ' ||

6151: 'x_return_status = ' || x_return_status, l_debug_prefix);
6152: END IF;
6153: */
6154: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6155: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'location_id is foreign key of hz_locations. ' ||
6156: 'x_return_status = ' || x_return_status,
6157: p_msg_level=>fnd_log.level_statement);
6158: END IF;
6159:

Line 11052: l_content_source_type HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;

11048: ) IS
11049:
11050: l_dummy VARCHAR2(1);
11051: l_address_effective_date DATE;
11052: l_content_source_type HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
11053: l_created_by_module VARCHAR2(150);
11054: l_application_id NUMBER;
11055: l_debug_prefix VARCHAR2(30) := '';
11056:

Line 11058: db_actual_content_source HZ_LOCATIONS.ACTUAL_CONTENT_SOURCE%TYPE;

11054: l_application_id NUMBER;
11055: l_debug_prefix VARCHAR2(30) := '';
11056:
11057: -- Bug 2197181: added for mix-n-match
11058: db_actual_content_source HZ_LOCATIONS.ACTUAL_CONTENT_SOURCE%TYPE;
11059:
11060: -- Bug 3330754: added to support attribute level non-updateable checking for third
11061: -- party records.
11062: db_orig_system_reference HZ_LOCATIONS.ORIG_SYSTEM_REFERENCE%TYPE;

Line 11062: db_orig_system_reference HZ_LOCATIONS.ORIG_SYSTEM_REFERENCE%TYPE;

11058: db_actual_content_source HZ_LOCATIONS.ACTUAL_CONTENT_SOURCE%TYPE;
11059:
11060: -- Bug 3330754: added to support attribute level non-updateable checking for third
11061: -- party records.
11062: db_orig_system_reference HZ_LOCATIONS.ORIG_SYSTEM_REFERENCE%TYPE;
11063: db_country HZ_LOCATIONS.COUNTRY%TYPE;
11064: db_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;

Line 11063: db_country HZ_LOCATIONS.COUNTRY%TYPE;

11059:
11060: -- Bug 3330754: added to support attribute level non-updateable checking for third
11061: -- party records.
11062: db_orig_system_reference HZ_LOCATIONS.ORIG_SYSTEM_REFERENCE%TYPE;
11063: db_country HZ_LOCATIONS.COUNTRY%TYPE;
11064: db_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;

Line 11064: db_address1 HZ_LOCATIONS.ADDRESS1%TYPE;

11060: -- Bug 3330754: added to support attribute level non-updateable checking for third
11061: -- party records.
11062: db_orig_system_reference HZ_LOCATIONS.ORIG_SYSTEM_REFERENCE%TYPE;
11063: db_country HZ_LOCATIONS.COUNTRY%TYPE;
11064: db_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
11068: db_city HZ_LOCATIONS.CITY%TYPE;

Line 11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;

11061: -- party records.
11062: db_orig_system_reference HZ_LOCATIONS.ORIG_SYSTEM_REFERENCE%TYPE;
11063: db_country HZ_LOCATIONS.COUNTRY%TYPE;
11064: db_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
11068: db_city HZ_LOCATIONS.CITY%TYPE;
11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;

Line 11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;

11062: db_orig_system_reference HZ_LOCATIONS.ORIG_SYSTEM_REFERENCE%TYPE;
11063: db_country HZ_LOCATIONS.COUNTRY%TYPE;
11064: db_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
11068: db_city HZ_LOCATIONS.CITY%TYPE;
11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
11070: db_state HZ_LOCATIONS.STATE%TYPE;

Line 11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;

11063: db_country HZ_LOCATIONS.COUNTRY%TYPE;
11064: db_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
11068: db_city HZ_LOCATIONS.CITY%TYPE;
11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
11070: db_state HZ_LOCATIONS.STATE%TYPE;
11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 11068: db_city HZ_LOCATIONS.CITY%TYPE;

11064: db_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
11068: db_city HZ_LOCATIONS.CITY%TYPE;
11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
11070: db_state HZ_LOCATIONS.STATE%TYPE;
11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;
11072: db_county HZ_LOCATIONS.COUNTY%TYPE;

Line 11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;

11065: db_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
11068: db_city HZ_LOCATIONS.CITY%TYPE;
11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
11070: db_state HZ_LOCATIONS.STATE%TYPE;
11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;
11072: db_county HZ_LOCATIONS.COUNTY%TYPE;
11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;

Line 11070: db_state HZ_LOCATIONS.STATE%TYPE;

11066: db_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
11068: db_city HZ_LOCATIONS.CITY%TYPE;
11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
11070: db_state HZ_LOCATIONS.STATE%TYPE;
11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;
11072: db_county HZ_LOCATIONS.COUNTY%TYPE;
11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;
11074: db_clli_code HZ_LOCATIONS.CLLI_CODE%TYPE;

Line 11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;

11067: db_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
11068: db_city HZ_LOCATIONS.CITY%TYPE;
11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
11070: db_state HZ_LOCATIONS.STATE%TYPE;
11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;
11072: db_county HZ_LOCATIONS.COUNTY%TYPE;
11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;
11074: db_clli_code HZ_LOCATIONS.CLLI_CODE%TYPE;
11075: db_delivery_point_code HZ_LOCATIONS.DELIVERY_POINT_CODE%TYPE;

Line 11072: db_county HZ_LOCATIONS.COUNTY%TYPE;

11068: db_city HZ_LOCATIONS.CITY%TYPE;
11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
11070: db_state HZ_LOCATIONS.STATE%TYPE;
11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;
11072: db_county HZ_LOCATIONS.COUNTY%TYPE;
11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;
11074: db_clli_code HZ_LOCATIONS.CLLI_CODE%TYPE;
11075: db_delivery_point_code HZ_LOCATIONS.DELIVERY_POINT_CODE%TYPE;
11076: db_location_directions HZ_LOCATIONS.LOCATION_DIRECTIONS%TYPE;

Line 11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;

11069: db_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
11070: db_state HZ_LOCATIONS.STATE%TYPE;
11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;
11072: db_county HZ_LOCATIONS.COUNTY%TYPE;
11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;
11074: db_clli_code HZ_LOCATIONS.CLLI_CODE%TYPE;
11075: db_delivery_point_code HZ_LOCATIONS.DELIVERY_POINT_CODE%TYPE;
11076: db_location_directions HZ_LOCATIONS.LOCATION_DIRECTIONS%TYPE;
11077: l_return_status VARCHAR2(1);

Line 11074: db_clli_code HZ_LOCATIONS.CLLI_CODE%TYPE;

11070: db_state HZ_LOCATIONS.STATE%TYPE;
11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;
11072: db_county HZ_LOCATIONS.COUNTY%TYPE;
11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;
11074: db_clli_code HZ_LOCATIONS.CLLI_CODE%TYPE;
11075: db_delivery_point_code HZ_LOCATIONS.DELIVERY_POINT_CODE%TYPE;
11076: db_location_directions HZ_LOCATIONS.LOCATION_DIRECTIONS%TYPE;
11077: l_return_status VARCHAR2(1);
11078:

Line 11075: db_delivery_point_code HZ_LOCATIONS.DELIVERY_POINT_CODE%TYPE;

11071: db_province HZ_LOCATIONS.PROVINCE%TYPE;
11072: db_county HZ_LOCATIONS.COUNTY%TYPE;
11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;
11074: db_clli_code HZ_LOCATIONS.CLLI_CODE%TYPE;
11075: db_delivery_point_code HZ_LOCATIONS.DELIVERY_POINT_CODE%TYPE;
11076: db_location_directions HZ_LOCATIONS.LOCATION_DIRECTIONS%TYPE;
11077: l_return_status VARCHAR2(1);
11078:
11079: l_vertex_taxware_installed BOOLEAN;

Line 11076: db_location_directions HZ_LOCATIONS.LOCATION_DIRECTIONS%TYPE;

11072: db_county HZ_LOCATIONS.COUNTY%TYPE;
11073: db_postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE;
11074: db_clli_code HZ_LOCATIONS.CLLI_CODE%TYPE;
11075: db_delivery_point_code HZ_LOCATIONS.DELIVERY_POINT_CODE%TYPE;
11076: db_location_directions HZ_LOCATIONS.LOCATION_DIRECTIONS%TYPE;
11077: l_return_status VARCHAR2(1);
11078:
11079: l_vertex_taxware_installed BOOLEAN;
11080:

Line 11147: FROM HZ_LOCATIONS

11143: db_postal_plus4_code,
11144: db_clli_code,
11145: db_delivery_point_code,
11146: db_location_directions
11147: FROM HZ_LOCATIONS
11148: WHERE ROWID = p_rowid;
11149: END IF;
11150:
11151: --------------------

Line 11244: p_entity_name => 'HZ_LOCATIONS',

11240: p_content_source_type => p_location_rec.content_source_type,
11241: p_old_content_source_type => l_content_source_type,
11242: p_actual_content_source => p_location_rec.actual_content_source,
11243: p_old_actual_content_source => db_actual_content_source,
11244: p_entity_name => 'HZ_LOCATIONS',
11245: x_return_status => x_return_status );
11246:
11247: -- Bug 3330754: added to support attribute level non-updateable checking for third
11248: -- party records.

Line 11377: p_entity_name => 'HZ_LOCATIONS',

11373:
11374: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege(
11375: p_actual_content_source => db_actual_content_source,
11376: p_new_actual_content_source => p_location_rec.actual_content_source,
11377: p_entity_name => 'HZ_LOCATIONS',
11378: x_return_status => x_return_status);
11379: -- Bug 4693719 : set global variable to Y
11380: HZ_UTILITY_V2PUB.G_UPDATE_ACS := 'Y';
11381: /*

Line 11736: FROM HZ_LOCATIONS

11732: attribute6, attribute7, attribute8, attribute9, attribute10
11733: INTO o_country, o_city, o_state, o_county, o_province, o_postal_code,
11734: o_attribute1,o_attribute2,o_attribute3,o_attribute4,o_attribute5,
11735: o_attribute6,o_attribute7,o_attribute8,o_attribute9,o_attribute10
11736: FROM HZ_LOCATIONS
11737: WHERE location_id = p_location_rec.location_id ;
11738:
11739: IF ( o_country <> p_location_rec.country
11740: OR o_city <> p_location_rec.city