[Home] [Help]
472: p_klnv_tbl IN klnv_tbl_type) IS
473:
474:
475: l_tabsize NUMBER := p_klnv_tbl.COUNT;
476: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
477: in_id OKC_DATATYPES.NumberTabTyp;
478: in_cle_id OKC_DATATYPES.NumberTabTyp;
479: in_dnz_chr_id OKC_DATATYPES.NumberTabTyp;
480: in_discount_list OKC_DATATYPES.NumberTabTyp;
869: in_revenue_Impact_Date(i),
870: in_counter_value_id(i)
871: );
872:
873: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
874: FORALL i in 1..l_tabsize
875: INSERT INTO OKS_K_LINES_TL(
876: id,
877: language,
888: last_update_date,
889: last_update_login)
890: VALUES (
891: in_id(i),
892: OKC_UTIL.g_language_code(lang_i),
893: in_source_lang(i),
894: in_sfwt_flag(i),
895: in_invoice_text(i),
896: in_ib_trx_details(i),
928: PROCEDURE CREATE_LINE_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
929: p_klnhv_tbl IN klnhv_tbl_type) IS
930:
931: l_tabsize NUMBER := p_klnhv_tbl.COUNT;
932: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
933: in_id OKC_DATATYPES.NumberTabTyp;
934: in_cle_id OKC_DATATYPES.NumberTabTyp;
935: in_dnz_chr_id OKC_DATATYPES.NumberTabTyp;
936: in_discount_list OKC_DATATYPES.NumberTabTyp;
1332: in_revenue_Impact_Date(i),
1333: in_counter_value_id(i)
1334: );
1335:
1336: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
1337: FORALL i in 1..l_tabsize
1338: Insert Into oks_k_lines_tlh
1339: (
1340: id ,
1354: last_update_login
1355: ) Values (
1356: in_id (i),
1357: in_major_version(i),
1358: OKC_UTIL.g_language_code(lang_i),
1359: in_source_lang (i),
1360: in_sfwt_flag (i),
1361: in_invoice_text (i),
1362: in_ib_trx_details (i),