3208: IS
3209: SELECT okl_sif_seq.NEXTVAL transaction_number
3210: FROM dual;
3211:
3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3216:
3209: SELECT okl_sif_seq.NEXTVAL transaction_number
3210: FROM dual;
3211:
3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3216:
3217: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3210: FROM dual;
3211:
3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3216:
3217: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3218: l_api_version CONSTANT NUMBER := 1.0;
3211:
3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3216:
3217: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3218: l_api_version CONSTANT NUMBER := 1.0;
3219: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3278: lp_selv_tbl(1).amount := p_amount;
3279: lp_selv_tbl(1).stream_element_date := p_stream_element_date;
3280: lp_selv_tbl(1).se_line_number := 1;
3281:
3282: Okl_Streams_Pub.create_streams(p_api_version => p_api_version
3283: ,p_init_msg_list => p_init_msg_list
3284: ,x_return_status => l_return_status
3285: ,x_msg_count => x_msg_count
3286: ,x_msg_data => x_msg_data