APPS.OE_OE_FORM_PRICE_LLINE SQL Statements

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

Line: 657

        l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 1167

,   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_LLine_rec             OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line: 1228

        l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 1250

        select qp_list_lines_s.nextval into l_Price_LLine_rec.price_list_line_id from dual;

Line: 1295

    x_last_update_date             := l_x_Price_LLine_rec.last_update_date;

Line: 1296

    x_last_updated_by              := l_x_Price_LLine_rec.last_updated_by;

Line: 1297

    x_last_update_login            := l_x_Price_LLine_rec.last_update_login;

Line: 1369

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_price_list_line_id            IN  NUMBER
)
IS
l_Price_LLine_rec             OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line: 1418

    l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 1499

            ,   'Delete_Row'
            );

Line: 1510

END Delete_Row;

Line: 1668

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_list_price                    IN  NUMBER
,   p_method_code                   IN  VARCHAR2
,   p_price_list_id                 IN  NUMBER
,   p_price_list_line_id            IN  NUMBER
,   p_pricing_attribute1            IN  VARCHAR2
,   p_pricing_attribute10           IN  VARCHAR2
,   p_pricing_attribute11           IN  VARCHAR2
,   p_pricing_attribute12           IN  VARCHAR2
,   p_pricing_attribute13           IN  VARCHAR2
,   p_pricing_attribute14           IN  VARCHAR2
,   p_pricing_attribute15           IN  VARCHAR2
,   p_pricing_attribute2            IN  VARCHAR2
,   p_pricing_attribute3            IN  VARCHAR2
,   p_pricing_attribute4            IN  VARCHAR2
,   p_pricing_attribute5            IN  VARCHAR2
,   p_pricing_attribute6            IN  VARCHAR2
,   p_pricing_attribute7            IN  VARCHAR2
,   p_pricing_attribute8            IN  VARCHAR2
,   p_pricing_attribute9            IN  VARCHAR2
,   p_pricing_context               IN  VARCHAR2
,   p_pricing_rule_id               IN  NUMBER
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_reprice_flag                  IN  VARCHAR2
,   p_request_id                    IN  NUMBER
,   p_revision                      IN  VARCHAR2
,   p_revision_date                 IN  DATE
,   p_revision_reason_code          IN  VARCHAR2
,   p_start_date_active             IN  DATE
,   p_unit_code                     IN  VARCHAR2
,   p_primary                       IN  VARCHAR2
,   p_list_line_type_code           IN  VARCHAR2
)
IS
l_return_status               VARCHAR2(1);

Line: 1750

    l_Price_LLine_rec.last_updated_by := p_last_updated_by;

Line: 1751

    l_Price_LLine_rec.last_update_date := p_last_update_date;

Line: 1752

    l_Price_LLine_rec.last_update_login := p_last_update_login;

Line: 1776

    l_Price_LLine_rec.program_update_date := p_program_update_date;