APPS.IEX_AG_DN_PKG SQL Statements

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

Line: 6

PROCEDURE insert_row(
          px_rowid                          IN OUT NOCOPY VARCHAR2
        , px_ag_dn_xref_id                  IN OUT NOCOPY NUMBER
        , p_aging_bucket_id                  NUMBER
        , p_aging_bucket_line_id             NUMBER
        , p_callback_flag                    VARCHAR2
        , p_callback_days                    NUMBER
        , p_FM_METHOD                        VARCHAR2
        , p_template_id                      NUMBER
        , p_xdo_template_id                  NUMBER
        , p_score_RANGE_LOW                  NUMBER
        , p_score_RANGE_HIGH                 NUMBER
        , p_dunning_level                    VARCHAR2
        , p_object_version_number            NUMBER
        , p_last_update_date                 DATE
        , p_last_updated_by                  NUMBER
        , p_creation_date                    DATE
        , p_created_by                       NUMBER
        , p_last_update_login                NUMBER
     ) IS
        CURSOR l_insert IS
          SELECT ROWID
            FROM iex_ag_dn_xref
           WHERE ag_dn_xref_id = px_ag_dn_xref_id;

Line: 32

          SELECT IEX_AG_DN_XREF_S.nextval
            FROM sys.dual;

Line: 42

        INSERT INTO IEX_AG_DN_XREF (
          AG_DN_XREF_ID
        , AGING_BUCKET_ID
        , AGING_BUCKET_LINE_ID
        , CALLBACK_FLAG
        , CALLBACK_DAYS
        , FM_METHOD
        , TEMPLATE_ID
        , XDO_TEMPLATE_ID
        , SCORE_RANGE_LOW
        , SCORE_RANGE_HIGH
        , DUNNING_LEVEL
        , OBJECT_VERSION_NUMBER
        , last_update_date
        , last_updated_by
        , creation_date
        , created_by
        , last_update_login
        ) VALUES (
          px_ag_dn_xref_id
        , DECODE(p_aging_bucket_id, FND_API.G_MISS_NUM, NULL, p_aging_bucket_id)
        , DECODE(p_aging_bucket_line_id, FND_API.G_MISS_NUM, NULL, p_aging_bucket_line_id)
        , DECODE(p_callback_flag, FND_API.G_MISS_CHAR, NULL, p_callback_flag)
        , DECODE(p_callback_days, FND_API.G_MISS_NUM, NULL, p_callback_days)
        , DECODE(p_fm_method, FND_API.G_MISS_CHAR, NULL, p_fm_method)
        , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
        , DECODE(p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
        , DECODE(p_score_range_low, FND_API.G_MISS_NUM, NULL, p_score_range_low)
        , DECODE(p_score_range_high, FND_API.G_MISS_NUM, NULL, p_score_range_high)
        , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
        , DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
        , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
        , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
        , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
        , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
        , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
        );

Line: 80

        OPEN l_insert;

Line: 81

        FETCH l_insert INTO px_rowid;

Line: 82

        IF (l_insert%NOTFOUND) THEN
            CLOSE l_insert;

Line: 86

     END insert_row;

Line: 90

     PROCEDURE delete_row(
        p_ag_dn_xref_id                     NUMBER
     ) IS
     BEGIN
        DELETE FROM iex_ag_dn_xref
        WHERE ag_dn_xref_id = p_ag_dn_xref_id;

Line: 99

     END delete_row;

Line: 102

     PROCEDURE update_row(
          p_rowid                            VARCHAR2
        , p_ag_dn_xref_id                    NUMBER
        , p_aging_bucket_id                  NUMBER
        , p_aging_bucket_line_id             NUMBER
        , p_callback_flag                    VARCHAR2
        , p_callback_days                    NUMBER
        , p_FM_METHOD                        VARCHAR2
        , p_template_id                      NUMBER
        , p_xdo_template_id                  NUMBER
        , p_score_RANGE_LOW                  NUMBER
        , p_score_RANGE_HIGH                 NUMBER
        , p_dunning_level                    VARCHAR2
        , p_object_version_number            NUMBER
        , p_last_update_date                 DATE
        , p_last_updated_by                  NUMBER
        , p_creation_date                    DATE
        , p_created_by                       NUMBER
        , p_last_update_login                NUMBER
     ) IS
     BEGIN
        UPDATE iex_ag_dn_xref
        SET
          ag_dn_xref_id          = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
        , aging_bucket_id        = DECODE(p_aging_bucket_id, FND_API.G_MISS_NUM, NULL, p_aging_bucket_id)
        , aging_bucket_line_id   = DECODE(p_aging_bucket_line_id, FND_API.G_MISS_NUM, NULL, p_aging_bucket_line_id)
        , callback_flag          = DECODE(p_callback_flag, FND_API.G_MISS_CHAR, NULL, p_callback_flag)
        , callback_days          = DECODE(p_callback_days, FND_API.G_MISS_NUM, NULL, p_callback_days)
        , fm_method              = DECODE(p_fm_method, FND_API.G_MISS_CHAR, NULL, p_fm_method)
        , template_id            = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
        , xdo_template_id        = DECODE(p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
        , score_range_low        = DECODE(p_score_range_low, FND_API.G_MISS_NUM, NULL, p_score_range_low)
        , score_range_high       = DECODE(p_score_range_high, FND_API.G_MISS_NUM, NULL, p_score_range_high)
        , dunning_level          = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
        , object_version_number  = DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
        , last_update_date  = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
        , last_updated_by   = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
        , creation_date     = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
        , created_by        = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
        , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
        WHERE ROWID         = p_rowid;

Line: 146

     END update_row;

Line: 164

        , p_last_update_date                 DATE
        , p_last_updated_by                  NUMBER
        , p_creation_date                    DATE
        , p_created_by                       NUMBER
        , p_last_update_login                NUMBER
     ) IS
        CURSOR l_lock IS
          SELECT *
          FROM iex_ag_dn_xref
          WHERE rowid = p_rowid
          FOR UPDATE OF ag_dn_xref_id NOWAIT;

Line: 181

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

Line: 222

          AND           ((l_table_rec.last_update_date = p_last_update_date)
            OR ((l_table_rec.last_update_date IS NULL)
                AND ( p_last_update_date IS NULL)))
          AND           ((l_table_rec.last_updated_by = p_last_updated_by)
            OR ((l_table_rec.last_updated_by IS NULL)
                AND ( p_last_updated_by IS NULL)))
          AND           ((l_table_rec.creation_date = p_creation_date)
            OR ((l_table_rec.creation_date IS NULL)
                AND ( p_creation_date IS NULL)))
          AND           ((l_table_rec.created_by = p_created_by)
            OR ((l_table_rec.created_by IS NULL)
                AND ( p_created_by IS NULL)))
          AND           ((l_table_rec.last_update_login = p_last_update_login)
            OR ((l_table_rec.last_update_login IS NULL)
                AND ( p_last_update_login IS NULL)))
        ) THEN
          RETURN;

Line: 240

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