eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CLE_PVT dependencies on OKC_UTIL

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

486: If (p_clev_rec.trn_code <> OKC_API.G_MISS_CHAR and
487: p_clev_rec.trn_code IS NOT NULL)
488: Then
489: -- Check if the value is a valid code from lookup table
490: x_return_status := OKC_UTIL.check_lookup_code('OKC_TERMINATION_REASON',
491: p_clev_rec.trn_code);
492: If (x_return_status = OKC_API.G_RET_STS_ERROR) Then
493: --set error message in message stack
494: OKC_API.SET_MESSAGE(

Line 914: x_return_status:=OKC_UTIL.check_lookup_code('OKC_PRICE_TYPE',p_clev_rec.price_type);

910: If (p_clev_rec.price_type <> OKC_API.G_MISS_CHAR and
911: p_clev_rec.price_type IS NOT NULL)
912: Then
913: -- Check if the value is a valid code from lookup table
914: x_return_status:=OKC_UTIL.check_lookup_code('OKC_PRICE_TYPE',p_clev_rec.price_type);
915: If (x_return_status = OKC_API.G_RET_STS_ERROR) Then
916: --set error message in message stack
917: OKC_API.SET_MESSAGE(
918: p_app_name => G_APP_NAME,

Line 1419: x_return_status := OKC_UTIL.check_lookup_code('OKC_LINE_RENEWAL_TYPE',

1415: If (p_clev_rec.line_renewal_type_code <> OKC_API.G_MISS_CHAR or
1416: p_clev_rec.line_renewal_type_code IS NOT NULL)
1417: Then
1418: -- Check if the value is a valid code from lookup table
1419: x_return_status := OKC_UTIL.check_lookup_code('OKC_LINE_RENEWAL_TYPE',
1420: p_clev_rec.line_renewal_type_code);
1421:
1422: If (x_return_status = OKC_API.G_RET_STS_ERROR) Then
1423: --set error message in message stack

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

1697: If (p_clev_rec.orig_system_source_code <> OKC_API.G_MISS_CHAR and
1698: p_clev_rec.orig_system_source_code IS NOT NULL)
1699: Then
1700: -- Check if the value is a valid code from lookup table
1701: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',
1702: p_clev_rec.orig_system_source_code);
1703: If (x_return_status = OKC_API.G_RET_STS_ERROR) Then
1704: --set error message in message stack
1705: OKC_API.SET_MESSAGE(

Line 5231: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

5227: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5228: BEGIN
5229:
5230: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
5231: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5232: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5233:
5234: RETURN(l_return_status);
5235:

Line 5232: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

5228: BEGIN
5229:
5230: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
5231: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5232: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5233:
5234: RETURN(l_return_status);
5235:
5236: END Set_Attributes;

Line 6985: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

6981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6982: BEGIN
6983:
6984: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
6985: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6986: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6987:
6988: RETURN(l_return_status);
6989:

Line 6986: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

6982: BEGIN
6983:
6984: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
6985: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6986: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6987:
6988: RETURN(l_return_status);
6989:
6990: END Set_Attributes;

Line 7962: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

7958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7959: BEGIN
7960:
7961: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
7962: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
7963: RETURN(l_return_status);
7964:
7965: END Set_Attributes;
7966: BEGIN

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

8690: -- Procedure for mass insert in OKC_K_LINES _B and TL tables
8691: ---------------------------------------------------------------
8692: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_clev_tbl clev_tbl_type) IS
8693: l_tabsize NUMBER := p_clev_tbl.COUNT;
8694: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
8695:
8696: in_id OKC_DATATYPES.NumberTabTyp;
8697: in_object_version_number OKC_DATATYPES.NumberTabTyp;
8698: in_sfwt_flag OKC_DATATYPES.Var3TabTyp;

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

9149: in_cancelled_amount(i)
9150: /*** R12 data model Changes 27072005 to be checked End***/
9151: );
9152:
9153: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
9154: FORALL i in 1..l_tabsize
9155: INSERT INTO OKC_K_LINES_TL(
9156: id,
9157: language,

Line 9174: OKC_UTIL.g_language_code(lang_i),

9170: last_update_login
9171: )
9172: VALUES (
9173: in_id(i),
9174: OKC_UTIL.g_language_code(lang_i),
9175: l_source_lang,
9176: in_sfwt_flag(i),
9177: in_name(i),
9178: in_comments(i),