APPS.OKE_RELATED_ENTITIES_PUB SQL Statements

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

Line: 48

	OKE_RLE_PVT.Insert_Row(
	    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_rle_rec		=> l_rle_rec,
            x_rle_rec		=> x_rle_rec);

Line: 132

    OKE_RLE_PVT.Insert_Row(
      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_rle_tbl		=> p_rle_tbl,
      x_rle_tbl		=> x_rle_tbl);

Line: 180

  PROCEDURE update_related_entity(
    p_api_version       IN NUMBER,
    p_init_msg_list     IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status     OUT NOCOPY VARCHAR2,
    x_msg_count         OUT NOCOPY NUMBER,
    x_msg_data          OUT NOCOPY VARCHAR2,
    p_rle_rec		IN oke_rle_pvt.rle_rec_type,
    x_rle_rec		OUT NOCOPY oke_rle_pvt.rle_rec_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';

Line: 214

    OKE_RLE_PVT.Update_Row(
      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_rle_rec			=> p_rle_rec,
      x_rle_rec			=> x_rle_rec);

Line: 261

  END update_related_entity;

Line: 264

 PROCEDURE update_related_entity(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rle_tbl			   IN  oke_rle_pvt.rle_tbl_type,
    x_rle_tbl			   OUT NOCOPY  oke_rle_pvt.rle_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';

Line: 299

    OKE_RLE_PVT.Update_Row(
	 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_rle_tbl			=> p_rle_tbl,
      x_rle_tbl			=> x_rle_tbl);

Line: 347

  END update_related_entity;

Line: 522

  PROCEDURE delete_related_entity(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rle_rec			   IN oke_rle_pvt.rle_rec_type) IS

    l_rle_rec		oke_rle_pvt.rle_rec_type;

Line: 532

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_RELATED_ENTITY';

Line: 558

    	OKE_RLE_PVT.delete_row(
	 	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_rle_rec		=> p_rle_rec);

Line: 604

  END delete_related_entity;

Line: 607

  PROCEDURE delete_related_entity(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rle_tbl			   IN  oke_rle_pvt.rle_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_RELATED_ENTITY';

Line: 640

    OKE_RLE_PVT.Delete_Row(
      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_rle_tbl		=> p_rle_tbl);

Line: 686

  END delete_related_entity;