APPS.QP_QP_FORM_SEG SQL Statements

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

Line: 475

        l_SEG_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 853

,   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_SEG_rec                     QP_Attributes_PUB.Seg_Rec_Type;

Line: 926

        l_SEG_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 964

    x_last_update_date             := l_x_SEG_rec.last_update_date;

Line: 965

    x_last_updated_by              := l_x_SEG_rec.last_updated_by;

Line: 966

    x_last_update_login            := l_x_SEG_rec.last_update_login;

Line: 1037

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_segment_id                    IN  NUMBER
)
IS
l_SEG_rec                     QP_Attributes_PUB.Seg_Rec_Type;

Line: 1077

    l_SEG_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1152

            ,   'Delete_Row'
            );

Line: 1163

END Delete_Row;

Line: 1300

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_prc_context_id                IN  NUMBER
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_seeded_flag                   IN  VARCHAR2
,   p_seeded_format_type            IN  VARCHAR2
,   p_seeded_precedence             IN  NUMBER
,   p_seeded_segment_name           IN  VARCHAR2
,   p_seeded_description     	    IN  VARCHAR2
,   p_seeded_valueset_id            IN  NUMBER
,   p_segment_code               IN  VARCHAR2
,   p_segment_id                    IN  NUMBER
,   p_application_id                IN  NUMBER
,   p_segment_mapping_column        IN  VARCHAR2
,   p_user_format_type              IN  VARCHAR2
,   p_user_precedence               IN  NUMBER
,   p_user_segment_name             IN  VARCHAR2
,   p_user_description		    IN  VARCHAR2
,   p_user_valueset_id              IN  NUMBER
,   p_required_flag		    IN  VARCHAR2
,   p_party_hierarchy_enabled_flag       IN  VARCHAR2    -- Added for TCA
)
IS
l_return_status               VARCHAR2(1);

Line: 1355

    l_SEG_rec.last_updated_by      := p_last_updated_by;

Line: 1356

    l_SEG_rec.last_update_date     := p_last_update_date;

Line: 1357

    l_SEG_rec.last_update_login    := p_last_update_login;

Line: 1361

    l_SEG_rec.program_update_date  := p_program_update_date;