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_LLN_PVT dependencies on OKL_CNSLD_AR_LINES_TL

Line 381: DELETE FROM OKL_CNSLD_AR_LINES_TL T

377: -- PROCEDURE add_language
378: ---------------------------------------------------------------------------
379: PROCEDURE add_language IS
380: BEGIN
381: DELETE FROM OKL_CNSLD_AR_LINES_TL T
382: WHERE NOT EXISTS (
383: SELECT NULL
384: FROM OKL_CNSLD_AR_LINES_B B
385: WHERE B.ID = T.ID

Line 407: FROM OKL_CNSLD_AR_LINES_TL SUBB, OKL_CNSLD_AR_LINES_TL SUBT

403: T.LANGUAGE)
404: IN (SELECT
405: SUBT.ID,
406: SUBT.LANGUAGE
407: FROM OKL_CNSLD_AR_LINES_TL SUBB, OKL_CNSLD_AR_LINES_TL SUBT
408: WHERE SUBB.ID = SUBT.ID
409: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
410: */
411:

Line 412: INSERT INTO OKL_CNSLD_AR_LINES_TL (

408: WHERE SUBB.ID = SUBT.ID
409: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
410: */
411:
412: INSERT INTO OKL_CNSLD_AR_LINES_TL (
413: ID,
414: LANGUAGE,
415: SOURCE_LANG,
416: SFWT_FLAG,

Line 432: FROM OKL_CNSLD_AR_LINES_TL B, FND_LANGUAGES L

428: B.CREATION_DATE,
429: B.LAST_UPDATED_BY,
430: B.LAST_UPDATE_DATE,
431: B.LAST_UPDATE_LOGIN
432: FROM OKL_CNSLD_AR_LINES_TL B, FND_LANGUAGES L
433: WHERE L.INSTALLED_FLAG IN ('I', 'B')
434: AND B.LANGUAGE = USERENV('LANG')
435: AND NOT EXISTS(
436: SELECT NULL

Line 437: FROM OKL_CNSLD_AR_LINES_TL T

433: WHERE L.INSTALLED_FLAG IN ('I', 'B')
434: AND B.LANGUAGE = USERENV('LANG')
435: AND NOT EXISTS(
436: SELECT NULL
437: FROM OKL_CNSLD_AR_LINES_TL T
438: WHERE T.ID = B.ID
439: AND T.LANGUAGE = L.LANGUAGE_CODE
440: );
441:

Line 549: -- FUNCTION get_rec for: OKL_CNSLD_AR_LINES_TL

545: BEGIN
546: RETURN(get_rec(p_lln_rec, l_row_notfound));
547: END get_rec;
548: ---------------------------------------------------------------------------
549: -- FUNCTION get_rec for: OKL_CNSLD_AR_LINES_TL
550: ---------------------------------------------------------------------------
551: FUNCTION get_rec (
552: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
553: x_no_data_found OUT NOCOPY BOOLEAN

Line 552: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,

548: ---------------------------------------------------------------------------
549: -- FUNCTION get_rec for: OKL_CNSLD_AR_LINES_TL
550: ---------------------------------------------------------------------------
551: FUNCTION get_rec (
552: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
553: x_no_data_found OUT NOCOPY BOOLEAN
554: ) RETURN okl_cnsld_ar_lines_tl_rec_type IS
555: CURSOR okl_cnsld_ar_lines_tl_pk_csr (p_id IN NUMBER,
556: p_language IN VARCHAR2) IS

Line 554: ) RETURN okl_cnsld_ar_lines_tl_rec_type IS

550: ---------------------------------------------------------------------------
551: FUNCTION get_rec (
552: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
553: x_no_data_found OUT NOCOPY BOOLEAN
554: ) RETURN okl_cnsld_ar_lines_tl_rec_type IS
555: CURSOR okl_cnsld_ar_lines_tl_pk_csr (p_id IN NUMBER,
556: p_language IN VARCHAR2) IS
557: SELECT
558: ID,

Line 555: CURSOR okl_cnsld_ar_lines_tl_pk_csr (p_id IN NUMBER,

551: FUNCTION get_rec (
552: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
553: x_no_data_found OUT NOCOPY BOOLEAN
554: ) RETURN okl_cnsld_ar_lines_tl_rec_type IS
555: CURSOR okl_cnsld_ar_lines_tl_pk_csr (p_id IN NUMBER,
556: p_language IN VARCHAR2) IS
557: SELECT
558: ID,
559: LANGUAGE,

Line 567: FROM Okl_Cnsld_Ar_Lines_Tl

563: CREATION_DATE,
564: LAST_UPDATED_BY,
565: LAST_UPDATE_DATE,
566: LAST_UPDATE_LOGIN
567: FROM Okl_Cnsld_Ar_Lines_Tl
568: WHERE okl_cnsld_ar_lines_tl.id = p_id
569: AND okl_cnsld_ar_lines_tl.LANGUAGE = p_language;
570: l_okl_cnsld_ar_lines_tl_pk okl_cnsld_ar_lines_tl_pk_csr%ROWTYPE;
571: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

Line 568: WHERE okl_cnsld_ar_lines_tl.id = p_id

564: LAST_UPDATED_BY,
565: LAST_UPDATE_DATE,
566: LAST_UPDATE_LOGIN
567: FROM Okl_Cnsld_Ar_Lines_Tl
568: WHERE okl_cnsld_ar_lines_tl.id = p_id
569: AND okl_cnsld_ar_lines_tl.LANGUAGE = p_language;
570: l_okl_cnsld_ar_lines_tl_pk okl_cnsld_ar_lines_tl_pk_csr%ROWTYPE;
571: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
572: BEGIN

Line 569: AND okl_cnsld_ar_lines_tl.LANGUAGE = p_language;

565: LAST_UPDATE_DATE,
566: LAST_UPDATE_LOGIN
567: FROM Okl_Cnsld_Ar_Lines_Tl
568: WHERE okl_cnsld_ar_lines_tl.id = p_id
569: AND okl_cnsld_ar_lines_tl.LANGUAGE = p_language;
570: l_okl_cnsld_ar_lines_tl_pk okl_cnsld_ar_lines_tl_pk_csr%ROWTYPE;
571: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
572: BEGIN
573: x_no_data_found := TRUE;

Line 570: l_okl_cnsld_ar_lines_tl_pk okl_cnsld_ar_lines_tl_pk_csr%ROWTYPE;

566: LAST_UPDATE_LOGIN
567: FROM Okl_Cnsld_Ar_Lines_Tl
568: WHERE okl_cnsld_ar_lines_tl.id = p_id
569: AND okl_cnsld_ar_lines_tl.LANGUAGE = p_language;
570: l_okl_cnsld_ar_lines_tl_pk okl_cnsld_ar_lines_tl_pk_csr%ROWTYPE;
571: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
572: BEGIN
573: x_no_data_found := TRUE;
574: -- Get current database values

Line 571: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

567: FROM Okl_Cnsld_Ar_Lines_Tl
568: WHERE okl_cnsld_ar_lines_tl.id = p_id
569: AND okl_cnsld_ar_lines_tl.LANGUAGE = p_language;
570: l_okl_cnsld_ar_lines_tl_pk okl_cnsld_ar_lines_tl_pk_csr%ROWTYPE;
571: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
572: BEGIN
573: x_no_data_found := TRUE;
574: -- Get current database values
575: OPEN okl_cnsld_ar_lines_tl_pk_csr (p_okl_cnsld_ar_lines_tl_rec.id,

Line 575: OPEN okl_cnsld_ar_lines_tl_pk_csr (p_okl_cnsld_ar_lines_tl_rec.id,

571: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
572: BEGIN
573: x_no_data_found := TRUE;
574: -- Get current database values
575: OPEN okl_cnsld_ar_lines_tl_pk_csr (p_okl_cnsld_ar_lines_tl_rec.id,
576: p_okl_cnsld_ar_lines_tl_rec.LANGUAGE);
577: FETCH okl_cnsld_ar_lines_tl_pk_csr INTO
578: l_okl_cnsld_ar_lines_tl_rec.ID,
579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,

Line 576: p_okl_cnsld_ar_lines_tl_rec.LANGUAGE);

572: BEGIN
573: x_no_data_found := TRUE;
574: -- Get current database values
575: OPEN okl_cnsld_ar_lines_tl_pk_csr (p_okl_cnsld_ar_lines_tl_rec.id,
576: p_okl_cnsld_ar_lines_tl_rec.LANGUAGE);
577: FETCH okl_cnsld_ar_lines_tl_pk_csr INTO
578: l_okl_cnsld_ar_lines_tl_rec.ID,
579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,

Line 577: FETCH okl_cnsld_ar_lines_tl_pk_csr INTO

573: x_no_data_found := TRUE;
574: -- Get current database values
575: OPEN okl_cnsld_ar_lines_tl_pk_csr (p_okl_cnsld_ar_lines_tl_rec.id,
576: p_okl_cnsld_ar_lines_tl_rec.LANGUAGE);
577: FETCH okl_cnsld_ar_lines_tl_pk_csr INTO
578: l_okl_cnsld_ar_lines_tl_rec.ID,
579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,
581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,

Line 578: l_okl_cnsld_ar_lines_tl_rec.ID,

574: -- Get current database values
575: OPEN okl_cnsld_ar_lines_tl_pk_csr (p_okl_cnsld_ar_lines_tl_rec.id,
576: p_okl_cnsld_ar_lines_tl_rec.LANGUAGE);
577: FETCH okl_cnsld_ar_lines_tl_pk_csr INTO
578: l_okl_cnsld_ar_lines_tl_rec.ID,
579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,
581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,
582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,

Line 579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,

575: OPEN okl_cnsld_ar_lines_tl_pk_csr (p_okl_cnsld_ar_lines_tl_rec.id,
576: p_okl_cnsld_ar_lines_tl_rec.LANGUAGE);
577: FETCH okl_cnsld_ar_lines_tl_pk_csr INTO
578: l_okl_cnsld_ar_lines_tl_rec.ID,
579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,
581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,
582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,
583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,

Line 580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,

576: p_okl_cnsld_ar_lines_tl_rec.LANGUAGE);
577: FETCH okl_cnsld_ar_lines_tl_pk_csr INTO
578: l_okl_cnsld_ar_lines_tl_rec.ID,
579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,
581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,
582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,
583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,
584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,

Line 581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,

577: FETCH okl_cnsld_ar_lines_tl_pk_csr INTO
578: l_okl_cnsld_ar_lines_tl_rec.ID,
579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,
581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,
582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,
583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,
584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,

Line 582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,

578: l_okl_cnsld_ar_lines_tl_rec.ID,
579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,
581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,
582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,
583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,
584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;

Line 583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,

579: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,
581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,
582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,
583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,
584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
587: x_no_data_found := okl_cnsld_ar_lines_tl_pk_csr%NOTFOUND;

Line 584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,

580: l_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG,
581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,
582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,
583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,
584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
587: x_no_data_found := okl_cnsld_ar_lines_tl_pk_csr%NOTFOUND;
588: CLOSE okl_cnsld_ar_lines_tl_pk_csr;

Line 585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,

581: l_okl_cnsld_ar_lines_tl_rec.SFWT_FLAG,
582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,
583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,
584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
587: x_no_data_found := okl_cnsld_ar_lines_tl_pk_csr%NOTFOUND;
588: CLOSE okl_cnsld_ar_lines_tl_pk_csr;
589: RETURN(l_okl_cnsld_ar_lines_tl_rec);

Line 586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;

582: l_okl_cnsld_ar_lines_tl_rec.CREATED_BY,
583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,
584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
587: x_no_data_found := okl_cnsld_ar_lines_tl_pk_csr%NOTFOUND;
588: CLOSE okl_cnsld_ar_lines_tl_pk_csr;
589: RETURN(l_okl_cnsld_ar_lines_tl_rec);
590: END get_rec;

Line 587: x_no_data_found := okl_cnsld_ar_lines_tl_pk_csr%NOTFOUND;

583: l_okl_cnsld_ar_lines_tl_rec.CREATION_DATE,
584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
587: x_no_data_found := okl_cnsld_ar_lines_tl_pk_csr%NOTFOUND;
588: CLOSE okl_cnsld_ar_lines_tl_pk_csr;
589: RETURN(l_okl_cnsld_ar_lines_tl_rec);
590: END get_rec;
591:

Line 588: CLOSE okl_cnsld_ar_lines_tl_pk_csr;

584: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
587: x_no_data_found := okl_cnsld_ar_lines_tl_pk_csr%NOTFOUND;
588: CLOSE okl_cnsld_ar_lines_tl_pk_csr;
589: RETURN(l_okl_cnsld_ar_lines_tl_rec);
590: END get_rec;
591:
592: FUNCTION get_rec (

Line 589: RETURN(l_okl_cnsld_ar_lines_tl_rec);

585: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
586: l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
587: x_no_data_found := okl_cnsld_ar_lines_tl_pk_csr%NOTFOUND;
588: CLOSE okl_cnsld_ar_lines_tl_pk_csr;
589: RETURN(l_okl_cnsld_ar_lines_tl_rec);
590: END get_rec;
591:
592: FUNCTION get_rec (
593: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type

Line 593: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type

589: RETURN(l_okl_cnsld_ar_lines_tl_rec);
590: END get_rec;
591:
592: FUNCTION get_rec (
593: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type
594: ) RETURN okl_cnsld_ar_lines_tl_rec_type IS
595: l_row_notfound BOOLEAN := TRUE;
596: BEGIN
597: RETURN(get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound));

Line 594: ) RETURN okl_cnsld_ar_lines_tl_rec_type IS

590: END get_rec;
591:
592: FUNCTION get_rec (
593: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type
594: ) RETURN okl_cnsld_ar_lines_tl_rec_type IS
595: l_row_notfound BOOLEAN := TRUE;
596: BEGIN
597: RETURN(get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound));
598: END get_rec;

Line 597: RETURN(get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound));

593: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type
594: ) RETURN okl_cnsld_ar_lines_tl_rec_type IS
595: l_row_notfound BOOLEAN := TRUE;
596: BEGIN
597: RETURN(get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound));
598: END get_rec;
599: ---------------------------------------------------------------------------
600: -- FUNCTION get_rec for: OKL_CNSLD_AR_LINES_V
601: ---------------------------------------------------------------------------

Line 1083: p_to OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type

1079: p_to.last_update_login := p_from.last_update_login;
1080: END migrate;
1081: PROCEDURE migrate (
1082: p_from IN llnv_rec_type,
1083: p_to OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
1084: ) IS
1085: BEGIN
1086: p_to.id := p_from.id;
1087: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1095: p_from IN okl_cnsld_ar_lines_tl_rec_type,

1091: p_to.last_update_date := p_from.last_update_date;
1092: p_to.last_update_login := p_from.last_update_login;
1093: END migrate;
1094: PROCEDURE migrate (
1095: p_from IN okl_cnsld_ar_lines_tl_rec_type,
1096: p_to OUT NOCOPY llnv_rec_type
1097: ) IS
1098: BEGIN
1099: p_to.id := p_from.id;

Line 1127: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

1123: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1124: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1125: l_llnv_rec llnv_rec_type := p_llnv_rec;
1126: l_lln_rec lln_rec_type;
1127: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
1128: BEGIN
1129: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1130: G_PKG_NAME,
1131: p_init_msg_list,

Line 1436: -- insert_row for:OKL_CNSLD_AR_LINES_TL --

1432: '_PVT'
1433: );
1434: END insert_row;
1435: ------------------------------------------
1436: -- insert_row for:OKL_CNSLD_AR_LINES_TL --
1437: ------------------------------------------
1438: PROCEDURE insert_row(
1439: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1440: x_return_status OUT NOCOPY VARCHAR2,

Line 1443: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,

1439: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1440: x_return_status OUT NOCOPY VARCHAR2,
1441: x_msg_count OUT NOCOPY NUMBER,
1442: x_msg_data OUT NOCOPY VARCHAR2,
1443: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
1444: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS
1445:
1446: l_api_version CONSTANT NUMBER := 1;
1447: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1444: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS

1440: x_return_status OUT NOCOPY VARCHAR2,
1441: x_msg_count OUT NOCOPY NUMBER,
1442: x_msg_data OUT NOCOPY VARCHAR2,
1443: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
1444: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS
1445:
1446: l_api_version CONSTANT NUMBER := 1;
1447: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1448: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1449: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type := p_okl_cnsld_ar_lines_tl_rec;

1445:
1446: l_api_version CONSTANT NUMBER := 1;
1447: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1448: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1449: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type := p_okl_cnsld_ar_lines_tl_rec;
1450: ldefoklcnsldarlinestlrec okl_cnsld_ar_lines_tl_rec_type;
1451: CURSOR get_languages IS
1452: SELECT *
1453: FROM FND_LANGUAGES

Line 1450: ldefoklcnsldarlinestlrec okl_cnsld_ar_lines_tl_rec_type;

1446: l_api_version CONSTANT NUMBER := 1;
1447: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1448: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1449: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type := p_okl_cnsld_ar_lines_tl_rec;
1450: ldefoklcnsldarlinestlrec okl_cnsld_ar_lines_tl_rec_type;
1451: CURSOR get_languages IS
1452: SELECT *
1453: FROM FND_LANGUAGES
1454: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1456: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --

1452: SELECT *
1453: FROM FND_LANGUAGES
1454: WHERE INSTALLED_FLAG IN ('I', 'B');
1455: ----------------------------------------------
1456: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
1457: ----------------------------------------------
1458: FUNCTION Set_Attributes (
1459: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
1460: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type

Line 1459: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,

1455: ----------------------------------------------
1456: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
1457: ----------------------------------------------
1458: FUNCTION Set_Attributes (
1459: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
1460: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1463: BEGIN

Line 1460: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type

1456: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
1457: ----------------------------------------------
1458: FUNCTION Set_Attributes (
1459: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
1460: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;

Line 1464: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;

1460: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
1465: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');
1466: x_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
1467: RETURN(l_return_status);
1468: END Set_Attributes;

Line 1465: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');

1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
1465: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');
1466: x_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
1467: RETURN(l_return_status);
1468: END Set_Attributes;
1469: BEGIN

Line 1466: x_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG := USERENV('LANG');

1462: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
1465: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');
1466: x_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
1467: RETURN(l_return_status);
1468: END Set_Attributes;
1469: BEGIN
1470: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 1481: p_okl_cnsld_ar_lines_tl_rec, -- IN

1477: RAISE Okc_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479: --- Setting item attributes
1480: l_return_status := Set_Attributes(
1481: p_okl_cnsld_ar_lines_tl_rec, -- IN
1482: l_okl_cnsld_ar_lines_tl_rec); -- OUT
1483: --- If any errors happen abort API
1484: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1482: l_okl_cnsld_ar_lines_tl_rec); -- OUT

1478: END IF;
1479: --- Setting item attributes
1480: l_return_status := Set_Attributes(
1481: p_okl_cnsld_ar_lines_tl_rec, -- IN
1482: l_okl_cnsld_ar_lines_tl_rec); -- OUT
1483: --- If any errors happen abort API
1484: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 1490: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_lang_rec.language_code;

1486: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1487: RAISE Okc_Api.G_EXCEPTION_ERROR;
1488: END IF;
1489: FOR l_lang_rec IN get_languages LOOP
1490: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_lang_rec.language_code;
1491: INSERT INTO OKL_CNSLD_AR_LINES_TL(
1492: id,
1493: LANGUAGE,
1494: source_lang,

Line 1491: INSERT INTO OKL_CNSLD_AR_LINES_TL(

1487: RAISE Okc_Api.G_EXCEPTION_ERROR;
1488: END IF;
1489: FOR l_lang_rec IN get_languages LOOP
1490: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_lang_rec.language_code;
1491: INSERT INTO OKL_CNSLD_AR_LINES_TL(
1492: id,
1493: LANGUAGE,
1494: source_lang,
1495: sfwt_flag,

Line 1502: l_okl_cnsld_ar_lines_tl_rec.id,

1498: last_updated_by,
1499: last_update_date,
1500: last_update_login)
1501: VALUES (
1502: l_okl_cnsld_ar_lines_tl_rec.id,
1503: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
1504: l_okl_cnsld_ar_lines_tl_rec.source_lang,
1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
1506: l_okl_cnsld_ar_lines_tl_rec.created_by,

Line 1503: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,

1499: last_update_date,
1500: last_update_login)
1501: VALUES (
1502: l_okl_cnsld_ar_lines_tl_rec.id,
1503: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
1504: l_okl_cnsld_ar_lines_tl_rec.source_lang,
1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
1506: l_okl_cnsld_ar_lines_tl_rec.created_by,
1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,

Line 1504: l_okl_cnsld_ar_lines_tl_rec.source_lang,

1500: last_update_login)
1501: VALUES (
1502: l_okl_cnsld_ar_lines_tl_rec.id,
1503: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
1504: l_okl_cnsld_ar_lines_tl_rec.source_lang,
1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
1506: l_okl_cnsld_ar_lines_tl_rec.created_by,
1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,
1508: l_okl_cnsld_ar_lines_tl_rec.last_updated_by,

Line 1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,

1501: VALUES (
1502: l_okl_cnsld_ar_lines_tl_rec.id,
1503: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
1504: l_okl_cnsld_ar_lines_tl_rec.source_lang,
1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
1506: l_okl_cnsld_ar_lines_tl_rec.created_by,
1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,
1508: l_okl_cnsld_ar_lines_tl_rec.last_updated_by,
1509: l_okl_cnsld_ar_lines_tl_rec.last_update_date,

Line 1506: l_okl_cnsld_ar_lines_tl_rec.created_by,

1502: l_okl_cnsld_ar_lines_tl_rec.id,
1503: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
1504: l_okl_cnsld_ar_lines_tl_rec.source_lang,
1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
1506: l_okl_cnsld_ar_lines_tl_rec.created_by,
1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,
1508: l_okl_cnsld_ar_lines_tl_rec.last_updated_by,
1509: l_okl_cnsld_ar_lines_tl_rec.last_update_date,
1510: l_okl_cnsld_ar_lines_tl_rec.last_update_login);

Line 1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,

1503: l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
1504: l_okl_cnsld_ar_lines_tl_rec.source_lang,
1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
1506: l_okl_cnsld_ar_lines_tl_rec.created_by,
1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,
1508: l_okl_cnsld_ar_lines_tl_rec.last_updated_by,
1509: l_okl_cnsld_ar_lines_tl_rec.last_update_date,
1510: l_okl_cnsld_ar_lines_tl_rec.last_update_login);
1511: END LOOP;

Line 1508: l_okl_cnsld_ar_lines_tl_rec.last_updated_by,

1504: l_okl_cnsld_ar_lines_tl_rec.source_lang,
1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
1506: l_okl_cnsld_ar_lines_tl_rec.created_by,
1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,
1508: l_okl_cnsld_ar_lines_tl_rec.last_updated_by,
1509: l_okl_cnsld_ar_lines_tl_rec.last_update_date,
1510: l_okl_cnsld_ar_lines_tl_rec.last_update_login);
1511: END LOOP;
1512: -- Set OUT values

Line 1509: l_okl_cnsld_ar_lines_tl_rec.last_update_date,

1505: l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
1506: l_okl_cnsld_ar_lines_tl_rec.created_by,
1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,
1508: l_okl_cnsld_ar_lines_tl_rec.last_updated_by,
1509: l_okl_cnsld_ar_lines_tl_rec.last_update_date,
1510: l_okl_cnsld_ar_lines_tl_rec.last_update_login);
1511: END LOOP;
1512: -- Set OUT values
1513: x_okl_cnsld_ar_lines_tl_rec := l_okl_cnsld_ar_lines_tl_rec;

Line 1510: l_okl_cnsld_ar_lines_tl_rec.last_update_login);

1506: l_okl_cnsld_ar_lines_tl_rec.created_by,
1507: l_okl_cnsld_ar_lines_tl_rec.creation_date,
1508: l_okl_cnsld_ar_lines_tl_rec.last_updated_by,
1509: l_okl_cnsld_ar_lines_tl_rec.last_update_date,
1510: l_okl_cnsld_ar_lines_tl_rec.last_update_login);
1511: END LOOP;
1512: -- Set OUT values
1513: x_okl_cnsld_ar_lines_tl_rec := l_okl_cnsld_ar_lines_tl_rec;
1514: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1513: x_okl_cnsld_ar_lines_tl_rec := l_okl_cnsld_ar_lines_tl_rec;

1509: l_okl_cnsld_ar_lines_tl_rec.last_update_date,
1510: l_okl_cnsld_ar_lines_tl_rec.last_update_login);
1511: END LOOP;
1512: -- Set OUT values
1513: x_okl_cnsld_ar_lines_tl_rec := l_okl_cnsld_ar_lines_tl_rec;
1514: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1515: EXCEPTION
1516: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1517: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

Line 1566: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

1562: l_llnv_rec llnv_rec_type;
1563: l_def_llnv_rec llnv_rec_type;
1564: l_lln_rec lln_rec_type;
1565: lx_lln_rec lln_rec_type;
1566: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
1567: lx_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
1568: -------------------------------
1569: -- FUNCTION fill_who_columns --
1570: -------------------------------

Line 1567: lx_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

1563: l_def_llnv_rec llnv_rec_type;
1564: l_lln_rec lln_rec_type;
1565: lx_lln_rec lln_rec_type;
1566: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
1567: lx_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
1568: -------------------------------
1569: -- FUNCTION fill_who_columns --
1570: -------------------------------
1571: FUNCTION fill_who_columns (

Line 1658: migrate(l_def_llnv_rec, l_okl_cnsld_ar_lines_tl_rec);

1654: --------------------------------------
1655: -- Move VIEW record to "Child" records
1656: --------------------------------------
1657: migrate(l_def_llnv_rec, l_lln_rec);
1658: migrate(l_def_llnv_rec, l_okl_cnsld_ar_lines_tl_rec);
1659: --------------------------------------------
1660: -- Call the INSERT_ROW for each child record
1661: --------------------------------------------
1662: insert_row(

Line 1681: l_okl_cnsld_ar_lines_tl_rec,

1677: p_init_msg_list,
1678: x_return_status,
1679: x_msg_count,
1680: x_msg_data,
1681: l_okl_cnsld_ar_lines_tl_rec,
1682: lx_okl_cnsld_ar_lines_tl_rec
1683: );
1684: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1685: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1682: lx_okl_cnsld_ar_lines_tl_rec

1678: x_return_status,
1679: x_msg_count,
1680: x_msg_data,
1681: l_okl_cnsld_ar_lines_tl_rec,
1682: lx_okl_cnsld_ar_lines_tl_rec
1683: );
1684: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1685: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1686: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 1689: migrate(lx_okl_cnsld_ar_lines_tl_rec, l_def_llnv_rec);

1685: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1686: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1687: RAISE Okc_Api.G_EXCEPTION_ERROR;
1688: END IF;
1689: migrate(lx_okl_cnsld_ar_lines_tl_rec, l_def_llnv_rec);
1690: -- Set OUT values
1691: x_llnv_rec := l_def_llnv_rec;
1692: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1693: EXCEPTION

Line 1919: -- lock_row for:OKL_CNSLD_AR_LINES_TL --

1915: '_PVT'
1916: );
1917: END lock_row;
1918: ----------------------------------------
1919: -- lock_row for:OKL_CNSLD_AR_LINES_TL --
1920: ----------------------------------------
1921: PROCEDURE lock_row(
1922: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1923: x_return_status OUT NOCOPY VARCHAR2,

Line 1926: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS

1922: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1923: x_return_status OUT NOCOPY VARCHAR2,
1924: x_msg_count OUT NOCOPY NUMBER,
1925: x_msg_data OUT NOCOPY VARCHAR2,
1926: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS
1927:
1928: E_Resource_Busy EXCEPTION;
1929: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1930: CURSOR lock_csr (p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS

Line 1930: CURSOR lock_csr (p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS

1926: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS
1927:
1928: E_Resource_Busy EXCEPTION;
1929: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1930: CURSOR lock_csr (p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS
1931: SELECT *
1932: FROM OKL_CNSLD_AR_LINES_TL
1933: WHERE ID = p_okl_cnsld_ar_lines_tl_rec.id
1934: FOR UPDATE NOWAIT;

Line 1932: FROM OKL_CNSLD_AR_LINES_TL

1928: E_Resource_Busy EXCEPTION;
1929: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1930: CURSOR lock_csr (p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS
1931: SELECT *
1932: FROM OKL_CNSLD_AR_LINES_TL
1933: WHERE ID = p_okl_cnsld_ar_lines_tl_rec.id
1934: FOR UPDATE NOWAIT;
1935:
1936: l_api_version CONSTANT NUMBER := 1;

Line 1933: WHERE ID = p_okl_cnsld_ar_lines_tl_rec.id

1929: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1930: CURSOR lock_csr (p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS
1931: SELECT *
1932: FROM OKL_CNSLD_AR_LINES_TL
1933: WHERE ID = p_okl_cnsld_ar_lines_tl_rec.id
1934: FOR UPDATE NOWAIT;
1935:
1936: l_api_version CONSTANT NUMBER := 1;
1937: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1953: OPEN lock_csr(p_okl_cnsld_ar_lines_tl_rec);

1949: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1950: RAISE Okc_Api.G_EXCEPTION_ERROR;
1951: END IF;
1952: BEGIN
1953: OPEN lock_csr(p_okl_cnsld_ar_lines_tl_rec);
1954: FETCH lock_csr INTO l_lock_var;
1955: l_row_notfound := lock_csr%NOTFOUND;
1956: CLOSE lock_csr;
1957: EXCEPTION

Line 2018: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

2014: l_api_version CONSTANT NUMBER := 1;
2015: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2016: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2017: l_lln_rec lln_rec_type;
2018: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2019: BEGIN
2020: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2021: G_PKG_NAME,
2022: p_init_msg_list,

Line 2036: migrate(p_llnv_rec, l_okl_cnsld_ar_lines_tl_rec);

2032: --------------------------------------
2033: -- Move VIEW record to "Child" records
2034: --------------------------------------
2035: migrate(p_llnv_rec, l_lln_rec);
2036: migrate(p_llnv_rec, l_okl_cnsld_ar_lines_tl_rec);
2037: --------------------------------------------
2038: -- Call the LOCK_ROW for each child record
2039: --------------------------------------------
2040: lock_row(

Line 2057: l_okl_cnsld_ar_lines_tl_rec

2053: p_init_msg_list,
2054: x_return_status,
2055: x_msg_count,
2056: x_msg_data,
2057: l_okl_cnsld_ar_lines_tl_rec
2058: );
2059: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2060: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2061: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 2461: -- update_row for:OKL_CNSLD_AR_LINES_TL --

2457: '_PVT'
2458: );
2459: END update_row;
2460: ------------------------------------------
2461: -- update_row for:OKL_CNSLD_AR_LINES_TL --
2462: ------------------------------------------
2463: PROCEDURE update_row(
2464: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2465: x_return_status OUT NOCOPY VARCHAR2,

Line 2468: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,

2464: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2465: x_return_status OUT NOCOPY VARCHAR2,
2466: x_msg_count OUT NOCOPY NUMBER,
2467: x_msg_data OUT NOCOPY VARCHAR2,
2468: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
2469: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS
2470:
2471: l_api_version CONSTANT NUMBER := 1;
2472: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2469: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS

2465: x_return_status OUT NOCOPY VARCHAR2,
2466: x_msg_count OUT NOCOPY NUMBER,
2467: x_msg_data OUT NOCOPY VARCHAR2,
2468: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
2469: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS
2470:
2471: l_api_version CONSTANT NUMBER := 1;
2472: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2473: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2474: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type := p_okl_cnsld_ar_lines_tl_rec;

2470:
2471: l_api_version CONSTANT NUMBER := 1;
2472: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2473: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2474: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type := p_okl_cnsld_ar_lines_tl_rec;
2475: ldefoklcnsldarlinestlrec okl_cnsld_ar_lines_tl_rec_type;
2476: l_row_notfound BOOLEAN := TRUE;
2477: ----------------------------------
2478: -- FUNCTION populate_new_record --

Line 2475: ldefoklcnsldarlinestlrec okl_cnsld_ar_lines_tl_rec_type;

2471: l_api_version CONSTANT NUMBER := 1;
2472: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2473: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2474: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type := p_okl_cnsld_ar_lines_tl_rec;
2475: ldefoklcnsldarlinestlrec okl_cnsld_ar_lines_tl_rec_type;
2476: l_row_notfound BOOLEAN := TRUE;
2477: ----------------------------------
2478: -- FUNCTION populate_new_record --
2479: ----------------------------------

Line 2481: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,

2477: ----------------------------------
2478: -- FUNCTION populate_new_record --
2479: ----------------------------------
2480: FUNCTION populate_new_record (
2481: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
2482: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
2483: ) RETURN VARCHAR2 IS
2484: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2485: l_row_notfound BOOLEAN := TRUE;

Line 2482: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type

2478: -- FUNCTION populate_new_record --
2479: ----------------------------------
2480: FUNCTION populate_new_record (
2481: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
2482: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
2483: ) RETURN VARCHAR2 IS
2484: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2485: l_row_notfound BOOLEAN := TRUE;
2486: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2484: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

2480: FUNCTION populate_new_record (
2481: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
2482: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
2483: ) RETURN VARCHAR2 IS
2484: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2485: l_row_notfound BOOLEAN := TRUE;
2486: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2487: BEGIN
2488: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;

Line 2488: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;

2484: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2485: l_row_notfound BOOLEAN := TRUE;
2486: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2487: BEGIN
2488: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
2489: -- Get current database values
2490: l_okl_cnsld_ar_lines_tl_rec := get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound);
2491: IF (l_row_notfound) THEN
2492: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

Line 2490: l_okl_cnsld_ar_lines_tl_rec := get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound);

2486: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2487: BEGIN
2488: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
2489: -- Get current database values
2490: l_okl_cnsld_ar_lines_tl_rec := get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound);
2491: IF (l_row_notfound) THEN
2492: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2493: END IF;
2494: IF (x_okl_cnsld_ar_lines_tl_rec.id = Okc_Api.G_MISS_NUM)

Line 2494: IF (x_okl_cnsld_ar_lines_tl_rec.id = Okc_Api.G_MISS_NUM)

2490: l_okl_cnsld_ar_lines_tl_rec := get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound);
2491: IF (l_row_notfound) THEN
2492: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2493: END IF;
2494: IF (x_okl_cnsld_ar_lines_tl_rec.id = Okc_Api.G_MISS_NUM)
2495: THEN
2496: x_okl_cnsld_ar_lines_tl_rec.id := l_okl_cnsld_ar_lines_tl_rec.id;
2497: END IF;
2498: IF (x_okl_cnsld_ar_lines_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

Line 2496: x_okl_cnsld_ar_lines_tl_rec.id := l_okl_cnsld_ar_lines_tl_rec.id;

2492: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2493: END IF;
2494: IF (x_okl_cnsld_ar_lines_tl_rec.id = Okc_Api.G_MISS_NUM)
2495: THEN
2496: x_okl_cnsld_ar_lines_tl_rec.id := l_okl_cnsld_ar_lines_tl_rec.id;
2497: END IF;
2498: IF (x_okl_cnsld_ar_lines_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2499: THEN
2500: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_okl_cnsld_ar_lines_tl_rec.LANGUAGE;

Line 2498: IF (x_okl_cnsld_ar_lines_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

2494: IF (x_okl_cnsld_ar_lines_tl_rec.id = Okc_Api.G_MISS_NUM)
2495: THEN
2496: x_okl_cnsld_ar_lines_tl_rec.id := l_okl_cnsld_ar_lines_tl_rec.id;
2497: END IF;
2498: IF (x_okl_cnsld_ar_lines_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2499: THEN
2500: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_okl_cnsld_ar_lines_tl_rec.LANGUAGE;
2501: END IF;
2502: IF (x_okl_cnsld_ar_lines_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

Line 2500: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_okl_cnsld_ar_lines_tl_rec.LANGUAGE;

2496: x_okl_cnsld_ar_lines_tl_rec.id := l_okl_cnsld_ar_lines_tl_rec.id;
2497: END IF;
2498: IF (x_okl_cnsld_ar_lines_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2499: THEN
2500: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_okl_cnsld_ar_lines_tl_rec.LANGUAGE;
2501: END IF;
2502: IF (x_okl_cnsld_ar_lines_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2503: THEN
2504: x_okl_cnsld_ar_lines_tl_rec.source_lang := l_okl_cnsld_ar_lines_tl_rec.source_lang;

Line 2502: IF (x_okl_cnsld_ar_lines_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

2498: IF (x_okl_cnsld_ar_lines_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2499: THEN
2500: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_okl_cnsld_ar_lines_tl_rec.LANGUAGE;
2501: END IF;
2502: IF (x_okl_cnsld_ar_lines_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2503: THEN
2504: x_okl_cnsld_ar_lines_tl_rec.source_lang := l_okl_cnsld_ar_lines_tl_rec.source_lang;
2505: END IF;
2506: IF (x_okl_cnsld_ar_lines_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

Line 2504: x_okl_cnsld_ar_lines_tl_rec.source_lang := l_okl_cnsld_ar_lines_tl_rec.source_lang;

2500: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := l_okl_cnsld_ar_lines_tl_rec.LANGUAGE;
2501: END IF;
2502: IF (x_okl_cnsld_ar_lines_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2503: THEN
2504: x_okl_cnsld_ar_lines_tl_rec.source_lang := l_okl_cnsld_ar_lines_tl_rec.source_lang;
2505: END IF;
2506: IF (x_okl_cnsld_ar_lines_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2507: THEN
2508: x_okl_cnsld_ar_lines_tl_rec.sfwt_flag := l_okl_cnsld_ar_lines_tl_rec.sfwt_flag;

Line 2506: IF (x_okl_cnsld_ar_lines_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

2502: IF (x_okl_cnsld_ar_lines_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2503: THEN
2504: x_okl_cnsld_ar_lines_tl_rec.source_lang := l_okl_cnsld_ar_lines_tl_rec.source_lang;
2505: END IF;
2506: IF (x_okl_cnsld_ar_lines_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2507: THEN
2508: x_okl_cnsld_ar_lines_tl_rec.sfwt_flag := l_okl_cnsld_ar_lines_tl_rec.sfwt_flag;
2509: END IF;
2510: IF (x_okl_cnsld_ar_lines_tl_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2508: x_okl_cnsld_ar_lines_tl_rec.sfwt_flag := l_okl_cnsld_ar_lines_tl_rec.sfwt_flag;

2504: x_okl_cnsld_ar_lines_tl_rec.source_lang := l_okl_cnsld_ar_lines_tl_rec.source_lang;
2505: END IF;
2506: IF (x_okl_cnsld_ar_lines_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2507: THEN
2508: x_okl_cnsld_ar_lines_tl_rec.sfwt_flag := l_okl_cnsld_ar_lines_tl_rec.sfwt_flag;
2509: END IF;
2510: IF (x_okl_cnsld_ar_lines_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2511: THEN
2512: x_okl_cnsld_ar_lines_tl_rec.created_by := l_okl_cnsld_ar_lines_tl_rec.created_by;

Line 2510: IF (x_okl_cnsld_ar_lines_tl_rec.created_by = Okc_Api.G_MISS_NUM)

2506: IF (x_okl_cnsld_ar_lines_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2507: THEN
2508: x_okl_cnsld_ar_lines_tl_rec.sfwt_flag := l_okl_cnsld_ar_lines_tl_rec.sfwt_flag;
2509: END IF;
2510: IF (x_okl_cnsld_ar_lines_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2511: THEN
2512: x_okl_cnsld_ar_lines_tl_rec.created_by := l_okl_cnsld_ar_lines_tl_rec.created_by;
2513: END IF;
2514: IF (x_okl_cnsld_ar_lines_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2512: x_okl_cnsld_ar_lines_tl_rec.created_by := l_okl_cnsld_ar_lines_tl_rec.created_by;

2508: x_okl_cnsld_ar_lines_tl_rec.sfwt_flag := l_okl_cnsld_ar_lines_tl_rec.sfwt_flag;
2509: END IF;
2510: IF (x_okl_cnsld_ar_lines_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2511: THEN
2512: x_okl_cnsld_ar_lines_tl_rec.created_by := l_okl_cnsld_ar_lines_tl_rec.created_by;
2513: END IF;
2514: IF (x_okl_cnsld_ar_lines_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2515: THEN
2516: x_okl_cnsld_ar_lines_tl_rec.creation_date := l_okl_cnsld_ar_lines_tl_rec.creation_date;

Line 2514: IF (x_okl_cnsld_ar_lines_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

2510: IF (x_okl_cnsld_ar_lines_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2511: THEN
2512: x_okl_cnsld_ar_lines_tl_rec.created_by := l_okl_cnsld_ar_lines_tl_rec.created_by;
2513: END IF;
2514: IF (x_okl_cnsld_ar_lines_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2515: THEN
2516: x_okl_cnsld_ar_lines_tl_rec.creation_date := l_okl_cnsld_ar_lines_tl_rec.creation_date;
2517: END IF;
2518: IF (x_okl_cnsld_ar_lines_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2516: x_okl_cnsld_ar_lines_tl_rec.creation_date := l_okl_cnsld_ar_lines_tl_rec.creation_date;

2512: x_okl_cnsld_ar_lines_tl_rec.created_by := l_okl_cnsld_ar_lines_tl_rec.created_by;
2513: END IF;
2514: IF (x_okl_cnsld_ar_lines_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2515: THEN
2516: x_okl_cnsld_ar_lines_tl_rec.creation_date := l_okl_cnsld_ar_lines_tl_rec.creation_date;
2517: END IF;
2518: IF (x_okl_cnsld_ar_lines_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2519: THEN
2520: x_okl_cnsld_ar_lines_tl_rec.last_updated_by := l_okl_cnsld_ar_lines_tl_rec.last_updated_by;

Line 2518: IF (x_okl_cnsld_ar_lines_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2514: IF (x_okl_cnsld_ar_lines_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2515: THEN
2516: x_okl_cnsld_ar_lines_tl_rec.creation_date := l_okl_cnsld_ar_lines_tl_rec.creation_date;
2517: END IF;
2518: IF (x_okl_cnsld_ar_lines_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2519: THEN
2520: x_okl_cnsld_ar_lines_tl_rec.last_updated_by := l_okl_cnsld_ar_lines_tl_rec.last_updated_by;
2521: END IF;
2522: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2520: x_okl_cnsld_ar_lines_tl_rec.last_updated_by := l_okl_cnsld_ar_lines_tl_rec.last_updated_by;

2516: x_okl_cnsld_ar_lines_tl_rec.creation_date := l_okl_cnsld_ar_lines_tl_rec.creation_date;
2517: END IF;
2518: IF (x_okl_cnsld_ar_lines_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2519: THEN
2520: x_okl_cnsld_ar_lines_tl_rec.last_updated_by := l_okl_cnsld_ar_lines_tl_rec.last_updated_by;
2521: END IF;
2522: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2523: THEN
2524: x_okl_cnsld_ar_lines_tl_rec.last_update_date := l_okl_cnsld_ar_lines_tl_rec.last_update_date;

Line 2522: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

2518: IF (x_okl_cnsld_ar_lines_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2519: THEN
2520: x_okl_cnsld_ar_lines_tl_rec.last_updated_by := l_okl_cnsld_ar_lines_tl_rec.last_updated_by;
2521: END IF;
2522: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2523: THEN
2524: x_okl_cnsld_ar_lines_tl_rec.last_update_date := l_okl_cnsld_ar_lines_tl_rec.last_update_date;
2525: END IF;
2526: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2524: x_okl_cnsld_ar_lines_tl_rec.last_update_date := l_okl_cnsld_ar_lines_tl_rec.last_update_date;

2520: x_okl_cnsld_ar_lines_tl_rec.last_updated_by := l_okl_cnsld_ar_lines_tl_rec.last_updated_by;
2521: END IF;
2522: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2523: THEN
2524: x_okl_cnsld_ar_lines_tl_rec.last_update_date := l_okl_cnsld_ar_lines_tl_rec.last_update_date;
2525: END IF;
2526: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2527: THEN
2528: x_okl_cnsld_ar_lines_tl_rec.last_update_login := l_okl_cnsld_ar_lines_tl_rec.last_update_login;

Line 2526: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

2522: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2523: THEN
2524: x_okl_cnsld_ar_lines_tl_rec.last_update_date := l_okl_cnsld_ar_lines_tl_rec.last_update_date;
2525: END IF;
2526: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2527: THEN
2528: x_okl_cnsld_ar_lines_tl_rec.last_update_login := l_okl_cnsld_ar_lines_tl_rec.last_update_login;
2529: END IF;
2530: RETURN(l_return_status);

Line 2528: x_okl_cnsld_ar_lines_tl_rec.last_update_login := l_okl_cnsld_ar_lines_tl_rec.last_update_login;

2524: x_okl_cnsld_ar_lines_tl_rec.last_update_date := l_okl_cnsld_ar_lines_tl_rec.last_update_date;
2525: END IF;
2526: IF (x_okl_cnsld_ar_lines_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2527: THEN
2528: x_okl_cnsld_ar_lines_tl_rec.last_update_login := l_okl_cnsld_ar_lines_tl_rec.last_update_login;
2529: END IF;
2530: RETURN(l_return_status);
2531: END populate_new_record;
2532: ----------------------------------------------

Line 2533: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --

2529: END IF;
2530: RETURN(l_return_status);
2531: END populate_new_record;
2532: ----------------------------------------------
2533: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
2534: ----------------------------------------------
2535: FUNCTION Set_Attributes (
2536: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
2537: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type

Line 2536: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,

2532: ----------------------------------------------
2533: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
2534: ----------------------------------------------
2535: FUNCTION Set_Attributes (
2536: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
2537: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
2538: ) RETURN VARCHAR2 IS
2539: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2540: BEGIN

Line 2537: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type

2533: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
2534: ----------------------------------------------
2535: FUNCTION Set_Attributes (
2536: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
2537: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
2538: ) RETURN VARCHAR2 IS
2539: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2540: BEGIN
2541: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;

Line 2541: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;

2537: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
2538: ) RETURN VARCHAR2 IS
2539: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2540: BEGIN
2541: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
2542: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');
2543: x_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2544: RETURN(l_return_status);
2545: END Set_Attributes;

Line 2542: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');

2538: ) RETURN VARCHAR2 IS
2539: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2540: BEGIN
2541: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
2542: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');
2543: x_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2544: RETURN(l_return_status);
2545: END Set_Attributes;
2546: BEGIN

Line 2543: x_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG := USERENV('LANG');

2539: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2540: BEGIN
2541: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
2542: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');
2543: x_okl_cnsld_ar_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2544: RETURN(l_return_status);
2545: END Set_Attributes;
2546: BEGIN
2547: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2558: p_okl_cnsld_ar_lines_tl_rec, -- IN

2554: RAISE Okc_Api.G_EXCEPTION_ERROR;
2555: END IF;
2556: --- Setting item attributes
2557: l_return_status := Set_Attributes(
2558: p_okl_cnsld_ar_lines_tl_rec, -- IN
2559: l_okl_cnsld_ar_lines_tl_rec); -- OUT
2560: --- If any errors happen abort API
2561: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2559: l_okl_cnsld_ar_lines_tl_rec); -- OUT

2555: END IF;
2556: --- Setting item attributes
2557: l_return_status := Set_Attributes(
2558: p_okl_cnsld_ar_lines_tl_rec, -- IN
2559: l_okl_cnsld_ar_lines_tl_rec); -- OUT
2560: --- If any errors happen abort API
2561: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2563: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 2566: l_return_status := populate_new_record(l_okl_cnsld_ar_lines_tl_rec, ldefoklcnsldarlinestlrec);

2562: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2563: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2564: RAISE Okc_Api.G_EXCEPTION_ERROR;
2565: END IF;
2566: l_return_status := populate_new_record(l_okl_cnsld_ar_lines_tl_rec, ldefoklcnsldarlinestlrec);
2567: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2568: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2569: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2570: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 2572: UPDATE OKL_CNSLD_AR_LINES_TL

2568: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2569: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2570: RAISE Okc_Api.G_EXCEPTION_ERROR;
2571: END IF;
2572: UPDATE OKL_CNSLD_AR_LINES_TL
2573: SET CREATED_BY = ldefoklcnsldarlinestlrec.created_by,
2574: CREATION_DATE = ldefoklcnsldarlinestlrec.creation_date,
2575: LAST_UPDATED_BY = ldefoklcnsldarlinestlrec.last_updated_by,
2576: LAST_UPDATE_DATE = ldefoklcnsldarlinestlrec.last_update_date,

Line 2582: UPDATE OKL_CNSLD_AR_LINES_TL

2578: WHERE ID = ldefoklcnsldarlinestlrec.id
2579: --AND SOURCE_LANG = USERENV('LANG');
2580: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2581:
2582: UPDATE OKL_CNSLD_AR_LINES_TL
2583: SET SFWT_FLAG = 'Y'
2584: WHERE ID = ldefoklcnsldarlinestlrec.id
2585: AND SOURCE_LANG <> USERENV('LANG');
2586:

Line 2587: x_okl_cnsld_ar_lines_tl_rec := ldefoklcnsldarlinestlrec;

2583: SET SFWT_FLAG = 'Y'
2584: WHERE ID = ldefoklcnsldarlinestlrec.id
2585: AND SOURCE_LANG <> USERENV('LANG');
2586:
2587: x_okl_cnsld_ar_lines_tl_rec := ldefoklcnsldarlinestlrec;
2588: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2589: EXCEPTION
2590: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2591: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

Line 2638: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

2634: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2635: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2636: l_llnv_rec llnv_rec_type := p_llnv_rec;
2637: l_def_llnv_rec llnv_rec_type;
2638: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2639: lx_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2640: l_lln_rec lln_rec_type;
2641: lx_lln_rec lln_rec_type;
2642: -------------------------------

Line 2639: lx_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

2635: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2636: l_llnv_rec llnv_rec_type := p_llnv_rec;
2637: l_def_llnv_rec llnv_rec_type;
2638: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2639: lx_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
2640: l_lln_rec lln_rec_type;
2641: lx_lln_rec lln_rec_type;
2642: -------------------------------
2643: -- FUNCTION fill_who_columns --

Line 2909: migrate(l_def_llnv_rec, l_okl_cnsld_ar_lines_tl_rec);

2905:
2906: --------------------------------------
2907: -- Move VIEW record to "Child" records
2908: --------------------------------------
2909: migrate(l_def_llnv_rec, l_okl_cnsld_ar_lines_tl_rec);
2910: migrate(l_def_llnv_rec, l_lln_rec);
2911: --------------------------------------------
2912: -- Call the UPDATE_ROW for each child record
2913: --------------------------------------------

Line 2919: l_okl_cnsld_ar_lines_tl_rec,

2915: p_init_msg_list,
2916: x_return_status,
2917: x_msg_count,
2918: x_msg_data,
2919: l_okl_cnsld_ar_lines_tl_rec,
2920: lx_okl_cnsld_ar_lines_tl_rec
2921: );
2922: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2920: lx_okl_cnsld_ar_lines_tl_rec

2916: x_return_status,
2917: x_msg_count,
2918: x_msg_data,
2919: l_okl_cnsld_ar_lines_tl_rec,
2920: lx_okl_cnsld_ar_lines_tl_rec
2921: );
2922: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2924: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 2927: migrate(lx_okl_cnsld_ar_lines_tl_rec, l_def_llnv_rec);

2923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2924: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2925: RAISE Okc_Api.G_EXCEPTION_ERROR;
2926: END IF;
2927: migrate(lx_okl_cnsld_ar_lines_tl_rec, l_def_llnv_rec);
2928: update_row(
2929: p_init_msg_list,
2930: x_return_status,
2931: x_msg_count,

Line 3108: -- delete_row for:OKL_CNSLD_AR_LINES_TL --

3104: '_PVT'
3105: );
3106: END delete_row;
3107: ------------------------------------------
3108: -- delete_row for:OKL_CNSLD_AR_LINES_TL --
3109: ------------------------------------------
3110: PROCEDURE delete_row(
3111: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3112: x_return_status OUT NOCOPY VARCHAR2,

Line 3115: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS

3111: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3112: x_return_status OUT NOCOPY VARCHAR2,
3113: x_msg_count OUT NOCOPY NUMBER,
3114: x_msg_data OUT NOCOPY VARCHAR2,
3115: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS
3116:
3117: l_api_version CONSTANT NUMBER := 1;
3118: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3119: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 3120: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type:= p_okl_cnsld_ar_lines_tl_rec;

3116:
3117: l_api_version CONSTANT NUMBER := 1;
3118: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3119: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3120: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type:= p_okl_cnsld_ar_lines_tl_rec;
3121: l_row_notfound BOOLEAN := TRUE;
3122: ----------------------------------------------
3123: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
3124: ----------------------------------------------

Line 3123: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --

3119: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3120: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type:= p_okl_cnsld_ar_lines_tl_rec;
3121: l_row_notfound BOOLEAN := TRUE;
3122: ----------------------------------------------
3123: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
3124: ----------------------------------------------
3125: FUNCTION Set_Attributes (
3126: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
3127: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type

Line 3126: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,

3122: ----------------------------------------------
3123: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
3124: ----------------------------------------------
3125: FUNCTION Set_Attributes (
3126: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
3127: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
3128: ) RETURN VARCHAR2 IS
3129: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3130: BEGIN

Line 3127: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type

3123: -- Set_Attributes for:OKL_CNSLD_AR_LINES_TL --
3124: ----------------------------------------------
3125: FUNCTION Set_Attributes (
3126: p_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
3127: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
3128: ) RETURN VARCHAR2 IS
3129: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3130: BEGIN
3131: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;

Line 3131: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;

3127: x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type
3128: ) RETURN VARCHAR2 IS
3129: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3130: BEGIN
3131: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
3132: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');
3133: RETURN(l_return_status);
3134: END Set_Attributes;
3135: BEGIN

Line 3132: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');

3128: ) RETURN VARCHAR2 IS
3129: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3130: BEGIN
3131: x_okl_cnsld_ar_lines_tl_rec := p_okl_cnsld_ar_lines_tl_rec;
3132: x_okl_cnsld_ar_lines_tl_rec.LANGUAGE := USERENV('LANG');
3133: RETURN(l_return_status);
3134: END Set_Attributes;
3135: BEGIN
3136: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 3147: p_okl_cnsld_ar_lines_tl_rec, -- IN

3143: RAISE Okc_Api.G_EXCEPTION_ERROR;
3144: END IF;
3145: --- Setting item attributes
3146: l_return_status := Set_Attributes(
3147: p_okl_cnsld_ar_lines_tl_rec, -- IN
3148: l_okl_cnsld_ar_lines_tl_rec); -- OUT
3149: --- If any errors happen abort API
3150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3148: l_okl_cnsld_ar_lines_tl_rec); -- OUT

3144: END IF;
3145: --- Setting item attributes
3146: l_return_status := Set_Attributes(
3147: p_okl_cnsld_ar_lines_tl_rec, -- IN
3148: l_okl_cnsld_ar_lines_tl_rec); -- OUT
3149: --- If any errors happen abort API
3150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3152: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 3155: DELETE FROM OKL_CNSLD_AR_LINES_TL

3151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3152: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3153: RAISE Okc_Api.G_EXCEPTION_ERROR;
3154: END IF;
3155: DELETE FROM OKL_CNSLD_AR_LINES_TL
3156: WHERE ID = l_okl_cnsld_ar_lines_tl_rec.id;
3157:
3158: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3159: EXCEPTION

Line 3156: WHERE ID = l_okl_cnsld_ar_lines_tl_rec.id;

3152: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3153: RAISE Okc_Api.G_EXCEPTION_ERROR;
3154: END IF;
3155: DELETE FROM OKL_CNSLD_AR_LINES_TL
3156: WHERE ID = l_okl_cnsld_ar_lines_tl_rec.id;
3157:
3158: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3159: EXCEPTION
3160: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 3206: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;

3202: l_api_version CONSTANT NUMBER := 1;
3203: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3204: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3205: l_llnv_rec llnv_rec_type := p_llnv_rec;
3206: l_okl_cnsld_ar_lines_tl_rec okl_cnsld_ar_lines_tl_rec_type;
3207: l_lln_rec lln_rec_type;
3208: BEGIN
3209: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3210: G_PKG_NAME,

Line 3224: migrate(l_llnv_rec, l_okl_cnsld_ar_lines_tl_rec);

3220: END IF;
3221: --------------------------------------
3222: -- Move VIEW record to "Child" records
3223: --------------------------------------
3224: migrate(l_llnv_rec, l_okl_cnsld_ar_lines_tl_rec);
3225: migrate(l_llnv_rec, l_lln_rec);
3226: --------------------------------------------
3227: -- Call the DELETE_ROW for each child record
3228: --------------------------------------------

Line 3234: l_okl_cnsld_ar_lines_tl_rec

3230: p_init_msg_list,
3231: x_return_status,
3232: x_msg_count,
3233: x_msg_data,
3234: l_okl_cnsld_ar_lines_tl_rec
3235: );
3236: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3237: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3238: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN