eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_ISSUE_LISTING_IDFR_PKG SQL Statements

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

Line: 9


PROCEDURE insert_row (
    p_issue_listing_idfr_id IN OUT NUMBER,
    p_exchange_id           IN     NUMBER,
    p_issue_id              IN     NUMBER,
    p_scheme                IN     VARCHAR2,
    p_value                 IN     VARCHAR2,
    p_search_code           IN     VARCHAR2,
    p_country_code          IN     VARCHAR2,
    p_listing_flag          IN     VARCHAR2,
    p_last_update_date      IN     DATE,
    p_last_updated_by       IN     NUMBER,
    p_creation_date         IN     DATE,
    p_created_by            IN     NUMBER,
    p_last_update_login     IN     NUMBER,
    p_attribute_category    IN     VARCHAR2,
    p_attribute1            IN     VARCHAR2,
    p_attribute2            IN     VARCHAR2,
    p_attribute3            IN     VARCHAR2,
    p_attribute4            IN     VARCHAR2,
    p_attribute5            IN     VARCHAR2,
    p_attribute6            IN     VARCHAR2,
    p_attribute7            IN     VARCHAR2,
    p_attribute8            IN     VARCHAR2,
    p_attribute9            IN     VARCHAR2,
    p_attribute10           IN     VARCHAR2,
    p_attribute11           IN     VARCHAR2,
    p_attribute12           IN     VARCHAR2,
    p_attribute13           IN     VARCHAR2,
    p_attribute14           IN     VARCHAR2,
    p_attribute15           IN     VARCHAR2) IS

    CURSOR C1 IS SELECT AS_ISSUE_LISTING_IDFR_S.nextval FROM sys.dual;

Line: 42


    CURSOR C2 IS SELECT ROWID FROM as_issue_listing_idfr
                 WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;

Line: 53


    INSERT INTO AS_ISSUE_LISTING_IDFR (
        issue_listing_idfr_id,
        exchange_id,
        issue_id,
        scheme,
        value,
        search_code,
        country_code,
        listing_flag,
        last_update_date,
        last_updated_by ,
        creation_date,
        created_by,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15) VALUES
       (DECODE(p_issue_listing_idfr_id, FND_API.G_MISS_NUM, NULL, p_issue_listing_idfr_id),
        DECODE(p_exchange_id, FND_API.G_MISS_NUM, NULL, p_exchange_id),
        DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),
        DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
        DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
        DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
        DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
        DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
        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),
        DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
        DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
        DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
        DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
        DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
        DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
        DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
        DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
        DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
        DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
        DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
        DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
        DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
        DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
        DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
        DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15));

Line: 122


END insert_row;

Line: 124


PROCEDURE update_row (
    p_issue_listing_idfr_id IN NUMBER,
    p_exchange_id           IN NUMBER,
    p_issue_id              IN NUMBER,
    p_scheme                IN VARCHAR2,
    p_value                 IN VARCHAR2,
    p_search_code           IN VARCHAR2,
    p_country_code          IN VARCHAR2,
    p_listing_flag          IN VARCHAR2,
    p_last_update_date      IN DATE,
    p_last_updated_by       IN NUMBER,
    p_creation_date         IN DATE,
    p_created_by            IN NUMBER,
    p_last_update_login     IN NUMBER,
    p_attribute_category    IN VARCHAR2,
    p_attribute1            IN VARCHAR2,
    p_attribute2            IN VARCHAR2,
    p_attribute3            IN VARCHAR2,
    p_attribute4            IN VARCHAR2,
    p_attribute5            IN VARCHAR2,
    p_attribute6            IN VARCHAR2,
    p_attribute7            IN VARCHAR2,
    p_attribute8            IN VARCHAR2,
    p_attribute9            IN VARCHAR2,
    p_attribute10           IN VARCHAR2,
    p_attribute11           IN VARCHAR2,
    p_attribute12           IN VARCHAR2,
    p_attribute13           IN VARCHAR2,
    p_attribute14           IN VARCHAR2,
    p_attribute15           IN VARCHAR2) IS

BEGIN

    UPDATE AS_ISSUE_LISTING_IDFR SET
        exchange_id           = DECODE(p_exchange_id, FND_API.G_MISS_NUM, exchange_id, p_exchange_id),
        issue_id              = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),
        scheme                = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
        value                 = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
        search_code           = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
        country_code          = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
        listing_flag          = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
        last_update_date      = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
        last_updated_by       = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
        creation_date         = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
        created_by            = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
        last_update_login     = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
        attribute1            = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
        attribute2            = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
        attribute3            = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
        attribute4            = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
        attribute5            = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
        attribute6            = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
        attribute7            = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
        attribute8            = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
        attribute9            = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
        attribute10           = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
        attribute11           = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
        attribute12           = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
        attribute13           = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
        attribute14           = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
        attribute15           = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
        attribute_category    = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
    WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;

Line: 192


END update_row;

Line: 194


PROCEDURE delete_row (
    p_issue_listing_idfr_id IN NUMBER) IS

BEGIN

    DELETE FROM AS_ISSUE_LISTING_IDFR
    WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;

Line: 206


END delete_row;

Line: 214


    CURSOR C IS SELECT object_version_number
                FROM AS_EXCHANGE_B
                WHERE issue_listing_idfr_id = p_issue_listing_idfr_id
                AND exchange_id = p_exchange_id
                AND issue_id = p_issue_id
                AND object_version_number = p_object_version_number
                FOR UPDATE OF issue_listing_idfr_id NOWAIT;

Line: 230


        fnd_message.set_name('FND', 'FORM RECORD_DELETED');