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.OKC_SCN_PVT dependencies on OKC_SECTIONS_TL

Line 517: DELETE FROM OKC_SECTIONS_TL T

513: okc_debug.Set_Indentation('OKC_SCN_PVT');
514: okc_debug.log('2300: Entered add_language', 2);
515: END IF;
516:
517: DELETE FROM OKC_SECTIONS_TL T
518: WHERE NOT EXISTS (
519: SELECT NULL
520: FROM OKC_SECTIONS_B B
521: WHERE B.ID = T.ID

Line 524: UPDATE OKC_SECTIONS_TL T SET (

520: FROM OKC_SECTIONS_B B
521: WHERE B.ID = T.ID
522: );
523:
524: UPDATE OKC_SECTIONS_TL T SET (
525: HEADING) = (SELECT
526: B.HEADING
527: FROM OKC_SECTIONS_TL B
528: WHERE B.ID = T.ID

Line 527: FROM OKC_SECTIONS_TL B

523:
524: UPDATE OKC_SECTIONS_TL T SET (
525: HEADING) = (SELECT
526: B.HEADING
527: FROM OKC_SECTIONS_TL B
528: WHERE B.ID = T.ID
529: AND B.LANGUAGE = T.SOURCE_LANG)
530: WHERE (
531: T.ID,

Line 536: FROM OKC_SECTIONS_TL SUBB, OKC_SECTIONS_TL SUBT

532: T.LANGUAGE)
533: IN (SELECT
534: SUBT.ID,
535: SUBT.LANGUAGE
536: FROM OKC_SECTIONS_TL SUBB, OKC_SECTIONS_TL SUBT
537: WHERE SUBB.ID = SUBT.ID
538: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
539: AND (SUBB.HEADING <> SUBT.HEADING
540: OR (SUBB.HEADING IS NULL AND SUBT.HEADING IS NOT NULL)

Line 544: INSERT INTO OKC_SECTIONS_TL (

540: OR (SUBB.HEADING IS NULL AND SUBT.HEADING IS NOT NULL)
541: OR (SUBB.HEADING IS NOT NULL AND SUBT.HEADING IS NULL)
542: ));
543:
544: INSERT INTO OKC_SECTIONS_TL (
545: ID,
546: LANGUAGE,
547: SOURCE_LANG,
548: SFWT_FLAG,

Line 566: FROM OKC_SECTIONS_TL B, FND_LANGUAGES L

562: B.CREATION_DATE,
563: B.LAST_UPDATED_BY,
564: B.LAST_UPDATE_DATE,
565: B.LAST_UPDATE_LOGIN
566: FROM OKC_SECTIONS_TL B, FND_LANGUAGES L
567: WHERE L.INSTALLED_FLAG IN ('I', 'B')
568: AND B.LANGUAGE = USERENV('LANG')
569: AND NOT EXISTS(
570: SELECT NULL

Line 571: FROM OKC_SECTIONS_TL T

567: WHERE L.INSTALLED_FLAG IN ('I', 'B')
568: AND B.LANGUAGE = USERENV('LANG')
569: AND NOT EXISTS(
570: SELECT NULL
571: FROM OKC_SECTIONS_TL T
572: WHERE T.ID = B.ID
573: AND T.LANGUAGE = L.LANGUAGE_CODE
574: );
575: DELETE FROM OKC_SECTIONS_TLH T

Line 575: DELETE FROM OKC_SECTIONS_TLH T

571: FROM OKC_SECTIONS_TL T
572: WHERE T.ID = B.ID
573: AND T.LANGUAGE = L.LANGUAGE_CODE
574: );
575: DELETE FROM OKC_SECTIONS_TLH T
576: WHERE NOT EXISTS (
577: SELECT NULL
578: FROM OKC_SECTIONS_BH B
579: WHERE B.ID = T.ID

Line 583: UPDATE OKC_SECTIONS_TLH T SET (

579: WHERE B.ID = T.ID
580: AND B.MAJOR_VERSION = T.MAJOR_VERSION
581: );
582:
583: UPDATE OKC_SECTIONS_TLH T SET (
584: HEADING) = (SELECT
585: B.HEADING
586: FROM OKC_SECTIONS_TLH B
587: WHERE B.ID = T.ID

Line 586: FROM OKC_SECTIONS_TLH B

582:
583: UPDATE OKC_SECTIONS_TLH T SET (
584: HEADING) = (SELECT
585: B.HEADING
586: FROM OKC_SECTIONS_TLH B
587: WHERE B.ID = T.ID
588: AND B.MAJOR_VERSION = T.MAJOR_VERSION
589: AND B.LANGUAGE = T.SOURCE_LANG)
590: WHERE (

Line 598: FROM OKC_SECTIONS_TLH SUBB, OKC_SECTIONS_TLH SUBT

594: IN (SELECT
595: SUBT.ID,
596: SUBT.MAJOR_VERSION,
597: SUBT.LANGUAGE
598: FROM OKC_SECTIONS_TLH SUBB, OKC_SECTIONS_TLH SUBT
599: WHERE SUBB.ID = SUBT.ID
600: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
601: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
602: AND (SUBB.HEADING <> SUBT.HEADING

Line 607: INSERT INTO OKC_SECTIONS_TLH (

603: OR (SUBB.HEADING IS NULL AND SUBT.HEADING IS NOT NULL)
604: OR (SUBB.HEADING IS NOT NULL AND SUBT.HEADING IS NULL)
605: ));
606:
607: INSERT INTO OKC_SECTIONS_TLH (
608: ID,
609: LANGUAGE,
610: MAJOR_VERSION,
611: SOURCE_LANG,

Line 631: FROM OKC_SECTIONS_TLH B, FND_LANGUAGES L

627: B.CREATION_DATE,
628: B.LAST_UPDATED_BY,
629: B.LAST_UPDATE_DATE,
630: B.LAST_UPDATE_LOGIN
631: FROM OKC_SECTIONS_TLH B, FND_LANGUAGES L
632: WHERE L.INSTALLED_FLAG IN ('I', 'B')
633: AND B.LANGUAGE = USERENV('LANG')
634: AND NOT EXISTS(
635: SELECT NULL

Line 636: FROM OKC_SECTIONS_TLH T

632: WHERE L.INSTALLED_FLAG IN ('I', 'B')
633: AND B.LANGUAGE = USERENV('LANG')
634: AND NOT EXISTS(
635: SELECT NULL
636: FROM OKC_SECTIONS_TLH T
637: WHERE T.ID = B.ID
638: AND T.MAJOR_VERSION = B.MAJOR_VERSION
639: AND T.LANGUAGE = L.LANGUAGE_CODE
640: );

Line 754: -- FUNCTION get_rec for: OKC_SECTIONS_TL

750: RETURN(get_rec(p_scn_rec, l_row_notfound));
751:
752: END get_rec;
753: ---------------------------------------------------------------------------
754: -- FUNCTION get_rec for: OKC_SECTIONS_TL
755: ---------------------------------------------------------------------------
756: FUNCTION get_rec (
757: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
758: x_no_data_found OUT NOCOPY BOOLEAN

Line 757: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,

753: ---------------------------------------------------------------------------
754: -- FUNCTION get_rec for: OKC_SECTIONS_TL
755: ---------------------------------------------------------------------------
756: FUNCTION get_rec (
757: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
758: x_no_data_found OUT NOCOPY BOOLEAN
759: ) RETURN okc_sections_tl_rec_type IS
760: CURSOR okc_sections_tl_pk_csr (p_id IN NUMBER,
761: p_language IN VARCHAR2) IS

Line 759: ) RETURN okc_sections_tl_rec_type IS

755: ---------------------------------------------------------------------------
756: FUNCTION get_rec (
757: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
758: x_no_data_found OUT NOCOPY BOOLEAN
759: ) RETURN okc_sections_tl_rec_type IS
760: CURSOR okc_sections_tl_pk_csr (p_id IN NUMBER,
761: p_language IN VARCHAR2) IS
762: SELECT
763: ID,

Line 760: CURSOR okc_sections_tl_pk_csr (p_id IN NUMBER,

756: FUNCTION get_rec (
757: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
758: x_no_data_found OUT NOCOPY BOOLEAN
759: ) RETURN okc_sections_tl_rec_type IS
760: CURSOR okc_sections_tl_pk_csr (p_id IN NUMBER,
761: p_language IN VARCHAR2) IS
762: SELECT
763: ID,
764: LANGUAGE,

Line 773: FROM Okc_Sections_Tl

769: CREATION_DATE,
770: LAST_UPDATED_BY,
771: LAST_UPDATE_DATE,
772: LAST_UPDATE_LOGIN
773: FROM Okc_Sections_Tl
774: WHERE okc_sections_tl.id = p_id
775: AND okc_sections_tl.language = p_language;
776: l_okc_sections_tl_pk okc_sections_tl_pk_csr%ROWTYPE;
777: l_okc_sections_tl_rec okc_sections_tl_rec_type;

Line 774: WHERE okc_sections_tl.id = p_id

770: LAST_UPDATED_BY,
771: LAST_UPDATE_DATE,
772: LAST_UPDATE_LOGIN
773: FROM Okc_Sections_Tl
774: WHERE okc_sections_tl.id = p_id
775: AND okc_sections_tl.language = p_language;
776: l_okc_sections_tl_pk okc_sections_tl_pk_csr%ROWTYPE;
777: l_okc_sections_tl_rec okc_sections_tl_rec_type;
778: BEGIN

Line 775: AND okc_sections_tl.language = p_language;

771: LAST_UPDATE_DATE,
772: LAST_UPDATE_LOGIN
773: FROM Okc_Sections_Tl
774: WHERE okc_sections_tl.id = p_id
775: AND okc_sections_tl.language = p_language;
776: l_okc_sections_tl_pk okc_sections_tl_pk_csr%ROWTYPE;
777: l_okc_sections_tl_rec okc_sections_tl_rec_type;
778: BEGIN
779:

Line 776: l_okc_sections_tl_pk okc_sections_tl_pk_csr%ROWTYPE;

772: LAST_UPDATE_LOGIN
773: FROM Okc_Sections_Tl
774: WHERE okc_sections_tl.id = p_id
775: AND okc_sections_tl.language = p_language;
776: l_okc_sections_tl_pk okc_sections_tl_pk_csr%ROWTYPE;
777: l_okc_sections_tl_rec okc_sections_tl_rec_type;
778: BEGIN
779:
780: IF (l_debug = 'Y') THEN

Line 777: l_okc_sections_tl_rec okc_sections_tl_rec_type;

773: FROM Okc_Sections_Tl
774: WHERE okc_sections_tl.id = p_id
775: AND okc_sections_tl.language = p_language;
776: l_okc_sections_tl_pk okc_sections_tl_pk_csr%ROWTYPE;
777: l_okc_sections_tl_rec okc_sections_tl_rec_type;
778: BEGIN
779:
780: IF (l_debug = 'Y') THEN
781: okc_debug.Set_Indentation('OKC_SCN_PVT');

Line 787: OPEN okc_sections_tl_pk_csr (p_okc_sections_tl_rec.id,

783: END IF;
784:
785: x_no_data_found := TRUE;
786: -- Get current database values
787: OPEN okc_sections_tl_pk_csr (p_okc_sections_tl_rec.id,
788: p_okc_sections_tl_rec.language);
789: FETCH okc_sections_tl_pk_csr INTO
790: l_okc_sections_tl_rec.ID,
791: l_okc_sections_tl_rec.LANGUAGE,

Line 788: p_okc_sections_tl_rec.language);

784:
785: x_no_data_found := TRUE;
786: -- Get current database values
787: OPEN okc_sections_tl_pk_csr (p_okc_sections_tl_rec.id,
788: p_okc_sections_tl_rec.language);
789: FETCH okc_sections_tl_pk_csr INTO
790: l_okc_sections_tl_rec.ID,
791: l_okc_sections_tl_rec.LANGUAGE,
792: l_okc_sections_tl_rec.SOURCE_LANG,

Line 789: FETCH okc_sections_tl_pk_csr INTO

785: x_no_data_found := TRUE;
786: -- Get current database values
787: OPEN okc_sections_tl_pk_csr (p_okc_sections_tl_rec.id,
788: p_okc_sections_tl_rec.language);
789: FETCH okc_sections_tl_pk_csr INTO
790: l_okc_sections_tl_rec.ID,
791: l_okc_sections_tl_rec.LANGUAGE,
792: l_okc_sections_tl_rec.SOURCE_LANG,
793: l_okc_sections_tl_rec.SFWT_FLAG,

Line 790: l_okc_sections_tl_rec.ID,

786: -- Get current database values
787: OPEN okc_sections_tl_pk_csr (p_okc_sections_tl_rec.id,
788: p_okc_sections_tl_rec.language);
789: FETCH okc_sections_tl_pk_csr INTO
790: l_okc_sections_tl_rec.ID,
791: l_okc_sections_tl_rec.LANGUAGE,
792: l_okc_sections_tl_rec.SOURCE_LANG,
793: l_okc_sections_tl_rec.SFWT_FLAG,
794: l_okc_sections_tl_rec.HEADING,

Line 791: l_okc_sections_tl_rec.LANGUAGE,

787: OPEN okc_sections_tl_pk_csr (p_okc_sections_tl_rec.id,
788: p_okc_sections_tl_rec.language);
789: FETCH okc_sections_tl_pk_csr INTO
790: l_okc_sections_tl_rec.ID,
791: l_okc_sections_tl_rec.LANGUAGE,
792: l_okc_sections_tl_rec.SOURCE_LANG,
793: l_okc_sections_tl_rec.SFWT_FLAG,
794: l_okc_sections_tl_rec.HEADING,
795: l_okc_sections_tl_rec.CREATED_BY,

Line 792: l_okc_sections_tl_rec.SOURCE_LANG,

788: p_okc_sections_tl_rec.language);
789: FETCH okc_sections_tl_pk_csr INTO
790: l_okc_sections_tl_rec.ID,
791: l_okc_sections_tl_rec.LANGUAGE,
792: l_okc_sections_tl_rec.SOURCE_LANG,
793: l_okc_sections_tl_rec.SFWT_FLAG,
794: l_okc_sections_tl_rec.HEADING,
795: l_okc_sections_tl_rec.CREATED_BY,
796: l_okc_sections_tl_rec.CREATION_DATE,

Line 793: l_okc_sections_tl_rec.SFWT_FLAG,

789: FETCH okc_sections_tl_pk_csr INTO
790: l_okc_sections_tl_rec.ID,
791: l_okc_sections_tl_rec.LANGUAGE,
792: l_okc_sections_tl_rec.SOURCE_LANG,
793: l_okc_sections_tl_rec.SFWT_FLAG,
794: l_okc_sections_tl_rec.HEADING,
795: l_okc_sections_tl_rec.CREATED_BY,
796: l_okc_sections_tl_rec.CREATION_DATE,
797: l_okc_sections_tl_rec.LAST_UPDATED_BY,

Line 794: l_okc_sections_tl_rec.HEADING,

790: l_okc_sections_tl_rec.ID,
791: l_okc_sections_tl_rec.LANGUAGE,
792: l_okc_sections_tl_rec.SOURCE_LANG,
793: l_okc_sections_tl_rec.SFWT_FLAG,
794: l_okc_sections_tl_rec.HEADING,
795: l_okc_sections_tl_rec.CREATED_BY,
796: l_okc_sections_tl_rec.CREATION_DATE,
797: l_okc_sections_tl_rec.LAST_UPDATED_BY,
798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,

Line 795: l_okc_sections_tl_rec.CREATED_BY,

791: l_okc_sections_tl_rec.LANGUAGE,
792: l_okc_sections_tl_rec.SOURCE_LANG,
793: l_okc_sections_tl_rec.SFWT_FLAG,
794: l_okc_sections_tl_rec.HEADING,
795: l_okc_sections_tl_rec.CREATED_BY,
796: l_okc_sections_tl_rec.CREATION_DATE,
797: l_okc_sections_tl_rec.LAST_UPDATED_BY,
798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,
799: l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;

Line 796: l_okc_sections_tl_rec.CREATION_DATE,

792: l_okc_sections_tl_rec.SOURCE_LANG,
793: l_okc_sections_tl_rec.SFWT_FLAG,
794: l_okc_sections_tl_rec.HEADING,
795: l_okc_sections_tl_rec.CREATED_BY,
796: l_okc_sections_tl_rec.CREATION_DATE,
797: l_okc_sections_tl_rec.LAST_UPDATED_BY,
798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,
799: l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;
800: x_no_data_found := okc_sections_tl_pk_csr%NOTFOUND;

Line 797: l_okc_sections_tl_rec.LAST_UPDATED_BY,

793: l_okc_sections_tl_rec.SFWT_FLAG,
794: l_okc_sections_tl_rec.HEADING,
795: l_okc_sections_tl_rec.CREATED_BY,
796: l_okc_sections_tl_rec.CREATION_DATE,
797: l_okc_sections_tl_rec.LAST_UPDATED_BY,
798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,
799: l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;
800: x_no_data_found := okc_sections_tl_pk_csr%NOTFOUND;
801: CLOSE okc_sections_tl_pk_csr;

Line 798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,

794: l_okc_sections_tl_rec.HEADING,
795: l_okc_sections_tl_rec.CREATED_BY,
796: l_okc_sections_tl_rec.CREATION_DATE,
797: l_okc_sections_tl_rec.LAST_UPDATED_BY,
798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,
799: l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;
800: x_no_data_found := okc_sections_tl_pk_csr%NOTFOUND;
801: CLOSE okc_sections_tl_pk_csr;
802: IF (l_debug = 'Y') THEN

Line 799: l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;

795: l_okc_sections_tl_rec.CREATED_BY,
796: l_okc_sections_tl_rec.CREATION_DATE,
797: l_okc_sections_tl_rec.LAST_UPDATED_BY,
798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,
799: l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;
800: x_no_data_found := okc_sections_tl_pk_csr%NOTFOUND;
801: CLOSE okc_sections_tl_pk_csr;
802: IF (l_debug = 'Y') THEN
803: okc_debug.log('900: Leaving Fn Get_Rec ', 2);

Line 800: x_no_data_found := okc_sections_tl_pk_csr%NOTFOUND;

796: l_okc_sections_tl_rec.CREATION_DATE,
797: l_okc_sections_tl_rec.LAST_UPDATED_BY,
798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,
799: l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;
800: x_no_data_found := okc_sections_tl_pk_csr%NOTFOUND;
801: CLOSE okc_sections_tl_pk_csr;
802: IF (l_debug = 'Y') THEN
803: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
804: okc_debug.Reset_Indentation;

Line 801: CLOSE okc_sections_tl_pk_csr;

797: l_okc_sections_tl_rec.LAST_UPDATED_BY,
798: l_okc_sections_tl_rec.LAST_UPDATE_DATE,
799: l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;
800: x_no_data_found := okc_sections_tl_pk_csr%NOTFOUND;
801: CLOSE okc_sections_tl_pk_csr;
802: IF (l_debug = 'Y') THEN
803: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
804: okc_debug.Reset_Indentation;
805: END IF;

Line 807: RETURN(l_okc_sections_tl_rec);

803: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
804: okc_debug.Reset_Indentation;
805: END IF;
806:
807: RETURN(l_okc_sections_tl_rec);
808:
809: END get_rec;
810:
811: FUNCTION get_rec (

Line 812: p_okc_sections_tl_rec IN okc_sections_tl_rec_type

808:
809: END get_rec;
810:
811: FUNCTION get_rec (
812: p_okc_sections_tl_rec IN okc_sections_tl_rec_type
813: ) RETURN okc_sections_tl_rec_type IS
814: l_row_notfound BOOLEAN := TRUE;
815: BEGIN
816:

Line 813: ) RETURN okc_sections_tl_rec_type IS

809: END get_rec;
810:
811: FUNCTION get_rec (
812: p_okc_sections_tl_rec IN okc_sections_tl_rec_type
813: ) RETURN okc_sections_tl_rec_type IS
814: l_row_notfound BOOLEAN := TRUE;
815: BEGIN
816:
817: RETURN(get_rec(p_okc_sections_tl_rec, l_row_notfound));

Line 817: RETURN(get_rec(p_okc_sections_tl_rec, l_row_notfound));

813: ) RETURN okc_sections_tl_rec_type IS
814: l_row_notfound BOOLEAN := TRUE;
815: BEGIN
816:
817: RETURN(get_rec(p_okc_sections_tl_rec, l_row_notfound));
818:
819: END get_rec;
820: ---------------------------------------------------------------------------
821: -- FUNCTION get_rec for: OKC_SECTIONS_V

Line 1359: p_to IN OUT NOCOPY okc_sections_tl_rec_type

1355:
1356:
1357: PROCEDURE migrate (
1358: p_from IN scnv_rec_type,
1359: p_to IN OUT NOCOPY okc_sections_tl_rec_type
1360: ) IS
1361: BEGIN
1362:
1363: p_to.id := p_from.id;

Line 1376: p_from IN okc_sections_tl_rec_type,

1372: END migrate;
1373:
1374:
1375: PROCEDURE migrate (
1376: p_from IN okc_sections_tl_rec_type,
1377: p_to IN OUT NOCOPY scnv_rec_type
1378: ) IS
1379: BEGIN
1380:

Line 1411: l_okc_sections_tl_rec okc_sections_tl_rec_type;

1407: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1408: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1409: l_scnv_rec scnv_rec_type := p_scnv_rec;
1410: l_scn_rec scn_rec_type;
1411: l_okc_sections_tl_rec okc_sections_tl_rec_type;
1412: BEGIN
1413:
1414: IF (l_debug = 'Y') THEN
1415: okc_debug.Set_Indentation('OKC_SCN_PVT');

Line 1776: -- insert_row for:OKC_SECTIONS_TL --

1772: );
1773:
1774: END insert_row;
1775: ------------------------------------
1776: -- insert_row for:OKC_SECTIONS_TL --
1777: ------------------------------------
1778: PROCEDURE insert_row(
1779: p_init_msg_list IN VARCHAR2,
1780: x_return_status OUT NOCOPY VARCHAR2,

Line 1783: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,

1779: p_init_msg_list IN VARCHAR2,
1780: x_return_status OUT NOCOPY VARCHAR2,
1781: x_msg_count OUT NOCOPY NUMBER,
1782: x_msg_data OUT NOCOPY VARCHAR2,
1783: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
1784: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type) IS
1785:
1786: l_api_version CONSTANT NUMBER := 1;
1787: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1784: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type) IS

1780: x_return_status OUT NOCOPY VARCHAR2,
1781: x_msg_count OUT NOCOPY NUMBER,
1782: x_msg_data OUT NOCOPY VARCHAR2,
1783: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
1784: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type) IS
1785:
1786: l_api_version CONSTANT NUMBER := 1;
1787: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1788: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1789: l_okc_sections_tl_rec okc_sections_tl_rec_type := p_okc_sections_tl_rec;

1785:
1786: l_api_version CONSTANT NUMBER := 1;
1787: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1788: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1789: l_okc_sections_tl_rec okc_sections_tl_rec_type := p_okc_sections_tl_rec;
1790: l_def_okc_sections_tl_rec okc_sections_tl_rec_type;
1791: CURSOR get_languages IS
1792: SELECT *
1793: FROM FND_LANGUAGES

Line 1790: l_def_okc_sections_tl_rec okc_sections_tl_rec_type;

1786: l_api_version CONSTANT NUMBER := 1;
1787: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1788: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1789: l_okc_sections_tl_rec okc_sections_tl_rec_type := p_okc_sections_tl_rec;
1790: l_def_okc_sections_tl_rec okc_sections_tl_rec_type;
1791: CURSOR get_languages IS
1792: SELECT *
1793: FROM FND_LANGUAGES
1794: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1796: -- Set_Attributes for:OKC_SECTIONS_TL --

1792: SELECT *
1793: FROM FND_LANGUAGES
1794: WHERE INSTALLED_FLAG IN ('I', 'B');
1795: ----------------------------------------
1796: -- Set_Attributes for:OKC_SECTIONS_TL --
1797: ----------------------------------------
1798: FUNCTION Set_Attributes (
1799: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
1800: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type

Line 1799: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,

1795: ----------------------------------------
1796: -- Set_Attributes for:OKC_SECTIONS_TL --
1797: ----------------------------------------
1798: FUNCTION Set_Attributes (
1799: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
1800: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
1801: ) RETURN VARCHAR2 IS
1802: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1803: BEGIN

Line 1800: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type

1796: -- Set_Attributes for:OKC_SECTIONS_TL --
1797: ----------------------------------------
1798: FUNCTION Set_Attributes (
1799: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
1800: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
1801: ) RETURN VARCHAR2 IS
1802: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1803: BEGIN
1804:

Line 1805: x_okc_sections_tl_rec := p_okc_sections_tl_rec;

1801: ) RETURN VARCHAR2 IS
1802: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1803: BEGIN
1804:
1805: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
1806: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1807: x_okc_sections_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1808: RETURN(l_return_status);
1809:

Line 1806: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1802: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1803: BEGIN
1804:
1805: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
1806: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1807: x_okc_sections_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1808: RETURN(l_return_status);
1809:
1810: END Set_Attributes;

Line 1807: x_okc_sections_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1803: BEGIN
1804:
1805: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
1806: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1807: x_okc_sections_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1808: RETURN(l_return_status);
1809:
1810: END Set_Attributes;
1811: BEGIN

Line 1829: p_okc_sections_tl_rec, -- IN

1825: RAISE OKC_API.G_EXCEPTION_ERROR;
1826: END IF;
1827: --- Setting item attributes
1828: l_return_status := Set_Attributes(
1829: p_okc_sections_tl_rec, -- IN
1830: l_okc_sections_tl_rec); -- OUT
1831: --- If any errors happen abort API
1832: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1833: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1830: l_okc_sections_tl_rec); -- OUT

1826: END IF;
1827: --- Setting item attributes
1828: l_return_status := Set_Attributes(
1829: p_okc_sections_tl_rec, -- IN
1830: l_okc_sections_tl_rec); -- OUT
1831: --- If any errors happen abort API
1832: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1833: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1834: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1838: l_okc_sections_tl_rec.language := l_lang_rec.language_code;

1834: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1835: RAISE OKC_API.G_EXCEPTION_ERROR;
1836: END IF;
1837: FOR l_lang_rec IN get_languages LOOP
1838: l_okc_sections_tl_rec.language := l_lang_rec.language_code;
1839: INSERT INTO OKC_SECTIONS_TL(
1840: id,
1841: language,
1842: source_lang,

Line 1839: INSERT INTO OKC_SECTIONS_TL(

1835: RAISE OKC_API.G_EXCEPTION_ERROR;
1836: END IF;
1837: FOR l_lang_rec IN get_languages LOOP
1838: l_okc_sections_tl_rec.language := l_lang_rec.language_code;
1839: INSERT INTO OKC_SECTIONS_TL(
1840: id,
1841: language,
1842: source_lang,
1843: sfwt_flag,

Line 1851: l_okc_sections_tl_rec.id,

1847: last_updated_by,
1848: last_update_date,
1849: last_update_login)
1850: VALUES (
1851: l_okc_sections_tl_rec.id,
1852: l_okc_sections_tl_rec.language,
1853: l_okc_sections_tl_rec.source_lang,
1854: l_okc_sections_tl_rec.sfwt_flag,
1855: l_okc_sections_tl_rec.heading,

Line 1852: l_okc_sections_tl_rec.language,

1848: last_update_date,
1849: last_update_login)
1850: VALUES (
1851: l_okc_sections_tl_rec.id,
1852: l_okc_sections_tl_rec.language,
1853: l_okc_sections_tl_rec.source_lang,
1854: l_okc_sections_tl_rec.sfwt_flag,
1855: l_okc_sections_tl_rec.heading,
1856: l_okc_sections_tl_rec.created_by,

Line 1853: l_okc_sections_tl_rec.source_lang,

1849: last_update_login)
1850: VALUES (
1851: l_okc_sections_tl_rec.id,
1852: l_okc_sections_tl_rec.language,
1853: l_okc_sections_tl_rec.source_lang,
1854: l_okc_sections_tl_rec.sfwt_flag,
1855: l_okc_sections_tl_rec.heading,
1856: l_okc_sections_tl_rec.created_by,
1857: l_okc_sections_tl_rec.creation_date,

Line 1854: l_okc_sections_tl_rec.sfwt_flag,

1850: VALUES (
1851: l_okc_sections_tl_rec.id,
1852: l_okc_sections_tl_rec.language,
1853: l_okc_sections_tl_rec.source_lang,
1854: l_okc_sections_tl_rec.sfwt_flag,
1855: l_okc_sections_tl_rec.heading,
1856: l_okc_sections_tl_rec.created_by,
1857: l_okc_sections_tl_rec.creation_date,
1858: l_okc_sections_tl_rec.last_updated_by,

Line 1855: l_okc_sections_tl_rec.heading,

1851: l_okc_sections_tl_rec.id,
1852: l_okc_sections_tl_rec.language,
1853: l_okc_sections_tl_rec.source_lang,
1854: l_okc_sections_tl_rec.sfwt_flag,
1855: l_okc_sections_tl_rec.heading,
1856: l_okc_sections_tl_rec.created_by,
1857: l_okc_sections_tl_rec.creation_date,
1858: l_okc_sections_tl_rec.last_updated_by,
1859: l_okc_sections_tl_rec.last_update_date,

Line 1856: l_okc_sections_tl_rec.created_by,

1852: l_okc_sections_tl_rec.language,
1853: l_okc_sections_tl_rec.source_lang,
1854: l_okc_sections_tl_rec.sfwt_flag,
1855: l_okc_sections_tl_rec.heading,
1856: l_okc_sections_tl_rec.created_by,
1857: l_okc_sections_tl_rec.creation_date,
1858: l_okc_sections_tl_rec.last_updated_by,
1859: l_okc_sections_tl_rec.last_update_date,
1860: l_okc_sections_tl_rec.last_update_login);

Line 1857: l_okc_sections_tl_rec.creation_date,

1853: l_okc_sections_tl_rec.source_lang,
1854: l_okc_sections_tl_rec.sfwt_flag,
1855: l_okc_sections_tl_rec.heading,
1856: l_okc_sections_tl_rec.created_by,
1857: l_okc_sections_tl_rec.creation_date,
1858: l_okc_sections_tl_rec.last_updated_by,
1859: l_okc_sections_tl_rec.last_update_date,
1860: l_okc_sections_tl_rec.last_update_login);
1861: END LOOP;

Line 1858: l_okc_sections_tl_rec.last_updated_by,

1854: l_okc_sections_tl_rec.sfwt_flag,
1855: l_okc_sections_tl_rec.heading,
1856: l_okc_sections_tl_rec.created_by,
1857: l_okc_sections_tl_rec.creation_date,
1858: l_okc_sections_tl_rec.last_updated_by,
1859: l_okc_sections_tl_rec.last_update_date,
1860: l_okc_sections_tl_rec.last_update_login);
1861: END LOOP;
1862: -- Set OUT values

Line 1859: l_okc_sections_tl_rec.last_update_date,

1855: l_okc_sections_tl_rec.heading,
1856: l_okc_sections_tl_rec.created_by,
1857: l_okc_sections_tl_rec.creation_date,
1858: l_okc_sections_tl_rec.last_updated_by,
1859: l_okc_sections_tl_rec.last_update_date,
1860: l_okc_sections_tl_rec.last_update_login);
1861: END LOOP;
1862: -- Set OUT values
1863: x_okc_sections_tl_rec := l_okc_sections_tl_rec;

Line 1860: l_okc_sections_tl_rec.last_update_login);

1856: l_okc_sections_tl_rec.created_by,
1857: l_okc_sections_tl_rec.creation_date,
1858: l_okc_sections_tl_rec.last_updated_by,
1859: l_okc_sections_tl_rec.last_update_date,
1860: l_okc_sections_tl_rec.last_update_login);
1861: END LOOP;
1862: -- Set OUT values
1863: x_okc_sections_tl_rec := l_okc_sections_tl_rec;
1864: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1863: x_okc_sections_tl_rec := l_okc_sections_tl_rec;

1859: l_okc_sections_tl_rec.last_update_date,
1860: l_okc_sections_tl_rec.last_update_login);
1861: END LOOP;
1862: -- Set OUT values
1863: x_okc_sections_tl_rec := l_okc_sections_tl_rec;
1864: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1865:
1866: IF (l_debug = 'Y') THEN
1867: okc_debug.log('5900: Leaving insert_row', 2);

Line 1941: l_okc_sections_tl_rec okc_sections_tl_rec_type;

1937: l_scnv_rec scnv_rec_type;
1938: l_def_scnv_rec scnv_rec_type;
1939: l_scn_rec scn_rec_type;
1940: lx_scn_rec scn_rec_type;
1941: l_okc_sections_tl_rec okc_sections_tl_rec_type;
1942: lx_okc_sections_tl_rec okc_sections_tl_rec_type;
1943: -------------------------------
1944: -- FUNCTION fill_who_columns --
1945: -------------------------------

Line 1942: lx_okc_sections_tl_rec okc_sections_tl_rec_type;

1938: l_def_scnv_rec scnv_rec_type;
1939: l_scn_rec scn_rec_type;
1940: lx_scn_rec scn_rec_type;
1941: l_okc_sections_tl_rec okc_sections_tl_rec_type;
1942: lx_okc_sections_tl_rec okc_sections_tl_rec_type;
1943: -------------------------------
1944: -- FUNCTION fill_who_columns --
1945: -------------------------------
1946: FUNCTION fill_who_columns (

Line 2037: migrate(l_def_scnv_rec, l_okc_sections_tl_rec);

2033: --------------------------------------
2034: -- Move VIEW record to "Child" records
2035: --------------------------------------
2036: migrate(l_def_scnv_rec, l_scn_rec);
2037: migrate(l_def_scnv_rec, l_okc_sections_tl_rec);
2038: --------------------------------------------
2039: -- Call the INSERT_ROW for each child record
2040: --------------------------------------------
2041: insert_row(

Line 2060: l_okc_sections_tl_rec,

2056: p_init_msg_list,
2057: x_return_status,
2058: x_msg_count,
2059: x_msg_data,
2060: l_okc_sections_tl_rec,
2061: lx_okc_sections_tl_rec
2062: );
2063: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2064: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2061: lx_okc_sections_tl_rec

2057: x_return_status,
2058: x_msg_count,
2059: x_msg_data,
2060: l_okc_sections_tl_rec,
2061: lx_okc_sections_tl_rec
2062: );
2063: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2064: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2065: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2068: migrate(lx_okc_sections_tl_rec, l_def_scnv_rec);

2064: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2065: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2066: RAISE OKC_API.G_EXCEPTION_ERROR;
2067: END IF;
2068: migrate(lx_okc_sections_tl_rec, l_def_scnv_rec);
2069: -- Set OUT values
2070: x_scnv_rec := l_def_scnv_rec;
2071: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2072:

Line 2379: -- lock_row for:OKC_SECTIONS_TL --

2375: );
2376:
2377: END lock_row;
2378: ----------------------------------
2379: -- lock_row for:OKC_SECTIONS_TL --
2380: ----------------------------------
2381: PROCEDURE lock_row(
2382: p_init_msg_list IN VARCHAR2,
2383: x_return_status OUT NOCOPY VARCHAR2,

Line 2386: p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS

2382: p_init_msg_list IN VARCHAR2,
2383: x_return_status OUT NOCOPY VARCHAR2,
2384: x_msg_count OUT NOCOPY NUMBER,
2385: x_msg_data OUT NOCOPY VARCHAR2,
2386: p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS
2387:
2388: E_Resource_Busy EXCEPTION;
2389: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2390: CURSOR lock_csr (p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS

Line 2390: CURSOR lock_csr (p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS

2386: p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS
2387:
2388: E_Resource_Busy EXCEPTION;
2389: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2390: CURSOR lock_csr (p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS
2391: SELECT *
2392: FROM OKC_SECTIONS_TL
2393: WHERE ID = p_okc_sections_tl_rec.id
2394: FOR UPDATE NOWAIT;

Line 2392: FROM OKC_SECTIONS_TL

2388: E_Resource_Busy EXCEPTION;
2389: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2390: CURSOR lock_csr (p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS
2391: SELECT *
2392: FROM OKC_SECTIONS_TL
2393: WHERE ID = p_okc_sections_tl_rec.id
2394: FOR UPDATE NOWAIT;
2395:
2396: l_api_version CONSTANT NUMBER := 1;

Line 2393: WHERE ID = p_okc_sections_tl_rec.id

2389: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2390: CURSOR lock_csr (p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS
2391: SELECT *
2392: FROM OKC_SECTIONS_TL
2393: WHERE ID = p_okc_sections_tl_rec.id
2394: FOR UPDATE NOWAIT;
2395:
2396: l_api_version CONSTANT NUMBER := 1;
2397: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2423: OPEN lock_csr(p_okc_sections_tl_rec);

2419:
2420: -- okc_debug.Set_Indentation('OKC_SCN_PVT');
2421: -- okc_debug.log('8400: Entered lock_row', 2);
2422:
2423: OPEN lock_csr(p_okc_sections_tl_rec);
2424: FETCH lock_csr INTO l_lock_var;
2425: l_row_notfound := lock_csr%NOTFOUND;
2426: CLOSE lock_csr;
2427:

Line 2520: l_okc_sections_tl_rec okc_sections_tl_rec_type;

2516: l_api_version CONSTANT NUMBER := 1;
2517: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2518: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2519: l_scn_rec scn_rec_type;
2520: l_okc_sections_tl_rec okc_sections_tl_rec_type;
2521: BEGIN
2522:
2523: IF (l_debug = 'Y') THEN
2524: okc_debug.Set_Indentation('OKC_SCN_PVT');

Line 2544: migrate(p_scnv_rec, l_okc_sections_tl_rec);

2540: --------------------------------------
2541: -- Move VIEW record to "Child" records
2542: --------------------------------------
2543: migrate(p_scnv_rec, l_scn_rec);
2544: migrate(p_scnv_rec, l_okc_sections_tl_rec);
2545: --------------------------------------------
2546: -- Call the LOCK_ROW for each child record
2547: --------------------------------------------
2548: lock_row(

Line 2565: l_okc_sections_tl_rec

2561: p_init_msg_list,
2562: x_return_status,
2563: x_msg_count,
2564: x_msg_data,
2565: l_okc_sections_tl_rec
2566: );
2567: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2568: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2569: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3029: -- update_row for:OKC_SECTIONS_TL --

3025: );
3026:
3027: END update_row;
3028: ------------------------------------
3029: -- update_row for:OKC_SECTIONS_TL --
3030: ------------------------------------
3031: PROCEDURE update_row(
3032: p_init_msg_list IN VARCHAR2,
3033: x_return_status OUT NOCOPY VARCHAR2,

Line 3036: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,

3032: p_init_msg_list IN VARCHAR2,
3033: x_return_status OUT NOCOPY VARCHAR2,
3034: x_msg_count OUT NOCOPY NUMBER,
3035: x_msg_data OUT NOCOPY VARCHAR2,
3036: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3037: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type) IS
3038:
3039: l_api_version CONSTANT NUMBER := 1;
3040: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3037: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type) IS

3033: x_return_status OUT NOCOPY VARCHAR2,
3034: x_msg_count OUT NOCOPY NUMBER,
3035: x_msg_data OUT NOCOPY VARCHAR2,
3036: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3037: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type) IS
3038:
3039: l_api_version CONSTANT NUMBER := 1;
3040: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3041: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3042: l_okc_sections_tl_rec okc_sections_tl_rec_type := p_okc_sections_tl_rec;

3038:
3039: l_api_version CONSTANT NUMBER := 1;
3040: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3041: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3042: l_okc_sections_tl_rec okc_sections_tl_rec_type := p_okc_sections_tl_rec;
3043: l_def_okc_sections_tl_rec okc_sections_tl_rec_type;
3044: l_row_notfound BOOLEAN := TRUE;
3045: ----------------------------------
3046: -- FUNCTION populate_new_record --

Line 3043: l_def_okc_sections_tl_rec okc_sections_tl_rec_type;

3039: l_api_version CONSTANT NUMBER := 1;
3040: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3041: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3042: l_okc_sections_tl_rec okc_sections_tl_rec_type := p_okc_sections_tl_rec;
3043: l_def_okc_sections_tl_rec okc_sections_tl_rec_type;
3044: l_row_notfound BOOLEAN := TRUE;
3045: ----------------------------------
3046: -- FUNCTION populate_new_record --
3047: ----------------------------------

Line 3049: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,

3045: ----------------------------------
3046: -- FUNCTION populate_new_record --
3047: ----------------------------------
3048: FUNCTION populate_new_record (
3049: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3050: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
3051: ) RETURN VARCHAR2 IS
3052: l_okc_sections_tl_rec okc_sections_tl_rec_type;
3053: l_row_notfound BOOLEAN := TRUE;

Line 3050: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type

3046: -- FUNCTION populate_new_record --
3047: ----------------------------------
3048: FUNCTION populate_new_record (
3049: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3050: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
3051: ) RETURN VARCHAR2 IS
3052: l_okc_sections_tl_rec okc_sections_tl_rec_type;
3053: l_row_notfound BOOLEAN := TRUE;
3054: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3052: l_okc_sections_tl_rec okc_sections_tl_rec_type;

3048: FUNCTION populate_new_record (
3049: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3050: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
3051: ) RETURN VARCHAR2 IS
3052: l_okc_sections_tl_rec okc_sections_tl_rec_type;
3053: l_row_notfound BOOLEAN := TRUE;
3054: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3055: BEGIN
3056:

Line 3062: x_okc_sections_tl_rec := p_okc_sections_tl_rec;

3058: okc_debug.Set_Indentation('OKC_SCN_PVT');
3059: okc_debug.log('10800: Entered populate_new_record', 2);
3060: END IF;
3061:
3062: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
3063: -- Get current database values
3064: l_okc_sections_tl_rec := get_rec(p_okc_sections_tl_rec, l_row_notfound);
3065: IF (l_row_notfound) THEN
3066: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 3064: l_okc_sections_tl_rec := get_rec(p_okc_sections_tl_rec, l_row_notfound);

3060: END IF;
3061:
3062: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
3063: -- Get current database values
3064: l_okc_sections_tl_rec := get_rec(p_okc_sections_tl_rec, l_row_notfound);
3065: IF (l_row_notfound) THEN
3066: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3067: END IF;
3068: IF (x_okc_sections_tl_rec.id = OKC_API.G_MISS_NUM)

Line 3068: IF (x_okc_sections_tl_rec.id = OKC_API.G_MISS_NUM)

3064: l_okc_sections_tl_rec := get_rec(p_okc_sections_tl_rec, l_row_notfound);
3065: IF (l_row_notfound) THEN
3066: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3067: END IF;
3068: IF (x_okc_sections_tl_rec.id = OKC_API.G_MISS_NUM)
3069: THEN
3070: x_okc_sections_tl_rec.id := l_okc_sections_tl_rec.id;
3071: END IF;
3072: IF (x_okc_sections_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 3070: x_okc_sections_tl_rec.id := l_okc_sections_tl_rec.id;

3066: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3067: END IF;
3068: IF (x_okc_sections_tl_rec.id = OKC_API.G_MISS_NUM)
3069: THEN
3070: x_okc_sections_tl_rec.id := l_okc_sections_tl_rec.id;
3071: END IF;
3072: IF (x_okc_sections_tl_rec.language = OKC_API.G_MISS_CHAR)
3073: THEN
3074: x_okc_sections_tl_rec.language := l_okc_sections_tl_rec.language;

Line 3072: IF (x_okc_sections_tl_rec.language = OKC_API.G_MISS_CHAR)

3068: IF (x_okc_sections_tl_rec.id = OKC_API.G_MISS_NUM)
3069: THEN
3070: x_okc_sections_tl_rec.id := l_okc_sections_tl_rec.id;
3071: END IF;
3072: IF (x_okc_sections_tl_rec.language = OKC_API.G_MISS_CHAR)
3073: THEN
3074: x_okc_sections_tl_rec.language := l_okc_sections_tl_rec.language;
3075: END IF;
3076: IF (x_okc_sections_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 3074: x_okc_sections_tl_rec.language := l_okc_sections_tl_rec.language;

3070: x_okc_sections_tl_rec.id := l_okc_sections_tl_rec.id;
3071: END IF;
3072: IF (x_okc_sections_tl_rec.language = OKC_API.G_MISS_CHAR)
3073: THEN
3074: x_okc_sections_tl_rec.language := l_okc_sections_tl_rec.language;
3075: END IF;
3076: IF (x_okc_sections_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3077: THEN
3078: x_okc_sections_tl_rec.source_lang := l_okc_sections_tl_rec.source_lang;

Line 3076: IF (x_okc_sections_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

3072: IF (x_okc_sections_tl_rec.language = OKC_API.G_MISS_CHAR)
3073: THEN
3074: x_okc_sections_tl_rec.language := l_okc_sections_tl_rec.language;
3075: END IF;
3076: IF (x_okc_sections_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3077: THEN
3078: x_okc_sections_tl_rec.source_lang := l_okc_sections_tl_rec.source_lang;
3079: END IF;
3080: IF (x_okc_sections_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 3078: x_okc_sections_tl_rec.source_lang := l_okc_sections_tl_rec.source_lang;

3074: x_okc_sections_tl_rec.language := l_okc_sections_tl_rec.language;
3075: END IF;
3076: IF (x_okc_sections_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3077: THEN
3078: x_okc_sections_tl_rec.source_lang := l_okc_sections_tl_rec.source_lang;
3079: END IF;
3080: IF (x_okc_sections_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3081: THEN
3082: x_okc_sections_tl_rec.sfwt_flag := l_okc_sections_tl_rec.sfwt_flag;

Line 3080: IF (x_okc_sections_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

3076: IF (x_okc_sections_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3077: THEN
3078: x_okc_sections_tl_rec.source_lang := l_okc_sections_tl_rec.source_lang;
3079: END IF;
3080: IF (x_okc_sections_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3081: THEN
3082: x_okc_sections_tl_rec.sfwt_flag := l_okc_sections_tl_rec.sfwt_flag;
3083: END IF;
3084: IF (x_okc_sections_tl_rec.heading = OKC_API.G_MISS_CHAR)

Line 3082: x_okc_sections_tl_rec.sfwt_flag := l_okc_sections_tl_rec.sfwt_flag;

3078: x_okc_sections_tl_rec.source_lang := l_okc_sections_tl_rec.source_lang;
3079: END IF;
3080: IF (x_okc_sections_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3081: THEN
3082: x_okc_sections_tl_rec.sfwt_flag := l_okc_sections_tl_rec.sfwt_flag;
3083: END IF;
3084: IF (x_okc_sections_tl_rec.heading = OKC_API.G_MISS_CHAR)
3085: THEN
3086: x_okc_sections_tl_rec.heading := l_okc_sections_tl_rec.heading;

Line 3084: IF (x_okc_sections_tl_rec.heading = OKC_API.G_MISS_CHAR)

3080: IF (x_okc_sections_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3081: THEN
3082: x_okc_sections_tl_rec.sfwt_flag := l_okc_sections_tl_rec.sfwt_flag;
3083: END IF;
3084: IF (x_okc_sections_tl_rec.heading = OKC_API.G_MISS_CHAR)
3085: THEN
3086: x_okc_sections_tl_rec.heading := l_okc_sections_tl_rec.heading;
3087: END IF;
3088: IF (x_okc_sections_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 3086: x_okc_sections_tl_rec.heading := l_okc_sections_tl_rec.heading;

3082: x_okc_sections_tl_rec.sfwt_flag := l_okc_sections_tl_rec.sfwt_flag;
3083: END IF;
3084: IF (x_okc_sections_tl_rec.heading = OKC_API.G_MISS_CHAR)
3085: THEN
3086: x_okc_sections_tl_rec.heading := l_okc_sections_tl_rec.heading;
3087: END IF;
3088: IF (x_okc_sections_tl_rec.created_by = OKC_API.G_MISS_NUM)
3089: THEN
3090: x_okc_sections_tl_rec.created_by := l_okc_sections_tl_rec.created_by;

Line 3088: IF (x_okc_sections_tl_rec.created_by = OKC_API.G_MISS_NUM)

3084: IF (x_okc_sections_tl_rec.heading = OKC_API.G_MISS_CHAR)
3085: THEN
3086: x_okc_sections_tl_rec.heading := l_okc_sections_tl_rec.heading;
3087: END IF;
3088: IF (x_okc_sections_tl_rec.created_by = OKC_API.G_MISS_NUM)
3089: THEN
3090: x_okc_sections_tl_rec.created_by := l_okc_sections_tl_rec.created_by;
3091: END IF;
3092: IF (x_okc_sections_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 3090: x_okc_sections_tl_rec.created_by := l_okc_sections_tl_rec.created_by;

3086: x_okc_sections_tl_rec.heading := l_okc_sections_tl_rec.heading;
3087: END IF;
3088: IF (x_okc_sections_tl_rec.created_by = OKC_API.G_MISS_NUM)
3089: THEN
3090: x_okc_sections_tl_rec.created_by := l_okc_sections_tl_rec.created_by;
3091: END IF;
3092: IF (x_okc_sections_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3093: THEN
3094: x_okc_sections_tl_rec.creation_date := l_okc_sections_tl_rec.creation_date;

Line 3092: IF (x_okc_sections_tl_rec.creation_date = OKC_API.G_MISS_DATE)

3088: IF (x_okc_sections_tl_rec.created_by = OKC_API.G_MISS_NUM)
3089: THEN
3090: x_okc_sections_tl_rec.created_by := l_okc_sections_tl_rec.created_by;
3091: END IF;
3092: IF (x_okc_sections_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3093: THEN
3094: x_okc_sections_tl_rec.creation_date := l_okc_sections_tl_rec.creation_date;
3095: END IF;
3096: IF (x_okc_sections_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 3094: x_okc_sections_tl_rec.creation_date := l_okc_sections_tl_rec.creation_date;

3090: x_okc_sections_tl_rec.created_by := l_okc_sections_tl_rec.created_by;
3091: END IF;
3092: IF (x_okc_sections_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3093: THEN
3094: x_okc_sections_tl_rec.creation_date := l_okc_sections_tl_rec.creation_date;
3095: END IF;
3096: IF (x_okc_sections_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3097: THEN
3098: x_okc_sections_tl_rec.last_updated_by := l_okc_sections_tl_rec.last_updated_by;

Line 3096: IF (x_okc_sections_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

3092: IF (x_okc_sections_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3093: THEN
3094: x_okc_sections_tl_rec.creation_date := l_okc_sections_tl_rec.creation_date;
3095: END IF;
3096: IF (x_okc_sections_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3097: THEN
3098: x_okc_sections_tl_rec.last_updated_by := l_okc_sections_tl_rec.last_updated_by;
3099: END IF;
3100: IF (x_okc_sections_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 3098: x_okc_sections_tl_rec.last_updated_by := l_okc_sections_tl_rec.last_updated_by;

3094: x_okc_sections_tl_rec.creation_date := l_okc_sections_tl_rec.creation_date;
3095: END IF;
3096: IF (x_okc_sections_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3097: THEN
3098: x_okc_sections_tl_rec.last_updated_by := l_okc_sections_tl_rec.last_updated_by;
3099: END IF;
3100: IF (x_okc_sections_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3101: THEN
3102: x_okc_sections_tl_rec.last_update_date := l_okc_sections_tl_rec.last_update_date;

Line 3100: IF (x_okc_sections_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

3096: IF (x_okc_sections_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3097: THEN
3098: x_okc_sections_tl_rec.last_updated_by := l_okc_sections_tl_rec.last_updated_by;
3099: END IF;
3100: IF (x_okc_sections_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3101: THEN
3102: x_okc_sections_tl_rec.last_update_date := l_okc_sections_tl_rec.last_update_date;
3103: END IF;
3104: IF (x_okc_sections_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 3102: x_okc_sections_tl_rec.last_update_date := l_okc_sections_tl_rec.last_update_date;

3098: x_okc_sections_tl_rec.last_updated_by := l_okc_sections_tl_rec.last_updated_by;
3099: END IF;
3100: IF (x_okc_sections_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3101: THEN
3102: x_okc_sections_tl_rec.last_update_date := l_okc_sections_tl_rec.last_update_date;
3103: END IF;
3104: IF (x_okc_sections_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3105: THEN
3106: x_okc_sections_tl_rec.last_update_login := l_okc_sections_tl_rec.last_update_login;

Line 3104: IF (x_okc_sections_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

3100: IF (x_okc_sections_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3101: THEN
3102: x_okc_sections_tl_rec.last_update_date := l_okc_sections_tl_rec.last_update_date;
3103: END IF;
3104: IF (x_okc_sections_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3105: THEN
3106: x_okc_sections_tl_rec.last_update_login := l_okc_sections_tl_rec.last_update_login;
3107: END IF;
3108:

Line 3106: x_okc_sections_tl_rec.last_update_login := l_okc_sections_tl_rec.last_update_login;

3102: x_okc_sections_tl_rec.last_update_date := l_okc_sections_tl_rec.last_update_date;
3103: END IF;
3104: IF (x_okc_sections_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3105: THEN
3106: x_okc_sections_tl_rec.last_update_login := l_okc_sections_tl_rec.last_update_login;
3107: END IF;
3108:
3109: IF (l_debug = 'Y') THEN
3110: okc_debug.log('11950: Leaving populate_new_record ', 2);

Line 3117: -- Set_Attributes for:OKC_SECTIONS_TL --

3113:
3114: RETURN(l_return_status);
3115: END populate_new_record;
3116: ----------------------------------------
3117: -- Set_Attributes for:OKC_SECTIONS_TL --
3118: ----------------------------------------
3119: FUNCTION Set_Attributes (
3120: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3121: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type

Line 3120: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,

3116: ----------------------------------------
3117: -- Set_Attributes for:OKC_SECTIONS_TL --
3118: ----------------------------------------
3119: FUNCTION Set_Attributes (
3120: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3121: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
3122: ) RETURN VARCHAR2 IS
3123: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3124: BEGIN

Line 3121: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type

3117: -- Set_Attributes for:OKC_SECTIONS_TL --
3118: ----------------------------------------
3119: FUNCTION Set_Attributes (
3120: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3121: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
3122: ) RETURN VARCHAR2 IS
3123: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3124: BEGIN
3125:

Line 3126: x_okc_sections_tl_rec := p_okc_sections_tl_rec;

3122: ) RETURN VARCHAR2 IS
3123: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3124: BEGIN
3125:
3126: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
3127: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3128: x_okc_sections_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
3129: RETURN(l_return_status);
3130:

Line 3127: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

3123: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3124: BEGIN
3125:
3126: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
3127: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3128: x_okc_sections_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
3129: RETURN(l_return_status);
3130:
3131: END Set_Attributes;

Line 3128: x_okc_sections_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

3124: BEGIN
3125:
3126: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
3127: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3128: x_okc_sections_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
3129: RETURN(l_return_status);
3130:
3131: END Set_Attributes;
3132: BEGIN

Line 3150: p_okc_sections_tl_rec, -- IN

3146: RAISE OKC_API.G_EXCEPTION_ERROR;
3147: END IF;
3148: --- Setting item attributes
3149: l_return_status := Set_Attributes(
3150: p_okc_sections_tl_rec, -- IN
3151: l_okc_sections_tl_rec); -- OUT
3152: --- If any errors happen abort API
3153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3151: l_okc_sections_tl_rec); -- OUT

3147: END IF;
3148: --- Setting item attributes
3149: l_return_status := Set_Attributes(
3150: p_okc_sections_tl_rec, -- IN
3151: l_okc_sections_tl_rec); -- OUT
3152: --- If any errors happen abort API
3153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3158: l_return_status := populate_new_record(l_okc_sections_tl_rec, l_def_okc_sections_tl_rec);

3154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3156: RAISE OKC_API.G_EXCEPTION_ERROR;
3157: END IF;
3158: l_return_status := populate_new_record(l_okc_sections_tl_rec, l_def_okc_sections_tl_rec);
3159: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3160: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3161: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3162: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3164: UPDATE OKC_SECTIONS_TL

3160: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3161: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3162: RAISE OKC_API.G_EXCEPTION_ERROR;
3163: END IF;
3164: UPDATE OKC_SECTIONS_TL
3165: SET HEADING = l_def_okc_sections_tl_rec.heading,
3166: CREATED_BY = l_def_okc_sections_tl_rec.created_by,
3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,

Line 3165: SET HEADING = l_def_okc_sections_tl_rec.heading,

3161: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3162: RAISE OKC_API.G_EXCEPTION_ERROR;
3163: END IF;
3164: UPDATE OKC_SECTIONS_TL
3165: SET HEADING = l_def_okc_sections_tl_rec.heading,
3166: CREATED_BY = l_def_okc_sections_tl_rec.created_by,
3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,
3169: LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,

Line 3166: CREATED_BY = l_def_okc_sections_tl_rec.created_by,

3162: RAISE OKC_API.G_EXCEPTION_ERROR;
3163: END IF;
3164: UPDATE OKC_SECTIONS_TL
3165: SET HEADING = l_def_okc_sections_tl_rec.heading,
3166: CREATED_BY = l_def_okc_sections_tl_rec.created_by,
3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,
3169: LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,
3170: LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login

Line 3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,

3163: END IF;
3164: UPDATE OKC_SECTIONS_TL
3165: SET HEADING = l_def_okc_sections_tl_rec.heading,
3166: CREATED_BY = l_def_okc_sections_tl_rec.created_by,
3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,
3169: LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,
3170: LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login
3171: WHERE ID = l_def_okc_sections_tl_rec.id

Line 3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,

3164: UPDATE OKC_SECTIONS_TL
3165: SET HEADING = l_def_okc_sections_tl_rec.heading,
3166: CREATED_BY = l_def_okc_sections_tl_rec.created_by,
3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,
3169: LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,
3170: LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login
3171: WHERE ID = l_def_okc_sections_tl_rec.id
3172: AND SOURCE_LANG = USERENV('LANG');

Line 3169: LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,

3165: SET HEADING = l_def_okc_sections_tl_rec.heading,
3166: CREATED_BY = l_def_okc_sections_tl_rec.created_by,
3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,
3169: LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,
3170: LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login
3171: WHERE ID = l_def_okc_sections_tl_rec.id
3172: AND SOURCE_LANG = USERENV('LANG');
3173:

Line 3170: LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login

3166: CREATED_BY = l_def_okc_sections_tl_rec.created_by,
3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,
3169: LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,
3170: LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login
3171: WHERE ID = l_def_okc_sections_tl_rec.id
3172: AND SOURCE_LANG = USERENV('LANG');
3173:
3174: UPDATE OKC_SECTIONS_TL

Line 3171: WHERE ID = l_def_okc_sections_tl_rec.id

3167: CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
3168: LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,
3169: LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,
3170: LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login
3171: WHERE ID = l_def_okc_sections_tl_rec.id
3172: AND SOURCE_LANG = USERENV('LANG');
3173:
3174: UPDATE OKC_SECTIONS_TL
3175: SET SFWT_FLAG = 'Y'

Line 3174: UPDATE OKC_SECTIONS_TL

3170: LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login
3171: WHERE ID = l_def_okc_sections_tl_rec.id
3172: AND SOURCE_LANG = USERENV('LANG');
3173:
3174: UPDATE OKC_SECTIONS_TL
3175: SET SFWT_FLAG = 'Y'
3176: WHERE ID = l_def_okc_sections_tl_rec.id
3177: AND SOURCE_LANG <> USERENV('LANG');
3178:

Line 3176: WHERE ID = l_def_okc_sections_tl_rec.id

3172: AND SOURCE_LANG = USERENV('LANG');
3173:
3174: UPDATE OKC_SECTIONS_TL
3175: SET SFWT_FLAG = 'Y'
3176: WHERE ID = l_def_okc_sections_tl_rec.id
3177: AND SOURCE_LANG <> USERENV('LANG');
3178:
3179: x_okc_sections_tl_rec := l_def_okc_sections_tl_rec;
3180: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3179: x_okc_sections_tl_rec := l_def_okc_sections_tl_rec;

3175: SET SFWT_FLAG = 'Y'
3176: WHERE ID = l_def_okc_sections_tl_rec.id
3177: AND SOURCE_LANG <> USERENV('LANG');
3178:
3179: x_okc_sections_tl_rec := l_def_okc_sections_tl_rec;
3180: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3181:
3182:
3183: IF (l_debug = 'Y') THEN

Line 3256: l_okc_sections_tl_rec okc_sections_tl_rec_type;

3252: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3253: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3254: l_scnv_rec scnv_rec_type := p_scnv_rec;
3255: l_def_scnv_rec scnv_rec_type;
3256: l_okc_sections_tl_rec okc_sections_tl_rec_type;
3257: lx_okc_sections_tl_rec okc_sections_tl_rec_type;
3258: l_scn_rec scn_rec_type;
3259: lx_scn_rec scn_rec_type;
3260: -------------------------------

Line 3257: lx_okc_sections_tl_rec okc_sections_tl_rec_type;

3253: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3254: l_scnv_rec scnv_rec_type := p_scnv_rec;
3255: l_def_scnv_rec scnv_rec_type;
3256: l_okc_sections_tl_rec okc_sections_tl_rec_type;
3257: lx_okc_sections_tl_rec okc_sections_tl_rec_type;
3258: l_scn_rec scn_rec_type;
3259: lx_scn_rec scn_rec_type;
3260: -------------------------------
3261: -- FUNCTION fill_who_columns --

Line 3500: migrate(l_def_scnv_rec, l_okc_sections_tl_rec);

3496:
3497: --------------------------------------
3498: -- Move VIEW record to "Child" records
3499: --------------------------------------
3500: migrate(l_def_scnv_rec, l_okc_sections_tl_rec);
3501: migrate(l_def_scnv_rec, l_scn_rec);
3502: --------------------------------------------
3503: -- Call the UPDATE_ROW for each child record
3504: --------------------------------------------

Line 3510: l_okc_sections_tl_rec,

3506: p_init_msg_list,
3507: x_return_status,
3508: x_msg_count,
3509: x_msg_data,
3510: l_okc_sections_tl_rec,
3511: lx_okc_sections_tl_rec
3512: );
3513: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3511: lx_okc_sections_tl_rec

3507: x_return_status,
3508: x_msg_count,
3509: x_msg_data,
3510: l_okc_sections_tl_rec,
3511: lx_okc_sections_tl_rec
3512: );
3513: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3515: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3518: migrate(lx_okc_sections_tl_rec, l_def_scnv_rec);

3514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3515: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3516: RAISE OKC_API.G_EXCEPTION_ERROR;
3517: END IF;
3518: migrate(lx_okc_sections_tl_rec, l_def_scnv_rec);
3519: update_row(
3520: p_init_msg_list,
3521: x_return_status,
3522: x_msg_count,

Line 3787: -- delete_row for:OKC_SECTIONS_TL --

3783: );
3784:
3785: END delete_row;
3786: ------------------------------------
3787: -- delete_row for:OKC_SECTIONS_TL --
3788: ------------------------------------
3789: PROCEDURE delete_row(
3790: p_init_msg_list IN VARCHAR2,
3791: x_return_status OUT NOCOPY VARCHAR2,

Line 3794: p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS

3790: p_init_msg_list IN VARCHAR2,
3791: x_return_status OUT NOCOPY VARCHAR2,
3792: x_msg_count OUT NOCOPY NUMBER,
3793: x_msg_data OUT NOCOPY VARCHAR2,
3794: p_okc_sections_tl_rec IN okc_sections_tl_rec_type) IS
3795:
3796: l_api_version CONSTANT NUMBER := 1;
3797: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3799: l_okc_sections_tl_rec okc_sections_tl_rec_type:= p_okc_sections_tl_rec;

3795:
3796: l_api_version CONSTANT NUMBER := 1;
3797: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3799: l_okc_sections_tl_rec okc_sections_tl_rec_type:= p_okc_sections_tl_rec;
3800: l_row_notfound BOOLEAN := TRUE;
3801: ----------------------------------------
3802: -- Set_Attributes for:OKC_SECTIONS_TL --
3803: ----------------------------------------

Line 3802: -- Set_Attributes for:OKC_SECTIONS_TL --

3798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3799: l_okc_sections_tl_rec okc_sections_tl_rec_type:= p_okc_sections_tl_rec;
3800: l_row_notfound BOOLEAN := TRUE;
3801: ----------------------------------------
3802: -- Set_Attributes for:OKC_SECTIONS_TL --
3803: ----------------------------------------
3804: FUNCTION Set_Attributes (
3805: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3806: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type

Line 3805: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,

3801: ----------------------------------------
3802: -- Set_Attributes for:OKC_SECTIONS_TL --
3803: ----------------------------------------
3804: FUNCTION Set_Attributes (
3805: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3806: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
3807: ) RETURN VARCHAR2 IS
3808: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3809: BEGIN

Line 3806: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type

3802: -- Set_Attributes for:OKC_SECTIONS_TL --
3803: ----------------------------------------
3804: FUNCTION Set_Attributes (
3805: p_okc_sections_tl_rec IN okc_sections_tl_rec_type,
3806: x_okc_sections_tl_rec OUT NOCOPY okc_sections_tl_rec_type
3807: ) RETURN VARCHAR2 IS
3808: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3809: BEGIN
3810:

Line 3811: x_okc_sections_tl_rec := p_okc_sections_tl_rec;

3807: ) RETURN VARCHAR2 IS
3808: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3809: BEGIN
3810:
3811: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
3812: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3813: RETURN(l_return_status);
3814:
3815: END Set_Attributes;

Line 3812: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

3808: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3809: BEGIN
3810:
3811: x_okc_sections_tl_rec := p_okc_sections_tl_rec;
3812: x_okc_sections_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3813: RETURN(l_return_status);
3814:
3815: END Set_Attributes;
3816: BEGIN

Line 3834: p_okc_sections_tl_rec, -- IN

3830: RAISE OKC_API.G_EXCEPTION_ERROR;
3831: END IF;
3832: --- Setting item attributes
3833: l_return_status := Set_Attributes(
3834: p_okc_sections_tl_rec, -- IN
3835: l_okc_sections_tl_rec); -- OUT
3836: --- If any errors happen abort API
3837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3835: l_okc_sections_tl_rec); -- OUT

3831: END IF;
3832: --- Setting item attributes
3833: l_return_status := Set_Attributes(
3834: p_okc_sections_tl_rec, -- IN
3835: l_okc_sections_tl_rec); -- OUT
3836: --- If any errors happen abort API
3837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3842: DELETE FROM OKC_SECTIONS_TL

3838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3840: RAISE OKC_API.G_EXCEPTION_ERROR;
3841: END IF;
3842: DELETE FROM OKC_SECTIONS_TL
3843: WHERE ID = l_okc_sections_tl_rec.id;
3844:
3845: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3846:

Line 3843: WHERE ID = l_okc_sections_tl_rec.id;

3839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3840: RAISE OKC_API.G_EXCEPTION_ERROR;
3841: END IF;
3842: DELETE FROM OKC_SECTIONS_TL
3843: WHERE ID = l_okc_sections_tl_rec.id;
3844:
3845: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3846:
3847: IF (l_debug = 'Y') THEN

Line 3918: l_okc_sections_tl_rec okc_sections_tl_rec_type;

3914: l_api_version CONSTANT NUMBER := 1;
3915: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3916: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3917: l_scnv_rec scnv_rec_type := p_scnv_rec;
3918: l_okc_sections_tl_rec okc_sections_tl_rec_type;
3919: l_scn_rec scn_rec_type;
3920: BEGIN
3921:
3922: IF (l_debug = 'Y') THEN

Line 3942: migrate(l_scnv_rec, l_okc_sections_tl_rec);

3938: END IF;
3939: --------------------------------------
3940: -- Move VIEW record to "Child" records
3941: --------------------------------------
3942: migrate(l_scnv_rec, l_okc_sections_tl_rec);
3943: migrate(l_scnv_rec, l_scn_rec);
3944: --------------------------------------------
3945: -- Call the DELETE_ROW for each child record
3946: --------------------------------------------

Line 3952: l_okc_sections_tl_rec

3948: p_init_msg_list,
3949: x_return_status,
3950: x_msg_count,
3951: x_msg_data,
3952: l_okc_sections_tl_rec
3953: );
3954: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3955: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3956: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4215: INSERT INTO okc_sections_tlh

4211: --------------------------
4212: -- Versioning TL Table
4213: --------------------------
4214:
4215: INSERT INTO okc_sections_tlh
4216: (
4217: major_version,
4218: id,
4219: language,

Line 4241: FROM okc_sections_tl

4237: creation_date,
4238: last_updated_by,
4239: last_update_date,
4240: last_update_login
4241: FROM okc_sections_tl
4242: WHERE id in (SELECT id
4243: FROM okc_sections_b
4244: WHERE chr_id= p_chr_id);
4245:

Line 4295: INSERT INTO okc_sections_tl

4291: okc_debug.Set_Indentation('OKC_SCN_PVT');
4292: okc_debug.log('15200: Entered restore_version', 2);
4293: END IF;
4294:
4295: INSERT INTO okc_sections_tl
4296: (
4297: id,
4298: language,
4299: source_lang,

Line 4319: FROM okc_sections_tlh

4315: creation_date,
4316: last_updated_by,
4317: last_update_date,
4318: last_update_login
4319: FROM okc_sections_tlh
4320: WHERE id in (SELECT id
4321: FROM okc_sections_bh
4322: WHERE chr_id = p_chr_id)
4323: AND major_version = p_major_version;