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_MERGE_PKG dependencies on HZ_LOCATIONS

Line 6117: FROM HZ_LOCATIONS l, HZ_PARTY_SITES ps

6113:
6114: CURSOR c_cont_source IS
6115: SELECT l.CONTENT_SOURCE_TYPE, l.last_update_date, ps.party_id,
6116: ps.identifying_address_flag, ps.party_site_number
6117: FROM HZ_LOCATIONS l, HZ_PARTY_SITES ps
6118: WHERE ps.party_site_id = p_from_id
6119: AND ps.location_id = l.location_id;
6120:
6121: CURSOR c_merge_to IS

Line 6126: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps

6122: SELECT ps.party_id, loc.content_source_type,loc.country,
6123: loc.address1, loc.address2, loc.address3, loc.address4,
6124: loc.city, loc.postal_code, loc.state, loc.province,
6125: loc.county,loc.location_id
6126: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps
6127: WHERE ps.party_site_id = x_to_id
6128: AND ps.location_id = loc.location_id;
6129: --bug 4569674
6130: /*CURSOR c_loc_assignments IS

Line 6144: HZ_LOCATIONS loc

6140: */
6141: CURSOR c_locations(x_party_site_id NUMBER) IS
6142: SELECT loc.location_id
6143: FROM HZ_PARTY_SITES ps,
6144: HZ_LOCATIONS loc
6145: WHERE ps.location_id = loc.location_id
6146: AND ps.party_site_id = x_party_site_id;
6147:
6148: CURSOR c_from_party_type IS

Line 6157: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;

6153: AND ps.party_site_id = p_from_id;
6154:
6155: l_from_last_upd_date DATE;
6156: l_to_last_upd_date DATE;
6157: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6158: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6159: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;

Line 6158: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;

6154:
6155: l_from_last_upd_date DATE;
6156: l_to_last_upd_date DATE;
6157: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6158: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6159: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;

Line 6159: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;

6155: l_from_last_upd_date DATE;
6156: l_to_last_upd_date DATE;
6157: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6158: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6159: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;

Line 6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;

6156: l_to_last_upd_date DATE;
6157: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6158: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6159: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;

Line 6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;

6157: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6158: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6159: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6165: l_city HZ_LOCATIONS.CITY%TYPE;

Line 6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;

6158: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6159: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6165: l_city HZ_LOCATIONS.CITY%TYPE;
6166: l_state HZ_LOCATIONS.STATE%TYPE;

Line 6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;

6159: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6165: l_city HZ_LOCATIONS.CITY%TYPE;
6166: l_state HZ_LOCATIONS.STATE%TYPE;
6167: l_county HZ_LOCATIONS.COUNTY%TYPE;

Line 6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;

6160: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6165: l_city HZ_LOCATIONS.CITY%TYPE;
6166: l_state HZ_LOCATIONS.STATE%TYPE;
6167: l_county HZ_LOCATIONS.COUNTY%TYPE;
6168: l_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 6165: l_city HZ_LOCATIONS.CITY%TYPE;

6161: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6165: l_city HZ_LOCATIONS.CITY%TYPE;
6166: l_state HZ_LOCATIONS.STATE%TYPE;
6167: l_county HZ_LOCATIONS.COUNTY%TYPE;
6168: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6169: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;

Line 6166: l_state HZ_LOCATIONS.STATE%TYPE;

6162: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6165: l_city HZ_LOCATIONS.CITY%TYPE;
6166: l_state HZ_LOCATIONS.STATE%TYPE;
6167: l_county HZ_LOCATIONS.COUNTY%TYPE;
6168: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6169: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;
6170: l_from_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;

Line 6167: l_county HZ_LOCATIONS.COUNTY%TYPE;

6163: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6165: l_city HZ_LOCATIONS.CITY%TYPE;
6166: l_state HZ_LOCATIONS.STATE%TYPE;
6167: l_county HZ_LOCATIONS.COUNTY%TYPE;
6168: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6169: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;
6170: l_from_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6171: l_to_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;

Line 6168: l_province HZ_LOCATIONS.PROVINCE%TYPE;

6164: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6165: l_city HZ_LOCATIONS.CITY%TYPE;
6166: l_state HZ_LOCATIONS.STATE%TYPE;
6167: l_county HZ_LOCATIONS.COUNTY%TYPE;
6168: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6169: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;
6170: l_from_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6171: l_to_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6172: l_ident_flag HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG%TYPE;

Line 6169: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;

6165: l_city HZ_LOCATIONS.CITY%TYPE;
6166: l_state HZ_LOCATIONS.STATE%TYPE;
6167: l_county HZ_LOCATIONS.COUNTY%TYPE;
6168: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6169: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;
6170: l_from_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6171: l_to_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6172: l_ident_flag HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG%TYPE;
6173: l_merge_to_id NUMBER;

Line 6193: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;

6189: l_ps_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
6190: l_actual_cont_source VARCHAR2(30);
6191: --l_loc_id HZ_LOC_ASSIGNMENTS.LOC_ID%TYPE; bug 4569674
6192: --l_org_id HZ_LOC_ASSIGNMENTS.ORG_ID%TYPE;
6193: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6194: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6195: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6196: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6197: map_ps_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

Line 6194: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;

6190: l_actual_cont_source VARCHAR2(30);
6191: --l_loc_id HZ_LOC_ASSIGNMENTS.LOC_ID%TYPE; bug 4569674
6192: --l_org_id HZ_LOC_ASSIGNMENTS.ORG_ID%TYPE;
6193: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6194: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6195: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6196: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6197: map_ps_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
6198: BEGIN

Line 6196: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;

6192: --l_org_id HZ_LOC_ASSIGNMENTS.ORG_ID%TYPE;
6193: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6194: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6195: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6196: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6197: map_ps_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
6198: BEGIN
6199:
6200: