DBA Data[Home] [Help]

APPS.OKL_RCS_PVT SQL Statements

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

Line: 29

    DELETE FROM OKL_FE_RESI_CAT_ALL_TL t
    WHERE       NOT EXISTS(SELECT NULL
                           FROM   OKL_FE_RESI_CAT_ALL_B b
                           WHERE  b.RESI_CATEGORY_SET_ID = t.RESI_CATEGORY_SET_ID);
Line: 34

    UPDATE OKL_FE_RESI_CAT_ALL_TL t
    SET(RESI_CAT_DESC) = (SELECT
                                    -- LANGUAGE,

                                    -- B.LANGUAGE,

                                     b.RESI_CAT_DESC
                              FROM   OKL_FE_RESI_CAT_ALL_TL b
                              WHERE  b.RESI_CATEGORY_SET_ID = t.RESI_CATEGORY_SET_ID
                                 AND b.language = t.source_lang)
    WHERE  (t.RESI_CATEGORY_SET_ID, t.language) IN(SELECT subt.RESI_CATEGORY_SET_ID ,subt.language
           FROM   OKL_FE_RESI_CAT_ALL_TL subb ,OKL_FE_RESI_CAT_ALL_TL subt
           WHERE  subb.RESI_CATEGORY_SET_ID = subt.RESI_CATEGORY_SET_ID AND subb.language = subt.language AND (  -- SUBB.LANGUAGE <> SUBT.LANGUAGE OR
             subb.RESI_CAT_DESC <> subt.RESI_CAT_DESC OR (subb.language IS NOT NULL
       AND subt.language IS NULL)
            OR (subb.RESI_CAT_DESC IS NULL AND subt.RESI_CAT_DESC IS NOT NULL)));
Line: 51

    INSERT INTO OKL_FE_RESI_CAT_ALL_TL
               (RESI_CATEGORY_SET_ID
               ,language
               ,source_lang
               ,sfwt_flag
               ,RESI_CAT_DESC
               ,CREATED_BY
               ,CREATION_DATE
               ,LAST_UPDATED_BY
               ,LAST_UPDATE_DATE
               ,LAST_UPDATE_LOGIN)
                SELECT b.RESI_CATEGORY_SET_ID
                      ,l.language_code
                      ,b.source_lang
                      ,b.sfwt_flag
                      ,b.RESI_CAT_DESC
                      ,b.CREATED_BY
                      ,b.CREATION_DATE
                      ,b.LAST_UPDATED_BY
                      ,b.LAST_UPDATE_DATE
                      ,b.LAST_UPDATE_LOGIN
                FROM   OKL_FE_RESI_CAT_ALL_TL b
                      ,fnd_languages l
                WHERE  l.installed_flag IN('I', 'B')
                   AND b.language = userenv('LANG')
                   AND NOT EXISTS(SELECT NULL
                                      FROM   OKL_FE_RESI_CAT_ALL_TL t
                                      WHERE  t.RESI_CATEGORY_SET_ID = b.RESI_CATEGORY_SET_ID AND t.language = l.language_code);
Line: 91

   SELECT
	RESI_CATEGORY_SET_ID,
	RESI_CAT_NAME,
	ORIG_RESI_CAT_SET_ID,
	OBJECT_VERSION_NUMBER,
	ORG_ID,
	SOURCE_CODE,
	STS_CODE,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
   FROM OKL_FE_RESI_CAT_ALL_B WHERE OKL_FE_RESI_CAT_ALL_B.resi_category_set_id=p_id;
Line: 121

	l_rcsb_rec.LAST_UPDATED_BY,
	l_rcsb_rec.LAST_UPDATE_DATE,
	l_rcsb_rec.LAST_UPDATE_LOGIN;
Line: 145

   SELECT
	RESI_CATEGORY_SET_ID,
	LANGUAGE,
	SOURCE_LANG,
	SFWT_FLAG,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN,
	RESI_CAT_DESC
   FROM OKL_FE_RESI_CAT_ALL_TL WHERE OKL_FE_RESI_CAT_ALL_TL.resi_category_set_id=p_id AND OKL_FE_RESI_CAT_ALL_TL.language=p_language;
Line: 170

	l_rcstl_rec.LAST_UPDATED_BY,
	l_rcstl_rec.LAST_UPDATE_DATE,
	l_rcstl_rec.LAST_UPDATE_LOGIN,
	l_rcstl_rec.RESI_CAT_DESC;
Line: 195

   SELECT
	RESI_CATEGORY_SET_ID,
	ORIG_RESI_CAT_SET_ID,
        OBJECT_VERSION_NUMBER,
	ORG_ID,
	SOURCE_CODE,
	STS_CODE,
	RESI_CAT_NAME,
	RESI_CAT_DESC,
	SFWT_FLAG,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
   FROM OKL_FE_RESI_CAT_V WHERE OKL_FE_RESI_CAT_V.resi_category_set_id=p_id;
Line: 229

	l_rcsv_rec.LAST_UPDATED_BY,
	l_rcsv_rec.LAST_UPDATE_DATE,
	l_rcsv_rec.LAST_UPDATE_LOGIN;
Line: 262

	p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;
Line: 263

	p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
Line: 264

	p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;
Line: 281

	p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;
Line: 282

	p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
Line: 283

	p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;
Line: 295

	p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;
Line: 296

	p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
Line: 297

	p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;
Line: 310

	p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;
Line: 311

	p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
Line: 312

	p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;
