APPS.HZ_FUZZY_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 175

         SELECT word_list_id FROM HZ_WORD_LISTS
         WHERE word_list_name = c_word_list_name;

Line: 180

      SELECT upper(replacement_word)
      FROM   hz_word_replacements
      WHERE  upper(original_word) = x_current_word
      AND    word_list_id         = cp_wl_id
      AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
		OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
	  )
      AND    condition_id IS NULL; --Bug No:4098780

Line: 190

      SELECT HWR.ORIGINAL_WORD,
             HWR.REPLACEMENT_WORD
      FROM   HZ_WORD_LISTS HWL, HZ_WORD_REPLACEMENTS HWR
      WHERE  HWL.WORD_LIST_NAME = 'KEY MODIFIERS' AND HWR.WORD_LIST_ID = HWL.WORD_LIST_ID
      AND ((HZ_TRANS_PKG.staging_context = 'Y' AND HWR.DELETE_FLAG = 'N')
		OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND HWR.STAGED_FLAG = 'Y')
	   )
      AND    HWR.CONDITION_ID IS NULL; --Bug No:4098780

Line: 409

      SELECT  party_id
      FROM    hz_parties
      WHERE   upper(party_name) = upper(X_party_Name);

Line: 414

      SELECT  party_id
      FROM    hz_parties
      WHERE   customer_key = X_party_Key;

Line: 496

      SELECT  location_id
      FROM    hz_locations
      WHERE   address_key = X_Address_Key;

Line: 509

        SELECT  location_id
          FROM  hz_locations
         WHERE  upper(replace(translate(
                X_Address1 || X_Address2 || X_Address3 || X_Address4 ||
                X_Postal_Code || X_State || X_City || X_Country,
                '#-_.,/\', ' ') ,' ' ) ) =
                upper(replace(translate(
                  ADDRESS1 || ADDRESS2 || ADDRESS3 || ADDRESS4 ||
                  POSTAL_CODE || STATE || CITY || COUNTRY,
                  '#-_.,/\', ' ') ,' ' ) );

Line: 589

    SELECT
           PARTY_ID,
           PARTY_NAME,
           PARTY_TYPE,
           PERSON_FIRST_NAME,
           PERSON_LAST_NAME
    INTO
           l_party_rec.PARTY_ID,
           l_party_rec.PARTY_NAME,
           l_party_rec.PARTY_TYPE,
           l_party_rec.FIRST_NAME,
           l_party_rec.LAST_NAME
    FROM   HZ_PARTIES
    WHERE  PARTY_ID = p_party_id;

Line: 638

    SELECT
           LOCATION_ID,
           ADDRESS1,
           ADDRESS2,
           ADDRESS3,
           ADDRESS4,
           POSTAL_CODE
    INTO
           l_location_rec.LOCATION_ID,
           l_location_rec.ADDRESS1,
           l_location_rec.ADDRESS2,
           l_location_rec.ADDRESS3,
           l_location_rec.ADDRESS4,
           l_location_rec.POSTAL_CODE
    FROM   HZ_LOCATIONS
    WHERE  LOCATION_ID = p_location_id;

Line: 905

 |				update of HZ_PARTIES ,HZ_LOCATIONS tables.   |
 |    Rajib R Borah  12-DEC-03  Bug 3142242.Reverted the changes done in     |
 |                              bug fix 1969345.Who columns should be updated|
 |                              only when a business attribute is updated.   |
 +===========================================================================*/

  PROCEDURE Generate_Full_Table_Key (
                         Errbuf          OUT NOCOPY     VARCHAR2,
                         Retcode         OUT NOCOPY     VARCHAR2,
                         p_key_type      IN      VARCHAR2 DEFAULT NULL,
                         p_new_rows      IN      VARCHAR2 DEFAULT 'Y'
                         )
  IS
    -- cursor to read all the party ids in the parties table.
    CURSOR C_Party_Ids (l_party_id NUMBER) IS
      SELECT  party_id
      FROM    hz_parties
      WHERE   party_id > l_party_id
        AND   party_type in ('PERSON', 'ORGANIZATION', 'GROUP');

Line: 927

      SELECT  party_id
      FROM    hz_parties
      WHERE   customer_key is NULL
      AND     party_id > l_party_id
      AND     party_type in ('PERSON', 'ORGANIZATION', 'GROUP');

Line: 935

      SELECT  location_id
      FROM    hz_locations
      WHERE   location_id > l_location_id;

Line: 941

      SELECT  location_id
      FROM    hz_locations
      WHERE   address_key is NULL
        AND   location_id > l_location_id;

Line: 999

            UPDATE HZ_PARTIES
            SET customer_key = l_key/*Bug 3142242
	       ,LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
		REQUEST_ID        = HZ_UTILITY_V2PUB.REQUEST_ID,
	 	PROGRAM_APPLICATION_ID=HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
		PROGRAM_ID        = HZ_UTILITY_V2PUB.PROGRAM_ID,
		PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
		LAST_UPDATE_DATE  = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
		LAST_UPDATED_BY   = HZ_UTILITY_V2PUB.LAST_UPDATED_BY */
            WHERE party_id = l_party_id;

Line: 1049

          UPDATE HZ_PARTIES
            SET customer_key = l_key/*Bug 3142242
		,LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
		REQUEST_ID        = HZ_UTILITY_V2PUB.REQUEST_ID,
	 	PROGRAM_APPLICATION_ID=HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
		PROGRAM_ID        = HZ_UTILITY_V2PUB.PROGRAM_ID,
		PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
		LAST_UPDATE_DATE  = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
		LAST_UPDATED_BY   = HZ_UTILITY_V2PUB.LAST_UPDATED_BY */
            WHERE party_id = l_party_id;

Line: 1102

          UPDATE HZ_LOCATIONS
            SET address_key = l_key/*Bug 3142242
		,LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
		REQUEST_ID        = HZ_UTILITY_V2PUB.REQUEST_ID,
	 	PROGRAM_APPLICATION_ID=HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
		PROGRAM_ID        = HZ_UTILITY_V2PUB.PROGRAM_ID,
		PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
		LAST_UPDATE_DATE  = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
		LAST_UPDATED_BY   = HZ_UTILITY_V2PUB.LAST_UPDATED_BY */
            WHERE location_id = l_location_id;

Line: 1151

          UPDATE HZ_LOCATIONS
            SET address_key = l_key/*Bug 3142242
		,LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
		REQUEST_ID        = HZ_UTILITY_V2PUB.REQUEST_ID,
	 	PROGRAM_APPLICATION_ID=HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
		PROGRAM_ID        = HZ_UTILITY_V2PUB.PROGRAM_ID,
		PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
		LAST_UPDATE_DATE  = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
		LAST_UPDATED_BY   = HZ_UTILITY_V2PUB.LAST_UPDATED_BY */
            WHERE location_id = l_location_id;

Line: 1439

      SELECT location_id
      FROM   hz_locations
      WHERE  address_key like X_Addr_Key||'%'||X_Post_Key||'%';

Line: 1522

      SELECT party_id
      FROM   hz_parties
      WHERE  customer_key like X_Party_Name_Key||'%'
      AND    party_type = 'ORGANIZATION';

Line: 1529

      SELECT party_id
      FROM   hz_parties
      WHERE  customer_key like X_Last_Name_Key||'%'||X_First_Name_Key||'%'
      AND    party_type = 'PERSON';