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.OE_CONTRACT_UTIL SQL Statements

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

Line: 129


        IF NOT OE_GLOBALS.Equal(p_Contract_rec.last_updated_by,p_old_Contract_rec.last_updated_by)
        THEN
            NULL;

Line: 134


        IF NOT OE_GLOBALS.Equal(p_Contract_rec.last_update_date,p_old_Contract_rec.last_update_date)
        THEN
            NULL;

Line: 139


        IF NOT OE_GLOBALS.Equal(p_Contract_rec.last_update_login,p_old_Contract_rec.last_update_login)
        THEN
            NULL;

Line: 194


    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        NULL;

Line: 196


    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        NULL;

Line: 198


    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        NULL;

Line: 323


    IF NOT OE_GLOBALS.Equal(p_Contract_rec.last_updated_by,p_old_Contract_rec.last_updated_by)
    THEN
        NULL;

Line: 328


    IF NOT OE_GLOBALS.Equal(p_Contract_rec.last_update_date,p_old_Contract_rec.last_update_date)
    THEN
        NULL;

Line: 333


    IF NOT OE_GLOBALS.Equal(p_Contract_rec.last_update_login,p_old_Contract_rec.last_update_login)
    THEN
        NULL;

Line: 440


    IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_Contract_rec.last_updated_by := p_old_Contract_rec.last_updated_by;

Line: 444


    IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_Contract_rec.last_update_date := p_old_Contract_rec.last_update_date;

Line: 448


    IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_Contract_rec.last_update_login := p_old_Contract_rec.last_update_login;

Line: 553


    IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_Contract_rec.last_updated_by := NULL;

Line: 557


    IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_Contract_rec.last_update_date := NULL;

Line: 561


    IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_Contract_rec.last_update_login := NULL;

Line: 579


PROCEDURE Update_Row
(   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
)
IS
BEGIN

    UPDATE  OE_PRICING_CONTRACTS
    SET     AGREEMENT_ID                   = p_Contract_rec.agreement_id
    ,       ATTRIBUTE1                     = p_Contract_rec.attribute1
    ,       ATTRIBUTE10                    = p_Contract_rec.attribute10
    ,       ATTRIBUTE11                    = p_Contract_rec.attribute11
    ,       ATTRIBUTE12                    = p_Contract_rec.attribute12
    ,       ATTRIBUTE13                    = p_Contract_rec.attribute13
    ,       ATTRIBUTE14                    = p_Contract_rec.attribute14
    ,       ATTRIBUTE15                    = p_Contract_rec.attribute15
    ,       ATTRIBUTE2                     = p_Contract_rec.attribute2
    ,       ATTRIBUTE3                     = p_Contract_rec.attribute3
    ,       ATTRIBUTE4                     = p_Contract_rec.attribute4
    ,       ATTRIBUTE5                     = p_Contract_rec.attribute5
    ,       ATTRIBUTE6                     = p_Contract_rec.attribute6
    ,       ATTRIBUTE7                     = p_Contract_rec.attribute7
    ,       ATTRIBUTE8                     = p_Contract_rec.attribute8
    ,       ATTRIBUTE9                     = p_Contract_rec.attribute9
    ,       CONTEXT                        = p_Contract_rec.context
    ,       CREATED_BY                     = p_Contract_rec.created_by
    ,       CREATION_DATE                  = p_Contract_rec.creation_date
    ,       DISCOUNT_ID                    = p_Contract_rec.discount_id
    ,       LAST_UPDATED_BY                = p_Contract_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_Contract_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_Contract_rec.last_update_login
    ,       PRICE_LIST_ID                  = p_Contract_rec.price_list_id
    ,       PRICING_CONTRACT_ID            = p_Contract_rec.pricing_contract_id
    WHERE   PRICING_CONTRACT_ID = p_Contract_rec.pricing_contract_id
    ;

Line: 622


            ,   'Update_Row'
            );

Line: 628


END Update_Row;

Line: 632


PROCEDURE Insert_Row
(   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
)
IS
BEGIN

    oe_debug_pub.add('Entering OE_Contract_Util.Insert_Row');

Line: 640


    INSERT  INTO OE_PRICING_CONTRACTS
    (       AGREEMENT_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISCOUNT_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PRICE_LIST_ID
    ,       PRICING_CONTRACT_ID
    )
    VALUES
    (       p_Contract_rec.agreement_id
    ,       p_Contract_rec.attribute1
    ,       p_Contract_rec.attribute10
    ,       p_Contract_rec.attribute11
    ,       p_Contract_rec.attribute12
    ,       p_Contract_rec.attribute13
    ,       p_Contract_rec.attribute14
    ,       p_Contract_rec.attribute15
    ,       p_Contract_rec.attribute2
    ,       p_Contract_rec.attribute3
    ,       p_Contract_rec.attribute4
    ,       p_Contract_rec.attribute5
    ,       p_Contract_rec.attribute6
    ,       p_Contract_rec.attribute7
    ,       p_Contract_rec.attribute8
    ,       p_Contract_rec.attribute9
    ,       p_Contract_rec.context
    ,       p_Contract_rec.created_by
    ,       p_Contract_rec.creation_date
    ,       p_Contract_rec.discount_id
    ,       p_Contract_rec.last_updated_by
    ,       p_Contract_rec.last_update_date
    ,       p_Contract_rec.last_update_login
    ,       p_Contract_rec.price_list_id
    ,       p_Contract_rec.pricing_contract_id
    );

