DBA Data[Home] [Help]

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 6778: l_stmv_rec Okl_Streams_Pvt.stmv_rec_type;

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:

Line 6779: l_stmv_rec2 Okl_Streams_Pvt.stmv_rec_type;

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;

Line 6780: l_stmv_rec3 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:

Line 6781: l_stmv_rec4 Okl_Streams_Pvt.stmv_rec_type;

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 ;

Line 6783: x_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 ;
6786: l_ipyv_rec ipyv_rec_type ;
6787: l_api_version CONSTANT NUMBER := 1;