eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_K_PRINT_FORMS_PUB SQL Statements

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

Line: 49


	OKE_FORM_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_form_rec		=> l_form_rec,
            x_form_rec		=> x_form_rec);

Line: 135


    OKE_FORM_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_form_tbl		=> p_form_tbl,
      x_form_tbl		=> x_form_tbl);

Line: 183


  PROCEDURE update_print_form(
    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_form_rec		IN oke_form_pvt.form_rec_type,
    x_form_rec		OUT NOCOPY oke_form_pvt.form_rec_type) IS

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

Line: 218


    OKE_FORM_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_form_rec			=> p_form_rec,
      x_form_rec			=> x_form_rec);

Line: 265


  END update_print_form;

Line: 268


 PROCEDURE update_print_form(
    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_form_tbl			   IN  oke_form_pvt.form_tbl_type,
    x_form_tbl			   OUT NOCOPY  oke_form_pvt.form_tbl_type) IS

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

Line: 307


    OKE_FORM_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_form_tbl			=> p_form_tbl,
      x_form_tbl			=> x_form_tbl);

Line: 355


  END update_print_form;

Line: 530


  PROCEDURE delete_print_form(

    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_form_rec			   IN oke_form_pvt.form_rec_type) IS

    l_form_rec		oke_form_pvt.form_rec_type;

Line: 540


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

Line: 566


    	OKE_FORM_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_form_rec		=> p_form_rec);

Line: 612


  END delete_print_form;

Line: 615


  PROCEDURE delete_print_form(
    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_form_tbl			   IN  oke_form_pvt.form_tbl_type) IS

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

Line: 648


    OKE_FORM_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_form_tbl		=> p_form_tbl);

Line: 694


  END delete_print_form;

Line: 698


  PROCEDURE delete_print_form(
    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_pfm_cd		IN OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE ) IS

    l_form_rec		oke_form_pvt.form_rec_type;

Line: 709


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

Line: 735


		OKE_FORM_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_pfm_cd		=> p_pfm_cd);

Line: 746


		OKE_FORM_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_pfm_cd		=> p_pfm_cd);

Line: 795


  END delete_print_form;

Line: 823


    SELECT
		b.K_HEADER_ID			,
		b.K_LINE_ID			,
		b.PRINT_FORM_CODE		,
		b.CREATION_DATE			,
		b.CREATED_BY			,
		b.LAST_UPDATE_DATE		,
		b.LAST_UPDATED_BY		,
		b.LAST_UPDATE_LOGIN		,
		b.REQUIRED_FLAG			,
		b.CUSTOMER_FURNISHED_FLAG	,
		b.COMPLETED_FLAG		,
		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_PRINT_FORMS b
    WHERE b.K_LINE_ID = p_id;

Line: 855


    SELECT
		b.K_HEADER_ID			,
		b.K_LINE_ID			,
		b.PRINT_FORM_CODE		,
		b.CREATION_DATE			,
		b.CREATED_BY			,
		b.LAST_UPDATE_DATE		,
		b.LAST_UPDATED_BY		,
		b.LAST_UPDATE_LOGIN		,
		b.REQUIRED_FLAG			,
		b.CUSTOMER_FURNISHED_FLAG	,
		b.COMPLETED_FLAG		,
		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_PRINT_FORMS b
    WHERE (b.K_HEADER_ID = p_id) AND (b.K_LINE_ID IS NULL);

Line: 923


		l_form_rec.LAST_UPDATE_DATE		,
		l_form_rec.LAST_UPDATED_BY		,
		l_form_rec.LAST_UPDATE_LOGIN		,
		l_form_rec.REQUIRED_FLAG		,
		l_form_rec.CUSTOMER_FURNISHED_FLAG	,
		l_form_rec.COMPLETED_FLAG		,
		l_form_rec.ATTRIBUTE_CATEGORY		,
		l_form_rec.ATTRIBUTE1			,
		l_form_rec.ATTRIBUTE2			,
		l_form_rec.ATTRIBUTE3			,
		l_form_rec.ATTRIBUTE4			,
		l_form_rec.ATTRIBUTE5			,
		l_form_rec.ATTRIBUTE6			,
		l_form_rec.ATTRIBUTE7			,
		l_form_rec.ATTRIBUTE8			,
		l_form_rec.ATTRIBUTE9			,
		l_form_rec.ATTRIBUTE10			,
		l_form_rec.ATTRIBUTE11			,
		l_form_rec.ATTRIBUTE12			,
		l_form_rec.ATTRIBUTE13			,
		l_form_rec.ATTRIBUTE14			,
		l_form_rec.ATTRIBUTE15			;

Line: 972


	--FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'print FORMS inserting std form');

Line: 973


    	OKE_FORM_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_form_tbl		=> l_form_tbl,
      		x_form_tbl		=> x_form_tbl);

Line: 1001


		l_form_rec.LAST_UPDATE_DATE		,
		l_form_rec.LAST_UPDATED_BY		,
		l_form_rec.LAST_UPDATE_LOGIN		,
		l_form_rec.REQUIRED_FLAG		,
		l_form_rec.CUSTOMER_FURNISHED_FLAG	,
		l_form_rec.COMPLETED_FLAG		,
		l_form_rec.ATTRIBUTE_CATEGORY		,
		l_form_rec.ATTRIBUTE1			,
		l_form_rec.ATTRIBUTE2			,
		l_form_rec.ATTRIBUTE3			,
		l_form_rec.ATTRIBUTE4			,
		l_form_rec.ATTRIBUTE5			,
		l_form_rec.ATTRIBUTE6			,
		l_form_rec.ATTRIBUTE7			,
		l_form_rec.ATTRIBUTE8			,
		l_form_rec.ATTRIBUTE9			,
		l_form_rec.ATTRIBUTE10			,
		l_form_rec.ATTRIBUTE11			,
		l_form_rec.ATTRIBUTE12			,
		l_form_rec.ATTRIBUTE13			,
		l_form_rec.ATTRIBUTE14			,
		l_form_rec.ATTRIBUTE15			;

Line: 1050


	--FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'print form inserting std form');

Line: 1051


    	OKE_FORM_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_form_tbl		=> l_form_tbl,
      		x_form_tbl		=> x_form_tbl);