APPS.QP_QP_FORM_FNA SQL Statements

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

Line: 438

        l_FNA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 722

,   x_last_update_date              OUT NOCOPY DATE
,   x_last_updated_by               OUT NOCOPY NUMBER
,   x_last_update_login             OUT NOCOPY NUMBER
)
IS
l_FNA_rec                     QP_Attr_Map_PUB.Fna_Rec_Type;

Line: 776

        l_FNA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 818

    x_last_update_date             := l_x_FNA_rec.last_update_date;

Line: 819

    x_last_updated_by              := l_x_FNA_rec.last_updated_by;

Line: 820

    x_last_update_login            := l_x_FNA_rec.last_update_login;

Line: 891

PROCEDURE Delete_Row
(   x_return_status                 OUT NOCOPY VARCHAR2
,   x_msg_count                     OUT NOCOPY NUMBER
,   x_msg_data                      OUT NOCOPY VARCHAR2
,   p_pte_sourcesystem_fnarea_id    IN  NUMBER
)
IS
l_FNA_rec                     QP_Attr_Map_PUB.Fna_Rec_Type;

Line: 939

    l_FNA_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1018

            ,   'Delete_Row'
            );

Line: 1029

END Delete_Row;

Line: 1179

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_pte_sourcesystem_fnarea_id    IN  NUMBER
,   p_pte_source_system_id          IN  NUMBER
,   p_request_id                    IN  NUMBER
,   p_seeded_flag                   IN  VARCHAR2
)
IS
l_return_status               VARCHAR2(1);

Line: 1229

    l_FNA_rec.last_updated_by      := p_last_updated_by;

Line: 1230

    l_FNA_rec.last_update_date     := p_last_update_date;

Line: 1231

    l_FNA_rec.last_update_login    := p_last_update_login;

Line: 1234

    l_FNA_rec.program_update_date  := p_program_update_date;