APPS.QP_QP_FORM_FORMULA_LINES SQL Statements

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

Line: 628

        l_FORMULA_LINES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 957

,   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_FORMULA_LINES_rec           QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

Line: 1003

        l_FORMULA_LINES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 1041

    x_last_update_date             := l_x_FORMULA_LINES_rec.last_update_date;

Line: 1042

    x_last_updated_by              := l_x_FORMULA_LINES_rec.last_updated_by;

Line: 1043

    x_last_update_login            := l_x_FORMULA_LINES_rec.last_update_login;

Line: 1114

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_formula_line_id         IN  NUMBER
)
IS
l_FORMULA_LINES_rec           QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

Line: 1154

    l_FORMULA_LINES_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1229

            ,   'Delete_Row'
            );

Line: 1240

END Delete_Row;

Line: 1377

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_numeric_constant              IN  NUMBER
,   p_price_formula_id              IN  NUMBER
,   p_price_formula_line_id         IN  NUMBER
,   p_formula_line_type_code        IN  VARCHAR2
,   p_price_list_line_id            IN  NUMBER
,   p_price_modifier_list_id        IN  NUMBER
,   p_pricing_attribute             IN  VARCHAR2
,   p_pricing_attribute_context     IN  VARCHAR2
,   p_start_date_active             IN  DATE
,   p_step_number                   IN  NUMBER
,   p_reqd_flag                     IN  VARCHAR2
)
IS
l_return_status               VARCHAR2(1);

Line: 1422

    l_FORMULA_LINES_rec.last_updated_by := p_last_updated_by;

Line: 1423

    l_FORMULA_LINES_rec.last_update_date := p_last_update_date;

Line: 1424

    l_FORMULA_LINES_rec.last_update_login := p_last_update_login;