Line: 695


    oe_debug_pub.add('Exiting OE_Contract_Util.Insert_Row');

Line: 705


            ,   'Insert_Row'
            );

Line: 711


END Insert_Row;

Line: 715


PROCEDURE Delete_Row
(   p_pricing_contract_id           IN  NUMBER
)
IS
BEGIN

    DELETE  FROM OE_PRICING_CONTRACTS
    WHERE   PRICING_CONTRACT_ID = p_pricing_contract_id
    ;

Line: 733


            ,   'Delete_Row'
            );

Line: 739


END Delete_Row;

Line: 750


    SELECT  AGREEMENT_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISCOUNT_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PRICE_LIST_ID
    ,       PRICING_CONTRACT_ID
    INTO    l_Contract_rec.agreement_id
    ,       l_Contract_rec.attribute1
    ,       l_Contract_rec.attribute10
    ,       l_Contract_rec.attribute11
    ,       l_Contract_rec.attribute12
    ,       l_Contract_rec.attribute13
    ,       l_Contract_rec.attribute14
    ,       l_Contract_rec.attribute15
    ,       l_Contract_rec.attribute2
    ,       l_Contract_rec.attribute3
    ,       l_Contract_rec.attribute4
    ,       l_Contract_rec.attribute5
    ,       l_Contract_rec.attribute6
    ,       l_Contract_rec.attribute7
    ,       l_Contract_rec.attribute8
    ,       l_Contract_rec.attribute9
    ,       l_Contract_rec.context
    ,       l_Contract_rec.created_by
    ,       l_Contract_rec.creation_date
    ,       l_Contract_rec.discount_id
    ,       l_Contract_rec.last_updated_by
    ,       l_Contract_rec.last_update_date
    ,       l_Contract_rec.last_update_login
    ,       l_Contract_rec.price_list_id
    ,       l_Contract_rec.pricing_contract_id
    FROM    OE_PRICING_CONTRACTS
    WHERE   PRICING_CONTRACT_ID = p_pricing_contract_id
    ;

Line: 834


    SELECT  AGREEMENT_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISCOUNT_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PRICE_LIST_ID
    ,       PRICING_CONTRACT_ID
    INTO    l_Contract_rec.agreement_id
    ,       l_Contract_rec.attribute1
    ,       l_Contract_rec.attribute10
    ,       l_Contract_rec.attribute11
    ,       l_Contract_rec.attribute12
    ,       l_Contract_rec.attribute13
    ,       l_Contract_rec.attribute14
    ,       l_Contract_rec.attribute15
    ,       l_Contract_rec.attribute2
    ,       l_Contract_rec.attribute3
    ,       l_Contract_rec.attribute4
    ,       l_Contract_rec.attribute5
    ,       l_Contract_rec.attribute6
    ,       l_Contract_rec.attribute7
    ,       l_Contract_rec.attribute8
    ,       l_Contract_rec.attribute9
    ,       l_Contract_rec.context
    ,       l_Contract_rec.created_by
    ,       l_Contract_rec.creation_date
    ,       l_Contract_rec.discount_id
    ,       l_Contract_rec.last_updated_by
    ,       l_Contract_rec.last_update_date
    ,       l_Contract_rec.last_update_login
    ,       l_Contract_rec.price_list_id
    ,       l_Contract_rec.pricing_contract_id
    FROM    OE_PRICING_CONTRACTS
    WHERE   PRICING_CONTRACT_ID = p_Contract_rec.pricing_contract_id
        FOR UPDATE NOWAIT;

Line: 990


    AND (   (l_Contract_rec.last_updated_by =
             p_Contract_rec.last_updated_by) OR
            ((p_Contract_rec.last_updated_by = FND_API.G_MISS_NUM) OR
            (   (l_Contract_rec.last_updated_by IS NULL) AND
                (p_Contract_rec.last_updated_by IS NULL))))
    AND (   (l_Contract_rec.last_update_date =
             p_Contract_rec.last_update_date) OR
            ((p_Contract_rec.last_update_date = FND_API.G_MISS_DATE) OR
            (   (l_Contract_rec.last_update_date IS NULL) AND
                (p_Contract_rec.last_update_date IS NULL))))
    AND (   (l_Contract_rec.last_update_login =
             p_Contract_rec.last_update_login) OR
            ((p_Contract_rec.last_update_login = FND_API.G_MISS_NUM) OR
            (   (l_Contract_rec.last_update_login IS NULL) AND
                (p_Contract_rec.last_update_login IS NULL))))
    AND (   (l_Contract_rec.price_list_id =
             p_Contract_rec.price_list_id) OR
            ((p_Contract_rec.price_list_id = FND_API.G_MISS_NUM) OR
            (   (l_Contract_rec.price_list_id IS NULL) AND
                (p_Contract_rec.price_list_id IS NULL))))
    AND (   (l_Contract_rec.pricing_contract_id =
             p_Contract_rec.pricing_contract_id) OR
            ((p_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM) OR
            (   (l_Contract_rec.pricing_contract_id IS NULL) AND
                (p_Contract_rec.pricing_contract_id IS NULL))))
    THEN

        --  Row has not changed. Set out parameter.

        x_Contract_rec                 := l_Contract_rec;

Line: 1053


            FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');