APPS.OKE_STANDARD_NOTES_PUB SQL Statements

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

Line: 46

	OKE_NOTE_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_note_rec		=> l_note_rec,
            x_note_rec		=> x_note_rec);

Line: 130

    OKE_NOTE_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_note_tbl		=> p_note_tbl,
      x_note_tbl		=> x_note_tbl);

Line: 178

  PROCEDURE update_standard_note(
    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_note_rec		IN oke_note_pvt.note_rec_type,
    x_note_rec		OUT NOCOPY oke_note_pvt.note_rec_type) IS

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

Line: 212

    OKE_NOTE_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_note_rec			=> p_note_rec,
      x_note_rec			=> x_note_rec);

Line: 259

  END update_standard_note;

Line: 262

 PROCEDURE update_standard_note(
    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_note_tbl			   IN  oke_note_pvt.note_tbl_type,
    x_note_tbl			   OUT NOCOPY  oke_note_pvt.note_tbl_type) IS

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

Line: 297

    OKE_NOTE_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_note_tbl			=> p_note_tbl,
      x_note_tbl			=> x_note_tbl);

Line: 345

  END update_standard_note;

Line: 520

  PROCEDURE delete_standard_note(

    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_note_rec			   IN oke_note_pvt.note_rec_type) IS

    l_note_rec		oke_note_pvt.note_rec_type;

Line: 530

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

Line: 556

    	OKE_NOTE_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_note_rec		=> p_note_rec);

Line: 602

  END delete_standard_note;

Line: 604

  PROCEDURE delete_standard_note(
    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_note_tbl			   IN  oke_note_pvt.note_tbl_type) IS

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

Line: 637

    OKE_NOTE_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_note_tbl		=> p_note_tbl);

Line: 683

  END delete_standard_note;

Line: 685

  PROCEDURE delete_standard_note(

    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_note_id			   IN NUMBER) IS

    l_note_rec		oke_note_pvt.note_rec_type;

Line: 695

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

Line: 720

    	SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B
	WHERE STANDARD_NOTES_ID = p_note_id;

Line: 723

	SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL
	WHERE STANDARD_NOTES_ID = p_note_id;

Line: 734

    	OKE_NOTE_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_note_rec		=> l_note_rec);

Line: 780

  END delete_standard_note;

Line: 784

  PROCEDURE delete_standard_note(

    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_hdr_id		IN NUMBER,
    p_cle_id		IN NUMBER,
    p_del_id		IN NUMBER ) IS

    l_note_rec		oke_note_pvt.note_rec_type;

Line: 796

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

Line: 822

		OKE_NOTE_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_del_id		=> p_del_id);

Line: 832

		OKE_NOTE_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);

Line: 842

		OKE_NOTE_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_hdr_id		=> p_hdr_id);

Line: 892

  END delete_standard_note;

Line: 921

    SELECT unique
		b.STANDARD_NOTES_ID		,
		b.CREATION_DATE			,
		b.CREATED_BY			,
		b.LAST_UPDATE_DATE		,
		b.LAST_UPDATED_BY			,
		b.LAST_UPDATE_LOGIN		,
		b.HEADER_ID			,

		b.LINE_ID			,

		b.DELIVERABLE_ID			,
		b.TYPE_CODE			,
		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			,
		b.SFWT_FLAG			,
		b.DESCRIPTION			,
		b.NAME				,
		b.TEXT				,
		b.default_flag
    FROM OKE_K_STANDARD_NOTES_VL b
    WHERE b.DELIVERABLE_ID = p_id
	AND b.LINE_ID IS NULL;

Line: 960

    SELECT 	unique
		b.STANDARD_NOTES_ID		,
		b.CREATION_DATE			,
		b.CREATED_BY			,
		b.LAST_UPDATE_DATE		,
		b.LAST_UPDATED_BY			,
		b.LAST_UPDATE_LOGIN		,
		b.HEADER_ID			,
		b.LINE_ID			,
		b.DELIVERABLE_ID			,
		b.TYPE_CODE			,
		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			,
		b.SFWT_FLAG			,
		b.DESCRIPTION			,
		b.NAME				,
		b.TEXT				,
		b.default_flag
    FROM OKE_K_STANDARD_NOTES_VL B
    WHERE b.LINE_ID = p_id
	AND b.DELIVERABLE_ID IS NULL;

Line: 997

    SELECT 	unique
		b.STANDARD_NOTES_ID		,
		b.CREATION_DATE			,
		b.CREATED_BY			,
		b.LAST_UPDATE_DATE		,
		b.LAST_UPDATED_BY			,
		b.LAST_UPDATE_LOGIN		,
		b.HEADER_ID			,
		b.LINE_ID			,
		b.DELIVERABLE_ID			,
		b.TYPE_CODE			,
		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			,
		b.SFWT_FLAG			,
		b.DESCRIPTION			,
		b.NAME				,
		b.TEXT				,
		b.default_flag
    FROM OKE_K_STANDARD_NOTES_VL B
    WHERE b.HEADER_ID = p_id
	AND b.DELIVERABLE_ID IS NULL AND b.LINE_ID IS NULL;

