APPS.OKC_CAT_PVT dependencies on OKC_UTIL

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

719: x_return_status := OKC_API.G_RET_STS_SUCCESS;
720: if (p_catv_rec.sbt_code is NULL or p_catv_rec.sbt_code = OKC_API.G_MISS_CHAR) then
721: return;
722: end if;
723: x_return_status := OKC_UTIL.check_lookup_code('OKC_SUBJECT',p_catv_rec.sbt_code);
724: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
725: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SBT_CODE');
726: x_return_status := OKC_API.G_RET_STS_ERROR;
727: end if;

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

1863: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1864: BEGIN
1865:
1866: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1867: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1868: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1869: RETURN(l_return_status);
1870:
1871: END Set_Attributes;

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

1864: BEGIN
1865:
1866: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
1867: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1868: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1869: RETURN(l_return_status);
1870:
1871: END Set_Attributes;
1872: BEGIN

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

3236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3237: BEGIN
3238:
3239: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3240: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3241: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
3242: RETURN(l_return_status);
3243:
3244: END Set_Attributes;

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

3237: BEGIN
3238:
3239: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3240: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3241: x_okc_k_articles_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
3242: RETURN(l_return_status);
3243:
3244: END Set_Attributes;
3245: BEGIN

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

3958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3959: BEGIN
3960:
3961: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;
3962: x_okc_k_articles_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3963: RETURN(l_return_status);
3964:
3965: END Set_Attributes;
3966: BEGIN

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

4276: -- Procedure for mass insert in OKC_K_ARTICLES _B and TL tables
4277: ---------------------------------------------------------------
4278: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_catv_tbl catv_tbl_type) IS
4279: l_tabsize NUMBER := p_catv_tbl.COUNT;
4280: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
4281:
4282: in_id OKC_DATATYPES.NumberTabTyp;
4283: in_chr_id OKC_DATATYPES.NumberTabTyp;
4284: in_cle_id OKC_DATATYPES.NumberTabTyp;

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

4441: in_attribute15(i)
4442: -- REMOVE comma from the previous line
4443: );
4444:
4445: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
4446: FORALL i in 1..l_tabsize
4447: INSERT INTO OKC_K_ARTICLES_TL(
4448: id,
4449: language,

Line 4467: OKC_UTIL.g_language_code(lang_i),

4463: -- REMOVE comma from the previous line
4464: )
4465: VALUES (
4466: in_id(i),
4467: OKC_UTIL.g_language_code(lang_i),
4468: l_source_lang,
4469: in_sfwt_flag(i),
4470: in_object_version_number(i),
4471: in_comments(i),