APPS.OKL_ESG_TRANSPORT_PVT dependencies on OKL_STREAM_TRX_DATA

Line 135: from okl_stream_trx_data a,

131:
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

Line 166: from okl_stream_trx_data

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
166: from okl_stream_trx_data
167: where transaction_number = p_trx_id
168: for update;
169:
170: l_khr_id number;

Line 214: update okl_stream_trx_data

210: /* trim the clob from the tag till the end */
211: DBMS_LOB.TRIM(l_outbound_xml, pos1);
212:
213: /* append the transaction state to the trimmed clob, and append the tail end from the tag to the end */
214: update okl_stream_trx_data
215: set out_xml = l_outbound_xml || ''||trans_clob||''|| l_tag_end_xml
216: where transaction_number = p_trx_num;
217: end if;
218: end if;

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 305: INSERT INTO OKL_STREAM_TRX_DATA

301: open get_trx_reference(l_orig_contract_id, l_purpose_code);
302: fetch get_trx_reference into l_trx_reference;
303: close get_trx_reference;
304:
305: INSERT INTO OKL_STREAM_TRX_DATA
306: (id,
307: transaction_number,
308: out_xml,
309: khr_id,

Line 378: -- 2. Store the outbound xml into OKL_STREAM_TRX_DATA table

374: ----------------------------------------------------------------------------------
375: l_outbound_xml := okl_xmlgen_pvt.generate_xmldocument(p_transaction_number);
376:
377: ----------------------------------------------------------------------------------
378: -- 2. Store the outbound xml into OKL_STREAM_TRX_DATA table
379: ----------------------------------------------------------------------------------
380: store_outxml(p_transaction_number, l_outbound_xml);
381:
382: ----------------------------------------------------------------------------------