APPS.OKL_OPT_RUL_TMP_PVT SQL Statements

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

Line: 4

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovd_id					   IN NUMBER,
    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: 32

		   SELECT rgr_rgd_code,
	   	   		  rgr_rdf_code
		   FROM  OKL_OPT_RULES	ORL,
	  	   		 OKL_OPV_RULES	OVD
		   WHERE OVD.ORL_ID = ORL.ID
		   AND 	 OVD.ID = p_in_id;

Line: 43

  SAVEPOINT Opt_Rul_Tmp_insert;

Line: 102

    Okc_Rul_Pvt.INSERT_ROW(
    					   p_api_version,
    					   p_init_msg_list,
    					   x_return_status,
    					   x_msg_count,
    					   x_msg_data,
    					   l_rulv_rec,
    					   x_rulv_rec);

Line: 116

    Okl_Ovd_Rul_Tmls_Pub.insert_ovd_rul_tmls(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_ovtv_rec      => l_ovtv_rec,
                              		 	   	 x_ovtv_rec      => x_ovtv_rec);

Line: 125

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 133

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 141

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 145

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_Opt_Rul_Tmp_PVT','insert_Opt_Rul_Tmp');

Line: 149

  END insert_row;

Line: 152

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovd_id					   IN NUMBER,
    p_rgrv_tbl                     IN rgrv_tbl_type,
    x_rgrv_tbl                     OUT NOCOPY rgrv_tbl_type)
  IS

  p_rgrv_rec						rgrv_rec_type;

Line: 170

  	 SAVEPOINT Opt_Rul_Tmp_insert;

Line: 176

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

Line: 189

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 197

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 205

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 209

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_Opt_Rul_Tmp_PVT','insert_Opt_Rul_Tmp');

Line: 213

  END insert_row;

Line: 216

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    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
  	   NULL;

Line: 227

  END update_row;

Line: 230

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    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
  BEGIN
  	   NULL;

Line: 241

  END update_row;

Line: 244

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    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
  BEGIN
  	   NULL;

Line: 254

  END delete_row;

Line: 257

PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    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
  BEGIN
  	   NULL;

Line: 267

  END delete_row;