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.OKL_ANT_PVT dependencies on OKL_ANSWER_SETS_TL

Line 227: DELETE FROM OKL_ANSWER_SETS_TL T

223: -- PROCEDURE add_language
224: ---------------------------------------------------------------------------
225: PROCEDURE add_language IS
226: BEGIN
227: DELETE FROM OKL_ANSWER_SETS_TL T
228: WHERE NOT EXISTS (
229: SELECT NULL
230: FROM OKL_ANSWER_SETS_B B --fixed bug 3321017 by kmotepal
231: WHERE B.ID = T.ID

Line 234: UPDATE OKL_ANSWER_SETS_TL T SET (

230: FROM OKL_ANSWER_SETS_B B --fixed bug 3321017 by kmotepal
231: WHERE B.ID = T.ID
232: );
233:
234: UPDATE OKL_ANSWER_SETS_TL T SET (
235: NAME,
236: DESCRIPTION) = (SELECT
237: B.NAME,
238: B.DESCRIPTION

Line 239: FROM OKL_ANSWER_SETS_TL B

235: NAME,
236: DESCRIPTION) = (SELECT
237: B.NAME,
238: B.DESCRIPTION
239: FROM OKL_ANSWER_SETS_TL B
240: WHERE B.ID = T.ID
241: AND B.LANGUAGE = T.SOURCE_LANG)
242: WHERE (
243: T.ID,

Line 248: FROM OKL_ANSWER_SETS_TL SUBB, OKL_ANSWER_SETS_TL SUBT

244: T.LANGUAGE)
245: IN (SELECT
246: SUBT.ID,
247: SUBT.LANGUAGE
248: FROM OKL_ANSWER_SETS_TL SUBB, OKL_ANSWER_SETS_TL SUBT
249: WHERE SUBB.ID = SUBT.ID
250: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
251: AND (SUBB.NAME <> SUBT.NAME
252: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 257: INSERT INTO OKL_ANSWER_SETS_TL (

253: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
254: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
255: ));
256:
257: INSERT INTO OKL_ANSWER_SETS_TL (
258: ID,
259: LANGUAGE,
260: SOURCE_LANG,
261: SFWT_FLAG,

Line 281: FROM OKL_ANSWER_SETS_TL B, FND_LANGUAGES L

277: B.CREATION_DATE,
278: B.LAST_UPDATED_BY,
279: B.LAST_UPDATE_DATE,
280: B.LAST_UPDATE_LOGIN
281: FROM OKL_ANSWER_SETS_TL B, FND_LANGUAGES L
282: WHERE L.INSTALLED_FLAG IN ('I', 'B')
283: AND B.LANGUAGE = USERENV('LANG')
284: AND NOT EXISTS(
285: SELECT NULL

Line 286: FROM OKL_ANSWER_SETS_TL T

282: WHERE L.INSTALLED_FLAG IN ('I', 'B')
283: AND B.LANGUAGE = USERENV('LANG')
284: AND NOT EXISTS(
285: SELECT NULL
286: FROM OKL_ANSWER_SETS_TL T
287: WHERE T.ID = B.ID
288: AND T.LANGUAGE = L.LANGUAGE_CODE
289: );
290:

Line 384: -- FUNCTION get_rec for: OKL_ANSWER_SETS_TL

380: BEGIN
381: RETURN(get_rec(p_ant_rec, l_row_notfound));
382: END get_rec;
383: ---------------------------------------------------------------------------
384: -- FUNCTION get_rec for: OKL_ANSWER_SETS_TL
385: ---------------------------------------------------------------------------
386: FUNCTION get_rec (
387: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
388: x_no_data_found OUT NOCOPY BOOLEAN

Line 387: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,

383: ---------------------------------------------------------------------------
384: -- FUNCTION get_rec for: OKL_ANSWER_SETS_TL
385: ---------------------------------------------------------------------------
386: FUNCTION get_rec (
387: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
388: x_no_data_found OUT NOCOPY BOOLEAN
389: ) RETURN okl_answer_sets_tl_rec_type IS
390: CURSOR okl_answer_sets_tl_pk_csr (p_id IN NUMBER,
391: p_language IN VARCHAR2) IS

Line 389: ) RETURN okl_answer_sets_tl_rec_type IS

385: ---------------------------------------------------------------------------
386: FUNCTION get_rec (
387: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
388: x_no_data_found OUT NOCOPY BOOLEAN
389: ) RETURN okl_answer_sets_tl_rec_type IS
390: CURSOR okl_answer_sets_tl_pk_csr (p_id IN NUMBER,
391: p_language IN VARCHAR2) IS
392: SELECT
393: ID,

Line 390: CURSOR okl_answer_sets_tl_pk_csr (p_id IN NUMBER,

386: FUNCTION get_rec (
387: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
388: x_no_data_found OUT NOCOPY BOOLEAN
389: ) RETURN okl_answer_sets_tl_rec_type IS
390: CURSOR okl_answer_sets_tl_pk_csr (p_id IN NUMBER,
391: p_language IN VARCHAR2) IS
392: SELECT
393: ID,
394: LANGUAGE,

Line 404: FROM Okl_Answer_Sets_Tl

400: CREATION_DATE,
401: LAST_UPDATED_BY,
402: LAST_UPDATE_DATE,
403: LAST_UPDATE_LOGIN
404: FROM Okl_Answer_Sets_Tl
405: WHERE okl_answer_sets_tl.id = p_id
406: AND okl_answer_sets_tl.LANGUAGE = p_language;
407: l_okl_answer_sets_tl_pk okl_answer_sets_tl_pk_csr%ROWTYPE;
408: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

Line 405: WHERE okl_answer_sets_tl.id = p_id

401: LAST_UPDATED_BY,
402: LAST_UPDATE_DATE,
403: LAST_UPDATE_LOGIN
404: FROM Okl_Answer_Sets_Tl
405: WHERE okl_answer_sets_tl.id = p_id
406: AND okl_answer_sets_tl.LANGUAGE = p_language;
407: l_okl_answer_sets_tl_pk okl_answer_sets_tl_pk_csr%ROWTYPE;
408: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
409: BEGIN

Line 406: AND okl_answer_sets_tl.LANGUAGE = p_language;

402: LAST_UPDATE_DATE,
403: LAST_UPDATE_LOGIN
404: FROM Okl_Answer_Sets_Tl
405: WHERE okl_answer_sets_tl.id = p_id
406: AND okl_answer_sets_tl.LANGUAGE = p_language;
407: l_okl_answer_sets_tl_pk okl_answer_sets_tl_pk_csr%ROWTYPE;
408: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
409: BEGIN
410: x_no_data_found := TRUE;

Line 407: l_okl_answer_sets_tl_pk okl_answer_sets_tl_pk_csr%ROWTYPE;

403: LAST_UPDATE_LOGIN
404: FROM Okl_Answer_Sets_Tl
405: WHERE okl_answer_sets_tl.id = p_id
406: AND okl_answer_sets_tl.LANGUAGE = p_language;
407: l_okl_answer_sets_tl_pk okl_answer_sets_tl_pk_csr%ROWTYPE;
408: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
409: BEGIN
410: x_no_data_found := TRUE;
411: -- Get current database values

Line 408: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

404: FROM Okl_Answer_Sets_Tl
405: WHERE okl_answer_sets_tl.id = p_id
406: AND okl_answer_sets_tl.LANGUAGE = p_language;
407: l_okl_answer_sets_tl_pk okl_answer_sets_tl_pk_csr%ROWTYPE;
408: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
409: BEGIN
410: x_no_data_found := TRUE;
411: -- Get current database values
412: OPEN okl_answer_sets_tl_pk_csr (p_okl_answer_sets_tl_rec.id,

Line 412: OPEN okl_answer_sets_tl_pk_csr (p_okl_answer_sets_tl_rec.id,

408: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
409: BEGIN
410: x_no_data_found := TRUE;
411: -- Get current database values
412: OPEN okl_answer_sets_tl_pk_csr (p_okl_answer_sets_tl_rec.id,
413: p_okl_answer_sets_tl_rec.LANGUAGE);
414: FETCH okl_answer_sets_tl_pk_csr INTO
415: l_okl_answer_sets_tl_rec.ID,
416: l_okl_answer_sets_tl_rec.LANGUAGE,

Line 413: p_okl_answer_sets_tl_rec.LANGUAGE);

409: BEGIN
410: x_no_data_found := TRUE;
411: -- Get current database values
412: OPEN okl_answer_sets_tl_pk_csr (p_okl_answer_sets_tl_rec.id,
413: p_okl_answer_sets_tl_rec.LANGUAGE);
414: FETCH okl_answer_sets_tl_pk_csr INTO
415: l_okl_answer_sets_tl_rec.ID,
416: l_okl_answer_sets_tl_rec.LANGUAGE,
417: l_okl_answer_sets_tl_rec.SOURCE_LANG,

Line 414: FETCH okl_answer_sets_tl_pk_csr INTO

410: x_no_data_found := TRUE;
411: -- Get current database values
412: OPEN okl_answer_sets_tl_pk_csr (p_okl_answer_sets_tl_rec.id,
413: p_okl_answer_sets_tl_rec.LANGUAGE);
414: FETCH okl_answer_sets_tl_pk_csr INTO
415: l_okl_answer_sets_tl_rec.ID,
416: l_okl_answer_sets_tl_rec.LANGUAGE,
417: l_okl_answer_sets_tl_rec.SOURCE_LANG,
418: l_okl_answer_sets_tl_rec.SFWT_FLAG,

Line 415: l_okl_answer_sets_tl_rec.ID,

411: -- Get current database values
412: OPEN okl_answer_sets_tl_pk_csr (p_okl_answer_sets_tl_rec.id,
413: p_okl_answer_sets_tl_rec.LANGUAGE);
414: FETCH okl_answer_sets_tl_pk_csr INTO
415: l_okl_answer_sets_tl_rec.ID,
416: l_okl_answer_sets_tl_rec.LANGUAGE,
417: l_okl_answer_sets_tl_rec.SOURCE_LANG,
418: l_okl_answer_sets_tl_rec.SFWT_FLAG,
419: l_okl_answer_sets_tl_rec.NAME,

Line 416: l_okl_answer_sets_tl_rec.LANGUAGE,

412: OPEN okl_answer_sets_tl_pk_csr (p_okl_answer_sets_tl_rec.id,
413: p_okl_answer_sets_tl_rec.LANGUAGE);
414: FETCH okl_answer_sets_tl_pk_csr INTO
415: l_okl_answer_sets_tl_rec.ID,
416: l_okl_answer_sets_tl_rec.LANGUAGE,
417: l_okl_answer_sets_tl_rec.SOURCE_LANG,
418: l_okl_answer_sets_tl_rec.SFWT_FLAG,
419: l_okl_answer_sets_tl_rec.NAME,
420: l_okl_answer_sets_tl_rec.DESCRIPTION,

Line 417: l_okl_answer_sets_tl_rec.SOURCE_LANG,

413: p_okl_answer_sets_tl_rec.LANGUAGE);
414: FETCH okl_answer_sets_tl_pk_csr INTO
415: l_okl_answer_sets_tl_rec.ID,
416: l_okl_answer_sets_tl_rec.LANGUAGE,
417: l_okl_answer_sets_tl_rec.SOURCE_LANG,
418: l_okl_answer_sets_tl_rec.SFWT_FLAG,
419: l_okl_answer_sets_tl_rec.NAME,
420: l_okl_answer_sets_tl_rec.DESCRIPTION,
421: l_okl_answer_sets_tl_rec.CREATED_BY,

Line 418: l_okl_answer_sets_tl_rec.SFWT_FLAG,

414: FETCH okl_answer_sets_tl_pk_csr INTO
415: l_okl_answer_sets_tl_rec.ID,
416: l_okl_answer_sets_tl_rec.LANGUAGE,
417: l_okl_answer_sets_tl_rec.SOURCE_LANG,
418: l_okl_answer_sets_tl_rec.SFWT_FLAG,
419: l_okl_answer_sets_tl_rec.NAME,
420: l_okl_answer_sets_tl_rec.DESCRIPTION,
421: l_okl_answer_sets_tl_rec.CREATED_BY,
422: l_okl_answer_sets_tl_rec.CREATION_DATE,

Line 419: l_okl_answer_sets_tl_rec.NAME,

415: l_okl_answer_sets_tl_rec.ID,
416: l_okl_answer_sets_tl_rec.LANGUAGE,
417: l_okl_answer_sets_tl_rec.SOURCE_LANG,
418: l_okl_answer_sets_tl_rec.SFWT_FLAG,
419: l_okl_answer_sets_tl_rec.NAME,
420: l_okl_answer_sets_tl_rec.DESCRIPTION,
421: l_okl_answer_sets_tl_rec.CREATED_BY,
422: l_okl_answer_sets_tl_rec.CREATION_DATE,
423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,

Line 420: l_okl_answer_sets_tl_rec.DESCRIPTION,

416: l_okl_answer_sets_tl_rec.LANGUAGE,
417: l_okl_answer_sets_tl_rec.SOURCE_LANG,
418: l_okl_answer_sets_tl_rec.SFWT_FLAG,
419: l_okl_answer_sets_tl_rec.NAME,
420: l_okl_answer_sets_tl_rec.DESCRIPTION,
421: l_okl_answer_sets_tl_rec.CREATED_BY,
422: l_okl_answer_sets_tl_rec.CREATION_DATE,
423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,
424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,

Line 421: l_okl_answer_sets_tl_rec.CREATED_BY,

417: l_okl_answer_sets_tl_rec.SOURCE_LANG,
418: l_okl_answer_sets_tl_rec.SFWT_FLAG,
419: l_okl_answer_sets_tl_rec.NAME,
420: l_okl_answer_sets_tl_rec.DESCRIPTION,
421: l_okl_answer_sets_tl_rec.CREATED_BY,
422: l_okl_answer_sets_tl_rec.CREATION_DATE,
423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,
424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,
425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;

Line 422: l_okl_answer_sets_tl_rec.CREATION_DATE,

418: l_okl_answer_sets_tl_rec.SFWT_FLAG,
419: l_okl_answer_sets_tl_rec.NAME,
420: l_okl_answer_sets_tl_rec.DESCRIPTION,
421: l_okl_answer_sets_tl_rec.CREATED_BY,
422: l_okl_answer_sets_tl_rec.CREATION_DATE,
423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,
424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,
425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;
426: x_no_data_found := okl_answer_sets_tl_pk_csr%NOTFOUND;

Line 423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,

419: l_okl_answer_sets_tl_rec.NAME,
420: l_okl_answer_sets_tl_rec.DESCRIPTION,
421: l_okl_answer_sets_tl_rec.CREATED_BY,
422: l_okl_answer_sets_tl_rec.CREATION_DATE,
423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,
424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,
425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;
426: x_no_data_found := okl_answer_sets_tl_pk_csr%NOTFOUND;
427: CLOSE okl_answer_sets_tl_pk_csr;

Line 424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,

420: l_okl_answer_sets_tl_rec.DESCRIPTION,
421: l_okl_answer_sets_tl_rec.CREATED_BY,
422: l_okl_answer_sets_tl_rec.CREATION_DATE,
423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,
424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,
425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;
426: x_no_data_found := okl_answer_sets_tl_pk_csr%NOTFOUND;
427: CLOSE okl_answer_sets_tl_pk_csr;
428: RETURN(l_okl_answer_sets_tl_rec);

Line 425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;

421: l_okl_answer_sets_tl_rec.CREATED_BY,
422: l_okl_answer_sets_tl_rec.CREATION_DATE,
423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,
424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,
425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;
426: x_no_data_found := okl_answer_sets_tl_pk_csr%NOTFOUND;
427: CLOSE okl_answer_sets_tl_pk_csr;
428: RETURN(l_okl_answer_sets_tl_rec);
429: END get_rec;

Line 426: x_no_data_found := okl_answer_sets_tl_pk_csr%NOTFOUND;

422: l_okl_answer_sets_tl_rec.CREATION_DATE,
423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,
424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,
425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;
426: x_no_data_found := okl_answer_sets_tl_pk_csr%NOTFOUND;
427: CLOSE okl_answer_sets_tl_pk_csr;
428: RETURN(l_okl_answer_sets_tl_rec);
429: END get_rec;
430:

Line 427: CLOSE okl_answer_sets_tl_pk_csr;

423: l_okl_answer_sets_tl_rec.LAST_UPDATED_BY,
424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,
425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;
426: x_no_data_found := okl_answer_sets_tl_pk_csr%NOTFOUND;
427: CLOSE okl_answer_sets_tl_pk_csr;
428: RETURN(l_okl_answer_sets_tl_rec);
429: END get_rec;
430:
431: FUNCTION get_rec (

Line 428: RETURN(l_okl_answer_sets_tl_rec);

424: l_okl_answer_sets_tl_rec.LAST_UPDATE_DATE,
425: l_okl_answer_sets_tl_rec.LAST_UPDATE_LOGIN;
426: x_no_data_found := okl_answer_sets_tl_pk_csr%NOTFOUND;
427: CLOSE okl_answer_sets_tl_pk_csr;
428: RETURN(l_okl_answer_sets_tl_rec);
429: END get_rec;
430:
431: FUNCTION get_rec (
432: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type

Line 432: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type

428: RETURN(l_okl_answer_sets_tl_rec);
429: END get_rec;
430:
431: FUNCTION get_rec (
432: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type
433: ) RETURN okl_answer_sets_tl_rec_type IS
434: l_row_notfound BOOLEAN := TRUE;
435: BEGIN
436: RETURN(get_rec(p_okl_answer_sets_tl_rec, l_row_notfound));

Line 433: ) RETURN okl_answer_sets_tl_rec_type IS

429: END get_rec;
430:
431: FUNCTION get_rec (
432: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type
433: ) RETURN okl_answer_sets_tl_rec_type IS
434: l_row_notfound BOOLEAN := TRUE;
435: BEGIN
436: RETURN(get_rec(p_okl_answer_sets_tl_rec, l_row_notfound));
437: END get_rec;

Line 436: RETURN(get_rec(p_okl_answer_sets_tl_rec, l_row_notfound));

432: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type
433: ) RETURN okl_answer_sets_tl_rec_type IS
434: l_row_notfound BOOLEAN := TRUE;
435: BEGIN
436: RETURN(get_rec(p_okl_answer_sets_tl_rec, l_row_notfound));
437: END get_rec;
438: ---------------------------------------------------------------------------
439: -- FUNCTION get_rec for: OKL_ANSWER_SETS_V
440: ---------------------------------------------------------------------------

Line 818: p_to OUT NOCOPY okl_answer_sets_tl_rec_type

814: p_to.last_update_login := p_from.last_update_login;
815: END migrate;
816: PROCEDURE migrate (
817: p_from IN antv_rec_type,
818: p_to OUT NOCOPY okl_answer_sets_tl_rec_type
819: ) IS
820: BEGIN
821: p_to.id := p_from.id;
822: p_to.sfwt_flag := p_from.sfwt_flag;

Line 832: p_from IN okl_answer_sets_tl_rec_type,

828: p_to.last_update_date := p_from.last_update_date;
829: p_to.last_update_login := p_from.last_update_login;
830: END migrate;
831: PROCEDURE migrate (
832: p_from IN okl_answer_sets_tl_rec_type,
833: p_to OUT NOCOPY antv_rec_type
834: ) IS
835: BEGIN
836: p_to.id := p_from.id;

Line 866: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

862: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
863: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
864: l_antv_rec antv_rec_type := p_antv_rec;
865: l_ant_rec ant_rec_type;
866: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
867: BEGIN
868: l_return_status := okl_api.START_ACTIVITY(l_api_name,
869: G_PKG_NAME,
870: p_init_msg_list,

Line 1141: -- insert_row for:OKL_ANSWER_SETS_TL --

1137: '_PVT'
1138: );
1139: END insert_row;
1140: ---------------------------------------
1141: -- insert_row for:OKL_ANSWER_SETS_TL --
1142: ---------------------------------------
1143: PROCEDURE insert_row(
1144: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1145: x_return_status OUT NOCOPY VARCHAR2,

Line 1148: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,

1144: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1145: x_return_status OUT NOCOPY VARCHAR2,
1146: x_msg_count OUT NOCOPY NUMBER,
1147: x_msg_data OUT NOCOPY VARCHAR2,
1148: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
1149: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type) IS
1150:
1151: l_api_version CONSTANT NUMBER := 1;
1152: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1149: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type) IS

1145: x_return_status OUT NOCOPY VARCHAR2,
1146: x_msg_count OUT NOCOPY NUMBER,
1147: x_msg_data OUT NOCOPY VARCHAR2,
1148: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
1149: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type) IS
1150:
1151: l_api_version CONSTANT NUMBER := 1;
1152: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1153: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 1154: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type := p_okl_answer_sets_tl_rec;

1150:
1151: l_api_version CONSTANT NUMBER := 1;
1152: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1153: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1154: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type := p_okl_answer_sets_tl_rec;
1155: l_def_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
1156: CURSOR get_languages IS
1157: SELECT *
1158: FROM FND_LANGUAGES

Line 1155: l_def_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

1151: l_api_version CONSTANT NUMBER := 1;
1152: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1153: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1154: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type := p_okl_answer_sets_tl_rec;
1155: l_def_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
1156: CURSOR get_languages IS
1157: SELECT *
1158: FROM FND_LANGUAGES
1159: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1161: -- Set_Attributes for:OKL_ANSWER_SETS_TL --

1157: SELECT *
1158: FROM FND_LANGUAGES
1159: WHERE INSTALLED_FLAG IN ('I', 'B');
1160: -------------------------------------------
1161: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
1162: -------------------------------------------
1163: FUNCTION Set_Attributes (
1164: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
1165: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type

Line 1164: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,

1160: -------------------------------------------
1161: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
1162: -------------------------------------------
1163: FUNCTION Set_Attributes (
1164: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
1165: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
1166: ) RETURN VARCHAR2 IS
1167: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1168: BEGIN

Line 1165: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type

1161: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
1162: -------------------------------------------
1163: FUNCTION Set_Attributes (
1164: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
1165: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
1166: ) RETURN VARCHAR2 IS
1167: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1168: BEGIN
1169: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;

Line 1169: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;

1165: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
1166: ) RETURN VARCHAR2 IS
1167: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1168: BEGIN
1169: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
1170: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');
1171: x_okl_answer_sets_tl_rec.SOURCE_LANG := USERENV('LANG');
1172: RETURN(l_return_status);
1173: END Set_Attributes;

Line 1170: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');

1166: ) RETURN VARCHAR2 IS
1167: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1168: BEGIN
1169: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
1170: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');
1171: x_okl_answer_sets_tl_rec.SOURCE_LANG := USERENV('LANG');
1172: RETURN(l_return_status);
1173: END Set_Attributes;
1174: BEGIN

Line 1171: x_okl_answer_sets_tl_rec.SOURCE_LANG := USERENV('LANG');

1167: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1168: BEGIN
1169: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
1170: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');
1171: x_okl_answer_sets_tl_rec.SOURCE_LANG := USERENV('LANG');
1172: RETURN(l_return_status);
1173: END Set_Attributes;
1174: BEGIN
1175: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 1186: p_okl_answer_sets_tl_rec, -- IN

1182: RAISE okl_api.G_EXCEPTION_ERROR;
1183: END IF;
1184: --- Setting item attributes
1185: l_return_status := Set_Attributes(
1186: p_okl_answer_sets_tl_rec, -- IN
1187: l_okl_answer_sets_tl_rec); -- OUT
1188: --- If any errors happen abort API
1189: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1190: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1187: l_okl_answer_sets_tl_rec); -- OUT

1183: END IF;
1184: --- Setting item attributes
1185: l_return_status := Set_Attributes(
1186: p_okl_answer_sets_tl_rec, -- IN
1187: l_okl_answer_sets_tl_rec); -- OUT
1188: --- If any errors happen abort API
1189: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1190: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1191: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1195: l_okl_answer_sets_tl_rec.LANGUAGE := l_lang_rec.language_code;

1191: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1192: RAISE okl_api.G_EXCEPTION_ERROR;
1193: END IF;
1194: FOR l_lang_rec IN get_languages LOOP
1195: l_okl_answer_sets_tl_rec.LANGUAGE := l_lang_rec.language_code;
1196: INSERT INTO OKL_ANSWER_SETS_TL(
1197: id,
1198: LANGUAGE,
1199: source_lang,

Line 1196: INSERT INTO OKL_ANSWER_SETS_TL(

1192: RAISE okl_api.G_EXCEPTION_ERROR;
1193: END IF;
1194: FOR l_lang_rec IN get_languages LOOP
1195: l_okl_answer_sets_tl_rec.LANGUAGE := l_lang_rec.language_code;
1196: INSERT INTO OKL_ANSWER_SETS_TL(
1197: id,
1198: LANGUAGE,
1199: source_lang,
1200: sfwt_flag,

Line 1209: l_okl_answer_sets_tl_rec.id,

1205: last_updated_by,
1206: last_update_date,
1207: last_update_login)
1208: VALUES (
1209: l_okl_answer_sets_tl_rec.id,
1210: l_okl_answer_sets_tl_rec.LANGUAGE,
1211: l_okl_answer_sets_tl_rec.source_lang,
1212: l_okl_answer_sets_tl_rec.sfwt_flag,
1213: l_okl_answer_sets_tl_rec.name,

Line 1210: l_okl_answer_sets_tl_rec.LANGUAGE,

1206: last_update_date,
1207: last_update_login)
1208: VALUES (
1209: l_okl_answer_sets_tl_rec.id,
1210: l_okl_answer_sets_tl_rec.LANGUAGE,
1211: l_okl_answer_sets_tl_rec.source_lang,
1212: l_okl_answer_sets_tl_rec.sfwt_flag,
1213: l_okl_answer_sets_tl_rec.name,
1214: l_okl_answer_sets_tl_rec.description,

Line 1211: l_okl_answer_sets_tl_rec.source_lang,

1207: last_update_login)
1208: VALUES (
1209: l_okl_answer_sets_tl_rec.id,
1210: l_okl_answer_sets_tl_rec.LANGUAGE,
1211: l_okl_answer_sets_tl_rec.source_lang,
1212: l_okl_answer_sets_tl_rec.sfwt_flag,
1213: l_okl_answer_sets_tl_rec.name,
1214: l_okl_answer_sets_tl_rec.description,
1215: l_okl_answer_sets_tl_rec.created_by,

Line 1212: l_okl_answer_sets_tl_rec.sfwt_flag,

1208: VALUES (
1209: l_okl_answer_sets_tl_rec.id,
1210: l_okl_answer_sets_tl_rec.LANGUAGE,
1211: l_okl_answer_sets_tl_rec.source_lang,
1212: l_okl_answer_sets_tl_rec.sfwt_flag,
1213: l_okl_answer_sets_tl_rec.name,
1214: l_okl_answer_sets_tl_rec.description,
1215: l_okl_answer_sets_tl_rec.created_by,
1216: l_okl_answer_sets_tl_rec.creation_date,

Line 1213: l_okl_answer_sets_tl_rec.name,

1209: l_okl_answer_sets_tl_rec.id,
1210: l_okl_answer_sets_tl_rec.LANGUAGE,
1211: l_okl_answer_sets_tl_rec.source_lang,
1212: l_okl_answer_sets_tl_rec.sfwt_flag,
1213: l_okl_answer_sets_tl_rec.name,
1214: l_okl_answer_sets_tl_rec.description,
1215: l_okl_answer_sets_tl_rec.created_by,
1216: l_okl_answer_sets_tl_rec.creation_date,
1217: l_okl_answer_sets_tl_rec.last_updated_by,

Line 1214: l_okl_answer_sets_tl_rec.description,

1210: l_okl_answer_sets_tl_rec.LANGUAGE,
1211: l_okl_answer_sets_tl_rec.source_lang,
1212: l_okl_answer_sets_tl_rec.sfwt_flag,
1213: l_okl_answer_sets_tl_rec.name,
1214: l_okl_answer_sets_tl_rec.description,
1215: l_okl_answer_sets_tl_rec.created_by,
1216: l_okl_answer_sets_tl_rec.creation_date,
1217: l_okl_answer_sets_tl_rec.last_updated_by,
1218: l_okl_answer_sets_tl_rec.last_update_date,

Line 1215: l_okl_answer_sets_tl_rec.created_by,

1211: l_okl_answer_sets_tl_rec.source_lang,
1212: l_okl_answer_sets_tl_rec.sfwt_flag,
1213: l_okl_answer_sets_tl_rec.name,
1214: l_okl_answer_sets_tl_rec.description,
1215: l_okl_answer_sets_tl_rec.created_by,
1216: l_okl_answer_sets_tl_rec.creation_date,
1217: l_okl_answer_sets_tl_rec.last_updated_by,
1218: l_okl_answer_sets_tl_rec.last_update_date,
1219: l_okl_answer_sets_tl_rec.last_update_login);

Line 1216: l_okl_answer_sets_tl_rec.creation_date,

1212: l_okl_answer_sets_tl_rec.sfwt_flag,
1213: l_okl_answer_sets_tl_rec.name,
1214: l_okl_answer_sets_tl_rec.description,
1215: l_okl_answer_sets_tl_rec.created_by,
1216: l_okl_answer_sets_tl_rec.creation_date,
1217: l_okl_answer_sets_tl_rec.last_updated_by,
1218: l_okl_answer_sets_tl_rec.last_update_date,
1219: l_okl_answer_sets_tl_rec.last_update_login);
1220: END LOOP;

Line 1217: l_okl_answer_sets_tl_rec.last_updated_by,

1213: l_okl_answer_sets_tl_rec.name,
1214: l_okl_answer_sets_tl_rec.description,
1215: l_okl_answer_sets_tl_rec.created_by,
1216: l_okl_answer_sets_tl_rec.creation_date,
1217: l_okl_answer_sets_tl_rec.last_updated_by,
1218: l_okl_answer_sets_tl_rec.last_update_date,
1219: l_okl_answer_sets_tl_rec.last_update_login);
1220: END LOOP;
1221: -- Set OUT values

Line 1218: l_okl_answer_sets_tl_rec.last_update_date,

1214: l_okl_answer_sets_tl_rec.description,
1215: l_okl_answer_sets_tl_rec.created_by,
1216: l_okl_answer_sets_tl_rec.creation_date,
1217: l_okl_answer_sets_tl_rec.last_updated_by,
1218: l_okl_answer_sets_tl_rec.last_update_date,
1219: l_okl_answer_sets_tl_rec.last_update_login);
1220: END LOOP;
1221: -- Set OUT values
1222: x_okl_answer_sets_tl_rec := l_okl_answer_sets_tl_rec;

Line 1219: l_okl_answer_sets_tl_rec.last_update_login);

1215: l_okl_answer_sets_tl_rec.created_by,
1216: l_okl_answer_sets_tl_rec.creation_date,
1217: l_okl_answer_sets_tl_rec.last_updated_by,
1218: l_okl_answer_sets_tl_rec.last_update_date,
1219: l_okl_answer_sets_tl_rec.last_update_login);
1220: END LOOP;
1221: -- Set OUT values
1222: x_okl_answer_sets_tl_rec := l_okl_answer_sets_tl_rec;
1223: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1222: x_okl_answer_sets_tl_rec := l_okl_answer_sets_tl_rec;

1218: l_okl_answer_sets_tl_rec.last_update_date,
1219: l_okl_answer_sets_tl_rec.last_update_login);
1220: END LOOP;
1221: -- Set OUT values
1222: x_okl_answer_sets_tl_rec := l_okl_answer_sets_tl_rec;
1223: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1224: EXCEPTION
1225: WHEN okl_api.G_EXCEPTION_ERROR THEN
1226: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 1275: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

1271: l_antv_rec antv_rec_type;
1272: l_def_antv_rec antv_rec_type;
1273: l_ant_rec ant_rec_type;
1274: lx_ant_rec ant_rec_type;
1275: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
1276: lx_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
1277: -------------------------------
1278: -- FUNCTION fill_who_columns --
1279: -------------------------------

Line 1276: lx_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

1272: l_def_antv_rec antv_rec_type;
1273: l_ant_rec ant_rec_type;
1274: lx_ant_rec ant_rec_type;
1275: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
1276: lx_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
1277: -------------------------------
1278: -- FUNCTION fill_who_columns --
1279: -------------------------------
1280: FUNCTION fill_who_columns (

Line 1351: migrate(l_def_antv_rec, l_okl_answer_sets_tl_rec);

1347: --------------------------------------
1348: -- Move VIEW record to "Child" records
1349: --------------------------------------
1350: migrate(l_def_antv_rec, l_ant_rec);
1351: migrate(l_def_antv_rec, l_okl_answer_sets_tl_rec);
1352: --------------------------------------------
1353: -- Call the INSERT_ROW for each child record
1354: --------------------------------------------
1355: insert_row(

Line 1374: l_okl_answer_sets_tl_rec,

1370: p_init_msg_list,
1371: x_return_status,
1372: x_msg_count,
1373: x_msg_data,
1374: l_okl_answer_sets_tl_rec,
1375: lx_okl_answer_sets_tl_rec
1376: );
1377: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1378: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1375: lx_okl_answer_sets_tl_rec

1371: x_return_status,
1372: x_msg_count,
1373: x_msg_data,
1374: l_okl_answer_sets_tl_rec,
1375: lx_okl_answer_sets_tl_rec
1376: );
1377: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1378: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1379: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1382: migrate(lx_okl_answer_sets_tl_rec, l_def_antv_rec);

1378: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1379: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN
1380: RAISE okl_api.G_EXCEPTION_ERROR;
1381: END IF;
1382: migrate(lx_okl_answer_sets_tl_rec, l_def_antv_rec);
1383: -- Set OUT values
1384: x_antv_rec := l_def_antv_rec;
1385: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1386: EXCEPTION

Line 1595: -- lock_row for:OKL_ANSWER_SETS_TL --

1591: '_PVT'
1592: );
1593: END lock_row;
1594: -------------------------------------
1595: -- lock_row for:OKL_ANSWER_SETS_TL --
1596: -------------------------------------
1597: PROCEDURE lock_row(
1598: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1599: x_return_status OUT NOCOPY VARCHAR2,

Line 1602: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS

1598: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1599: x_return_status OUT NOCOPY VARCHAR2,
1600: x_msg_count OUT NOCOPY NUMBER,
1601: x_msg_data OUT NOCOPY VARCHAR2,
1602: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS
1603:
1604: E_Resource_Busy EXCEPTION;
1605: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1606: CURSOR lock_csr (p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS

Line 1606: CURSOR lock_csr (p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS

1602: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS
1603:
1604: E_Resource_Busy EXCEPTION;
1605: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1606: CURSOR lock_csr (p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS
1607: SELECT *
1608: FROM OKL_ANSWER_SETS_TL
1609: WHERE ID = p_okl_answer_sets_tl_rec.id
1610: FOR UPDATE NOWAIT;

Line 1608: FROM OKL_ANSWER_SETS_TL

1604: E_Resource_Busy EXCEPTION;
1605: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1606: CURSOR lock_csr (p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS
1607: SELECT *
1608: FROM OKL_ANSWER_SETS_TL
1609: WHERE ID = p_okl_answer_sets_tl_rec.id
1610: FOR UPDATE NOWAIT;
1611:
1612: l_api_version CONSTANT NUMBER := 1;

Line 1609: WHERE ID = p_okl_answer_sets_tl_rec.id

1605: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1606: CURSOR lock_csr (p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS
1607: SELECT *
1608: FROM OKL_ANSWER_SETS_TL
1609: WHERE ID = p_okl_answer_sets_tl_rec.id
1610: FOR UPDATE NOWAIT;
1611:
1612: l_api_version CONSTANT NUMBER := 1;
1613: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1629: OPEN lock_csr(p_okl_answer_sets_tl_rec);

1625: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1626: RAISE okl_api.G_EXCEPTION_ERROR;
1627: END IF;
1628: BEGIN
1629: OPEN lock_csr(p_okl_answer_sets_tl_rec);
1630: FETCH lock_csr INTO l_lock_var;
1631: l_row_notfound := lock_csr%NOTFOUND;
1632: CLOSE lock_csr;
1633: EXCEPTION

Line 1694: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

1690: l_api_version CONSTANT NUMBER := 1;
1691: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1692: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1693: l_ant_rec ant_rec_type;
1694: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
1695: BEGIN
1696: l_return_status := okl_api.START_ACTIVITY(l_api_name,
1697: G_PKG_NAME,
1698: p_init_msg_list,

Line 1712: migrate(p_antv_rec, l_okl_answer_sets_tl_rec);

1708: --------------------------------------
1709: -- Move VIEW record to "Child" records
1710: --------------------------------------
1711: migrate(p_antv_rec, l_ant_rec);
1712: migrate(p_antv_rec, l_okl_answer_sets_tl_rec);
1713: --------------------------------------------
1714: -- Call the LOCK_ROW for each child record
1715: --------------------------------------------
1716: lock_row(

Line 1733: l_okl_answer_sets_tl_rec

1729: p_init_msg_list,
1730: x_return_status,
1731: x_msg_count,
1732: x_msg_data,
1733: l_okl_answer_sets_tl_rec
1734: );
1735: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1736: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1737: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2102: -- update_row for:OKL_ANSWER_SETS_TL --

2098: '_PVT'
2099: );
2100: END update_row;
2101: ---------------------------------------
2102: -- update_row for:OKL_ANSWER_SETS_TL --
2103: ---------------------------------------
2104: PROCEDURE update_row(
2105: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2106: x_return_status OUT NOCOPY VARCHAR2,

Line 2109: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,

2105: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2106: x_return_status OUT NOCOPY VARCHAR2,
2107: x_msg_count OUT NOCOPY NUMBER,
2108: x_msg_data OUT NOCOPY VARCHAR2,
2109: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2110: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type) IS
2111:
2112: l_api_version CONSTANT NUMBER := 1;
2113: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2110: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type) IS

2106: x_return_status OUT NOCOPY VARCHAR2,
2107: x_msg_count OUT NOCOPY NUMBER,
2108: x_msg_data OUT NOCOPY VARCHAR2,
2109: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2110: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type) IS
2111:
2112: l_api_version CONSTANT NUMBER := 1;
2113: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2114: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2115: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type := p_okl_answer_sets_tl_rec;

2111:
2112: l_api_version CONSTANT NUMBER := 1;
2113: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2114: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2115: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type := p_okl_answer_sets_tl_rec;
2116: l_def_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2117: l_row_notfound BOOLEAN := TRUE;
2118: ----------------------------------
2119: -- FUNCTION populate_new_record --

Line 2116: l_def_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

2112: l_api_version CONSTANT NUMBER := 1;
2113: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2114: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2115: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type := p_okl_answer_sets_tl_rec;
2116: l_def_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2117: l_row_notfound BOOLEAN := TRUE;
2118: ----------------------------------
2119: -- FUNCTION populate_new_record --
2120: ----------------------------------

Line 2122: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,

2118: ----------------------------------
2119: -- FUNCTION populate_new_record --
2120: ----------------------------------
2121: FUNCTION populate_new_record (
2122: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2123: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2124: ) RETURN VARCHAR2 IS
2125: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2126: l_row_notfound BOOLEAN := TRUE;

Line 2123: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type

2119: -- FUNCTION populate_new_record --
2120: ----------------------------------
2121: FUNCTION populate_new_record (
2122: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2123: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2124: ) RETURN VARCHAR2 IS
2125: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2126: l_row_notfound BOOLEAN := TRUE;
2127: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2125: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

2121: FUNCTION populate_new_record (
2122: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2123: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2124: ) RETURN VARCHAR2 IS
2125: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2126: l_row_notfound BOOLEAN := TRUE;
2127: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2128: BEGIN
2129: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;

Line 2129: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;

2125: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2126: l_row_notfound BOOLEAN := TRUE;
2127: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2128: BEGIN
2129: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
2130: -- Get current database values
2131: l_okl_answer_sets_tl_rec := get_rec(p_okl_answer_sets_tl_rec, l_row_notfound);
2132: IF (l_row_notfound) THEN
2133: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;

Line 2131: l_okl_answer_sets_tl_rec := get_rec(p_okl_answer_sets_tl_rec, l_row_notfound);

2127: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2128: BEGIN
2129: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
2130: -- Get current database values
2131: l_okl_answer_sets_tl_rec := get_rec(p_okl_answer_sets_tl_rec, l_row_notfound);
2132: IF (l_row_notfound) THEN
2133: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2134: END IF;
2135: IF (x_okl_answer_sets_tl_rec.id = okl_api.G_MISS_NUM)

Line 2135: IF (x_okl_answer_sets_tl_rec.id = okl_api.G_MISS_NUM)

2131: l_okl_answer_sets_tl_rec := get_rec(p_okl_answer_sets_tl_rec, l_row_notfound);
2132: IF (l_row_notfound) THEN
2133: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2134: END IF;
2135: IF (x_okl_answer_sets_tl_rec.id = okl_api.G_MISS_NUM)
2136: THEN
2137: x_okl_answer_sets_tl_rec.id := l_okl_answer_sets_tl_rec.id;
2138: END IF;
2139: IF (x_okl_answer_sets_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

Line 2137: x_okl_answer_sets_tl_rec.id := l_okl_answer_sets_tl_rec.id;

2133: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2134: END IF;
2135: IF (x_okl_answer_sets_tl_rec.id = okl_api.G_MISS_NUM)
2136: THEN
2137: x_okl_answer_sets_tl_rec.id := l_okl_answer_sets_tl_rec.id;
2138: END IF;
2139: IF (x_okl_answer_sets_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2140: THEN
2141: x_okl_answer_sets_tl_rec.LANGUAGE := l_okl_answer_sets_tl_rec.LANGUAGE;

Line 2139: IF (x_okl_answer_sets_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

2135: IF (x_okl_answer_sets_tl_rec.id = okl_api.G_MISS_NUM)
2136: THEN
2137: x_okl_answer_sets_tl_rec.id := l_okl_answer_sets_tl_rec.id;
2138: END IF;
2139: IF (x_okl_answer_sets_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2140: THEN
2141: x_okl_answer_sets_tl_rec.LANGUAGE := l_okl_answer_sets_tl_rec.LANGUAGE;
2142: END IF;
2143: IF (x_okl_answer_sets_tl_rec.source_lang = okl_api.G_MISS_CHAR)

Line 2141: x_okl_answer_sets_tl_rec.LANGUAGE := l_okl_answer_sets_tl_rec.LANGUAGE;

2137: x_okl_answer_sets_tl_rec.id := l_okl_answer_sets_tl_rec.id;
2138: END IF;
2139: IF (x_okl_answer_sets_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2140: THEN
2141: x_okl_answer_sets_tl_rec.LANGUAGE := l_okl_answer_sets_tl_rec.LANGUAGE;
2142: END IF;
2143: IF (x_okl_answer_sets_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2144: THEN
2145: x_okl_answer_sets_tl_rec.source_lang := l_okl_answer_sets_tl_rec.source_lang;

Line 2143: IF (x_okl_answer_sets_tl_rec.source_lang = okl_api.G_MISS_CHAR)

2139: IF (x_okl_answer_sets_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2140: THEN
2141: x_okl_answer_sets_tl_rec.LANGUAGE := l_okl_answer_sets_tl_rec.LANGUAGE;
2142: END IF;
2143: IF (x_okl_answer_sets_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2144: THEN
2145: x_okl_answer_sets_tl_rec.source_lang := l_okl_answer_sets_tl_rec.source_lang;
2146: END IF;
2147: IF (x_okl_answer_sets_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

Line 2145: x_okl_answer_sets_tl_rec.source_lang := l_okl_answer_sets_tl_rec.source_lang;

2141: x_okl_answer_sets_tl_rec.LANGUAGE := l_okl_answer_sets_tl_rec.LANGUAGE;
2142: END IF;
2143: IF (x_okl_answer_sets_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2144: THEN
2145: x_okl_answer_sets_tl_rec.source_lang := l_okl_answer_sets_tl_rec.source_lang;
2146: END IF;
2147: IF (x_okl_answer_sets_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2148: THEN
2149: x_okl_answer_sets_tl_rec.sfwt_flag := l_okl_answer_sets_tl_rec.sfwt_flag;

Line 2147: IF (x_okl_answer_sets_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

2143: IF (x_okl_answer_sets_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2144: THEN
2145: x_okl_answer_sets_tl_rec.source_lang := l_okl_answer_sets_tl_rec.source_lang;
2146: END IF;
2147: IF (x_okl_answer_sets_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2148: THEN
2149: x_okl_answer_sets_tl_rec.sfwt_flag := l_okl_answer_sets_tl_rec.sfwt_flag;
2150: END IF;
2151: IF (x_okl_answer_sets_tl_rec.name = okl_api.G_MISS_CHAR)

Line 2149: x_okl_answer_sets_tl_rec.sfwt_flag := l_okl_answer_sets_tl_rec.sfwt_flag;

2145: x_okl_answer_sets_tl_rec.source_lang := l_okl_answer_sets_tl_rec.source_lang;
2146: END IF;
2147: IF (x_okl_answer_sets_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2148: THEN
2149: x_okl_answer_sets_tl_rec.sfwt_flag := l_okl_answer_sets_tl_rec.sfwt_flag;
2150: END IF;
2151: IF (x_okl_answer_sets_tl_rec.name = okl_api.G_MISS_CHAR)
2152: THEN
2153: x_okl_answer_sets_tl_rec.name := l_okl_answer_sets_tl_rec.name;

Line 2151: IF (x_okl_answer_sets_tl_rec.name = okl_api.G_MISS_CHAR)

2147: IF (x_okl_answer_sets_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2148: THEN
2149: x_okl_answer_sets_tl_rec.sfwt_flag := l_okl_answer_sets_tl_rec.sfwt_flag;
2150: END IF;
2151: IF (x_okl_answer_sets_tl_rec.name = okl_api.G_MISS_CHAR)
2152: THEN
2153: x_okl_answer_sets_tl_rec.name := l_okl_answer_sets_tl_rec.name;
2154: END IF;
2155: IF (x_okl_answer_sets_tl_rec.description = okl_api.G_MISS_CHAR)

Line 2153: x_okl_answer_sets_tl_rec.name := l_okl_answer_sets_tl_rec.name;

2149: x_okl_answer_sets_tl_rec.sfwt_flag := l_okl_answer_sets_tl_rec.sfwt_flag;
2150: END IF;
2151: IF (x_okl_answer_sets_tl_rec.name = okl_api.G_MISS_CHAR)
2152: THEN
2153: x_okl_answer_sets_tl_rec.name := l_okl_answer_sets_tl_rec.name;
2154: END IF;
2155: IF (x_okl_answer_sets_tl_rec.description = okl_api.G_MISS_CHAR)
2156: THEN
2157: x_okl_answer_sets_tl_rec.description := l_okl_answer_sets_tl_rec.description;

Line 2155: IF (x_okl_answer_sets_tl_rec.description = okl_api.G_MISS_CHAR)

2151: IF (x_okl_answer_sets_tl_rec.name = okl_api.G_MISS_CHAR)
2152: THEN
2153: x_okl_answer_sets_tl_rec.name := l_okl_answer_sets_tl_rec.name;
2154: END IF;
2155: IF (x_okl_answer_sets_tl_rec.description = okl_api.G_MISS_CHAR)
2156: THEN
2157: x_okl_answer_sets_tl_rec.description := l_okl_answer_sets_tl_rec.description;
2158: END IF;
2159: IF (x_okl_answer_sets_tl_rec.created_by = okl_api.G_MISS_NUM)

Line 2157: x_okl_answer_sets_tl_rec.description := l_okl_answer_sets_tl_rec.description;

2153: x_okl_answer_sets_tl_rec.name := l_okl_answer_sets_tl_rec.name;
2154: END IF;
2155: IF (x_okl_answer_sets_tl_rec.description = okl_api.G_MISS_CHAR)
2156: THEN
2157: x_okl_answer_sets_tl_rec.description := l_okl_answer_sets_tl_rec.description;
2158: END IF;
2159: IF (x_okl_answer_sets_tl_rec.created_by = okl_api.G_MISS_NUM)
2160: THEN
2161: x_okl_answer_sets_tl_rec.created_by := l_okl_answer_sets_tl_rec.created_by;

Line 2159: IF (x_okl_answer_sets_tl_rec.created_by = okl_api.G_MISS_NUM)

2155: IF (x_okl_answer_sets_tl_rec.description = okl_api.G_MISS_CHAR)
2156: THEN
2157: x_okl_answer_sets_tl_rec.description := l_okl_answer_sets_tl_rec.description;
2158: END IF;
2159: IF (x_okl_answer_sets_tl_rec.created_by = okl_api.G_MISS_NUM)
2160: THEN
2161: x_okl_answer_sets_tl_rec.created_by := l_okl_answer_sets_tl_rec.created_by;
2162: END IF;
2163: IF (x_okl_answer_sets_tl_rec.creation_date = okl_api.G_MISS_DATE)

Line 2161: x_okl_answer_sets_tl_rec.created_by := l_okl_answer_sets_tl_rec.created_by;

2157: x_okl_answer_sets_tl_rec.description := l_okl_answer_sets_tl_rec.description;
2158: END IF;
2159: IF (x_okl_answer_sets_tl_rec.created_by = okl_api.G_MISS_NUM)
2160: THEN
2161: x_okl_answer_sets_tl_rec.created_by := l_okl_answer_sets_tl_rec.created_by;
2162: END IF;
2163: IF (x_okl_answer_sets_tl_rec.creation_date = okl_api.G_MISS_DATE)
2164: THEN
2165: x_okl_answer_sets_tl_rec.creation_date := l_okl_answer_sets_tl_rec.creation_date;

Line 2163: IF (x_okl_answer_sets_tl_rec.creation_date = okl_api.G_MISS_DATE)

2159: IF (x_okl_answer_sets_tl_rec.created_by = okl_api.G_MISS_NUM)
2160: THEN
2161: x_okl_answer_sets_tl_rec.created_by := l_okl_answer_sets_tl_rec.created_by;
2162: END IF;
2163: IF (x_okl_answer_sets_tl_rec.creation_date = okl_api.G_MISS_DATE)
2164: THEN
2165: x_okl_answer_sets_tl_rec.creation_date := l_okl_answer_sets_tl_rec.creation_date;
2166: END IF;
2167: IF (x_okl_answer_sets_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

Line 2165: x_okl_answer_sets_tl_rec.creation_date := l_okl_answer_sets_tl_rec.creation_date;

2161: x_okl_answer_sets_tl_rec.created_by := l_okl_answer_sets_tl_rec.created_by;
2162: END IF;
2163: IF (x_okl_answer_sets_tl_rec.creation_date = okl_api.G_MISS_DATE)
2164: THEN
2165: x_okl_answer_sets_tl_rec.creation_date := l_okl_answer_sets_tl_rec.creation_date;
2166: END IF;
2167: IF (x_okl_answer_sets_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2168: THEN
2169: x_okl_answer_sets_tl_rec.last_updated_by := l_okl_answer_sets_tl_rec.last_updated_by;

Line 2167: IF (x_okl_answer_sets_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

2163: IF (x_okl_answer_sets_tl_rec.creation_date = okl_api.G_MISS_DATE)
2164: THEN
2165: x_okl_answer_sets_tl_rec.creation_date := l_okl_answer_sets_tl_rec.creation_date;
2166: END IF;
2167: IF (x_okl_answer_sets_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2168: THEN
2169: x_okl_answer_sets_tl_rec.last_updated_by := l_okl_answer_sets_tl_rec.last_updated_by;
2170: END IF;
2171: IF (x_okl_answer_sets_tl_rec.last_update_date = okl_api.G_MISS_DATE)

Line 2169: x_okl_answer_sets_tl_rec.last_updated_by := l_okl_answer_sets_tl_rec.last_updated_by;

2165: x_okl_answer_sets_tl_rec.creation_date := l_okl_answer_sets_tl_rec.creation_date;
2166: END IF;
2167: IF (x_okl_answer_sets_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2168: THEN
2169: x_okl_answer_sets_tl_rec.last_updated_by := l_okl_answer_sets_tl_rec.last_updated_by;
2170: END IF;
2171: IF (x_okl_answer_sets_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2172: THEN
2173: x_okl_answer_sets_tl_rec.last_update_date := l_okl_answer_sets_tl_rec.last_update_date;

Line 2171: IF (x_okl_answer_sets_tl_rec.last_update_date = okl_api.G_MISS_DATE)

2167: IF (x_okl_answer_sets_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2168: THEN
2169: x_okl_answer_sets_tl_rec.last_updated_by := l_okl_answer_sets_tl_rec.last_updated_by;
2170: END IF;
2171: IF (x_okl_answer_sets_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2172: THEN
2173: x_okl_answer_sets_tl_rec.last_update_date := l_okl_answer_sets_tl_rec.last_update_date;
2174: END IF;
2175: IF (x_okl_answer_sets_tl_rec.last_update_login = okl_api.G_MISS_NUM)

Line 2173: x_okl_answer_sets_tl_rec.last_update_date := l_okl_answer_sets_tl_rec.last_update_date;

2169: x_okl_answer_sets_tl_rec.last_updated_by := l_okl_answer_sets_tl_rec.last_updated_by;
2170: END IF;
2171: IF (x_okl_answer_sets_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2172: THEN
2173: x_okl_answer_sets_tl_rec.last_update_date := l_okl_answer_sets_tl_rec.last_update_date;
2174: END IF;
2175: IF (x_okl_answer_sets_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2176: THEN
2177: x_okl_answer_sets_tl_rec.last_update_login := l_okl_answer_sets_tl_rec.last_update_login;

Line 2175: IF (x_okl_answer_sets_tl_rec.last_update_login = okl_api.G_MISS_NUM)

2171: IF (x_okl_answer_sets_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2172: THEN
2173: x_okl_answer_sets_tl_rec.last_update_date := l_okl_answer_sets_tl_rec.last_update_date;
2174: END IF;
2175: IF (x_okl_answer_sets_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2176: THEN
2177: x_okl_answer_sets_tl_rec.last_update_login := l_okl_answer_sets_tl_rec.last_update_login;
2178: END IF;
2179: RETURN(l_return_status);

Line 2177: x_okl_answer_sets_tl_rec.last_update_login := l_okl_answer_sets_tl_rec.last_update_login;

2173: x_okl_answer_sets_tl_rec.last_update_date := l_okl_answer_sets_tl_rec.last_update_date;
2174: END IF;
2175: IF (x_okl_answer_sets_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2176: THEN
2177: x_okl_answer_sets_tl_rec.last_update_login := l_okl_answer_sets_tl_rec.last_update_login;
2178: END IF;
2179: RETURN(l_return_status);
2180: END populate_new_record;
2181: -------------------------------------------

Line 2182: -- Set_Attributes for:OKL_ANSWER_SETS_TL --

2178: END IF;
2179: RETURN(l_return_status);
2180: END populate_new_record;
2181: -------------------------------------------
2182: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
2183: -------------------------------------------
2184: FUNCTION Set_Attributes (
2185: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2186: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type

Line 2185: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,

2181: -------------------------------------------
2182: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
2183: -------------------------------------------
2184: FUNCTION Set_Attributes (
2185: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2186: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2187: ) RETURN VARCHAR2 IS
2188: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2189: BEGIN

Line 2186: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type

2182: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
2183: -------------------------------------------
2184: FUNCTION Set_Attributes (
2185: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2186: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2187: ) RETURN VARCHAR2 IS
2188: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2189: BEGIN
2190: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;

Line 2190: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;

2186: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2187: ) RETURN VARCHAR2 IS
2188: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2189: BEGIN
2190: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
2191: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');
2192: x_okl_answer_sets_tl_rec.SOURCE_LANG := USERENV('LANG');
2193: RETURN(l_return_status);
2194: END Set_Attributes;

Line 2191: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');

2187: ) RETURN VARCHAR2 IS
2188: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2189: BEGIN
2190: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
2191: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');
2192: x_okl_answer_sets_tl_rec.SOURCE_LANG := USERENV('LANG');
2193: RETURN(l_return_status);
2194: END Set_Attributes;
2195: BEGIN

Line 2192: x_okl_answer_sets_tl_rec.SOURCE_LANG := USERENV('LANG');

2188: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2189: BEGIN
2190: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
2191: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');
2192: x_okl_answer_sets_tl_rec.SOURCE_LANG := USERENV('LANG');
2193: RETURN(l_return_status);
2194: END Set_Attributes;
2195: BEGIN
2196: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 2207: p_okl_answer_sets_tl_rec, -- IN

2203: RAISE okl_api.G_EXCEPTION_ERROR;
2204: END IF;
2205: --- Setting item attributes
2206: l_return_status := Set_Attributes(
2207: p_okl_answer_sets_tl_rec, -- IN
2208: l_okl_answer_sets_tl_rec); -- OUT
2209: --- If any errors happen abort API
2210: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2211: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2208: l_okl_answer_sets_tl_rec); -- OUT

2204: END IF;
2205: --- Setting item attributes
2206: l_return_status := Set_Attributes(
2207: p_okl_answer_sets_tl_rec, -- IN
2208: l_okl_answer_sets_tl_rec); -- OUT
2209: --- If any errors happen abort API
2210: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2211: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2215: l_return_status := populate_new_record(l_okl_answer_sets_tl_rec, l_def_okl_answer_sets_tl_rec);

2211: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2213: RAISE okl_api.G_EXCEPTION_ERROR;
2214: END IF;
2215: l_return_status := populate_new_record(l_okl_answer_sets_tl_rec, l_def_okl_answer_sets_tl_rec);
2216: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2219: RAISE okl_api.G_EXCEPTION_ERROR;

Line 2221: UPDATE OKL_ANSWER_SETS_TL

2217: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2219: RAISE okl_api.G_EXCEPTION_ERROR;
2220: END IF;
2221: UPDATE OKL_ANSWER_SETS_TL
2222: SET NAME = l_def_okl_answer_sets_tl_rec.name,
2223: DESCRIPTION = l_def_okl_answer_sets_tl_rec.description,
2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,
2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,

Line 2222: SET NAME = l_def_okl_answer_sets_tl_rec.name,

2218: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2219: RAISE okl_api.G_EXCEPTION_ERROR;
2220: END IF;
2221: UPDATE OKL_ANSWER_SETS_TL
2222: SET NAME = l_def_okl_answer_sets_tl_rec.name,
2223: DESCRIPTION = l_def_okl_answer_sets_tl_rec.description,
2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,
2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,
2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,

Line 2223: DESCRIPTION = l_def_okl_answer_sets_tl_rec.description,

2219: RAISE okl_api.G_EXCEPTION_ERROR;
2220: END IF;
2221: UPDATE OKL_ANSWER_SETS_TL
2222: SET NAME = l_def_okl_answer_sets_tl_rec.name,
2223: DESCRIPTION = l_def_okl_answer_sets_tl_rec.description,
2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,
2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,
2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,
2227: LAST_UPDATE_DATE = l_def_okl_answer_sets_tl_rec.last_update_date,

Line 2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,

2220: END IF;
2221: UPDATE OKL_ANSWER_SETS_TL
2222: SET NAME = l_def_okl_answer_sets_tl_rec.name,
2223: DESCRIPTION = l_def_okl_answer_sets_tl_rec.description,
2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,
2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,
2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,
2227: LAST_UPDATE_DATE = l_def_okl_answer_sets_tl_rec.last_update_date,
2228: LAST_UPDATE_LOGIN = l_def_okl_answer_sets_tl_rec.last_update_login

Line 2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,

2221: UPDATE OKL_ANSWER_SETS_TL
2222: SET NAME = l_def_okl_answer_sets_tl_rec.name,
2223: DESCRIPTION = l_def_okl_answer_sets_tl_rec.description,
2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,
2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,
2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,
2227: LAST_UPDATE_DATE = l_def_okl_answer_sets_tl_rec.last_update_date,
2228: LAST_UPDATE_LOGIN = l_def_okl_answer_sets_tl_rec.last_update_login
2229: WHERE ID = l_def_okl_answer_sets_tl_rec.id

Line 2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,

2222: SET NAME = l_def_okl_answer_sets_tl_rec.name,
2223: DESCRIPTION = l_def_okl_answer_sets_tl_rec.description,
2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,
2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,
2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,
2227: LAST_UPDATE_DATE = l_def_okl_answer_sets_tl_rec.last_update_date,
2228: LAST_UPDATE_LOGIN = l_def_okl_answer_sets_tl_rec.last_update_login
2229: WHERE ID = l_def_okl_answer_sets_tl_rec.id
2230: --AND SOURCE_LANG = USERENV('LANG');

Line 2227: LAST_UPDATE_DATE = l_def_okl_answer_sets_tl_rec.last_update_date,

2223: DESCRIPTION = l_def_okl_answer_sets_tl_rec.description,
2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,
2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,
2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,
2227: LAST_UPDATE_DATE = l_def_okl_answer_sets_tl_rec.last_update_date,
2228: LAST_UPDATE_LOGIN = l_def_okl_answer_sets_tl_rec.last_update_login
2229: WHERE ID = l_def_okl_answer_sets_tl_rec.id
2230: --AND SOURCE_LANG = USERENV('LANG');
2231: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);

Line 2228: LAST_UPDATE_LOGIN = l_def_okl_answer_sets_tl_rec.last_update_login

2224: CREATED_BY = l_def_okl_answer_sets_tl_rec.created_by,
2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,
2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,
2227: LAST_UPDATE_DATE = l_def_okl_answer_sets_tl_rec.last_update_date,
2228: LAST_UPDATE_LOGIN = l_def_okl_answer_sets_tl_rec.last_update_login
2229: WHERE ID = l_def_okl_answer_sets_tl_rec.id
2230: --AND SOURCE_LANG = USERENV('LANG');
2231: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2232:

Line 2229: WHERE ID = l_def_okl_answer_sets_tl_rec.id

2225: CREATION_DATE = l_def_okl_answer_sets_tl_rec.creation_date,
2226: LAST_UPDATED_BY = l_def_okl_answer_sets_tl_rec.last_updated_by,
2227: LAST_UPDATE_DATE = l_def_okl_answer_sets_tl_rec.last_update_date,
2228: LAST_UPDATE_LOGIN = l_def_okl_answer_sets_tl_rec.last_update_login
2229: WHERE ID = l_def_okl_answer_sets_tl_rec.id
2230: --AND SOURCE_LANG = USERENV('LANG');
2231: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2232:
2233: UPDATE OKL_ANSWER_SETS_TL

Line 2233: UPDATE OKL_ANSWER_SETS_TL

2229: WHERE ID = l_def_okl_answer_sets_tl_rec.id
2230: --AND SOURCE_LANG = USERENV('LANG');
2231: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2232:
2233: UPDATE OKL_ANSWER_SETS_TL
2234: SET SFWT_FLAG = 'Y'
2235: WHERE ID = l_def_okl_answer_sets_tl_rec.id
2236: AND SOURCE_LANG <> USERENV('LANG');
2237:

Line 2235: WHERE ID = l_def_okl_answer_sets_tl_rec.id

2231: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2232:
2233: UPDATE OKL_ANSWER_SETS_TL
2234: SET SFWT_FLAG = 'Y'
2235: WHERE ID = l_def_okl_answer_sets_tl_rec.id
2236: AND SOURCE_LANG <> USERENV('LANG');
2237:
2238: x_okl_answer_sets_tl_rec := l_def_okl_answer_sets_tl_rec;
2239: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2238: x_okl_answer_sets_tl_rec := l_def_okl_answer_sets_tl_rec;

2234: SET SFWT_FLAG = 'Y'
2235: WHERE ID = l_def_okl_answer_sets_tl_rec.id
2236: AND SOURCE_LANG <> USERENV('LANG');
2237:
2238: x_okl_answer_sets_tl_rec := l_def_okl_answer_sets_tl_rec;
2239: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2240: EXCEPTION
2241: WHEN okl_api.G_EXCEPTION_ERROR THEN
2242: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 2289: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

2285: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2286: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2287: l_antv_rec antv_rec_type := p_antv_rec;
2288: l_def_antv_rec antv_rec_type;
2289: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2290: lx_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2291: l_ant_rec ant_rec_type;
2292: lx_ant_rec ant_rec_type;
2293: -------------------------------

Line 2290: lx_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

2286: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2287: l_antv_rec antv_rec_type := p_antv_rec;
2288: l_def_antv_rec antv_rec_type;
2289: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2290: lx_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2291: l_ant_rec ant_rec_type;
2292: lx_ant_rec ant_rec_type;
2293: -------------------------------
2294: -- FUNCTION fill_who_columns --

Line 2518: migrate(l_def_antv_rec, l_okl_answer_sets_tl_rec);

2514:
2515: --------------------------------------
2516: -- Move VIEW record to "Child" records
2517: --------------------------------------
2518: migrate(l_def_antv_rec, l_okl_answer_sets_tl_rec);
2519: migrate(l_def_antv_rec, l_ant_rec);
2520: --------------------------------------------
2521: -- Call the UPDATE_ROW for each child record
2522: --------------------------------------------

Line 2528: l_okl_answer_sets_tl_rec,

2524: p_init_msg_list,
2525: x_return_status,
2526: x_msg_count,
2527: x_msg_data,
2528: l_okl_answer_sets_tl_rec,
2529: lx_okl_answer_sets_tl_rec
2530: );
2531: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2532: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2529: lx_okl_answer_sets_tl_rec

2525: x_return_status,
2526: x_msg_count,
2527: x_msg_data,
2528: l_okl_answer_sets_tl_rec,
2529: lx_okl_answer_sets_tl_rec
2530: );
2531: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2532: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2536: migrate(lx_okl_answer_sets_tl_rec, l_def_antv_rec);

2532: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN
2534: RAISE okl_api.G_EXCEPTION_ERROR;
2535: END IF;
2536: migrate(lx_okl_answer_sets_tl_rec, l_def_antv_rec);
2537: update_row(
2538: p_init_msg_list,
2539: x_return_status,
2540: x_msg_count,

Line 2717: -- delete_row for:OKL_ANSWER_SETS_TL --

2713: '_PVT'
2714: );
2715: END delete_row;
2716: ---------------------------------------
2717: -- delete_row for:OKL_ANSWER_SETS_TL --
2718: ---------------------------------------
2719: PROCEDURE delete_row(
2720: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2721: x_return_status OUT NOCOPY VARCHAR2,

Line 2724: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS

2720: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2721: x_return_status OUT NOCOPY VARCHAR2,
2722: x_msg_count OUT NOCOPY NUMBER,
2723: x_msg_data OUT NOCOPY VARCHAR2,
2724: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type) IS
2725:
2726: l_api_version CONSTANT NUMBER := 1;
2727: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2728: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2729: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type:= p_okl_answer_sets_tl_rec;

2725:
2726: l_api_version CONSTANT NUMBER := 1;
2727: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2728: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2729: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type:= p_okl_answer_sets_tl_rec;
2730: l_row_notfound BOOLEAN := TRUE;
2731: -------------------------------------------
2732: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
2733: -------------------------------------------

Line 2732: -- Set_Attributes for:OKL_ANSWER_SETS_TL --

2728: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2729: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type:= p_okl_answer_sets_tl_rec;
2730: l_row_notfound BOOLEAN := TRUE;
2731: -------------------------------------------
2732: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
2733: -------------------------------------------
2734: FUNCTION Set_Attributes (
2735: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2736: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type

Line 2735: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,

2731: -------------------------------------------
2732: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
2733: -------------------------------------------
2734: FUNCTION Set_Attributes (
2735: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2736: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2737: ) RETURN VARCHAR2 IS
2738: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2739: BEGIN

Line 2736: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type

2732: -- Set_Attributes for:OKL_ANSWER_SETS_TL --
2733: -------------------------------------------
2734: FUNCTION Set_Attributes (
2735: p_okl_answer_sets_tl_rec IN okl_answer_sets_tl_rec_type,
2736: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2737: ) RETURN VARCHAR2 IS
2738: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2739: BEGIN
2740: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;

Line 2740: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;

2736: x_okl_answer_sets_tl_rec OUT NOCOPY okl_answer_sets_tl_rec_type
2737: ) RETURN VARCHAR2 IS
2738: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2739: BEGIN
2740: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
2741: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');
2742: RETURN(l_return_status);
2743: END Set_Attributes;
2744: BEGIN

Line 2741: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');

2737: ) RETURN VARCHAR2 IS
2738: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2739: BEGIN
2740: x_okl_answer_sets_tl_rec := p_okl_answer_sets_tl_rec;
2741: x_okl_answer_sets_tl_rec.LANGUAGE := USERENV('LANG');
2742: RETURN(l_return_status);
2743: END Set_Attributes;
2744: BEGIN
2745: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 2756: p_okl_answer_sets_tl_rec, -- IN

2752: RAISE okl_api.G_EXCEPTION_ERROR;
2753: END IF;
2754: --- Setting item attributes
2755: l_return_status := Set_Attributes(
2756: p_okl_answer_sets_tl_rec, -- IN
2757: l_okl_answer_sets_tl_rec); -- OUT
2758: --- If any errors happen abort API
2759: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2760: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2757: l_okl_answer_sets_tl_rec); -- OUT

2753: END IF;
2754: --- Setting item attributes
2755: l_return_status := Set_Attributes(
2756: p_okl_answer_sets_tl_rec, -- IN
2757: l_okl_answer_sets_tl_rec); -- OUT
2758: --- If any errors happen abort API
2759: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2760: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2761: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2764: DELETE FROM OKL_ANSWER_SETS_TL

2760: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2761: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2762: RAISE okl_api.G_EXCEPTION_ERROR;
2763: END IF;
2764: DELETE FROM OKL_ANSWER_SETS_TL
2765: WHERE ID = l_okl_answer_sets_tl_rec.id;
2766:
2767: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2768: EXCEPTION

Line 2765: WHERE ID = l_okl_answer_sets_tl_rec.id;

2761: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2762: RAISE okl_api.G_EXCEPTION_ERROR;
2763: END IF;
2764: DELETE FROM OKL_ANSWER_SETS_TL
2765: WHERE ID = l_okl_answer_sets_tl_rec.id;
2766:
2767: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2768: EXCEPTION
2769: WHEN okl_api.G_EXCEPTION_ERROR THEN

Line 2815: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;

2811: l_api_version CONSTANT NUMBER := 1;
2812: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2813: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2814: l_antv_rec antv_rec_type := p_antv_rec;
2815: l_okl_answer_sets_tl_rec okl_answer_sets_tl_rec_type;
2816: l_ant_rec ant_rec_type;
2817: BEGIN
2818: l_return_status := okl_api.START_ACTIVITY(l_api_name,
2819: G_PKG_NAME,

Line 2833: migrate(l_antv_rec, l_okl_answer_sets_tl_rec);

2829: END IF;
2830: --------------------------------------
2831: -- Move VIEW record to "Child" records
2832: --------------------------------------
2833: migrate(l_antv_rec, l_okl_answer_sets_tl_rec);
2834: migrate(l_antv_rec, l_ant_rec);
2835: --------------------------------------------
2836: -- Call the DELETE_ROW for each child record
2837: --------------------------------------------

Line 2843: l_okl_answer_sets_tl_rec

2839: p_init_msg_list,
2840: x_return_status,
2841: x_msg_count,
2842: x_msg_data,
2843: l_okl_answer_sets_tl_rec
2844: );
2845: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2846: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2847: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN