APPS.QP_QP_FORM_PRICE_LIST_LINE SQL Statements

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

Line: 682

        l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 1285

,   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
,   x_program_application_id        OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_program_id                    OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_program_update_date           OUT NOCOPY /* file.sql.39 change */ DATE
,   x_request_id                    OUT NOCOPY /* file.sql.39 change */ NUMBER
)
IS
l_PRICE_LIST_LINE_rec         QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line: 1338

        l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 1378

    x_last_update_date             := l_x_PRICE_LIST_LINE_rec.last_update_date;

Line: 1379

    x_last_updated_by              := l_x_PRICE_LIST_LINE_rec.last_updated_by;

Line: 1380

  x_last_update_login            := l_x_PRICE_LIST_LINE_rec.last_update_login;

Line: 1383

 x_program_update_date     := l_x_PRICE_LIST_LINE_rec.program_update_date;

Line: 1455

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_list_line_id                  IN  NUMBER
)
IS
l_PRICE_LIST_LINE_rec         QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line: 1499

    l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1576

            ,   'Delete_Row'
            );

Line: 1587

END Delete_Row;

Line: 1741

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_list_header_id                IN  NUMBER
,   p_list_line_id                  IN  NUMBER
,   p_list_line_type_code           IN  VARCHAR2
,   p_list_price                    IN  NUMBER
,   p_product_precedence            IN  NUMBER
,   p_modifier_level_code           IN  VARCHAR2
,   p_number_effective_periods      IN  NUMBER
,   p_operand                       IN  NUMBER
,   p_organization_id               IN  NUMBER
,   p_override_flag                 IN  VARCHAR2
,   p_percent_price                 IN  NUMBER
,   p_price_break_type_code         IN  VARCHAR2
,   p_price_by_formula_id           IN  NUMBER
,   p_primary_uom_flag              IN  VARCHAR2
,   p_print_on_invoice_flag         IN  VARCHAR2
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_rebate_trxn_type_code         IN  VARCHAR2
,   p_related_item_id               IN  NUMBER
,   p_relationship_type_id          IN  NUMBER
,   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_substitution_attribute        IN  VARCHAR2
,   p_substitution_context          IN  VARCHAR2
,   p_substitution_value            IN  VARCHAR2
,   p_recurring_value               IN  NUMBER -- block pricing
,   p_customer_item_id              IN  NUMBER
,   p_break_uom_code                IN  VARCHAR2 -- OKS proration
,   p_break_uom_context             IN  VARCHAR2 -- OKS
,   p_break_uom_attribute           IN  VARCHAR2 -- OKS proration
,   p_continuous_price_break_flag       IN  VARCHAR2 --Continuous price breaks
)
IS
l_return_status               VARCHAR2(1);

Line: 1828

    l_PRICE_LIST_LINE_rec.last_updated_by := p_last_updated_by;

Line: 1829

    l_PRICE_LIST_LINE_rec.last_update_date := p_last_update_date;

Line: 1830

    l_PRICE_LIST_LINE_rec.last_update_login := p_last_update_login;

Line: 1848

    l_PRICE_LIST_LINE_rec.program_update_date := p_program_update_date;

Line: 2027

       QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
					p_entity_code  => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE
					,p_entity_id    => p_list_line_id
				     ,x_return_status => l_return_status);

Line: 2061

Procedure Delete_All_Requests
(   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
)
IS
l_return_status                     Varchar2(30);

Line: 2080

            ,   'Delete_All_Requests'
            );

Line: 2090

END Delete_All_Requests;