APPS.OKC_SCN_PVT dependencies on OKC_UTIL

Line 1180: -- l_unq_tbl OKC_UTIL.unq_tbl_type;

1176: FUNCTION Validate_Record (
1177: p_scnv_rec IN scnv_rec_type
1178: ) RETURN VARCHAR2 IS
1179: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1180: -- l_unq_tbl OKC_UTIL.unq_tbl_type;
1181:
1182: -- ------------------------------------------------------
1183: -- To check for any matching row, for unique check
1184: -- The cursor includes id check filter to handle updates

Line 1219: -- OKC_UTIL.check_comp_unique call earlier was not using

1215:
1216:
1217: -- ---------------------------------------------------------------------
1218: -- Bug 1636056 related changes - Shyam
1219: -- OKC_UTIL.check_comp_unique call earlier was not using
1220: -- the bind variables and parses everytime, replaced with
1221: -- the explicit cursors above, for identical function to
1222: -- check uniqueness for CHR_ID + SAT_CODE + SECTION_SEQUENCE
1223: -- chr_id and sat_code are mutually exclusive (in actual values)

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 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 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