APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_K_LINES_TL

Line 4657: --update the oks_k_lines_tl for the toplines

4653: END IF;
4654:
4655: END LOOP;
4656:
4657: --update the oks_k_lines_tl for the toplines
4658: FORALL j in l_sl_id_tbl.first..l_sl_id_tbl.last
4659: UPDATE oks_k_lines_tl
4660: SET invoice_text = l_inv_txt_tbl(j)
4661: WHERE id = l_sl_id_tbl(j) AND language = USERENV('LANG');

Line 4659: UPDATE oks_k_lines_tl

4655: END LOOP;
4656:
4657: --update the oks_k_lines_tl for the toplines
4658: FORALL j in l_sl_id_tbl.first..l_sl_id_tbl.last
4659: UPDATE oks_k_lines_tl
4660: SET invoice_text = l_inv_txt_tbl(j)
4661: WHERE id = l_sl_id_tbl(j) AND language = USERENV('LANG');
4662:
4663: l_line_tbl.delete;

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

4717: END IF;
4718:
4719: END LOOP;
4720:
4721: --update the oks_k_lines_tl for the sublines using toplines inv txt
4722: FORALL j in l_sl_id_tbl.first..l_sl_id_tbl.last
4723: UPDATE oks_k_lines_tl c
4724: SET c.invoice_text =
4725: (SELECT SUBSTR(a.invoice_text,1, decode(INSTR(a.invoice_text, ':'),0,

Line 4723: UPDATE oks_k_lines_tl c

4719: END LOOP;
4720:
4721: --update the oks_k_lines_tl for the sublines using toplines inv txt
4722: FORALL j in l_sl_id_tbl.first..l_sl_id_tbl.last
4723: UPDATE oks_k_lines_tl c
4724: SET c.invoice_text =
4725: (SELECT SUBSTR(a.invoice_text,1, decode(INSTR(a.invoice_text, ':'),0,
4726: LENGTH(a.invoice_text), INSTR(a.invoice_text, ':'))) ||l_inv_txt_tbl(j)
4727: FROM oks_k_lines_tl a, oks_k_lines_b b

Line 4727: FROM oks_k_lines_tl a, oks_k_lines_b b

4723: UPDATE oks_k_lines_tl c
4724: SET c.invoice_text =
4725: (SELECT SUBSTR(a.invoice_text,1, decode(INSTR(a.invoice_text, ':'),0,
4726: LENGTH(a.invoice_text), INSTR(a.invoice_text, ':'))) ||l_inv_txt_tbl(j)
4727: FROM oks_k_lines_tl a, oks_k_lines_b b
4728: WHERE a.id = b.id AND a.language = USERENV('LANG')
4729: AND b.cle_id = l_cle_id_tbl(j))
4730: WHERE id = l_sl_id_tbl(j) AND language = USERENV('LANG');
4731: l_line_tbl.delete;