DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_STREAMS_PUB

Line 7746: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

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:

Line 7747: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

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)

Line 7748: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

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

Line 7749: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

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,

Line 7894: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

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;

Line 7895: l_selv_tbl Okl_Streams_pub.selv_tbl_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;

Line 7896: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_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:

Line 7897: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;

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:

Line 7898: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

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

Line 7899: x_selv_tbl Okl_Streams_pub.selv_tbl_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
7903: SELECT str.Id,

Line 7971: l_stmv_rec_temp Okl_Streams_pub.stmv_rec_type;

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,

Line 8036: Okl_Streams_Pub.update_streams(

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

Line 8199: Okl_Streams_Pub.update_streams(

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

Line 8224: Okl_Streams_Pub.create_streams(

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

Line 8252: Okl_Streams_Pub.create_streams(

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