2592: chr_old.contract_number
2593: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old
2594: WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
2595:
2596: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2597: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2598: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2599: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2593: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old
2594: WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
2595:
2596: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2597: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2598: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2599: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2601: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2594: WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
2595:
2596: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2597: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2598: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2599: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2601: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2602: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2595:
2596: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2597: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2598: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2599: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2601: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2602: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2603: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2596: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2597: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2598: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2599: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2601: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2602: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2603: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2604: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2597: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;
2598: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2599: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2601: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2602: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2603: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2604: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2605: l_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2598: l_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2599: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2601: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2602: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2603: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2604: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2605: l_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2606: x_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2599: l_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2601: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2602: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2603: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2604: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2605: l_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2606: x_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2607: x_err_msg VARCHAR2 (2000);
2600: l_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2601: x_quot_rec okl_am_create_quote_pvt.quot_rec_type;
2602: x_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
2603: x_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
2604: x_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2605: l_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2606: x_term_rec okl_am_termnt_quote_pvt.term_rec_type;
2607: x_err_msg VARCHAR2 (2000);
2608: