DBA Data[Home] [Help]

APPS.OKL_IRV_PVT SQL Statements

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

Line: 28

   SELECT
	ITEM_RESDL_VALUE_ID,
    OBJECT_VERSION_NUMBER,
    ITEM_RESIDUAL_ID,
	ITEM_RESDL_VERSION_ID,
	TERM_IN_MONTHS,
	RESIDUAL_VALUE,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
   FROM OKL_FE_ITEM_RESDL_VALUES IRV WHERE IRV.item_resdl_value_id=p_id;
Line: 56

	l_irv_rec.LAST_UPDATED_BY,
	l_irv_rec.LAST_UPDATE_DATE,
	l_irv_rec.LAST_UPDATE_LOGIN;
Line: 100

	IF (l_irv_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
	 l_irv_rec.LAST_UPDATED_BY:=NULL;
Line: 103

	IF (l_irv_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
	 l_irv_rec.LAST_UPDATE_DATE:=NULL;
Line: 106

	IF (l_irv_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN
	 l_irv_rec.LAST_UPDATE_LOGIN:=NULL;
Line: 424

        SELECT
            item_resdl_value_id
         FROM
             OKL_FE_ITEM_RESDL_VALUES IRV
         WHERE
              IRV.ITEM_RESDL_VERSION_ID         = p_irv_rec.item_resdl_version_id
          AND IRV.TERM_IN_MONTHS = p_irv_rec.term_in_months;
Line: 463

PROCEDURE insert_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_irv_rec			 IN okl_irv_rec,
	 x_irv_rec			 OUT NOCOPY okl_irv_rec)IS

l_api_version			CONSTANT NUMBER:=1;
Line: 473

l_api_name			CONSTANT VARCHAR2(30):='insert_row';
Line: 485

  l_irv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 486

  l_irv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 487

  l_irv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 544

	INSERT INTO OKL_FE_ITEM_RESDL_VALUES(
	   ITEM_RESDL_VALUE_ID,
	   OBJECT_VERSION_NUMBER,
       ITEM_RESIDUAL_ID,
	   ITEM_RESDL_VERSION_ID,
	   TERM_IN_MONTHS,
	   RESIDUAL_VALUE,
	   CREATED_BY,
	   CREATION_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATE_LOGIN)
	VALUES (
	   l_def_irv_rec.ITEM_RESDL_VALUE_ID,
	   l_def_irv_rec.OBJECT_VERSION_NUMBER,
	   l_def_irv_rec.ITEM_RESIDUAL_ID,
	   l_def_irv_rec.ITEM_RESDL_VERSION_ID,
	   l_def_irv_rec.TERM_IN_MONTHS,
	   l_def_irv_rec.RESIDUAL_VALUE,
	   l_def_irv_rec.CREATED_BY,
	   l_def_irv_rec.CREATION_DATE,
	   l_def_irv_rec.LAST_UPDATED_BY,
	   l_def_irv_rec.LAST_UPDATE_DATE,
	   l_def_irv_rec.LAST_UPDATE_LOGIN);
Line: 612

   END insert_row;
Line: 616

PROCEDURE insert_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_irv_tbl			 IN okl_irv_tbl,
	 x_irv_tbl			 OUT NOCOPY okl_irv_tbl)IS

	l_api_version			CONSTANT NUMBER:=1;
Line: 626

	l_api_name			CONSTANT VARCHAR2(30):='insert_row_tbl';
Line: 636

	   insert_row (p_api_version			=> p_api_version,
		p_init_msg_list			=> OKL_API.G_FALSE,
		x_return_status			=> x_return_status,
		x_msg_count			=> x_msg_count,
		x_msg_data			=> x_msg_data,
		p_irv_rec			=> p_irv_tbl(i),
		x_irv_rec			=> x_irv_tbl(i));
Line: 692

   END insert_row;
Line: 712

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_FE_ITEM_RESDL_VALUES
     WHERE ITEM_RESDL_VALUE_ID = p_def_irv_rec.item_resdl_value_id
       AND OBJECT_VERSION_NUMBER = p_def_irv_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 719

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_FE_ITEM_RESDL_VALUES
     WHERE item_resdl_value_id = p_def_irv_rec.item_resdl_value_id;
Line: 752

      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 761

      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 871

PROCEDURE update_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_irv_rec			 IN okl_irv_rec,
	 x_irv_rec			 OUT NOCOPY okl_irv_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 880

	l_api_name			CONSTANT VARCHAR2(30):='update_row';
Line: 891

   l_irv_rec .LAST_UPDATE_DATE := SYSDATE;
Line: 892

  l_irv_rec .LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 893

  l_irv_rec .LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 945

	IF (x_irv_rec.LAST_UPDATED_BY IS NULL)
	THEN
	 x_irv_rec.LAST_UPDATED_BY:=l_irv_rec.LAST_UPDATED_BY;
Line: 949

	IF (x_irv_rec.LAST_UPDATE_DATE IS NULL)
	THEN
	 x_irv_rec.LAST_UPDATE_DATE:=l_irv_rec.LAST_UPDATE_DATE;
Line: 953

	IF (x_irv_rec.LAST_UPDATE_LOGIN IS NULL)
	THEN
	 x_irv_rec.LAST_UPDATE_LOGIN:=l_irv_rec.LAST_UPDATE_LOGIN;
Line: 1024

UPDATE OKL_FE_ITEM_RESDL_VALUES
 SET
	ITEM_RESDL_VALUE_ID= l_def_irv_rec.ITEM_RESDL_VALUE_ID,
	OBJECT_VERSION_NUMBER=l_def_irv_rec.OBJECT_VERSION_NUMBER+1,
	ITEM_RESIDUAL_ID= l_def_irv_rec.ITEM_RESIDUAL_ID,
	ITEM_RESDL_VERSION_ID= l_def_irv_rec.ITEM_RESDL_VERSION_ID,
	TERM_IN_MONTHS= l_def_irv_rec.TERM_IN_MONTHS,
	RESIDUAL_VALUE= l_def_irv_rec.RESIDUAL_VALUE,
	CREATED_BY= l_def_irv_rec.CREATED_BY,
	CREATION_DATE= l_def_irv_rec.CREATION_DATE,
	LAST_UPDATED_BY= l_def_irv_rec.LAST_UPDATED_BY,
	LAST_UPDATE_DATE= l_def_irv_rec.LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN= l_def_irv_rec.LAST_UPDATE_LOGIN
 WHERE ITEM_RESDL_VALUE_ID = l_def_irv_rec.item_resdl_value_id;
Line: 1079

   END update_row;
Line: 1083

PROCEDURE update_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_irv_tbl			 IN okl_irv_tbl,
	 x_irv_tbl			 OUT NOCOPY okl_irv_tbl)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1092

	l_api_name			CONSTANT VARCHAR2(30):='update_tbl';
Line: 1102

	   update_row (p_api_version			=> p_api_version,
		p_init_msg_list			=> OKL_API.G_FALSE,
		x_return_status			=> x_return_status,
		x_msg_count			=> x_msg_count,
		x_msg_data			=> x_msg_data,
		p_irv_rec			=> p_irv_tbl(i),
		x_irv_rec			=> x_irv_tbl(i));
Line: 1158

   END update_row;
Line: 1163

PROCEDURE delete_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_irv_rec			 IN okl_irv_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1171

	l_api_name			CONSTANT VARCHAR2(30):='v_delete_row';
Line: 1190

	DELETE FROM OKL_FE_ITEM_RESDL_VALUES
	WHERE ITEM_RESDL_VALUE_ID=l_irv_rec.item_resdl_value_id;
Line: 1233

   END delete_row;
Line: 1237

PROCEDURE delete_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_irv_tbl			 IN okl_irv_tbl)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1245

	l_api_name			CONSTANT VARCHAR2(30):='v_delete_row';
Line: 1255

	   delete_row (p_api_version			=> p_api_version,
		p_init_msg_list			=> OKL_API.G_FALSE,
		x_return_status			=> x_return_status,
		x_msg_count			=> x_msg_count,
		x_msg_data			=> x_msg_data,
		p_irv_rec			=> p_irv_tbl(i));
Line: 1310

   END delete_row;