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

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

Line: 152


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

Line: 155


            l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;

Line: 158


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

Line: 161


            l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;

Line: 164


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

Line: 167


            l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;

Line: 194


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

Line: 197


            l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 350


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

Line: 352


        l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;

Line: 353


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

Line: 355


        l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;

Line: 356


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

Line: 358


        l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;

Line: 371


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

Line: 373


        l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 538


    IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,p_old_LIMIT_BALANCES_rec.last_updated_by)
    THEN
        NULL;

Line: 543


    IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,p_old_LIMIT_BALANCES_rec.last_update_date)
    THEN
        NULL;

Line: 548


    IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,p_old_LIMIT_BALANCES_rec.last_update_login)
    THEN
        NULL;

Line: 573


    IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,p_old_LIMIT_BALANCES_rec.program_update_date)
    THEN
        NULL;

Line: 746


    IF l_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_LIMIT_BALANCES_rec.last_updated_by := p_old_LIMIT_BALANCES_rec.last_updated_by;

Line: 750


    IF l_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_LIMIT_BALANCES_rec.last_update_date := p_old_LIMIT_BALANCES_rec.last_update_date;

Line: 754


    IF l_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_LIMIT_BALANCES_rec.last_update_login := p_old_LIMIT_BALANCES_rec.last_update_login;

Line: 774


    IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_LIMIT_BALANCES_rec.program_update_date := p_old_LIMIT_BALANCES_rec.program_update_date;

Line: 931


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

Line: 935


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

Line: 939


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

Line: 959


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

Line: 1029


PROCEDURE Update_Row
(   p_LIMIT_BALANCES_rec            IN  QP_Limits_PUB.Limit_Balances_Rec_Type
)
IS
l_check_active_flag VARCHAR2(1);

Line: 1036


  SELECT active_flag
       INTO l_active_flag
       FROM QP_LIMITS a,QP_LIST_HEADERS_B b
       WHERE a.limit_id=p_LIMIT_BALANCES_rec.limit_id
       AND   b.list_header_id=a.list_header_id;

Line: 1043


    UPDATE  QP_LIMIT_BALANCES
    SET     ATTRIBUTE1                     = p_LIMIT_BALANCES_rec.attribute1
    ,       ATTRIBUTE10                    = p_LIMIT_BALANCES_rec.attribute10
    ,       ATTRIBUTE11                    = p_LIMIT_BALANCES_rec.attribute11
    ,       ATTRIBUTE12                    = p_LIMIT_BALANCES_rec.attribute12
    ,       ATTRIBUTE13                    = p_LIMIT_BALANCES_rec.attribute13
    ,       ATTRIBUTE14                    = p_LIMIT_BALANCES_rec.attribute14
    ,       ATTRIBUTE15                    = p_LIMIT_BALANCES_rec.attribute15
    ,       ATTRIBUTE2                     = p_LIMIT_BALANCES_rec.attribute2
    ,       ATTRIBUTE3                     = p_LIMIT_BALANCES_rec.attribute3
    ,       ATTRIBUTE4                     = p_LIMIT_BALANCES_rec.attribute4
    ,       ATTRIBUTE5                     = p_LIMIT_BALANCES_rec.attribute5
    ,       ATTRIBUTE6                     = p_LIMIT_BALANCES_rec.attribute6
    ,       ATTRIBUTE7                     = p_LIMIT_BALANCES_rec.attribute7
    ,       ATTRIBUTE8                     = p_LIMIT_BALANCES_rec.attribute8
    ,       ATTRIBUTE9                     = p_LIMIT_BALANCES_rec.attribute9
    ,       AVAILABLE_AMOUNT               = p_LIMIT_BALANCES_rec.available_amount
    ,       CONSUMED_AMOUNT                = p_LIMIT_BALANCES_rec.consumed_amount
    ,       CONTEXT                        = p_LIMIT_BALANCES_rec.context
    ,       CREATED_BY                     = p_LIMIT_BALANCES_rec.created_by
    ,       CREATION_DATE                  = p_LIMIT_BALANCES_rec.creation_date
    ,       LAST_UPDATED_BY                = p_LIMIT_BALANCES_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_LIMIT_BALANCES_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_LIMIT_BALANCES_rec.last_update_login
    ,       LIMIT_BALANCE_ID               = p_LIMIT_BALANCES_rec.limit_balance_id
    ,       LIMIT_ID                       = p_LIMIT_BALANCES_rec.limit_id
    ,       PROGRAM_APPLICATION_ID         = p_LIMIT_BALANCES_rec.program_application_id
    ,       PROGRAM_ID                     = p_LIMIT_BALANCES_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_LIMIT_BALANCES_rec.program_update_date
    ,       REQUEST_ID                     = p_LIMIT_BALANCES_rec.request_id
    ,       RESERVED_AMOUNT                = p_LIMIT_BALANCES_rec.reserved_amount
    ,       MULTIVAL_ATTR1_TYPE            = p_LIMIT_BALANCES_rec.multival_attr1_type
    ,       MULTIVAL_ATTR1_CONTEXT         = p_LIMIT_BALANCES_rec.multival_attr1_context
    ,       MULTIVAL_ATTRIBUTE1            = p_LIMIT_BALANCES_rec.multival_attribute1
    ,       MULTIVAL_ATTR1_VALUE           = p_LIMIT_BALANCES_rec.multival_attr1_value
    ,       MULTIVAL_ATTR1_DATATYPE        = p_LIMIT_BALANCES_rec.multival_attr1_datatype
    ,       MULTIVAL_ATTR2_TYPE            = p_LIMIT_BALANCES_rec.multival_attr2_type
    ,       MULTIVAL_ATTR2_CONTEXT         = p_LIMIT_BALANCES_rec.multival_attr2_context
    ,       MULTIVAL_ATTRIBUTE2            = p_LIMIT_BALANCES_rec.multival_attribute2
    ,       MULTIVAL_ATTR2_VALUE           = p_LIMIT_BALANCES_rec.multival_attr2_value
    ,       MULTIVAL_ATTR2_DATATYPE        = p_LIMIT_BALANCES_rec.multival_attr2_datatype
    ,       ORGANIZATION_ATTR_CONTEXT      = p_LIMIT_BALANCES_rec.organization_attr_context
    ,       ORGANIZATION_ATTRIBUTE         = p_LIMIT_BALANCES_rec.organization_attribute
    ,       ORGANIZATION_ATTR_VALUE        = p_LIMIT_BALANCES_rec.organization_attr_value
    WHERE   LIMIT_BALANCE_ID = p_LIMIT_BALANCES_rec.limit_balance_id
    ;

Line: 1096


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_LIMIT_BALANCES_rec.multival_attribute1
 AND    a.prc_context_id=b.prc_context_id
 AND b.prc_context_type = p_LIMIT_BALANCES_rec.multival_attr1_type
 AND    b.prc_context_code=p_LIMIT_BALANCES_rec.multival_attr1_context);

Line: 1109


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_LIMIT_BALANCES_rec.multival_attribute2
 AND    a.prc_context_id=b.prc_context_id
 AND b.prc_context_type = p_LIMIT_BALANCES_rec.multival_attr2_type
 AND    b.prc_context_code=p_LIMIT_BALANCES_rec.multival_attr2_context);

Line: 1130


            ,   'Update_Row'
            );

Line: 1136


END Update_Row;

Line: 1140


PROCEDURE Insert_Row
(   p_LIMIT_BALANCES_rec            IN  QP_Limits_PUB.Limit_Balances_Rec_Type
)
IS
l_check_active_flag VARCHAR2(1);

Line: 1147


SELECT active_flag
       INTO l_active_flag
       FROM QP_LIMITS a,QP_LIST_HEADERS_B b
       WHERE a.limit_id=p_LIMIT_BALANCES_rec.limit_id
       AND   b.list_header_id=a.list_header_id;

Line: 1153


    INSERT  INTO QP_LIMIT_BALANCES
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AVAILABLE_AMOUNT
    ,       CONSUMED_AMOUNT
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_BALANCE_ID
    ,       LIMIT_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       RESERVED_AMOUNT
    ,       MULTIVAL_ATTR1_TYPE
    ,       MULTIVAL_ATTR1_CONTEXT
    ,       MULTIVAL_ATTRIBUTE1
    ,       MULTIVAL_ATTR1_VALUE
    ,       MULTIVAL_ATTR1_DATATYPE
    ,       MULTIVAL_ATTR2_TYPE
    ,       MULTIVAL_ATTR2_CONTEXT
    ,       MULTIVAL_ATTRIBUTE2
    ,       MULTIVAL_ATTR2_VALUE
    ,       MULTIVAL_ATTR2_DATATYPE
    ,       ORGANIZATION_ATTR_CONTEXT
    ,       ORGANIZATION_ATTRIBUTE
    ,       ORGANIZATION_ATTR_VALUE
    )
    VALUES
    (       p_LIMIT_BALANCES_rec.attribute1
    ,       p_LIMIT_BALANCES_rec.attribute10
    ,       p_LIMIT_BALANCES_rec.attribute11
    ,       p_LIMIT_BALANCES_rec.attribute12
    ,       p_LIMIT_BALANCES_rec.attribute13
    ,       p_LIMIT_BALANCES_rec.attribute14
    ,       p_LIMIT_BALANCES_rec.attribute15
    ,       p_LIMIT_BALANCES_rec.attribute2
    ,       p_LIMIT_BALANCES_rec.attribute3
    ,       p_LIMIT_BALANCES_rec.attribute4
    ,       p_LIMIT_BALANCES_rec.attribute5
    ,       p_LIMIT_BALANCES_rec.attribute6
    ,       p_LIMIT_BALANCES_rec.attribute7
    ,       p_LIMIT_BALANCES_rec.attribute8
    ,       p_LIMIT_BALANCES_rec.attribute9
    ,       p_LIMIT_BALANCES_rec.available_amount
    ,       p_LIMIT_BALANCES_rec.consumed_amount
    ,       p_LIMIT_BALANCES_rec.context
    ,       p_LIMIT_BALANCES_rec.created_by
    ,       p_LIMIT_BALANCES_rec.creation_date
    ,       p_LIMIT_BALANCES_rec.last_updated_by
    ,       p_LIMIT_BALANCES_rec.last_update_date
    ,       p_LIMIT_BALANCES_rec.last_update_login
    ,       p_LIMIT_BALANCES_rec.limit_balance_id
    ,       p_LIMIT_BALANCES_rec.limit_id
    ,       p_LIMIT_BALANCES_rec.program_application_id
    ,       p_LIMIT_BALANCES_rec.program_id
    ,       p_LIMIT_BALANCES_rec.program_update_date
    ,       p_LIMIT_BALANCES_rec.request_id
    ,       p_LIMIT_BALANCES_rec.reserved_amount
    ,       p_LIMIT_BALANCES_rec.multival_attr1_type
    ,       p_LIMIT_BALANCES_rec.multival_attr1_context
    ,       p_LIMIT_BALANCES_rec.multival_attribute1
    ,       p_LIMIT_BALANCES_rec.multival_attr1_value
    ,       p_LIMIT_BALANCES_rec.multival_attr1_datatype
    ,       p_LIMIT_BALANCES_rec.multival_attr2_type
    ,       p_LIMIT_BALANCES_rec.multival_attr2_context
    ,       p_LIMIT_BALANCES_rec.multival_attribute2
    ,       p_LIMIT_BALANCES_rec.multival_attr2_value
    ,       p_LIMIT_BALANCES_rec.multival_attr2_datatype
    ,       p_LIMIT_BALANCES_rec.organization_attr_context
    ,       p_LIMIT_BALANCES_rec.organization_attribute
    ,       p_LIMIT_BALANCES_rec.organization_attr_value
    );

Line: 1248


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_LIMIT_BALANCES_rec.multival_attribute1
 AND    a.prc_context_id=b.prc_context_id
 AND b.prc_context_type = p_LIMIT_BALANCES_rec.multival_attr1_type
 AND    b.prc_context_code=p_LIMIT_BALANCES_rec.multival_attr1_context);

Line: 1261


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_LIMIT_BALANCES_rec.multival_attribute2
 AND    a.prc_context_id=b.prc_context_id
 AND b.prc_context_type = p_LIMIT_BALANCES_rec.multival_attr2_type
 AND    b.prc_context_code=p_LIMIT_BALANCES_rec.multival_attr2_context);

Line: 1281


            ,   'Insert_Row'
            );

Line: 1287


END Insert_Row;

Line: 1291


PROCEDURE Delete_Row
(   p_limit_balance_id              IN  NUMBER
)
IS
BEGIN

    DELETE  FROM QP_LIMIT_BALANCES
    WHERE   LIMIT_BALANCE_ID = p_limit_balance_id
    ;

Line: 1311


            ,   'Delete_Row'
            );

Line: 1317


END Delete_Row;

Line: 1348


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AVAILABLE_AMOUNT
    ,       CONSUMED_AMOUNT
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_BALANCE_ID
    ,       LIMIT_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       RESERVED_AMOUNT
    ,       MULTIVAL_ATTR1_TYPE
    ,       MULTIVAL_ATTR1_CONTEXT
    ,       MULTIVAL_ATTRIBUTE1
    ,       MULTIVAL_ATTR1_VALUE
    ,       MULTIVAL_ATTR1_DATATYPE
    ,       MULTIVAL_ATTR2_TYPE
    ,       MULTIVAL_ATTR2_CONTEXT
    ,       MULTIVAL_ATTRIBUTE2
    ,       MULTIVAL_ATTR2_VALUE
    ,       MULTIVAL_ATTR2_DATATYPE
    ,       ORGANIZATION_ATTR_CONTEXT
    ,       ORGANIZATION_ATTRIBUTE
    ,       ORGANIZATION_ATTR_VALUE
    FROM    QP_LIMIT_BALANCES
    WHERE ( LIMIT_BALANCE_ID = p_limit_balance_id
    )
    OR (    LIMIT_ID = p_limit_id
    );

Line: 1446


        l_LIMIT_BALANCES_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1447


        l_LIMIT_BALANCES_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1448


        l_LIMIT_BALANCES_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1453


        l_LIMIT_BALANCES_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1524


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AVAILABLE_AMOUNT
    ,       CONSUMED_AMOUNT
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_BALANCE_ID
    ,       LIMIT_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       RESERVED_AMOUNT
    ,       MULTIVAL_ATTR1_TYPE
    ,       MULTIVAL_ATTR1_CONTEXT
    ,       MULTIVAL_ATTRIBUTE1
    ,       MULTIVAL_ATTR1_VALUE
    ,       MULTIVAL_ATTR1_DATATYPE
    ,       MULTIVAL_ATTR2_TYPE
    ,       MULTIVAL_ATTR2_CONTEXT
    ,       MULTIVAL_ATTRIBUTE2
    ,       MULTIVAL_ATTR2_VALUE
    ,       MULTIVAL_ATTR2_DATATYPE
    ,       ORGANIZATION_ATTR_CONTEXT
    ,       ORGANIZATION_ATTRIBUTE
    ,       ORGANIZATION_ATTR_VALUE
    INTO    l_LIMIT_BALANCES_rec.attribute1
    ,       l_LIMIT_BALANCES_rec.attribute10
    ,       l_LIMIT_BALANCES_rec.attribute11
    ,       l_LIMIT_BALANCES_rec.attribute12
    ,       l_LIMIT_BALANCES_rec.attribute13
    ,       l_LIMIT_BALANCES_rec.attribute14
    ,       l_LIMIT_BALANCES_rec.attribute15
    ,       l_LIMIT_BALANCES_rec.attribute2
    ,       l_LIMIT_BALANCES_rec.attribute3
    ,       l_LIMIT_BALANCES_rec.attribute4
    ,       l_LIMIT_BALANCES_rec.attribute5
    ,       l_LIMIT_BALANCES_rec.attribute6
    ,       l_LIMIT_BALANCES_rec.attribute7
    ,       l_LIMIT_BALANCES_rec.attribute8
    ,       l_LIMIT_BALANCES_rec.attribute9
    ,       l_LIMIT_BALANCES_rec.available_amount
    ,       l_LIMIT_BALANCES_rec.consumed_amount
    ,       l_LIMIT_BALANCES_rec.context
    ,       l_LIMIT_BALANCES_rec.created_by
    ,       l_LIMIT_BALANCES_rec.creation_date
    ,       l_LIMIT_BALANCES_rec.last_updated_by
    ,       l_LIMIT_BALANCES_rec.last_update_date
    ,       l_LIMIT_BALANCES_rec.last_update_login
    ,       l_LIMIT_BALANCES_rec.limit_balance_id
    ,       l_LIMIT_BALANCES_rec.limit_id
    ,       l_LIMIT_BALANCES_rec.program_application_id
    ,       l_LIMIT_BALANCES_rec.program_id
    ,       l_LIMIT_BALANCES_rec.program_update_date
    ,       l_LIMIT_BALANCES_rec.request_id
    ,       l_LIMIT_BALANCES_rec.reserved_amount
    ,       l_LIMIT_BALANCES_rec.multival_attr1_type
    ,       l_LIMIT_BALANCES_rec.multival_attr1_context
    ,       l_LIMIT_BALANCES_rec.multival_attribute1
    ,       l_LIMIT_BALANCES_rec.multival_attr1_value
    ,       l_LIMIT_BALANCES_rec.multival_attr1_datatype
    ,       l_LIMIT_BALANCES_rec.multival_attr2_type
    ,       l_LIMIT_BALANCES_rec.multival_attr2_context
    ,       l_LIMIT_BALANCES_rec.multival_attribute2
    ,       l_LIMIT_BALANCES_rec.multival_attr2_value
    ,       l_LIMIT_BALANCES_rec.multival_attr2_datatype
    ,       l_LIMIT_BALANCES_rec.organization_attr_context
    ,       l_LIMIT_BALANCES_rec.organization_attribute
    ,       l_LIMIT_BALANCES_rec.organization_attr_value
    FROM    QP_LIMIT_BALANCES
    WHERE   LIMIT_BALANCE_ID = p_LIMIT_BALANCES_rec.limit_balance_id
        FOR UPDATE NOWAIT;

Line: 1656


    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,
                         l_LIMIT_BALANCES_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,
                         l_LIMIT_BALANCES_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,
                         l_LIMIT_BALANCES_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,
                         l_LIMIT_BALANCES_rec.limit_balance_id)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,
                         l_LIMIT_BALANCES_rec.limit_id)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,
                         l_LIMIT_BALANCES_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,
                         l_LIMIT_BALANCES_rec.program_id)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,
                         l_LIMIT_BALANCES_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,
                         l_LIMIT_BALANCES_rec.request_id)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,
                         l_LIMIT_BALANCES_rec.reserved_amount)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,
                         l_LIMIT_BALANCES_rec.multival_attr1_type)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,
                         l_LIMIT_BALANCES_rec.multival_attr1_context)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,
                         l_LIMIT_BALANCES_rec.multival_attribute1)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,
                         l_LIMIT_BALANCES_rec.multival_attr1_value)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,
                         l_LIMIT_BALANCES_rec.multival_attr1_datatype)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,
                         l_LIMIT_BALANCES_rec.multival_attr2_type)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,
                         l_LIMIT_BALANCES_rec.multival_attr2_context)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,
                         l_LIMIT_BALANCES_rec.multival_attribute2)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,
                         l_LIMIT_BALANCES_rec.multival_attr2_value)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,
                         l_LIMIT_BALANCES_rec.multival_attr2_datatype)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,
                         l_LIMIT_BALANCES_rec.organization_attr_context)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,
                         l_LIMIT_BALANCES_rec.organization_attribute)
    AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,
                         l_LIMIT_BALANCES_rec.organization_attr_value)
    THEN

        --  Row has not changed. Set out parameter.

        x_LIMIT_BALANCES_rec           := l_LIMIT_BALANCES_rec;

Line: 1740


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