APPS.QP_QP_FORM_CURR_DETAILS SQL Statements

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

Line: 492

        l_CURR_DETAILS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 888

,   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_CURR_DETAILS_rec            QP_Currency_PUB.Curr_Details_Rec_Type;

Line: 935

        l_CURR_DETAILS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 975

    x_last_update_date             := l_x_CURR_DETAILS_rec.last_update_date;

Line: 976

    x_last_updated_by              := l_x_CURR_DETAILS_rec.last_updated_by;

Line: 977

    x_last_update_login            := l_x_CURR_DETAILS_rec.last_update_login;

Line: 1048

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_currency_detail_id            IN  NUMBER
)
IS
l_CURR_DETAILS_rec            QP_Currency_PUB.Curr_Details_Rec_Type;

Line: 1088

    l_CURR_DETAILS_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1163

            ,   'Delete_Row'
            );

Line: 1174

END Delete_Row;

Line: 1318

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_markup_formula_id             IN  NUMBER
,   p_markup_operator               IN  VARCHAR2
,   p_markup_value                  IN  NUMBER
,   p_price_formula_id              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_rounding_factor               IN  NUMBER
,   p_selling_rounding_factor       IN  NUMBER
,   p_start_date_active             IN  DATE
,   p_to_currency_code              IN  VARCHAR2
,   p_curr_attribute_type           IN  VARCHAR2
,   p_curr_attribute_context        IN  VARCHAR2
,   p_curr_attribute                IN  VARCHAR2
,   p_curr_attribute_value          IN  VARCHAR2
,   p_precedence                    IN  NUMBER
)
IS
l_return_status               VARCHAR2(1);

Line: 1378

    l_CURR_DETAILS_rec.last_updated_by := p_last_updated_by;

Line: 1379

    l_CURR_DETAILS_rec.last_update_date := p_last_update_date;

Line: 1380

    l_CURR_DETAILS_rec.last_update_login := p_last_update_login;

Line: 1387

    l_CURR_DETAILS_rec.program_update_date := p_program_update_date;