DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_STREAMS_PUB

Line 7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

7795: l_api_version CONSTANT NUMBER := 1.0;
7796: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7797:
7798:
7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7803:

Line 7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

7796: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7797:
7798:
7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7803:
7804: --Cursor to fetch split child records (for split asset as well as split asset into components)

Line 7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

7797:
7798:
7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7803:
7804: --Cursor to fetch split child records (for split asset as well as split asset into components)
7805: CURSOR l_split_trx_csr1(p_trxline_id IN NUMBER) IS

Line 7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

7798:
7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7803:
7804: --Cursor to fetch split child records (for split asset as well as split asset into components)
7805: CURSOR l_split_trx_csr1(p_trxline_id IN NUMBER) IS
7806: SELECT txd.split_percent,

Line 7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

7943: p_txl_id IN NUMBER,
7944: --Bug# 6344223
7945: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7946:
7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

Line 7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

7944: --Bug# 6344223
7945: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7946:
7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

Line 7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;

7945: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7946:
7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7953:

Line 7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;

7946:
7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7953:
7954:

Line 7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7953:
7954:
7955: CURSOR l_strm_csr ( kleId NUMBER, status VARCHAR2) IS

Line 7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7953:
7954:
7955: CURSOR l_strm_csr ( kleId NUMBER, status VARCHAR2) IS
7956: SELECT str.Id,

Line 8024: l_stmv_rec_temp Okl_Streams_pub.stmv_rec_type;

8020:
8021: l_active_yn OKL_STREAMS.ACTIVE_YN%TYPE;
8022:
8023: --Bug# 4775555
8024: l_stmv_rec_temp Okl_Streams_pub.stmv_rec_type;
8025:
8026: --Bug# 6344223
8027: CURSOR l_txd_csr(p_trxline_id IN NUMBER) IS
8028: SELECT txd.id,

Line 8089: Okl_Streams_Pub.update_streams(

8085: l_stmv_rec_hist.active_yn := 'N';
8086: l_stmv_rec_hist.date_history := SYSDATE;
8087: --Bug# 6344223
8088: l_stmv_rec_hist.link_hist_stream_id := l_strms_rec.link_hist_stream_id;
8089: Okl_Streams_Pub.update_streams(
8090: p_api_version => l_api_version
8091: ,p_init_msg_list => p_init_msg_list
8092: ,x_return_status => x_return_status
8093: ,x_msg_count => x_msg_count

Line 8252: Okl_Streams_Pub.update_streams(

8248: l_stmv_rec_hist.active_yn := 'N';
8249: l_stmv_rec_hist.date_history := SYSDATE;
8250: --Bug# 6344223
8251: l_stmv_rec_hist.link_hist_stream_id := l_strms_rec.link_hist_stream_id;
8252: Okl_Streams_Pub.update_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

Line 8277: Okl_Streams_Pub.create_streams(

8273: CLOSE l_sifseq_csr;
8274: --Bug# 3502142
8275: l_stmv_rec.date_current := SYSDATE;
8276:
8277: Okl_Streams_Pub.create_streams(
8278: p_api_version => l_api_version
8279: ,p_init_msg_list => p_init_msg_list
8280: ,x_return_status => x_return_status
8281: ,x_msg_count => x_msg_count

Line 8305: Okl_Streams_Pub.create_streams(

8301: CLOSE l_sifseq_csr;
8302: --Bug# 3502142
8303: l_stmv_rec.date_current := SYSDATE;
8304:
8305: Okl_Streams_Pub.create_streams(
8306: p_api_version => l_api_version
8307: ,p_init_msg_list => p_init_msg_list
8308: ,x_return_status => x_return_status
8309: ,x_msg_count => x_msg_count