APPS.OE_OE_FORM_PRICE_BREAK SQL Statements

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

Line: 476

        l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 798

,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
)
IS
l_Price_Break_rec             OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line: 871

    select qp_list_lines_s.nextval into l_Price_LLine_rec.price_list_line_id
    from dual;

Line: 880

    select sysdate into l_Price_LLine_rec.creation_date
    from dual;

Line: 934

    x_last_update_date             := l_x_Price_Break_rec.last_update_date;

Line: 935

    x_last_updated_by              := l_x_Price_Break_rec.last_updated_by;

Line: 936

    x_last_update_login            := l_x_Price_Break_rec.last_update_login;

Line: 1019

 SELECT  ATTRIBUTE1
,       ATTRIBUTE10
,       ATTRIBUTE11
,       ATTRIBUTE12
,       ATTRIBUTE13
,       ATTRIBUTE14
,       ATTRIBUTE15
,       ATTRIBUTE2
,       ATTRIBUTE3
,       ATTRIBUTE4
,       ATTRIBUTE5
,       ATTRIBUTE6
,       ATTRIBUTE7
,       ATTRIBUTE8
,       ATTRIBUTE9
,       COMMENTS
,       CONTEXT
,       CREATED_BY
,       CREATION_DATE
,       CUSTOMER_ITEM_ID
,       END_DATE_ACTIVE
,       INVENTORY_ITEM_ID
,       LAST_UPDATED_BY
,       LAST_UPDATE_DATE
,       LAST_UPDATE_LOGIN
,       LIST_PRICE
,       METHOD_CODE
,       PRICE_LIST_ID
,       PRICE_LIST_LINE_ID
,       PRICING_ATTRIBUTE1
,       PRICING_ATTRIBUTE10
,       PRICING_ATTRIBUTE11
,       PRICING_ATTRIBUTE12
,       PRICING_ATTRIBUTE13
,       PRICING_ATTRIBUTE14
,       PRICING_ATTRIBUTE15
,       PRICING_ATTRIBUTE2
,       PRICING_ATTRIBUTE3
,       PRICING_ATTRIBUTE4
,       PRICING_ATTRIBUTE5
,       PRICING_ATTRIBUTE6
,       PRICING_ATTRIBUTE7
,       PRICING_ATTRIBUTE8
,       PRICING_ATTRIBUTE9
,       PRICING_CONTEXT
,       PRICING_RULE_ID
,       PRIMARY
,       PROGRAM_APPLICATION_ID
,       PROGRAM_ID
,       PROGRAM_UPDATE_DATE
,       REPRICE_FLAG
,       REQUEST_ID
,       REVISION
,       REVISION_DATE
,       REVISION_REASON_CODE
,       START_DATE_ACTIVE
,       UNIT_CODE
INTO        l_Price_LLine_rec.ATTRIBUTE1
,       l_Price_LLine_rec.ATTRIBUTE10
,       l_Price_LLine_rec.ATTRIBUTE11
,       l_Price_LLine_rec.ATTRIBUTE12
,       l_Price_LLine_rec.ATTRIBUTE13
,       l_Price_LLine_rec.ATTRIBUTE14
,       l_Price_LLine_rec.ATTRIBUTE15
,       l_Price_LLine_rec.ATTRIBUTE2
,       l_Price_LLine_rec.ATTRIBUTE3
,       l_Price_LLine_rec.ATTRIBUTE4
,       l_Price_LLine_rec.ATTRIBUTE5
,       l_Price_LLine_rec.ATTRIBUTE6
,       l_Price_LLine_rec.ATTRIBUTE7
,       l_Price_LLine_rec.ATTRIBUTE8
,       l_Price_LLine_rec.ATTRIBUTE9
,       l_Price_LLine_rec.COMMENTS
,       l_Price_LLine_rec.CONTEXT
,       l_Price_LLine_rec.CREATED_BY
,       l_Price_LLine_rec.CREATION_DATE
,       l_Price_LLine_rec.CUSTOMER_ITEM_ID
,       l_Price_LLine_rec.END_DATE_ACTIVE
,       l_Price_LLine_rec.INVENTORY_ITEM_ID
,       l_Price_LLine_rec.LAST_UPDATED_BY
,       l_Price_LLine_rec.LAST_UPDATE_DATE
,       l_Price_LLine_rec.LAST_UPDATE_LOGIN
,       l_Price_LLine_rec.LIST_PRICE
,       l_Price_LLine_rec.METHOD_CODE
,       l_Price_LLine_rec.PRICE_LIST_ID
,       l_Price_LLine_rec.PRICE_LIST_LINE_ID
,       l_Price_LLine_rec.PRICING_ATTRIBUTE1
,       l_Price_LLine_rec.PRICING_ATTRIBUTE10
,       l_Price_LLine_rec.PRICING_ATTRIBUTE11
,       l_Price_LLine_rec.PRICING_ATTRIBUTE12
,       l_Price_LLine_rec.PRICING_ATTRIBUTE13
,       l_Price_LLine_rec.PRICING_ATTRIBUTE14
,       l_Price_LLine_rec.PRICING_ATTRIBUTE15
,       l_Price_LLine_rec.PRICING_ATTRIBUTE2
,       l_Price_LLine_rec.PRICING_ATTRIBUTE3
,       l_Price_LLine_rec.PRICING_ATTRIBUTE4
,       l_Price_LLine_rec.PRICING_ATTRIBUTE5
,       l_Price_LLine_rec.PRICING_ATTRIBUTE6
,       l_Price_LLine_rec.PRICING_ATTRIBUTE7
,       l_Price_LLine_rec.PRICING_ATTRIBUTE8
,       l_Price_LLine_rec.PRICING_ATTRIBUTE9
,       l_Price_LLine_rec.PRICING_CONTEXT
,       l_Price_LLine_rec.PRICING_RULE_ID
,       l_Price_LLine_rec.PRIMARY
,       l_Price_LLine_rec.PROGRAM_APPLICATION_ID
,       l_Price_LLine_rec.PROGRAM_ID
,       l_Price_LLine_rec.PROGRAM_UPDATE_DATE
,       l_Price_LLine_rec.REPRICE_FLAG
,       l_Price_LLine_rec.REQUEST_ID
,       l_Price_LLine_rec.REVISION
,       l_Price_LLine_rec.REVISION_DATE
,       l_Price_LLine_rec.REVISION_REASON_CODE
,       l_Price_LLine_rec.START_DATE_ACTIVE
,       l_Price_LLine_rec.UNIT_CODE

FROM    	qp_price_list_lines_v WHERE ( PRICE_LIST_LINE_ID = p_price_list_line_id);

Line: 1152

PROCEDURE Delete_Row
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   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
l_Price_Break_rec             OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line: 1207

    l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 1288

            ,   'Delete_Row'
            );

Line: 1299

END Delete_Row;

Line: 1453

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_method_type_code              IN  VARCHAR2
,   p_percent                       IN  NUMBER
,   p_price                         IN  NUMBER
,   p_price_break_high              IN  NUMBER
,   p_price_break_low               IN  NUMBER
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_request_id                    IN  NUMBER
,   p_start_date_active             IN  DATE
,   p_unit_code                     IN  VARCHAR2
)
IS
l_return_status               VARCHAR2(1);

Line: 1509

    l_Price_Break_rec.last_updated_by := p_last_updated_by;

Line: 1510

    l_Price_Break_rec.last_update_date := p_last_update_date;

Line: 1511

    l_Price_Break_rec.last_update_login := p_last_update_login;

Line: 1519

    l_Price_Break_rec.program_update_date := p_program_update_date;