APPS.OKL_INS_QUOTE_PVT dependencies on OKL_STREAMS_PVT

Line 6227: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;

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;

Line 6234: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;

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.

Line 6785: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;

6781: AND STM.KHR_ID = p_contract_id
6782: AND STM.PURPOSE_CODE ='REPORT';
6783:
6784:
6785: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6786: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6787: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6788: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6789:

Line 6786: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;

6782: AND STM.PURPOSE_CODE ='REPORT';
6783:
6784:
6785: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6786: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6787: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6788: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6789:
6790: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;

Line 6787: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;

6783:
6784:
6785: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6786: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6787: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6788: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6789:
6790: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6791:

Line 6788: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;

6784:
6785: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6786: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6787: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6788: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6789:
6790: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6791:
6792: lx_ipyv_rec ipyv_rec_type ;

Line 6790: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;

6786: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;
6787: l_stmv_rec3 Okl_Streams_Pvt.stmv_rec_type;
6788: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;
6789:
6790: x_stmv_rec Okl_Streams_Pvt.stmv_rec_type;
6791:
6792: lx_ipyv_rec ipyv_rec_type ;
6793: l_ipyv_rec ipyv_rec_type ;
6794: l_api_version CONSTANT NUMBER := 1;