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

Line 497: FROM hz_locations

493: p_is_duplicate OUT NOCOPY VARCHAR2)
494: IS
495: CURSOR C_Duplicate_Keys (X_Address_Key VARCHAR2) IS
496: SELECT location_id
497: FROM hz_locations
498: WHERE address_key = X_Address_Key;
499:
500: CURSOR C_Duplicate_Address (
501: X_Address1 VARCHAR2,

Line 510: FROM hz_locations

506: X_State VARCHAR2,
507: X_City VARCHAR2,
508: X_Country VARCHAR2) IS
509: SELECT location_id
510: FROM hz_locations
511: WHERE upper(replace(translate(
512: X_Address1 || X_Address2 || X_Address3 || X_Address4 ||
513: X_Postal_Code || X_State || X_City || X_Country,
514: '#-_.,/\', ' ') ,' ' ) ) =

Line 652: FROM HZ_LOCATIONS

648: l_location_rec.ADDRESS2,
649: l_location_rec.ADDRESS3,
650: l_location_rec.ADDRESS4,
651: l_location_rec.POSTAL_CODE
652: FROM HZ_LOCATIONS
653: WHERE LOCATION_ID = p_location_id;
654:
655: RETURN l_location_rec;
656: END Get_Location_Rec;

Line 905: | update of HZ_PARTIES ,HZ_LOCATIONS tables. |

901: | |
902: | MODIFICATION HISTORY |
903: | Indrajit Sen 22-JUN-00 Created |
904: | Sisir 26-SEP-01 Bug No:1969345;Added who columns in the |
905: | update of HZ_PARTIES ,HZ_LOCATIONS tables. |
906: | Rajib R Borah 12-DEC-03 Bug 3142242.Reverted the changes done in |
907: | bug fix 1969345.Who columns should be updated|
908: | only when a business attribute is updated. |
909: +===========================================================================*/

Line 936: FROM hz_locations

932:
933: -- cursor to read all the location ids in the locations table.
934: CURSOR C_Location_Ids (l_location_id NUMBER) IS
935: SELECT location_id
936: FROM hz_locations
937: WHERE location_id > l_location_id;
938:
939: -- cursor to read all the location ids in the locations table where address_key is null.
940: CURSOR C_Location_Ids_New_Rows (l_location_id NUMBER) IS

Line 942: FROM hz_locations

938:
939: -- cursor to read all the location ids in the locations table where address_key is null.
940: CURSOR C_Location_Ids_New_Rows (l_location_id NUMBER) IS
941: SELECT location_id
942: FROM hz_locations
943: WHERE address_key is NULL
944: AND location_id > l_location_id;
945:
946: l_party_rec PARTY_REC_TYPE;

Line 952: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE ;

948: l_key VARCHAR2(2000);
949: l_rec_count NUMBER := 0;
950: l_party_id HZ_PARTIES.PARTY_ID%TYPE ;
951: l_last_party_id HZ_PARTIES.PARTY_ID%TYPE := 0;
952: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE ;
953: l_last_location_id HZ_LOCATIONS.LOCATION_ID%TYPE := 0;
954: l_flag VARCHAR2(1);
955: BEGIN
956:

Line 953: l_last_location_id HZ_LOCATIONS.LOCATION_ID%TYPE := 0;

949: l_rec_count NUMBER := 0;
950: l_party_id HZ_PARTIES.PARTY_ID%TYPE ;
951: l_last_party_id HZ_PARTIES.PARTY_ID%TYPE := 0;
952: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE ;
953: l_last_location_id HZ_LOCATIONS.LOCATION_ID%TYPE := 0;
954: l_flag VARCHAR2(1);
955: BEGIN
956:
957: -- send the run details to the log file

Line 1102: UPDATE HZ_LOCATIONS

1098: p_postal_code => l_location_rec.postal_code,
1099: p_first_name => NULL,
1100: p_last_name => NULL);
1101: -- update the locations record with the new key
1102: UPDATE HZ_LOCATIONS
1103: SET address_key = l_key/*Bug 3142242
1104: ,LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1105: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
1106: PROGRAM_APPLICATION_ID=HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 1151: UPDATE HZ_LOCATIONS

1147: p_postal_code => l_location_rec.postal_code,
1148: p_first_name => NULL,
1149: p_last_name => NULL);
1150: -- update the locations record with the new key
1151: UPDATE HZ_LOCATIONS
1152: SET address_key = l_key/*Bug 3142242
1153: ,LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1154: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
1155: PROGRAM_APPLICATION_ID=HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 1423: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,

1419: | |
1420: +===========================================================================*/
1421:
1422: PROCEDURE Fuzzy_Search_Address(
1423: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
1424: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
1425: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
1426: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
1427: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,

Line 1424: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,

1420: +===========================================================================*/
1421:
1422: PROCEDURE Fuzzy_Search_Address(
1423: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
1424: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
1425: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
1426: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
1427: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
1428: p_location_tbl OUT NOCOPY LOCATION_TBL_TYPE,

Line 1425: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,

1421:
1422: PROCEDURE Fuzzy_Search_Address(
1423: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
1424: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
1425: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
1426: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
1427: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
1428: p_location_tbl OUT NOCOPY LOCATION_TBL_TYPE,
1429: p_count OUT NOCOPY NUMBER) IS

Line 1426: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,

1422: PROCEDURE Fuzzy_Search_Address(
1423: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
1424: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
1425: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
1426: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
1427: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
1428: p_location_tbl OUT NOCOPY LOCATION_TBL_TYPE,
1429: p_count OUT NOCOPY NUMBER) IS
1430:

Line 1427: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,

1423: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
1424: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
1425: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
1426: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
1427: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
1428: p_location_tbl OUT NOCOPY LOCATION_TBL_TYPE,
1429: p_count OUT NOCOPY NUMBER) IS
1430:
1431: l_addr_key VARCHAR2(2000);

Line 1440: FROM hz_locations

1436:
1437: CURSOR c_locations (X_Addr_Key VARCHAR2, X_Post_Key VARCHAR2)
1438: IS
1439: SELECT location_id
1440: FROM hz_locations
1441: WHERE address_key like X_Addr_Key||'%'||X_Post_Key||'%';
1442:
1443: begin
1444: -- generate the key with only the address part (not including postal code)