5812:
5813:
5814: /* Cursor to get the Quote Number. */
5815:
5816: CURSOR l_qte_number_csr ( qteID IN OKL_TRX_QUOTES_V.ID%TYPE ) IS
5817: SELECT quote_number
5818: FROM okl_trx_quotes_v
5819: WHERE id = qteID;
5820:
5814: /* Cursor to get the Quote Number. */
5815:
5816: CURSOR l_qte_number_csr ( qteID IN OKL_TRX_QUOTES_V.ID%TYPE ) IS
5817: SELECT quote_number
5818: FROM okl_trx_quotes_v
5819: WHERE id = qteID;
5820:
5821:
5822: /* Cursor to get the rollover quote fee top/sub-line payments for a
5871: l_top_fee_ln_id OKL_K_LINES.ID%TYPE;
5872: l_top_fee_ln_name OKC_K_LINES_V.NAME%TYPE;
5873: l_sub_fee_ln_id OKL_K_LINES.ID%TYPE;
5874: l_qte_id OKL_K_LINES.QTE_ID%TYPE;
5875: l_qte_num OKL_TRX_QUOTES_V.QUOTE_NUMBER%TYPE;
5876: p_term_tbl Okl_Trx_Quotes_Pub.qtev_tbl_type;
5877: x_term_tbl Okl_Trx_Quotes_Pub.qtev_tbl_type;
5878: x_err_msg VARCHAR2(1000);
5879: