DBA Data[Home] [Help]

APPS.OKC_CHR_PVT dependencies on OKC_UTIL

Line 1781: x_return_status := OKC_UTIL.check_lookup_code('OKC_TERMINATION_REASON',

1777: IF (p_chrv_rec.trn_code <> OKC_API.G_MISS_CHAR AND
1778: p_chrv_rec.trn_code IS NOT NULL)
1779: THEN
1780: -- Check if the value is a valid code from lookup table
1781: x_return_status := OKC_UTIL.check_lookup_code('OKC_TERMINATION_REASON',
1782: p_chrv_rec.trn_code);
1783: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1784: --set error message in message stack
1785: OKC_API.SET_MESSAGE(

Line 1931: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',

1927: IF (p_chrv_rec.orig_system_source_code <> OKC_API.G_MISS_CHAR AND
1928: p_chrv_rec.orig_system_source_code IS NOT NULL)
1929: THEN
1930: -- Check if the value is a valid code from lookup table
1931: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',
1932: p_chrv_rec.orig_system_source_code);
1933: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1934: --set error message in message stack
1935: OKC_API.SET_MESSAGE(

Line 2140: x_return_status := OKC_UTIL.check_lookup_code('OKC_RENEWAL_TYPE',

2136: IF (p_chrv_rec.renewal_type_code <> OKC_API.G_MISS_CHAR AND
2137: p_chrv_rec.renewal_type_code IS NOT NULL)
2138: THEN
2139: -- Check if the value is a valid code from lookup table
2140: x_return_status := OKC_UTIL.check_lookup_code('OKC_RENEWAL_TYPE',
2141: p_chrv_rec.renewal_type_code);
2142:
2143: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2144: --set error message in message stack

Line 2210: x_return_status := OKC_UTIL.check_lookup_code('OKS_RENEWAL_TYPE',

2206: IF (p_chrv_rec.renewal_type_code <> OKC_API.G_MISS_CHAR AND
2207: p_chrv_rec.renewal_type_code IS NOT NULL)
2208: THEN
2209: -- Check if the value is a valid code from lookup table
2210: x_return_status := OKC_UTIL.check_lookup_code('OKS_RENEWAL_TYPE',
2211: p_chrv_rec.renewal_type_code);
2212:
2213: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2214: --set error message in message stack

Line 5120: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

5116: okc_debug.LOG('14200: Entered Set_Attributes', 2);
5117: END IF;
5118:
5119: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
5120: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5121: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5122: RETURN(l_return_status);
5123:
5124: END Set_Attributes;

Line 5121: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

5117: END IF;
5118:
5119: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
5120: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5121: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5122: RETURN(l_return_status);
5123:
5124: END Set_Attributes;
5125: BEGIN

Line 6920: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

6916: okc_debug.LOG('19400: Entered Set_Attributes', 2);
6917: END IF;
6918:
6919: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6920: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6921: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6922: RETURN(l_return_status);
6923:
6924: END Set_Attributes;

Line 6921: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

6917: END IF;
6918:
6919: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6920: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6921: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6922: RETURN(l_return_status);
6923:
6924: END Set_Attributes;
6925: BEGIN

Line 7949: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

7945: okc_debug.LOG('21800: Entered Set_Attributes', 2);
7946: END IF;
7947:
7948: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
7949: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
7950: RETURN(l_return_status);
7951:
7952: END Set_Attributes;
7953: BEGIN

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

8301: -- Procedure for mass insert in OKC_K_HEADERS _B and TL tables
8302: ---------------------------------------------------------------
8303: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_chrv_tbl chrv_tbl_type) IS
8304: l_tabsize NUMBER := p_chrv_tbl.COUNT;
8305: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
8306:
8307: in_id OKC_DATATYPES.NumberTabTyp;
8308: in_object_version_number OKC_DATATYPES.NumberTabTyp;
8309: in_sfwt_flag OKC_DATATYPES.Var3TabTyp;

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

8775: in_payment_instruction_type(i)
8776: -- R12 Data Model Changes 4485150 End
8777: );
8778:
8779: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
8780: FORALL i IN 1..l_tabsize
8781: INSERT INTO OKC_K_HEADERS_TL(
8782: id,
8783: language,

Line 8801: OKC_UTIL.g_language_code(lang_i),

8797: last_update_login
8798: )
8799: VALUES (
8800: in_id(i),
8801: OKC_UTIL.g_language_code(lang_i),
8802: l_source_lang,
8803: in_sfwt_flag(i),
8804: in_short_description(i),
8805: in_comments(i),