APPS.HZ_PREFERENCE_PUB SQL Statements

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

Line: 45

  SELECT  1
  INTO    l_dummy
  FROM    HZ_PARTY_PREFERENCES
  WHERE   CATEGORY = p_category
  AND     PREFERENCE_CODE = p_preference_code
  AND     PARTY_ID = p_party_id
  AND     VALUE_VARCHAR2 = p_value_varchar2_o
  AND     ROWNUM = 1;

Line: 98

  SELECT  1
  INTO    l_dummy
  FROM    HZ_PARTY_PREFERENCES
  WHERE   CATEGORY = p_category
  AND     PREFERENCE_CODE = p_preference_code
  AND     PARTY_ID = p_party_id
  AND     ROWNUM = 1;

Line: 235

    select tag
    from   fnd_lookup_values
    where  lookup_type = 'HZ_PREFERENCE'
    and    lookup_code = p_preference_code;

Line: 321

    select hz_party_preferences_s.nextval into l_party_preference_id from dual;

Line: 327

    HZ_PARTY_PREFERENCES_PKG.insert_row
    (X_ROWID                 => l_rowid,
     X_PARTY_PREFERENCE_ID   => l_party_preference_id,
     X_PARTY_ID              => p_party_id,
     X_MODULE                => p_module,
     X_CATEGORY              => p_category,
     X_PREFERENCE_CODE       => p_preference_code,
     X_VALUE_VARCHAR2        => p_value_varchar2,
     X_VALUE_NUMBER          => p_value_number,
     X_VALUE_DATE            => p_value_date,
     X_VALUE_NAME            => p_value_name,
     X_ADDITIONAL_VALUE1     => p_additional_value1,
     X_ADDITIONAL_VALUE2     => p_additional_value2,
     X_ADDITIONAL_VALUE3     => p_additional_value3,
     X_ADDITIONAL_VALUE4     => p_additional_value4,
     X_ADDITIONAL_VALUE5     => p_additional_value5,
     X_OBJECT_VERSION_NUMBER => l_object_version_number,
     X_CREATED_BY            => hz_utility_pub.CREATED_BY,
     X_CREATION_DATE         => hz_utility_pub.CREATION_DATE,
     X_LAST_UPDATED_BY       => hz_utility_pub.LAST_UPDATED_BY,
     X_LAST_UPDATE_DATE      => hz_utility_pub.LAST_UPDATE_DATE,
     X_LAST_UPDATE_LOGIN     => hz_utility_pub.LAST_UPDATE_LOGIN
    );

Line: 422

    select tag
    from   fnd_lookup_values
    where  lookup_type = 'HZ_PREFERENCE'
    and    lookup_code = p_preference_code;

Line: 536

        select party_preference_id, object_version_number
        into   l_party_preference_id, o_object_version_number
        from   hz_party_preferences
        where  party_id = p_party_id
        and    category = p_category
        and    preference_code = p_preference_code
        for update nowait;

Line: 556

        HZ_PARTY_PREFERENCES_PKG.update_row
        (X_PARTY_PREFERENCE_ID    => l_party_preference_id
        ,X_PARTY_ID               => p_party_id
        ,X_MODULE                 => p_module
        ,X_CATEGORY               => p_category
        ,X_PREFERENCE_CODE        => p_preference_code
        ,X_VALUE_VARCHAR2         => p_value_varchar2
        ,X_VALUE_NUMBER           => p_value_number
        ,X_VALUE_DATE             => p_value_date
        ,X_VALUE_NAME             => p_value_name
        ,X_ADDITIONAL_VALUE1      => p_additional_value1
        ,X_ADDITIONAL_VALUE2      => p_additional_value2
        ,X_ADDITIONAL_VALUE3      => p_additional_value3
        ,X_ADDITIONAL_VALUE4      => p_additional_value4
        ,X_ADDITIONAL_VALUE5      => p_additional_value5
        ,X_OBJECT_VERSION_NUMBER  => l_object_version_number
        ,X_LAST_UPDATED_BY        => hz_utility_pub.last_updated_by
        ,X_LAST_UPDATE_DATE       => hz_utility_pub.last_update_date
        ,X_LAST_UPDATE_LOGIN      => hz_utility_pub.last_update_login
        );

Line: 616

      select party_preference_id, object_version_number
      into   l_party_preference_id, o_object_version_number
      from   hz_party_preferences
      where  party_id = p_party_id
      and    category = p_category
      and    preference_code = p_preference_code
      and    value_varchar2 = p_value_varchar2
      for update nowait;

Line: 627

      select party_preference_id, object_version_number
      into   l_party_preference_id, o_object_version_number
      from   hz_party_preferences
      where  party_id = p_party_id
      and    category = p_category
      and    preference_code = p_preference_code
      and    value_number = p_value_number
      for update nowait;

Line: 638

      select party_preference_id, object_version_number
      into   l_party_preference_id, o_object_version_number
      from   hz_party_preferences
      where  party_id = p_party_id
      and    category = p_category
      and    preference_code = p_preference_code
      and    value_date = p_value_date
      for update nowait;

Line: 660

    HZ_PARTY_PREFERENCES_PKG.update_row
    (X_PARTY_PREFERENCE_ID    => l_party_preference_id
    ,X_PARTY_ID               => p_party_id
    ,X_MODULE                 => p_module
    ,X_CATEGORY               => p_category
    ,X_PREFERENCE_CODE        => p_preference_code
    ,X_VALUE_VARCHAR2         => p_value_varchar2
    ,X_VALUE_NUMBER           => p_value_number
    ,X_VALUE_DATE             => p_value_date
    ,X_VALUE_NAME             => p_value_name
    ,X_ADDITIONAL_VALUE1      => p_additional_value1
    ,X_ADDITIONAL_VALUE2      => p_additional_value2
    ,X_ADDITIONAL_VALUE3      => p_additional_value3
    ,X_ADDITIONAL_VALUE4      => p_additional_value4
    ,X_ADDITIONAL_VALUE5      => p_additional_value5
    ,X_OBJECT_VERSION_NUMBER  => l_object_version_number
    ,X_LAST_UPDATED_BY        => hz_utility_pub.last_updated_by
    ,X_LAST_UPDATE_DATE       => hz_utility_pub.last_update_date
    ,X_LAST_UPDATE_LOGIN      => hz_utility_pub.last_update_login
    );

Line: 808

    DELETE FROM hz_party_preferences
    WHERE  party_id = p_party_id
    AND    category = p_category
    AND    preference_code = p_preference_code;

Line: 826

    DELETE FROM hz_party_preferences
    WHERE  party_id = p_party_id
    AND    category = p_category
    AND    preference_code = p_preference_code
    AND    value_varchar2 = p_value_varchar2
    AND    object_version_number = p_object_version_number;

Line: 846

    DELETE FROM hz_party_preferences
    WHERE  party_id = p_party_id
    AND    category = p_category
    AND    preference_code = p_preference_code
    AND    value_number = p_value_number
    AND    object_version_number = p_object_version_number;

Line: 860

    DELETE FROM hz_party_preferences
    WHERE  party_id = p_party_id
    AND    category = p_category
    AND    preference_code = p_preference_code
    AND    value_date = p_value_date
    AND    object_version_number = p_object_version_number;

Line: 938

    SELECT  *
    FROM    HZ_PARTY_PREFERENCES
    WHERE   CATEGORY = p_category
    AND     PREFERENCE_CODE = p_preference_code
    AND     PARTY_ID = p_party_id;

Line: 987

    SELECT  VALUE_VARCHAR2
    FROM    HZ_PARTY_PREFERENCES
    WHERE   CATEGORY = cat
    AND     PREFERENCE_CODE = pref
    AND     PARTY_ID = pty
    AND     VALUE_VARCHAR2 is not null;

Line: 1046

    SELECT  VALUE_NUMBER
    FROM    HZ_PARTY_PREFERENCES
    WHERE   CATEGORY = cat
    AND     PREFERENCE_CODE = pref
    AND     PARTY_ID = pty
    AND     VALUE_NUMBER is not null;

Line: 1104

    SELECT  VALUE_DATE
    FROM    HZ_PARTY_PREFERENCES
    WHERE   CATEGORY = cat
    AND     PREFERENCE_CODE = pref
    AND     PARTY_ID = pty
    AND     VALUE_DATE is not null;

Line: 1180

  SELECT  1
  INTO    l_dummy
  FROM    HZ_PARTY_PREFERENCES
  WHERE   CATEGORY = p_category
  AND     PREFERENCE_CODE = p_preference_code
  AND     PARTY_ID = p_party_id
  AND     VALUE_NUMBER = p_value_number
  AND     ROWNUM = 1;

Line: 1234

  SELECT  1
  INTO    l_dummy
  FROM    HZ_PARTY_PREFERENCES
  WHERE   CATEGORY = p_category
  AND     PREFERENCE_CODE = p_preference_code
  AND     PARTY_ID = p_party_id
  AND     VALUE_DATE = p_value_date
  AND     ROWNUM = 1;

Line: 1304

    select 'Y' into l_dummy
    from   hz_parties
    where  party_id = p_party_id;

Line: 1351

    SELECT 'Y'
    FROM   hz_parties
    WHERE  party_id = p_party_id
    FOR UPDATE NOWAIT;

Line: 1373

    UPDATE hz_parties
    SET    preferred_contact_method = p_value_varchar2
    WHERE  party_id = p_party_id;