APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKL_STREAMS

Line 60: okl_streams stm,

56: stm.sty_id sty_id,
57: ste.amount amount,
58: chr.contract_number contract_number
59: FROM okl_strm_elements ste,
60: okl_streams stm,
61: OKC_K_HEADERS_B chr, -- Added for Org,
62: okl_k_headers oklchr,
63: OKL_STRM_TMPT_LINES_UV stl
64:

Line 110: l_selv_rec Okl_Streams_Pub.selv_rec_type;

106: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
107: l_msg_data VARCHAR2(2000);
108: l_msg_count NUMBER := 0 ;
109:
110: l_selv_rec Okl_Streams_Pub.selv_rec_type;
111: x_selv_rec Okl_Streams_Pub.selv_rec_type;
112:
113: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
114: SELECT id

Line 111: x_selv_rec Okl_Streams_Pub.selv_rec_type;

107: l_msg_data VARCHAR2(2000);
108: l_msg_count NUMBER := 0 ;
109:
110: l_selv_rec Okl_Streams_Pub.selv_rec_type;
111: x_selv_rec Okl_Streams_Pub.selv_rec_type;
112:
113: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
114: SELECT id
115: FROM okl_trx_types_tl

Line 200: Okl_Streams_Pub.update_stream_elements

196: ELSE
197: l_selv_rec.id := c_streams_rec.stream_ele_id;
198: l_selv_rec.date_billed := sysdate;
199:
200: Okl_Streams_Pub.update_stream_elements
201: (l_api_version
202: ,Okc_Api.G_TRUE
203: ,l_return_status
204: ,l_msg_count