5163: --Bug 4414441 - Start of Changes
5164: l_payment_rec l_payment_csr%ROWTYPE;
5165: TYPE l_payment_tbl_type IS TABLE OF l_payment_csr%ROWTYPE INDEX BY BINARY_INTEGER;
5166: l_payment_tbl l_payment_tbl_type;
5167: l_rent_amt_tbl Okl_Streams_Util.NumberTabTyp;
5168: k NUMBER;
5169: l_next_position NUMBER;
5170: --Bug 4414441 - End of Changes
5171: BEGIN
5753: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5754: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5755:
5756: -- Code for bulk update -02/28/2004 - HKPATEL
5757: l_id_tbl okl_streams_util.NumberTabTyp;
5758: l_say_code_tbl okl_streams_util.Var10TabTyp;
5759: l_active_yn_tbl okl_streams_util.Var10TabTyp;
5760: l_date_history_tbl okl_streams_util.DateTabTyp;
5761: l_date_curr_tbl okl_streams_util.DateTabTyp;
5754: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5755:
5756: -- Code for bulk update -02/28/2004 - HKPATEL
5757: l_id_tbl okl_streams_util.NumberTabTyp;
5758: l_say_code_tbl okl_streams_util.Var10TabTyp;
5759: l_active_yn_tbl okl_streams_util.Var10TabTyp;
5760: l_date_history_tbl okl_streams_util.DateTabTyp;
5761: l_date_curr_tbl okl_streams_util.DateTabTyp;
5762:
5755:
5756: -- Code for bulk update -02/28/2004 - HKPATEL
5757: l_id_tbl okl_streams_util.NumberTabTyp;
5758: l_say_code_tbl okl_streams_util.Var10TabTyp;
5759: l_active_yn_tbl okl_streams_util.Var10TabTyp;
5760: l_date_history_tbl okl_streams_util.DateTabTyp;
5761: l_date_curr_tbl okl_streams_util.DateTabTyp;
5762:
5763: -- Code for bulk update ends here -02/28/2004 - HKPATEL
5756: -- Code for bulk update -02/28/2004 - HKPATEL
5757: l_id_tbl okl_streams_util.NumberTabTyp;
5758: l_say_code_tbl okl_streams_util.Var10TabTyp;
5759: l_active_yn_tbl okl_streams_util.Var10TabTyp;
5760: l_date_history_tbl okl_streams_util.DateTabTyp;
5761: l_date_curr_tbl okl_streams_util.DateTabTyp;
5762:
5763: -- Code for bulk update ends here -02/28/2004 - HKPATEL
5764:
5757: l_id_tbl okl_streams_util.NumberTabTyp;
5758: l_say_code_tbl okl_streams_util.Var10TabTyp;
5759: l_active_yn_tbl okl_streams_util.Var10TabTyp;
5760: l_date_history_tbl okl_streams_util.DateTabTyp;
5761: l_date_curr_tbl okl_streams_util.DateTabTyp;
5762:
5763: -- Code for bulk update ends here -02/28/2004 - HKPATEL
5764:
5765:
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:
7106:
7107: Cursor ylds_csr( chrId NUMBER ) IS
9118: END IF;
9119: CLOSE get_sub_income_strm_csr;
9120:
9121: -- New code for bug 4044089 by HKPATEL 12/02/2004
9122: OKL_STREAMS_UTIL.get_dependent_stream_type
9123: (
9124: p_khr_id =>p_chr_id,
9125: p_primary_sty_id =>l_sty_id,
9126: p_dependent_sty_purpose=>'SUBSIDY_INCOME',
9260: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
9261: END IF;
9262: CLOSE get_sub_income_strm_csr;
9263: -- New code for bug 4044089 by HKPATEL 12/02/2004
9264: OKL_STREAMS_UTIL.get_dependent_stream_type
9265: (
9266: p_khr_id =>p_chr_id,
9267: p_primary_sty_id =>l_sty_id,
9268: p_dependent_sty_purpose=>'SUBSIDY_INCOME',
20378: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
20379: l_strms_orig_rec strms_csr%ROWTYPE;
20380: l_strms_rep_rec strms_csr%ROWTYPE;
20381: -- Code for bulk update -02/28/2004 - HKPATEL
20382: l_id_tbl okl_streams_util.NumberTabTyp;
20383: -- Code for bulk update ends here -02/28/2004 - HKPATEL
20384:
20385:
20386: i NUMBER;
20580: return;
20581:
20582: End If;
20583:
20584: OKL_STREAMS_UTIL.get_pricing_engine(
20585: p_khr_id => p_khr_id,
20586: x_pricing_engine => l_pricing_engine,
20587: x_return_status => x_return_status);
20588: --Added by kthiruva for Debugging