6223: p_ipyv_rec IN ipyv_rec_type
6224: )IS
6225:
6226: p_sty_id NUMBER;
6227: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6228: l_row_notfound BOOLEAN := TRUE;
6229: l_msg_count NUMBER ;
6230: l_msg_data VARCHAR2(2000);
6231: l_api_version CONSTANT NUMBER := 1;
6230: l_msg_data VARCHAR2(2000);
6231: l_api_version CONSTANT NUMBER := 1;
6232: l_api_name CONSTANT VARCHAR2(30) := 'ACTIVATE_INS_STREAM';
6233: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
6234: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6235: l_khr_status VARCHAR2 (30) ;
6236: lx_ipyv_rec ipyv_rec_type ;
6237: l_ipyv_rec ipyv_rec_type ;
6238: l_contract_number VARCHAR2(120); --3745151 Invalid error message fix.
6774: AND STM.KHR_ID = p_contract_id
6775: AND STM.PURPOSE_CODE ='REPORT';
6776:
6777:
6778: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6779: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6780: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6781: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6782:
6775: AND STM.PURPOSE_CODE ='REPORT';
6776:
6777:
6778: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6779: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6780: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6781: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6782:
6783: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6776:
6777:
6778: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6779: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6780: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6781: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6782:
6783: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6784:
6777:
6778: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6779: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6780: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6781: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6782:
6783: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6784:
6785: lx_ipyv_rec ipyv_rec_type ;
6779: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6780: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6781: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6782:
6783: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6784:
6785: lx_ipyv_rec ipyv_rec_type ;
6786: l_ipyv_rec ipyv_rec_type ;
6787: l_api_version CONSTANT NUMBER := 1;