5510: pl_khrv_rec okl_contract_pvt.khrv_rec_type;
5511: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5512: xl_khrv_rec okl_contract_pub.khrv_rec_type;
5513:
5514: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5515: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5516:
5517: i NUMBER;
5518: l_tcnCode VARCHAR2(256);
5511: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5512: xl_khrv_rec okl_contract_pub.khrv_rec_type;
5513:
5514: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5515: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5516:
5517: i NUMBER;
5518: l_tcnCode VARCHAR2(256);
5519: l_transaction_type VARCHAR2(256) := 'Miscellaneous';--'Generate Yields';
5741: pl_khrv_rec okl_contract_pvt.khrv_rec_type;
5742: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5743: xl_khrv_rec okl_contract_pub.khrv_rec_type;
5744:
5745: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5746: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5747: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
5748: l_strm_rec strm_csr%ROWTYPE;
5749: l_strms_rec strms_csr%ROWTYPE;
5742: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5743: xl_khrv_rec okl_contract_pub.khrv_rec_type;
5744:
5745: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5746: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5747: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
5748: l_strm_rec strm_csr%ROWTYPE;
5749: l_strms_rec strms_csr%ROWTYPE;
5750:
6518: --Cursor to check whether it is a partial termination mass rebook transaction
6519: CURSOR l_chk_mass_rbk_csr IS
6520: SELECT '!'
6521: FROM okc_k_headers_b CHR,
6522: okl_trx_contracts ktrx,
6523: okl_trx_contracts trx
6524: WHERE CHR.ID = p_chr_id
6525: AND ktrx.KHR_ID = chr.id
6526: AND ktrx.tsu_code = 'ENTERED'
6519: CURSOR l_chk_mass_rbk_csr IS
6520: SELECT '!'
6521: FROM okc_k_headers_b CHR,
6522: okl_trx_contracts ktrx,
6523: okl_trx_contracts trx
6524: WHERE CHR.ID = p_chr_id
6525: AND ktrx.KHR_ID = chr.id
6526: AND ktrx.tsu_code = 'ENTERED'
6527: AND ktrx.rbr_code IS NOT NULL
6662:
6663: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE) IS
6664: SELECT 'Y'
6665: FROM okc_k_headers_b CHR,
6666: okl_trx_contracts ktrx,
6667: okl_trx_contracts trx,
6668: okl_txl_quote_lines_b txl
6669: WHERE CHR.ID = p_chr_id
6670: AND ktrx.KHR_ID = chr.id
6663: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE) IS
6664: SELECT 'Y'
6665: FROM okc_k_headers_b CHR,
6666: okl_trx_contracts ktrx,
6667: okl_trx_contracts trx,
6668: okl_txl_quote_lines_b txl
6669: WHERE CHR.ID = p_chr_id
6670: AND ktrx.KHR_ID = chr.id
6671: AND ktrx.tsu_code = 'ENTERED'
7096: xl_khrv_rec okl_contract_pub.khrv_rec_type;
7097:
7098: l_chr_yields yields_rec_type;
7099:
7100: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7101: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7102: -- Code for bulk update -02/18/2004 - HKPATEL
7103: l_id_tbl okl_streams_util.NumberTabTyp;
7104: -- Code for bulk update ends here -02/18/2004 - HKPATEL
7097:
7098: l_chr_yields yields_rec_type;
7099:
7100: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7101: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7102: -- Code for bulk update -02/18/2004 - HKPATEL
7103: l_id_tbl okl_streams_util.NumberTabTyp;
7104: -- Code for bulk update ends here -02/18/2004 - HKPATEL
7105:
19368: l_isStrmGenAllowed BOOLEAN := TRUE;
19369: l_passStatus VARCHAR2(256);
19370: l_failStatus VARCHAR2(256);
19371:
19372: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19373: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19374:
19375: l_lines_rec l_line_rec_csr%ROWTYPE;
19376: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';
19369: l_passStatus VARCHAR2(256);
19370: l_failStatus VARCHAR2(256);
19371:
19372: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19373: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19374:
19375: l_lines_rec l_line_rec_csr%ROWTYPE;
19376: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';
19377: l_request_id NUMBER;
19612: l_isStrmGenAllowed BOOLEAN := TRUE;
19613: l_passStatus VARCHAR2(256);
19614: l_failStatus VARCHAR2(256);
19615:
19616: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19617: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19618:
19619: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
19620: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
19613: l_passStatus VARCHAR2(256);
19614: l_failStatus VARCHAR2(256);
19615:
19616: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19617: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19618:
19619: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
19620: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
19621: