APPS.QP_QP_FORM_LIMITS SQL Statements

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

Line: 466

        l_LIMITS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 832

,   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_LIMITS_rec                  QP_Limits_PUB.Limits_Rec_Type;

Line: 878

        l_LIMITS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 911

    x_last_update_date             := l_x_LIMITS_rec.last_update_date;

Line: 912

    x_last_updated_by              := l_x_LIMITS_rec.last_updated_by;

Line: 913

    x_last_update_login            := l_x_LIMITS_rec.last_update_login;

Line: 984

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_limit_id                      IN  NUMBER
)
IS
l_LIMITS_rec                  QP_Limits_PUB.Limits_Rec_Type;

Line: 1025

    l_LIMITS_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1097

            ,   'Delete_Row'
            );

Line: 1108

END Delete_Row;

Line: 1361

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_limit_exceed_action_code      IN  VARCHAR2
,   p_limit_hold_flag               IN  VARCHAR2
,   p_limit_id                      IN  NUMBER
,   p_limit_level_code              IN  VARCHAR2
,   p_limit_number                  IN  NUMBER
,   p_list_header_id                IN  NUMBER
,   p_list_line_id                  IN  NUMBER
,   p_multival_attr1_type           IN  VARCHAR2
,   p_multival_attr1_context        IN  VARCHAR2
,   p_multival_attribute1           IN  VARCHAR2
,   p_multival_attr1_datatype       IN  VARCHAR2
,   p_multival_attr2_type           IN  VARCHAR2
,   p_multival_attr2_context        IN  VARCHAR2
,   p_multival_attribute2           IN  VARCHAR2
,   p_multival_attr2_datatype       IN  VARCHAR2
,   p_organization_flag             IN  VARCHAR2
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_request_id                    IN  NUMBER
)
IS
l_return_status               VARCHAR2(1);

Line: 1417

    l_LIMITS_rec.last_updated_by   := p_last_updated_by;

Line: 1418

    l_LIMITS_rec.last_update_date  := p_last_update_date;

Line: 1419

    l_LIMITS_rec.last_update_login := p_last_update_login;

Line: 1438

    l_LIMITS_rec.program_update_date     := p_program_update_date;