[Home] [Help]
2: /* $Header: OKCSCNLB.pls 120.0 2005/05/25 23:14:37 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: l_lang VARCHAR2(12) := okc_util.get_userenv_lang;
7: ---------------------------------------------------------------------------
8: -- FUNCTION get_seq_id
9: ---------------------------------------------------------------------------
10: FUNCTION get_seq_id RETURN NUMBER IS
2791: OPEN cnl_cur;
2792: FETCH cnl_cur INTO l_cnl_rec;
2793: IF cnl_cur%FOUND THEN
2794: OKC_API.SET_MESSAGE(p_app_name => g_app_name
2795: ,p_msg_name => OKC_UTIL.g_unq
2796: ,p_token1 => g_col_name_token
2797: ,p_token1_value => 'sortseq');
2798: -- notify caller of an error
2799: l_return_status := OKC_API.G_RET_STS_ERROR;
5199: -- Procedure for mass insert in OKC_CONDITION_LINES _B and TL tables
5200: ---------------------------------------------------------------
5201: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_cnlv_tbl cnlv_tbl_type) IS
5202: l_tabsize NUMBER := p_cnlv_tbl.COUNT;
5203: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
5204:
5205: in_id OKC_DATATYPES.NumberTabTyp;
5206: in_object_version_number OKC_DATATYPES.NumberTabTyp;
5207: in_sfwt_flag OKC_DATATYPES.Var3TabTyp;
5393: in_application_id(i),
5394: in_seeded_flag(i)
5395: );
5396:
5397: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
5398: FORALL i in 1..l_tabsize
5399: INSERT INTO OKC_CONDITION_LINES_TL(
5400: id,
5401: language,
5409: last_update_login
5410: )
5411: VALUES (
5412: in_id(i),
5413: OKC_UTIL.g_language_code(lang_i),
5414: l_source_lang,
5415: in_sfwt_flag(i),
5416: in_description(i),
5417: in_created_by(i),