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_CLG_PVT dependencies on OKL_CNTR_LVLNG_GRPS_TL

Line 528: CURSOR c1( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS

524:
525: l_dummy VARCHAR2(1);
526: l_row_found BOOLEAN := FALSE;
527: l_clg_id NUMBER;
528: CURSOR c1( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS
529: SELECT 1
530: FROM OKL_CNTR_LVLNG_GRPS_V
531: WHERE name = p_name;
532: CURSOR c2( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS

Line 532: CURSOR c2( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS

528: CURSOR c1( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS
529: SELECT 1
530: FROM OKL_CNTR_LVLNG_GRPS_V
531: WHERE name = p_name;
532: CURSOR c2( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS
533: SELECT id
534: FROM OKL_CNTR_LVLNG_GRPS_V
535: WHERE name = p_name;
536: BEGIN

Line 642: DELETE FROM OKL_CNTR_LVLNG_GRPS_TL T

638: -- PROCEDURE add_language
639: ---------------------------------------------------------------------------
640: PROCEDURE add_language IS
641: BEGIN
642: DELETE FROM OKL_CNTR_LVLNG_GRPS_TL T
643: WHERE NOT EXISTS (
644: SELECT NULL
645: FROM OKL_CNTR_LVL_GRPS_ALL_B B --fixed bug 3321017 by kmotepal
646: WHERE B.ID = T.ID

Line 649: UPDATE OKL_CNTR_LVLNG_GRPS_TL T SET (

645: FROM OKL_CNTR_LVL_GRPS_ALL_B B --fixed bug 3321017 by kmotepal
646: WHERE B.ID = T.ID
647: );
648:
649: UPDATE OKL_CNTR_LVLNG_GRPS_TL T SET (
650: NAME,
651: DESCRIPTION,
652: PRIVATE_LABEL_LOGO_URL) = (SELECT
653: B.NAME,

Line 656: FROM OKL_CNTR_LVLNG_GRPS_TL B

652: PRIVATE_LABEL_LOGO_URL) = (SELECT
653: B.NAME,
654: B.DESCRIPTION,
655: B.PRIVATE_LABEL_LOGO_URL
656: FROM OKL_CNTR_LVLNG_GRPS_TL B
657: WHERE B.ID = T.ID
658: AND B.LANGUAGE = T.SOURCE_LANG)
659: WHERE (
660: T.ID,

Line 665: FROM OKL_CNTR_LVLNG_GRPS_TL SUBB, OKL_CNTR_LVLNG_GRPS_TL SUBT

661: T.LANGUAGE)
662: IN (SELECT
663: SUBT.ID,
664: SUBT.LANGUAGE
665: FROM OKL_CNTR_LVLNG_GRPS_TL SUBB, OKL_CNTR_LVLNG_GRPS_TL SUBT
666: WHERE SUBB.ID = SUBT.ID
667: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
668: AND (SUBB.NAME <> SUBT.NAME
669: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 677: INSERT INTO OKL_CNTR_LVLNG_GRPS_TL (

673: OR (SUBB.PRIVATE_LABEL_LOGO_URL IS NULL AND SUBT.PRIVATE_LABEL_LOGO_URL IS NOT NULL)
674: OR (SUBB.PRIVATE_LABEL_LOGO_URL IS NOT NULL AND SUBT.PRIVATE_LABEL_LOGO_URL IS NULL)
675: ));
676:
677: INSERT INTO OKL_CNTR_LVLNG_GRPS_TL (
678: ID,
679: LANGUAGE,
680: SOURCE_LANG,
681: SFWT_FLAG,

Line 703: FROM OKL_CNTR_LVLNG_GRPS_TL B, FND_LANGUAGES L

699: B.CREATION_DATE,
700: B.LAST_UPDATED_BY,
701: B.LAST_UPDATE_DATE,
702: B.LAST_UPDATE_LOGIN
703: FROM OKL_CNTR_LVLNG_GRPS_TL B, FND_LANGUAGES L
704: WHERE L.INSTALLED_FLAG IN ('I', 'B')
705: AND B.LANGUAGE = USERENV('LANG')
706: AND NOT EXISTS(
707: SELECT NULL

Line 708: FROM OKL_CNTR_LVLNG_GRPS_TL T

704: WHERE L.INSTALLED_FLAG IN ('I', 'B')
705: AND B.LANGUAGE = USERENV('LANG')
706: AND NOT EXISTS(
707: SELECT NULL
708: FROM OKL_CNTR_LVLNG_GRPS_TL T
709: WHERE T.ID = B.ID
710: AND T.LANGUAGE = L.LANGUAGE_CODE
711: );
712:

Line 814: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_GRPS_TL

810: BEGIN
811: RETURN(get_rec(p_clg_rec, l_row_notfound));
812: END get_rec;
813: ---------------------------------------------------------------------------
814: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_GRPS_TL
815: ---------------------------------------------------------------------------
816: FUNCTION get_rec (
817: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
818: x_no_data_found OUT NOCOPY BOOLEAN

Line 817: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,

813: ---------------------------------------------------------------------------
814: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_GRPS_TL
815: ---------------------------------------------------------------------------
816: FUNCTION get_rec (
817: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
818: x_no_data_found OUT NOCOPY BOOLEAN
819: ) RETURN OklCntrLvlngGrpsTlRecType IS
820: CURSOR okl_cntr_lvlng_grps_tl_pk_csr (p_id IN NUMBER,
821: p_language IN VARCHAR2) IS

Line 820: CURSOR okl_cntr_lvlng_grps_tl_pk_csr (p_id IN NUMBER,

816: FUNCTION get_rec (
817: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
818: x_no_data_found OUT NOCOPY BOOLEAN
819: ) RETURN OklCntrLvlngGrpsTlRecType IS
820: CURSOR okl_cntr_lvlng_grps_tl_pk_csr (p_id IN NUMBER,
821: p_language IN VARCHAR2) IS
822: SELECT
823: ID,
824: LANGUAGE,

Line 835: FROM Okl_Cntr_Lvlng_Grps_Tl

831: CREATION_DATE,
832: LAST_UPDATED_BY,
833: LAST_UPDATE_DATE,
834: LAST_UPDATE_LOGIN
835: FROM Okl_Cntr_Lvlng_Grps_Tl
836: WHERE okl_cntr_lvlng_grps_tl.id = p_id
837: AND okl_cntr_lvlng_grps_tl.LANGUAGE = p_language;
838: l_okl_cntr_lvlng_grps_tl_pk okl_cntr_lvlng_grps_tl_pk_csr%ROWTYPE;
839: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

Line 836: WHERE okl_cntr_lvlng_grps_tl.id = p_id

832: LAST_UPDATED_BY,
833: LAST_UPDATE_DATE,
834: LAST_UPDATE_LOGIN
835: FROM Okl_Cntr_Lvlng_Grps_Tl
836: WHERE okl_cntr_lvlng_grps_tl.id = p_id
837: AND okl_cntr_lvlng_grps_tl.LANGUAGE = p_language;
838: l_okl_cntr_lvlng_grps_tl_pk okl_cntr_lvlng_grps_tl_pk_csr%ROWTYPE;
839: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
840: BEGIN

Line 837: AND okl_cntr_lvlng_grps_tl.LANGUAGE = p_language;

833: LAST_UPDATE_DATE,
834: LAST_UPDATE_LOGIN
835: FROM Okl_Cntr_Lvlng_Grps_Tl
836: WHERE okl_cntr_lvlng_grps_tl.id = p_id
837: AND okl_cntr_lvlng_grps_tl.LANGUAGE = p_language;
838: l_okl_cntr_lvlng_grps_tl_pk okl_cntr_lvlng_grps_tl_pk_csr%ROWTYPE;
839: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
840: BEGIN
841: x_no_data_found := TRUE;

Line 838: l_okl_cntr_lvlng_grps_tl_pk okl_cntr_lvlng_grps_tl_pk_csr%ROWTYPE;

834: LAST_UPDATE_LOGIN
835: FROM Okl_Cntr_Lvlng_Grps_Tl
836: WHERE okl_cntr_lvlng_grps_tl.id = p_id
837: AND okl_cntr_lvlng_grps_tl.LANGUAGE = p_language;
838: l_okl_cntr_lvlng_grps_tl_pk okl_cntr_lvlng_grps_tl_pk_csr%ROWTYPE;
839: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
840: BEGIN
841: x_no_data_found := TRUE;
842: -- Get current database values

Line 839: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

835: FROM Okl_Cntr_Lvlng_Grps_Tl
836: WHERE okl_cntr_lvlng_grps_tl.id = p_id
837: AND okl_cntr_lvlng_grps_tl.LANGUAGE = p_language;
838: l_okl_cntr_lvlng_grps_tl_pk okl_cntr_lvlng_grps_tl_pk_csr%ROWTYPE;
839: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
840: BEGIN
841: x_no_data_found := TRUE;
842: -- Get current database values
843: OPEN okl_cntr_lvlng_grps_tl_pk_csr (p_okl_cntr_lvlng_grps_tl_rec.id,

Line 843: OPEN okl_cntr_lvlng_grps_tl_pk_csr (p_okl_cntr_lvlng_grps_tl_rec.id,

839: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
840: BEGIN
841: x_no_data_found := TRUE;
842: -- Get current database values
843: OPEN okl_cntr_lvlng_grps_tl_pk_csr (p_okl_cntr_lvlng_grps_tl_rec.id,
844: p_okl_cntr_lvlng_grps_tl_rec.LANGUAGE);
845: FETCH okl_cntr_lvlng_grps_tl_pk_csr INTO
846: l_okl_cntr_lvlng_grps_tl_rec.ID,
847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,

Line 844: p_okl_cntr_lvlng_grps_tl_rec.LANGUAGE);

840: BEGIN
841: x_no_data_found := TRUE;
842: -- Get current database values
843: OPEN okl_cntr_lvlng_grps_tl_pk_csr (p_okl_cntr_lvlng_grps_tl_rec.id,
844: p_okl_cntr_lvlng_grps_tl_rec.LANGUAGE);
845: FETCH okl_cntr_lvlng_grps_tl_pk_csr INTO
846: l_okl_cntr_lvlng_grps_tl_rec.ID,
847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,

Line 845: FETCH okl_cntr_lvlng_grps_tl_pk_csr INTO

841: x_no_data_found := TRUE;
842: -- Get current database values
843: OPEN okl_cntr_lvlng_grps_tl_pk_csr (p_okl_cntr_lvlng_grps_tl_rec.id,
844: p_okl_cntr_lvlng_grps_tl_rec.LANGUAGE);
845: FETCH okl_cntr_lvlng_grps_tl_pk_csr INTO
846: l_okl_cntr_lvlng_grps_tl_rec.ID,
847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,
849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,

Line 846: l_okl_cntr_lvlng_grps_tl_rec.ID,

842: -- Get current database values
843: OPEN okl_cntr_lvlng_grps_tl_pk_csr (p_okl_cntr_lvlng_grps_tl_rec.id,
844: p_okl_cntr_lvlng_grps_tl_rec.LANGUAGE);
845: FETCH okl_cntr_lvlng_grps_tl_pk_csr INTO
846: l_okl_cntr_lvlng_grps_tl_rec.ID,
847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,
849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,
850: l_okl_cntr_lvlng_grps_tl_rec.NAME,

Line 847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,

843: OPEN okl_cntr_lvlng_grps_tl_pk_csr (p_okl_cntr_lvlng_grps_tl_rec.id,
844: p_okl_cntr_lvlng_grps_tl_rec.LANGUAGE);
845: FETCH okl_cntr_lvlng_grps_tl_pk_csr INTO
846: l_okl_cntr_lvlng_grps_tl_rec.ID,
847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,
849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,
850: l_okl_cntr_lvlng_grps_tl_rec.NAME,
851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,

Line 848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,

844: p_okl_cntr_lvlng_grps_tl_rec.LANGUAGE);
845: FETCH okl_cntr_lvlng_grps_tl_pk_csr INTO
846: l_okl_cntr_lvlng_grps_tl_rec.ID,
847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,
849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,
850: l_okl_cntr_lvlng_grps_tl_rec.NAME,
851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,
852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,

Line 849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,

845: FETCH okl_cntr_lvlng_grps_tl_pk_csr INTO
846: l_okl_cntr_lvlng_grps_tl_rec.ID,
847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,
849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,
850: l_okl_cntr_lvlng_grps_tl_rec.NAME,
851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,
852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,
853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,

Line 850: l_okl_cntr_lvlng_grps_tl_rec.NAME,

846: l_okl_cntr_lvlng_grps_tl_rec.ID,
847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,
849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,
850: l_okl_cntr_lvlng_grps_tl_rec.NAME,
851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,
852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,
853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,
854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,

Line 851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,

847: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,
849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,
850: l_okl_cntr_lvlng_grps_tl_rec.NAME,
851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,
852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,
853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,
854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,
855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,

Line 852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,

848: l_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG,
849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,
850: l_okl_cntr_lvlng_grps_tl_rec.NAME,
851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,
852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,
853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,
854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,
855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,
856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,

Line 853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,

849: l_okl_cntr_lvlng_grps_tl_rec.SFWT_FLAG,
850: l_okl_cntr_lvlng_grps_tl_rec.NAME,
851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,
852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,
853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,
854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,
855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,
856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,
857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;

Line 854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,

850: l_okl_cntr_lvlng_grps_tl_rec.NAME,
851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,
852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,
853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,
854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,
855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,
856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,
857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;
858: x_no_data_found := okl_cntr_lvlng_grps_tl_pk_csr%NOTFOUND;

Line 855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,

851: l_okl_cntr_lvlng_grps_tl_rec.DESCRIPTION,
852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,
853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,
854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,
855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,
856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,
857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;
858: x_no_data_found := okl_cntr_lvlng_grps_tl_pk_csr%NOTFOUND;
859: CLOSE okl_cntr_lvlng_grps_tl_pk_csr;

Line 856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,

852: l_okl_cntr_lvlng_grps_tl_rec.PRIVATE_LABEL_LOGO_URL,
853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,
854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,
855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,
856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,
857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;
858: x_no_data_found := okl_cntr_lvlng_grps_tl_pk_csr%NOTFOUND;
859: CLOSE okl_cntr_lvlng_grps_tl_pk_csr;
860: RETURN(l_okl_cntr_lvlng_grps_tl_rec);

Line 857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;

853: l_okl_cntr_lvlng_grps_tl_rec.CREATED_BY,
854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,
855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,
856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,
857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;
858: x_no_data_found := okl_cntr_lvlng_grps_tl_pk_csr%NOTFOUND;
859: CLOSE okl_cntr_lvlng_grps_tl_pk_csr;
860: RETURN(l_okl_cntr_lvlng_grps_tl_rec);
861: END get_rec;

Line 858: x_no_data_found := okl_cntr_lvlng_grps_tl_pk_csr%NOTFOUND;

854: l_okl_cntr_lvlng_grps_tl_rec.CREATION_DATE,
855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,
856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,
857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;
858: x_no_data_found := okl_cntr_lvlng_grps_tl_pk_csr%NOTFOUND;
859: CLOSE okl_cntr_lvlng_grps_tl_pk_csr;
860: RETURN(l_okl_cntr_lvlng_grps_tl_rec);
861: END get_rec;
862:

Line 859: CLOSE okl_cntr_lvlng_grps_tl_pk_csr;

855: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATED_BY,
856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,
857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;
858: x_no_data_found := okl_cntr_lvlng_grps_tl_pk_csr%NOTFOUND;
859: CLOSE okl_cntr_lvlng_grps_tl_pk_csr;
860: RETURN(l_okl_cntr_lvlng_grps_tl_rec);
861: END get_rec;
862:
863: FUNCTION get_rec (

Line 860: RETURN(l_okl_cntr_lvlng_grps_tl_rec);

856: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_DATE,
857: l_okl_cntr_lvlng_grps_tl_rec.LAST_UPDATE_LOGIN;
858: x_no_data_found := okl_cntr_lvlng_grps_tl_pk_csr%NOTFOUND;
859: CLOSE okl_cntr_lvlng_grps_tl_pk_csr;
860: RETURN(l_okl_cntr_lvlng_grps_tl_rec);
861: END get_rec;
862:
863: FUNCTION get_rec (
864: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType

Line 864: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType

860: RETURN(l_okl_cntr_lvlng_grps_tl_rec);
861: END get_rec;
862:
863: FUNCTION get_rec (
864: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType
865: ) RETURN OklCntrLvlngGrpsTlRecType IS
866: l_row_notfound BOOLEAN := TRUE;
867: BEGIN
868: RETURN(get_rec(p_okl_cntr_lvlng_grps_tl_rec, l_row_notfound));

Line 868: RETURN(get_rec(p_okl_cntr_lvlng_grps_tl_rec, l_row_notfound));

864: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType
865: ) RETURN OklCntrLvlngGrpsTlRecType IS
866: l_row_notfound BOOLEAN := TRUE;
867: BEGIN
868: RETURN(get_rec(p_okl_cntr_lvlng_grps_tl_rec, l_row_notfound));
869: END get_rec;
870: ---------------------------------------------------------------------------
871: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_GRPS_V
872: ---------------------------------------------------------------------------

Line 1373: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

1369: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1370: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1371: l_clgv_rec clgv_rec_type := p_clgv_rec;
1372: l_clg_rec clg_rec_type;
1373: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
1374: BEGIN
1375: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1376: G_PKG_NAME,
1377: p_init_msg_list,

Line 1656: -- insert_row for:OKL_CNTR_LVLNG_GRPS_TL --

1652: '_PVT'
1653: );
1654: END insert_row;
1655: -------------------------------------------
1656: -- insert_row for:OKL_CNTR_LVLNG_GRPS_TL --
1657: -------------------------------------------
1658: PROCEDURE insert_row(
1659: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1660: x_return_status OUT NOCOPY VARCHAR2,

Line 1663: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,

1659: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1660: x_return_status OUT NOCOPY VARCHAR2,
1661: x_msg_count OUT NOCOPY NUMBER,
1662: x_msg_data OUT NOCOPY VARCHAR2,
1663: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
1664: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType) IS
1665:
1666: l_api_version CONSTANT NUMBER := 1;
1667: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1664: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType) IS

1660: x_return_status OUT NOCOPY VARCHAR2,
1661: x_msg_count OUT NOCOPY NUMBER,
1662: x_msg_data OUT NOCOPY VARCHAR2,
1663: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
1664: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType) IS
1665:
1666: l_api_version CONSTANT NUMBER := 1;
1667: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1668: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1669: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType := p_okl_cntr_lvlng_grps_tl_rec;

1665:
1666: l_api_version CONSTANT NUMBER := 1;
1667: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1668: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1669: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType := p_okl_cntr_lvlng_grps_tl_rec;
1670: ldefoklcntrlvlnggrpstlrec OklCntrLvlngGrpsTlRecType;
1671: CURSOR get_languages IS
1672: SELECT *
1673: FROM FND_LANGUAGES

Line 1676: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --

1672: SELECT *
1673: FROM FND_LANGUAGES
1674: WHERE INSTALLED_FLAG IN ('I', 'B');
1675: -----------------------------------------------
1676: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
1677: -----------------------------------------------
1678: FUNCTION Set_Attributes (
1679: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
1680: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType

Line 1679: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,

1675: -----------------------------------------------
1676: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
1677: -----------------------------------------------
1678: FUNCTION Set_Attributes (
1679: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
1680: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
1681: ) RETURN VARCHAR2 IS
1682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1683: BEGIN

Line 1680: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType

1676: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
1677: -----------------------------------------------
1678: FUNCTION Set_Attributes (
1679: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
1680: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
1681: ) RETURN VARCHAR2 IS
1682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1683: BEGIN
1684: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;

Line 1684: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;

1680: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
1681: ) RETURN VARCHAR2 IS
1682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1683: BEGIN
1684: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
1685: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');
1686: x_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG := USERENV('LANG');
1687: RETURN(l_return_status);
1688: END Set_Attributes;

Line 1685: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');

1681: ) RETURN VARCHAR2 IS
1682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1683: BEGIN
1684: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
1685: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');
1686: x_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG := USERENV('LANG');
1687: RETURN(l_return_status);
1688: END Set_Attributes;
1689: BEGIN

Line 1686: x_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG := USERENV('LANG');

1682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1683: BEGIN
1684: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
1685: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');
1686: x_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG := USERENV('LANG');
1687: RETURN(l_return_status);
1688: END Set_Attributes;
1689: BEGIN
1690: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 1701: p_okl_cntr_lvlng_grps_tl_rec, -- IN

1697: RAISE Okc_Api.G_EXCEPTION_ERROR;
1698: END IF;
1699: --- Setting item attributes
1700: l_return_status := Set_Attributes(
1701: p_okl_cntr_lvlng_grps_tl_rec, -- IN
1702: l_okl_cntr_lvlng_grps_tl_rec); -- OUT
1703: --- If any errors happen abort API
1704: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1702: l_okl_cntr_lvlng_grps_tl_rec); -- OUT

1698: END IF;
1699: --- Setting item attributes
1700: l_return_status := Set_Attributes(
1701: p_okl_cntr_lvlng_grps_tl_rec, -- IN
1702: l_okl_cntr_lvlng_grps_tl_rec); -- OUT
1703: --- If any errors happen abort API
1704: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 1710: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_lang_rec.language_code;

1706: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1707: RAISE Okc_Api.G_EXCEPTION_ERROR;
1708: END IF;
1709: FOR l_lang_rec IN get_languages LOOP
1710: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_lang_rec.language_code;
1711: INSERT INTO OKL_CNTR_LVLNG_GRPS_TL(
1712: id,
1713: LANGUAGE,
1714: source_lang,

Line 1711: INSERT INTO OKL_CNTR_LVLNG_GRPS_TL(

1707: RAISE Okc_Api.G_EXCEPTION_ERROR;
1708: END IF;
1709: FOR l_lang_rec IN get_languages LOOP
1710: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_lang_rec.language_code;
1711: INSERT INTO OKL_CNTR_LVLNG_GRPS_TL(
1712: id,
1713: LANGUAGE,
1714: source_lang,
1715: sfwt_flag,

Line 1725: l_okl_cntr_lvlng_grps_tl_rec.id,

1721: last_updated_by,
1722: last_update_date,
1723: last_update_login)
1724: VALUES (
1725: l_okl_cntr_lvlng_grps_tl_rec.id,
1726: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
1727: l_okl_cntr_lvlng_grps_tl_rec.source_lang,
1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,
1729: l_okl_cntr_lvlng_grps_tl_rec.name,

Line 1726: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,

1722: last_update_date,
1723: last_update_login)
1724: VALUES (
1725: l_okl_cntr_lvlng_grps_tl_rec.id,
1726: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
1727: l_okl_cntr_lvlng_grps_tl_rec.source_lang,
1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,
1729: l_okl_cntr_lvlng_grps_tl_rec.name,
1730: l_okl_cntr_lvlng_grps_tl_rec.description,

Line 1727: l_okl_cntr_lvlng_grps_tl_rec.source_lang,

1723: last_update_login)
1724: VALUES (
1725: l_okl_cntr_lvlng_grps_tl_rec.id,
1726: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
1727: l_okl_cntr_lvlng_grps_tl_rec.source_lang,
1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,
1729: l_okl_cntr_lvlng_grps_tl_rec.name,
1730: l_okl_cntr_lvlng_grps_tl_rec.description,
1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,

Line 1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,

1724: VALUES (
1725: l_okl_cntr_lvlng_grps_tl_rec.id,
1726: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
1727: l_okl_cntr_lvlng_grps_tl_rec.source_lang,
1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,
1729: l_okl_cntr_lvlng_grps_tl_rec.name,
1730: l_okl_cntr_lvlng_grps_tl_rec.description,
1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,
1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,

Line 1729: l_okl_cntr_lvlng_grps_tl_rec.name,

1725: l_okl_cntr_lvlng_grps_tl_rec.id,
1726: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
1727: l_okl_cntr_lvlng_grps_tl_rec.source_lang,
1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,
1729: l_okl_cntr_lvlng_grps_tl_rec.name,
1730: l_okl_cntr_lvlng_grps_tl_rec.description,
1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,
1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,
1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,

Line 1730: l_okl_cntr_lvlng_grps_tl_rec.description,

1726: l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE,
1727: l_okl_cntr_lvlng_grps_tl_rec.source_lang,
1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,
1729: l_okl_cntr_lvlng_grps_tl_rec.name,
1730: l_okl_cntr_lvlng_grps_tl_rec.description,
1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,
1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,
1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,
1734: l_okl_cntr_lvlng_grps_tl_rec.last_updated_by,

Line 1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,

1727: l_okl_cntr_lvlng_grps_tl_rec.source_lang,
1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,
1729: l_okl_cntr_lvlng_grps_tl_rec.name,
1730: l_okl_cntr_lvlng_grps_tl_rec.description,
1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,
1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,
1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,
1734: l_okl_cntr_lvlng_grps_tl_rec.last_updated_by,
1735: l_okl_cntr_lvlng_grps_tl_rec.last_update_date,

Line 1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,

1728: l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag,
1729: l_okl_cntr_lvlng_grps_tl_rec.name,
1730: l_okl_cntr_lvlng_grps_tl_rec.description,
1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,
1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,
1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,
1734: l_okl_cntr_lvlng_grps_tl_rec.last_updated_by,
1735: l_okl_cntr_lvlng_grps_tl_rec.last_update_date,
1736: l_okl_cntr_lvlng_grps_tl_rec.last_update_login);

Line 1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,

1729: l_okl_cntr_lvlng_grps_tl_rec.name,
1730: l_okl_cntr_lvlng_grps_tl_rec.description,
1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,
1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,
1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,
1734: l_okl_cntr_lvlng_grps_tl_rec.last_updated_by,
1735: l_okl_cntr_lvlng_grps_tl_rec.last_update_date,
1736: l_okl_cntr_lvlng_grps_tl_rec.last_update_login);
1737: END LOOP;

Line 1734: l_okl_cntr_lvlng_grps_tl_rec.last_updated_by,

1730: l_okl_cntr_lvlng_grps_tl_rec.description,
1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,
1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,
1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,
1734: l_okl_cntr_lvlng_grps_tl_rec.last_updated_by,
1735: l_okl_cntr_lvlng_grps_tl_rec.last_update_date,
1736: l_okl_cntr_lvlng_grps_tl_rec.last_update_login);
1737: END LOOP;
1738: -- Set OUT values

Line 1735: l_okl_cntr_lvlng_grps_tl_rec.last_update_date,

1731: l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url,
1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,
1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,
1734: l_okl_cntr_lvlng_grps_tl_rec.last_updated_by,
1735: l_okl_cntr_lvlng_grps_tl_rec.last_update_date,
1736: l_okl_cntr_lvlng_grps_tl_rec.last_update_login);
1737: END LOOP;
1738: -- Set OUT values
1739: x_okl_cntr_lvlng_grps_tl_rec := l_okl_cntr_lvlng_grps_tl_rec;

Line 1736: l_okl_cntr_lvlng_grps_tl_rec.last_update_login);

1732: l_okl_cntr_lvlng_grps_tl_rec.created_by,
1733: l_okl_cntr_lvlng_grps_tl_rec.creation_date,
1734: l_okl_cntr_lvlng_grps_tl_rec.last_updated_by,
1735: l_okl_cntr_lvlng_grps_tl_rec.last_update_date,
1736: l_okl_cntr_lvlng_grps_tl_rec.last_update_login);
1737: END LOOP;
1738: -- Set OUT values
1739: x_okl_cntr_lvlng_grps_tl_rec := l_okl_cntr_lvlng_grps_tl_rec;
1740: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1739: x_okl_cntr_lvlng_grps_tl_rec := l_okl_cntr_lvlng_grps_tl_rec;

1735: l_okl_cntr_lvlng_grps_tl_rec.last_update_date,
1736: l_okl_cntr_lvlng_grps_tl_rec.last_update_login);
1737: END LOOP;
1738: -- Set OUT values
1739: x_okl_cntr_lvlng_grps_tl_rec := l_okl_cntr_lvlng_grps_tl_rec;
1740: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1741: EXCEPTION
1742: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1743: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

Line 1792: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

1788: l_clgv_rec clgv_rec_type;
1789: l_def_clgv_rec clgv_rec_type;
1790: l_clg_rec clg_rec_type;
1791: lx_clg_rec clg_rec_type;
1792: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
1793: lx_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
1794: -------------------------------
1795: -- FUNCTION fill_who_columns --
1796: -------------------------------

Line 1793: lx_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

1789: l_def_clgv_rec clgv_rec_type;
1790: l_clg_rec clg_rec_type;
1791: lx_clg_rec clg_rec_type;
1792: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
1793: lx_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
1794: -------------------------------
1795: -- FUNCTION fill_who_columns --
1796: -------------------------------
1797: FUNCTION fill_who_columns (

Line 1869: migrate(l_def_clgv_rec, l_okl_cntr_lvlng_grps_tl_rec);

1865: --------------------------------------
1866: -- Move VIEW record to "Child" records
1867: --------------------------------------
1868: migrate(l_def_clgv_rec, l_clg_rec);
1869: migrate(l_def_clgv_rec, l_okl_cntr_lvlng_grps_tl_rec);
1870: --------------------------------------------
1871: -- Call the INSERT_ROW for each child record
1872: --------------------------------------------
1873: insert_row(

Line 1892: l_okl_cntr_lvlng_grps_tl_rec,

1888: p_init_msg_list,
1889: x_return_status,
1890: x_msg_count,
1891: x_msg_data,
1892: l_okl_cntr_lvlng_grps_tl_rec,
1893: lx_okl_cntr_lvlng_grps_tl_rec
1894: );
1895: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1896: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1893: lx_okl_cntr_lvlng_grps_tl_rec

1889: x_return_status,
1890: x_msg_count,
1891: x_msg_data,
1892: l_okl_cntr_lvlng_grps_tl_rec,
1893: lx_okl_cntr_lvlng_grps_tl_rec
1894: );
1895: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1896: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1897: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 1900: migrate(lx_okl_cntr_lvlng_grps_tl_rec, l_def_clgv_rec);

1896: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1897: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1898: RAISE Okc_Api.G_EXCEPTION_ERROR;
1899: END IF;
1900: migrate(lx_okl_cntr_lvlng_grps_tl_rec, l_def_clgv_rec);
1901: -- Set OUT values
1902: x_clgv_rec := l_def_clgv_rec;
1903: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1904: EXCEPTION

Line 2113: -- lock_row for:OKL_CNTR_LVLNG_GRPS_TL --

2109: '_PVT'
2110: );
2111: END lock_row;
2112: -----------------------------------------
2113: -- lock_row for:OKL_CNTR_LVLNG_GRPS_TL --
2114: -----------------------------------------
2115: PROCEDURE lock_row(
2116: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2117: x_return_status OUT NOCOPY VARCHAR2,

Line 2120: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS

2116: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2117: x_return_status OUT NOCOPY VARCHAR2,
2118: x_msg_count OUT NOCOPY NUMBER,
2119: x_msg_data OUT NOCOPY VARCHAR2,
2120: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS
2121:
2122: E_Resource_Busy EXCEPTION;
2123: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2124: CURSOR lock_csr (p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS

Line 2124: CURSOR lock_csr (p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS

2120: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS
2121:
2122: E_Resource_Busy EXCEPTION;
2123: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2124: CURSOR lock_csr (p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS
2125: SELECT *
2126: FROM OKL_CNTR_LVLNG_GRPS_TL
2127: WHERE ID = p_okl_cntr_lvlng_grps_tl_rec.id
2128: FOR UPDATE NOWAIT;

Line 2126: FROM OKL_CNTR_LVLNG_GRPS_TL

2122: E_Resource_Busy EXCEPTION;
2123: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2124: CURSOR lock_csr (p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS
2125: SELECT *
2126: FROM OKL_CNTR_LVLNG_GRPS_TL
2127: WHERE ID = p_okl_cntr_lvlng_grps_tl_rec.id
2128: FOR UPDATE NOWAIT;
2129:
2130: l_api_version CONSTANT NUMBER := 1;

Line 2127: WHERE ID = p_okl_cntr_lvlng_grps_tl_rec.id

2123: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2124: CURSOR lock_csr (p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS
2125: SELECT *
2126: FROM OKL_CNTR_LVLNG_GRPS_TL
2127: WHERE ID = p_okl_cntr_lvlng_grps_tl_rec.id
2128: FOR UPDATE NOWAIT;
2129:
2130: l_api_version CONSTANT NUMBER := 1;
2131: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2147: OPEN lock_csr(p_okl_cntr_lvlng_grps_tl_rec);

2143: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2144: RAISE Okc_Api.G_EXCEPTION_ERROR;
2145: END IF;
2146: BEGIN
2147: OPEN lock_csr(p_okl_cntr_lvlng_grps_tl_rec);
2148: FETCH lock_csr INTO l_lock_var;
2149: l_row_notfound := lock_csr%NOTFOUND;
2150: CLOSE lock_csr;
2151: EXCEPTION

Line 2212: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

2208: l_api_version CONSTANT NUMBER := 1;
2209: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2210: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2211: l_clg_rec clg_rec_type;
2212: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2213: BEGIN
2214: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2215: G_PKG_NAME,
2216: p_init_msg_list,

Line 2230: migrate(p_clgv_rec, l_okl_cntr_lvlng_grps_tl_rec);

2226: --------------------------------------
2227: -- Move VIEW record to "Child" records
2228: --------------------------------------
2229: migrate(p_clgv_rec, l_clg_rec);
2230: migrate(p_clgv_rec, l_okl_cntr_lvlng_grps_tl_rec);
2231: --------------------------------------------
2232: -- Call the LOCK_ROW for each child record
2233: --------------------------------------------
2234: lock_row(

Line 2251: l_okl_cntr_lvlng_grps_tl_rec

2247: p_init_msg_list,
2248: x_return_status,
2249: x_msg_count,
2250: x_msg_data,
2251: l_okl_cntr_lvlng_grps_tl_rec
2252: );
2253: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2254: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2255: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 2642: -- update_row for:OKL_CNTR_LVLNG_GRPS_TL --

2638: '_PVT'
2639: );
2640: END update_row;
2641: -------------------------------------------
2642: -- update_row for:OKL_CNTR_LVLNG_GRPS_TL --
2643: -------------------------------------------
2644: PROCEDURE update_row(
2645: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2646: x_return_status OUT NOCOPY VARCHAR2,

Line 2649: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,

2645: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2646: x_return_status OUT NOCOPY VARCHAR2,
2647: x_msg_count OUT NOCOPY NUMBER,
2648: x_msg_data OUT NOCOPY VARCHAR2,
2649: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
2650: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType) IS
2651:
2652: l_api_version CONSTANT NUMBER := 1;
2653: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2650: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType) IS

2646: x_return_status OUT NOCOPY VARCHAR2,
2647: x_msg_count OUT NOCOPY NUMBER,
2648: x_msg_data OUT NOCOPY VARCHAR2,
2649: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
2650: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType) IS
2651:
2652: l_api_version CONSTANT NUMBER := 1;
2653: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2654: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2655: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType := p_okl_cntr_lvlng_grps_tl_rec;

2651:
2652: l_api_version CONSTANT NUMBER := 1;
2653: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2654: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2655: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType := p_okl_cntr_lvlng_grps_tl_rec;
2656: ldefoklcntrlvlnggrpstlrec OklCntrLvlngGrpsTlRecType;
2657: l_row_notfound BOOLEAN := TRUE;
2658: ----------------------------------
2659: -- FUNCTION populate_new_record --

Line 2662: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,

2658: ----------------------------------
2659: -- FUNCTION populate_new_record --
2660: ----------------------------------
2661: FUNCTION populate_new_record (
2662: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
2663: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
2664: ) RETURN VARCHAR2 IS
2665: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2666: l_row_notfound BOOLEAN := TRUE;

Line 2663: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType

2659: -- FUNCTION populate_new_record --
2660: ----------------------------------
2661: FUNCTION populate_new_record (
2662: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
2663: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
2664: ) RETURN VARCHAR2 IS
2665: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2666: l_row_notfound BOOLEAN := TRUE;
2667: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2665: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

2661: FUNCTION populate_new_record (
2662: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
2663: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
2664: ) RETURN VARCHAR2 IS
2665: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2666: l_row_notfound BOOLEAN := TRUE;
2667: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2668: BEGIN
2669: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;

Line 2669: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;

2665: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2666: l_row_notfound BOOLEAN := TRUE;
2667: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2668: BEGIN
2669: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
2670: -- Get current database values
2671: l_okl_cntr_lvlng_grps_tl_rec := get_rec(p_okl_cntr_lvlng_grps_tl_rec, l_row_notfound);
2672: IF (l_row_notfound) THEN
2673: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

Line 2671: l_okl_cntr_lvlng_grps_tl_rec := get_rec(p_okl_cntr_lvlng_grps_tl_rec, l_row_notfound);

2667: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2668: BEGIN
2669: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
2670: -- Get current database values
2671: l_okl_cntr_lvlng_grps_tl_rec := get_rec(p_okl_cntr_lvlng_grps_tl_rec, l_row_notfound);
2672: IF (l_row_notfound) THEN
2673: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2674: END IF;
2675: IF (x_okl_cntr_lvlng_grps_tl_rec.id = Okc_Api.G_MISS_NUM)

Line 2675: IF (x_okl_cntr_lvlng_grps_tl_rec.id = Okc_Api.G_MISS_NUM)

2671: l_okl_cntr_lvlng_grps_tl_rec := get_rec(p_okl_cntr_lvlng_grps_tl_rec, l_row_notfound);
2672: IF (l_row_notfound) THEN
2673: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2674: END IF;
2675: IF (x_okl_cntr_lvlng_grps_tl_rec.id = Okc_Api.G_MISS_NUM)
2676: THEN
2677: x_okl_cntr_lvlng_grps_tl_rec.id := l_okl_cntr_lvlng_grps_tl_rec.id;
2678: END IF;
2679: IF (x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

Line 2677: x_okl_cntr_lvlng_grps_tl_rec.id := l_okl_cntr_lvlng_grps_tl_rec.id;

2673: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2674: END IF;
2675: IF (x_okl_cntr_lvlng_grps_tl_rec.id = Okc_Api.G_MISS_NUM)
2676: THEN
2677: x_okl_cntr_lvlng_grps_tl_rec.id := l_okl_cntr_lvlng_grps_tl_rec.id;
2678: END IF;
2679: IF (x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2680: THEN
2681: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE;

Line 2679: IF (x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

2675: IF (x_okl_cntr_lvlng_grps_tl_rec.id = Okc_Api.G_MISS_NUM)
2676: THEN
2677: x_okl_cntr_lvlng_grps_tl_rec.id := l_okl_cntr_lvlng_grps_tl_rec.id;
2678: END IF;
2679: IF (x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2680: THEN
2681: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE;
2682: END IF;
2683: IF (x_okl_cntr_lvlng_grps_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

Line 2681: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE;

2677: x_okl_cntr_lvlng_grps_tl_rec.id := l_okl_cntr_lvlng_grps_tl_rec.id;
2678: END IF;
2679: IF (x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2680: THEN
2681: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE;
2682: END IF;
2683: IF (x_okl_cntr_lvlng_grps_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2684: THEN
2685: x_okl_cntr_lvlng_grps_tl_rec.source_lang := l_okl_cntr_lvlng_grps_tl_rec.source_lang;

Line 2683: IF (x_okl_cntr_lvlng_grps_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

2679: IF (x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2680: THEN
2681: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE;
2682: END IF;
2683: IF (x_okl_cntr_lvlng_grps_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2684: THEN
2685: x_okl_cntr_lvlng_grps_tl_rec.source_lang := l_okl_cntr_lvlng_grps_tl_rec.source_lang;
2686: END IF;
2687: IF (x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

Line 2685: x_okl_cntr_lvlng_grps_tl_rec.source_lang := l_okl_cntr_lvlng_grps_tl_rec.source_lang;

2681: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := l_okl_cntr_lvlng_grps_tl_rec.LANGUAGE;
2682: END IF;
2683: IF (x_okl_cntr_lvlng_grps_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2684: THEN
2685: x_okl_cntr_lvlng_grps_tl_rec.source_lang := l_okl_cntr_lvlng_grps_tl_rec.source_lang;
2686: END IF;
2687: IF (x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2688: THEN
2689: x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag := l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag;

Line 2687: IF (x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

2683: IF (x_okl_cntr_lvlng_grps_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2684: THEN
2685: x_okl_cntr_lvlng_grps_tl_rec.source_lang := l_okl_cntr_lvlng_grps_tl_rec.source_lang;
2686: END IF;
2687: IF (x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2688: THEN
2689: x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag := l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag;
2690: END IF;
2691: IF (x_okl_cntr_lvlng_grps_tl_rec.name = Okc_Api.G_MISS_CHAR)

Line 2689: x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag := l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag;

2685: x_okl_cntr_lvlng_grps_tl_rec.source_lang := l_okl_cntr_lvlng_grps_tl_rec.source_lang;
2686: END IF;
2687: IF (x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2688: THEN
2689: x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag := l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag;
2690: END IF;
2691: IF (x_okl_cntr_lvlng_grps_tl_rec.name = Okc_Api.G_MISS_CHAR)
2692: THEN
2693: x_okl_cntr_lvlng_grps_tl_rec.name := l_okl_cntr_lvlng_grps_tl_rec.name;

Line 2691: IF (x_okl_cntr_lvlng_grps_tl_rec.name = Okc_Api.G_MISS_CHAR)

2687: IF (x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2688: THEN
2689: x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag := l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag;
2690: END IF;
2691: IF (x_okl_cntr_lvlng_grps_tl_rec.name = Okc_Api.G_MISS_CHAR)
2692: THEN
2693: x_okl_cntr_lvlng_grps_tl_rec.name := l_okl_cntr_lvlng_grps_tl_rec.name;
2694: END IF;
2695: IF (x_okl_cntr_lvlng_grps_tl_rec.description = Okc_Api.G_MISS_CHAR)

Line 2693: x_okl_cntr_lvlng_grps_tl_rec.name := l_okl_cntr_lvlng_grps_tl_rec.name;

2689: x_okl_cntr_lvlng_grps_tl_rec.sfwt_flag := l_okl_cntr_lvlng_grps_tl_rec.sfwt_flag;
2690: END IF;
2691: IF (x_okl_cntr_lvlng_grps_tl_rec.name = Okc_Api.G_MISS_CHAR)
2692: THEN
2693: x_okl_cntr_lvlng_grps_tl_rec.name := l_okl_cntr_lvlng_grps_tl_rec.name;
2694: END IF;
2695: IF (x_okl_cntr_lvlng_grps_tl_rec.description = Okc_Api.G_MISS_CHAR)
2696: THEN
2697: x_okl_cntr_lvlng_grps_tl_rec.description := l_okl_cntr_lvlng_grps_tl_rec.description;

Line 2695: IF (x_okl_cntr_lvlng_grps_tl_rec.description = Okc_Api.G_MISS_CHAR)

2691: IF (x_okl_cntr_lvlng_grps_tl_rec.name = Okc_Api.G_MISS_CHAR)
2692: THEN
2693: x_okl_cntr_lvlng_grps_tl_rec.name := l_okl_cntr_lvlng_grps_tl_rec.name;
2694: END IF;
2695: IF (x_okl_cntr_lvlng_grps_tl_rec.description = Okc_Api.G_MISS_CHAR)
2696: THEN
2697: x_okl_cntr_lvlng_grps_tl_rec.description := l_okl_cntr_lvlng_grps_tl_rec.description;
2698: END IF;
2699: IF (x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)

Line 2697: x_okl_cntr_lvlng_grps_tl_rec.description := l_okl_cntr_lvlng_grps_tl_rec.description;

2693: x_okl_cntr_lvlng_grps_tl_rec.name := l_okl_cntr_lvlng_grps_tl_rec.name;
2694: END IF;
2695: IF (x_okl_cntr_lvlng_grps_tl_rec.description = Okc_Api.G_MISS_CHAR)
2696: THEN
2697: x_okl_cntr_lvlng_grps_tl_rec.description := l_okl_cntr_lvlng_grps_tl_rec.description;
2698: END IF;
2699: IF (x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)
2700: THEN
2701: x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url := l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url;

Line 2699: IF (x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)

2695: IF (x_okl_cntr_lvlng_grps_tl_rec.description = Okc_Api.G_MISS_CHAR)
2696: THEN
2697: x_okl_cntr_lvlng_grps_tl_rec.description := l_okl_cntr_lvlng_grps_tl_rec.description;
2698: END IF;
2699: IF (x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)
2700: THEN
2701: x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url := l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url;
2702: END IF;
2703: IF (x_okl_cntr_lvlng_grps_tl_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2701: x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url := l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url;

2697: x_okl_cntr_lvlng_grps_tl_rec.description := l_okl_cntr_lvlng_grps_tl_rec.description;
2698: END IF;
2699: IF (x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)
2700: THEN
2701: x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url := l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url;
2702: END IF;
2703: IF (x_okl_cntr_lvlng_grps_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2704: THEN
2705: x_okl_cntr_lvlng_grps_tl_rec.created_by := l_okl_cntr_lvlng_grps_tl_rec.created_by;

Line 2703: IF (x_okl_cntr_lvlng_grps_tl_rec.created_by = Okc_Api.G_MISS_NUM)

2699: IF (x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)
2700: THEN
2701: x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url := l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url;
2702: END IF;
2703: IF (x_okl_cntr_lvlng_grps_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2704: THEN
2705: x_okl_cntr_lvlng_grps_tl_rec.created_by := l_okl_cntr_lvlng_grps_tl_rec.created_by;
2706: END IF;
2707: IF (x_okl_cntr_lvlng_grps_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2705: x_okl_cntr_lvlng_grps_tl_rec.created_by := l_okl_cntr_lvlng_grps_tl_rec.created_by;

2701: x_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url := l_okl_cntr_lvlng_grps_tl_rec.private_label_logo_url;
2702: END IF;
2703: IF (x_okl_cntr_lvlng_grps_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2704: THEN
2705: x_okl_cntr_lvlng_grps_tl_rec.created_by := l_okl_cntr_lvlng_grps_tl_rec.created_by;
2706: END IF;
2707: IF (x_okl_cntr_lvlng_grps_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2708: THEN
2709: x_okl_cntr_lvlng_grps_tl_rec.creation_date := l_okl_cntr_lvlng_grps_tl_rec.creation_date;

Line 2707: IF (x_okl_cntr_lvlng_grps_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

2703: IF (x_okl_cntr_lvlng_grps_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2704: THEN
2705: x_okl_cntr_lvlng_grps_tl_rec.created_by := l_okl_cntr_lvlng_grps_tl_rec.created_by;
2706: END IF;
2707: IF (x_okl_cntr_lvlng_grps_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2708: THEN
2709: x_okl_cntr_lvlng_grps_tl_rec.creation_date := l_okl_cntr_lvlng_grps_tl_rec.creation_date;
2710: END IF;
2711: IF (x_okl_cntr_lvlng_grps_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2709: x_okl_cntr_lvlng_grps_tl_rec.creation_date := l_okl_cntr_lvlng_grps_tl_rec.creation_date;

2705: x_okl_cntr_lvlng_grps_tl_rec.created_by := l_okl_cntr_lvlng_grps_tl_rec.created_by;
2706: END IF;
2707: IF (x_okl_cntr_lvlng_grps_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2708: THEN
2709: x_okl_cntr_lvlng_grps_tl_rec.creation_date := l_okl_cntr_lvlng_grps_tl_rec.creation_date;
2710: END IF;
2711: IF (x_okl_cntr_lvlng_grps_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2712: THEN
2713: x_okl_cntr_lvlng_grps_tl_rec.last_updated_by := l_okl_cntr_lvlng_grps_tl_rec.last_updated_by;

Line 2711: IF (x_okl_cntr_lvlng_grps_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2707: IF (x_okl_cntr_lvlng_grps_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2708: THEN
2709: x_okl_cntr_lvlng_grps_tl_rec.creation_date := l_okl_cntr_lvlng_grps_tl_rec.creation_date;
2710: END IF;
2711: IF (x_okl_cntr_lvlng_grps_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2712: THEN
2713: x_okl_cntr_lvlng_grps_tl_rec.last_updated_by := l_okl_cntr_lvlng_grps_tl_rec.last_updated_by;
2714: END IF;
2715: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2713: x_okl_cntr_lvlng_grps_tl_rec.last_updated_by := l_okl_cntr_lvlng_grps_tl_rec.last_updated_by;

2709: x_okl_cntr_lvlng_grps_tl_rec.creation_date := l_okl_cntr_lvlng_grps_tl_rec.creation_date;
2710: END IF;
2711: IF (x_okl_cntr_lvlng_grps_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2712: THEN
2713: x_okl_cntr_lvlng_grps_tl_rec.last_updated_by := l_okl_cntr_lvlng_grps_tl_rec.last_updated_by;
2714: END IF;
2715: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2716: THEN
2717: x_okl_cntr_lvlng_grps_tl_rec.last_update_date := l_okl_cntr_lvlng_grps_tl_rec.last_update_date;

Line 2715: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

2711: IF (x_okl_cntr_lvlng_grps_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2712: THEN
2713: x_okl_cntr_lvlng_grps_tl_rec.last_updated_by := l_okl_cntr_lvlng_grps_tl_rec.last_updated_by;
2714: END IF;
2715: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2716: THEN
2717: x_okl_cntr_lvlng_grps_tl_rec.last_update_date := l_okl_cntr_lvlng_grps_tl_rec.last_update_date;
2718: END IF;
2719: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2717: x_okl_cntr_lvlng_grps_tl_rec.last_update_date := l_okl_cntr_lvlng_grps_tl_rec.last_update_date;

2713: x_okl_cntr_lvlng_grps_tl_rec.last_updated_by := l_okl_cntr_lvlng_grps_tl_rec.last_updated_by;
2714: END IF;
2715: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2716: THEN
2717: x_okl_cntr_lvlng_grps_tl_rec.last_update_date := l_okl_cntr_lvlng_grps_tl_rec.last_update_date;
2718: END IF;
2719: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2720: THEN
2721: x_okl_cntr_lvlng_grps_tl_rec.last_update_login := l_okl_cntr_lvlng_grps_tl_rec.last_update_login;

Line 2719: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

2715: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2716: THEN
2717: x_okl_cntr_lvlng_grps_tl_rec.last_update_date := l_okl_cntr_lvlng_grps_tl_rec.last_update_date;
2718: END IF;
2719: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2720: THEN
2721: x_okl_cntr_lvlng_grps_tl_rec.last_update_login := l_okl_cntr_lvlng_grps_tl_rec.last_update_login;
2722: END IF;
2723: RETURN(l_return_status);

Line 2721: x_okl_cntr_lvlng_grps_tl_rec.last_update_login := l_okl_cntr_lvlng_grps_tl_rec.last_update_login;

2717: x_okl_cntr_lvlng_grps_tl_rec.last_update_date := l_okl_cntr_lvlng_grps_tl_rec.last_update_date;
2718: END IF;
2719: IF (x_okl_cntr_lvlng_grps_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2720: THEN
2721: x_okl_cntr_lvlng_grps_tl_rec.last_update_login := l_okl_cntr_lvlng_grps_tl_rec.last_update_login;
2722: END IF;
2723: RETURN(l_return_status);
2724: END populate_new_record;
2725: -----------------------------------------------

Line 2726: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --

2722: END IF;
2723: RETURN(l_return_status);
2724: END populate_new_record;
2725: -----------------------------------------------
2726: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
2727: -----------------------------------------------
2728: FUNCTION Set_Attributes (
2729: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
2730: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType

Line 2729: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,

2725: -----------------------------------------------
2726: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
2727: -----------------------------------------------
2728: FUNCTION Set_Attributes (
2729: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
2730: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
2731: ) RETURN VARCHAR2 IS
2732: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2733: BEGIN

Line 2730: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType

2726: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
2727: -----------------------------------------------
2728: FUNCTION Set_Attributes (
2729: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
2730: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
2731: ) RETURN VARCHAR2 IS
2732: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2733: BEGIN
2734: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;

Line 2734: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;

2730: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
2731: ) RETURN VARCHAR2 IS
2732: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2733: BEGIN
2734: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
2735: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');
2736: x_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG := USERENV('LANG');
2737: RETURN(l_return_status);
2738: END Set_Attributes;

Line 2735: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');

2731: ) RETURN VARCHAR2 IS
2732: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2733: BEGIN
2734: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
2735: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');
2736: x_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG := USERENV('LANG');
2737: RETURN(l_return_status);
2738: END Set_Attributes;
2739: BEGIN

Line 2736: x_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG := USERENV('LANG');

2732: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2733: BEGIN
2734: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
2735: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');
2736: x_okl_cntr_lvlng_grps_tl_rec.SOURCE_LANG := USERENV('LANG');
2737: RETURN(l_return_status);
2738: END Set_Attributes;
2739: BEGIN
2740: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2751: p_okl_cntr_lvlng_grps_tl_rec, -- IN

2747: RAISE Okc_Api.G_EXCEPTION_ERROR;
2748: END IF;
2749: --- Setting item attributes
2750: l_return_status := Set_Attributes(
2751: p_okl_cntr_lvlng_grps_tl_rec, -- IN
2752: l_okl_cntr_lvlng_grps_tl_rec); -- OUT
2753: --- If any errors happen abort API
2754: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2755: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2752: l_okl_cntr_lvlng_grps_tl_rec); -- OUT

2748: END IF;
2749: --- Setting item attributes
2750: l_return_status := Set_Attributes(
2751: p_okl_cntr_lvlng_grps_tl_rec, -- IN
2752: l_okl_cntr_lvlng_grps_tl_rec); -- OUT
2753: --- If any errors happen abort API
2754: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2755: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2756: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 2759: l_return_status := populate_new_record(l_okl_cntr_lvlng_grps_tl_rec, ldefoklcntrlvlnggrpstlrec);

2755: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2756: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2757: RAISE Okc_Api.G_EXCEPTION_ERROR;
2758: END IF;
2759: l_return_status := populate_new_record(l_okl_cntr_lvlng_grps_tl_rec, ldefoklcntrlvlnggrpstlrec);
2760: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2761: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2762: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2763: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 2765: UPDATE OKL_CNTR_LVLNG_GRPS_TL

2761: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2762: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2763: RAISE Okc_Api.G_EXCEPTION_ERROR;
2764: END IF;
2765: UPDATE OKL_CNTR_LVLNG_GRPS_TL
2766: SET NAME = ldefoklcntrlvlnggrpstlrec.name,
2767: DESCRIPTION = ldefoklcntrlvlnggrpstlrec.description,
2768: PRIVATE_LABEL_LOGO_URL = ldefoklcntrlvlnggrpstlrec.private_label_logo_url,
2769: CREATED_BY = ldefoklcntrlvlnggrpstlrec.created_by,

Line 2778: UPDATE OKL_CNTR_LVLNG_GRPS_TL

2774: WHERE ID = ldefoklcntrlvlnggrpstlrec.id
2775: --AND SOURCE_LANG = USERENV('LANG');
2776: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2777:
2778: UPDATE OKL_CNTR_LVLNG_GRPS_TL
2779: SET SFWT_FLAG = 'Y'
2780: WHERE ID = ldefoklcntrlvlnggrpstlrec.id
2781: AND SOURCE_LANG <> USERENV('LANG');
2782:

Line 2783: x_okl_cntr_lvlng_grps_tl_rec := ldefoklcntrlvlnggrpstlrec;

2779: SET SFWT_FLAG = 'Y'
2780: WHERE ID = ldefoklcntrlvlnggrpstlrec.id
2781: AND SOURCE_LANG <> USERENV('LANG');
2782:
2783: x_okl_cntr_lvlng_grps_tl_rec := ldefoklcntrlvlnggrpstlrec;
2784: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2785: EXCEPTION
2786: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2787: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

Line 2834: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

2830: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2831: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2832: l_clgv_rec clgv_rec_type := p_clgv_rec;
2833: l_def_clgv_rec clgv_rec_type;
2834: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2835: lx_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2836: l_clg_rec clg_rec_type;
2837: lx_clg_rec clg_rec_type;
2838: -------------------------------

Line 2835: lx_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

2831: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2832: l_clgv_rec clgv_rec_type := p_clgv_rec;
2833: l_def_clgv_rec clgv_rec_type;
2834: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2835: lx_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
2836: l_clg_rec clg_rec_type;
2837: lx_clg_rec clg_rec_type;
2838: -------------------------------
2839: -- FUNCTION fill_who_columns --

Line 3085: migrate(l_def_clgv_rec, l_okl_cntr_lvlng_grps_tl_rec);

3081:
3082: --------------------------------------
3083: -- Move VIEW record to "Child" records
3084: --------------------------------------
3085: migrate(l_def_clgv_rec, l_okl_cntr_lvlng_grps_tl_rec);
3086: migrate(l_def_clgv_rec, l_clg_rec);
3087: --------------------------------------------
3088: -- Call the UPDATE_ROW for each child record
3089: --------------------------------------------

Line 3095: l_okl_cntr_lvlng_grps_tl_rec,

3091: p_init_msg_list,
3092: x_return_status,
3093: x_msg_count,
3094: x_msg_data,
3095: l_okl_cntr_lvlng_grps_tl_rec,
3096: lx_okl_cntr_lvlng_grps_tl_rec
3097: );
3098: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3096: lx_okl_cntr_lvlng_grps_tl_rec

3092: x_return_status,
3093: x_msg_count,
3094: x_msg_data,
3095: l_okl_cntr_lvlng_grps_tl_rec,
3096: lx_okl_cntr_lvlng_grps_tl_rec
3097: );
3098: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3100: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 3103: migrate(lx_okl_cntr_lvlng_grps_tl_rec, l_def_clgv_rec);

3099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3100: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3101: RAISE Okc_Api.G_EXCEPTION_ERROR;
3102: END IF;
3103: migrate(lx_okl_cntr_lvlng_grps_tl_rec, l_def_clgv_rec);
3104: update_row(
3105: p_init_msg_list,
3106: x_return_status,
3107: x_msg_count,

Line 3284: -- delete_row for:OKL_CNTR_LVLNG_GRPS_TL --

3280: '_PVT'
3281: );
3282: END delete_row;
3283: -------------------------------------------
3284: -- delete_row for:OKL_CNTR_LVLNG_GRPS_TL --
3285: -------------------------------------------
3286: PROCEDURE delete_row(
3287: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3288: x_return_status OUT NOCOPY VARCHAR2,

Line 3291: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS

3287: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3288: x_return_status OUT NOCOPY VARCHAR2,
3289: x_msg_count OUT NOCOPY NUMBER,
3290: x_msg_data OUT NOCOPY VARCHAR2,
3291: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType) IS
3292:
3293: l_api_version CONSTANT NUMBER := 1;
3294: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3295: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 3296: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType:= p_okl_cntr_lvlng_grps_tl_rec;

3292:
3293: l_api_version CONSTANT NUMBER := 1;
3294: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3295: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3296: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType:= p_okl_cntr_lvlng_grps_tl_rec;
3297: l_row_notfound BOOLEAN := TRUE;
3298: -----------------------------------------------
3299: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
3300: -----------------------------------------------

Line 3299: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --

3295: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3296: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType:= p_okl_cntr_lvlng_grps_tl_rec;
3297: l_row_notfound BOOLEAN := TRUE;
3298: -----------------------------------------------
3299: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
3300: -----------------------------------------------
3301: FUNCTION Set_Attributes (
3302: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
3303: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType

Line 3302: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,

3298: -----------------------------------------------
3299: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
3300: -----------------------------------------------
3301: FUNCTION Set_Attributes (
3302: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
3303: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
3304: ) RETURN VARCHAR2 IS
3305: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3306: BEGIN

Line 3303: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType

3299: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_TL --
3300: -----------------------------------------------
3301: FUNCTION Set_Attributes (
3302: p_okl_cntr_lvlng_grps_tl_rec IN OklCntrLvlngGrpsTlRecType,
3303: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
3304: ) RETURN VARCHAR2 IS
3305: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3306: BEGIN
3307: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;

Line 3307: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;

3303: x_okl_cntr_lvlng_grps_tl_rec OUT NOCOPY OklCntrLvlngGrpsTlRecType
3304: ) RETURN VARCHAR2 IS
3305: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3306: BEGIN
3307: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
3308: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');
3309: RETURN(l_return_status);
3310: END Set_Attributes;
3311: BEGIN

Line 3308: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');

3304: ) RETURN VARCHAR2 IS
3305: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3306: BEGIN
3307: x_okl_cntr_lvlng_grps_tl_rec := p_okl_cntr_lvlng_grps_tl_rec;
3308: x_okl_cntr_lvlng_grps_tl_rec.LANGUAGE := USERENV('LANG');
3309: RETURN(l_return_status);
3310: END Set_Attributes;
3311: BEGIN
3312: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 3323: p_okl_cntr_lvlng_grps_tl_rec, -- IN

3319: RAISE Okc_Api.G_EXCEPTION_ERROR;
3320: END IF;
3321: --- Setting item attributes
3322: l_return_status := Set_Attributes(
3323: p_okl_cntr_lvlng_grps_tl_rec, -- IN
3324: l_okl_cntr_lvlng_grps_tl_rec); -- OUT
3325: --- If any errors happen abort API
3326: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3327: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3324: l_okl_cntr_lvlng_grps_tl_rec); -- OUT

3320: END IF;
3321: --- Setting item attributes
3322: l_return_status := Set_Attributes(
3323: p_okl_cntr_lvlng_grps_tl_rec, -- IN
3324: l_okl_cntr_lvlng_grps_tl_rec); -- OUT
3325: --- If any errors happen abort API
3326: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3327: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3328: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 3331: DELETE FROM OKL_CNTR_LVLNG_GRPS_TL

3327: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3328: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3329: RAISE Okc_Api.G_EXCEPTION_ERROR;
3330: END IF;
3331: DELETE FROM OKL_CNTR_LVLNG_GRPS_TL
3332: WHERE ID = l_okl_cntr_lvlng_grps_tl_rec.id;
3333:
3334: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3335: EXCEPTION

Line 3332: WHERE ID = l_okl_cntr_lvlng_grps_tl_rec.id;

3328: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3329: RAISE Okc_Api.G_EXCEPTION_ERROR;
3330: END IF;
3331: DELETE FROM OKL_CNTR_LVLNG_GRPS_TL
3332: WHERE ID = l_okl_cntr_lvlng_grps_tl_rec.id;
3333:
3334: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3335: EXCEPTION
3336: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 3382: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;

3378: l_api_version CONSTANT NUMBER := 1;
3379: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3380: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3381: l_clgv_rec clgv_rec_type := p_clgv_rec;
3382: l_okl_cntr_lvlng_grps_tl_rec OklCntrLvlngGrpsTlRecType;
3383: l_clg_rec clg_rec_type;
3384: BEGIN
3385: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3386: G_PKG_NAME,

Line 3400: migrate(l_clgv_rec, l_okl_cntr_lvlng_grps_tl_rec);

3396: END IF;
3397: --------------------------------------
3398: -- Move VIEW record to "Child" records
3399: --------------------------------------
3400: migrate(l_clgv_rec, l_okl_cntr_lvlng_grps_tl_rec);
3401: migrate(l_clgv_rec, l_clg_rec);
3402: --------------------------------------------
3403: -- Call the DELETE_ROW for each child record
3404: --------------------------------------------

Line 3410: l_okl_cntr_lvlng_grps_tl_rec

3406: p_init_msg_list,
3407: x_return_status,
3408: x_msg_count,
3409: x_msg_data,
3410: l_okl_cntr_lvlng_grps_tl_rec
3411: );
3412: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3413: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3414: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN