APPS.CAC_SYNC_CONTACT_PREF_PVT SQL Statements

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

Line: 18

        SELECT party_preference_id
          FROM hz_party_preferences
         WHERE party_id = p_party_id
           AND category = p_category
           AND value_number = p_value_number
           AND preference_code = p_preference_code
           AND module = p_module;

Line: 72

            UPDATE hz_party_preferences
               SET last_update_date = p_last_sync_date
             WHERE party_id = p_party_id
               AND category = p_category
               AND preference_code = p_preference_code
               AND module = p_module
               AND value_number = p_value_number;

Line: 104

    PROCEDURE DELETE_CONTACT_PREFERENCE
    ( p_init_msg_list           IN  VARCHAR2 DEFAULT NULL
    , p_party_id                IN  NUMBER
    , p_category                IN  VARCHAR2
    , p_preference_code         IN  VARCHAR2
    , p_value_number            IN  NUMBER
    , p_object_version_number   IN  NUMBER
    , x_return_status           OUT NOCOPY VARCHAR2
    , x_msg_count               OUT NOCOPY NUMBER
    , x_msg_data                OUT NOCOPY VARCHAR2
    )
    IS
    BEGIN
        SAVEPOINT delete_contact_preference_sv;

Line: 148

            ROLLBACK TO delete_contact_preference_sv;

Line: 153

            ROLLBACK TO delete_contact_preference_sv;

Line: 160

    END DELETE_CONTACT_PREFERENCE;