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

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

Line: 10


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

Line: 82


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

Line: 132


	SELECT 'x'
	FROM OKE_TERM_VALUES_V
	WHERE TERM_CODE = p_term_rec.TERM_CODE;

Line: 197


	SELECT 'x'
	FROM OKE_TERM_VALUES_V
	WHERE TERM_VALUE_PK1 = p_term_rec.TERM_VALUE_PK1;

Line: 266


	SELECT 'x'
	FROM OKE_TERM_VALUES_V
	WHERE TERM_VALUE_PK2 = p_term_rec.TERM_VALUE_PK2;

Line: 343


	SELECT 'x'
	FROM OKE_TERM_VALUES_V
	WHERE	TERM_CODE = p_term_rec.TERM_CODE AND
		TERM_VALUE_PK1 = p_term_rec.TERM_VALUE_PK1 AND
		TERM_VALUE_PK2 = p_term_rec.TERM_VALUE_PK2;

Line: 571


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

Line: 575


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

Line: 579


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

Line: 594


    SELECT

 	K_HEADER_ID,
 	K_LINE_ID,
 	TERM_CODE,
	TERM_VALUE_PK1,
	TERM_VALUE_PK2,
 	CREATION_DATE,
 	CREATED_BY,
 	LAST_UPDATE_DATE,
 	LAST_UPDATED_BY,
 	LAST_UPDATE_LOGIN,
 	ATTRIBUTE_CATEGORY,
 	ATTRIBUTE1   ,
 	ATTRIBUTE2   ,
 	ATTRIBUTE3   ,
 	ATTRIBUTE4   ,
 	ATTRIBUTE5   ,
 	ATTRIBUTE6   ,
 	ATTRIBUTE7              ,
 	ATTRIBUTE8              ,
 	ATTRIBUTE9              ,
 	ATTRIBUTE10             ,
 	ATTRIBUTE11             ,
 	ATTRIBUTE12             ,
 	ATTRIBUTE13             ,
 	ATTRIBUTE14             ,
 	ATTRIBUTE15


    FROM OKE_K_TERMS a
    WHERE
	(a.K_HEADER_ID = chr_id)AND(a.TERM_CODE=trm_cd)
	AND (a.TERM_VALUE_PK1=TERM_VALUE_PK1)
	AND (a.TERM_VALUE_PK2=TERM_VALUE_PK2)
	AND(
	     ((a.K_LINE_ID IS NULL)AND(cle_id IS NULL)) OR
             (a.K_LINE_ID = cle_id));

Line: 650


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


	-- 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_term_rec                      IN term_rec_type,
    x_term_rec                      OUT NOCOPY term_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 692


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

Line: 711


      l_term_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 712


      l_term_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 713


      l_term_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 732


  BEGIN  -- insert


    l_return_status := OKE_API.START_ACTIVITY(l_api_name,
                                              G_PKG_NAME,
                                              p_init_msg_list,
                                              l_api_version,
                                              p_api_version,
                                              '_PVT',
                                              x_return_status);

Line: 793


    INSERT INTO OKE_K_TERMS(

 	K_HEADER_ID          ,
 	K_LINE_ID            ,
 	TERM_CODE	     ,
	TERM_VALUE_PK1	     ,
	TERM_VALUE_PK2	     ,
 	CREATION_DATE        ,
 	CREATED_BY           ,
 	LAST_UPDATE_DATE     ,
 	LAST_UPDATED_BY      ,
 	LAST_UPDATE_LOGIN    ,
 	ATTRIBUTE_CATEGORY   ,
 	ATTRIBUTE1           ,
 	ATTRIBUTE2           ,
 	ATTRIBUTE3           ,
 	ATTRIBUTE4           ,
 	ATTRIBUTE5           ,
 	ATTRIBUTE6           ,
 	ATTRIBUTE7           ,
 	ATTRIBUTE8           ,
 	ATTRIBUTE9           ,
 	ATTRIBUTE10          ,
 	ATTRIBUTE11          ,
 	ATTRIBUTE12          ,
 	ATTRIBUTE13          ,
 	ATTRIBUTE14          ,
 	ATTRIBUTE15
	)
    VALUES(
	l_def_term_rec.K_HEADER_ID          ,
 	l_def_term_rec.K_LINE_ID            ,
 	l_def_term_rec.TERM_CODE      	    ,
	l_def_term_rec.TERM_VALUE_PK1	    ,
	l_def_term_rec.TERM_VALUE_PK2	    ,
 	l_def_term_rec.CREATION_DATE        ,
 	l_def_term_rec.CREATED_BY           ,
 	l_def_term_rec.LAST_UPDATE_DATE     ,
 	l_def_term_rec.LAST_UPDATED_BY      ,
 	l_def_term_rec.LAST_UPDATE_LOGIN    ,
 	l_def_term_rec.ATTRIBUTE_CATEGORY   ,
 	l_def_term_rec.ATTRIBUTE1           ,
 	l_def_term_rec.ATTRIBUTE2           ,
 	l_def_term_rec.ATTRIBUTE3           ,
 	l_def_term_rec.ATTRIBUTE4           ,
 	l_def_term_rec.ATTRIBUTE5           ,
 	l_def_term_rec.ATTRIBUTE6           ,
 	l_def_term_rec.ATTRIBUTE7           ,
 	l_def_term_rec.ATTRIBUTE8           ,
 	l_def_term_rec.ATTRIBUTE9           ,
 	l_def_term_rec.ATTRIBUTE10          ,
 	l_def_term_rec.ATTRIBUTE11          ,
 	l_def_term_rec.ATTRIBUTE12          ,
 	l_def_term_rec.ATTRIBUTE13          ,
 	l_def_term_rec.ATTRIBUTE14          ,
 	l_def_term_rec.ATTRIBUTE15
	);

