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_CURR_DETAILS_UTIL SQL Statements

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

Line: 190


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

Line: 193


            l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;

Line: 196


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

Line: 199


            l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;

Line: 202


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

Line: 205


            l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 244


        IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)
        THEN
            l_index := l_index + 1;

Line: 247


            l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 389


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

Line: 391


        l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;

Line: 392


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

Line: 394


        l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;

Line: 395


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

Line: 397


        l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 416


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

Line: 418


        l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 601


    IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,p_old_CURR_DETAILS_rec.last_updated_by)
    THEN
        NULL;

Line: 606


    IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,p_old_CURR_DETAILS_rec.last_update_date)
    THEN
        NULL;

Line: 611


    IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,p_old_CURR_DETAILS_rec.last_update_login)
    THEN
        NULL;

Line: 646


    IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)
    THEN
        NULL;

Line: 722


		update qp_pte_segments d set used_in_setup='Y'
		where nvl(used_in_setup,'N')='N' and
		exists
		(select 'x'
		from qp_segments_b a,qp_prc_contexts_b b
		where a.segment_mapping_column = p_CURR_DETAILS_rec.curr_attribute
		and   a.segment_id             = d.segment_id
		and   a.prc_context_id         = b.prc_context_id
		and   b.prc_context_type       = p_CURR_DETAILS_rec.curr_attribute_type
		and   b.prc_context_code       = p_CURR_DETAILS_rec.curr_attribute_context);

Line: 853


    IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_CURR_DETAILS_rec.last_updated_by := p_old_CURR_DETAILS_rec.last_updated_by;

Line: 857


    IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_CURR_DETAILS_rec.last_update_date := p_old_CURR_DETAILS_rec.last_update_date;

Line: 861


    IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_CURR_DETAILS_rec.last_update_login := p_old_CURR_DETAILS_rec.last_update_login;

Line: 889


    IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_CURR_DETAILS_rec.program_update_date := p_old_CURR_DETAILS_rec.program_update_date;

Line: 1052


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

Line: 1056


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

Line: 1060


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

Line: 1088


    IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_CURR_DETAILS_rec.program_update_date := NULL;

Line: 1138


PROCEDURE Update_Row
(   p_CURR_DETAILS_rec              IN  QP_Currency_PUB.Curr_Details_Rec_Type
)
IS
BEGIN

    UPDATE  QP_CURRENCY_DETAILS
    SET     ATTRIBUTE1                     = p_CURR_DETAILS_rec.attribute1
    ,       ATTRIBUTE10                    = p_CURR_DETAILS_rec.attribute10
    ,       ATTRIBUTE11                    = p_CURR_DETAILS_rec.attribute11
    ,       ATTRIBUTE12                    = p_CURR_DETAILS_rec.attribute12
    ,       ATTRIBUTE13                    = p_CURR_DETAILS_rec.attribute13
    ,       ATTRIBUTE14                    = p_CURR_DETAILS_rec.attribute14
    ,       ATTRIBUTE15                    = p_CURR_DETAILS_rec.attribute15
    ,       ATTRIBUTE2                     = p_CURR_DETAILS_rec.attribute2
    ,       ATTRIBUTE3                     = p_CURR_DETAILS_rec.attribute3
    ,       ATTRIBUTE4                     = p_CURR_DETAILS_rec.attribute4
    ,       ATTRIBUTE5                     = p_CURR_DETAILS_rec.attribute5
    ,       ATTRIBUTE6                     = p_CURR_DETAILS_rec.attribute6
    ,       ATTRIBUTE7                     = p_CURR_DETAILS_rec.attribute7
    ,       ATTRIBUTE8                     = p_CURR_DETAILS_rec.attribute8
    ,       ATTRIBUTE9                     = p_CURR_DETAILS_rec.attribute9
    ,       CONTEXT                        = p_CURR_DETAILS_rec.context
    ,       CONVERSION_DATE                = p_CURR_DETAILS_rec.conversion_date
    ,       CONVERSION_DATE_TYPE           = p_CURR_DETAILS_rec.conversion_date_type
    -- ,       CONVERSION_METHOD              = p_CURR_DETAILS_rec.conversion_method
    ,       CONVERSION_TYPE                = p_CURR_DETAILS_rec.conversion_type
    ,       CREATED_BY                     = p_CURR_DETAILS_rec.created_by
    ,       CREATION_DATE                  = p_CURR_DETAILS_rec.creation_date
    ,       CURRENCY_DETAIL_ID             = p_CURR_DETAILS_rec.currency_detail_id
    ,       CURRENCY_HEADER_ID             = p_CURR_DETAILS_rec.currency_header_id
    ,       END_DATE_ACTIVE                = p_CURR_DETAILS_rec.end_date_active
    ,       FIXED_VALUE                    = p_CURR_DETAILS_rec.fixed_value
    ,       LAST_UPDATED_BY                = p_CURR_DETAILS_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_CURR_DETAILS_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_CURR_DETAILS_rec.last_update_login
    ,       MARKUP_FORMULA_ID              = p_CURR_DETAILS_rec.markup_formula_id
    ,       MARKUP_OPERATOR                = p_CURR_DETAILS_rec.markup_operator
    ,       MARKUP_VALUE                   = p_CURR_DETAILS_rec.markup_value
    ,       PRICE_FORMULA_ID               = p_CURR_DETAILS_rec.price_formula_id
    ,       PROGRAM_APPLICATION_ID         = p_CURR_DETAILS_rec.program_application_id
    ,       PROGRAM_ID                     = p_CURR_DETAILS_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_CURR_DETAILS_rec.program_update_date
    ,       REQUEST_ID                     = p_CURR_DETAILS_rec.request_id
    ,       ROUNDING_FACTOR                = p_CURR_DETAILS_rec.rounding_factor
    ,       SELLING_ROUNDING_FACTOR        = p_CURR_DETAILS_rec.selling_rounding_factor
    ,       START_DATE_ACTIVE              = p_CURR_DETAILS_rec.start_date_active
    ,       TO_CURRENCY_CODE               = p_CURR_DETAILS_rec.to_currency_code
    ,       CURR_ATTRIBUTE_TYPE            = p_CURR_DETAILS_rec.curr_attribute_type
    ,       CURR_ATTRIBUTE_CONTEXT         = p_CURR_DETAILS_rec.curr_attribute_context
    ,       CURR_ATTRIBUTE                 = p_CURR_DETAILS_rec.curr_attribute
    ,       CURR_ATTRIBUTE_VALUE           = p_CURR_DETAILS_rec.curr_attribute_value
    ,       PRECEDENCE                     = p_CURR_DETAILS_rec.precedence
    WHERE   CURRENCY_DETAIL_ID = p_CURR_DETAILS_rec.currency_detail_id
    ;

Line: 1202


            ,   'Update_Row'
            );

Line: 1208


END Update_Row;

Line: 1212


PROCEDURE Insert_Row
(   p_CURR_DETAILS_rec              IN  QP_Currency_PUB.Curr_Details_Rec_Type
)
IS
BEGIN

    INSERT  INTO QP_CURRENCY_DETAILS
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CONVERSION_DATE
    ,       CONVERSION_DATE_TYPE
    -- ,       CONVERSION_METHOD
    ,       CONVERSION_TYPE
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_DETAIL_ID
    ,       CURRENCY_HEADER_ID
    ,       END_DATE_ACTIVE
    ,       FIXED_VALUE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       MARKUP_FORMULA_ID
    ,       MARKUP_OPERATOR
    ,       MARKUP_VALUE
    ,       PRICE_FORMULA_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SELLING_ROUNDING_FACTOR
    ,       START_DATE_ACTIVE
    ,       TO_CURRENCY_CODE
    ,       CURR_ATTRIBUTE_TYPE
    ,       CURR_ATTRIBUTE_CONTEXT
    ,       CURR_ATTRIBUTE
    ,       CURR_ATTRIBUTE_VALUE
    ,       PRECEDENCE
    )
    VALUES
    (       p_CURR_DETAILS_rec.attribute1
    ,       p_CURR_DETAILS_rec.attribute10
    ,       p_CURR_DETAILS_rec.attribute11
    ,       p_CURR_DETAILS_rec.attribute12
    ,       p_CURR_DETAILS_rec.attribute13
    ,       p_CURR_DETAILS_rec.attribute14
    ,       p_CURR_DETAILS_rec.attribute15
    ,       p_CURR_DETAILS_rec.attribute2
    ,       p_CURR_DETAILS_rec.attribute3
    ,       p_CURR_DETAILS_rec.attribute4
    ,       p_CURR_DETAILS_rec.attribute5
    ,       p_CURR_DETAILS_rec.attribute6
    ,       p_CURR_DETAILS_rec.attribute7
    ,       p_CURR_DETAILS_rec.attribute8
    ,       p_CURR_DETAILS_rec.attribute9
    ,       p_CURR_DETAILS_rec.context
    ,       p_CURR_DETAILS_rec.conversion_date
    ,       p_CURR_DETAILS_rec.conversion_date_type
    -- ,       p_CURR_DETAILS_rec.conversion_method
    ,       p_CURR_DETAILS_rec.conversion_type
    ,       p_CURR_DETAILS_rec.created_by
    ,       p_CURR_DETAILS_rec.creation_date
    ,       p_CURR_DETAILS_rec.currency_detail_id
    ,       p_CURR_DETAILS_rec.currency_header_id
    ,       p_CURR_DETAILS_rec.end_date_active
    ,       p_CURR_DETAILS_rec.fixed_value
    ,       p_CURR_DETAILS_rec.last_updated_by
    ,       p_CURR_DETAILS_rec.last_update_date
    ,       p_CURR_DETAILS_rec.last_update_login
    ,       p_CURR_DETAILS_rec.markup_formula_id
    ,       p_CURR_DETAILS_rec.markup_operator
    ,       p_CURR_DETAILS_rec.markup_value
    ,       p_CURR_DETAILS_rec.price_formula_id
    ,       p_CURR_DETAILS_rec.program_application_id
    ,       p_CURR_DETAILS_rec.program_id
    ,       p_CURR_DETAILS_rec.program_update_date
    ,       p_CURR_DETAILS_rec.request_id
    ,       p_CURR_DETAILS_rec.rounding_factor
    ,       p_CURR_DETAILS_rec.selling_rounding_factor
    ,       p_CURR_DETAILS_rec.start_date_active
    ,       p_CURR_DETAILS_rec.to_currency_code
    ,       p_CURR_DETAILS_rec.curr_attribute_type
    ,       p_CURR_DETAILS_rec.curr_attribute_context
    ,       p_CURR_DETAILS_rec.curr_attribute
    ,       p_CURR_DETAILS_rec.curr_attribute_value
    ,       p_CURR_DETAILS_rec.precedence
    );

Line: 1323


            ,   'Insert_Row'
            );

Line: 1329


END Insert_Row;

Line: 1333


PROCEDURE Delete_Row
(   p_currency_detail_id            IN  NUMBER
)
IS
BEGIN

    DELETE  FROM QP_CURRENCY_DETAILS
    WHERE   CURRENCY_DETAIL_ID = p_currency_detail_id
    ;

Line: 1351


            ,   'Delete_Row'
            );

Line: 1357


END Delete_Row;

Line: 1388


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CONVERSION_DATE
    ,       CONVERSION_DATE_TYPE
    -- ,       CONVERSION_METHOD
    ,       CONVERSION_TYPE
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_DETAIL_ID
    ,       CURRENCY_HEADER_ID
    ,       END_DATE_ACTIVE
    ,       FIXED_VALUE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       MARKUP_FORMULA_ID
    ,       MARKUP_OPERATOR
    ,       MARKUP_VALUE
    ,       PRICE_FORMULA_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SELLING_ROUNDING_FACTOR
    ,       START_DATE_ACTIVE
    ,       TO_CURRENCY_CODE
    ,       CURR_ATTRIBUTE_TYPE
    ,       CURR_ATTRIBUTE_CONTEXT
    ,       CURR_ATTRIBUTE
    ,       CURR_ATTRIBUTE_VALUE
    ,       PRECEDENCE
    FROM    QP_CURRENCY_DETAILS
    WHERE ( CURRENCY_DETAIL_ID = p_currency_detail_id
    )
    OR (    CURRENCY_HEADER_ID = p_currency_header_id
    );

Line: 1495


        l_CURR_DETAILS_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1496


        l_CURR_DETAILS_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1497


        l_CURR_DETAILS_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1504


        l_CURR_DETAILS_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1570


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CONVERSION_DATE
    ,       CONVERSION_DATE_TYPE
    -- ,       CONVERSION_METHOD
    ,       CONVERSION_TYPE
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_DETAIL_ID
    ,       CURRENCY_HEADER_ID
    ,       END_DATE_ACTIVE
    ,       FIXED_VALUE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       MARKUP_FORMULA_ID
    ,       MARKUP_OPERATOR
    ,       MARKUP_VALUE
    ,       PRICE_FORMULA_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SELLING_ROUNDING_FACTOR
    ,       START_DATE_ACTIVE
    ,       TO_CURRENCY_CODE
    ,       CURR_ATTRIBUTE_TYPE
    ,       CURR_ATTRIBUTE_CONTEXT
    ,       CURR_ATTRIBUTE
    ,       CURR_ATTRIBUTE_VALUE
    ,       PRECEDENCE
    INTO    l_CURR_DETAILS_rec.attribute1
    ,       l_CURR_DETAILS_rec.attribute10
    ,       l_CURR_DETAILS_rec.attribute11
    ,       l_CURR_DETAILS_rec.attribute12
    ,       l_CURR_DETAILS_rec.attribute13
    ,       l_CURR_DETAILS_rec.attribute14
    ,       l_CURR_DETAILS_rec.attribute15
    ,       l_CURR_DETAILS_rec.attribute2
    ,       l_CURR_DETAILS_rec.attribute3
    ,       l_CURR_DETAILS_rec.attribute4
    ,       l_CURR_DETAILS_rec.attribute5
    ,       l_CURR_DETAILS_rec.attribute6
    ,       l_CURR_DETAILS_rec.attribute7
    ,       l_CURR_DETAILS_rec.attribute8
    ,       l_CURR_DETAILS_rec.attribute9
    ,       l_CURR_DETAILS_rec.context
    ,       l_CURR_DETAILS_rec.conversion_date
    ,       l_CURR_DETAILS_rec.conversion_date_type
    -- ,       l_CURR_DETAILS_rec.conversion_method
    ,       l_CURR_DETAILS_rec.conversion_type
    ,       l_CURR_DETAILS_rec.created_by
    ,       l_CURR_DETAILS_rec.creation_date
    ,       l_CURR_DETAILS_rec.currency_detail_id
    ,       l_CURR_DETAILS_rec.currency_header_id
    ,       l_CURR_DETAILS_rec.end_date_active
    ,       l_CURR_DETAILS_rec.fixed_value
    ,       l_CURR_DETAILS_rec.last_updated_by
    ,       l_CURR_DETAILS_rec.last_update_date
    ,       l_CURR_DETAILS_rec.last_update_login
    ,       l_CURR_DETAILS_rec.markup_formula_id
    ,       l_CURR_DETAILS_rec.markup_operator
    ,       l_CURR_DETAILS_rec.markup_value
    ,       l_CURR_DETAILS_rec.price_formula_id
    ,       l_CURR_DETAILS_rec.program_application_id
    ,       l_CURR_DETAILS_rec.program_id
    ,       l_CURR_DETAILS_rec.program_update_date
    ,       l_CURR_DETAILS_rec.request_id
    ,       l_CURR_DETAILS_rec.rounding_factor
    ,       l_CURR_DETAILS_rec.selling_rounding_factor
    ,       l_CURR_DETAILS_rec.start_date_active
    ,       l_CURR_DETAILS_rec.to_currency_code
    ,       l_CURR_DETAILS_rec.curr_attribute_type
    ,       l_CURR_DETAILS_rec.curr_attribute_context
    ,       l_CURR_DETAILS_rec.curr_attribute
    ,       l_CURR_DETAILS_rec.curr_attribute_value
    ,       l_CURR_DETAILS_rec.precedence
    FROM    QP_CURRENCY_DETAILS
    WHERE   CURRENCY_DETAIL_ID = p_CURR_DETAILS_rec.currency_detail_id
        FOR UPDATE NOWAIT;

Line: 1720


    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
                         l_CURR_DETAILS_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
                         l_CURR_DETAILS_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
                         l_CURR_DETAILS_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
                         l_CURR_DETAILS_rec.markup_formula_id)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
                         l_CURR_DETAILS_rec.markup_operator)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
                         l_CURR_DETAILS_rec.markup_value)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
                         l_CURR_DETAILS_rec.price_formula_id)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
                         l_CURR_DETAILS_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
                         l_CURR_DETAILS_rec.program_id)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
                         l_CURR_DETAILS_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
                         l_CURR_DETAILS_rec.request_id)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
                         l_CURR_DETAILS_rec.rounding_factor)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
                         l_CURR_DETAILS_rec.selling_rounding_factor)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
                         l_CURR_DETAILS_rec.start_date_active)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
                         l_CURR_DETAILS_rec.to_currency_code)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
                         l_CURR_DETAILS_rec.curr_attribute_type)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
                         l_CURR_DETAILS_rec.curr_attribute_context)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
                         l_CURR_DETAILS_rec.curr_attribute)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,
                         l_CURR_DETAILS_rec.curr_attribute_value)
    AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,
                         l_CURR_DETAILS_rec.precedence)
    THEN

        --  Row has not changed. Set out parameter.

        x_CURR_DETAILS_rec             := l_CURR_DETAILS_rec;

Line: 1798


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