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

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

Line: 67


	SELECT 'x'
	FROM FND_CURRENCIES
	WHERE CURRENCY_CODE = p_pool_rec.CURRENCY_CODE;

Line: 136


	SELECT 'x'
	FROM PER_EMPLOYEES_CURRENT_X
	WHERE EMPLOYEE_ID= p_pool_rec.CONTACT_PERSON_ID;

Line: 190


	SELECT 'x'
	FROM OKE_PROGRAMS
	WHERE PROGRAM_ID= p_pool_rec.PROGRAM_ID
          AND SYSDATE BETWEEN START_DATE
          AND NVL(END_DATE+1 , SYSDATE )
        ;

Line: 388


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

Line: 392


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

Line: 396


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

Line: 413


    SELECT

	FUNDING_POOL_ID,
	NAME,
	DESCRIPTION,
	CURRENCY_CODE,
	CONTACT_PERSON_ID,
	PROGRAM_ID,

 	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_FUNDING_POOLS a
    WHERE (a.funding_pool_id = p_funding_pool_id);

Line: 466


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

Line: 489


      	OKE_API.set_message(G_APP_NAME,G_FORM_RECORD_DELETED);

Line: 498


	-- row level insert
	-- will create using nextVal from sequence oke_funding_pools_s

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_rec                      IN pool_rec_type,
    x_pool_rec                      OUT NOCOPY pool_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 511


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

Line: 531


      l_pool_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 532


      l_pool_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 533


      l_pool_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 553


  BEGIN  -- insert
    --oke_debug.debug('start call oke_pool_pvt.insert_row');

Line: 631


    SELECT OKE_FUNDING_POOLS_S.nextval  INTO l_seq FROM dual;

Line: 633


    OKE_FUNDING_POOLS_PKG.Insert_Row
	(l_row_id,
	l_seq,
	l_def_pool_rec.NAME,
	l_def_pool_rec.DESCRIPTION,
	l_def_pool_rec.CURRENCY_CODE,
	l_def_pool_rec.CONTACT_PERSON_ID,
	l_def_pool_rec.PROGRAM_ID,
 	l_def_pool_rec.LAST_UPDATE_DATE     ,
 	l_def_pool_rec.LAST_UPDATED_BY      ,
 	l_def_pool_rec.CREATION_DATE        ,
 	l_def_pool_rec.CREATED_BY           ,
 	l_def_pool_rec.LAST_UPDATE_LOGIN    ,
 	l_def_pool_rec.ATTRIBUTE_CATEGORY   ,
 	l_def_pool_rec.ATTRIBUTE1           ,
 	l_def_pool_rec.ATTRIBUTE2           ,
 	l_def_pool_rec.ATTRIBUTE3           ,
 	l_def_pool_rec.ATTRIBUTE4           ,
 	l_def_pool_rec.ATTRIBUTE5           ,
 	l_def_pool_rec.ATTRIBUTE6           ,
 	l_def_pool_rec.ATTRIBUTE7           ,
 	l_def_pool_rec.ATTRIBUTE8           ,
 	l_def_pool_rec.ATTRIBUTE9           ,
 	l_def_pool_rec.ATTRIBUTE10          ,
 	l_def_pool_rec.ATTRIBUTE11          ,
 	l_def_pool_rec.ATTRIBUTE12          ,
 	l_def_pool_rec.ATTRIBUTE13          ,
 	l_def_pool_rec.ATTRIBUTE14          ,
 	l_def_pool_rec.ATTRIBUTE15
	);

Line: 703


  END insert_row;   -- row level

Line: 708


	-- table level insert

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_tbl                      IN pool_tbl_type,
    x_pool_tbl                      OUT NOCOPY pool_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 720


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

Line: 746


        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_pool_rec                      => p_pool_tbl(i),
          x_pool_rec                      => x_pool_tbl(i));

Line: 804


  END insert_row; -- table level

Line: 813


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_rec                      IN pool_rec_type,
    x_pool_rec                      OUT NOCOPY pool_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1.0;

Line: 823


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

Line: 831


	select funding_pool_id
	from oke_funding_pools
	where funding_pool_id=p_pool_rec.funding_pool_id;

Line: 845


      l_pool_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 846


      l_pool_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 847


      l_pool_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 902


	IF x_pool_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	  x_pool_rec.LAST_UPDATE_DATE := l_pool_rec.LAST_UPDATE_DATE;

Line: 906


	IF x_pool_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	  x_pool_rec.LAST_UPDATED_BY  := l_pool_rec.LAST_UPDATED_BY ;

Line: 910


	IF x_pool_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	  x_pool_rec.LAST_UPDATE_LOGIN := l_pool_rec.LAST_UPDATE_LOGIN;

Line: 996


  BEGIN  -- update row

    --oke_debug.debug('start call oke_pool_pvt.update_row');

Line: 1103


    OKE_FUNDING_POOLS_PKG.update_row(
	l_def_pool_rec.FUNDING_POOL_ID,
	l_def_pool_rec.NAME,
	l_def_pool_rec.DESCRIPTION,
	l_def_pool_rec.CONTACT_PERSON_ID,
	l_def_pool_rec.PROGRAM_ID,

	l_def_pool_rec.LAST_UPDATE_DATE,
	l_def_pool_rec.LAST_UPDATED_BY,
	l_def_pool_rec.LAST_UPDATE_LOGIN,

	l_def_pool_rec.ATTRIBUTE_CATEGORY,
	l_def_pool_rec.ATTRIBUTE1,
	l_def_pool_rec.ATTRIBUTE2,
	l_def_pool_rec.ATTRIBUTE3,
	 l_def_pool_rec.ATTRIBUTE4,
	l_def_pool_rec.ATTRIBUTE5,
	l_def_pool_rec.ATTRIBUTE6,
	l_def_pool_rec.ATTRIBUTE7,
	l_def_pool_rec.ATTRIBUTE8,
	l_def_pool_rec.ATTRIBUTE9,
	l_def_pool_rec.ATTRIBUTE10,
	l_def_pool_rec.ATTRIBUTE11,
	l_def_pool_rec.ATTRIBUTE12,
	l_def_pool_rec.ATTRIBUTE13,
	l_def_pool_rec.ATTRIBUTE14,
	l_def_pool_rec.ATTRIBUTE15 );

Line: 1166


  END update_row;   -- row level update

Line: 1170


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_tbl                     IN pool_tbl_type,
    x_pool_tbl                     OUT NOCOPY pool_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1.0;

Line: 1180


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

Line: 1210


        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_pool_rec                      => p_pool_tbl(i),
          x_pool_rec                     => x_pool_tbl(i));

Line: 1267


  END update_row;  -- table level update

Line: 1270


	-- deletes by the funding_pool_id

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_rec                     IN pool_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1281


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

Line: 1287


	select funding_pool_id
	from oke_funding_pools
	where funding_pool_id=p_pool_rec.funding_pool_id;

Line: 1333


	DELETE FROM OKE_FUNDING_POOLS
	WHERE FUNDING_POOL_ID = p_pool_rec.FUNDING_POOL_ID;

Line: 1370


  END delete_row;

Line: 1375


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pool_tbl                     IN pool_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1384


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

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_pool_rec                      => p_pool_tbl(i));

Line: 1468


  END delete_row; -- table level delete

Line: 1492


	SELECT funding_pool_id FROM oke_funding_pools a
	WHERE
	  a.funding_pool_id = p.funding_pool_id
	FOR UPDATE NOWAIT;

Line: 1535


      OKE_API.set_message(G_APP_NAME,G_FORM_RECORD_DELETED);