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_FORM_PVT SQL Statements

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

Line: 31


	SELECT 'x'
	FROM OKE_K_HEADERS
	WHERE K_HEADER_ID = p_form_rec.K_HEADER_ID;

Line: 102


	SELECT 'x'
	FROM OKE_K_LINES
	WHERE K_LINE_ID = p_form_rec.K_LINE_ID;

Line: 153


	SELECT 'x'
	FROM OKE_PRINT_FORMS_B
	WHERE PRINT_FORM_CODE = p_form_rec.PRINT_FORM_CODE;

Line: 359


    IF	l_form_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	l_form_rec.LAST_UPDATED_BY := NULL;

Line: 363


    IF	l_form_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	l_form_rec.LAST_UPDATE_LOGIN := NULL;

Line: 367


    IF	l_form_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	l_form_rec.LAST_UPDATE_DATE := NULL;

Line: 386


    SELECT

 	K_HEADER_ID,
 	K_LINE_ID,
 	PRINT_FORM_CODE,
 	CREATION_DATE,
 	CREATED_BY,
 	LAST_UPDATE_DATE,
 	LAST_UPDATED_BY,
 	LAST_UPDATE_LOGIN,
 	REQUIRED_FLAG,
 	CUSTOMER_FURNISHED_FLAG,
 	COMPLETED_FLAG,
 	ATTRIBUTE_CATEGORY,
 	ATTRIBUTE1   ,
 	ATTRIBUTE2   ,
 	ATTRIBUTE3   ,
 	ATTRIBUTE4   ,
 	ATTRIBUTE5   ,
 	ATTRIBUTE6   ,
 	ATTRIBUTE7              ,
 	ATTRIBUTE8              ,
 	ATTRIBUTE9              ,
 	ATTRIBUTE10             ,
 	ATTRIBUTE11             ,
 	ATTRIBUTE12             ,
 	ATTRIBUTE13             ,
 	ATTRIBUTE14             ,
 	ATTRIBUTE15


    FROM OKE_K_PRINT_FORMS a
    WHERE
	(a.K_HEADER_ID = chr_id)AND(a.PRINT_FORM_CODE=pfm_cd)
	AND(
	     ((a.K_LINE_ID IS NULL)AND(cle_id IS NULL)) OR
             (a.K_LINE_ID = cle_id));

Line: 443


		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: 486


	-- row level insert

  PROCEDURE insert_row(
    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 form_rec_type,
    x_form_rec                      OUT NOCOPY form_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 498


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

Line: 517


      l_form_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 518


      l_form_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 519


      l_form_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 543


  BEGIN  -- insert

  IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
    FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call insert api');

Line: 586


      FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes set for insert');

Line: 596


      FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'who column filled for insert');

Line: 611


    FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes validated for insert');

