7742: l_api_version CONSTANT NUMBER := 1.0;
7743: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7744:
7745:
7746: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7747: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7748: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7749: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7750:
7743: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7744:
7745:
7746: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7747: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7748: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7749: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7750:
7751: --Cursor to fetch split child records (for split asset as well as split asset into components)
7744:
7745:
7746: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7747: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7748: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7749: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7750:
7751: --Cursor to fetch split child records (for split asset as well as split asset into components)
7752: CURSOR l_split_trx_csr1(p_trxline_id IN NUMBER) IS
7745:
7746: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7747: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7748: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7749: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7750:
7751: --Cursor to fetch split child records (for split asset as well as split asset into components)
7752: CURSOR l_split_trx_csr1(p_trxline_id IN NUMBER) IS
7753: SELECT txd.split_percent,
7890: p_txl_id IN NUMBER,
7891: --Bug# 6344223
7892: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7893:
7894: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7895: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7896: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7897: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7898: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7891: --Bug# 6344223
7892: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7893:
7894: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7895: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7896: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7897: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7898: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7899: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7892: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7893:
7894: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7895: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7896: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7897: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7898: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7899: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7900:
7893:
7894: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7895: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7896: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7897: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7898: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7899: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7900:
7901:
7894: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7895: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7896: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7897: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7898: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7899: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7900:
7901:
7902: CURSOR l_strm_csr ( kleId NUMBER, status VARCHAR2) IS
7895: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7896: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7897: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7898: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7899: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7900:
7901:
7902: CURSOR l_strm_csr ( kleId NUMBER, status VARCHAR2) IS
7903: SELECT str.Id,
7967:
7968: l_active_yn OKL_STREAMS.ACTIVE_YN%TYPE;
7969:
7970: --Bug# 4775555
7971: l_stmv_rec_temp Okl_Streams_pub.stmv_rec_type;
7972:
7973: --Bug# 6344223
7974: CURSOR l_txd_csr(p_trxline_id IN NUMBER) IS
7975: SELECT txd.id,
8032: l_stmv_rec_hist.active_yn := 'N';
8033: l_stmv_rec_hist.date_history := SYSDATE;
8034: --Bug# 6344223
8035: l_stmv_rec_hist.link_hist_stream_id := l_strms_rec.link_hist_stream_id;
8036: Okl_Streams_Pub.update_streams(
8037: p_api_version => l_api_version
8038: ,p_init_msg_list => p_init_msg_list
8039: ,x_return_status => x_return_status
8040: ,x_msg_count => x_msg_count
8195: l_stmv_rec_hist.active_yn := 'N';
8196: l_stmv_rec_hist.date_history := SYSDATE;
8197: --Bug# 6344223
8198: l_stmv_rec_hist.link_hist_stream_id := l_strms_rec.link_hist_stream_id;
8199: Okl_Streams_Pub.update_streams(
8200: p_api_version => l_api_version
8201: ,p_init_msg_list => p_init_msg_list
8202: ,x_return_status => x_return_status
8203: ,x_msg_count => x_msg_count
8220: CLOSE l_sifseq_csr;
8221: --Bug# 3502142
8222: l_stmv_rec.date_current := SYSDATE;
8223:
8224: Okl_Streams_Pub.create_streams(
8225: p_api_version => l_api_version
8226: ,p_init_msg_list => p_init_msg_list
8227: ,x_return_status => x_return_status
8228: ,x_msg_count => x_msg_count
8248: CLOSE l_sifseq_csr;
8249: --Bug# 3502142
8250: l_stmv_rec.date_current := SYSDATE;
8251:
8252: Okl_Streams_Pub.create_streams(
8253: p_api_version => l_api_version
8254: ,p_init_msg_list => p_init_msg_list
8255: ,x_return_status => x_return_status
8256: ,x_msg_count => x_msg_count