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

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

Line: 146


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

Line: 149


            l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATED_BY;

Line: 152


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

Line: 155


            l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATE_DATE;

Line: 158


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

Line: 161


            l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 219


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

Line: 222


            l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 288


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

Line: 290


        l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATED_BY;

Line: 291


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

Line: 293


        l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATE_DATE;

Line: 294


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

Line: 296


        l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 325


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

Line: 327


        l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 445


    IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,p_old_LIMIT_ATTRS_rec.last_updated_by)
    THEN
        NULL;

Line: 450


    IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,p_old_LIMIT_ATTRS_rec.last_update_date)
    THEN
        NULL;

Line: 455


    IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,p_old_LIMIT_ATTRS_rec.last_update_login)
    THEN
        NULL;

Line: 505


    IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,p_old_LIMIT_ATTRS_rec.program_update_date)
    THEN
        NULL;

Line: 603


    IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_LIMIT_ATTRS_rec.last_updated_by := p_old_LIMIT_ATTRS_rec.last_updated_by;

Line: 607


    IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_LIMIT_ATTRS_rec.last_update_date := p_old_LIMIT_ATTRS_rec.last_update_date;

Line: 611


    IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_LIMIT_ATTRS_rec.last_update_login := p_old_LIMIT_ATTRS_rec.last_update_login;

Line: 651


    IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_LIMIT_ATTRS_rec.program_update_date := p_old_LIMIT_ATTRS_rec.program_update_date;

Line: 748


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

Line: 752


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

Line: 756


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

Line: 796


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

Line: 810


PROCEDURE Update_Row
(   p_LIMIT_ATTRS_rec               IN  QP_Limits_PUB.Limit_Attrs_Rec_Type
)
IS
l_check_active_flag VARCHAR2(1);

Line: 817


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

Line: 824


    UPDATE  QP_LIMIT_ATTRIBUTES
    SET     ATTRIBUTE1                     = p_LIMIT_ATTRS_rec.attribute1
    ,       ATTRIBUTE10                    = p_LIMIT_ATTRS_rec.attribute10
    ,       ATTRIBUTE11                    = p_LIMIT_ATTRS_rec.attribute11
    ,       ATTRIBUTE12                    = p_LIMIT_ATTRS_rec.attribute12
    ,       ATTRIBUTE13                    = p_LIMIT_ATTRS_rec.attribute13
    ,       ATTRIBUTE14                    = p_LIMIT_ATTRS_rec.attribute14
    ,       ATTRIBUTE15                    = p_LIMIT_ATTRS_rec.attribute15
    ,       ATTRIBUTE2                     = p_LIMIT_ATTRS_rec.attribute2
    ,       ATTRIBUTE3                     = p_LIMIT_ATTRS_rec.attribute3
    ,       ATTRIBUTE4                     = p_LIMIT_ATTRS_rec.attribute4
    ,       ATTRIBUTE5                     = p_LIMIT_ATTRS_rec.attribute5
    ,       ATTRIBUTE6                     = p_LIMIT_ATTRS_rec.attribute6
    ,       ATTRIBUTE7                     = p_LIMIT_ATTRS_rec.attribute7
    ,       ATTRIBUTE8                     = p_LIMIT_ATTRS_rec.attribute8
    ,       ATTRIBUTE9                     = p_LIMIT_ATTRS_rec.attribute9
    ,       COMPARISON_OPERATOR_CODE       = p_LIMIT_ATTRS_rec.comparison_operator_code
    ,       CONTEXT                        = p_LIMIT_ATTRS_rec.context
    ,       CREATED_BY                     = p_LIMIT_ATTRS_rec.created_by
    ,       CREATION_DATE                  = p_LIMIT_ATTRS_rec.creation_date
    ,       LAST_UPDATED_BY                = p_LIMIT_ATTRS_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_LIMIT_ATTRS_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_LIMIT_ATTRS_rec.last_update_login
    ,       LIMIT_ATTRIBUTE                = p_LIMIT_ATTRS_rec.limit_attribute
    ,       LIMIT_ATTRIBUTE_CONTEXT        = p_LIMIT_ATTRS_rec.limit_attribute_context
    ,       LIMIT_ATTRIBUTE_ID             = p_LIMIT_ATTRS_rec.limit_attribute_id
    ,       LIMIT_ATTRIBUTE_TYPE           = p_LIMIT_ATTRS_rec.limit_attribute_type
    ,       LIMIT_ATTR_DATATYPE            = p_LIMIT_ATTRS_rec.limit_attr_datatype
    ,       LIMIT_ATTR_VALUE               = p_LIMIT_ATTRS_rec.limit_attr_value
    ,       LIMIT_ID                       = p_LIMIT_ATTRS_rec.limit_id
    ,       PROGRAM_APPLICATION_ID         = p_LIMIT_ATTRS_rec.program_application_id
    ,       PROGRAM_ID                     = p_LIMIT_ATTRS_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_LIMIT_ATTRS_rec.program_update_date
    ,       REQUEST_ID                     = p_LIMIT_ATTRS_rec.request_id
    WHERE   LIMIT_ATTRIBUTE_ID = p_LIMIT_ATTRS_rec.limit_attribute_id
    ;

Line: 866


  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_ATTRS_rec.limit_attribute
  AND    a.prc_context_id=b.prc_context_id
  AND b.prc_context_type = p_LIMIT_ATTRS_rec.limit_attribute_type
  AND    b.prc_context_code=p_LIMIT_ATTRS_rec.limit_attribute_context);

Line: 886


            ,   'Update_Row'
            );

Line: 892


END Update_Row;

Line: 896


PROCEDURE Insert_Row
(   p_LIMIT_ATTRS_rec               IN  QP_Limits_PUB.Limit_Attrs_Rec_Type
)
IS
l_check_active_flag VARCHAR2(1);

Line: 904


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

Line: 910


    INSERT  INTO QP_LIMIT_ATTRIBUTES
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       COMPARISON_OPERATOR_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_ATTRIBUTE
    ,       LIMIT_ATTRIBUTE_CONTEXT
    ,       LIMIT_ATTRIBUTE_ID
    ,       LIMIT_ATTRIBUTE_TYPE
    ,       LIMIT_ATTR_DATATYPE
    ,       LIMIT_ATTR_VALUE
    ,       LIMIT_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    )
    VALUES
    (       p_LIMIT_ATTRS_rec.attribute1
    ,       p_LIMIT_ATTRS_rec.attribute10
    ,       p_LIMIT_ATTRS_rec.attribute11
    ,       p_LIMIT_ATTRS_rec.attribute12
    ,       p_LIMIT_ATTRS_rec.attribute13
    ,       p_LIMIT_ATTRS_rec.attribute14
    ,       p_LIMIT_ATTRS_rec.attribute15
    ,       p_LIMIT_ATTRS_rec.attribute2
    ,       p_LIMIT_ATTRS_rec.attribute3
    ,       p_LIMIT_ATTRS_rec.attribute4
    ,       p_LIMIT_ATTRS_rec.attribute5
    ,       p_LIMIT_ATTRS_rec.attribute6
    ,       p_LIMIT_ATTRS_rec.attribute7
    ,       p_LIMIT_ATTRS_rec.attribute8
    ,       p_LIMIT_ATTRS_rec.attribute9
    ,       p_LIMIT_ATTRS_rec.comparison_operator_code
    ,       p_LIMIT_ATTRS_rec.context
    ,       p_LIMIT_ATTRS_rec.created_by
    ,       p_LIMIT_ATTRS_rec.creation_date
    ,       p_LIMIT_ATTRS_rec.last_updated_by
    ,       p_LIMIT_ATTRS_rec.last_update_date
    ,       p_LIMIT_ATTRS_rec.last_update_login
    ,       p_LIMIT_ATTRS_rec.limit_attribute
    ,       p_LIMIT_ATTRS_rec.limit_attribute_context
    ,       p_LIMIT_ATTRS_rec.limit_attribute_id
    ,       p_LIMIT_ATTRS_rec.limit_attribute_type
    ,       p_LIMIT_ATTRS_rec.limit_attr_datatype
    ,       p_LIMIT_ATTRS_rec.limit_attr_value
    ,       p_LIMIT_ATTRS_rec.limit_id
    ,       p_LIMIT_ATTRS_rec.program_application_id
    ,       p_LIMIT_ATTRS_rec.program_id
    ,       p_LIMIT_ATTRS_rec.program_update_date
    ,       p_LIMIT_ATTRS_rec.request_id
    );

Line: 985


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_ATTRS_rec.limit_attribute
 AND    a.prc_context_id=b.prc_context_id
 AND b.prc_context_type = p_LIMIT_ATTRS_rec.limit_attribute_type
 AND    b.prc_context_code=p_LIMIT_ATTRS_rec.limit_attribute_context);

Line: 1006


            ,   'Insert_Row'
            );

Line: 1012


END Insert_Row;

Line: 1016


PROCEDURE Delete_Row
(   p_limit_attribute_id            IN  NUMBER
)
IS
BEGIN

    DELETE  FROM QP_LIMIT_ATTRIBUTES
    WHERE   LIMIT_ATTRIBUTE_ID = p_limit_attribute_id
    ;

Line: 1035


            ,   'Delete_Row'
            );

Line: 1041


END Delete_Row;

Line: 1072


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       COMPARISON_OPERATOR_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_ATTRIBUTE
    ,       LIMIT_ATTRIBUTE_CONTEXT
    ,       LIMIT_ATTRIBUTE_ID
    ,       LIMIT_ATTRIBUTE_TYPE
    ,       LIMIT_ATTR_DATATYPE
    ,       LIMIT_ATTR_VALUE
    ,       LIMIT_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    FROM    QP_LIMIT_ATTRIBUTES
    WHERE ( LIMIT_ATTRIBUTE_ID = p_limit_attribute_id
    )
    OR (    LIMIT_ID = p_limit_id
    );

Line: 1159


        l_LIMIT_ATTRS_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1160


        l_LIMIT_ATTRS_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1161


        l_LIMIT_ATTRS_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1171


        l_LIMIT_ATTRS_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1228


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       COMPARISON_OPERATOR_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMIT_ATTRIBUTE
    ,       LIMIT_ATTRIBUTE_CONTEXT
    ,       LIMIT_ATTRIBUTE_ID
    ,       LIMIT_ATTRIBUTE_TYPE
    ,       LIMIT_ATTR_DATATYPE
    ,       LIMIT_ATTR_VALUE
    ,       LIMIT_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    INTO    l_LIMIT_ATTRS_rec.attribute1
    ,       l_LIMIT_ATTRS_rec.attribute10
    ,       l_LIMIT_ATTRS_rec.attribute11
    ,       l_LIMIT_ATTRS_rec.attribute12
    ,       l_LIMIT_ATTRS_rec.attribute13
    ,       l_LIMIT_ATTRS_rec.attribute14
    ,       l_LIMIT_ATTRS_rec.attribute15
    ,       l_LIMIT_ATTRS_rec.attribute2
    ,       l_LIMIT_ATTRS_rec.attribute3
    ,       l_LIMIT_ATTRS_rec.attribute4
    ,       l_LIMIT_ATTRS_rec.attribute5
    ,       l_LIMIT_ATTRS_rec.attribute6
    ,       l_LIMIT_ATTRS_rec.attribute7
    ,       l_LIMIT_ATTRS_rec.attribute8
    ,       l_LIMIT_ATTRS_rec.attribute9
    ,       l_LIMIT_ATTRS_rec.comparison_operator_code
    ,       l_LIMIT_ATTRS_rec.context
    ,       l_LIMIT_ATTRS_rec.created_by
    ,       l_LIMIT_ATTRS_rec.creation_date
    ,       l_LIMIT_ATTRS_rec.last_updated_by
    ,       l_LIMIT_ATTRS_rec.last_update_date
    ,       l_LIMIT_ATTRS_rec.last_update_login
    ,       l_LIMIT_ATTRS_rec.limit_attribute
    ,       l_LIMIT_ATTRS_rec.limit_attribute_context
    ,       l_LIMIT_ATTRS_rec.limit_attribute_id
    ,       l_LIMIT_ATTRS_rec.limit_attribute_type
    ,       l_LIMIT_ATTRS_rec.limit_attr_datatype
    ,       l_LIMIT_ATTRS_rec.limit_attr_value
    ,       l_LIMIT_ATTRS_rec.limit_id
    ,       l_LIMIT_ATTRS_rec.program_application_id
    ,       l_LIMIT_ATTRS_rec.program_id
    ,       l_LIMIT_ATTRS_rec.program_update_date
    ,       l_LIMIT_ATTRS_rec.request_id
    FROM    QP_LIMIT_ATTRIBUTES
    WHERE   LIMIT_ATTRIBUTE_ID = p_LIMIT_ATTRS_rec.limit_attribute_id
        FOR UPDATE NOWAIT;

Line: 1338


    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,
                         l_LIMIT_ATTRS_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,
                         l_LIMIT_ATTRS_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,
                         l_LIMIT_ATTRS_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,
                         l_LIMIT_ATTRS_rec.limit_attribute)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,
                         l_LIMIT_ATTRS_rec.limit_attribute_context)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,
                         l_LIMIT_ATTRS_rec.limit_attribute_id)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,
                         l_LIMIT_ATTRS_rec.limit_attribute_type)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,
                         l_LIMIT_ATTRS_rec.limit_attr_datatype)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,
                         l_LIMIT_ATTRS_rec.limit_attr_value)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,
                         l_LIMIT_ATTRS_rec.limit_id)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,
                         l_LIMIT_ATTRS_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,
                         l_LIMIT_ATTRS_rec.program_id)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,
                         l_LIMIT_ATTRS_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,
                         l_LIMIT_ATTRS_rec.request_id)
    THEN

        --  Row has not changed. Set out parameter.

        x_LIMIT_ATTRS_rec              := l_LIMIT_ATTRS_rec;

Line: 1404


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

Line: 1613


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