2873:
2874: l_line_amount := 0;
2875: BEGIN
2876: SELECT SUM(amount) INTO l_line_amount
2877: FROM okl_cnsld_ar_strms_v
2878: WHERE lln_id = line_seq.id;
2879: EXCEPTION
2880: WHEN OTHERS THEN
2881: l_line_amount := 0;
3041:
3042: BEGIN
3043: SELECT sty.name
3044: INTO l_xlsv_rec.XTRX_STREAM_TYPE
3045: FROM okl_cnsld_ar_strms_v lsm,
3046: okl_strm_type_v sty
3047: WHERE lsm.id = cnr_update_tbl(cnr_tab_idx).lsm_id AND
3048: sty.id = lsm.sty_id;
3049: EXCEPTION