DBA Data[Home] [Help]

APPS.OKC_RULE_DEF_PUB SQL Statements

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

Line: 16

    l_rdsv_rec.last_updated_by       := p_rdsv_rec1.last_updated_by;
Line: 17

    l_rdsv_rec.last_update_date      := p_rdsv_rec1.last_update_date;
Line: 18

    l_rdsv_rec.last_update_login     := p_rdsv_rec1.last_update_login;
Line: 38

    l_rgrv_rec.last_updated_by       := p_rgrv_rec1.last_updated_by;
Line: 39

    l_rgrv_rec.last_update_date      := p_rgrv_rec1.last_update_date;
Line: 40

    l_rgrv_rec.last_update_login     := p_rgrv_rec1.last_update_login;
Line: 193

  PROCEDURE update_rg_def_rule(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_rgrv_rec                     IN rgrv_rec_type,
     x_rgrv_rec                     OUT NOCOPY rgrv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 202

     l_api_name                     CONSTANT VARCHAR2(30) := 'update_rg_def_rule';
Line: 224

     OKC_RULE_DEF_PVT.update_rg_def_rule(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => x_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_rgrv_rec            => l_rgrv_rec,
                         x_rgrv_rec            => x_rgrv_rec);
Line: 274

  END update_rg_def_rule;
Line: 279

  PROCEDURE update_rg_def_rule(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_rgrv_tbl                     IN rgrv_tbl_type,
     x_rgrv_tbl                     OUT NOCOPY rgrv_tbl_type) IS

     i				    NUMBER := 0;
Line: 295

       update_rg_def_rule(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => l_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_rgrv_rec            => p_rgrv_tbl(i),
                         x_rgrv_rec            => x_rgrv_tbl(i));
Line: 326

  END update_rg_def_rule;
Line: 331

  PROCEDURE delete_rg_def_rule(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_rgrv_rec                     IN rgrv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 339

     l_api_name                     CONSTANT VARCHAR2(30) := 'delete_rg_def_rule';
Line: 360

     OKC_RULE_DEF_PVT.delete_rg_def_rule(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => x_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_rgrv_rec            => p_rgrv_rec);
Line: 409

  END delete_rg_def_rule;
Line: 414

  PROCEDURE delete_rg_def_rule(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_rgrv_tbl                     IN rgrv_tbl_type) IS

     i				    NUMBER := 0;
Line: 429

       delete_rg_def_rule(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => l_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_rgrv_rec            => p_rgrv_tbl(i));
Line: 459

  END delete_rg_def_rule;
Line: 804

  PROCEDURE update_rd_source(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_rdsv_rec                     IN rdsv_rec_type,
     x_rdsv_rec                     OUT NOCOPY rdsv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 813

     l_api_name                     CONSTANT VARCHAR2(30) := 'update_rd_source';
Line: 835

     OKC_RULE_DEF_PVT.update_rd_source(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => x_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_rdsv_rec            => l_rdsv_rec,
                         x_rdsv_rec            => x_rdsv_rec);
Line: 884

  END update_rd_source;
Line: 889

  PROCEDURE update_rd_source(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_rdsv_tbl                     IN rdsv_tbl_type,
     x_rdsv_tbl                     OUT NOCOPY rdsv_tbl_type) IS

     i				    NUMBER := 0;
Line: 905

       update_rd_source(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => l_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_rdsv_rec            => p_rdsv_tbl(i),
                         x_rdsv_rec            => x_rdsv_tbl(i));
Line: 936

  END update_rd_source;
Line: 941

  PROCEDURE delete_rd_source(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_rdsv_rec                     IN rdsv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 949

     l_api_name                     CONSTANT VARCHAR2(30) := 'delete_rd_source';
Line: 970

     OKC_RULE_DEF_PVT.delete_rd_source(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => x_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_rdsv_rec            => p_rdsv_rec);
Line: 1018

  END delete_rd_source;
Line: 1023

  PROCEDURE delete_rd_source(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_rdsv_tbl                     IN rdsv_tbl_type) IS

     i				    NUMBER := 0;
Line: 1038

       delete_rd_source(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => l_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_rdsv_rec            => p_rdsv_tbl(i));
Line: 1068

  END delete_rd_source;