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 5115: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

5111: okc_debug.LOG('14200: Entered Set_Attributes', 2);
5112: END IF;
5113:
5114: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
5115: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5116: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5117: RETURN(l_return_status);
5118:
5119: END Set_Attributes;

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

5112: END IF;
5113:
5114: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
5115: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5116: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5117: RETURN(l_return_status);
5118:
5119: END Set_Attributes;
5120: BEGIN

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

6900: okc_debug.LOG('19400: Entered Set_Attributes', 2);
6901: END IF;
6902:
6903: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6904: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6905: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6906: RETURN(l_return_status);
6907:
6908: END Set_Attributes;

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

6901: END IF;
6902:
6903: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6904: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6905: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6906: RETURN(l_return_status);
6907:
6908: END Set_Attributes;
6909: BEGIN

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

7929: okc_debug.LOG('21800: Entered Set_Attributes', 2);
7930: END IF;
7931:
7932: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
7933: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
7934: RETURN(l_return_status);
7935:
7936: END Set_Attributes;
7937: BEGIN

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

8285: -- Procedure for mass insert in OKC_K_HEADERS _B and TL tables
8286: ---------------------------------------------------------------
8287: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_chrv_tbl chrv_tbl_type) IS
8288: l_tabsize NUMBER := p_chrv_tbl.COUNT;
8289: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
8290:
8291: in_id OKC_DATATYPES.NumberTabTyp;
8292: in_object_version_number OKC_DATATYPES.NumberTabTyp;
8293: in_sfwt_flag OKC_DATATYPES.Var3TabTyp;

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

8759: in_payment_instruction_type(i)
8760: -- R12 Data Model Changes 4485150 End
8761: );
8762:
8763: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
8764: FORALL i IN 1..l_tabsize
8765: INSERT INTO OKC_K_HEADERS_TL(
8766: id,
8767: language,

Line 8785: OKC_UTIL.g_language_code(lang_i),

8781: last_update_login
8782: )
8783: VALUES (
8784: in_id(i),
8785: OKC_UTIL.g_language_code(lang_i),
8786: l_source_lang,
8787: in_sfwt_flag(i),
8788: in_short_description(i),
8789: in_comments(i),