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_PRICE_BREAK_UTIL SQL Statements

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

Line: 134


        IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.last_updated_by,p_old_Price_Break_rec.last_updated_by)
        THEN
            NULL;

Line: 139


        IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.last_update_date,p_old_Price_Break_rec.last_update_date)
        THEN
            NULL;

Line: 144


        IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.last_update_login,p_old_Price_Break_rec.last_update_login)
        THEN
            NULL;

Line: 184


        IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.program_update_date,p_old_Price_Break_rec.program_update_date)
        THEN
            NULL;

Line: 246


    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        NULL;

Line: 248


    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        NULL;

Line: 250


    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        NULL;

Line: 266


    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        NULL;

Line: 398


    IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.last_updated_by,p_old_Price_Break_rec.last_updated_by)
    THEN
        NULL;

Line: 403


    IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.last_update_date,p_old_Price_Break_rec.last_update_date)
    THEN
        NULL;

Line: 408


    IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.last_update_login,p_old_Price_Break_rec.last_update_login)
    THEN
        NULL;

Line: 448


    IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.program_update_date,p_old_Price_Break_rec.program_update_date)
    THEN
        NULL;

Line: 564


    IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_Price_Break_rec.last_updated_by := p_old_Price_Break_rec.last_updated_by;

Line: 568


    IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_Price_Break_rec.last_update_date := p_old_Price_Break_rec.last_update_date;

Line: 572


    IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_Price_Break_rec.last_update_login := p_old_Price_Break_rec.last_update_login;

Line: 604


    IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_Price_Break_rec.program_update_date := p_old_Price_Break_rec.program_update_date;

Line: 717


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

Line: 721


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

Line: 725


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

Line: 757


    IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_Price_Break_rec.program_update_date := NULL;

Line: 779


PROCEDURE Update_Row
(   p_Price_Break_rec               IN  OE_Pricing_Cont_PUB.Price_Break_Rec_Type
)
IS
BEGIN

    UPDATE  OE_PRICE_BREAK_LINES
    SET     AMOUNT                         = p_Price_Break_rec.amount
    ,       ATTRIBUTE1                     = p_Price_Break_rec.attribute1
    ,       ATTRIBUTE10                    = p_Price_Break_rec.attribute10
    ,       ATTRIBUTE11                    = p_Price_Break_rec.attribute11
    ,       ATTRIBUTE12                    = p_Price_Break_rec.attribute12
    ,       ATTRIBUTE13                    = p_Price_Break_rec.attribute13
    ,       ATTRIBUTE14                    = p_Price_Break_rec.attribute14
    ,       ATTRIBUTE15                    = p_Price_Break_rec.attribute15
    ,       ATTRIBUTE2                     = p_Price_Break_rec.attribute2
    ,       ATTRIBUTE3                     = p_Price_Break_rec.attribute3
    ,       ATTRIBUTE4                     = p_Price_Break_rec.attribute4
    ,       ATTRIBUTE5                     = p_Price_Break_rec.attribute5
    ,       ATTRIBUTE6                     = p_Price_Break_rec.attribute6
    ,       ATTRIBUTE7                     = p_Price_Break_rec.attribute7
    ,       ATTRIBUTE8                     = p_Price_Break_rec.attribute8
    ,       ATTRIBUTE9                     = p_Price_Break_rec.attribute9
    ,       CONTEXT                        = p_Price_Break_rec.context
    ,       CREATED_BY                     = p_Price_Break_rec.created_by
    ,       CREATION_DATE                  = p_Price_Break_rec.creation_date
    ,       DISCOUNT_LINE_ID               = p_Price_Break_rec.discount_line_id
    ,       END_DATE_ACTIVE                = p_Price_Break_rec.end_date_active
    ,       LAST_UPDATED_BY                = p_Price_Break_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_Price_Break_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_Price_Break_rec.last_update_login
    ,       METHOD_TYPE_CODE               = p_Price_Break_rec.method_type_code
    ,       PERCENT                        = p_Price_Break_rec.percent
    ,       PRICE                          = p_Price_Break_rec.price
    ,       PRICE_BREAK_LINES_HIGH_RANGE   = p_Price_Break_rec.price_break_high
    ,       PRICE_BREAK_LINES_LOW_RANGE    = p_Price_Break_rec.price_break_low
    ,       PROGRAM_APPLICATION_ID         = p_Price_Break_rec.program_application_id
    ,       PROGRAM_ID                     = p_Price_Break_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_Price_Break_rec.program_update_date
    ,       REQUEST_ID                     = p_Price_Break_rec.request_id
    ,       START_DATE_ACTIVE              = p_Price_Break_rec.start_date_active
    ,       UNIT_CODE                      = p_Price_Break_rec.unit_code
    WHERE   DISCOUNT_LINE_ID = p_Price_Break_rec.discount_line_id
    AND     METHOD_TYPE_CODE = p_Price_Break_rec.method_type_code
    AND     PRICE_BREAK_LINES_HIGH_RANGE = p_Price_Break_rec.price_break_high
    AND     PRICE_BREAK_LINES_LOW_RANGE = p_Price_Break_rec.price_break_low
    ;

Line: 835


            ,   'Update_Row'
            );

Line: 841


END Update_Row;

Line: 845


PROCEDURE Insert_Row
(   p_Price_Break_rec               IN  OE_Pricing_Cont_PUB.Price_Break_Rec_Type
)
IS
BEGIN

    INSERT  INTO OE_PRICE_BREAK_LINES
    (       AMOUNT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISCOUNT_LINE_ID
    ,       END_DATE_ACTIVE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       METHOD_TYPE_CODE
    ,       PERCENT
    ,       PRICE
    ,       PRICE_BREAK_LINES_HIGH_RANGE
    ,       PRICE_BREAK_LINES_LOW_RANGE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       START_DATE_ACTIVE
    ,       UNIT_CODE
    )
    VALUES
    (       p_Price_Break_rec.amount
    ,       p_Price_Break_rec.attribute1
    ,       p_Price_Break_rec.attribute10
    ,       p_Price_Break_rec.attribute11
    ,       p_Price_Break_rec.attribute12
    ,       p_Price_Break_rec.attribute13
    ,       p_Price_Break_rec.attribute14
    ,       p_Price_Break_rec.attribute15
    ,       p_Price_Break_rec.attribute2
    ,       p_Price_Break_rec.attribute3
    ,       p_Price_Break_rec.attribute4
    ,       p_Price_Break_rec.attribute5
    ,       p_Price_Break_rec.attribute6
    ,       p_Price_Break_rec.attribute7
    ,       p_Price_Break_rec.attribute8
    ,       p_Price_Break_rec.attribute9
    ,       p_Price_Break_rec.context
    ,       p_Price_Break_rec.created_by
    ,       p_Price_Break_rec.creation_date
    ,       p_Price_Break_rec.discount_line_id
    ,       p_Price_Break_rec.end_date_active
    ,       p_Price_Break_rec.last_updated_by
    ,       p_Price_Break_rec.last_update_date
    ,       p_Price_Break_rec.last_update_login
    ,       p_Price_Break_rec.method_type_code
    ,       p_Price_Break_rec.percent
    ,       p_Price_Break_rec.price
    ,       p_Price_Break_rec.price_break_high
    ,       p_Price_Break_rec.price_break_low
    ,       p_Price_Break_rec.program_application_id
    ,       p_Price_Break_rec.program_id
    ,       p_Price_Break_rec.program_update_date
    ,       p_Price_Break_rec.request_id
    ,       p_Price_Break_rec.start_date_active
    ,       p_Price_Break_rec.unit_code
    );

Line: 934


            ,   'Insert_Row'
            );

Line: 940


END Insert_Row;

Line: 944


