85: --| OKC_K_LINES_TL | | X | | | | |
86: --+---------------------------------+---+---+---+---+---+----------------------+
87: --| OKS_K_LINES_B | X | X | | | | |
88: --+---------------------------------+---+---+---+---+---+----------------------+
89: --| OKS_K_LINES_TL | | X | | | | |
90: --+---------------------------------+---+---+---+---+---+----------------------+
91: --| OKS_BILLING_PROFILES_B | X | | | | | |
92: --+---------------------------------+---+---+---+---+---+----------------------+
93: --| OKS_BILL_SCH | | | | | |X |
3653: FOR lang_i IN
3654: okc_util.g_language_code.FIRST .. okc_util.g_language_code.LAST
3655: LOOP
3656: FORALL i IN 1 .. l_tabsize
3657: INSERT INTO oks_k_lines_tl
3658: (ID,
3659: LANGUAGE,
3660: source_lang,
3661: sfwt_flag,
4132: FOR lang_i IN
4133: okc_util.g_language_code.FIRST .. okc_util.g_language_code.LAST
4134: LOOP
4135: FORALL i IN 1 .. l_tabsize
4136: INSERT INTO oks_k_lines_tl
4137: (ID,
4138: LANGUAGE,
4139: source_lang,
4140: sfwt_flag,
4165: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4166: THEN
4167: fnd_log.STRING (fnd_log.level_event,
4168: g_module_current || 'oks_mass_update.create_contract_Line',
4169: 'after insert into oks_k_lines_tl table');
4170: END IF;
4171:
4172:
4173:
8050: Close l_subline_invtext_csr;
8051:
8052: IF sub_line_id.COUNT > 0 THEN -- Added for Bug#14183916
8053: Forall i in 1..sub_line_id.count
8054: UPDATE oks_k_lines_tl klt
8055: SET invoice_text = inv_text(i),
8056: last_updated_by = fnd_global.user_id,
8057: last_update_date = SYSDATE,
8058: last_update_login = fnd_global.login_id
8089: inv_text;
8090: Close l_invoice_text_csr;
8091:
8092: Forall i in 1..top_line_id.count
8093: UPDATE oks_k_lines_tl
8094: SET invoice_text = inv_text(i),
8095: last_updated_by = fnd_global.user_id,
8096: last_update_date = SYSDATE,
8097: last_update_login = fnd_global.login_id