Line: 1065

		l_note_rec.LAST_UPDATE_DATE		,
		l_note_rec.LAST_UPDATED_BY		,
		l_note_rec.LAST_UPDATE_LOGIN		,
		l_note_rec.K_HEADER_ID			,
		l_note_rec.K_LINE_ID			,
		l_note_rec.DELIVERABLE_ID		,
		l_note_rec.TYPE_CODE			,
		l_note_rec.ATTRIBUTE_CATEGORY		,
		l_note_rec.ATTRIBUTE1			,
		l_note_rec.ATTRIBUTE2			,
		l_note_rec.ATTRIBUTE3			,
		l_note_rec.ATTRIBUTE4			,
		l_note_rec.ATTRIBUTE5			,
		l_note_rec.ATTRIBUTE6			,
		l_note_rec.ATTRIBUTE7			,
		l_note_rec.ATTRIBUTE8			,
		l_note_rec.ATTRIBUTE9			,
		l_note_rec.ATTRIBUTE10			,
		l_note_rec.ATTRIBUTE11			,
		l_note_rec.ATTRIBUTE12			,
		l_note_rec.ATTRIBUTE13			,
		l_note_rec.ATTRIBUTE14			,
		l_note_rec.ATTRIBUTE15			,
		l_note_rec.SFWT_FLAG			,
		l_note_rec.DESCRIPTION			,
		l_note_rec.NAME				,
		l_note_rec.TEXT				,
		l_note_rec.default_flag			;

Line: 1122

    	OKE_NOTE_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_note_tbl		=> l_note_tbl,
      		x_note_tbl		=> x_note_tbl);

Line: 1150

		l_note_rec.LAST_UPDATE_DATE		,
		l_note_rec.LAST_UPDATED_BY		,
		l_note_rec.LAST_UPDATE_LOGIN		,
		l_note_rec.K_HEADER_ID			,
		l_note_rec.K_LINE_ID			,
		l_note_rec.DELIVERABLE_ID		,
		l_note_rec.TYPE_CODE			,
		l_note_rec.ATTRIBUTE_CATEGORY		,
		l_note_rec.ATTRIBUTE1			,
		l_note_rec.ATTRIBUTE2			,
		l_note_rec.ATTRIBUTE3			,
		l_note_rec.ATTRIBUTE4			,
		l_note_rec.ATTRIBUTE5			,
		l_note_rec.ATTRIBUTE6			,
		l_note_rec.ATTRIBUTE7			,
		l_note_rec.ATTRIBUTE8			,
		l_note_rec.ATTRIBUTE9			,
		l_note_rec.ATTRIBUTE10			,
		l_note_rec.ATTRIBUTE11			,
		l_note_rec.ATTRIBUTE12			,
		l_note_rec.ATTRIBUTE13			,
		l_note_rec.ATTRIBUTE14			,
		l_note_rec.ATTRIBUTE15			,
		l_note_rec.SFWT_FLAG			,
		l_note_rec.DESCRIPTION			,
		l_note_rec.NAME				,
		l_note_rec.TEXT				,
		l_note_rec.default_flag			;

Line: 1207

    	OKE_NOTE_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_note_tbl		=> l_note_tbl,
      		x_note_tbl		=> x_note_tbl);

Line: 1236

		l_note_rec.LAST_UPDATE_DATE		,
		l_note_rec.LAST_UPDATED_BY		,
		l_note_rec.LAST_UPDATE_LOGIN		,
		l_note_rec.K_HEADER_ID			,
		l_note_rec.K_LINE_ID			,
		l_note_rec.DELIVERABLE_ID		,
		l_note_rec.TYPE_CODE			,
		l_note_rec.ATTRIBUTE_CATEGORY		,
		l_note_rec.ATTRIBUTE1			,
		l_note_rec.ATTRIBUTE2			,
		l_note_rec.ATTRIBUTE3			,
		l_note_rec.ATTRIBUTE4			,
		l_note_rec.ATTRIBUTE5			,
		l_note_rec.ATTRIBUTE6			,
		l_note_rec.ATTRIBUTE7			,
		l_note_rec.ATTRIBUTE8			,
		l_note_rec.ATTRIBUTE9			,
		l_note_rec.ATTRIBUTE10			,
		l_note_rec.ATTRIBUTE11			,
		l_note_rec.ATTRIBUTE12			,
		l_note_rec.ATTRIBUTE13			,
		l_note_rec.ATTRIBUTE14			,
		l_note_rec.ATTRIBUTE15			,
		l_note_rec.SFWT_FLAG			,
		l_note_rec.DESCRIPTION			,
		l_note_rec.NAME				,
		l_note_rec.TEXT				,
		l_note_rec.default_flag			;

Line: 1291

    	OKE_NOTE_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_note_tbl		=> l_note_tbl,
      		x_note_tbl		=> x_note_tbl);