PROCEDURE Delete_Row
(   p_discount_line_id              IN  NUMBER
,   p_method_type_code              IN  VARCHAR2
,   p_price_break_high              IN  NUMBER
,   p_price_break_low               IN  NUMBER
)
IS
BEGIN

    DELETE  FROM OE_PRICE_BREAK_LINES
    WHERE   DISCOUNT_LINE_ID = p_discount_line_id
    AND     METHOD_TYPE_CODE = p_method_type_code
    AND     PRICE_BREAK_LINES_HIGH_RANGE = p_price_break_high
    AND     PRICE_BREAK_LINES_LOW_RANGE = p_price_break_low
    ;

Line: 968


            ,   'Delete_Row'
            );

Line: 974


END Delete_Row;

Line: 1015


    SELECT  AMOUNT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISCOUNT_LINE_ID
    ,       END_DATE_ACTIVE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       METHOD_TYPE_CODE
    ,       PERCENT
    ,       PRICE
    ,       PRICE_BREAK_LINES_HIGH_RANGE
    ,       PRICE_BREAK_LINES_LOW_RANGE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       START_DATE_ACTIVE
    ,       UNIT_CODE
    FROM    OE_PRICE_BREAK_LINES
    WHERE ( DISCOUNT_LINE_ID = p_discount_line_id
    AND     METHOD_TYPE_CODE = p_method_type_code
    AND     PRICE_BREAK_LINES_HIGH_RANGE = p_price_break_high
    AND     PRICE_BREAK_LINES_LOW_RANGE = p_price_break_low
    )
    OR (    DISCOUNT_LINE_ID = p_discount_line_id
    );

Line: 1122


        l_Price_Break_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1123


        l_Price_Break_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1124


        l_Price_Break_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1132


        l_Price_Break_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1203


    SELECT  AMOUNT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISCOUNT_LINE_ID
    ,       END_DATE_ACTIVE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       METHOD_TYPE_CODE
    ,       PERCENT
    ,       PRICE
    ,       PRICE_BREAK_LINES_HIGH_RANGE
    ,       PRICE_BREAK_LINES_LOW_RANGE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       START_DATE_ACTIVE
    ,       UNIT_CODE
    INTO    l_Price_Break_rec.amount
    ,       l_Price_Break_rec.attribute1
    ,       l_Price_Break_rec.attribute10
    ,       l_Price_Break_rec.attribute11
    ,       l_Price_Break_rec.attribute12
    ,       l_Price_Break_rec.attribute13
    ,       l_Price_Break_rec.attribute14
    ,       l_Price_Break_rec.attribute15
    ,       l_Price_Break_rec.attribute2
    ,       l_Price_Break_rec.attribute3
    ,       l_Price_Break_rec.attribute4
    ,       l_Price_Break_rec.attribute5
    ,       l_Price_Break_rec.attribute6
    ,       l_Price_Break_rec.attribute7
    ,       l_Price_Break_rec.attribute8
    ,       l_Price_Break_rec.attribute9
    ,       l_Price_Break_rec.context
    ,       l_Price_Break_rec.created_by
    ,       l_Price_Break_rec.creation_date
    ,       l_Price_Break_rec.discount_line_id
    ,       l_Price_Break_rec.end_date_active
    ,       l_Price_Break_rec.last_updated_by
    ,       l_Price_Break_rec.last_update_date
    ,       l_Price_Break_rec.last_update_login
    ,       l_Price_Break_rec.method_type_code
    ,       l_Price_Break_rec.percent
    ,       l_Price_Break_rec.price
    ,       l_Price_Break_rec.price_break_high
    ,       l_Price_Break_rec.price_break_low
    ,       l_Price_Break_rec.program_application_id
    ,       l_Price_Break_rec.program_id
    ,       l_Price_Break_rec.program_update_date
    ,       l_Price_Break_rec.request_id
    ,       l_Price_Break_rec.start_date_active
    ,       l_Price_Break_rec.unit_code
    FROM    OE_PRICE_BREAK_LINES
    WHERE   DISCOUNT_LINE_ID = p_Price_Break_rec.discount_line_id
    AND     METHOD_TYPE_CODE = p_Price_Break_rec.method_type_code
    AND     PRICE_BREAK_LINES_HIGH_RANGE = p_Price_Break_rec.price_break_high
    AND     PRICE_BREAK_LINES_LOW_RANGE = p_Price_Break_rec.price_break_low
        FOR UPDATE NOWAIT;

Line: 1387


    AND (   (l_Price_Break_rec.last_updated_by =
             p_Price_Break_rec.last_updated_by) OR
            ((p_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.last_updated_by IS NULL) AND
                (p_Price_Break_rec.last_updated_by IS NULL))))
    AND (   (l_Price_Break_rec.last_update_date =
             p_Price_Break_rec.last_update_date) OR
            ((p_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE) OR
            (   (l_Price_Break_rec.last_update_date IS NULL) AND
                (p_Price_Break_rec.last_update_date IS NULL))))
    AND (   (l_Price_Break_rec.last_update_login =
             p_Price_Break_rec.last_update_login) OR
            ((p_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.last_update_login IS NULL) AND
                (p_Price_Break_rec.last_update_login IS NULL))))
    AND (   (l_Price_Break_rec.method_type_code =
             p_Price_Break_rec.method_type_code) OR
            ((p_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR) OR
            (   (l_Price_Break_rec.method_type_code IS NULL) AND
                (p_Price_Break_rec.method_type_code IS NULL))))
    AND (   (l_Price_Break_rec.percent =
             p_Price_Break_rec.percent) OR
            ((p_Price_Break_rec.percent = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.percent IS NULL) AND
                (p_Price_Break_rec.percent IS NULL))))
    AND (   (l_Price_Break_rec.price =
             p_Price_Break_rec.price) OR
            ((p_Price_Break_rec.price = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.price IS NULL) AND
                (p_Price_Break_rec.price IS NULL))))
    AND (   (l_Price_Break_rec.price_break_high =
             p_Price_Break_rec.price_break_high) OR
            ((p_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.price_break_high IS NULL) AND
                (p_Price_Break_rec.price_break_high IS NULL))))
    AND (   (l_Price_Break_rec.price_break_low =
             p_Price_Break_rec.price_break_low) OR
            ((p_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.price_break_low IS NULL) AND
                (p_Price_Break_rec.price_break_low IS NULL))))
    AND (   (l_Price_Break_rec.program_application_id =
             p_Price_Break_rec.program_application_id) OR
            ((p_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.program_application_id IS NULL) AND
                (p_Price_Break_rec.program_application_id IS NULL))))
    AND (   (l_Price_Break_rec.program_id =
             p_Price_Break_rec.program_id) OR
            ((p_Price_Break_rec.program_id = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.program_id IS NULL) AND
                (p_Price_Break_rec.program_id IS NULL))))
    AND (   (l_Price_Break_rec.program_update_date =
             p_Price_Break_rec.program_update_date) OR
            ((p_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE) OR
            (   (l_Price_Break_rec.program_update_date IS NULL) AND
                (p_Price_Break_rec.program_update_date IS NULL))))
    AND (   (l_Price_Break_rec.request_id =
             p_Price_Break_rec.request_id) OR
            ((p_Price_Break_rec.request_id = FND_API.G_MISS_NUM) OR
            (   (l_Price_Break_rec.request_id IS NULL) AND
                (p_Price_Break_rec.request_id IS NULL))))
    AND (   (l_Price_Break_rec.start_date_active =
             p_Price_Break_rec.start_date_active) OR
            ((p_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE) OR
            (   (l_Price_Break_rec.start_date_active IS NULL) AND
                (p_Price_Break_rec.start_date_active IS NULL))))
    AND (   (l_Price_Break_rec.unit_code =
             p_Price_Break_rec.unit_code) OR
            ((p_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR) OR
            (   (l_Price_Break_rec.unit_code IS NULL) AND
                (p_Price_Break_rec.unit_code IS NULL))))
    THEN

        --  Row has not changed. Set out parameter.

        x_Price_Break_rec              := l_Price_Break_rec;

Line: 1495


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