APPS.OKL_VP_CAT_PVT dependencies on OKC_UTIL

Line 548: x_return_status := OKC_UTIL.check_lookup_code('OKC_SUBJECT',p_catv_rec.sbt_code);

544: x_return_status := OKC_API.G_RET_STS_SUCCESS;
545: if (p_catv_rec.sbt_code is NULL or p_catv_rec.sbt_code = OKC_API.G_MISS_CHAR) then
546: return;
547: end if;
548: x_return_status := OKC_UTIL.check_lookup_code('OKC_SUBJECT',p_catv_rec.sbt_code);
549: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
550: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SBT_CODE');
551: x_return_status := OKC_API.G_RET_STS_ERROR;
552: end if;

Line 1745: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1741: ) RETURN VARCHAR2 IS
1742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1743: BEGIN
1744: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1745: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1746: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1747: RETURN(l_return_status);
1748: END Set_Attributes;
1749: BEGIN

Line 1746: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1743: BEGIN
1744: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1745: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1746: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1747: RETURN(l_return_status);
1748: END Set_Attributes;
1749: BEGIN
1750: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2810: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2806: ) RETURN VARCHAR2 IS
2807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2808: BEGIN
2809: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2810: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2811: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2812: RETURN(l_return_status);
2813: END Set_Attributes;
2814: BEGIN

Line 2811: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

2807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2808: BEGIN
2809: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
2810: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2811: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2812: RETURN(l_return_status);
2813: END Set_Attributes;
2814: BEGIN
2815: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3390: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

3386: ) RETURN VARCHAR2 IS
3387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3388: BEGIN
3389: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3390: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3391: RETURN(l_return_status);
3392: END Set_Attributes;
3393: BEGIN
3394: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3614: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

3610: -- Procedure for mass insert in OKC_K_ARTICLES _B and TL tables
3611: ---------------------------------------------------------------
3612: PROCEDURE INSERT_ROW_UPG(p_catv_tbl catv_tbl_type) IS
3613: l_tabsize NUMBER := p_catv_tbl.COUNT;
3614: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
3615:
3616: in_id OKC_DATATYPES.NumberTabTyp;
3617: in_chr_id OKC_DATATYPES.NumberTabTyp;
3618: in_cle_id OKC_DATATYPES.NumberTabTyp;

Line 3772: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP

3768: in_attribute15(i)
3769: -- REMOVE comma from the previous line
3770: );
3771:
3772: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3773: FORALL i in 1..l_tabsize
3774: INSERT INTO OKC_K_ARTICLES_TL(
3775: id,
3776: language,

Line 3794: OKC_UTIL.g_language_code(lang_i),

3790: -- REMOVE comma from the previous line
3791: )
3792: VALUES (
3793: in_id(i),
3794: OKC_UTIL.g_language_code(lang_i),
3795: l_source_lang,
3796: in_sfwt_flag(i),
3797: in_object_version_number(i),
3798: in_comments(i),