DBA Data[Home] [Help]

APPS.QP_RQT_UTIL SQL Statements

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

Line: 146

        IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,p_old_RQT_rec.last_updated_by)
        THEN
            l_index := l_index + 1;
Line: 149

            l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATED_BY;
Line: 152

        IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_date,p_old_RQT_rec.last_update_date)
        THEN
            l_index := l_index + 1;
Line: 155

            l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATE_DATE;
Line: 158

        IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_login,p_old_RQT_rec.last_update_login)
        THEN
            l_index := l_index + 1;
Line: 161

            l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATE_LOGIN;
Line: 200

        IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_update_date,p_old_RQT_rec.program_update_date)
        THEN
            l_index := l_index + 1;
Line: 203

            l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 287

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

        l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATED_BY;
Line: 290

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

        l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATE_DATE;
Line: 293

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

        l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATE_LOGIN;
Line: 314

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

        l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 443

    IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,p_old_RQT_rec.last_updated_by)
    THEN
        NULL;
Line: 448

    IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_date,p_old_RQT_rec.last_update_date)
    THEN
        NULL;
Line: 453

    IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_login,p_old_RQT_rec.last_update_login)
    THEN
        NULL;
Line: 488

    IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_update_date,p_old_RQT_rec.program_update_date)
    THEN
        NULL;
Line: 601

    IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_RQT_rec.last_updated_by := p_old_RQT_rec.last_updated_by;
Line: 605

    IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_RQT_rec.last_update_date := p_old_RQT_rec.last_update_date;
Line: 609

    IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_RQT_rec.last_update_login := p_old_RQT_rec.last_update_login;
Line: 637

    IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_RQT_rec.program_update_date := p_old_RQT_rec.program_update_date;
Line: 746

    IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_RQT_rec.last_updated_by := NULL;
Line: 750

    IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_RQT_rec.last_update_date := NULL;
Line: 754

    IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_RQT_rec.last_update_login := NULL;
Line: 782

    IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_RQT_rec.program_update_date := NULL;
Line: 808

PROCEDURE Update_Row
(   p_RQT_rec                       IN  QP_Attr_Map_PUB.Rqt_Rec_Type
)
IS
BEGIN

    UPDATE  QP_PTE_REQUEST_TYPES_b
    SET     ATTRIBUTE1                     = p_RQT_rec.attribute1
    ,       ATTRIBUTE10                    = p_RQT_rec.attribute10
    ,       ATTRIBUTE11                    = p_RQT_rec.attribute11
    ,       ATTRIBUTE12                    = p_RQT_rec.attribute12
    ,       ATTRIBUTE13                    = p_RQT_rec.attribute13
    ,       ATTRIBUTE14                    = p_RQT_rec.attribute14
    ,       ATTRIBUTE15                    = p_RQT_rec.attribute15
    ,       ATTRIBUTE2                     = p_RQT_rec.attribute2
    ,       ATTRIBUTE3                     = p_RQT_rec.attribute3
    ,       ATTRIBUTE4                     = p_RQT_rec.attribute4
    ,       ATTRIBUTE5                     = p_RQT_rec.attribute5
    ,       ATTRIBUTE6                     = p_RQT_rec.attribute6
    ,       ATTRIBUTE7                     = p_RQT_rec.attribute7
    ,       ATTRIBUTE8                     = p_RQT_rec.attribute8
    ,       ATTRIBUTE9                     = p_RQT_rec.attribute9
    ,       CONTEXT                        = p_RQT_rec.context
    ,       CREATED_BY                     = p_RQT_rec.created_by
    ,       CREATION_DATE                  = p_RQT_rec.creation_date
    ,       ENABLED_FLAG                   = p_RQT_rec.enabled_flag
    ,       LAST_UPDATED_BY                = p_RQT_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_RQT_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_RQT_rec.last_update_login
    ,       LINE_LEVEL_GLOBAL_STRUCT       = p_RQT_rec.line_level_global_struct
    ,       LINE_LEVEL_VIEW_NAME           = p_RQT_rec.line_level_view_name
    ,       ORDER_LEVEL_GLOBAL_STRUCT      = p_RQT_rec.order_level_global_struct
    ,       ORDER_LEVEL_VIEW_NAME          = p_RQT_rec.order_level_view_name
    ,       PROGRAM_APPLICATION_ID         = p_RQT_rec.program_application_id
    ,       PROGRAM_ID                     = p_RQT_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_RQT_rec.program_update_date
    ,       PTE_CODE                       = p_RQT_rec.pte_code
    ,       REQUEST_TYPE_CODE              = p_RQT_rec.request_type_code
    WHERE   REQUEST_TYPE_CODE = p_RQT_rec.request_type_code ;
Line: 849

    UPDATE  QP_PTE_REQUEST_TYPES_tl
    SET     CREATED_BY                     = p_RQT_rec.created_by
    ,       CREATION_DATE                  = p_RQT_rec.creation_date
    ,       LAST_UPDATED_BY                = p_RQT_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_RQT_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_RQT_rec.last_update_login
    ,       REQUEST_TYPE_DESC              = p_RQT_rec.request_type_desc
    ,       SOURCE_LANG                    = userenv('LANG')
    WHERE   REQUEST_TYPE_CODE = p_RQT_rec.request_type_code and
            userenv('LANG') in (LANGUAGE, SOURCE_LANG);
Line: 861

    UPDATE  QP_PTE_REQUEST_TYPES_V
    SET     ATTRIBUTE1                     = p_RQT_rec.attribute1
    ,       ATTRIBUTE10                    = p_RQT_rec.attribute10
    ,       ATTRIBUTE11                    = p_RQT_rec.attribute11
    ,       ATTRIBUTE12                    = p_RQT_rec.attribute12
    ,       ATTRIBUTE13                    = p_RQT_rec.attribute13
    ,       ATTRIBUTE14                    = p_RQT_rec.attribute14
    ,       ATTRIBUTE15                    = p_RQT_rec.attribute15
    ,       ATTRIBUTE2                     = p_RQT_rec.attribute2
    ,       ATTRIBUTE3                     = p_RQT_rec.attribute3
    ,       ATTRIBUTE4                     = p_RQT_rec.attribute4
    ,       ATTRIBUTE5                     = p_RQT_rec.attribute5
    ,       ATTRIBUTE6                     = p_RQT_rec.attribute6
    ,       ATTRIBUTE7                     = p_RQT_rec.attribute7
    ,       ATTRIBUTE8                     = p_RQT_rec.attribute8
    ,       ATTRIBUTE9                     = p_RQT_rec.attribute9
    ,       CONTEXT                        = p_RQT_rec.context
    ,       CREATED_BY                     = p_RQT_rec.created_by
    ,       CREATION_DATE                  = p_RQT_rec.creation_date
    ,       ENABLED_FLAG                   = p_RQT_rec.enabled_flag
    ,       LAST_UPDATED_BY                = p_RQT_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_RQT_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_RQT_rec.last_update_login
    ,       LINE_LEVEL_GLOBAL_STRUCT       = p_RQT_rec.line_level_global_struct
    ,       LINE_LEVEL_VIEW_NAME           = p_RQT_rec.line_level_view_name
    ,       ORDER_LEVEL_GLOBAL_STRUCT      = p_RQT_rec.order_level_global_struct
    ,       ORDER_LEVEL_VIEW_NAME          = p_RQT_rec.order_level_view_name
    ,       PROGRAM_APPLICATION_ID         = p_RQT_rec.program_application_id
    ,       PROGRAM_ID                     = p_RQT_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_RQT_rec.program_update_date
    ,       PTE_CODE                       = p_RQT_rec.pte_code
    ,       REQUEST_TYPE_CODE              = p_RQT_rec.request_type_code
    ,       REQUEST_TYPE_DESC              = p_RQT_rec.request_type_desc
    ,       ROW_ID                         = p_RQT_rec.row_id
    WHERE   REQUEST_TYPE_CODE = p_RQT_rec.request_type_code
    ;
Line: 907

            ,   'Update_Row'
            );
Line: 913

END Update_Row;
Line: 917

PROCEDURE Insert_Row
(   p_RQT_rec                       IN  QP_Attr_Map_PUB.Rqt_Rec_Type
)
IS
BEGIN

/*
    INSERT  INTO QP_PTE_REQUEST_TYPES_V
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_LEVEL_GLOBAL_STRUCT
    ,       LINE_LEVEL_VIEW_NAME
    ,       ORDER_LEVEL_GLOBAL_STRUCT
    ,       ORDER_LEVEL_VIEW_NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       REQUEST_TYPE_CODE
    ,       REQUEST_TYPE_DESC
    ,       ROW_ID
    )
    VALUES
    (       p_RQT_rec.attribute1
    ,       p_RQT_rec.attribute10
    ,       p_RQT_rec.attribute11
    ,       p_RQT_rec.attribute12
    ,       p_RQT_rec.attribute13
    ,       p_RQT_rec.attribute14
    ,       p_RQT_rec.attribute15
    ,       p_RQT_rec.attribute2
    ,       p_RQT_rec.attribute3
    ,       p_RQT_rec.attribute4
    ,       p_RQT_rec.attribute5
    ,       p_RQT_rec.attribute6
    ,       p_RQT_rec.attribute7
    ,       p_RQT_rec.attribute8
    ,       p_RQT_rec.attribute9
    ,       p_RQT_rec.context
    ,       p_RQT_rec.created_by
    ,       p_RQT_rec.creation_date
    ,       p_RQT_rec.enabled_flag
    ,       p_RQT_rec.last_updated_by
    ,       p_RQT_rec.last_update_date
    ,       p_RQT_rec.last_update_login
    ,       p_RQT_rec.line_level_global_struct
    ,       p_RQT_rec.line_level_view_name
    ,       p_RQT_rec.order_level_global_struct
    ,       p_RQT_rec.order_level_view_name
    ,       p_RQT_rec.program_application_id
    ,       p_RQT_rec.program_id
    ,       p_RQT_rec.program_update_date
    ,       p_RQT_rec.pte_code
    ,       p_RQT_rec.request_type_code
    ,       p_RQT_rec.request_type_desc
    ,       p_RQT_rec.row_id
    );
Line: 996

    INSERT  INTO QP_PTE_REQUEST_TYPES_B
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_LEVEL_GLOBAL_STRUCT
    ,       LINE_LEVEL_VIEW_NAME
    ,       ORDER_LEVEL_GLOBAL_STRUCT
    ,       ORDER_LEVEL_VIEW_NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       REQUEST_TYPE_CODE
    )
    VALUES
    (       p_RQT_rec.attribute1
    ,       p_RQT_rec.attribute10
    ,       p_RQT_rec.attribute11
    ,       p_RQT_rec.attribute12
    ,       p_RQT_rec.attribute13
    ,       p_RQT_rec.attribute14
    ,       p_RQT_rec.attribute15
    ,       p_RQT_rec.attribute2
    ,       p_RQT_rec.attribute3
    ,       p_RQT_rec.attribute4
    ,       p_RQT_rec.attribute5
    ,       p_RQT_rec.attribute6
    ,       p_RQT_rec.attribute7
    ,       p_RQT_rec.attribute8
    ,       p_RQT_rec.attribute9
    ,       p_RQT_rec.context
    ,       p_RQT_rec.created_by
    ,       p_RQT_rec.creation_date
    ,       p_RQT_rec.enabled_flag
    ,       p_RQT_rec.last_updated_by
    ,       p_RQT_rec.last_update_date
    ,       p_RQT_rec.last_update_login
    ,       p_RQT_rec.line_level_global_struct
    ,       p_RQT_rec.line_level_view_name
    ,       p_RQT_rec.order_level_global_struct
    ,       p_RQT_rec.order_level_view_name
    ,       p_RQT_rec.program_application_id
    ,       p_RQT_rec.program_id
    ,       p_RQT_rec.program_update_date
    ,       p_RQT_rec.pte_code
    ,       p_RQT_rec.request_type_code);
Line: 1063

    INSERT  INTO QP_PTE_REQUEST_TYPES_tl
    (       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       REQUEST_TYPE_CODE
    ,       REQUEST_TYPE_DESC
    ,       language
    ,       source_lang
    )
    SELECT  p_RQT_rec.created_by
    ,       p_RQT_rec.creation_date
    ,       p_RQT_rec.last_updated_by
    ,       p_RQT_rec.last_update_date
    ,       p_RQT_rec.last_update_login
    ,       p_RQT_rec.request_type_code
    ,       p_RQT_rec.request_type_desc
    ,       L.language_code
    ,       userenv('LANG')
    from  FND_LANGUAGES  L
    where  L.INSTALLED_FLAG in ('I', 'B')
    and    not exists
           ( select NULL
             from  qp_pte_request_types_tl T
             where  T.request_type_code = p_RQT_rec.request_type_code
             and  T.LANGUAGE = L.LANGUAGE_CODE );
Line: 1092

    QP_Param_Util.Insert_Parameter_Values('REQ',
                                           p_RQT_rec.request_type_code);
Line: 1103

            ,   'Insert_Row'
            );
Line: 1109

END Insert_Row;
Line: 1113

PROCEDURE Delete_Row
(   p_request_type_code             IN  VARCHAR2
)
IS
BEGIN

    DELETE  FROM QP_PTE_REQUEST_TYPES_TL
    WHERE   REQUEST_TYPE_CODE = p_request_type_code;
Line: 1122

    DELETE  FROM QP_PTE_REQUEST_TYPES_B
    WHERE   REQUEST_TYPE_CODE = p_request_type_code;
Line: 1126

    QP_Param_Util.Delete_Parameter_Values('REQ',
                                           p_request_type_code);
Line: 1137

            ,   'Delete_Row'
            );
Line: 1143

END Delete_Row;
Line: 1174

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_LEVEL_GLOBAL_STRUCT
    ,       LINE_LEVEL_VIEW_NAME
    ,       ORDER_LEVEL_GLOBAL_STRUCT
    ,       ORDER_LEVEL_VIEW_NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       REQUEST_TYPE_CODE
    ,       REQUEST_TYPE_DESC
    --**,       ROW_ID
    FROM    QP_PTE_REQUEST_TYPES_V
    WHERE ( REQUEST_TYPE_CODE = p_request_type_code
    )
    --**OR (    LOOKUP_CODE = p_lookup_code
    OR (    pte_code = p_lookup_code
    );
Line: 1262

        l_RQT_rec.last_updated_by      := l_implicit_rec.LAST_UPDATED_BY;
Line: 1263

        l_RQT_rec.last_update_date     := l_implicit_rec.LAST_UPDATE_DATE;
Line: 1264

        l_RQT_rec.last_update_login    := l_implicit_rec.LAST_UPDATE_LOGIN;
Line: 1271

        l_RQT_rec.program_update_date  := l_implicit_rec.PROGRAM_UPDATE_DATE;
Line: 1331

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_LEVEL_GLOBAL_STRUCT
    ,       LINE_LEVEL_VIEW_NAME
    ,       ORDER_LEVEL_GLOBAL_STRUCT
    ,       ORDER_LEVEL_VIEW_NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       REQUEST_TYPE_CODE
    ,       REQUEST_TYPE_DESC
    --**,       ROW_ID
    INTO    l_RQT_rec.attribute1
    ,       l_RQT_rec.attribute10
    ,       l_RQT_rec.attribute11
    ,       l_RQT_rec.attribute12
    ,       l_RQT_rec.attribute13
    ,       l_RQT_rec.attribute14
    ,       l_RQT_rec.attribute15
    ,       l_RQT_rec.attribute2
    ,       l_RQT_rec.attribute3
    ,       l_RQT_rec.attribute4
    ,       l_RQT_rec.attribute5
    ,       l_RQT_rec.attribute6
    ,       l_RQT_rec.attribute7
    ,       l_RQT_rec.attribute8
    ,       l_RQT_rec.attribute9
    ,       l_RQT_rec.context
    ,       l_RQT_rec.created_by
    ,       l_RQT_rec.creation_date
    ,       l_RQT_rec.enabled_flag
    ,       l_RQT_rec.last_updated_by
    ,       l_RQT_rec.last_update_date
    ,       l_RQT_rec.last_update_login
    ,       l_RQT_rec.line_level_global_struct
    ,       l_RQT_rec.line_level_view_name
    ,       l_RQT_rec.order_level_global_struct
    ,       l_RQT_rec.order_level_view_name
    ,       l_RQT_rec.program_application_id
    ,       l_RQT_rec.program_id
    ,       l_RQT_rec.program_update_date
    ,       l_RQT_rec.pte_code
    ,       l_RQT_rec.request_type_code
    ,       l_RQT_rec.request_type_desc
    --**,       l_RQT_rec.row_id
    FROM    QP_PTE_REQUEST_TYPES_V
    WHERE   REQUEST_TYPE_CODE = p_RQT_rec.request_type_code
        FOR UPDATE NOWAIT;
Line: 1441

    AND QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,
                         l_RQT_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_RQT_rec.last_update_date,
                         l_RQT_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_RQT_rec.last_update_login,
                         l_RQT_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,
                         l_RQT_rec.line_level_global_struct)
    AND QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,
                         l_RQT_rec.line_level_view_name)
    AND QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,
                         l_RQT_rec.order_level_global_struct)
    AND QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,
                         l_RQT_rec.order_level_view_name)
    AND QP_GLOBALS.Equal(p_RQT_rec.program_application_id,
                         l_RQT_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_RQT_rec.program_id,
                         l_RQT_rec.program_id)
    AND QP_GLOBALS.Equal(p_RQT_rec.program_update_date,
                         l_RQT_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_RQT_rec.pte_code,
                         l_RQT_rec.pte_code)
    AND QP_GLOBALS.Equal(p_RQT_rec.request_type_code,
                         l_RQT_rec.request_type_code)
    AND QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,
                         l_RQT_rec.request_type_desc)
    --**AND QP_GLOBALS.Equal(p_RQT_rec.row_id,
    --**                     l_RQT_rec.row_id)
    THEN

        --  Row has not changed. Set out parameter.

        x_RQT_rec                      := l_RQT_rec;
Line: 1507

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