eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_FORMULA_LINES_UTIL SQL Statements

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

Line: 147


        IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,p_old_FORMULA_LINES_rec.last_updated_by)
        THEN
            l_index := l_index + 1;

Line: 150


            l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATED_BY;

Line: 153


        IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,p_old_FORMULA_LINES_rec.last_update_date)
        THEN
            l_index := l_index + 1;

Line: 156


            l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATE_DATE;

Line: 159


        IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,p_old_FORMULA_LINES_rec.last_update_login)
        THEN
            l_index := l_index + 1;

Line: 162


            l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATE_LOGIN;

Line: 288


    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        l_index := l_index + 1;

Line: 290


        l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATED_BY;

Line: 291


    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        l_index := l_index + 1;

Line: 293


        l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATE_DATE;

Line: 294


    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        l_index := l_index + 1;

Line: 296


        l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATE_LOGIN;

Line: 446


    IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,p_old_FORMULA_LINES_rec.last_updated_by)
    THEN
        NULL;

Line: 451


    IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,p_old_FORMULA_LINES_rec.last_update_date)
    THEN
        NULL;

Line: 456


    IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,p_old_FORMULA_LINES_rec.last_update_login)
    THEN
        NULL;

Line: 606


    IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_FORMULA_LINES_rec.last_updated_by := p_old_FORMULA_LINES_rec.last_updated_by;

Line: 610


    IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_FORMULA_LINES_rec.last_update_date := p_old_FORMULA_LINES_rec.last_update_date;

Line: 614


    IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_FORMULA_LINES_rec.last_update_login := p_old_FORMULA_LINES_rec.last_update_login;

Line: 753


    IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_FORMULA_LINES_rec.last_updated_by := NULL;

Line: 757


    IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_FORMULA_LINES_rec.last_update_date := NULL;

Line: 761


    IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_FORMULA_LINES_rec.last_update_login := NULL;

Line: 816


PROCEDURE Update_Row
(   p_FORMULA_LINES_rec             IN  QP_Price_Formula_PUB.Formula_Lines_Rec_Type
)
IS
BEGIN

oe_debug_pub.add('Entering proc Update_Row in FormulaLines Util Pkg');

Line: 823


    UPDATE  QP_PRICE_FORMULA_LINES
    SET     ATTRIBUTE1                     = p_FORMULA_LINES_rec.attribute1
    ,       ATTRIBUTE10                    = p_FORMULA_LINES_rec.attribute10
    ,       ATTRIBUTE11                    = p_FORMULA_LINES_rec.attribute11
    ,       ATTRIBUTE12                    = p_FORMULA_LINES_rec.attribute12
    ,       ATTRIBUTE13                    = p_FORMULA_LINES_rec.attribute13
    ,       ATTRIBUTE14                    = p_FORMULA_LINES_rec.attribute14
    ,       ATTRIBUTE15                    = p_FORMULA_LINES_rec.attribute15
    ,       ATTRIBUTE2                     = p_FORMULA_LINES_rec.attribute2
    ,       ATTRIBUTE3                     = p_FORMULA_LINES_rec.attribute3
    ,       ATTRIBUTE4                     = p_FORMULA_LINES_rec.attribute4
    ,       ATTRIBUTE5                     = p_FORMULA_LINES_rec.attribute5
    ,       ATTRIBUTE6                     = p_FORMULA_LINES_rec.attribute6
    ,       ATTRIBUTE7                     = p_FORMULA_LINES_rec.attribute7
    ,       ATTRIBUTE8                     = p_FORMULA_LINES_rec.attribute8
    ,       ATTRIBUTE9                     = p_FORMULA_LINES_rec.attribute9
    ,       CONTEXT                        = p_FORMULA_LINES_rec.context
    ,       CREATED_BY                     = p_FORMULA_LINES_rec.created_by
    ,       CREATION_DATE                  = p_FORMULA_LINES_rec.creation_date
    ,       END_DATE_ACTIVE                = p_FORMULA_LINES_rec.end_date_active
    ,       LAST_UPDATED_BY                = p_FORMULA_LINES_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_FORMULA_LINES_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_FORMULA_LINES_rec.last_update_login
    ,       NUMERIC_CONSTANT               = p_FORMULA_LINES_rec.numeric_constant
    ,       PRICE_FORMULA_ID               = p_FORMULA_LINES_rec.price_formula_id
    ,       PRICE_FORMULA_LINE_ID          = p_FORMULA_LINES_rec.price_formula_line_id
    ,       PRICE_FORMULA_LINE_TYPE_CODE   = p_FORMULA_LINES_rec.formula_line_type_code
    ,       PRICE_LIST_LINE_ID             = p_FORMULA_LINES_rec.price_list_line_id
    ,       PRICE_MODIFIER_LIST_ID         = p_FORMULA_LINES_rec.price_modifier_list_id
    ,       PRICING_ATTRIBUTE              = p_FORMULA_LINES_rec.pricing_attribute
    ,       PRICING_ATTRIBUTE_CONTEXT      = p_FORMULA_LINES_rec.pricing_attribute_context
    ,       START_DATE_ACTIVE              = p_FORMULA_LINES_rec.start_date_active
    ,       STEP_NUMBER                    = p_FORMULA_LINES_rec.step_number
    ,       REQD_FLAG                      = p_FORMULA_LINES_rec.reqd_flag
    WHERE   PRICE_FORMULA_LINE_ID = p_FORMULA_LINES_rec.price_formula_line_id
    ;

Line: 860


oe_debug_pub.add('Leaving proc Update_Row in FormulaLines Util Pkg');

Line: 864


   UPDATE qp_pte_segments SET used_in_setup='Y'
   WHERE  nvl(used_in_setup,'N')='N'
   AND    segment_id IN
   (SELECT a.segment_id
    FROM  qp_segments_b a,qp_prc_contexts_b b
    WHERE a.segment_mapping_column=p_FORMULA_LINES_rec.pricing_attribute
    AND   a.prc_context_id=b.prc_context_id
    AND   b.prc_context_code=p_FORMULA_LINES_rec.pricing_attribute_context);

Line: 881


            ,   'Update_Row'
            );

Line: 887


END Update_Row;

Line: 891


PROCEDURE Insert_Row
(   p_FORMULA_LINES_rec             IN  QP_Price_Formula_PUB.Formula_Lines_Rec_Type
)
IS
BEGIN

oe_debug_pub.add('Entering proc Insert_Row in FormulaLines Util Pkg');

Line: 898


    INSERT  INTO QP_PRICE_FORMULA_LINES
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       END_DATE_ACTIVE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NUMERIC_CONSTANT
    ,       PRICE_FORMULA_ID
    ,       PRICE_FORMULA_LINE_ID
    ,       PRICE_FORMULA_LINE_TYPE_CODE
    ,       PRICE_LIST_LINE_ID
    ,       PRICE_MODIFIER_LIST_ID
    ,       PRICING_ATTRIBUTE
    ,       PRICING_ATTRIBUTE_CONTEXT
    ,       START_DATE_ACTIVE
    ,       STEP_NUMBER
    ,       REQD_FLAG
    )
    VALUES
    (       p_FORMULA_LINES_rec.attribute1
    ,       p_FORMULA_LINES_rec.attribute10
    ,       p_FORMULA_LINES_rec.attribute11
    ,       p_FORMULA_LINES_rec.attribute12
    ,       p_FORMULA_LINES_rec.attribute13
    ,       p_FORMULA_LINES_rec.attribute14
    ,       p_FORMULA_LINES_rec.attribute15
    ,       p_FORMULA_LINES_rec.attribute2
    ,       p_FORMULA_LINES_rec.attribute3
    ,       p_FORMULA_LINES_rec.attribute4
    ,       p_FORMULA_LINES_rec.attribute5
    ,       p_FORMULA_LINES_rec.attribute6
    ,       p_FORMULA_LINES_rec.attribute7
    ,       p_FORMULA_LINES_rec.attribute8
    ,       p_FORMULA_LINES_rec.attribute9
    ,       p_FORMULA_LINES_rec.context
    ,       p_FORMULA_LINES_rec.created_by
    ,       p_FORMULA_LINES_rec.creation_date
    ,       p_FORMULA_LINES_rec.end_date_active
    ,       p_FORMULA_LINES_rec.last_updated_by
    ,       p_FORMULA_LINES_rec.last_update_date
    ,       p_FORMULA_LINES_rec.last_update_login
    ,       p_FORMULA_LINES_rec.numeric_constant
    ,       p_FORMULA_LINES_rec.price_formula_id
    ,       p_FORMULA_LINES_rec.price_formula_line_id
    ,       p_FORMULA_LINES_rec.formula_line_type_code
    ,       p_FORMULA_LINES_rec.price_list_line_id
    ,       p_FORMULA_LINES_rec.price_modifier_list_id
    ,       p_FORMULA_LINES_rec.pricing_attribute
    ,       p_FORMULA_LINES_rec.pricing_attribute_context
    ,       p_FORMULA_LINES_rec.start_date_active
    ,       p_FORMULA_LINES_rec.step_number
    ,       p_FORMULA_LINES_rec.reqd_flag
    );

Line: 969


oe_debug_pub.add('Leaving proc Insert_Row in FormulaLines Util Pkg');

Line: 973


   UPDATE qp_pte_segments SET used_in_setup='Y'
   WHERE  nvl(used_in_setup,'N')='N'
   AND    segment_id IN
   (SELECT a.segment_id
    FROM  qp_segments_b a,qp_prc_contexts_b b
    WHERE a.segment_mapping_column=p_FORMULA_LINES_rec.pricing_attribute
    AND   a.prc_context_id=b.prc_context_id
    AND   b.prc_context_code=p_FORMULA_LINES_rec.pricing_attribute_context);

Line: 991


            ,   'Insert_Row'
            );

Line: 997


END Insert_Row;

Line: 1001


PROCEDURE Delete_Row
(   p_price_formula_line_id         IN  NUMBER
)
IS
BEGIN

oe_debug_pub.add('Entering proc Delete_Row in FormulaLines Util Pkg');

Line: 1008


    DELETE  FROM QP_PRICE_FORMULA_LINES
    WHERE   PRICE_FORMULA_LINE_ID = p_price_formula_line_id
    ;

Line: 1012


oe_debug_pub.add('Leaving proc Delete_Row in FormulaLines Util Pkg');

Line: 1023


            ,   'Delete_Row'
            );

Line: 1029


END Delete_Row;

Line: 1061


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       END_DATE_ACTIVE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NUMERIC_CONSTANT
    ,       PRICE_FORMULA_ID
    ,       PRICE_FORMULA_LINE_ID
    ,       PRICE_FORMULA_LINE_TYPE_CODE
    ,       PRICE_LIST_LINE_ID
    ,       PRICE_MODIFIER_LIST_ID
    ,       PRICING_ATTRIBUTE
    ,       PRICING_ATTRIBUTE_CONTEXT
    ,       START_DATE_ACTIVE
    ,       STEP_NUMBER
    ,       REQD_FLAG
    FROM    QP_PRICE_FORMULA_LINES
    WHERE ( PRICE_FORMULA_LINE_ID = p_price_formula_line_id
    )
    OR (    PRICE_FORMULA_ID = p_price_formula_id
    );

Line: 1149


        l_FORMULA_LINES_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1150


        l_FORMULA_LINES_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1151


        l_FORMULA_LINES_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1220


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       END_DATE_ACTIVE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NUMERIC_CONSTANT
    ,       PRICE_FORMULA_ID
    ,       PRICE_FORMULA_LINE_ID
    ,       PRICE_FORMULA_LINE_TYPE_CODE
    ,       PRICE_LIST_LINE_ID
    ,       PRICE_MODIFIER_LIST_ID
    ,       PRICING_ATTRIBUTE
    ,       PRICING_ATTRIBUTE_CONTEXT
    ,       START_DATE_ACTIVE
    ,       STEP_NUMBER
    ,       REQD_FLAG
    INTO    l_FORMULA_LINES_rec.attribute1
    ,       l_FORMULA_LINES_rec.attribute10
    ,       l_FORMULA_LINES_rec.attribute11
    ,       l_FORMULA_LINES_rec.attribute12
    ,       l_FORMULA_LINES_rec.attribute13
    ,       l_FORMULA_LINES_rec.attribute14
    ,       l_FORMULA_LINES_rec.attribute15
    ,       l_FORMULA_LINES_rec.attribute2
    ,       l_FORMULA_LINES_rec.attribute3
    ,       l_FORMULA_LINES_rec.attribute4
    ,       l_FORMULA_LINES_rec.attribute5
    ,       l_FORMULA_LINES_rec.attribute6
    ,       l_FORMULA_LINES_rec.attribute7
    ,       l_FORMULA_LINES_rec.attribute8
    ,       l_FORMULA_LINES_rec.attribute9
    ,       l_FORMULA_LINES_rec.context
    ,       l_FORMULA_LINES_rec.created_by
    ,       l_FORMULA_LINES_rec.creation_date
    ,       l_FORMULA_LINES_rec.end_date_active
    ,       l_FORMULA_LINES_rec.last_updated_by
    ,       l_FORMULA_LINES_rec.last_update_date
    ,       l_FORMULA_LINES_rec.last_update_login
    ,       l_FORMULA_LINES_rec.numeric_constant
    ,       l_FORMULA_LINES_rec.price_formula_id
    ,       l_FORMULA_LINES_rec.price_formula_line_id
    ,       l_FORMULA_LINES_rec.formula_line_type_code
    ,       l_FORMULA_LINES_rec.price_list_line_id
    ,       l_FORMULA_LINES_rec.price_modifier_list_id
    ,       l_FORMULA_LINES_rec.pricing_attribute
    ,       l_FORMULA_LINES_rec.pricing_attribute_context
    ,       l_FORMULA_LINES_rec.start_date_active
    ,       l_FORMULA_LINES_rec.step_number
    ,       l_FORMULA_LINES_rec.reqd_flag
    FROM    QP_PRICE_FORMULA_LINES
    WHERE   PRICE_FORMULA_LINE_ID = p_FORMULA_LINES_rec.price_formula_line_id
        FOR UPDATE NOWAIT;

Line: 1330


    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,
                         l_FORMULA_LINES_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,
                         l_FORMULA_LINES_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,
                         l_FORMULA_LINES_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,
                         l_FORMULA_LINES_rec.numeric_constant)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,
                         l_FORMULA_LINES_rec.price_formula_id)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,
                         l_FORMULA_LINES_rec.price_formula_line_id)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,
                         l_FORMULA_LINES_rec.formula_line_type_code)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,
                         l_FORMULA_LINES_rec.price_list_line_id)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,
                         l_FORMULA_LINES_rec.price_modifier_list_id)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,
                         l_FORMULA_LINES_rec.pricing_attribute)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,
                         l_FORMULA_LINES_rec.pricing_attribute_context)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,
                         l_FORMULA_LINES_rec.start_date_active)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,
                         l_FORMULA_LINES_rec.step_number)
    AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,
                         l_FORMULA_LINES_rec.reqd_flag)
    THEN

        --  Row has not changed. Set out parameter.

        x_FORMULA_LINES_rec            := l_FORMULA_LINES_rec;

Line: 1397


            FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');