Line: 887


  END insert_row;   -- row level

Line: 892


	-- 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_term_tbl                      IN term_tbl_type,
    x_term_tbl                      OUT NOCOPY term_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 904


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

Line: 915


        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_term_rec                      => p_term_tbl(i),
          x_term_rec                      => x_term_tbl(i));

Line: 971


  END insert_row; -- table level

Line: 980


  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_term_rec                      IN term_rec_type,
    x_term_rec                      OUT NOCOPY term_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1.0;

Line: 990


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

Line: 1006


      l_term_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1007


      l_term_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1008


      l_term_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1033


      OKE_API.set_message(G_APP_NAME,G_FORM_RECORD_DELETED);

Line: 1045


	IF x_term_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	  x_term_rec.LAST_UPDATE_DATE := l_term_rec.LAST_UPDATE_DATE;

Line: 1049


	IF x_term_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	  x_term_rec.LAST_UPDATED_BY  := l_term_rec.LAST_UPDATED_BY ;

Line: 1053


	IF x_term_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	  x_term_rec.LAST_UPDATE_LOGIN := l_term_rec.LAST_UPDATE_LOGIN;

Line: 1140


  BEGIN  -- update row

    l_return_status := OKE_API.START_ACTIVITY(l_api_name,
                                              G_PKG_NAME,
                                              p_init_msg_list,
                                              l_api_version,
                                              p_api_version,
                                              '_PVT',
                                              x_return_status);

Line: 1199


    UPDATE OKE_K_TERMS
    SET
	CREATION_DATE	= l_def_term_rec.CREATION_DATE,
	CREATED_BY = l_def_term_rec.CREATED_BY,
	LAST_UPDATE_DATE = l_def_term_rec.LAST_UPDATE_DATE,
	LAST_UPDATED_BY = l_def_term_rec.LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = l_def_term_rec.LAST_UPDATE_LOGIN,

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

Line: 1266


  END update_row;   -- row level update

Line: 1270


  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_term_tbl                     IN term_tbl_type,
    x_term_tbl                     OUT NOCOPY term_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1.0;

Line: 1280


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

Line: 1308


        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_term_rec                      => p_term_tbl(i),
          x_term_rec                     => x_term_tbl(i));

Line: 1364


  END update_row;  -- table level update

Line: 1368


  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_trm_cd			   OKE_K_TERMS.TERM_CODE%TYPE,
    p_trm_val_pk1		   OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
    p_trm_val_pk2		   OKE_K_TERMS.TERM_VALUE_PK2%TYPE

) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1382


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

Line: 1402


    DELETE FROM OKE_K_TERMS
    WHERE K_LINE_ID = p_cle_id AND TERM_CODE = p_trm_cd
	AND TERM_VALUE_PK1=p_trm_val_pk1
	AND TERM_VALUE_PK2=p_trm_val_pk2;

Line: 1440


  END delete_row;

Line: 1445


  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_trm_cd			   OKE_K_TERMS.TERM_CODE%TYPE,
    p_trm_val_pk1		   OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
    p_trm_val_pk2		   OKE_K_TERMS.TERM_VALUE_PK2%TYPE
) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1458


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

Line: 1478


    DELETE FROM OKE_K_TERMS
    WHERE (K_HEADER_ID=p_chr_id) AND (TERM_CODE=p_trm_cd)
	AND (K_LINE_ID IS NULL)
	AND (TERM_VALUE_PK1=p_trm_val_pk1)
	AND (TERM_VALUE_PK2=p_trm_val_pk2);

Line: 1518


  END delete_row;

Line: 1521


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1530


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

Line: 1551


        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_term_rec.K_HEADER_ID,
	  p_trm_cd			 => p_term_rec.TERM_CODE,
	  p_trm_val_pk1			 => p_term_rec.TERM_VALUE_PK1,
	  p_trm_val_pk2			 => p_term_rec.TERM_VALUE_PK2);

Line: 1562


        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_term_rec.K_LINE_ID,
	  p_trm_cd			 => p_term_rec.TERM_CODE,
	  p_trm_val_pk1			 => p_term_rec.TERM_VALUE_PK1,
	  p_trm_val_pk2			 => p_term_rec.TERM_VALUE_PK2);

Line: 1607


  END delete_row;

Line: 1612


  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_term_tbl                     IN term_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1621


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

Line: 1647


        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_term_rec                      => p_term_tbl(i));

Line: 1705


  END delete_row; -- table level delete

Line: 1888


	SELECT k_header_id,k_line_id,term_code FROM oke_k_terms a
	WHERE
	(a.K_HEADER_ID = p.K_HEADER_ID)AND(a.TERM_CODE=p.TERM_CODE)
	AND(a.TERM_VALUE_PK1=p.TERM_VALUE_PK1)
	AND(a.TERM_VALUE_PK2=p.TERM_VALUE_PK2)
	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: 1933


      OKE_API.set_message(G_APP_NAME,G_FORM_RECORD_DELETED);