APPS.AHL_FMP_MR_PUB SQL Statements

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

Line: 636

                AHL_FMP_MR_HEADER_PVT.UPDATE_MR_HEADER
                (
                        p_api_version           => 1.0,
                        p_init_msg_list         => FND_API.G_FALSE,
                        p_commit                => FND_API.G_FALSE,
                        p_validation_level      => p_validation_level,
                        p_default               => p_default,
                        p_module_type           => p_module_type,
                        x_return_status         => x_return_status,
                        x_msg_count             => x_msg_count,
                        x_msg_data              => x_msg_data,
                        p_x_mr_header_rec       => l_mr_header_rec
                );

Line: 662

                                'AHL_FMP_MR_HEADER_PVT.UPDATE_MR_HEADER successful'
                        );

Line: 1086

PROCEDURE Delete_Mr
(
        -- standard IN params
        p_api_version                   IN              NUMBER,
        p_init_msg_list                 IN              VARCHAR2        :=FND_API.G_FALSE,
        p_commit                        IN              VARCHAR2        :=FND_API.G_FALSE,
        p_validation_level              IN              NUMBER          :=FND_API.G_VALID_LEVEL_FULL,
        p_default                       IN              VARCHAR2        :=FND_API.G_FALSE,
        p_module_type                   IN              VARCHAR2        :=NULL,
        -- standard OUT params
        x_return_status                 OUT NOCOPY      VARCHAR2,
        x_msg_count                     OUT NOCOPY      NUMBER,
        x_msg_data                      OUT NOCOPY      VARCHAR2,
        -- procedure params
        p_mr_header_id                  IN              NUMBER,
        p_mr_title                      IN              VARCHAR2,
        p_mr_version_number             IN              NUMBER,
        p_mr_object_version             IN              NUMBER
)
IS
        -- 1.   Declare local variables
        l_api_name      CONSTANT        VARCHAR2(30)    := 'Delete_Mr';

Line: 1118

        SAVEPOINT Delete_Mr_SP;

Line: 1172

        AHL_FMP_MR_HEADER_PVT.DELETE_MR_HEADER
        (
                p_api_version           => 1.0,
                p_init_msg_list         => FND_API.G_FALSE,
                p_commit                => FND_API.G_FALSE,
                p_validation_level      => p_validation_level,
                p_default               => p_default,
                p_module_type           => p_module_type,
                x_return_status         => x_return_status,
                x_msg_count             => x_msg_count,
                x_msg_data              => x_msg_data,
                p_mr_header_id          => l_mr_header_id,
                p_OBJECT_VERSION_NUMBER => p_mr_object_version
        );

Line: 1229

                Rollback to Delete_Mr_SP;

Line: 1239

                Rollback to Delete_Mr_SP;

Line: 1249

                Rollback to Delete_Mr_SP;

Line: 1255

                                p_procedure_name        => 'Delete_Mr',
                                p_error_text            => SUBSTR(SQLERRM,1,240)
                        );

Line: 1266

END Delete_Mr;