Line: 622


    INSERT INTO OKE_K_PRINT_FORMS(

 	K_HEADER_ID          ,
 	K_LINE_ID            ,
 	PRINT_FORM_CODE      ,
 	CREATION_DATE        ,
 	CREATED_BY           ,
 	LAST_UPDATE_DATE     ,
 	LAST_UPDATED_BY      ,
 	LAST_UPDATE_LOGIN    ,
 	REQUIRED_FLAG        ,
 	CUSTOMER_FURNISHED_FLAG,
	COMPLETED_FLAG       ,
 	ATTRIBUTE_CATEGORY   ,
 	ATTRIBUTE1           ,
 	ATTRIBUTE2           ,
 	ATTRIBUTE3           ,
 	ATTRIBUTE4           ,
 	ATTRIBUTE5           ,
 	ATTRIBUTE6           ,
 	ATTRIBUTE7           ,
 	ATTRIBUTE8           ,
 	ATTRIBUTE9           ,
 	ATTRIBUTE10          ,
 	ATTRIBUTE11          ,
 	ATTRIBUTE12          ,
 	ATTRIBUTE13          ,
 	ATTRIBUTE14          ,
 	ATTRIBUTE15
	)
    VALUES(
	l_def_form_rec.K_HEADER_ID          ,
 	l_def_form_rec.K_LINE_ID            ,
 	l_def_form_rec.PRINT_FORM_CODE      ,
 	l_def_form_rec.CREATION_DATE        ,
 	l_def_form_rec.CREATED_BY           ,
 	l_def_form_rec.LAST_UPDATE_DATE     ,
 	l_def_form_rec.LAST_UPDATED_BY      ,
 	l_def_form_rec.LAST_UPDATE_LOGIN    ,
 	l_def_form_rec.REQUIRED_FLAG        ,
 	l_def_form_rec.CUSTOMER_FURNISHED_FLAG,
	l_def_form_rec.COMPLETED_FLAG       ,
 	l_def_form_rec.ATTRIBUTE_CATEGORY   ,
 	l_def_form_rec.ATTRIBUTE1           ,
 	l_def_form_rec.ATTRIBUTE2           ,
 	l_def_form_rec.ATTRIBUTE3           ,
 	l_def_form_rec.ATTRIBUTE4           ,
 	l_def_form_rec.ATTRIBUTE5           ,
 	l_def_form_rec.ATTRIBUTE6           ,
 	l_def_form_rec.ATTRIBUTE7           ,
 	l_def_form_rec.ATTRIBUTE8           ,
 	l_def_form_rec.ATTRIBUTE9           ,
 	l_def_form_rec.ATTRIBUTE10          ,
 	l_def_form_rec.ATTRIBUTE11          ,
 	l_def_form_rec.ATTRIBUTE12          ,
 	l_def_form_rec.ATTRIBUTE13          ,
 	l_def_form_rec.ATTRIBUTE14          ,
 	l_def_form_rec.ATTRIBUTE15
	);

Line: 683


      FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record inserted');

Line: 721


  END insert_row;   -- row level

Line: 726


	-- table level insert

  PROCEDURE insert_row(
    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 form_tbl_type,
    x_form_tbl                      OUT NOCOPY form_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 738


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

Line: 749


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,

          p_form_rec                      => p_form_tbl(i),
          x_form_rec                      => x_form_tbl(i));

Line: 805


  END insert_row; -- table level

Line: 814


  PROCEDURE update_row(
    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 form_rec_type,
    x_form_rec                      OUT NOCOPY form_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1.0;

Line: 824


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

Line: 840


      l_form_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 841


      l_form_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 842


      l_form_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 889


	IF x_form_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	  x_form_rec.LAST_UPDATE_DATE := l_form_rec.LAST_UPDATE_DATE;

Line: 893


	IF x_form_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	  x_form_rec.LAST_UPDATED_BY  := l_form_rec.LAST_UPDATED_BY ;

Line: 897


	IF x_form_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	  x_form_rec.LAST_UPDATE_LOGIN := l_form_rec.LAST_UPDATE_LOGIN;

Line: 1002


  BEGIN  -- update row
   IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call api initialization');

Line: 1076


       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'update base table');

Line: 1079


    UPDATE OKE_K_PRINT_FORMS
    SET
	CREATION_DATE	= l_def_form_rec.CREATION_DATE,
	CREATED_BY = l_def_form_rec.CREATED_BY,
	LAST_UPDATE_DATE = l_def_form_rec.LAST_UPDATE_DATE,
	LAST_UPDATED_BY = l_def_form_rec.LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = l_def_form_rec.LAST_UPDATE_LOGIN,
	REQUIRED_FLAG = l_def_form_rec.REQUIRED_FLAG,
	CUSTOMER_FURNISHED_FLAG = l_def_form_rec.CUSTOMER_FURNISHED_FLAG,
	COMPLETED_FLAG = l_def_form_rec.COMPLETED_FLAG,

	ATTRIBUTE_CATEGORY = l_def_form_rec.ATTRIBUTE_CATEGORY,
	ATTRIBUTE1 = l_def_form_rec.ATTRIBUTE1,
	ATTRIBUTE2 = l_def_form_rec.ATTRIBUTE2,
	ATTRIBUTE3 = l_def_form_rec.ATTRIBUTE3,
	ATTRIBUTE4 = l_def_form_rec.ATTRIBUTE4,
	ATTRIBUTE5 = l_def_form_rec.ATTRIBUTE5,
	ATTRIBUTE6 = l_def_form_rec.ATTRIBUTE6,
	ATTRIBUTE7 = l_def_form_rec.ATTRIBUTE7,
	ATTRIBUTE8 = l_def_form_rec.ATTRIBUTE8,
	ATTRIBUTE9 = l_def_form_rec.ATTRIBUTE9,
	ATTRIBUTE10 = l_def_form_rec.ATTRIBUTE10,
	ATTRIBUTE11 = l_def_form_rec.ATTRIBUTE11,
	ATTRIBUTE12 = l_def_form_rec.ATTRIBUTE12,
	ATTRIBUTE13 = l_def_form_rec.ATTRIBUTE13,
	ATTRIBUTE14 = l_def_form_rec.ATTRIBUTE14,
	ATTRIBUTE15 = l_def_form_rec.ATTRIBUTE15
    WHERE
	(K_HEADER_ID = l_def_form_rec.K_HEADER_ID)AND
	(PRINT_FORM_CODE = l_def_form_rec.PRINT_FORM_CODE) AND
	((K_LINE_ID = l_def_form_rec.K_LINE_ID)OR
	 (K_LINE_ID IS NULL)AND(l_def_form_rec.K_LINE_ID IS NULL));

Line: 1147


  END update_row;   -- row level update

Line: 1151


  PROCEDURE update_row(
    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 form_tbl_type,
    x_form_tbl                     OUT NOCOPY form_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1.0;

Line: 1161


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

Line: 1170


     FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'begin table type of update in pvt');

Line: 1179


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_form_rec                      => p_form_tbl(i),
          x_form_rec                     => x_form_tbl(i));

Line: 1234


  END update_row;  -- table level update

Line: 1238


  PROCEDURE delete_row(
    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_cle_id                       IN NUMBER,
    p_pfm_cd			   OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE
) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1249


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

Line: 1267


    DELETE FROM OKE_K_PRINT_FORMS
    WHERE K_LINE_ID = p_cle_id AND PRINT_FORM_CODE = p_pfm_cd;

Line: 1303


  END delete_row;

Line: 1305


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1316


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

Line: 1334


    DELETE FROM OKE_K_PRINT_FORMS
    WHERE (K_HEADER_ID=p_chr_id) AND (PRINT_FORM_CODE=p_pfm_cd) AND (K_LINE_ID IS NULL);

Line: 1370


  END delete_row;

Line: 1373


  PROCEDURE delete_row(
    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 form_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1382


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

Line: 1401


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
	  p_chr_id			 => p_form_rec.K_HEADER_ID,
	  p_pfm_cd			 => p_form_rec.PRINT_FORM_CODE);

Line: 1410


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
	  p_cle_id			 => p_form_rec.K_LINE_ID,
	  p_pfm_cd			 => p_form_rec.PRINT_FORM_CODE);

Line: 1452


  END delete_row;

Line: 1457


  PROCEDURE delete_row(
    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 form_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1466


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

Line: 1477


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_form_rec                      => p_form_tbl(i));

Line: 1533


  END delete_row; -- table level delete

Line: 1716


	SELECT k_header_id,k_line_id,print_form_code FROM oke_k_print_forms a
	WHERE
	(a.K_HEADER_ID = p.K_HEADER_ID)AND(a.PRINT_FORM_CODE=p.PRINT_FORM_CODE)
	AND(
	     ((a.K_LINE_ID IS NULL)AND(p.K_LINE_ID IS NULL)) OR
             (a.K_LINE_ID = p.K_LINE_ID))
	FOR UPDATE NOWAIT;

Line: 1755


      OKE_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);