APPS.OKL_ESG_TRANSPORT_PVT dependencies on OKL_STREAM_INTERFACES

Line 29: , okl_stream_interfaces si

25: CURSOR c_tt (b_transaction_number NUMBER) is
26: SELECT t.ext_subtype, t.protocol_address, t.username, t.password,
27: t.protocol_type -- added bug8209104
28: FROM ecx_tp_details_v t
29: , okl_stream_interfaces si
30: WHERE t.transaction_type = 'OKL_ST'
31: AND t.transaction_subtype = si.deal_type
32: AND si.transaction_number = b_transaction_number;
33:

Line 136: okl_stream_interfaces b

132: cursor get_clob(p_contract_id IN NUMBER,
133: p_purpose_code IN VARCHAR2) IS
134: select a.transaction_state
135: from okl_stream_trx_data a,
136: okl_stream_interfaces b
137: where a.orig_khr_id = p_contract_id
138: and a.last_trx_state = 'Y'
139: and a.transaction_number = b.transaction_number
140: and nvl(b.purpose_code, 'PRIMARY') = p_purpose_code;

Line 146: ,okl_stream_interfaces osi

142: cursor is_erd_enabled(p_trx_number IN NUMBER ) IS
143: select gts.deal_type
144: ,gts.interest_calc_meth_code
145: from okl_sys_acct_opts_all sao
146: ,okl_stream_interfaces osi
147: ,okc_k_headers_all_b chr
148: ,okl_k_headers khr
149: ,okl_products pdt
150: ,okl_ae_tmpt_sets_all aes

Line 161: from okl_stream_interfaces

157: and pdt.aes_id = aes.id
158: and aes.gts_id = gts.id;
159: cursor get_trx_contract(p_trx_id IN NUMBER) IS
160: select khr_id, nvl(purpose_code, 'PRIMARY') purpose_code
161: from okl_stream_interfaces
162: where transaction_number = p_trx_num;
163:
164: cursor get_orig_contract(p_trx_id in number) is
165: select orig_khr_id, out_xml

Line 263: from okl_stream_interfaces

259: );
260:
261: cursor get_purpose_code(p_transaction_number number) IS
262: select NVL(purpose_code, 'PRIMARY') purpose_code
263: from okl_stream_interfaces
264: where transaction_number = p_transaction_number;
265:
266: cursor get_trx_reference(p_khr_id number, p_purpose_code varchar2) IS
267: select a.transaction_number

Line 268: from okl_stream_trx_data a, okl_stream_interfaces b

264: where transaction_number = p_transaction_number;
265:
266: cursor get_trx_reference(p_khr_id number, p_purpose_code varchar2) IS
267: select a.transaction_number
268: from okl_stream_trx_data a, okl_stream_interfaces b
269: where a.orig_khr_id = p_khr_id
270: and a.last_trx_state = 'Y'
271: and a.transaction_number = b.transaction_number
272: and NVL(b.purpose_code, 'PRIMARY') = p_purpose_code;

Line 284: from okl_stream_interfaces

280:
281: -- get the current contract_id. this could be a copy_contract_id
282: select khr_id
283: into l_contract_id
284: from okl_stream_interfaces
285: where transaction_number = p_transaction_number;
286:
287: -- based on the above contract_id, get the original contract_id.
288: -- this is applicable to online rebooks.