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 6247: FROM HZ_LOCATIONS l, HZ_PARTY_SITES ps

6243:
6244: CURSOR c_cont_source IS
6245: SELECT l.CONTENT_SOURCE_TYPE, l.last_update_date, ps.party_id,
6246: ps.identifying_address_flag, ps.party_site_number
6247: FROM HZ_LOCATIONS l, HZ_PARTY_SITES ps
6248: WHERE ps.party_site_id = p_from_id
6249: AND ps.location_id = l.location_id;
6250:
6251: CURSOR c_merge_to IS

Line 6256: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps

6252: SELECT ps.party_id, loc.content_source_type,loc.country,
6253: loc.address1, loc.address2, loc.address3, loc.address4,
6254: loc.city, loc.postal_code, loc.state, loc.province,
6255: loc.county,loc.location_id
6256: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps
6257: WHERE ps.party_site_id = x_to_id
6258: AND ps.location_id = loc.location_id;
6259: --bug 4569674
6260: /*CURSOR c_loc_assignments IS

Line 6274: HZ_LOCATIONS loc

6270: */
6271: CURSOR c_locations(x_party_site_id NUMBER) IS
6272: SELECT loc.location_id
6273: FROM HZ_PARTY_SITES ps,
6274: HZ_LOCATIONS loc
6275: WHERE ps.location_id = loc.location_id
6276: AND ps.party_site_id = x_party_site_id;
6277:
6278: CURSOR c_from_party_type IS

Line 6287: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;

6283: AND ps.party_site_id = p_from_id;
6284:
6285: l_from_last_upd_date DATE;
6286: l_to_last_upd_date DATE;
6287: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6288: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6289: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;

Line 6288: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;

6284:
6285: l_from_last_upd_date DATE;
6286: l_to_last_upd_date DATE;
6287: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6288: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6289: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;

Line 6289: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;

6285: l_from_last_upd_date DATE;
6286: l_to_last_upd_date DATE;
6287: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6288: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6289: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;

Line 6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;

6286: l_to_last_upd_date DATE;
6287: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6288: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6289: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;

Line 6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;

6287: l_cont_source HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6288: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6289: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6295: l_city HZ_LOCATIONS.CITY%TYPE;

Line 6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;

6288: l_cont_source_to HZ_LOCATIONS.CONTENT_SOURCE_TYPE%TYPE;
6289: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6295: l_city HZ_LOCATIONS.CITY%TYPE;
6296: l_state HZ_LOCATIONS.STATE%TYPE;

Line 6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;

6289: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6295: l_city HZ_LOCATIONS.CITY%TYPE;
6296: l_state HZ_LOCATIONS.STATE%TYPE;
6297: l_county HZ_LOCATIONS.COUNTY%TYPE;

Line 6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;

6290: l_address1 HZ_LOCATIONS.ADDRESS1%TYPE;
6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6295: l_city HZ_LOCATIONS.CITY%TYPE;
6296: l_state HZ_LOCATIONS.STATE%TYPE;
6297: l_county HZ_LOCATIONS.COUNTY%TYPE;
6298: l_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 6295: l_city HZ_LOCATIONS.CITY%TYPE;

6291: l_address2 HZ_LOCATIONS.ADDRESS2%TYPE;
6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6295: l_city HZ_LOCATIONS.CITY%TYPE;
6296: l_state HZ_LOCATIONS.STATE%TYPE;
6297: l_county HZ_LOCATIONS.COUNTY%TYPE;
6298: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6299: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;

Line 6296: l_state HZ_LOCATIONS.STATE%TYPE;

6292: l_address3 HZ_LOCATIONS.ADDRESS3%TYPE;
6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6295: l_city HZ_LOCATIONS.CITY%TYPE;
6296: l_state HZ_LOCATIONS.STATE%TYPE;
6297: l_county HZ_LOCATIONS.COUNTY%TYPE;
6298: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6299: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;
6300: l_from_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;

Line 6297: l_county HZ_LOCATIONS.COUNTY%TYPE;

6293: l_address4 HZ_LOCATIONS.ADDRESS4%TYPE;
6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6295: l_city HZ_LOCATIONS.CITY%TYPE;
6296: l_state HZ_LOCATIONS.STATE%TYPE;
6297: l_county HZ_LOCATIONS.COUNTY%TYPE;
6298: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6299: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;
6300: l_from_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6301: l_to_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;

Line 6298: l_province HZ_LOCATIONS.PROVINCE%TYPE;

6294: l_country HZ_LOCATIONS.COUNTRY%TYPE;
6295: l_city HZ_LOCATIONS.CITY%TYPE;
6296: l_state HZ_LOCATIONS.STATE%TYPE;
6297: l_county HZ_LOCATIONS.COUNTY%TYPE;
6298: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6299: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;
6300: l_from_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6301: l_to_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6302: l_ident_flag HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG%TYPE;

Line 6299: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;

6295: l_city HZ_LOCATIONS.CITY%TYPE;
6296: l_state HZ_LOCATIONS.STATE%TYPE;
6297: l_county HZ_LOCATIONS.COUNTY%TYPE;
6298: l_province HZ_LOCATIONS.PROVINCE%TYPE;
6299: l_postal HZ_LOCATIONS.POSTAL_CODE%TYPE;
6300: l_from_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6301: l_to_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
6302: l_ident_flag HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG%TYPE;
6303: l_merge_to_id NUMBER;

Line 6323: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;

6319: l_ps_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
6320: l_actual_cont_source VARCHAR2(30);
6321: --l_loc_id HZ_LOC_ASSIGNMENTS.LOC_ID%TYPE; bug 4569674
6322: --l_org_id HZ_LOC_ASSIGNMENTS.ORG_ID%TYPE;
6323: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6324: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6325: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6326: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6327: map_ps_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

Line 6324: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;

6320: l_actual_cont_source VARCHAR2(30);
6321: --l_loc_id HZ_LOC_ASSIGNMENTS.LOC_ID%TYPE; bug 4569674
6322: --l_org_id HZ_LOC_ASSIGNMENTS.ORG_ID%TYPE;
6323: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6324: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6325: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6326: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6327: map_ps_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
6328: BEGIN

Line 6326: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;

6322: --l_org_id HZ_LOC_ASSIGNMENTS.ORG_ID%TYPE;
6323: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6324: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6325: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6326: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6327: map_ps_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
6328: BEGIN
6329:
6330: