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

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

Line: 158


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

Line: 161


            l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATED_BY;

Line: 164


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

Line: 167


            l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATE_DATE;

Line: 170


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

Line: 173


            l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 194


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

Line: 197


            l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 304


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

Line: 306


        l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATED_BY;

Line: 307


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

Line: 309


        l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATE_DATE;

Line: 310


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

Line: 312


        l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 322


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

Line: 324


        l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 448


	   Select 'X'
	   Into l_dummy_c
	   From QP_LIST_HEADERS_B
	   Where currency_header_id = p_old_CURR_LISTS_rec.currency_header_id;

Line: 461


		-- Update details record's to_currency_code with new base_currency_code
	        Update QP_CURRENCY_DETAILS
	        Set to_currency_code = p_CURR_LISTS_rec.base_currency_code
	        Where to_currency_code = p_old_CURR_LISTS_rec.base_currency_code
	        And   currency_header_id = p_old_CURR_LISTS_rec.currency_header_id;

Line: 467


		-- Delete detail record having to_currecny = new.base_currency and conversion_type<>NULL
		Delete from QP_CURRENCY_DETAILS
		Where to_currency_code = p_CURR_LISTS_rec.base_currency_code
		And   currency_header_id = p_old_CURR_LISTS_rec.currency_header_id
		-- And   conversion_method is NOT NULL;

Line: 525


        update qp_list_headers_b
           set rounding_factor = p_CURR_LISTS_rec.base_rounding_factor
          where currency_header_id = p_CURR_LISTS_rec.currency_header_id;

Line: 546


    IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,p_old_CURR_LISTS_rec.last_updated_by)
    THEN
        NULL;

Line: 551


    IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,p_old_CURR_LISTS_rec.last_update_date)
    THEN
        NULL;

Line: 556


    IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,p_old_CURR_LISTS_rec.last_update_login)
    THEN
        NULL;

Line: 576


    IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,p_old_CURR_LISTS_rec.program_update_date)
    THEN
        NULL;

Line: 707


    IF l_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_CURR_LISTS_rec.last_updated_by := p_old_CURR_LISTS_rec.last_updated_by;

Line: 711


    IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_CURR_LISTS_rec.last_update_date := p_old_CURR_LISTS_rec.last_update_date;

Line: 715


    IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_CURR_LISTS_rec.last_update_login := p_old_CURR_LISTS_rec.last_update_login;

Line: 731


    IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_CURR_LISTS_rec.program_update_date := p_old_CURR_LISTS_rec.program_update_date;

Line: 842


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

Line: 846


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

Line: 850


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

Line: 866


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

Line: 904


PROCEDURE Update_Row
(   p_CURR_LISTS_rec                IN  QP_Currency_PUB.Curr_Lists_Rec_Type
)
IS
BEGIN

    -- oe_debug_pub.add('UPDATE_ROW of Header');

Line: 921


    UPDATE  QP_CURRENCY_LISTS_B
    SET     ATTRIBUTE1                     = p_CURR_LISTS_rec.attribute1
    ,       ATTRIBUTE10                    = p_CURR_LISTS_rec.attribute10
    ,       ATTRIBUTE11                    = p_CURR_LISTS_rec.attribute11
    ,       ATTRIBUTE12                    = p_CURR_LISTS_rec.attribute12
    ,       ATTRIBUTE13                    = p_CURR_LISTS_rec.attribute13
    ,       ATTRIBUTE14                    = p_CURR_LISTS_rec.attribute14
    ,       ATTRIBUTE15                    = p_CURR_LISTS_rec.attribute15
    ,       ATTRIBUTE2                     = p_CURR_LISTS_rec.attribute2
    ,       ATTRIBUTE3                     = p_CURR_LISTS_rec.attribute3
    ,       ATTRIBUTE4                     = p_CURR_LISTS_rec.attribute4
    ,       ATTRIBUTE5                     = p_CURR_LISTS_rec.attribute5
    ,       ATTRIBUTE6                     = p_CURR_LISTS_rec.attribute6
    ,       ATTRIBUTE7                     = p_CURR_LISTS_rec.attribute7
    ,       ATTRIBUTE8                     = p_CURR_LISTS_rec.attribute8
    ,       ATTRIBUTE9                     = p_CURR_LISTS_rec.attribute9
    ,       BASE_CURRENCY_CODE             = p_CURR_LISTS_rec.base_currency_code
    ,       CONTEXT                        = p_CURR_LISTS_rec.context
    ,       CREATED_BY                     = p_CURR_LISTS_rec.created_by
    ,       CREATION_DATE                  = p_CURR_LISTS_rec.creation_date
    ,       CURRENCY_HEADER_ID             = p_CURR_LISTS_rec.currency_header_id
    ,       LAST_UPDATED_BY                = p_CURR_LISTS_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_CURR_LISTS_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_CURR_LISTS_rec.last_update_login
    ,       PROGRAM_APPLICATION_ID         = p_CURR_LISTS_rec.program_application_id
    ,       PROGRAM_ID                     = p_CURR_LISTS_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_CURR_LISTS_rec.program_update_date
    ,       REQUEST_ID                     = p_CURR_LISTS_rec.request_id
    WHERE   CURRENCY_HEADER_ID = p_CURR_LISTS_rec.currency_header_id
    ;

Line: 955


    update QP_CURRENCY_LISTS_TL set
      NAME                   = p_CURR_LISTS_rec.NAME
    , DESCRIPTION            = p_CURR_LISTS_rec.DESCRIPTION
    , LAST_UPDATE_DATE       = p_CURR_LISTS_rec.LAST_UPDATE_DATE
    , LAST_UPDATED_BY        = p_CURR_LISTS_rec.LAST_UPDATED_BY
    , LAST_UPDATE_LOGIN      = p_CURR_LISTS_rec.LAST_UPDATE_LOGIN
    , SOURCE_LANG            = userenv('LANG')
    where CURRENCY_HEADER_ID = p_CURR_LISTS_rec.CURRENCY_HEADER_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 968


    update QP_CURRENCY_DETAILS set
      selling_rounding_factor        = p_CURR_LISTS_rec.base_rounding_factor
    , markup_operator        = p_CURR_LISTS_rec.base_markup_operator
    , markup_value           = p_CURR_LISTS_rec.base_markup_value
    , markup_formula_id      = p_CURR_LISTS_rec.base_markup_formula_id
    , LAST_UPDATE_DATE       = p_CURR_LISTS_rec.LAST_UPDATE_DATE
    , LAST_UPDATED_BY        = p_CURR_LISTS_rec.LAST_UPDATED_BY
    , LAST_UPDATE_LOGIN      = p_CURR_LISTS_rec.last_update_login
    where CURRENCY_HEADER_ID = p_CURR_LISTS_rec.CURRENCY_HEADER_ID
    and   TO_CURRENCY_CODE   = p_CURR_LISTS_rec.BASE_CURRENCY_CODE;

Line: 990


            ,   'Update_Row'
            );

Line: 996


END Update_Row;

Line: 1000


PROCEDURE Insert_Row
(   p_CURR_LISTS_rec                IN  QP_Currency_PUB.Curr_Lists_Rec_Type
)
IS
BEGIN
    -- oe_debug_pub.add('INSERT_ROW of Header');

Line: 1017


    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
    ,       SELLING_ROUNDING_FACTOR
    ,       START_DATE_ACTIVE
    ,       TO_CURRENCY_CODE
    ,       CURR_ATTRIBUTE_TYPE
    ,       CURR_ATTRIBUTE_CONTEXT
    ,       CURR_ATTRIBUTE
    ,       CURR_ATTRIBUTE_VALUE
    ,       PRECEDENCE
    )
    VALUES
    (       NULL         -- p_CURR_DETAILS_rec.attribute1
    ,       NULL         -- p_CURR_DETAILS_rec.attribute10
    ,       NULL         -- p_CURR_DETAILS_rec.attribute11
    ,       NULL         -- p_CURR_DETAILS_rec.attribute12
    ,       NULL         -- p_CURR_DETAILS_rec.attribute13
    ,       NULL         -- p_CURR_DETAILS_rec.attribute14
    ,       NULL         -- p_CURR_DETAILS_rec.attribute15
    ,       NULL         -- p_CURR_DETAILS_rec.attribute2
    ,       NULL         -- p_CURR_DETAILS_rec.attribute3
    ,       NULL         -- p_CURR_DETAILS_rec.attribute4
    ,       NULL         -- p_CURR_DETAILS_rec.attribute5
    ,       NULL         -- p_CURR_DETAILS_rec.attribute6
    ,       NULL         -- p_CURR_DETAILS_rec.attribute7
    ,       NULL         -- p_CURR_DETAILS_rec.attribute8
    ,       NULL         -- p_CURR_DETAILS_rec.attribute9
    ,       NULL         -- p_CURR_DETAILS_rec.context
    ,       NULL         -- p_CURR_DETAILS_rec.conversion_date
    ,       NULL         -- p_CURR_DETAILS_rec.conversion_date_type
    -- ,       NULL         -- p_CURR_DETAILS_rec.conversion_method
    ,       NULL         -- p_CURR_DETAILS_rec.conversion_type
    ,       p_CURR_LISTS_rec.created_by
    ,       p_CURR_LISTS_rec.creation_date
    ,       QP_CURRENCY_DETAILS_S.nextval
    ,       p_CURR_LISTS_rec.currency_header_id
    ,       NULL          -- p_CURR_DETAILS_rec.end_date_active
    ,       NULL          -- p_CURR_DETAILS_rec.fixed_value
    ,       p_CURR_LISTS_rec.last_updated_by
    ,       p_CURR_LISTS_rec.last_update_date
    ,       p_CURR_LISTS_rec.last_update_login
    ,       p_CURR_LISTS_rec.base_markup_formula_id
    ,       p_CURR_LISTS_rec.base_markup_operator
    ,       p_CURR_LISTS_rec.base_markup_value
    ,       NULL          -- p_CURR_DETAILS_rec.price_formula_id
    ,       NULL          -- p_CURR_DETAILS_rec.program_application_id
    ,       NULL          -- p_CURR_DETAILS_rec.program_id
    ,       NULL          -- p_CURR_DETAILS_rec.program_update_date
    ,       NULL          -- p_CURR_DETAILS_rec.request_id
    ,       p_CURR_LISTS_rec.base_rounding_factor
    ,       NULL          -- p_CURR_DETAILS_rec.start_date_active
    ,       p_CURR_LISTS_rec.base_currency_code
    ,       NULL          -- p_CURR_DETAILS_rec.curr_attribute_type
    ,       NULL          -- p_CURR_DETAILS_rec.curr_attribute_context
    ,       NULL          -- p_CURR_DETAILS_rec.curr_attribute
    ,       NULL          -- p_CURR_DETAILS_rec.curr_attribute_value
    ,       NULL          -- p_CURR_DETAILS_rec.precedence
    );

Line: 1120


            ,   'Insert_Row'
            );

Line: 1130


    Insert into QP_CURRENCY_LISTS_TL
    ( CURRENCY_HEADER_ID
    , NAME
    , DESCRIPTION
    , CREATION_DATE
    , CREATED_BY
    , LAST_UPDATE_DATE
    , LAST_UPDATED_BY
    , LAST_UPDATE_LOGIN
    , LANGUAGE
    , SOURCE_LANG
    ) select
      p_CURR_LISTS_rec.CURRENCY_HEADER_ID
    , p_CURR_LISTS_rec.NAME
    , p_CURR_LISTS_rec.DESCRIPTION
    , p_CURR_LISTS_rec.CREATION_DATE
    , p_CURR_LISTS_rec.CREATED_BY
    , p_CURR_LISTS_rec.LAST_UPDATE_DATE
    , p_CURR_LISTS_rec.LAST_UPDATED_BY
    , p_CURR_LISTS_rec.LAST_UPDATE_LOGIN
    , L.LANGUAGE_CODE
    , userenv('LANG')
    from FND_LANGUAGES L
    where L.INSTALLED_FLAG in ('I','B')
    and not exists
    (select NULL from QP_CURRENCY_LISTS_TL T
    where T.CURRENCY_HEADER_ID = p_CURR_LISTS_rec.CURRENCY_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 1172


            ,   'Insert_Row'
            );

Line: 1180


    INSERT  INTO QP_CURRENCY_LISTS_B
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       BASE_CURRENCY_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_HEADER_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    )
    VALUES
    (       p_CURR_LISTS_rec.attribute1
    ,       p_CURR_LISTS_rec.attribute10
    ,       p_CURR_LISTS_rec.attribute11
    ,       p_CURR_LISTS_rec.attribute12
    ,       p_CURR_LISTS_rec.attribute13
    ,       p_CURR_LISTS_rec.attribute14
    ,       p_CURR_LISTS_rec.attribute15
    ,       p_CURR_LISTS_rec.attribute2
    ,       p_CURR_LISTS_rec.attribute3
    ,       p_CURR_LISTS_rec.attribute4
    ,       p_CURR_LISTS_rec.attribute5
    ,       p_CURR_LISTS_rec.attribute6
    ,       p_CURR_LISTS_rec.attribute7
    ,       p_CURR_LISTS_rec.attribute8
    ,       p_CURR_LISTS_rec.attribute9
    ,       p_CURR_LISTS_rec.base_currency_code
    ,       p_CURR_LISTS_rec.context
    ,       p_CURR_LISTS_rec.created_by
    ,       p_CURR_LISTS_rec.creation_date
    ,       p_CURR_LISTS_rec.currency_header_id
    ,       p_CURR_LISTS_rec.last_updated_by
    ,       p_CURR_LISTS_rec.last_update_date
    ,       p_CURR_LISTS_rec.last_update_login
    ,       p_CURR_LISTS_rec.program_application_id
    ,       p_CURR_LISTS_rec.program_id
    ,       p_CURR_LISTS_rec.program_update_date
    ,       p_CURR_LISTS_rec.request_id
    );

Line: 1249


            ,   'Insert_Row'
            );

Line: 1255


END Insert_Row;

Line: 1259


PROCEDURE Delete_Row
(   p_currency_header_id            IN  NUMBER
)
IS
BEGIN

    DELETE  FROM QP_CURRENCY_LISTS_B
    WHERE   CURRENCY_HEADER_ID = p_currency_header_id
    ;

Line: 1270


    DELETE  FROM QP_CURRENCY_LISTS_TL
    WHERE   CURRENCY_HEADER_ID = p_currency_header_id;

Line: 1281


            ,   'Delete_Row'
            );

Line: 1287


END Delete_Row;

Line: 1298


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       BASE_CURRENCY_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_HEADER_ID
    --,       DESCRIPTION
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    --,       NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    --,       ROW_ID
    INTO    l_CURR_LISTS_rec.attribute1
    ,       l_CURR_LISTS_rec.attribute10
    ,       l_CURR_LISTS_rec.attribute11
    ,       l_CURR_LISTS_rec.attribute12
    ,       l_CURR_LISTS_rec.attribute13
    ,       l_CURR_LISTS_rec.attribute14
    ,       l_CURR_LISTS_rec.attribute15
    ,       l_CURR_LISTS_rec.attribute2
    ,       l_CURR_LISTS_rec.attribute3
    ,       l_CURR_LISTS_rec.attribute4
    ,       l_CURR_LISTS_rec.attribute5
    ,       l_CURR_LISTS_rec.attribute6
    ,       l_CURR_LISTS_rec.attribute7
    ,       l_CURR_LISTS_rec.attribute8
    ,       l_CURR_LISTS_rec.attribute9
    ,       l_CURR_LISTS_rec.base_currency_code
    ,       l_CURR_LISTS_rec.context
    ,       l_CURR_LISTS_rec.created_by
    ,       l_CURR_LISTS_rec.creation_date
    ,       l_CURR_LISTS_rec.currency_header_id
    --,       l_CURR_LISTS_rec.description
    ,       l_CURR_LISTS_rec.last_updated_by
    ,       l_CURR_LISTS_rec.last_update_date
    ,       l_CURR_LISTS_rec.last_update_login
    --,       l_CURR_LISTS_rec.name
    ,       l_CURR_LISTS_rec.program_application_id
    ,       l_CURR_LISTS_rec.program_id
    ,       l_CURR_LISTS_rec.program_update_date
    ,       l_CURR_LISTS_rec.request_id
    --,       l_CURR_LISTS_rec.row_id
    --FROM    QP_CURRENCY_LISTS_VL
    FROM    QP_CURRENCY_LISTS_B
    WHERE   CURRENCY_HEADER_ID = p_currency_header_id
    ;

Line: 1364


    SELECT  NAME
    ,       DESCRIPTION
    INTO    l_CURR_LISTS_rec.name
    ,       l_CURR_LISTS_rec.description
    FROM    QP_CURRENCY_LISTS_TL
    WHERE   CURRENCY_HEADER_ID = p_currency_header_id
    AND     LANGUAGE = userenv('LANG');

Line: 1375


    SELECT  selling_rounding_factor
    ,       markup_value
    ,       markup_operator
    ,       markup_formula_id
    INTO    l_CURR_LISTS_rec.base_rounding_factor
    ,       l_CURR_LISTS_rec.base_markup_value
    ,       l_CURR_LISTS_rec.base_markup_operator
    ,       l_CURR_LISTS_rec.base_markup_formula_id
    FROM    QP_CURRENCY_DETAILS
    WHERE   CURRENCY_HEADER_ID = p_currency_header_id
    AND     CONVERSION_TYPE IS NULL
    AND     TO_CURRENCY_CODE = l_CURR_LISTS_rec.base_currency_code;

Line: 1422


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       BASE_CURRENCY_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_HEADER_ID
    -- ,       DESCRIPTION
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    -- ,       NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    -- ,       ROW_ID
    INTO    l_CURR_LISTS_rec.attribute1
    ,       l_CURR_LISTS_rec.attribute10
    ,       l_CURR_LISTS_rec.attribute11
    ,       l_CURR_LISTS_rec.attribute12
    ,       l_CURR_LISTS_rec.attribute13
    ,       l_CURR_LISTS_rec.attribute14
    ,       l_CURR_LISTS_rec.attribute15
    ,       l_CURR_LISTS_rec.attribute2
    ,       l_CURR_LISTS_rec.attribute3
    ,       l_CURR_LISTS_rec.attribute4
    ,       l_CURR_LISTS_rec.attribute5
    ,       l_CURR_LISTS_rec.attribute6
    ,       l_CURR_LISTS_rec.attribute7
    ,       l_CURR_LISTS_rec.attribute8
    ,       l_CURR_LISTS_rec.attribute9
    ,       l_CURR_LISTS_rec.base_currency_code
    ,       l_CURR_LISTS_rec.context
    ,       l_CURR_LISTS_rec.created_by
    ,       l_CURR_LISTS_rec.creation_date
    ,       l_CURR_LISTS_rec.currency_header_id
    -- ,       l_CURR_LISTS_rec.description
    ,       l_CURR_LISTS_rec.last_updated_by
    ,       l_CURR_LISTS_rec.last_update_date
    ,       l_CURR_LISTS_rec.last_update_login
    -- ,       l_CURR_LISTS_rec.name
    ,       l_CURR_LISTS_rec.program_application_id
    ,       l_CURR_LISTS_rec.program_id
    ,       l_CURR_LISTS_rec.program_update_date
    ,       l_CURR_LISTS_rec.request_id
    -- ,       l_CURR_LISTS_rec.row_id
    -- FROM    QP_CURRENCY_LISTS_VL
    FROM    QP_CURRENCY_LISTS_B
    WHERE   CURRENCY_HEADER_ID = p_CURR_LISTS_rec.currency_header_id
        FOR UPDATE NOWAIT;

Line: 1488


    SELECT  NAME
    ,       DESCRIPTION
    INTO    l_CURR_LISTS_rec.name
    ,       l_CURR_LISTS_rec.description
    FROM    QP_CURRENCY_LISTS_TL
    WHERE   CURRENCY_HEADER_ID = p_CURR_LISTS_rec.CURRENCY_HEADER_ID
    AND     LANGUAGE = userenv('LANG');

Line: 1497


    SELECT  SELLING_ROUNDING_FACTOR
          , MARKUP_OPERATOR
          , MARKUP_VALUE
          , MARKUP_FORMULA_ID
    INTO    l_CURR_LISTS_rec.base_rounding_factor
          , l_CURR_LISTS_rec.base_markup_operator
          , l_CURR_LISTS_rec.base_markup_value
          , l_CURR_LISTS_rec.base_markup_formula_id
    FROM    QP_CURRENCY_DETAILS
    WHERE   CURRENCY_HEADER_ID = p_CURR_LISTS_rec.CURRENCY_HEADER_ID
    AND     TO_CURRENCY_CODE   = p_CURR_LISTS_rec.BASE_CURRENCY_CODE;

Line: 1554


    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,
                         l_CURR_LISTS_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,
                         l_CURR_LISTS_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,
                         l_CURR_LISTS_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,
                         l_CURR_LISTS_rec.name)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,
                         l_CURR_LISTS_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,
                         l_CURR_LISTS_rec.program_id)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,
                         l_CURR_LISTS_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,
                         l_CURR_LISTS_rec.request_id)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,
                         l_CURR_LISTS_rec.base_rounding_factor)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,
                         l_CURR_LISTS_rec.base_markup_value)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,
                         l_CURR_LISTS_rec.base_markup_operator)
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,
                         l_CURR_LISTS_rec.base_markup_formula_id)
/* Commented by Sunil
    AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,
                         l_CURR_LISTS_rec.row_id)
  Commented by Sunil */
    THEN

        --  Row has not changed. Set out parameter.

        x_CURR_LISTS_rec               := l_CURR_LISTS_rec;

Line: 1620


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