2289: chr_old.contract_number
2290: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old
2291: WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
2292:
2293: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2294: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2295: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2296: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2290: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old
2291: WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
2292:
2293: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2294: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2295: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2296: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2298: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2291: WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
2292:
2293: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2294: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2295: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2296: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2298: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2299: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2292:
2293: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2294: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2295: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2296: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2298: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2299: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2300: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2293: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2294: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2295: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2296: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2298: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2299: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2300: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2301: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2294: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2295: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2296: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2298: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2299: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2300: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2301: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2302: l_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2295: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2296: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2298: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2299: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2300: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2301: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2302: l_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2303: x_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2296: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2298: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2299: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2300: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2301: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2302: l_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2303: x_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2304: x_err_msg VARCHAR2 (2000);
2297: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2298: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2299: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2300: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2301: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2302: l_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2303: x_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2304: x_err_msg VARCHAR2 (2000);
2305: