APPS.OKC_RULE_DEF_PVT SQL Statements

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

Line: 6

  G_EXCEPTION_CANNOT_DELETE    EXCEPTION;

Line: 7

  G_CANNOT_DELETE_MASTER       CONSTANT VARCHAR2(200) := 'OKC_CANNOT_DELETE_MASTER';

Line: 8

  G_CANNOT_DELETE_RULE_DEF     CONSTANT VARCHAR2(200) := 'OKC_CANNOT_DELETE_RULE_DEF';

Line: 22

     OKC_RGR_PVT.insert_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_rgrv_rec,
                         x_rgrv_rec);

Line: 35

  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
  BEGIN
     OKC_RGR_PVT.update_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_rgrv_rec,
                         x_rgrv_rec);

Line: 52

  END update_rg_def_rule;

Line: 57

  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_dummy_var VARCHAR(1) := NULL;

Line: 68

      SELECT /*+ FIRST_ROWS */
         'x'
        FROM OKC_RULES_B rul,
             OKC_RULE_GROUPS_B rgp
       WHERE rul.rule_information_category = p_rgrv_rec.rdf_code
         AND rul.rgp_id                    = rgp.id
         AND rgp.rgd_code                  = p_rgrv_rec.rgd_code
         AND rownum < 2;

Line: 83

      RAISE G_EXCEPTION_CANNOT_DELETE;

Line: 86

    OKC_RGR_PVT.delete_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_rgrv_rec);

Line: 94

  WHEN G_EXCEPTION_CANNOT_DELETE THEN
    -- store SQL error message on message stack
    OKC_API.SET_MESSAGE(
      p_app_name        => G_APP_NAME,
      p_msg_name        => G_CANNOT_DELETE_RULE_DEF);

Line: 116

  END delete_rg_def_rule;

Line: 170

     OKC_RDS_PVT.insert_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_rdsv_rec,
                         x_rdsv_rec);

Line: 183

  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
  BEGIN
     OKC_RDS_PVT.update_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_rdsv_rec,
                         x_rdsv_rec);

Line: 200

  END update_rd_source;

Line: 205

  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
  BEGIN
     OKC_RDS_PVT.delete_row(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_rdsv_rec);

Line: 220

  END delete_rd_source;