APPS.IEU_UWQ_MEDIA_ACTIONS_PKG SQL Statements

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

Line: 3

     PROCEDURE insert_row(
          x_rowid                          IN OUT  NOCOPY VARCHAR2
        , x_media_action_id                  NUMBER
        , x_created_by                       NUMBER
        , x_creation_date                    DATE
        , x_last_updated_by                  NUMBER
        , x_last_update_date                 DATE
        , x_last_update_login                NUMBER
        , x_media_type_id                    NUMBER
        , x_maction_def_id                   NUMBER
        , x_application_id                   NUMBER
        , x_classification                   VARCHAR2
        , x_other_params                     VARCHAR2
     ) IS
        CURSOR l_insert IS
          SELECT ROWID
          FROM ieu_uwq_media_actions
          WHERE media_action_id = x_media_action_id;

Line: 22

        INSERT INTO ieu_uwq_media_actions (
          media_action_id
        , created_by
        , creation_date
        , last_updated_by
        , last_update_date
        , last_update_login
        , media_type_id
        , maction_def_id
        , application_id
        , classification
        , other_params
        , object_version_number
        ) VALUES (
          x_media_action_id
        , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
        , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
        , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
        , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
        , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
        , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
        , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
        , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
        , DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
        , DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
        , 1
        );

Line: 50

        OPEN l_insert;

Line: 51

        FETCH l_insert INTO x_rowid;

Line: 52

        IF (l_insert%NOTFOUND) THEN
            CLOSE l_insert;

Line: 56

     END insert_row;

Line: 58

     PROCEDURE delete_row(
        x_media_action_id                  NUMBER
     ) IS
     BEGIN
        DELETE FROM ieu_uwq_media_actions
        WHERE media_action_id = x_media_action_id;

Line: 67

     END delete_row;

Line: 69

     PROCEDURE update_row(
          x_rowid                          VARCHAR2
        , x_media_action_id                NUMBER
        , x_created_by                     NUMBER
        , x_creation_date                  DATE
        , x_last_updated_by                NUMBER
        , x_last_update_date               DATE
        , x_last_update_login              NUMBER
        , x_media_type_id                  NUMBER
        , x_maction_def_id                 NUMBER
        , x_application_id                 NUMBER
        , x_classification                 VARCHAR2
        , x_other_params                   VARCHAR2
     ) IS
     BEGIN
        UPDATE ieu_uwq_media_actions
        SET
          media_action_id=DECODE(x_media_action_id,FND_API.G_MISS_NUM,NULL,x_media_action_id)
        , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
        , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
        , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
        , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
        , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
        , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
        , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
        , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
        , classification=DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
        , other_params=DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
        , object_version_number=nvl(object_version_number,0) + 1
        WHERE ROWID = x_rowid;

Line: 102

     END update_row;

Line: 109

        , x_last_updated_by                NUMBER
        , x_last_update_date               DATE
        , x_last_update_login              NUMBER
        , x_media_type_id                  NUMBER
        , x_maction_def_id                 NUMBER
        , x_application_id                 NUMBER
        , x_classification                 VARCHAR2
        , x_other_params                   VARCHAR2
     ) IS
        CURSOR l_lock IS
          SELECT *
          FROM ieu_uwq_media_actions
          WHERE rowid = x_rowid
          FOR UPDATE OF media_action_id NOWAIT;

Line: 129

             FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 143

          AND           ((l_table_rec.last_updated_by = x_last_updated_by)
            OR ((l_table_rec.last_updated_by IS NULL)
                AND ( x_last_updated_by IS NULL)))
          AND           ((l_table_rec.last_update_date = x_last_update_date)
            OR ((l_table_rec.last_update_date IS NULL)
                AND ( x_last_update_date IS NULL)))
          AND           ((l_table_rec.last_update_login = x_last_update_login)
            OR ((l_table_rec.last_update_login IS NULL)
                AND ( x_last_update_login IS NULL)))
          AND           ((l_table_rec.media_type_id = x_media_type_id)
            OR ((l_table_rec.media_type_id IS NULL)
                AND ( x_media_type_id IS NULL)))
          AND           ((l_table_rec.maction_def_id = x_maction_def_id)
            OR ((l_table_rec.maction_def_id IS NULL)
                AND ( x_maction_def_id IS NULL)))
          AND           ((l_table_rec.application_id = x_application_id)
            OR ((l_table_rec.application_id IS NULL)
                AND ( x_application_id IS NULL)))
          AND           ((l_table_rec.classification = x_classification)
            OR ((l_table_rec.classification IS NULL)
                AND ( x_classification IS NULL)))
          AND           ((l_table_rec.other_params = x_other_params)
            OR ((l_table_rec.other_params IS NULL)
                AND ( x_other_params IS NULL)))
        ) THEN
          RETURN;

Line: 170

          FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');