APPS.QP_QP_FORM_PLL_PRICING_ATTR SQL Statements

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

Line: 507

        l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 873

,   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_PRICING_ATTR_rec            QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line: 928

        l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 968

    x_last_update_date             := l_x_PRICING_ATTR_rec.last_update_date;

Line: 969

    x_last_updated_by              := l_x_PRICING_ATTR_rec.last_updated_by;

Line: 970

    x_last_update_login            := l_x_PRICING_ATTR_rec.last_update_login;

Line: 973

    x_program_update_date          := l_x_PRICING_ATTR_rec.program_update_date;

Line: 1052

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_pricing_attribute_id          IN  NUMBER
)
IS
l_PRICING_ATTR_rec            QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line: 1102

    l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1112

select start_date_active, end_date_active , revision, list_header_id
    into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
    from qp_list_lines
    where list_line_id = l_pricing_attr_rec.list_line_id;

Line: 1137

	  oe_debug_pub.add('failed in logging a delayed request in delete_row ');

Line: 1148

    oe_debug_pub.add('Logging a request to update qualification_ind  ', 1);

Line: 1154

                 p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
                 x_return_status => l_return_status);

Line: 1159

          oe_debug_pub.add('failed in logging a delayed request in delete_row ');

Line: 1234

            ,   'Delete_Row'
            );

Line: 1245

END Delete_Row;

Line: 1390

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_list_line_id                  IN  NUMBER
,   p_pricing_attribute             IN  VARCHAR2
,   p_pricing_attribute_context     IN  VARCHAR2
,   p_pricing_attribute_id          IN  NUMBER
,   p_pricing_attr_value_from       IN  VARCHAR2
,   p_pricing_attr_value_to         IN  VARCHAR2
,   p_product_attribute             IN  VARCHAR2
,   p_product_attribute_context     IN  VARCHAR2
,   p_product_attr_value            IN  VARCHAR2
,   p_product_uom_code              IN  VARCHAR2
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_request_id                    IN  NUMBER
,   p_comparison_operator_code      IN VARCHAR2
,   p_pricing_attribute_datatype    IN VARCHAR2
,   p_product_attribute_datatype    IN VARCHAR2
)
IS
l_return_status               VARCHAR2(1);

Line: 1447

    l_PRICING_ATTR_rec.last_updated_by := p_last_updated_by;

Line: 1448

    l_PRICING_ATTR_rec.last_update_date := p_last_update_date;

Line: 1449

    l_PRICING_ATTR_rec.last_update_login := p_last_update_login;

Line: 1462

    l_PRICING_ATTR_rec.program_update_date := p_program_update_date;

Line: 1617

       QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
					p_entity_code  => QP_GLOBALS.G_ENTITY_PRICING_ATTR
					,p_entity_id    => p_pricing_attribute_id
				     ,x_return_status => l_return_status);

Line: 1651

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: 1670

            ,   'Delete_All_Requests'
            );

Line: 1680

END Delete_All_Requests;

Line: 1713

 SELECT
   L.ACCRUAL_QTY
,L.ACCRUAL_UOM_CODE
,L.ARITHMETIC_OPERATOR
,L.ATTRIBUTE1
,L.ATTRIBUTE10
,L.ATTRIBUTE11
,L.ATTRIBUTE12
,L.ATTRIBUTE13
,L.ATTRIBUTE14
,L.ATTRIBUTE15
,L.ATTRIBUTE2
,L.ATTRIBUTE3
,L.ATTRIBUTE4
,L.ATTRIBUTE5
,L.ATTRIBUTE6
,L.ATTRIBUTE7
,L.ATTRIBUTE8
,L.ATTRIBUTE9
,L.AUTOMATIC_FLAG
,L.BASE_QTY
,L.BASE_UOM_CODE
,L.COMMENTS
,L.CONTEXT
,L.CREATED_BY
,L.CREATION_DATE
,L.EFFECTIVE_PERIOD_UOM
,L.END_DATE_ACTIVE
,L.ESTIM_ACCRUAL_RATE
,L.GENERATE_USING_FORMULA_ID
,L.INVENTORY_ITEM_ID
,L.LAST_UPDATED_BY
,L.LAST_UPDATE_DATE
,L.LAST_UPDATE_LOGIN
,L.LIST_HEADER_ID
,L.LIST_LINE_ID
,L.LIST_LINE_TYPE_CODE
,L.LIST_PRICE
,L.MODIFIER_LEVEL_CODE
,L.NUMBER_EFFECTIVE_PERIODS
,L.OPERAND
,L.ORGANIZATION_ID
,L.OVERRIDE_FLAG
,L.PERCENT_PRICE
,L.PRICE_BREAK_TYPE_CODE
,L.PRICE_BY_FORMULA_ID
,L.PRIMARY_UOM_FLAG
,L.PRINT_ON_INVOICE_FLAG
,L.PROGRAM_APPLICATION_ID
,L.PROGRAM_ID
,L.PROGRAM_UPDATE_DATE
,L.REBATE_TRANSACTION_TYPE_CODE
,L.RELATED_ITEM_ID
,L.RELATIONSHIP_TYPE_ID
,L.REPRICE_FLAG
,L.REQUEST_ID
,L.REVISION
,L.REVISION_DATE
,L.REVISION_REASON_CODE
,L.START_DATE_ACTIVE
,L.SUBSTITUTION_ATTRIBUTE
,L.SUBSTITUTION_CONTEXT
,L.SUBSTITUTION_VALUE
,RM.RLTD_MODIFIER_ID
,RM.FROM_RLTD_MODIFIER_ID
,RM.TO_RLTD_MODIFIER_ID
,RM.RLTD_MODIFIER_GRP_NO
,RM.RLTD_MODIFIER_GRP_TYPE
,L.PRODUCT_PRECEDENCE
,L.LIST_LINE_NO
,L.QUALIFICATION_IND
,L.RECURRING_VALUE
,L.CUSTOMER_ITEM_ID
,L.BREAK_UOM_CODE
,L.BREAK_UOM_CONTEXT
,L.BREAK_UOM_ATTRIBUTE
 FROM    QP_LIST_LINES L, QP_RLTD_MODIFIERS RM
 WHERE   L.LIST_LINE_ID  = RM.TO_RLTD_MODIFIER_ID
 AND     RM.FROM_RLTD_MODIFIER_ID = p_list_line_id;

Line: 1796

    SELECT  ACCUMULATE_FLAG
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_GROUPING_NO
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_LINE_ID
    ,       LIST_HEADER_ID
    ,       PRICING_PHASE_ID
    ,       PRICING_ATTRIBUTE
    ,       PRICING_ATTRIBUTE_CONTEXT
    ,       PRICING_ATTRIBUTE_ID
    ,       PRICING_ATTR_VALUE_FROM
    ,       PRICING_ATTR_VALUE_TO
    ,       PRODUCT_ATTRIBUTE
    ,       PRODUCT_ATTRIBUTE_CONTEXT
    ,       PRODUCT_ATTR_VALUE
    ,       PRODUCT_UOM_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       COMPARISON_OPERATOR_CODE
    ,       PRICING_ATTRIBUTE_DATATYPE
    ,       PRODUCT_ATTRIBUTE_DATATYPE
    ,       PRICING_ATTR_VALUE_FROM_NUMBER
    ,       PRICING_ATTR_VALUE_TO_NUMBER
    ,       QUALIFICATION_IND
    FROM    QP_PRICING_ATTRIBUTES
    WHERE     LIST_LINE_ID = p_list_line_id
              AND PRICING_ATTRIBUTE_CONTEXT IS NOT NULL;

Line: 1851

SELECT  ACCUMULATE_FLAG
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_GROUPING_NO
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_LINE_ID
    ,       LIST_HEADER_ID
    ,       PRICING_PHASE_ID
    ,       PRICING_ATTRIBUTE
    ,       PRICING_ATTRIBUTE_CONTEXT
    ,       PRICING_ATTRIBUTE_ID
    ,       PRICING_ATTR_VALUE_FROM
    ,       PRICING_ATTR_VALUE_TO
    ,       PRODUCT_ATTRIBUTE
    ,       PRODUCT_ATTRIBUTE_CONTEXT
    ,       PRODUCT_ATTR_VALUE
    ,       PRODUCT_UOM_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       COMPARISON_OPERATOR_CODE
    ,       PRICING_ATTRIBUTE_DATATYPE
    ,       PRODUCT_ATTRIBUTE_DATATYPE
    ,       PRICING_ATTR_VALUE_FROM_NUMBER
    ,       PRICING_ATTR_VALUE_TO_NUMBER
    ,       QUALIFICATION_IND
    FROM    QP_PRICING_ATTRIBUTES
    WHERE   LIST_LINE_ID = p_list_line_id;

Line: 1906

    SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
    FROM dual;

Line: 1930

        l_PRICING_ATTR_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1931

        l_PRICING_ATTR_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1932

        l_PRICING_ATTR_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1947

        l_PRICING_ATTR_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1963

SELECT list_line_type_code into l_list_line_type_code from QP_LIST_LINES where list_line_id=p_x_old_list_line_id;

Line: 1968

        SELECT continuous_price_break_flag INTO l_continuous_price_break_flag
        FROM QP_LIST_LINES
        WHERE list_line_id=p_x_old_list_line_id;

Line: 1974

        SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
        FROM dual;

Line: 2009

l_PRICE_LIST_LINE_rec.last_updated_by                  := l_implicit_rec.LAST_UPDATED_BY;

Line: 2010

l_PRICE_LIST_LINE_rec.last_update_date                 := l_implicit_rec.LAST_UPDATE_DATE;

Line: 2011

l_PRICE_LIST_LINE_rec.last_update_login                := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 2028

l_PRICE_LIST_LINE_rec.program_update_date              := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 2064

   SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id FROM dual;

Line: 2087

	        l_PRICING_ATTR_rec.last_updated_by 		:= l_implicit_attr_rec.LAST_UPDATED_BY;

Line: 2088

	        l_PRICING_ATTR_rec.last_update_date 		:= l_implicit_attr_rec.LAST_UPDATE_DATE;

Line: 2089

	        l_PRICING_ATTR_rec.last_update_login 		:= l_implicit_attr_rec.LAST_UPDATE_LOGIN;

Line: 2104

	        l_PRICING_ATTR_rec.program_update_date 		:= l_implicit_attr_rec.PROGRAM_UPDATE_DATE;