DBA Data[Home] [Help]

APPS.IBY_BANKACCXFR_PUB dependencies on DBMS_LOB

Line 148: DBMS_LOB.CreateTemporary(l_tempclob, TRUE);

144:
145: -------------------------
146: -- create temporary clob
147: -------------------------
148: DBMS_LOB.CreateTemporary(l_tempclob, TRUE);
149:
150: -----------------------------
151: -- reading header level data
152: -----------------------------

Line 180: DBMS_LOB.WriteAppend(l_tempclob, length(l_post_body), l_post_body);

176: l_post_body, l_db_nls, l_ecapp_nls);
177:
178:
179: -- write to CLOB
180: DBMS_LOB.WriteAppend(l_tempclob, length(l_post_body), l_post_body);
181:
182: --dbms_output.put_line('String :'||l_post_body);
183:
184: -- Writing Transaction Level Data

Line 215: DBMS_LOB.WriteAppend(l_tempclob, length(l_post_body), l_post_body);

211: l_curr_index := p_accxfr_trxn_tbl.next(l_curr_index);
212: --dbms_output.put_line('IBY_BANKACCXFR_PUB : '||l_pos);
213: --dbms_output.put_line('String :'||l_post_body);
214: -- write to CLOB
215: DBMS_LOB.WriteAppend(l_tempclob, length(l_post_body), l_post_body);
216:
217:
218:
219: END LOOP;

Line 226: --dbms_output.put_line('Length : '||DBMS_LOB.GETLENGTH(l_tempclob));

222: ---------------------------------------------------
223: -- sending POST request and unpacking the results
224: ---------------------------------------------------
225:
226: --dbms_output.put_line('Length : '||DBMS_LOB.GETLENGTH(l_tempclob));
227: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_tempclob,l_names,l_values, l_status, l_errcode, l_errmessage);
228:
229: -- Release temporary blobs
230: DBMS_LOB.FreeTemporary(l_tempclob);

Line 230: DBMS_LOB.FreeTemporary(l_tempclob);

226: --dbms_output.put_line('Length : '||DBMS_LOB.GETLENGTH(l_tempclob));
227: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_tempclob,l_names,l_values, l_status, l_errcode, l_errmessage);
228:
229: -- Release temporary blobs
230: DBMS_LOB.FreeTemporary(l_tempclob);
231:
232:
233: FOR i IN l_names.FIRST..l_names.last LOOP
234: --dbms_output.put_line(l_names(i)||' : '||l_values(i));