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_CRN_PVT dependencies on OKL_CRITERIA_TL

Line 246: DELETE FROM OKL_CRITERIA_TL T

242: -- PROCEDURE add_language
243: ---------------------------------------------------------------------------
244: PROCEDURE add_language IS
245: BEGIN
246: DELETE FROM OKL_CRITERIA_TL T
247: WHERE NOT EXISTS (
248: SELECT NULL
249: FROM OKL_CRITERIA_B B --fixed bug 3321017 by kmotepal
250: WHERE B.ID = T.ID

Line 253: UPDATE OKL_CRITERIA_TL T SET (

249: FROM OKL_CRITERIA_B B --fixed bug 3321017 by kmotepal
250: WHERE B.ID = T.ID
251: );
252:
253: UPDATE OKL_CRITERIA_TL T SET (
254: NAME,
255: DESCRIPTION) = (SELECT
256: B.NAME,
257: B.DESCRIPTION

Line 258: FROM OKL_CRITERIA_TL B

254: NAME,
255: DESCRIPTION) = (SELECT
256: B.NAME,
257: B.DESCRIPTION
258: FROM OKL_CRITERIA_TL B
259: WHERE B.ID = T.ID
260: AND B.LANGUAGE = T.SOURCE_LANG)
261: WHERE (
262: T.ID,

Line 267: FROM OKL_CRITERIA_TL SUBB, OKL_CRITERIA_TL SUBT

263: T.LANGUAGE)
264: IN (SELECT
265: SUBT.ID,
266: SUBT.LANGUAGE
267: FROM OKL_CRITERIA_TL SUBB, OKL_CRITERIA_TL SUBT
268: WHERE SUBB.ID = SUBT.ID
269: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
270: AND (SUBB.NAME <> SUBT.NAME
271: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 276: INSERT INTO OKL_CRITERIA_TL (

272: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
273: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
274: ));
275:
276: INSERT INTO OKL_CRITERIA_TL (
277: ID,
278: LANGUAGE,
279: SOURCE_LANG,
280: SFWT_FLAG,

Line 300: FROM OKL_CRITERIA_TL B, FND_LANGUAGES L

296: B.CREATION_DATE,
297: B.LAST_UPDATED_BY,
298: B.LAST_UPDATE_DATE,
299: B.LAST_UPDATE_LOGIN
300: FROM OKL_CRITERIA_TL B, FND_LANGUAGES L
301: WHERE L.INSTALLED_FLAG IN ('I', 'B')
302: AND B.LANGUAGE = USERENV('LANG')
303: AND NOT EXISTS(
304: SELECT NULL

Line 305: FROM OKL_CRITERIA_TL T

301: WHERE L.INSTALLED_FLAG IN ('I', 'B')
302: AND B.LANGUAGE = USERENV('LANG')
303: AND NOT EXISTS(
304: SELECT NULL
305: FROM OKL_CRITERIA_TL T
306: WHERE T.ID = B.ID
307: AND T.LANGUAGE = L.LANGUAGE_CODE
308: );
309:

Line 395: -- FUNCTION get_rec for: OKL_CRITERIA_TL

391: BEGIN
392: RETURN(get_rec(p_crn_rec, l_row_notfound));
393: END get_rec;
394: ---------------------------------------------------------------------------
395: -- FUNCTION get_rec for: OKL_CRITERIA_TL
396: ---------------------------------------------------------------------------
397: FUNCTION get_rec (
398: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
399: x_no_data_found OUT NOCOPY BOOLEAN

Line 398: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,

394: ---------------------------------------------------------------------------
395: -- FUNCTION get_rec for: OKL_CRITERIA_TL
396: ---------------------------------------------------------------------------
397: FUNCTION get_rec (
398: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
399: x_no_data_found OUT NOCOPY BOOLEAN
400: ) RETURN okl_criteria_tl_rec_type IS
401: CURSOR okl_criteria_tl_pk_csr (p_id IN NUMBER,
402: p_language IN VARCHAR2) IS

Line 400: ) RETURN okl_criteria_tl_rec_type IS

396: ---------------------------------------------------------------------------
397: FUNCTION get_rec (
398: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
399: x_no_data_found OUT NOCOPY BOOLEAN
400: ) RETURN okl_criteria_tl_rec_type IS
401: CURSOR okl_criteria_tl_pk_csr (p_id IN NUMBER,
402: p_language IN VARCHAR2) IS
403: SELECT
404: ID,

Line 401: CURSOR okl_criteria_tl_pk_csr (p_id IN NUMBER,

397: FUNCTION get_rec (
398: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
399: x_no_data_found OUT NOCOPY BOOLEAN
400: ) RETURN okl_criteria_tl_rec_type IS
401: CURSOR okl_criteria_tl_pk_csr (p_id IN NUMBER,
402: p_language IN VARCHAR2) IS
403: SELECT
404: ID,
405: LANGUAGE,

Line 415: FROM Okl_Criteria_Tl

411: CREATION_DATE,
412: LAST_UPDATED_BY,
413: LAST_UPDATE_DATE,
414: LAST_UPDATE_LOGIN
415: FROM Okl_Criteria_Tl
416: WHERE okl_criteria_tl.id = p_id
417: AND okl_criteria_tl.LANGUAGE = p_language;
418: l_okl_criteria_tl_pk okl_criteria_tl_pk_csr%ROWTYPE;
419: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;

Line 416: WHERE okl_criteria_tl.id = p_id

412: LAST_UPDATED_BY,
413: LAST_UPDATE_DATE,
414: LAST_UPDATE_LOGIN
415: FROM Okl_Criteria_Tl
416: WHERE okl_criteria_tl.id = p_id
417: AND okl_criteria_tl.LANGUAGE = p_language;
418: l_okl_criteria_tl_pk okl_criteria_tl_pk_csr%ROWTYPE;
419: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
420: BEGIN

Line 417: AND okl_criteria_tl.LANGUAGE = p_language;

413: LAST_UPDATE_DATE,
414: LAST_UPDATE_LOGIN
415: FROM Okl_Criteria_Tl
416: WHERE okl_criteria_tl.id = p_id
417: AND okl_criteria_tl.LANGUAGE = p_language;
418: l_okl_criteria_tl_pk okl_criteria_tl_pk_csr%ROWTYPE;
419: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
420: BEGIN
421: x_no_data_found := TRUE;

Line 418: l_okl_criteria_tl_pk okl_criteria_tl_pk_csr%ROWTYPE;

414: LAST_UPDATE_LOGIN
415: FROM Okl_Criteria_Tl
416: WHERE okl_criteria_tl.id = p_id
417: AND okl_criteria_tl.LANGUAGE = p_language;
418: l_okl_criteria_tl_pk okl_criteria_tl_pk_csr%ROWTYPE;
419: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
420: BEGIN
421: x_no_data_found := TRUE;
422: -- Get current database values

Line 419: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;

415: FROM Okl_Criteria_Tl
416: WHERE okl_criteria_tl.id = p_id
417: AND okl_criteria_tl.LANGUAGE = p_language;
418: l_okl_criteria_tl_pk okl_criteria_tl_pk_csr%ROWTYPE;
419: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
420: BEGIN
421: x_no_data_found := TRUE;
422: -- Get current database values
423: OPEN okl_criteria_tl_pk_csr (p_okl_criteria_tl_rec.id,

Line 423: OPEN okl_criteria_tl_pk_csr (p_okl_criteria_tl_rec.id,

419: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
420: BEGIN
421: x_no_data_found := TRUE;
422: -- Get current database values
423: OPEN okl_criteria_tl_pk_csr (p_okl_criteria_tl_rec.id,
424: p_okl_criteria_tl_rec.LANGUAGE);
425: FETCH okl_criteria_tl_pk_csr INTO
426: l_okl_criteria_tl_rec.ID,
427: l_okl_criteria_tl_rec.LANGUAGE,

Line 424: p_okl_criteria_tl_rec.LANGUAGE);

420: BEGIN
421: x_no_data_found := TRUE;
422: -- Get current database values
423: OPEN okl_criteria_tl_pk_csr (p_okl_criteria_tl_rec.id,
424: p_okl_criteria_tl_rec.LANGUAGE);
425: FETCH okl_criteria_tl_pk_csr INTO
426: l_okl_criteria_tl_rec.ID,
427: l_okl_criteria_tl_rec.LANGUAGE,
428: l_okl_criteria_tl_rec.SOURCE_LANG,

Line 425: FETCH okl_criteria_tl_pk_csr INTO

421: x_no_data_found := TRUE;
422: -- Get current database values
423: OPEN okl_criteria_tl_pk_csr (p_okl_criteria_tl_rec.id,
424: p_okl_criteria_tl_rec.LANGUAGE);
425: FETCH okl_criteria_tl_pk_csr INTO
426: l_okl_criteria_tl_rec.ID,
427: l_okl_criteria_tl_rec.LANGUAGE,
428: l_okl_criteria_tl_rec.SOURCE_LANG,
429: l_okl_criteria_tl_rec.SFWT_FLAG,

Line 426: l_okl_criteria_tl_rec.ID,

422: -- Get current database values
423: OPEN okl_criteria_tl_pk_csr (p_okl_criteria_tl_rec.id,
424: p_okl_criteria_tl_rec.LANGUAGE);
425: FETCH okl_criteria_tl_pk_csr INTO
426: l_okl_criteria_tl_rec.ID,
427: l_okl_criteria_tl_rec.LANGUAGE,
428: l_okl_criteria_tl_rec.SOURCE_LANG,
429: l_okl_criteria_tl_rec.SFWT_FLAG,
430: l_okl_criteria_tl_rec.NAME,

Line 427: l_okl_criteria_tl_rec.LANGUAGE,

423: OPEN okl_criteria_tl_pk_csr (p_okl_criteria_tl_rec.id,
424: p_okl_criteria_tl_rec.LANGUAGE);
425: FETCH okl_criteria_tl_pk_csr INTO
426: l_okl_criteria_tl_rec.ID,
427: l_okl_criteria_tl_rec.LANGUAGE,
428: l_okl_criteria_tl_rec.SOURCE_LANG,
429: l_okl_criteria_tl_rec.SFWT_FLAG,
430: l_okl_criteria_tl_rec.NAME,
431: l_okl_criteria_tl_rec.DESCRIPTION,

Line 428: l_okl_criteria_tl_rec.SOURCE_LANG,

424: p_okl_criteria_tl_rec.LANGUAGE);
425: FETCH okl_criteria_tl_pk_csr INTO
426: l_okl_criteria_tl_rec.ID,
427: l_okl_criteria_tl_rec.LANGUAGE,
428: l_okl_criteria_tl_rec.SOURCE_LANG,
429: l_okl_criteria_tl_rec.SFWT_FLAG,
430: l_okl_criteria_tl_rec.NAME,
431: l_okl_criteria_tl_rec.DESCRIPTION,
432: l_okl_criteria_tl_rec.CREATED_BY,

Line 429: l_okl_criteria_tl_rec.SFWT_FLAG,

425: FETCH okl_criteria_tl_pk_csr INTO
426: l_okl_criteria_tl_rec.ID,
427: l_okl_criteria_tl_rec.LANGUAGE,
428: l_okl_criteria_tl_rec.SOURCE_LANG,
429: l_okl_criteria_tl_rec.SFWT_FLAG,
430: l_okl_criteria_tl_rec.NAME,
431: l_okl_criteria_tl_rec.DESCRIPTION,
432: l_okl_criteria_tl_rec.CREATED_BY,
433: l_okl_criteria_tl_rec.CREATION_DATE,

Line 430: l_okl_criteria_tl_rec.NAME,

426: l_okl_criteria_tl_rec.ID,
427: l_okl_criteria_tl_rec.LANGUAGE,
428: l_okl_criteria_tl_rec.SOURCE_LANG,
429: l_okl_criteria_tl_rec.SFWT_FLAG,
430: l_okl_criteria_tl_rec.NAME,
431: l_okl_criteria_tl_rec.DESCRIPTION,
432: l_okl_criteria_tl_rec.CREATED_BY,
433: l_okl_criteria_tl_rec.CREATION_DATE,
434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,

Line 431: l_okl_criteria_tl_rec.DESCRIPTION,

427: l_okl_criteria_tl_rec.LANGUAGE,
428: l_okl_criteria_tl_rec.SOURCE_LANG,
429: l_okl_criteria_tl_rec.SFWT_FLAG,
430: l_okl_criteria_tl_rec.NAME,
431: l_okl_criteria_tl_rec.DESCRIPTION,
432: l_okl_criteria_tl_rec.CREATED_BY,
433: l_okl_criteria_tl_rec.CREATION_DATE,
434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,
435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,

Line 432: l_okl_criteria_tl_rec.CREATED_BY,

428: l_okl_criteria_tl_rec.SOURCE_LANG,
429: l_okl_criteria_tl_rec.SFWT_FLAG,
430: l_okl_criteria_tl_rec.NAME,
431: l_okl_criteria_tl_rec.DESCRIPTION,
432: l_okl_criteria_tl_rec.CREATED_BY,
433: l_okl_criteria_tl_rec.CREATION_DATE,
434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,
435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,
436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;

Line 433: l_okl_criteria_tl_rec.CREATION_DATE,

429: l_okl_criteria_tl_rec.SFWT_FLAG,
430: l_okl_criteria_tl_rec.NAME,
431: l_okl_criteria_tl_rec.DESCRIPTION,
432: l_okl_criteria_tl_rec.CREATED_BY,
433: l_okl_criteria_tl_rec.CREATION_DATE,
434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,
435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,
436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;
437: x_no_data_found := okl_criteria_tl_pk_csr%NOTFOUND;

Line 434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,

430: l_okl_criteria_tl_rec.NAME,
431: l_okl_criteria_tl_rec.DESCRIPTION,
432: l_okl_criteria_tl_rec.CREATED_BY,
433: l_okl_criteria_tl_rec.CREATION_DATE,
434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,
435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,
436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;
437: x_no_data_found := okl_criteria_tl_pk_csr%NOTFOUND;
438: CLOSE okl_criteria_tl_pk_csr;

Line 435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,

431: l_okl_criteria_tl_rec.DESCRIPTION,
432: l_okl_criteria_tl_rec.CREATED_BY,
433: l_okl_criteria_tl_rec.CREATION_DATE,
434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,
435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,
436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;
437: x_no_data_found := okl_criteria_tl_pk_csr%NOTFOUND;
438: CLOSE okl_criteria_tl_pk_csr;
439: RETURN(l_okl_criteria_tl_rec);

Line 436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;

432: l_okl_criteria_tl_rec.CREATED_BY,
433: l_okl_criteria_tl_rec.CREATION_DATE,
434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,
435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,
436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;
437: x_no_data_found := okl_criteria_tl_pk_csr%NOTFOUND;
438: CLOSE okl_criteria_tl_pk_csr;
439: RETURN(l_okl_criteria_tl_rec);
440: END get_rec;

Line 437: x_no_data_found := okl_criteria_tl_pk_csr%NOTFOUND;

433: l_okl_criteria_tl_rec.CREATION_DATE,
434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,
435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,
436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;
437: x_no_data_found := okl_criteria_tl_pk_csr%NOTFOUND;
438: CLOSE okl_criteria_tl_pk_csr;
439: RETURN(l_okl_criteria_tl_rec);
440: END get_rec;
441:

Line 438: CLOSE okl_criteria_tl_pk_csr;

434: l_okl_criteria_tl_rec.LAST_UPDATED_BY,
435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,
436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;
437: x_no_data_found := okl_criteria_tl_pk_csr%NOTFOUND;
438: CLOSE okl_criteria_tl_pk_csr;
439: RETURN(l_okl_criteria_tl_rec);
440: END get_rec;
441:
442: FUNCTION get_rec (

Line 439: RETURN(l_okl_criteria_tl_rec);

435: l_okl_criteria_tl_rec.LAST_UPDATE_DATE,
436: l_okl_criteria_tl_rec.LAST_UPDATE_LOGIN;
437: x_no_data_found := okl_criteria_tl_pk_csr%NOTFOUND;
438: CLOSE okl_criteria_tl_pk_csr;
439: RETURN(l_okl_criteria_tl_rec);
440: END get_rec;
441:
442: FUNCTION get_rec (
443: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type

Line 443: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type

439: RETURN(l_okl_criteria_tl_rec);
440: END get_rec;
441:
442: FUNCTION get_rec (
443: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type
444: ) RETURN okl_criteria_tl_rec_type IS
445: l_row_notfound BOOLEAN := TRUE;
446: BEGIN
447: RETURN(get_rec(p_okl_criteria_tl_rec, l_row_notfound));

Line 444: ) RETURN okl_criteria_tl_rec_type IS

440: END get_rec;
441:
442: FUNCTION get_rec (
443: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type
444: ) RETURN okl_criteria_tl_rec_type IS
445: l_row_notfound BOOLEAN := TRUE;
446: BEGIN
447: RETURN(get_rec(p_okl_criteria_tl_rec, l_row_notfound));
448: END get_rec;

Line 447: RETURN(get_rec(p_okl_criteria_tl_rec, l_row_notfound));

443: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type
444: ) RETURN okl_criteria_tl_rec_type IS
445: l_row_notfound BOOLEAN := TRUE;
446: BEGIN
447: RETURN(get_rec(p_okl_criteria_tl_rec, l_row_notfound));
448: END get_rec;
449: ---------------------------------------------------------------------------
450: -- FUNCTION get_rec for: OKL_CRITERIA_V
451: ---------------------------------------------------------------------------

Line 820: p_to OUT NOCOPY okl_criteria_tl_rec_type

816: p_to.last_update_login := p_from.last_update_login;
817: END migrate;
818: PROCEDURE migrate (
819: p_from IN crnv_rec_type,
820: p_to OUT NOCOPY okl_criteria_tl_rec_type
821: ) IS
822: BEGIN
823: p_to.id := p_from.id;
824: p_to.sfwt_flag := p_from.sfwt_flag;

Line 834: p_from IN okl_criteria_tl_rec_type,

830: p_to.last_update_date := p_from.last_update_date;
831: p_to.last_update_login := p_from.last_update_login;
832: END migrate;
833: PROCEDURE migrate (
834: p_from IN okl_criteria_tl_rec_type,
835: p_to OUT NOCOPY crnv_rec_type
836: ) IS
837: BEGIN
838: p_to.id := p_from.id;

Line 868: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;

864: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
865: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
866: l_crnv_rec crnv_rec_type := p_crnv_rec;
867: l_crn_rec crn_rec_type;
868: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
869: BEGIN
870: l_return_status := okl_api.START_ACTIVITY(l_api_name,
871: G_PKG_NAME,
872: p_init_msg_list,

Line 1135: -- insert_row for:OKL_CRITERIA_TL --

1131: '_PVT'
1132: );
1133: END insert_row;
1134: ------------------------------------
1135: -- insert_row for:OKL_CRITERIA_TL --
1136: ------------------------------------
1137: PROCEDURE insert_row(
1138: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1139: x_return_status OUT NOCOPY VARCHAR2,

Line 1142: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,

1138: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1139: x_return_status OUT NOCOPY VARCHAR2,
1140: x_msg_count OUT NOCOPY NUMBER,
1141: x_msg_data OUT NOCOPY VARCHAR2,
1142: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
1143: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type) IS
1144:
1145: l_api_version CONSTANT NUMBER := 1;
1146: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1143: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type) IS

1139: x_return_status OUT NOCOPY VARCHAR2,
1140: x_msg_count OUT NOCOPY NUMBER,
1141: x_msg_data OUT NOCOPY VARCHAR2,
1142: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
1143: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type) IS
1144:
1145: l_api_version CONSTANT NUMBER := 1;
1146: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1147: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 1148: l_okl_criteria_tl_rec okl_criteria_tl_rec_type := p_okl_criteria_tl_rec;

1144:
1145: l_api_version CONSTANT NUMBER := 1;
1146: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1147: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1148: l_okl_criteria_tl_rec okl_criteria_tl_rec_type := p_okl_criteria_tl_rec;
1149: l_def_okl_criteria_tl_rec okl_criteria_tl_rec_type;
1150: CURSOR get_languages IS
1151: SELECT *
1152: FROM FND_LANGUAGES

Line 1149: l_def_okl_criteria_tl_rec okl_criteria_tl_rec_type;

1145: l_api_version CONSTANT NUMBER := 1;
1146: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1147: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1148: l_okl_criteria_tl_rec okl_criteria_tl_rec_type := p_okl_criteria_tl_rec;
1149: l_def_okl_criteria_tl_rec okl_criteria_tl_rec_type;
1150: CURSOR get_languages IS
1151: SELECT *
1152: FROM FND_LANGUAGES
1153: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1155: -- Set_Attributes for:OKL_CRITERIA_TL --

1151: SELECT *
1152: FROM FND_LANGUAGES
1153: WHERE INSTALLED_FLAG IN ('I', 'B');
1154: ----------------------------------------
1155: -- Set_Attributes for:OKL_CRITERIA_TL --
1156: ----------------------------------------
1157: FUNCTION Set_Attributes (
1158: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
1159: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type

Line 1158: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,

1154: ----------------------------------------
1155: -- Set_Attributes for:OKL_CRITERIA_TL --
1156: ----------------------------------------
1157: FUNCTION Set_Attributes (
1158: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
1159: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
1160: ) RETURN VARCHAR2 IS
1161: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1162: BEGIN

Line 1159: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type

1155: -- Set_Attributes for:OKL_CRITERIA_TL --
1156: ----------------------------------------
1157: FUNCTION Set_Attributes (
1158: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
1159: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
1160: ) RETURN VARCHAR2 IS
1161: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1162: BEGIN
1163: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;

Line 1163: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;

1159: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
1160: ) RETURN VARCHAR2 IS
1161: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1162: BEGIN
1163: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
1164: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');
1165: x_okl_criteria_tl_rec.SOURCE_LANG := USERENV('LANG');
1166: RETURN(l_return_status);
1167: END Set_Attributes;

Line 1164: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');

1160: ) RETURN VARCHAR2 IS
1161: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1162: BEGIN
1163: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
1164: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');
1165: x_okl_criteria_tl_rec.SOURCE_LANG := USERENV('LANG');
1166: RETURN(l_return_status);
1167: END Set_Attributes;
1168: BEGIN

Line 1165: x_okl_criteria_tl_rec.SOURCE_LANG := USERENV('LANG');

1161: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1162: BEGIN
1163: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
1164: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');
1165: x_okl_criteria_tl_rec.SOURCE_LANG := USERENV('LANG');
1166: RETURN(l_return_status);
1167: END Set_Attributes;
1168: BEGIN
1169: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 1180: p_okl_criteria_tl_rec, -- IN

1176: RAISE okl_api.G_EXCEPTION_ERROR;
1177: END IF;
1178: --- Setting item attributes
1179: l_return_status := Set_Attributes(
1180: p_okl_criteria_tl_rec, -- IN
1181: l_okl_criteria_tl_rec); -- OUT
1182: --- If any errors happen abort API
1183: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1181: l_okl_criteria_tl_rec); -- OUT

1177: END IF;
1178: --- Setting item attributes
1179: l_return_status := Set_Attributes(
1180: p_okl_criteria_tl_rec, -- IN
1181: l_okl_criteria_tl_rec); -- OUT
1182: --- If any errors happen abort API
1183: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1189: l_okl_criteria_tl_rec.LANGUAGE := l_lang_rec.language_code;

1185: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1186: RAISE okl_api.G_EXCEPTION_ERROR;
1187: END IF;
1188: FOR l_lang_rec IN get_languages LOOP
1189: l_okl_criteria_tl_rec.LANGUAGE := l_lang_rec.language_code;
1190: INSERT INTO OKL_CRITERIA_TL(
1191: id,
1192: LANGUAGE,
1193: source_lang,

Line 1190: INSERT INTO OKL_CRITERIA_TL(

1186: RAISE okl_api.G_EXCEPTION_ERROR;
1187: END IF;
1188: FOR l_lang_rec IN get_languages LOOP
1189: l_okl_criteria_tl_rec.LANGUAGE := l_lang_rec.language_code;
1190: INSERT INTO OKL_CRITERIA_TL(
1191: id,
1192: LANGUAGE,
1193: source_lang,
1194: sfwt_flag,

Line 1203: l_okl_criteria_tl_rec.id,

1199: last_updated_by,
1200: last_update_date,
1201: last_update_login)
1202: VALUES (
1203: l_okl_criteria_tl_rec.id,
1204: l_okl_criteria_tl_rec.LANGUAGE,
1205: l_okl_criteria_tl_rec.source_lang,
1206: l_okl_criteria_tl_rec.sfwt_flag,
1207: l_okl_criteria_tl_rec.name,

Line 1204: l_okl_criteria_tl_rec.LANGUAGE,

1200: last_update_date,
1201: last_update_login)
1202: VALUES (
1203: l_okl_criteria_tl_rec.id,
1204: l_okl_criteria_tl_rec.LANGUAGE,
1205: l_okl_criteria_tl_rec.source_lang,
1206: l_okl_criteria_tl_rec.sfwt_flag,
1207: l_okl_criteria_tl_rec.name,
1208: l_okl_criteria_tl_rec.description,

Line 1205: l_okl_criteria_tl_rec.source_lang,

1201: last_update_login)
1202: VALUES (
1203: l_okl_criteria_tl_rec.id,
1204: l_okl_criteria_tl_rec.LANGUAGE,
1205: l_okl_criteria_tl_rec.source_lang,
1206: l_okl_criteria_tl_rec.sfwt_flag,
1207: l_okl_criteria_tl_rec.name,
1208: l_okl_criteria_tl_rec.description,
1209: l_okl_criteria_tl_rec.created_by,

Line 1206: l_okl_criteria_tl_rec.sfwt_flag,

1202: VALUES (
1203: l_okl_criteria_tl_rec.id,
1204: l_okl_criteria_tl_rec.LANGUAGE,
1205: l_okl_criteria_tl_rec.source_lang,
1206: l_okl_criteria_tl_rec.sfwt_flag,
1207: l_okl_criteria_tl_rec.name,
1208: l_okl_criteria_tl_rec.description,
1209: l_okl_criteria_tl_rec.created_by,
1210: l_okl_criteria_tl_rec.creation_date,

Line 1207: l_okl_criteria_tl_rec.name,

1203: l_okl_criteria_tl_rec.id,
1204: l_okl_criteria_tl_rec.LANGUAGE,
1205: l_okl_criteria_tl_rec.source_lang,
1206: l_okl_criteria_tl_rec.sfwt_flag,
1207: l_okl_criteria_tl_rec.name,
1208: l_okl_criteria_tl_rec.description,
1209: l_okl_criteria_tl_rec.created_by,
1210: l_okl_criteria_tl_rec.creation_date,
1211: l_okl_criteria_tl_rec.last_updated_by,

Line 1208: l_okl_criteria_tl_rec.description,

1204: l_okl_criteria_tl_rec.LANGUAGE,
1205: l_okl_criteria_tl_rec.source_lang,
1206: l_okl_criteria_tl_rec.sfwt_flag,
1207: l_okl_criteria_tl_rec.name,
1208: l_okl_criteria_tl_rec.description,
1209: l_okl_criteria_tl_rec.created_by,
1210: l_okl_criteria_tl_rec.creation_date,
1211: l_okl_criteria_tl_rec.last_updated_by,
1212: l_okl_criteria_tl_rec.last_update_date,

Line 1209: l_okl_criteria_tl_rec.created_by,

1205: l_okl_criteria_tl_rec.source_lang,
1206: l_okl_criteria_tl_rec.sfwt_flag,
1207: l_okl_criteria_tl_rec.name,
1208: l_okl_criteria_tl_rec.description,
1209: l_okl_criteria_tl_rec.created_by,
1210: l_okl_criteria_tl_rec.creation_date,
1211: l_okl_criteria_tl_rec.last_updated_by,
1212: l_okl_criteria_tl_rec.last_update_date,
1213: l_okl_criteria_tl_rec.last_update_login);

Line 1210: l_okl_criteria_tl_rec.creation_date,

1206: l_okl_criteria_tl_rec.sfwt_flag,
1207: l_okl_criteria_tl_rec.name,
1208: l_okl_criteria_tl_rec.description,
1209: l_okl_criteria_tl_rec.created_by,
1210: l_okl_criteria_tl_rec.creation_date,
1211: l_okl_criteria_tl_rec.last_updated_by,
1212: l_okl_criteria_tl_rec.last_update_date,
1213: l_okl_criteria_tl_rec.last_update_login);
1214: END LOOP;

Line 1211: l_okl_criteria_tl_rec.last_updated_by,

1207: l_okl_criteria_tl_rec.name,
1208: l_okl_criteria_tl_rec.description,
1209: l_okl_criteria_tl_rec.created_by,
1210: l_okl_criteria_tl_rec.creation_date,
1211: l_okl_criteria_tl_rec.last_updated_by,
1212: l_okl_criteria_tl_rec.last_update_date,
1213: l_okl_criteria_tl_rec.last_update_login);
1214: END LOOP;
1215: -- Set OUT values

Line 1212: l_okl_criteria_tl_rec.last_update_date,

1208: l_okl_criteria_tl_rec.description,
1209: l_okl_criteria_tl_rec.created_by,
1210: l_okl_criteria_tl_rec.creation_date,
1211: l_okl_criteria_tl_rec.last_updated_by,
1212: l_okl_criteria_tl_rec.last_update_date,
1213: l_okl_criteria_tl_rec.last_update_login);
1214: END LOOP;
1215: -- Set OUT values
1216: x_okl_criteria_tl_rec := l_okl_criteria_tl_rec;

Line 1213: l_okl_criteria_tl_rec.last_update_login);

1209: l_okl_criteria_tl_rec.created_by,
1210: l_okl_criteria_tl_rec.creation_date,
1211: l_okl_criteria_tl_rec.last_updated_by,
1212: l_okl_criteria_tl_rec.last_update_date,
1213: l_okl_criteria_tl_rec.last_update_login);
1214: END LOOP;
1215: -- Set OUT values
1216: x_okl_criteria_tl_rec := l_okl_criteria_tl_rec;
1217: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1216: x_okl_criteria_tl_rec := l_okl_criteria_tl_rec;

1212: l_okl_criteria_tl_rec.last_update_date,
1213: l_okl_criteria_tl_rec.last_update_login);
1214: END LOOP;
1215: -- Set OUT values
1216: x_okl_criteria_tl_rec := l_okl_criteria_tl_rec;
1217: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1218: EXCEPTION
1219: WHEN okl_api.G_EXCEPTION_ERROR THEN
1220: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 1269: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;

1265: l_crnv_rec crnv_rec_type;
1266: l_def_crnv_rec crnv_rec_type;
1267: l_crn_rec crn_rec_type;
1268: lx_crn_rec crn_rec_type;
1269: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
1270: lx_okl_criteria_tl_rec okl_criteria_tl_rec_type;
1271: -------------------------------
1272: -- FUNCTION fill_who_columns --
1273: -------------------------------

Line 1270: lx_okl_criteria_tl_rec okl_criteria_tl_rec_type;

1266: l_def_crnv_rec crnv_rec_type;
1267: l_crn_rec crn_rec_type;
1268: lx_crn_rec crn_rec_type;
1269: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
1270: lx_okl_criteria_tl_rec okl_criteria_tl_rec_type;
1271: -------------------------------
1272: -- FUNCTION fill_who_columns --
1273: -------------------------------
1274: FUNCTION fill_who_columns (

Line 1345: migrate(l_def_crnv_rec, l_okl_criteria_tl_rec);

1341: --------------------------------------
1342: -- Move VIEW record to "Child" records
1343: --------------------------------------
1344: migrate(l_def_crnv_rec, l_crn_rec);
1345: migrate(l_def_crnv_rec, l_okl_criteria_tl_rec);
1346: --------------------------------------------
1347: -- Call the INSERT_ROW for each child record
1348: --------------------------------------------
1349: insert_row(

Line 1368: l_okl_criteria_tl_rec,

1364: p_init_msg_list,
1365: x_return_status,
1366: x_msg_count,
1367: x_msg_data,
1368: l_okl_criteria_tl_rec,
1369: lx_okl_criteria_tl_rec
1370: );
1371: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1369: lx_okl_criteria_tl_rec

1365: x_return_status,
1366: x_msg_count,
1367: x_msg_data,
1368: l_okl_criteria_tl_rec,
1369: lx_okl_criteria_tl_rec
1370: );
1371: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 1376: migrate(lx_okl_criteria_tl_rec, l_def_crnv_rec);

1372: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN
1374: RAISE okl_api.G_EXCEPTION_ERROR;
1375: END IF;
1376: migrate(lx_okl_criteria_tl_rec, l_def_crnv_rec);
1377: -- Set OUT values
1378: x_crnv_rec := l_def_crnv_rec;
1379: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1380: EXCEPTION

Line 1589: -- lock_row for:OKL_CRITERIA_TL --

1585: '_PVT'
1586: );
1587: END lock_row;
1588: ----------------------------------
1589: -- lock_row for:OKL_CRITERIA_TL --
1590: ----------------------------------
1591: PROCEDURE lock_row(
1592: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1593: x_return_status OUT NOCOPY VARCHAR2,

Line 1596: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS

1592: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1593: x_return_status OUT NOCOPY VARCHAR2,
1594: x_msg_count OUT NOCOPY NUMBER,
1595: x_msg_data OUT NOCOPY VARCHAR2,
1596: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS
1597:
1598: E_Resource_Busy EXCEPTION;
1599: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1600: CURSOR lock_csr (p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS

Line 1600: CURSOR lock_csr (p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS

1596: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS
1597:
1598: E_Resource_Busy EXCEPTION;
1599: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1600: CURSOR lock_csr (p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS
1601: SELECT *
1602: FROM OKL_CRITERIA_TL
1603: WHERE ID = p_okl_criteria_tl_rec.id
1604: FOR UPDATE NOWAIT;

Line 1602: FROM OKL_CRITERIA_TL

1598: E_Resource_Busy EXCEPTION;
1599: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1600: CURSOR lock_csr (p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS
1601: SELECT *
1602: FROM OKL_CRITERIA_TL
1603: WHERE ID = p_okl_criteria_tl_rec.id
1604: FOR UPDATE NOWAIT;
1605:
1606: l_api_version CONSTANT NUMBER := 1;

Line 1603: WHERE ID = p_okl_criteria_tl_rec.id

1599: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1600: CURSOR lock_csr (p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS
1601: SELECT *
1602: FROM OKL_CRITERIA_TL
1603: WHERE ID = p_okl_criteria_tl_rec.id
1604: FOR UPDATE NOWAIT;
1605:
1606: l_api_version CONSTANT NUMBER := 1;
1607: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1623: OPEN lock_csr(p_okl_criteria_tl_rec);

1619: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1620: RAISE okl_api.G_EXCEPTION_ERROR;
1621: END IF;
1622: BEGIN
1623: OPEN lock_csr(p_okl_criteria_tl_rec);
1624: FETCH lock_csr INTO l_lock_var;
1625: l_row_notfound := lock_csr%NOTFOUND;
1626: CLOSE lock_csr;
1627: EXCEPTION

Line 1688: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;

1684: l_api_version CONSTANT NUMBER := 1;
1685: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1686: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1687: l_crn_rec crn_rec_type;
1688: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
1689: BEGIN
1690: l_return_status := okl_api.START_ACTIVITY(l_api_name,
1691: G_PKG_NAME,
1692: p_init_msg_list,

Line 1706: migrate(p_crnv_rec, l_okl_criteria_tl_rec);

1702: --------------------------------------
1703: -- Move VIEW record to "Child" records
1704: --------------------------------------
1705: migrate(p_crnv_rec, l_crn_rec);
1706: migrate(p_crnv_rec, l_okl_criteria_tl_rec);
1707: --------------------------------------------
1708: -- Call the LOCK_ROW for each child record
1709: --------------------------------------------
1710: lock_row(

Line 1727: l_okl_criteria_tl_rec

1723: p_init_msg_list,
1724: x_return_status,
1725: x_msg_count,
1726: x_msg_data,
1727: l_okl_criteria_tl_rec
1728: );
1729: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2076: -- update_row for:OKL_CRITERIA_TL --

2072: '_PVT'
2073: );
2074: END update_row;
2075: ------------------------------------
2076: -- update_row for:OKL_CRITERIA_TL --
2077: ------------------------------------
2078: PROCEDURE update_row(
2079: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2080: x_return_status OUT NOCOPY VARCHAR2,

Line 2083: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,

2079: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2080: x_return_status OUT NOCOPY VARCHAR2,
2081: x_msg_count OUT NOCOPY NUMBER,
2082: x_msg_data OUT NOCOPY VARCHAR2,
2083: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2084: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type) IS
2085:
2086: l_api_version CONSTANT NUMBER := 1;
2087: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2084: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type) IS

2080: x_return_status OUT NOCOPY VARCHAR2,
2081: x_msg_count OUT NOCOPY NUMBER,
2082: x_msg_data OUT NOCOPY VARCHAR2,
2083: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2084: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type) IS
2085:
2086: l_api_version CONSTANT NUMBER := 1;
2087: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2088: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2089: l_okl_criteria_tl_rec okl_criteria_tl_rec_type := p_okl_criteria_tl_rec;

2085:
2086: l_api_version CONSTANT NUMBER := 1;
2087: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2088: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2089: l_okl_criteria_tl_rec okl_criteria_tl_rec_type := p_okl_criteria_tl_rec;
2090: l_def_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2091: l_row_notfound BOOLEAN := TRUE;
2092: ----------------------------------
2093: -- FUNCTION populate_new_record --

Line 2090: l_def_okl_criteria_tl_rec okl_criteria_tl_rec_type;

2086: l_api_version CONSTANT NUMBER := 1;
2087: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2088: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2089: l_okl_criteria_tl_rec okl_criteria_tl_rec_type := p_okl_criteria_tl_rec;
2090: l_def_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2091: l_row_notfound BOOLEAN := TRUE;
2092: ----------------------------------
2093: -- FUNCTION populate_new_record --
2094: ----------------------------------

Line 2096: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,

2092: ----------------------------------
2093: -- FUNCTION populate_new_record --
2094: ----------------------------------
2095: FUNCTION populate_new_record (
2096: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2097: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2098: ) RETURN VARCHAR2 IS
2099: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2100: l_row_notfound BOOLEAN := TRUE;

Line 2097: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type

2093: -- FUNCTION populate_new_record --
2094: ----------------------------------
2095: FUNCTION populate_new_record (
2096: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2097: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2098: ) RETURN VARCHAR2 IS
2099: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2100: l_row_notfound BOOLEAN := TRUE;
2101: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2099: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;

2095: FUNCTION populate_new_record (
2096: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2097: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2098: ) RETURN VARCHAR2 IS
2099: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2100: l_row_notfound BOOLEAN := TRUE;
2101: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2102: BEGIN
2103: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;

Line 2103: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;

2099: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2100: l_row_notfound BOOLEAN := TRUE;
2101: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2102: BEGIN
2103: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
2104: -- Get current database values
2105: l_okl_criteria_tl_rec := get_rec(p_okl_criteria_tl_rec, l_row_notfound);
2106: IF (l_row_notfound) THEN
2107: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;

Line 2105: l_okl_criteria_tl_rec := get_rec(p_okl_criteria_tl_rec, l_row_notfound);

2101: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2102: BEGIN
2103: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
2104: -- Get current database values
2105: l_okl_criteria_tl_rec := get_rec(p_okl_criteria_tl_rec, l_row_notfound);
2106: IF (l_row_notfound) THEN
2107: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2108: END IF;
2109: IF (x_okl_criteria_tl_rec.id = okl_api.G_MISS_NUM)

Line 2109: IF (x_okl_criteria_tl_rec.id = okl_api.G_MISS_NUM)

2105: l_okl_criteria_tl_rec := get_rec(p_okl_criteria_tl_rec, l_row_notfound);
2106: IF (l_row_notfound) THEN
2107: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2108: END IF;
2109: IF (x_okl_criteria_tl_rec.id = okl_api.G_MISS_NUM)
2110: THEN
2111: x_okl_criteria_tl_rec.id := l_okl_criteria_tl_rec.id;
2112: END IF;
2113: IF (x_okl_criteria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

Line 2111: x_okl_criteria_tl_rec.id := l_okl_criteria_tl_rec.id;

2107: l_return_status := okl_api.G_RET_STS_UNEXP_ERROR;
2108: END IF;
2109: IF (x_okl_criteria_tl_rec.id = okl_api.G_MISS_NUM)
2110: THEN
2111: x_okl_criteria_tl_rec.id := l_okl_criteria_tl_rec.id;
2112: END IF;
2113: IF (x_okl_criteria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2114: THEN
2115: x_okl_criteria_tl_rec.LANGUAGE := l_okl_criteria_tl_rec.LANGUAGE;

Line 2113: IF (x_okl_criteria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)

2109: IF (x_okl_criteria_tl_rec.id = okl_api.G_MISS_NUM)
2110: THEN
2111: x_okl_criteria_tl_rec.id := l_okl_criteria_tl_rec.id;
2112: END IF;
2113: IF (x_okl_criteria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2114: THEN
2115: x_okl_criteria_tl_rec.LANGUAGE := l_okl_criteria_tl_rec.LANGUAGE;
2116: END IF;
2117: IF (x_okl_criteria_tl_rec.source_lang = okl_api.G_MISS_CHAR)

Line 2115: x_okl_criteria_tl_rec.LANGUAGE := l_okl_criteria_tl_rec.LANGUAGE;

2111: x_okl_criteria_tl_rec.id := l_okl_criteria_tl_rec.id;
2112: END IF;
2113: IF (x_okl_criteria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2114: THEN
2115: x_okl_criteria_tl_rec.LANGUAGE := l_okl_criteria_tl_rec.LANGUAGE;
2116: END IF;
2117: IF (x_okl_criteria_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2118: THEN
2119: x_okl_criteria_tl_rec.source_lang := l_okl_criteria_tl_rec.source_lang;

Line 2117: IF (x_okl_criteria_tl_rec.source_lang = okl_api.G_MISS_CHAR)

2113: IF (x_okl_criteria_tl_rec.LANGUAGE = okl_api.G_MISS_CHAR)
2114: THEN
2115: x_okl_criteria_tl_rec.LANGUAGE := l_okl_criteria_tl_rec.LANGUAGE;
2116: END IF;
2117: IF (x_okl_criteria_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2118: THEN
2119: x_okl_criteria_tl_rec.source_lang := l_okl_criteria_tl_rec.source_lang;
2120: END IF;
2121: IF (x_okl_criteria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

Line 2119: x_okl_criteria_tl_rec.source_lang := l_okl_criteria_tl_rec.source_lang;

2115: x_okl_criteria_tl_rec.LANGUAGE := l_okl_criteria_tl_rec.LANGUAGE;
2116: END IF;
2117: IF (x_okl_criteria_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2118: THEN
2119: x_okl_criteria_tl_rec.source_lang := l_okl_criteria_tl_rec.source_lang;
2120: END IF;
2121: IF (x_okl_criteria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2122: THEN
2123: x_okl_criteria_tl_rec.sfwt_flag := l_okl_criteria_tl_rec.sfwt_flag;

Line 2121: IF (x_okl_criteria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)

2117: IF (x_okl_criteria_tl_rec.source_lang = okl_api.G_MISS_CHAR)
2118: THEN
2119: x_okl_criteria_tl_rec.source_lang := l_okl_criteria_tl_rec.source_lang;
2120: END IF;
2121: IF (x_okl_criteria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2122: THEN
2123: x_okl_criteria_tl_rec.sfwt_flag := l_okl_criteria_tl_rec.sfwt_flag;
2124: END IF;
2125: IF (x_okl_criteria_tl_rec.name = okl_api.G_MISS_CHAR)

Line 2123: x_okl_criteria_tl_rec.sfwt_flag := l_okl_criteria_tl_rec.sfwt_flag;

2119: x_okl_criteria_tl_rec.source_lang := l_okl_criteria_tl_rec.source_lang;
2120: END IF;
2121: IF (x_okl_criteria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2122: THEN
2123: x_okl_criteria_tl_rec.sfwt_flag := l_okl_criteria_tl_rec.sfwt_flag;
2124: END IF;
2125: IF (x_okl_criteria_tl_rec.name = okl_api.G_MISS_CHAR)
2126: THEN
2127: x_okl_criteria_tl_rec.name := l_okl_criteria_tl_rec.name;

Line 2125: IF (x_okl_criteria_tl_rec.name = okl_api.G_MISS_CHAR)

2121: IF (x_okl_criteria_tl_rec.sfwt_flag = okl_api.G_MISS_CHAR)
2122: THEN
2123: x_okl_criteria_tl_rec.sfwt_flag := l_okl_criteria_tl_rec.sfwt_flag;
2124: END IF;
2125: IF (x_okl_criteria_tl_rec.name = okl_api.G_MISS_CHAR)
2126: THEN
2127: x_okl_criteria_tl_rec.name := l_okl_criteria_tl_rec.name;
2128: END IF;
2129: IF (x_okl_criteria_tl_rec.description = okl_api.G_MISS_CHAR)

Line 2127: x_okl_criteria_tl_rec.name := l_okl_criteria_tl_rec.name;

2123: x_okl_criteria_tl_rec.sfwt_flag := l_okl_criteria_tl_rec.sfwt_flag;
2124: END IF;
2125: IF (x_okl_criteria_tl_rec.name = okl_api.G_MISS_CHAR)
2126: THEN
2127: x_okl_criteria_tl_rec.name := l_okl_criteria_tl_rec.name;
2128: END IF;
2129: IF (x_okl_criteria_tl_rec.description = okl_api.G_MISS_CHAR)
2130: THEN
2131: x_okl_criteria_tl_rec.description := l_okl_criteria_tl_rec.description;

Line 2129: IF (x_okl_criteria_tl_rec.description = okl_api.G_MISS_CHAR)

2125: IF (x_okl_criteria_tl_rec.name = okl_api.G_MISS_CHAR)
2126: THEN
2127: x_okl_criteria_tl_rec.name := l_okl_criteria_tl_rec.name;
2128: END IF;
2129: IF (x_okl_criteria_tl_rec.description = okl_api.G_MISS_CHAR)
2130: THEN
2131: x_okl_criteria_tl_rec.description := l_okl_criteria_tl_rec.description;
2132: END IF;
2133: IF (x_okl_criteria_tl_rec.created_by = okl_api.G_MISS_NUM)

Line 2131: x_okl_criteria_tl_rec.description := l_okl_criteria_tl_rec.description;

2127: x_okl_criteria_tl_rec.name := l_okl_criteria_tl_rec.name;
2128: END IF;
2129: IF (x_okl_criteria_tl_rec.description = okl_api.G_MISS_CHAR)
2130: THEN
2131: x_okl_criteria_tl_rec.description := l_okl_criteria_tl_rec.description;
2132: END IF;
2133: IF (x_okl_criteria_tl_rec.created_by = okl_api.G_MISS_NUM)
2134: THEN
2135: x_okl_criteria_tl_rec.created_by := l_okl_criteria_tl_rec.created_by;

Line 2133: IF (x_okl_criteria_tl_rec.created_by = okl_api.G_MISS_NUM)

2129: IF (x_okl_criteria_tl_rec.description = okl_api.G_MISS_CHAR)
2130: THEN
2131: x_okl_criteria_tl_rec.description := l_okl_criteria_tl_rec.description;
2132: END IF;
2133: IF (x_okl_criteria_tl_rec.created_by = okl_api.G_MISS_NUM)
2134: THEN
2135: x_okl_criteria_tl_rec.created_by := l_okl_criteria_tl_rec.created_by;
2136: END IF;
2137: IF (x_okl_criteria_tl_rec.creation_date = okl_api.G_MISS_DATE)

Line 2135: x_okl_criteria_tl_rec.created_by := l_okl_criteria_tl_rec.created_by;

2131: x_okl_criteria_tl_rec.description := l_okl_criteria_tl_rec.description;
2132: END IF;
2133: IF (x_okl_criteria_tl_rec.created_by = okl_api.G_MISS_NUM)
2134: THEN
2135: x_okl_criteria_tl_rec.created_by := l_okl_criteria_tl_rec.created_by;
2136: END IF;
2137: IF (x_okl_criteria_tl_rec.creation_date = okl_api.G_MISS_DATE)
2138: THEN
2139: x_okl_criteria_tl_rec.creation_date := l_okl_criteria_tl_rec.creation_date;

Line 2137: IF (x_okl_criteria_tl_rec.creation_date = okl_api.G_MISS_DATE)

2133: IF (x_okl_criteria_tl_rec.created_by = okl_api.G_MISS_NUM)
2134: THEN
2135: x_okl_criteria_tl_rec.created_by := l_okl_criteria_tl_rec.created_by;
2136: END IF;
2137: IF (x_okl_criteria_tl_rec.creation_date = okl_api.G_MISS_DATE)
2138: THEN
2139: x_okl_criteria_tl_rec.creation_date := l_okl_criteria_tl_rec.creation_date;
2140: END IF;
2141: IF (x_okl_criteria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

Line 2139: x_okl_criteria_tl_rec.creation_date := l_okl_criteria_tl_rec.creation_date;

2135: x_okl_criteria_tl_rec.created_by := l_okl_criteria_tl_rec.created_by;
2136: END IF;
2137: IF (x_okl_criteria_tl_rec.creation_date = okl_api.G_MISS_DATE)
2138: THEN
2139: x_okl_criteria_tl_rec.creation_date := l_okl_criteria_tl_rec.creation_date;
2140: END IF;
2141: IF (x_okl_criteria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2142: THEN
2143: x_okl_criteria_tl_rec.last_updated_by := l_okl_criteria_tl_rec.last_updated_by;

Line 2141: IF (x_okl_criteria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)

2137: IF (x_okl_criteria_tl_rec.creation_date = okl_api.G_MISS_DATE)
2138: THEN
2139: x_okl_criteria_tl_rec.creation_date := l_okl_criteria_tl_rec.creation_date;
2140: END IF;
2141: IF (x_okl_criteria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2142: THEN
2143: x_okl_criteria_tl_rec.last_updated_by := l_okl_criteria_tl_rec.last_updated_by;
2144: END IF;
2145: IF (x_okl_criteria_tl_rec.last_update_date = okl_api.G_MISS_DATE)

Line 2143: x_okl_criteria_tl_rec.last_updated_by := l_okl_criteria_tl_rec.last_updated_by;

2139: x_okl_criteria_tl_rec.creation_date := l_okl_criteria_tl_rec.creation_date;
2140: END IF;
2141: IF (x_okl_criteria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2142: THEN
2143: x_okl_criteria_tl_rec.last_updated_by := l_okl_criteria_tl_rec.last_updated_by;
2144: END IF;
2145: IF (x_okl_criteria_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2146: THEN
2147: x_okl_criteria_tl_rec.last_update_date := l_okl_criteria_tl_rec.last_update_date;

Line 2145: IF (x_okl_criteria_tl_rec.last_update_date = okl_api.G_MISS_DATE)

2141: IF (x_okl_criteria_tl_rec.last_updated_by = okl_api.G_MISS_NUM)
2142: THEN
2143: x_okl_criteria_tl_rec.last_updated_by := l_okl_criteria_tl_rec.last_updated_by;
2144: END IF;
2145: IF (x_okl_criteria_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2146: THEN
2147: x_okl_criteria_tl_rec.last_update_date := l_okl_criteria_tl_rec.last_update_date;
2148: END IF;
2149: IF (x_okl_criteria_tl_rec.last_update_login = okl_api.G_MISS_NUM)

Line 2147: x_okl_criteria_tl_rec.last_update_date := l_okl_criteria_tl_rec.last_update_date;

2143: x_okl_criteria_tl_rec.last_updated_by := l_okl_criteria_tl_rec.last_updated_by;
2144: END IF;
2145: IF (x_okl_criteria_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2146: THEN
2147: x_okl_criteria_tl_rec.last_update_date := l_okl_criteria_tl_rec.last_update_date;
2148: END IF;
2149: IF (x_okl_criteria_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2150: THEN
2151: x_okl_criteria_tl_rec.last_update_login := l_okl_criteria_tl_rec.last_update_login;

Line 2149: IF (x_okl_criteria_tl_rec.last_update_login = okl_api.G_MISS_NUM)

2145: IF (x_okl_criteria_tl_rec.last_update_date = okl_api.G_MISS_DATE)
2146: THEN
2147: x_okl_criteria_tl_rec.last_update_date := l_okl_criteria_tl_rec.last_update_date;
2148: END IF;
2149: IF (x_okl_criteria_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2150: THEN
2151: x_okl_criteria_tl_rec.last_update_login := l_okl_criteria_tl_rec.last_update_login;
2152: END IF;
2153: RETURN(l_return_status);

Line 2151: x_okl_criteria_tl_rec.last_update_login := l_okl_criteria_tl_rec.last_update_login;

2147: x_okl_criteria_tl_rec.last_update_date := l_okl_criteria_tl_rec.last_update_date;
2148: END IF;
2149: IF (x_okl_criteria_tl_rec.last_update_login = okl_api.G_MISS_NUM)
2150: THEN
2151: x_okl_criteria_tl_rec.last_update_login := l_okl_criteria_tl_rec.last_update_login;
2152: END IF;
2153: RETURN(l_return_status);
2154: END populate_new_record;
2155: ----------------------------------------

Line 2156: -- Set_Attributes for:OKL_CRITERIA_TL --

2152: END IF;
2153: RETURN(l_return_status);
2154: END populate_new_record;
2155: ----------------------------------------
2156: -- Set_Attributes for:OKL_CRITERIA_TL --
2157: ----------------------------------------
2158: FUNCTION Set_Attributes (
2159: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2160: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type

Line 2159: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,

2155: ----------------------------------------
2156: -- Set_Attributes for:OKL_CRITERIA_TL --
2157: ----------------------------------------
2158: FUNCTION Set_Attributes (
2159: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2160: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2161: ) RETURN VARCHAR2 IS
2162: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2163: BEGIN

Line 2160: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type

2156: -- Set_Attributes for:OKL_CRITERIA_TL --
2157: ----------------------------------------
2158: FUNCTION Set_Attributes (
2159: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2160: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2161: ) RETURN VARCHAR2 IS
2162: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2163: BEGIN
2164: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;

Line 2164: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;

2160: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2161: ) RETURN VARCHAR2 IS
2162: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2163: BEGIN
2164: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
2165: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');
2166: x_okl_criteria_tl_rec.SOURCE_LANG := USERENV('LANG');
2167: RETURN(l_return_status);
2168: END Set_Attributes;

Line 2165: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');

2161: ) RETURN VARCHAR2 IS
2162: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2163: BEGIN
2164: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
2165: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');
2166: x_okl_criteria_tl_rec.SOURCE_LANG := USERENV('LANG');
2167: RETURN(l_return_status);
2168: END Set_Attributes;
2169: BEGIN

Line 2166: x_okl_criteria_tl_rec.SOURCE_LANG := USERENV('LANG');

2162: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2163: BEGIN
2164: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
2165: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');
2166: x_okl_criteria_tl_rec.SOURCE_LANG := USERENV('LANG');
2167: RETURN(l_return_status);
2168: END Set_Attributes;
2169: BEGIN
2170: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 2181: p_okl_criteria_tl_rec, -- IN

2177: RAISE okl_api.G_EXCEPTION_ERROR;
2178: END IF;
2179: --- Setting item attributes
2180: l_return_status := Set_Attributes(
2181: p_okl_criteria_tl_rec, -- IN
2182: l_okl_criteria_tl_rec); -- OUT
2183: --- If any errors happen abort API
2184: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2185: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2182: l_okl_criteria_tl_rec); -- OUT

2178: END IF;
2179: --- Setting item attributes
2180: l_return_status := Set_Attributes(
2181: p_okl_criteria_tl_rec, -- IN
2182: l_okl_criteria_tl_rec); -- OUT
2183: --- If any errors happen abort API
2184: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2185: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2186: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2189: l_return_status := populate_new_record(l_okl_criteria_tl_rec, l_def_okl_criteria_tl_rec);

2185: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2186: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2187: RAISE okl_api.G_EXCEPTION_ERROR;
2188: END IF;
2189: l_return_status := populate_new_record(l_okl_criteria_tl_rec, l_def_okl_criteria_tl_rec);
2190: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2191: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2192: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2193: RAISE okl_api.G_EXCEPTION_ERROR;

Line 2195: UPDATE OKL_CRITERIA_TL

2191: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2192: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2193: RAISE okl_api.G_EXCEPTION_ERROR;
2194: END IF;
2195: UPDATE OKL_CRITERIA_TL
2196: SET NAME = l_def_okl_criteria_tl_rec.name,
2197: DESCRIPTION = l_def_okl_criteria_tl_rec.description,
2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,
2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,

Line 2196: SET NAME = l_def_okl_criteria_tl_rec.name,

2192: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2193: RAISE okl_api.G_EXCEPTION_ERROR;
2194: END IF;
2195: UPDATE OKL_CRITERIA_TL
2196: SET NAME = l_def_okl_criteria_tl_rec.name,
2197: DESCRIPTION = l_def_okl_criteria_tl_rec.description,
2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,
2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,
2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,

Line 2197: DESCRIPTION = l_def_okl_criteria_tl_rec.description,

2193: RAISE okl_api.G_EXCEPTION_ERROR;
2194: END IF;
2195: UPDATE OKL_CRITERIA_TL
2196: SET NAME = l_def_okl_criteria_tl_rec.name,
2197: DESCRIPTION = l_def_okl_criteria_tl_rec.description,
2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,
2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,
2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,
2201: LAST_UPDATE_DATE = l_def_okl_criteria_tl_rec.last_update_date,

Line 2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,

2194: END IF;
2195: UPDATE OKL_CRITERIA_TL
2196: SET NAME = l_def_okl_criteria_tl_rec.name,
2197: DESCRIPTION = l_def_okl_criteria_tl_rec.description,
2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,
2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,
2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,
2201: LAST_UPDATE_DATE = l_def_okl_criteria_tl_rec.last_update_date,
2202: LAST_UPDATE_LOGIN = l_def_okl_criteria_tl_rec.last_update_login

Line 2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,

2195: UPDATE OKL_CRITERIA_TL
2196: SET NAME = l_def_okl_criteria_tl_rec.name,
2197: DESCRIPTION = l_def_okl_criteria_tl_rec.description,
2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,
2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,
2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,
2201: LAST_UPDATE_DATE = l_def_okl_criteria_tl_rec.last_update_date,
2202: LAST_UPDATE_LOGIN = l_def_okl_criteria_tl_rec.last_update_login
2203: WHERE ID = l_def_okl_criteria_tl_rec.id

Line 2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,

2196: SET NAME = l_def_okl_criteria_tl_rec.name,
2197: DESCRIPTION = l_def_okl_criteria_tl_rec.description,
2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,
2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,
2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,
2201: LAST_UPDATE_DATE = l_def_okl_criteria_tl_rec.last_update_date,
2202: LAST_UPDATE_LOGIN = l_def_okl_criteria_tl_rec.last_update_login
2203: WHERE ID = l_def_okl_criteria_tl_rec.id
2204: --AND SOURCE_LANG = USERENV('LANG');

Line 2201: LAST_UPDATE_DATE = l_def_okl_criteria_tl_rec.last_update_date,

2197: DESCRIPTION = l_def_okl_criteria_tl_rec.description,
2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,
2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,
2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,
2201: LAST_UPDATE_DATE = l_def_okl_criteria_tl_rec.last_update_date,
2202: LAST_UPDATE_LOGIN = l_def_okl_criteria_tl_rec.last_update_login
2203: WHERE ID = l_def_okl_criteria_tl_rec.id
2204: --AND SOURCE_LANG = USERENV('LANG');
2205: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);

Line 2202: LAST_UPDATE_LOGIN = l_def_okl_criteria_tl_rec.last_update_login

2198: CREATED_BY = l_def_okl_criteria_tl_rec.created_by,
2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,
2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,
2201: LAST_UPDATE_DATE = l_def_okl_criteria_tl_rec.last_update_date,
2202: LAST_UPDATE_LOGIN = l_def_okl_criteria_tl_rec.last_update_login
2203: WHERE ID = l_def_okl_criteria_tl_rec.id
2204: --AND SOURCE_LANG = USERENV('LANG');
2205: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2206:

Line 2203: WHERE ID = l_def_okl_criteria_tl_rec.id

2199: CREATION_DATE = l_def_okl_criteria_tl_rec.creation_date,
2200: LAST_UPDATED_BY = l_def_okl_criteria_tl_rec.last_updated_by,
2201: LAST_UPDATE_DATE = l_def_okl_criteria_tl_rec.last_update_date,
2202: LAST_UPDATE_LOGIN = l_def_okl_criteria_tl_rec.last_update_login
2203: WHERE ID = l_def_okl_criteria_tl_rec.id
2204: --AND SOURCE_LANG = USERENV('LANG');
2205: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2206:
2207: UPDATE OKL_CRITERIA_TL

Line 2207: UPDATE OKL_CRITERIA_TL

2203: WHERE ID = l_def_okl_criteria_tl_rec.id
2204: --AND SOURCE_LANG = USERENV('LANG');
2205: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2206:
2207: UPDATE OKL_CRITERIA_TL
2208: SET SFWT_FLAG = 'Y'
2209: WHERE ID = l_def_okl_criteria_tl_rec.id
2210: AND SOURCE_LANG <> USERENV('LANG');
2211:

Line 2209: WHERE ID = l_def_okl_criteria_tl_rec.id

2205: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2206:
2207: UPDATE OKL_CRITERIA_TL
2208: SET SFWT_FLAG = 'Y'
2209: WHERE ID = l_def_okl_criteria_tl_rec.id
2210: AND SOURCE_LANG <> USERENV('LANG');
2211:
2212: x_okl_criteria_tl_rec := l_def_okl_criteria_tl_rec;
2213: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2212: x_okl_criteria_tl_rec := l_def_okl_criteria_tl_rec;

2208: SET SFWT_FLAG = 'Y'
2209: WHERE ID = l_def_okl_criteria_tl_rec.id
2210: AND SOURCE_LANG <> USERENV('LANG');
2211:
2212: x_okl_criteria_tl_rec := l_def_okl_criteria_tl_rec;
2213: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2214: EXCEPTION
2215: WHEN okl_api.G_EXCEPTION_ERROR THEN
2216: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 2263: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;

2259: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2260: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2261: l_crnv_rec crnv_rec_type := p_crnv_rec;
2262: l_def_crnv_rec crnv_rec_type;
2263: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2264: lx_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2265: l_crn_rec crn_rec_type;
2266: lx_crn_rec crn_rec_type;
2267: -------------------------------

Line 2264: lx_okl_criteria_tl_rec okl_criteria_tl_rec_type;

2260: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2261: l_crnv_rec crnv_rec_type := p_crnv_rec;
2262: l_def_crnv_rec crnv_rec_type;
2263: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2264: lx_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2265: l_crn_rec crn_rec_type;
2266: lx_crn_rec crn_rec_type;
2267: -------------------------------
2268: -- FUNCTION fill_who_columns --

Line 2476: migrate(l_def_crnv_rec, l_okl_criteria_tl_rec);

2472:
2473: --------------------------------------
2474: -- Move VIEW record to "Child" records
2475: --------------------------------------
2476: migrate(l_def_crnv_rec, l_okl_criteria_tl_rec);
2477: migrate(l_def_crnv_rec, l_crn_rec);
2478: --------------------------------------------
2479: -- Call the UPDATE_ROW for each child record
2480: --------------------------------------------

Line 2486: l_okl_criteria_tl_rec,

2482: p_init_msg_list,
2483: x_return_status,
2484: x_msg_count,
2485: x_msg_data,
2486: l_okl_criteria_tl_rec,
2487: lx_okl_criteria_tl_rec
2488: );
2489: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2490: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2487: lx_okl_criteria_tl_rec

2483: x_return_status,
2484: x_msg_count,
2485: x_msg_data,
2486: l_okl_criteria_tl_rec,
2487: lx_okl_criteria_tl_rec
2488: );
2489: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2490: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2491: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2494: migrate(lx_okl_criteria_tl_rec, l_def_crnv_rec);

2490: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2491: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN
2492: RAISE okl_api.G_EXCEPTION_ERROR;
2493: END IF;
2494: migrate(lx_okl_criteria_tl_rec, l_def_crnv_rec);
2495: update_row(
2496: p_init_msg_list,
2497: x_return_status,
2498: x_msg_count,

Line 2675: -- delete_row for:OKL_CRITERIA_TL --

2671: '_PVT'
2672: );
2673: END delete_row;
2674: ------------------------------------
2675: -- delete_row for:OKL_CRITERIA_TL --
2676: ------------------------------------
2677: PROCEDURE delete_row(
2678: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2679: x_return_status OUT NOCOPY VARCHAR2,

Line 2682: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS

2678: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2679: x_return_status OUT NOCOPY VARCHAR2,
2680: x_msg_count OUT NOCOPY NUMBER,
2681: x_msg_data OUT NOCOPY VARCHAR2,
2682: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type) IS
2683:
2684: l_api_version CONSTANT NUMBER := 1;
2685: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2686: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 2687: l_okl_criteria_tl_rec okl_criteria_tl_rec_type:= p_okl_criteria_tl_rec;

2683:
2684: l_api_version CONSTANT NUMBER := 1;
2685: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2686: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2687: l_okl_criteria_tl_rec okl_criteria_tl_rec_type:= p_okl_criteria_tl_rec;
2688: l_row_notfound BOOLEAN := TRUE;
2689: ----------------------------------------
2690: -- Set_Attributes for:OKL_CRITERIA_TL --
2691: ----------------------------------------

Line 2690: -- Set_Attributes for:OKL_CRITERIA_TL --

2686: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2687: l_okl_criteria_tl_rec okl_criteria_tl_rec_type:= p_okl_criteria_tl_rec;
2688: l_row_notfound BOOLEAN := TRUE;
2689: ----------------------------------------
2690: -- Set_Attributes for:OKL_CRITERIA_TL --
2691: ----------------------------------------
2692: FUNCTION Set_Attributes (
2693: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2694: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type

Line 2693: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,

2689: ----------------------------------------
2690: -- Set_Attributes for:OKL_CRITERIA_TL --
2691: ----------------------------------------
2692: FUNCTION Set_Attributes (
2693: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2694: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2695: ) RETURN VARCHAR2 IS
2696: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2697: BEGIN

Line 2694: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type

2690: -- Set_Attributes for:OKL_CRITERIA_TL --
2691: ----------------------------------------
2692: FUNCTION Set_Attributes (
2693: p_okl_criteria_tl_rec IN okl_criteria_tl_rec_type,
2694: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2695: ) RETURN VARCHAR2 IS
2696: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2697: BEGIN
2698: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;

Line 2698: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;

2694: x_okl_criteria_tl_rec OUT NOCOPY okl_criteria_tl_rec_type
2695: ) RETURN VARCHAR2 IS
2696: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2697: BEGIN
2698: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
2699: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');
2700: RETURN(l_return_status);
2701: END Set_Attributes;
2702: BEGIN

Line 2699: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');

2695: ) RETURN VARCHAR2 IS
2696: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2697: BEGIN
2698: x_okl_criteria_tl_rec := p_okl_criteria_tl_rec;
2699: x_okl_criteria_tl_rec.LANGUAGE := USERENV('LANG');
2700: RETURN(l_return_status);
2701: END Set_Attributes;
2702: BEGIN
2703: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 2714: p_okl_criteria_tl_rec, -- IN

2710: RAISE okl_api.G_EXCEPTION_ERROR;
2711: END IF;
2712: --- Setting item attributes
2713: l_return_status := Set_Attributes(
2714: p_okl_criteria_tl_rec, -- IN
2715: l_okl_criteria_tl_rec); -- OUT
2716: --- If any errors happen abort API
2717: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2718: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2715: l_okl_criteria_tl_rec); -- OUT

2711: END IF;
2712: --- Setting item attributes
2713: l_return_status := Set_Attributes(
2714: p_okl_criteria_tl_rec, -- IN
2715: l_okl_criteria_tl_rec); -- OUT
2716: --- If any errors happen abort API
2717: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2718: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2719: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

Line 2722: DELETE FROM OKL_CRITERIA_TL

2718: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2719: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2720: RAISE okl_api.G_EXCEPTION_ERROR;
2721: END IF;
2722: DELETE FROM OKL_CRITERIA_TL
2723: WHERE ID = l_okl_criteria_tl_rec.id;
2724:
2725: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2726: EXCEPTION

Line 2723: WHERE ID = l_okl_criteria_tl_rec.id;

2719: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2720: RAISE okl_api.G_EXCEPTION_ERROR;
2721: END IF;
2722: DELETE FROM OKL_CRITERIA_TL
2723: WHERE ID = l_okl_criteria_tl_rec.id;
2724:
2725: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2726: EXCEPTION
2727: WHEN okl_api.G_EXCEPTION_ERROR THEN

Line 2773: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;

2769: l_api_version CONSTANT NUMBER := 1;
2770: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2771: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
2772: l_crnv_rec crnv_rec_type := p_crnv_rec;
2773: l_okl_criteria_tl_rec okl_criteria_tl_rec_type;
2774: l_crn_rec crn_rec_type;
2775: BEGIN
2776: l_return_status := okl_api.START_ACTIVITY(l_api_name,
2777: G_PKG_NAME,

Line 2791: migrate(l_crnv_rec, l_okl_criteria_tl_rec);

2787: END IF;
2788: --------------------------------------
2789: -- Move VIEW record to "Child" records
2790: --------------------------------------
2791: migrate(l_crnv_rec, l_okl_criteria_tl_rec);
2792: migrate(l_crnv_rec, l_crn_rec);
2793: --------------------------------------------
2794: -- Call the DELETE_ROW for each child record
2795: --------------------------------------------

Line 2801: l_okl_criteria_tl_rec

2797: p_init_msg_list,
2798: x_return_status,
2799: x_msg_count,
2800: x_msg_data,
2801: l_okl_criteria_tl_rec
2802: );
2803: IF (x_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
2804: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2805: ELSIF (x_return_status = okl_api.G_RET_STS_ERROR) THEN