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

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

Line: 8


PROCEDURE Update_List_Header_And_Line
(p_LIMITS_rec          IN  QP_Limits_PUB.Limits_Rec_Type)
IS

l_dummy NUMBER := 0;

Line: 14


l_updated NUMBER := 0;  --pattern

Line: 22


         UPDATE QP_LIST_HEADERS_B
         SET LIMIT_EXISTS_FLAG = 'Y'
         WHERE list_header_id = p_LIMITS_rec.list_header_id
         and nvl(LIMIT_EXISTS_FLAG,'N')  <> 'Y' ; --Bug no 6193752

Line: 26


	 l_updated := 1;  --pattern

Line: 30


         UPDATE QP_LIST_LINES
         SET LIMIT_EXISTS_FLAG = 'Y'
         WHERE list_line_id = p_LIMITS_rec.list_line_id
         and nvl(LIMIT_EXISTS_FLAG,'N')  <> 'Y' ; --Bug no 6193752

Line: 34


	 l_updated := 2;  --pattern

Line: 37


   ELSIF (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_delete) OR (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_update) THEN

      IF p_LIMITS_rec.list_header_id IS NOT NULL THEN

         l_dummy := 0;

Line: 42


         SELECT COUNT(*) INTO   l_dummy
         FROM QP_LIST_HEADERS_B WHERE list_header_id = p_LIMITS_rec.list_header_id;

Line: 48


            SELECT COUNT(*) INTO   l_dummy1
            FROM QP_LIMITS WHERE list_header_id = p_LIMITS_rec.list_header_id;

Line: 52


               UPDATE QP_LIST_HEADERS_B SET LIMIT_EXISTS_FLAG = 'N'
               WHERE list_header_id = p_LIMITS_rec.list_header_id
               and nvl(LIMIT_EXISTS_FLAG,'Y')  <> 'N' ; --Bug no 6193752

Line: 55


	       l_updated := 1;  --pattern

Line: 57


               UPDATE QP_LIST_HEADERS_B SET LIMIT_EXISTS_FLAG = 'Y'
               WHERE list_header_id = p_LIMITS_rec.list_header_id
               and nvl(LIMIT_EXISTS_FLAG,'N')  <> 'Y' ; --Bug no 6193752

Line: 60


	       l_updated := 1;  --pattern

Line: 70


         SELECT COUNT(*) INTO   l_dummy
         FROM QP_LIST_LINES WHERE list_line_id = p_LIMITS_rec.list_line_id;

Line: 76


            SELECT COUNT(*) INTO   l_dummy1
            FROM QP_LIMITS WHERE list_line_id = p_LIMITS_rec.list_line_id;

Line: 80


               UPDATE QP_LIST_LINES SET LIMIT_EXISTS_FLAG = 'N'
               WHERE list_line_id = p_LIMITS_rec.list_line_id
               and nvl(LIMIT_EXISTS_FLAG,'Y')  <> 'N' ; --Bug no 6193752

Line: 83


	       l_updated := 2;  --pattern

Line: 85


               UPDATE QP_LIST_LINES SET LIMIT_EXISTS_FLAG = 'Y'
               WHERE list_line_id = p_LIMITS_rec.list_line_id
               and nvl(LIMIT_EXISTS_FLAG,'N')  <> 'Y' ; --Bug no 6193752

Line: 88


	       l_updated := 2;  --pattern

Line: 98


    IF (p_LIMITS_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
     IF l_updated = 1 then
	qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_LIMITS_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_LIMITS_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => l_return_status);

Line: 110


      IF l_updated = 2 then
	qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_LIMITS_rec.list_header_id,
		p_request_unique_key1 => p_LIMITS_rec.list_line_id,
		p_request_unique_key2 => NULL,
		p_request_unique_key3 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_LIMITS_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
		x_return_status => l_return_status);

Line: 127


    IF (p_LIMITS_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
     IF l_updated = 1 then
	qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_LIMITS_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_LIMITS_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => l_return_status);

Line: 139


      IF l_updated = 2 then
	qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_LIMITS_rec.list_header_id,
		p_request_unique_key1 => p_LIMITS_rec.list_line_id,
		p_request_unique_key2 => NULL,
		p_request_unique_key3 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_LIMITS_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
		x_return_status => l_return_status);

Line: 155


END Update_List_Header_And_Line;

Line: 300


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

Line: 303


            l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;

Line: 306


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

Line: 309


            l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;

Line: 312


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

Line: 315


            l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 373


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

Line: 376


            l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 499


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

Line: 501


        l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;

Line: 502


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

Line: 504


        l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;

Line: 505


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

Line: 507


        l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 535


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

Line: 537


        l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 687


    IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by, p_old_LIMITS_rec.last_updated_by)
    THEN
        NULL;

Line: 692


    IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date, p_old_LIMITS_rec.last_update_date)
    THEN
        NULL;

Line: 697


    IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login, p_old_LIMITS_rec.last_update_login)
    THEN
        NULL;

Line: 747


    IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date, p_old_LIMITS_rec.program_update_date)
    THEN
        NULL;

Line: 894


    IF l_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_LIMITS_rec.last_updated_by := p_old_LIMITS_rec.last_updated_by;

Line: 898


    IF l_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_LIMITS_rec.last_update_date := p_old_LIMITS_rec.last_update_date;

Line: 902


    IF l_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_LIMITS_rec.last_update_login := p_old_LIMITS_rec.last_update_login;

Line: 942


    IF l_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_LIMITS_rec.program_update_date := p_old_LIMITS_rec.program_update_date;

Line: 1079


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

Line: 1083


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

Line: 1087


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

Line: 1127


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

Line: 1177


PROCEDURE Update_Row
(   p_LIMITS_rec                    IN  QP_Limits_PUB.Limits_Rec_Type
)

IS
l_check_active_flag VARCHAR2(1);

Line: 1193


    SELECT active_flag
       INTO   l_active_flag
       FROM   QP_LIST_HEADERS_B
       WHERE  list_header_id=p_LIMITS_rec.list_header_id;

Line: 1198


    UPDATE  QP_LIMITS
    SET     AMOUNT                         = p_LIMITS_rec.amount
    ,       ATTRIBUTE1                     = p_LIMITS_rec.attribute1
    ,       ATTRIBUTE10                    = p_LIMITS_rec.attribute10
    ,       ATTRIBUTE11                    = p_LIMITS_rec.attribute11
    ,       ATTRIBUTE12                    = p_LIMITS_rec.attribute12
    ,       ATTRIBUTE13                    = p_LIMITS_rec.attribute13
    ,       ATTRIBUTE14                    = p_LIMITS_rec.attribute14
    ,       ATTRIBUTE15                    = p_LIMITS_rec.attribute15
    ,       ATTRIBUTE2                     = p_LIMITS_rec.attribute2
    ,       ATTRIBUTE3                     = p_LIMITS_rec.attribute3
    ,       ATTRIBUTE4                     = p_LIMITS_rec.attribute4
    ,       ATTRIBUTE5                     = p_LIMITS_rec.attribute5
    ,       ATTRIBUTE6                     = p_LIMITS_rec.attribute6
    ,       ATTRIBUTE7                     = p_LIMITS_rec.attribute7
    ,       ATTRIBUTE8                     = p_LIMITS_rec.attribute8
    ,       ATTRIBUTE9                     = p_LIMITS_rec.attribute9
    ,       BASIS                          = p_LIMITS_rec.basis
    ,       CONTEXT                        = p_LIMITS_rec.context
    ,       CREATED_BY                     = p_LIMITS_rec.created_by
    ,       CREATION_DATE                  = p_LIMITS_rec.creation_date
    ,       LAST_UPDATED_BY                = p_LIMITS_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_LIMITS_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_LIMITS_rec.last_update_login
    ,       LIMIT_EXCEED_ACTION_CODE       = p_LIMITS_rec.limit_exceed_action_code
    ,       LIMIT_HOLD_FLAG                = p_LIMITS_rec.limit_hold_flag
    ,       LIMIT_ID                       = p_LIMITS_rec.limit_id
    ,       LIMIT_LEVEL_CODE               = p_LIMITS_rec.limit_level_code
    ,       LIMIT_NUMBER                   = p_LIMITS_rec.limit_number
    ,       LIST_HEADER_ID                 = p_LIMITS_rec.list_header_id
    ,       LIST_LINE_ID                   = p_LIMITS_rec.list_line_id
    ,       MULTIVAL_ATTR1_TYPE            = p_LIMITS_rec.multival_attr1_type
    ,       MULTIVAL_ATTR1_CONTEXT         = p_LIMITS_rec.multival_attr1_context
    ,       MULTIVAL_ATTRIBUTE1            = p_LIMITS_rec.multival_attribute1
    ,       MULTIVAL_ATTR1_DATATYPE        = p_LIMITS_rec.multival_attr1_datatype
    ,       MULTIVAL_ATTR2_TYPE            = p_LIMITS_rec.multival_attr2_type
    ,       MULTIVAL_ATTR2_CONTEXT         = p_LIMITS_rec.multival_attr2_context
    ,       MULTIVAL_ATTRIBUTE2            = p_LIMITS_rec.multival_attribute2
    ,       MULTIVAL_ATTR2_DATATYPE        = p_LIMITS_rec.multival_attr2_datatype
    ,       ORGANIZATION_FLAG              = p_LIMITS_rec.organization_flag
    ,       PROGRAM_APPLICATION_ID         = p_LIMITS_rec.program_application_id
    ,       PROGRAM_ID                     = p_LIMITS_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_LIMITS_rec.program_update_date
    ,       REQUEST_ID                     = p_LIMITS_rec.request_id
    WHERE   LIMIT_ID = p_LIMITS_rec.limit_id
    ;

Line: 1244


    l_LIMITS_rec.operation := QP_GLOBALS.g_opr_update;

Line: 1251


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

Line: 1264


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

Line: 1276


    Update_List_Header_And_Line(l_LIMITS_rec);

Line: 1282


       QP_LIMIT_CONC_REQ.UPDATE_BALANCES(x_retcode
                                        ,x_errbuf
                                        ,null
                                        ,null
                                        ,p_LIMITS_rec.limit_id
                                        ,null);

Line: 1291


          ,   'UPDATE_BALANCES'
          );

Line: 1308


            ,   'Update_Row'
            );

Line: 1314


END Update_Row;

Line: 1318


PROCEDURE Insert_Row
(   p_LIMITS_rec                    IN  QP_Limits_PUB.Limits_Rec_Type
)

IS
l_check_active_flag VARCHAR2(1);

Line: 1330


SELECT active_flag
       INTO   l_active_flag
       FROM   QP_LIST_HEADERS_B
       WHERE  list_header_id=p_LIMITS_rec.list_header_id;

Line: 1335


    INSERT  INTO QP_LIMITS
    (       AMOUNT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       BASIS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_EXCEED_ACTION_CODE
    ,       LIMIT_HOLD_FLAG
    ,       LIMIT_ID
    ,       LIMIT_LEVEL_CODE
    ,       LIMIT_NUMBER
    ,       LIST_HEADER_ID
    ,       LIST_LINE_ID
    ,       MULTIVAL_ATTR1_TYPE
    ,       MULTIVAL_ATTR1_CONTEXT
    ,       MULTIVAL_ATTRIBUTE1
    ,       MULTIVAL_ATTR1_DATATYPE
    ,       MULTIVAL_ATTR2_TYPE
    ,       MULTIVAL_ATTR2_CONTEXT
    ,       MULTIVAL_ATTRIBUTE2
    ,       MULTIVAL_ATTR2_DATATYPE
    ,       ORGANIZATION_FLAG
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    )
    VALUES
    (       p_LIMITS_rec.amount
    ,       p_LIMITS_rec.attribute1
    ,       p_LIMITS_rec.attribute10
    ,       p_LIMITS_rec.attribute11
    ,       p_LIMITS_rec.attribute12
    ,       p_LIMITS_rec.attribute13
    ,       p_LIMITS_rec.attribute14
    ,       p_LIMITS_rec.attribute15
    ,       p_LIMITS_rec.attribute2
    ,       p_LIMITS_rec.attribute3
    ,       p_LIMITS_rec.attribute4
    ,       p_LIMITS_rec.attribute5
    ,       p_LIMITS_rec.attribute6
    ,       p_LIMITS_rec.attribute7
    ,       p_LIMITS_rec.attribute8
    ,       p_LIMITS_rec.attribute9
    ,       p_LIMITS_rec.basis
    ,       p_LIMITS_rec.context
    ,       p_LIMITS_rec.created_by
    ,       p_LIMITS_rec.creation_date
    ,       p_LIMITS_rec.last_updated_by
    ,       p_LIMITS_rec.last_update_date
    ,       p_LIMITS_rec.last_update_login
    ,       p_LIMITS_rec.limit_exceed_action_code
    ,       p_LIMITS_rec.limit_hold_flag
    ,       p_LIMITS_rec.limit_id
    ,       p_LIMITS_rec.limit_level_code
    ,       p_LIMITS_rec.limit_number
    ,       p_LIMITS_rec.list_header_id
    ,       p_LIMITS_rec.list_line_id
    ,       p_LIMITS_rec.multival_attr1_type
    ,       p_LIMITS_rec.multival_attr1_context
    ,       p_LIMITS_rec.multival_attribute1
    ,       p_LIMITS_rec.multival_attr1_datatype
    ,       p_LIMITS_rec.multival_attr2_type
    ,       p_LIMITS_rec.multival_attr2_context
    ,       p_LIMITS_rec.multival_attribute2
    ,       p_LIMITS_rec.multival_attr2_datatype
    ,       p_LIMITS_rec.organization_flag
    ,       p_LIMITS_rec.program_application_id
    ,       p_LIMITS_rec.program_id
    ,       p_LIMITS_rec.program_update_date
    ,       p_LIMITS_rec.request_id
    );

Line: 1426


    Update_List_Header_And_Line(l_LIMITS_rec);

Line: 1432


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

Line: 1445


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

Line: 1465


            ,   'Insert_Row'
            );

Line: 1471


END Insert_Row;

Line: 1475


PROCEDURE Delete_Row
(   p_limit_id                      IN  NUMBER
)

IS
l_limits_rec     QP_Limits_PUB.Limits_Rec_Type;

Line: 1485


     l_limits_rec.operation := QP_GLOBALS.g_opr_delete;

Line: 1488


    DELETE  FROM QP_LIMITS
    WHERE   LIMIT_ID = p_limit_id;

Line: 1491


    Update_List_Header_And_Line(l_limits_rec);

Line: 1503


            ,   'Delete_Row'
            );

Line: 1509


END Delete_Row;

Line: 1520


    SELECT  AMOUNT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       BASIS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_EXCEED_ACTION_CODE
    ,       LIMIT_HOLD_FLAG
    ,       LIMIT_ID
    ,       LIMIT_LEVEL_CODE
    ,       LIMIT_NUMBER
    ,       LIST_HEADER_ID
    ,       LIST_LINE_ID
    ,       MULTIVAL_ATTR1_TYPE
    ,       MULTIVAL_ATTR1_CONTEXT
    ,       MULTIVAL_ATTRIBUTE1
    ,       MULTIVAL_ATTR1_DATATYPE
    ,       MULTIVAL_ATTR2_TYPE
    ,       MULTIVAL_ATTR2_CONTEXT
    ,       MULTIVAL_ATTRIBUTE2
    ,       MULTIVAL_ATTR2_DATATYPE
    ,       ORGANIZATION_FLAG
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    INTO    l_LIMITS_rec.amount
    ,       l_LIMITS_rec.attribute1
    ,       l_LIMITS_rec.attribute10
    ,       l_LIMITS_rec.attribute11
    ,       l_LIMITS_rec.attribute12
    ,       l_LIMITS_rec.attribute13
    ,       l_LIMITS_rec.attribute14
    ,       l_LIMITS_rec.attribute15
    ,       l_LIMITS_rec.attribute2
    ,       l_LIMITS_rec.attribute3
    ,       l_LIMITS_rec.attribute4
    ,       l_LIMITS_rec.attribute5
    ,       l_LIMITS_rec.attribute6
    ,       l_LIMITS_rec.attribute7
    ,       l_LIMITS_rec.attribute8
    ,       l_LIMITS_rec.attribute9
    ,       l_LIMITS_rec.basis
    ,       l_LIMITS_rec.context
    ,       l_LIMITS_rec.created_by
    ,       l_LIMITS_rec.creation_date
    ,       l_LIMITS_rec.last_updated_by
    ,       l_LIMITS_rec.last_update_date
    ,       l_LIMITS_rec.last_update_login
    ,       l_LIMITS_rec.limit_exceed_action_code
    ,       l_LIMITS_rec.limit_hold_flag
    ,       l_LIMITS_rec.limit_id
    ,       l_LIMITS_rec.limit_level_code
    ,       l_LIMITS_rec.limit_number
    ,       l_LIMITS_rec.list_header_id
    ,       l_LIMITS_rec.list_line_id
    ,       l_LIMITS_rec.multival_attr1_type
    ,       l_LIMITS_rec.multival_attr1_context
    ,       l_LIMITS_rec.multival_attribute1
    ,       l_LIMITS_rec.multival_attr1_datatype
    ,       l_LIMITS_rec.multival_attr2_type
    ,       l_LIMITS_rec.multival_attr2_context
    ,       l_LIMITS_rec.multival_attribute2
    ,       l_LIMITS_rec.multival_attr2_datatype
    ,       l_LIMITS_rec.organization_flag
    ,       l_LIMITS_rec.program_application_id
    ,       l_LIMITS_rec.program_id
    ,       l_LIMITS_rec.program_update_date
    ,       l_LIMITS_rec.request_id
    FROM    QP_LIMITS
    WHERE   LIMIT_ID = p_limit_id
    ;

Line: 1643


    SELECT  AMOUNT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       BASIS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_EXCEED_ACTION_CODE
    ,       LIMIT_HOLD_FLAG
    ,       LIMIT_ID
    ,       LIMIT_LEVEL_CODE
    ,       LIMIT_NUMBER
    ,       LIST_HEADER_ID
    ,       LIST_LINE_ID
    ,       MULTIVAL_ATTR1_TYPE
    ,       MULTIVAL_ATTR1_CONTEXT
    ,       MULTIVAL_ATTRIBUTE1
    ,       MULTIVAL_ATTR1_DATATYPE
    ,       MULTIVAL_ATTR2_TYPE
    ,       MULTIVAL_ATTR2_CONTEXT
    ,       MULTIVAL_ATTRIBUTE2
    ,       MULTIVAL_ATTR2_DATATYPE
    ,       ORGANIZATION_FLAG
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    INTO    l_LIMITS_rec.amount
    ,       l_LIMITS_rec.attribute1
    ,       l_LIMITS_rec.attribute10
    ,       l_LIMITS_rec.attribute11
    ,       l_LIMITS_rec.attribute12
    ,       l_LIMITS_rec.attribute13
    ,       l_LIMITS_rec.attribute14
    ,       l_LIMITS_rec.attribute15
    ,       l_LIMITS_rec.attribute2
    ,       l_LIMITS_rec.attribute3
    ,       l_LIMITS_rec.attribute4
    ,       l_LIMITS_rec.attribute5
    ,       l_LIMITS_rec.attribute6
    ,       l_LIMITS_rec.attribute7
    ,       l_LIMITS_rec.attribute8
    ,       l_LIMITS_rec.attribute9
    ,       l_LIMITS_rec.basis
    ,       l_LIMITS_rec.context
    ,       l_LIMITS_rec.created_by
    ,       l_LIMITS_rec.creation_date
    ,       l_LIMITS_rec.last_updated_by
    ,       l_LIMITS_rec.last_update_date
    ,       l_LIMITS_rec.last_update_login
    ,       l_LIMITS_rec.limit_exceed_action_code
    ,       l_LIMITS_rec.limit_hold_flag
    ,       l_LIMITS_rec.limit_id
    ,       l_LIMITS_rec.limit_level_code
    ,       l_LIMITS_rec.limit_number
    ,       l_LIMITS_rec.list_header_id
    ,       l_LIMITS_rec.list_line_id
    ,       l_LIMITS_rec.multival_attr1_type
    ,       l_LIMITS_rec.multival_attr1_context
    ,       l_LIMITS_rec.multival_attribute1
    ,       l_LIMITS_rec.multival_attr1_datatype
    ,       l_LIMITS_rec.multival_attr2_type
    ,       l_LIMITS_rec.multival_attr2_context
    ,       l_LIMITS_rec.multival_attribute2
    ,       l_LIMITS_rec.multival_attr2_datatype
    ,       l_LIMITS_rec.organization_flag
    ,       l_LIMITS_rec.program_application_id
    ,       l_LIMITS_rec.program_id
    ,       l_LIMITS_rec.program_update_date
    ,       l_LIMITS_rec.request_id
    FROM    QP_LIMITS
    WHERE   LIMIT_ID = p_LIMITS_rec.limit_id
        FOR UPDATE NOWAIT;

Line: 1775


    AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
                         l_LIMITS_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
                         l_LIMITS_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
                         l_LIMITS_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
                         l_LIMITS_rec.limit_exceed_action_code)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
                         l_LIMITS_rec.limit_hold_flag)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
                         l_LIMITS_rec.limit_id)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
                         l_LIMITS_rec.limit_level_code)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
                         l_LIMITS_rec.limit_number)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
                         l_LIMITS_rec.list_header_id)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
                         l_LIMITS_rec.list_line_id)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
                         l_LIMITS_rec.multival_attr1_type)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
                         l_LIMITS_rec.multival_attr1_context)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
                         l_LIMITS_rec.multival_attribute1)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
                         l_LIMITS_rec.multival_attr1_datatype)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
                         l_LIMITS_rec.multival_attr2_type)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
                         l_LIMITS_rec.multival_attr2_context)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
                         l_LIMITS_rec.multival_attribute2)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
                         l_LIMITS_rec.multival_attr2_datatype)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
                         l_LIMITS_rec.organization_flag)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
                         l_LIMITS_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
                         l_LIMITS_rec.program_id)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,
                         l_LIMITS_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_LIMITS_rec.request_id,
                         l_LIMITS_rec.request_id)
    THEN

        --  Row has not changed. Set out parameter.

        x_LIMITS_rec                   := l_LIMITS_rec;

Line: 1859


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

Line: 2189


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