APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_K_LINES_TL

Line 4692: --update the oks_k_lines_tl for the toplines

4688: END IF;
4689:
4690: END LOOP;
4691:
4692: --update the oks_k_lines_tl for the toplines
4693: FORALL j in l_sl_id_tbl.first..l_sl_id_tbl.last
4694: UPDATE oks_k_lines_tl
4695: SET invoice_text = l_inv_txt_tbl(j)
4696: WHERE id = l_sl_id_tbl(j) AND language = USERENV('LANG');

Line 4694: UPDATE oks_k_lines_tl

4690: END LOOP;
4691:
4692: --update the oks_k_lines_tl for the toplines
4693: FORALL j in l_sl_id_tbl.first..l_sl_id_tbl.last
4694: UPDATE oks_k_lines_tl
4695: SET invoice_text = l_inv_txt_tbl(j)
4696: WHERE id = l_sl_id_tbl(j) AND language = USERENV('LANG');
4697:
4698: l_line_tbl.delete;

Line 4756: --update the oks_k_lines_tl for the sublines using toplines inv txt

4752: END IF;
4753:
4754: END LOOP;
4755:
4756: --update the oks_k_lines_tl for the sublines using toplines inv txt
4757: FORALL j in l_sl_id_tbl.first..l_sl_id_tbl.last
4758: UPDATE oks_k_lines_tl c
4759: SET c.invoice_text =
4760: (SELECT SUBSTR(a.invoice_text,1, decode(INSTR(a.invoice_text, ':'),0,

Line 4758: UPDATE oks_k_lines_tl c

4754: END LOOP;
4755:
4756: --update the oks_k_lines_tl for the sublines using toplines inv txt
4757: FORALL j in l_sl_id_tbl.first..l_sl_id_tbl.last
4758: UPDATE oks_k_lines_tl c
4759: SET c.invoice_text =
4760: (SELECT SUBSTR(a.invoice_text,1, decode(INSTR(a.invoice_text, ':'),0,
4761: LENGTH(a.invoice_text), INSTR(a.invoice_text, ':'))) ||l_inv_txt_tbl(j)
4762: FROM oks_k_lines_tl a, oks_k_lines_b b

Line 4762: FROM oks_k_lines_tl a, oks_k_lines_b b

4758: UPDATE oks_k_lines_tl c
4759: SET c.invoice_text =
4760: (SELECT SUBSTR(a.invoice_text,1, decode(INSTR(a.invoice_text, ':'),0,
4761: LENGTH(a.invoice_text), INSTR(a.invoice_text, ':'))) ||l_inv_txt_tbl(j)
4762: FROM oks_k_lines_tl a, oks_k_lines_b b
4763: WHERE a.id = b.id AND a.language = USERENV('LANG')
4764: AND b.cle_id = l_cle_id_tbl(j))
4765: WHERE id = l_sl_id_tbl(j) AND language = USERENV('LANG');
4766: l_line_tbl.delete;