3153: IS
3154: SELECT okl_sif_seq.NEXTVAL transaction_number
3155: FROM dual;
3156:
3157: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3158: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3159: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3160: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3161:
3154: SELECT okl_sif_seq.NEXTVAL transaction_number
3155: FROM dual;
3156:
3157: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3158: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3159: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3160: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3161:
3162: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3155: FROM dual;
3156:
3157: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3158: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3159: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3160: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3161:
3162: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3163: l_api_version CONSTANT NUMBER := 1.0;
3156:
3157: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3158: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3159: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3160: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3161:
3162: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3163: l_api_version CONSTANT NUMBER := 1.0;
3164: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3223: lp_selv_tbl(1).amount := p_amount;
3224: lp_selv_tbl(1).stream_element_date := p_stream_element_date;
3225: lp_selv_tbl(1).se_line_number := 1;
3226:
3227: Okl_Streams_Pub.create_streams(p_api_version => p_api_version
3228: ,p_init_msg_list => p_init_msg_list
3229: ,x_return_status => l_return_status
3230: ,x_msg_count => x_msg_count
3231: ,x_msg_data => x_msg_data