APPS.HZ_WORD_RPL_COND_ATTRIBS_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row (
    x_condition_id                          IN  NUMBER,
    x_assoc_cond_attrib_id                  IN NUMBER,
    x_object_version_number                 IN  NUMBER
) IS
BEGIN
              INSERT INTO HZ_WORD_RPL_COND_ATTRIBS (
                condition_id,
                assoc_cond_attrib_id,
                last_update_date,
                last_updated_by,
                creation_date,
                created_by,
                last_update_login,
                object_version_number
                )
               VALUES (
                x_condition_id,
                x_assoc_cond_attrib_id,
                hz_utility_v2pub.last_update_date,
                hz_utility_v2pub.last_updated_by,
                hz_utility_v2pub.creation_date,
                hz_utility_v2pub.created_by,
                hz_utility_v2pub.last_update_login,
                DECODE(x_object_version_number,
                    FND_API.G_MISS_NUM, NULL,
                    x_object_version_number)
                ) ;

Line: 34

END Insert_Row;

Line: 36

PROCEDURE Update_Row (
    x_condition_id                          IN  NUMBER,
    x_assoc_cond_attrib_id                  IN NUMBER,
    x_new_cond_attrib_id                    IN NUMBER,
    x_object_version_number                 IN  OUT NOCOPY NUMBER
)
IS
p_object_version_number NUMBER ;

Line: 47

 UPDATE HZ_WORD_RPL_COND_ATTRIBS set
        assoc_cond_attrib_id = x_new_cond_attrib_id,
        object_version_number = p_object_version_number,
        last_update_date = hz_utility_v2pub.last_update_date,
        last_updated_by = hz_utility_v2pub.last_updated_by,
        last_update_login = hz_utility_v2pub.last_update_login
  where condition_id = x_condition_id  and assoc_cond_attrib_id = x_assoc_cond_attrib_id ;

Line: 62

PROCEDURE Delete_Row (
    x_condition_id                          IN  NUMBER,
    x_assoc_cond_attrib_id                  IN NUMBER
)
IS
BEGIN

    DELETE FROM HZ_WORD_RPL_COND_ATTRIBS
    where condition_id = x_condition_id and assoc_cond_attrib_id = x_assoc_cond_attrib_id ;

Line: 76

PROCEDURE Delete_Row (
    x_condition_id                          IN  NUMBER
)
IS
BEGIN

    DELETE FROM HZ_WORD_RPL_COND_ATTRIBS
    where condition_id = x_condition_id ;

Line: 93

cursor c is select
    object_version_number
    from HZ_WORD_RPL_COND_ATTRIBS B
    where condition_id = x_condition_id
    and assoc_cond_attrib_id = x_assoc_cond_attrib_id
    for update of condition_id, assoc_cond_attrib_id nowait;

Line: 108

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');