DBA Data[Home] [Help]

APPS.OKL_RES_PVT SQL Statements

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

Line: 30

   SELECT
	RESI_CAT_OBJECT_ID,
        OBJECT_VERSION_NUMBER,
	RESI_CATEGORY_SET_ID,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN,
	INVENTORY_ITEM_ID,
	ORGANIZATION_ID,
	CATEGORY_ID,
	CATEGORY_SET_ID
   FROM OKL_FE_RESI_CAT_OBJECTS WHERE OKL_FE_RESI_CAT_OBJECTS.RESI_CAT_OBJECT_ID=p_id;
Line: 56

	l_res_rec.LAST_UPDATED_BY,
	l_res_rec.LAST_UPDATE_DATE,
	l_res_rec.LAST_UPDATE_LOGIN,
	l_res_rec.INVENTORY_ITEM_ID,
	l_res_rec.ORGANIZATION_ID,
	l_res_rec.CATEGORY_ID,
	l_res_rec.CATEGORY_SET_ID;
Line: 106

	IF (l_res_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
	 l_res_rec.LAST_UPDATED_BY:=NULL;
Line: 109

	IF (l_res_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
	 l_res_rec.LAST_UPDATE_DATE:=NULL;
Line: 112

	IF (l_res_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN
	 l_res_rec.LAST_UPDATE_LOGIN:=NULL;
Line: 288

PROCEDURE insert_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_res_rec			 IN okl_res_rec,
	 x_res_rec			 OUT NOCOPY okl_res_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 297

	l_api_name			CONSTANT VARCHAR2(30):='v_insert_row';
Line: 311

  l_res_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 312

  l_res_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 313

  l_res_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 364

	INSERT INTO OKL_FE_RESI_CAT_OBJECTS(
	   RESI_CAT_OBJECT_ID,
	   OBJECT_VERSION_NUMBER,
	   RESI_CATEGORY_SET_ID,
	   CREATED_BY,
	   CREATION_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATE_LOGIN,
	   INVENTORY_ITEM_ID,
	   ORGANIZATION_ID,
	   CATEGORY_ID,
	   CATEGORY_SET_ID)
	VALUES (
	   l_def_res_rec.RESI_CAT_OBJECT_ID,
	   l_def_res_rec.OBJECT_VERSION_NUMBER,
	   l_def_res_rec.RESI_CATEGORY_SET_ID,
	   l_def_res_rec.CREATED_BY,
	   l_def_res_rec.CREATION_DATE,
	   l_def_res_rec.LAST_UPDATED_BY,
	   l_def_res_rec.LAST_UPDATE_DATE,
	   l_def_res_rec.LAST_UPDATE_LOGIN,
	   l_def_res_rec.INVENTORY_ITEM_ID,
	   l_def_res_rec.ORGANIZATION_ID,
	   l_def_res_rec.CATEGORY_ID,
	   l_def_res_rec.CATEGORY_SET_ID);
Line: 431

   END insert_row;
Line: 435

PROCEDURE insert_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_res_tbl			 IN okl_res_tbl,
	 x_res_tbl			 OUT NOCOPY okl_res_tbl)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 444

	l_api_name			CONSTANT VARCHAR2(30):='v_insert_row';
Line: 454

	   insert_row (p_api_version			=> p_api_version,
		p_init_msg_list			=> OKC_API.G_FALSE,
		x_return_status			=> x_return_status,
		x_msg_count			=> x_msg_count,
		x_msg_data			=> x_msg_data,
		p_res_rec			=> p_res_tbl(i),
		x_res_rec			=> x_res_tbl(i));
Line: 510

   END insert_row;
Line: 531

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_FE_RESI_CAT_OBJECTS
     WHERE RESI_CAT_OBJECT_ID = p_def_res_rec.resi_cat_object_id
       AND OBJECT_VERSION_NUMBER = p_def_res_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 538

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_FE_RESI_CAT_OBJECTS
     WHERE RESI_CAT_OBJECT_ID = p_def_res_rec.resi_cat_object_id;
Line: 571

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 580

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 689

PROCEDURE update_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_res_rec			 IN okl_res_rec,
	 x_res_rec			 OUT NOCOPY okl_res_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 698

	l_api_name			CONSTANT VARCHAR2(30):='v_insert_row';
Line: 710

   l_res_rec .LAST_UPDATE_DATE := SYSDATE;
Line: 711

  l_res_rec .LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 712

  l_res_rec .LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 767

	IF (x_res_rec.LAST_UPDATED_BY IS NULL)
	THEN
	 x_res_rec.LAST_UPDATED_BY:=l_res_rec.LAST_UPDATED_BY;
Line: 771

	IF (x_res_rec.LAST_UPDATE_DATE IS NULL)
	THEN
	 x_res_rec.LAST_UPDATE_DATE:=l_res_rec.LAST_UPDATE_DATE;
Line: 775

	IF (x_res_rec.LAST_UPDATE_LOGIN IS NULL)
	THEN
	 x_res_rec.LAST_UPDATE_LOGIN:=l_res_rec.LAST_UPDATE_LOGIN;
Line: 851

UPDATE OKL_FE_RESI_CAT_OBJECTS
 SET
	RESI_CAT_OBJECT_ID= l_def_res_rec.RESI_CAT_OBJECT_ID,
	OBJECT_VERSION_NUMBER=l_def_res_rec.OBJECT_VERSION_NUMBER+1,
	RESI_CATEGORY_SET_ID= l_def_res_rec.RESI_CATEGORY_SET_ID,
	CREATED_BY= l_def_res_rec.CREATED_BY,
	CREATION_DATE= l_def_res_rec.CREATION_DATE,
	LAST_UPDATED_BY= l_def_res_rec.LAST_UPDATED_BY,
	LAST_UPDATE_DATE= l_def_res_rec.LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN= l_def_res_rec.LAST_UPDATE_LOGIN,
	INVENTORY_ITEM_ID= l_def_res_rec.INVENTORY_ITEM_ID,
	ORGANIZATION_ID= l_def_res_rec.ORGANIZATION_ID,
	CATEGORY_ID= l_def_res_rec.CATEGORY_ID,
	CATEGORY_SET_ID= l_def_res_rec.CATEGORY_SET_ID
 WHERE RESI_CAT_OBJECT_ID = l_def_res_rec.RESI_CAT_OBJECT_ID;
Line: 908

   END update_row;
Line: 912

PROCEDURE update_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_res_tbl			 IN okl_res_tbl,
	 x_res_tbl			 OUT NOCOPY okl_res_tbl)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 921

	l_api_name			CONSTANT VARCHAR2(30):='v_update_row';
Line: 931

	   update_row (p_api_version			=> p_api_version,
		p_init_msg_list			=> OKC_API.G_FALSE,
		x_return_status			=> x_return_status,
		x_msg_count			=> x_msg_count,
		x_msg_data			=> x_msg_data,
		p_res_rec			=> p_res_tbl(i),
		x_res_rec			=> x_res_tbl(i));
Line: 987

   END update_row;
Line: 991

PROCEDURE delete_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_res_rec			 IN okl_res_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 999

	l_api_name			CONSTANT VARCHAR2(30):='delete_row';
Line: 1018

	DELETE FROM OKL_FE_RESI_CAT_OBJECTS
	WHERE RESI_CAT_OBJECT_ID=l_res_rec.RESI_CAT_OBJECT_ID;
Line: 1058

   END delete_row;
Line: 1063

PROCEDURE delete_row(
	 p_api_version			 IN NUMBER ,
	 p_init_msg_list		 IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
	 x_return_status		 OUT NOCOPY VARCHAR2,
	 x_msg_count			 OUT NOCOPY NUMBER,
	 x_msg_data			 OUT NOCOPY VARCHAR2,
	 p_res_tbl			 IN okl_res_tbl)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1071

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

	   delete_row (p_api_version			=> p_api_version,
		p_init_msg_list			=> OKC_API.G_FALSE,
		x_return_status			=> x_return_status,
		x_msg_count			=> x_msg_count,
		x_msg_data			=> x_msg_data,
		p_res_rec			=> p_res_tbl(i));
Line: 1136

   END delete_row;