DBA Data[Home] [Help]

APPS.OKE_TERMS_PUB SQL Statements

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

Line: 45

	OKE_TERM_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_term_rec		=> l_term_rec,
            x_term_rec		=> x_term_rec);
Line: 131

    OKE_TERM_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_term_tbl	=> p_term_tbl,
      x_term_tbl	=> x_term_tbl);
Line: 182

  PROCEDURE update_term(
    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_term_rec		IN oke_term_pvt.term_rec_type,
    x_term_rec		OUT NOCOPY oke_term_pvt.term_rec_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_TERM';
Line: 217

    OKE_TERM_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_term_rec			=> p_term_rec,
      x_term_rec			=> x_term_rec);
Line: 264

  END update_term;
Line: 267

 PROCEDURE update_term(
    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_term_tbl			   IN  oke_term_pvt.term_tbl_type,
    x_term_tbl			   OUT NOCOPY  oke_term_pvt.term_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_TERM';
Line: 302

    OKE_TERM_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_term_tbl			=> p_term_tbl,
      x_term_tbl			=> x_term_tbl);
Line: 350

  END update_term;
Line: 525

  PROCEDURE delete_term(

    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_term_rec			   IN oke_term_pvt.term_rec_type) IS

    l_term_rec		oke_term_pvt.term_rec_type;
Line: 535

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_TERM';
Line: 562

    	OKE_TERM_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_term_rec		=> p_term_rec);
Line: 607

  END delete_term;
Line: 609

  PROCEDURE delete_term(
    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_term_tbl			   IN  oke_term_pvt.term_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_TERM';
Line: 643

    OKE_TERM_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_term_tbl	=> p_term_tbl);
Line: 689

  END delete_term;
Line: 692

  PROCEDURE delete_term(

    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_chr_id		IN NUMBER,
    p_cle_id		IN NUMBER,
    p_trm_cd		IN OKE_K_TERMS.TERM_CODE%TYPE,
    p_trm_val_pk1	IN OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
    p_trm_val_pk2	IN OKE_K_TERMS.TERM_VALUE_PK2%TYPE) IS

    l_term_rec		oke_term_pvt.term_rec_type;
Line: 706

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_TERM';
Line: 733

		OKE_TERM_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_cle_id		=> p_cle_id,
		p_trm_cd		=> p_trm_cd,
		p_trm_val_pk1		=> p_trm_val_pk1,
		p_trm_val_pk2		=> p_trm_val_pk2);
Line: 746

		OKE_TERM_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_chr_id		=> p_chr_id,
		p_trm_cd		=> p_trm_cd,
		p_trm_val_pk1		=> p_trm_val_pk1,
		p_trm_val_pk2		=> p_trm_val_pk2);
Line: 798

  END delete_term;
Line: 826

    SELECT
		b.K_HEADER_ID			,
		b.K_LINE_ID			,
		b.TERM_CODE			,
		b.TERM_VALUE_PK1		,
		b.TERM_VALUE_PK2		,
		b.CREATION_DATE			,
		b.CREATED_BY			,
		b.LAST_UPDATE_DATE		,
		b.LAST_UPDATED_BY		,
		b.LAST_UPDATE_LOGIN		,
		b.ATTRIBUTE_CATEGORY		,
		b.ATTRIBUTE1			,
		b.ATTRIBUTE2			,
		b.ATTRIBUTE3			,
		b.ATTRIBUTE4			,
		b.ATTRIBUTE5			,
		b.ATTRIBUTE6			,
		b.ATTRIBUTE7			,
		b.ATTRIBUTE8			,
		b.ATTRIBUTE9			,
		b.ATTRIBUTE10			,
		b.ATTRIBUTE11			,
		b.ATTRIBUTE12			,
		b.ATTRIBUTE13			,
		b.ATTRIBUTE14			,
		b.ATTRIBUTE15
    FROM OKE_K_TERMS b
    WHERE b.K_LINE_ID = p_id;
Line: 857

    SELECT
		b.K_HEADER_ID			,
		b.K_LINE_ID			,
		b.TERM_CODE			,
		b.TERM_VALUE_PK1		,
		b.TERM_VALUE_PK2		,
		b.CREATION_DATE			,
		b.CREATED_BY			,
		b.LAST_UPDATE_DATE		,
		b.LAST_UPDATED_BY		,
		b.LAST_UPDATE_LOGIN		,
		b.ATTRIBUTE_CATEGORY		,
		b.ATTRIBUTE1			,
		b.ATTRIBUTE2			,
		b.ATTRIBUTE3			,
		b.ATTRIBUTE4			,
		b.ATTRIBUTE5			,
		b.ATTRIBUTE6			,
		b.ATTRIBUTE7			,
		b.ATTRIBUTE8			,
		b.ATTRIBUTE9			,
		b.ATTRIBUTE10			,
		b.ATTRIBUTE11			,
		b.ATTRIBUTE12			,
		b.ATTRIBUTE13			,
		b.ATTRIBUTE14			,
		b.ATTRIBUTE15
    FROM OKE_K_TERMS b
    WHERE (b.K_HEADER_ID = p_id) AND (b.K_LINE_ID IS NULL);
Line: 923

		l_term_rec.LAST_UPDATE_DATE		,
		l_term_rec.LAST_UPDATED_BY		,
		l_term_rec.LAST_UPDATE_LOGIN		,
		l_term_rec.ATTRIBUTE_CATEGORY		,
		l_term_rec.ATTRIBUTE1			,
		l_term_rec.ATTRIBUTE2			,
		l_term_rec.ATTRIBUTE3			,
		l_term_rec.ATTRIBUTE4			,
		l_term_rec.ATTRIBUTE5			,
		l_term_rec.ATTRIBUTE6			,
		l_term_rec.ATTRIBUTE7			,
		l_term_rec.ATTRIBUTE8			,
		l_term_rec.ATTRIBUTE9			,
		l_term_rec.ATTRIBUTE10			,
		l_term_rec.ATTRIBUTE11			,
		l_term_rec.ATTRIBUTE12			,
		l_term_rec.ATTRIBUTE13			,
		l_term_rec.ATTRIBUTE14			,
		l_term_rec.ATTRIBUTE15			;
Line: 969

    	OKE_TERM_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_term_tbl		=> l_term_tbl,
      		x_term_tbl		=> x_term_tbl);
Line: 997

		l_term_rec.LAST_UPDATE_DATE		,
		l_term_rec.LAST_UPDATED_BY		,
		l_term_rec.LAST_UPDATE_LOGIN		,
		l_term_rec.ATTRIBUTE_CATEGORY		,
		l_term_rec.ATTRIBUTE1			,
		l_term_rec.ATTRIBUTE2			,
		l_term_rec.ATTRIBUTE3			,
		l_term_rec.ATTRIBUTE4			,
		l_term_rec.ATTRIBUTE5			,
		l_term_rec.ATTRIBUTE6			,
		l_term_rec.ATTRIBUTE7			,
		l_term_rec.ATTRIBUTE8			,
		l_term_rec.ATTRIBUTE9			,
		l_term_rec.ATTRIBUTE10			,
		l_term_rec.ATTRIBUTE11			,
		l_term_rec.ATTRIBUTE12			,
		l_term_rec.ATTRIBUTE13			,
		l_term_rec.ATTRIBUTE14			,
		l_term_rec.ATTRIBUTE15			;
Line: 1044

    	OKE_TERM_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_term_tbl		=> l_term_tbl,
      		x_term_tbl		=> x_term_tbl);