Line: 353

	IF (l_rcsv_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
	 l_rcsv_rec.LAST_UPDATED_BY:=NULL;
Line: 356

	IF (l_rcsv_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
	 l_rcsv_rec.LAST_UPDATE_DATE:=NULL;
Line: 359

	IF (l_rcsv_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN
	 l_rcsv_rec.LAST_UPDATE_LOGIN:=NULL;
Line: 381

        SELECT
            RESI_CATEGORY_SET_ID
         FROM
             -- viselvar Bug 4860445 modified start
             OKL_FE_RESI_CAT_V RCS_B
             -- viselvar Bug 4860445 modifield end
         WHERE
	      RCS_B.RESI_CAT_NAME = p_rcsb_rec.resi_cat_name;
Line: 764

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_rcsb_rec			 IN okl_rcsb_rec,
	 x_rcsb_rec			 OUT NOCOPY okl_rcsb_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 773

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

	INSERT INTO OKL_FE_RESI_CAT_ALL_B(
	   RESI_CATEGORY_SET_ID,
	   RESI_CAT_NAME,
	   ORIG_RESI_CAT_SET_ID,
	   OBJECT_VERSION_NUMBER,
	   ORG_ID,
	   SOURCE_CODE,
	   STS_CODE,
	   CREATED_BY,
	   CREATION_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATE_LOGIN)
	VALUES (
	   l_rcsb_rec.RESI_CATEGORY_SET_ID,
	   l_rcsb_rec.RESI_CAT_NAME,
	   l_rcsb_rec.ORIG_RESI_CAT_SET_ID,
	   l_rcsb_rec.OBJECT_VERSION_NUMBER,
	   l_rcsb_rec.ORG_ID,
	   l_rcsb_rec.SOURCE_CODE,
	   l_rcsb_rec.STS_CODE,
	   l_rcsb_rec.CREATED_BY,
	   l_rcsb_rec.CREATION_DATE,
	   l_rcsb_rec.LAST_UPDATED_BY,
	   l_rcsb_rec.LAST_UPDATE_DATE,
	   l_rcsb_rec.LAST_UPDATE_LOGIN);
Line: 886

   END insert_row;
Line: 890

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_rcstl_rec			 IN okl_rcstl_rec,
	 x_rcstl_rec			 OUT NOCOPY okl_rcstl_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 899

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

     SELECT * from fnd_languages
      where INSTALLED_FLAG IN ('I','B');
Line: 945

	INSERT INTO OKL_FE_RESI_CAT_ALL_TL(
	   RESI_CATEGORY_SET_ID,
	   LANGUAGE,
	   SOURCE_LANG,
	   SFWT_FLAG,
	   CREATED_BY,
	   CREATION_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATE_LOGIN,
	   RESI_CAT_DESC)
	VALUES (
	   l_rcstl_rec.RESI_CATEGORY_SET_ID,
	   l_rcstl_rec.LANGUAGE,
	   l_rcstl_rec.SOURCE_LANG,
	   l_rcstl_rec.SFWT_FLAG,
	   l_rcstl_rec.CREATED_BY,
	   l_rcstl_rec.CREATION_DATE,
	   l_rcstl_rec.LAST_UPDATED_BY,
	   l_rcstl_rec.LAST_UPDATE_DATE,
	   l_rcstl_rec.LAST_UPDATE_LOGIN,
	   l_rcstl_rec.RESI_CAT_DESC);
Line: 1012

   END insert_row;
Line: 1016

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_rcsv_rec			 IN okl_rcsv_rec,
	 x_rcsv_rec			 OUT NOCOPY okl_rcsv_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1025

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

  l_rcsv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1042

  l_rcsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1043

  l_rcsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1104

	insert_row(
	 p_api_version,
	 p_init_msg_list,
	 x_return_status,
	 x_msg_count,
	 x_msg_data,
	 l_rcsb_rec,
	 lx_rcsb_rec);
Line: 1119

	insert_row(
	 p_api_version,
	 p_init_msg_list,
	 x_return_status,
	 x_msg_count,
	 x_msg_data,
	 l_rcstl_rec,
	 lx_rcstl_rec);
Line: 1174

   END insert_row;
Line: 1178

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_rcsv_tbl			 IN okl_rcsv_tbl,
	 x_rcsv_tbl			 OUT NOCOPY okl_rcsv_tbl)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1187

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

	   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_rcsv_rec			=> p_rcsv_tbl(i),
		x_rcsv_rec			=> x_rcsv_tbl(i));
Line: 1253

   END insert_row;
Line: 1272

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_FE_RESI_CAT_ALL_B
     WHERE RESI_CATEGORY_SET_ID = p_rcsb_rec.RESI_CATEGORY_SET_ID
       AND OBJECT_VERSION_NUMBER = p_rcsb_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1279

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_FE_RESI_CAT_ALL_B
    WHERE RESI_CATEGORY_SET_ID = p_rcsb_rec.RESI_CATEGORY_SET_ID;
Line: 1320

      Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1329

      Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1388

    SELECT *
      FROM OKL_FE_RESI_CAT_ALL_TL
     WHERE RESI_CATEGORY_SET_ID = p_rcstl_rec.RESI_CATEGORY_SET_ID
    FOR UPDATE NOWAIT;
Line: 1424

      Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1668

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_rcsb_rec			 IN okl_rcsb_rec,
	 x_rcsb_rec			 OUT NOCOPY okl_rcsb_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1677

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

UPDATE OKL_FE_RESI_CAT_ALL_B
 SET
	RESI_CATEGORY_SET_ID= l_def_rcsb_rec.RESI_CATEGORY_SET_ID,
	RESI_CAT_NAME       =l_def_rcsb_rec.RESI_CAT_NAME,
	ORIG_RESI_CAT_SET_ID=l_def_rcsb_rec.ORIG_RESI_CAT_SET_ID,
	OBJECT_VERSION_NUMBER=l_def_rcsb_rec.OBJECT_VERSION_NUMBER+1,
	ORG_ID= l_def_rcsb_rec.ORG_ID,
	SOURCE_CODE= l_def_rcsb_rec.SOURCE_CODE,
	STS_CODE= l_def_rcsb_rec.STS_CODE,
	CREATED_BY= l_def_rcsb_rec.CREATED_BY,
	CREATION_DATE= l_def_rcsb_rec.CREATION_DATE,
	LAST_UPDATED_BY= l_def_rcsb_rec.LAST_UPDATED_BY,
	LAST_UPDATE_DATE= l_def_rcsb_rec.LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN= l_def_rcsb_rec.LAST_UPDATE_LOGIN
 WHERE RESI_CATEGORY_SET_ID = l_def_rcsb_rec.resi_category_set_id;
Line: 1772

   END update_row;
Line: 1776

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_rcstl_rec			 IN okl_rcstl_rec,
	 x_rcstl_rec			 OUT NOCOPY okl_rcstl_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1785

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

UPDATE OKL_FE_RESI_CAT_ALL_TL
 SET
	RESI_CATEGORY_SET_ID= l_def_rcstl_rec.RESI_CATEGORY_SET_ID,
	SOURCE_LANG= l_def_rcstl_rec.SOURCE_LANG,
	SFWT_FLAG= l_def_rcstl_rec.SFWT_FLAG,
	CREATED_BY= l_def_rcstl_rec.CREATED_BY,
	CREATION_DATE= l_def_rcstl_rec.CREATION_DATE,
	LAST_UPDATED_BY= l_def_rcstl_rec.LAST_UPDATED_BY,
	LAST_UPDATE_DATE= l_def_rcstl_rec.LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN= l_def_rcstl_rec.LAST_UPDATE_LOGIN,
	RESI_CAT_DESC= l_def_rcstl_rec.RESI_CAT_DESC
 WHERE
       RESI_CATEGORY_SET_ID   = l_def_rcstl_rec.resi_category_set_id;
Line: 1837

UPDATE OKL_FE_RESI_CAT_ALL_TL
	SET SFWT_FLAG='Y' WHERE RESI_CATEGORY_SET_ID =l_def_rcstl_rec.resi_category_set_id
	AND SOURCE_LANG<>USERENV('LANG');
Line: 1882

   END update_row;
Line: 1886

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_rcsv_rec			 IN okl_rcsv_rec,
	 x_rcsv_rec			 OUT NOCOPY okl_rcsv_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 1895

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

   l_rcsv_rec .LAST_UPDATE_DATE := SYSDATE;
Line: 1910

  l_rcsv_rec .LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1911

  l_rcsv_rec .LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1974

	IF (x_rcsv_rec.LAST_UPDATED_BY IS NULL)
	THEN
	 x_rcsv_rec.LAST_UPDATED_BY:=l_rcsv_rec.LAST_UPDATED_BY;
Line: 1978

	IF (x_rcsv_rec.LAST_UPDATE_DATE IS NULL)
	THEN
	 x_rcsv_rec.LAST_UPDATE_DATE:=l_rcsv_rec.LAST_UPDATE_DATE;
Line: 1982

	IF (x_rcsv_rec.LAST_UPDATE_LOGIN IS NULL)
	THEN
	 x_rcsv_rec.LAST_UPDATE_LOGIN:=l_rcsv_rec.LAST_UPDATE_LOGIN;
Line: 2056

	update_row(
	 p_api_version,
	 p_init_msg_list,
	 l_return_status,
	 x_msg_count,
	 x_msg_data,
	 l_rcsb_rec,
	 lx_rcsb_rec);
Line: 2070

	update_row(
	 p_api_version,
	 p_init_msg_list,
	 l_return_status,
	 x_msg_count,
	 x_msg_data,
	 l_rcstl_rec,
	 lx_rcstl_rec);
Line: 2127

   END update_row;
Line: 2131

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_rcsv_tbl			 IN okl_rcsv_tbl,
	 x_rcsv_tbl			 OUT NOCOPY okl_rcsv_tbl)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 2140

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

	   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_rcsv_rec			=> p_rcsv_tbl(i),
		x_rcsv_rec			=> x_rcsv_tbl(i));
Line: 2206

   END update_row;
Line: 2210

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_rcsb_rec			 IN okl_rcsb_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 2218

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

	DELETE FROM OKL_FE_RESI_CAT_ALL_B
	WHERE RESI_CATEGORY_SET_ID=l_rcsb_rec.resi_category_set_id;
Line: 2277

   END delete_row;
Line: 2281

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_rcstl_rec			 IN okl_rcstl_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 2289

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

	DELETE FROM OKL_FE_RESI_CAT_ALL_TL
	WHERE RESI_CATEGORY_SET_ID=l_rcstl_rec.resi_category_set_id;
Line: 2368

   END delete_row;
Line: 2372

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_rcsv_rec			 IN okl_rcsv_rec)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 2380

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

	delete_row(
	 p_api_version,
	 p_init_msg_list,
	 x_return_status,
	 x_msg_count,
	 x_msg_data,
	 l_rcsb_rec);
Line: 2414

	delete_row(
	 p_api_version,
	 p_init_msg_list,
	 x_return_status,
	 x_msg_count,
	 x_msg_data,
	 l_rcstl_rec);
Line: 2465

   END delete_row;
Line: 2469

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_rcsv_tbl			 IN okl_rcsv_tbl)IS
	l_api_version			CONSTANT NUMBER:=1;
Line: 2477

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

	   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_rcsv_rec			=> p_rcsv_tbl(i));
Line: 2542

   END delete_row;