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)
                SELECT b.RESI_CATEGORY_SET_ID
                      ,l.language_code
                      ,b.source_lang
                      ,b.sfwt_flag
                      ,b.RESI_CAT_DESC
                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: 81

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

   END insert_row;
Line: 880

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

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

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

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

   END insert_row;
Line: 1006

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

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

  l_rcsv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1032

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

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

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

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

   END insert_row;
Line: 1168

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

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

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

   END insert_row;
Line: 1262

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

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

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

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

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

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

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

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

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

   END update_row;
Line: 1766

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

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

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

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

   END update_row;
Line: 1876

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

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

   l_rcsv_rec .LAST_UPDATE_DATE := SYSDATE;
Line: 1900

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

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

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

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

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

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

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

   END update_row;
Line: 2121

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

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

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

   END update_row;
Line: 2200

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

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

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

   END delete_row;
Line: 2271

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

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

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

   END delete_row;
Line: 2362

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

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

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

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

   END delete_row;
Line: 2459

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

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

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

   END delete_row;