DBA Data[Home] [Help]

APPS.QP_QP_FORM_RQT SQL Statements

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

Line: 441

        l_RQT_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
Line: 751

,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
)
IS
l_RQT_rec                     QP_Attr_Map_PUB.Rqt_Rec_Type;
Line: 805

        l_RQT_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
Line: 847

    x_last_update_date             := l_x_RQT_rec.last_update_date;
Line: 848

    x_last_updated_by              := l_x_RQT_rec.last_updated_by;
Line: 849

    x_last_update_login            := l_x_RQT_rec.last_update_login;
Line: 920

PROCEDURE Delete_Row
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_request_type_code             IN  VARCHAR2
)
IS
l_RQT_rec                     QP_Attr_Map_PUB.Rqt_Rec_Type;
Line: 968

    l_RQT_rec.operation := QP_GLOBALS.G_OPR_DELETE;
Line: 1047

            ,   'Delete_Row'
            );
Line: 1058

END Delete_Row;
Line: 1207

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_line_level_global_struct      IN  VARCHAR2
,   p_line_level_view_name          IN  VARCHAR2
,   p_order_level_global_struct     IN  VARCHAR2
,   p_order_level_view_name         IN  VARCHAR2
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_pte_code                      IN  VARCHAR2
,   p_request_type_code             IN  VARCHAR2
,   p_request_type_desc             IN  VARCHAR2
--**,   p_row_id                        IN  ROWID
)
IS
l_return_status               VARCHAR2(1);
Line: 1260

    l_RQT_rec.last_updated_by      := p_last_updated_by;
Line: 1261

    l_RQT_rec.last_update_date     := p_last_update_date;
Line: 1262

    l_RQT_rec.last_update_login    := p_last_update_login;
Line: 1269

    l_RQT_rec.program_update_date  := p_program_update_date;