eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_T4A_XML dependencies on DBMS_LOB

Line 84: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);

80:
81: raw_data:=utl_raw.cast_to_raw(p_text);
82: text_size:=utl_raw.length(raw_data);
83:
84: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
85: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
86:
87: dbms_lob.writeappend(temp_blob,
88: text_size,

Line 85: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);

81: raw_data:=utl_raw.cast_to_raw(p_text);
82: text_size:=utl_raw.length(raw_data);
83:
84: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
85: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
86:
87: dbms_lob.writeappend(temp_blob,
88: text_size,
89: raw_data);

Line 87: dbms_lob.writeappend(temp_blob,

83:
84: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
85: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
86:
87: dbms_lob.writeappend(temp_blob,
88: text_size,
89: raw_data);
90:
91: IF dbms_lob.ISOPEN(temp_blob)=1 THEN

Line 91: IF dbms_lob.ISOPEN(temp_blob)=1 THEN

87: dbms_lob.writeappend(temp_blob,
88: text_size,
89: raw_data);
90:
91: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
92: hr_utility.trace('Closing temp_lob' );
93: dbms_lob.close(temp_blob);
94: hr_utility.trace('Closed temp_lob' );
95: END IF;

Line 93: dbms_lob.close(temp_blob);

89: raw_data);
90:
91: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
92: hr_utility.trace('Closing temp_lob' );
93: dbms_lob.close(temp_blob);
94: hr_utility.trace('Closed temp_lob' );
95: END IF;
96:
97: return temp_blob;

Line 251: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));

247: 'Y',
248: 'get_final_xml',
249: p_xml_blob
250: );
251: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
252: hr_utility.trace('1. final 1. XML l_final_xml '||
253: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
254: hr_utility.trace('In get_final_xml 30');
255:

Line 253: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));

249: p_xml_blob
250: );
251: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
252: hr_utility.trace('1. final 1. XML l_final_xml '||
253: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
254: hr_utility.trace('In get_final_xml 30');
255:
256: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
257: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );

Line 256: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);

252: hr_utility.trace('1. final 1. XML l_final_xml '||
253: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
254: hr_utility.trace('In get_final_xml 30');
255:
256: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
257: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
258:
259: IF l_is_temp_final_xml = 1 THEN
260: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 260: DBMS_LOB.FREETEMPORARY(l_final_xml);

256: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
257: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
258:
259: IF l_is_temp_final_xml = 1 THEN
260: DBMS_LOB.FREETEMPORARY(l_final_xml);
261: END IF;
262:
263: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
264: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

Line 263: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);

259: IF l_is_temp_final_xml = 1 THEN
260: DBMS_LOB.FREETEMPORARY(l_final_xml);
261: END IF;
262:
263: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
264: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
265: l_final_xml := append_to_lob(l_header_xml_string);
266: dbms_lob.append(l_final_xml,p_xml_blob);
267: hr_utility.trace('In get_final_xml 40');

Line 264: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

260: DBMS_LOB.FREETEMPORARY(l_final_xml);
261: END IF;
262:
263: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
264: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
265: l_final_xml := append_to_lob(l_header_xml_string);
266: dbms_lob.append(l_final_xml,p_xml_blob);
267: hr_utility.trace('In get_final_xml 40');
268:

Line 266: dbms_lob.append(l_final_xml,p_xml_blob);

262:
263: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
264: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
265: l_final_xml := append_to_lob(l_header_xml_string);
266: dbms_lob.append(l_final_xml,p_xml_blob);
267: hr_utility.trace('In get_final_xml 40');
268:
269: l_trailer_xml := ''||EOL;
270:

Line 272: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);

268:
269: l_trailer_xml := ''||EOL;
270:
271: hr_utility.trace('In get_final_xml 50');
272: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
273: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
274: l_temp_blob := append_to_lob(l_trailer_xml);
275: dbms_lob.append(l_final_xml,l_temp_blob);
276:

Line 273: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);

269: l_trailer_xml := ''||EOL;
270:
271: hr_utility.trace('In get_final_xml 50');
272: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
273: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
274: l_temp_blob := append_to_lob(l_trailer_xml);
275: dbms_lob.append(l_final_xml,l_temp_blob);
276:
277: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN

Line 275: dbms_lob.append(l_final_xml,l_temp_blob);

271: hr_utility.trace('In get_final_xml 50');
272: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
273: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
274: l_temp_blob := append_to_lob(l_trailer_xml);
275: dbms_lob.append(l_final_xml,l_temp_blob);
276:
277: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
278: hr_utility.trace('Closing l_final_xml' );
279: dbms_lob.close(l_final_xml);

Line 277: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN

273: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
274: l_temp_blob := append_to_lob(l_trailer_xml);
275: dbms_lob.append(l_final_xml,l_temp_blob);
276:
277: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
278: hr_utility.trace('Closing l_final_xml' );
279: dbms_lob.close(l_final_xml);
280: END IF;
281: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 279: dbms_lob.close(l_final_xml);

275: dbms_lob.append(l_final_xml,l_temp_blob);
276:
277: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
278: hr_utility.trace('Closing l_final_xml' );
279: dbms_lob.close(l_final_xml);
280: END IF;
281: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
282: hr_utility.trace('Closing p_xml_blob' );
283: dbms_lob.close(p_xml_blob);

Line 281: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

277: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
278: hr_utility.trace('Closing l_final_xml' );
279: dbms_lob.close(l_final_xml);
280: END IF;
281: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
282: hr_utility.trace('Closing p_xml_blob' );
283: dbms_lob.close(p_xml_blob);
284: END IF;
285: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 283: dbms_lob.close(p_xml_blob);

279: dbms_lob.close(l_final_xml);
280: END IF;
281: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
282: hr_utility.trace('Closing p_xml_blob' );
283: dbms_lob.close(p_xml_blob);
284: END IF;
285: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
286: hr_utility.trace('Closing l_temp_blob' );
287: dbms_lob.close(l_temp_blob);

Line 285: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

281: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
282: hr_utility.trace('Closing p_xml_blob' );
283: dbms_lob.close(p_xml_blob);
284: END IF;
285: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
286: hr_utility.trace('Closing l_temp_blob' );
287: dbms_lob.close(l_temp_blob);
288: END IF;
289: hr_utility.trace('In get_final_xml 60');

Line 287: dbms_lob.close(l_temp_blob);

283: dbms_lob.close(p_xml_blob);
284: END IF;
285: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
286: hr_utility.trace('Closing l_temp_blob' );
287: dbms_lob.close(l_temp_blob);
288: END IF;
289: hr_utility.trace('In get_final_xml 60');
290:
291: else -- lv_negative_bal_flag = 'Y'

Line 299: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);

295: INTO l_err_msg;
296: CLOSE cur_get_meaning;
297:
298: l_err_msg := 'Error:'||l_err_msg;
299: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
300: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
301:
302: IF l_is_temp_final_xml = 1 THEN
303: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 303: DBMS_LOB.FREETEMPORARY(l_final_xml);

299: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
300: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
301:
302: IF l_is_temp_final_xml = 1 THEN
303: DBMS_LOB.FREETEMPORARY(l_final_xml);
304: END IF;
305:
306: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
307: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

Line 306: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);

302: IF l_is_temp_final_xml = 1 THEN
303: DBMS_LOB.FREETEMPORARY(l_final_xml);
304: END IF;
305:
306: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
307: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
308: l_final_xml := append_to_lob(l_err_msg);
309: hr_utility.trace('In get_final_xml 61');
310: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN

Line 307: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

303: DBMS_LOB.FREETEMPORARY(l_final_xml);
304: END IF;
305:
306: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
307: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
308: l_final_xml := append_to_lob(l_err_msg);
309: hr_utility.trace('In get_final_xml 61');
310: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
311: hr_utility.trace('Closing l_final_xml' );

Line 310: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN

306: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
307: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
308: l_final_xml := append_to_lob(l_err_msg);
309: hr_utility.trace('In get_final_xml 61');
310: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
311: hr_utility.trace('Closing l_final_xml' );
312: dbms_lob.close(l_final_xml);
313: END IF;
314: hr_utility.trace('In get_final_xml 62');

Line 312: dbms_lob.close(l_final_xml);

308: l_final_xml := append_to_lob(l_err_msg);
309: hr_utility.trace('In get_final_xml 61');
310: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
311: hr_utility.trace('Closing l_final_xml' );
312: dbms_lob.close(l_final_xml);
313: END IF;
314: hr_utility.trace('In get_final_xml 62');
315: end if;
316: hr_utility.trace('In get_final_xml 65');

Line 323: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN

319: exception
320: when others then
321: hr_utility.trace('In get_final_xml 70');
322:
323: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
324: hr_utility.trace('Raising exception and Closing l_final_xml' );
325: dbms_lob.close(l_final_xml);
326: END IF;
327: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 325: dbms_lob.close(l_final_xml);

321: hr_utility.trace('In get_final_xml 70');
322:
323: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
324: hr_utility.trace('Raising exception and Closing l_final_xml' );
325: dbms_lob.close(l_final_xml);
326: END IF;
327: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
328: hr_utility.trace('Raising exception and Closing p_xml_string' );
329: dbms_lob.close(p_xml_blob);

Line 327: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

323: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
324: hr_utility.trace('Raising exception and Closing l_final_xml' );
325: dbms_lob.close(l_final_xml);
326: END IF;
327: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
328: hr_utility.trace('Raising exception and Closing p_xml_string' );
329: dbms_lob.close(p_xml_blob);
330: END IF;
331: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 329: dbms_lob.close(p_xml_blob);

325: dbms_lob.close(l_final_xml);
326: END IF;
327: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
328: hr_utility.trace('Raising exception and Closing p_xml_string' );
329: dbms_lob.close(p_xml_blob);
330: END IF;
331: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
332: hr_utility.trace('Closing l_temp_blob' );
333: dbms_lob.close(l_temp_blob);

Line 331: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

327: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
328: hr_utility.trace('Raising exception and Closing p_xml_string' );
329: dbms_lob.close(p_xml_blob);
330: END IF;
331: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
332: hr_utility.trace('Closing l_temp_blob' );
333: dbms_lob.close(l_temp_blob);
334: END IF;
335:

Line 333: dbms_lob.close(l_temp_blob);

329: dbms_lob.close(p_xml_blob);
330: END IF;
331: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
332: hr_utility.trace('Closing l_temp_blob' );
333: dbms_lob.close(l_temp_blob);
334: END IF;
335:
336: hr_utility.trace('sqleerm ' || SQLERRM);
337: raise;

Line 1196: l_is_temp_final_xml := dbms_lob.istemporary(p_xml_blob);

1192: hr_utility.trace('after writing in magtape');
1193: end if;
1194:
1195: if trim(called_from) = 'get_final_xml' then
1196: l_is_temp_final_xml := dbms_lob.istemporary(p_xml_blob);
1197: IF l_is_temp_final_xml = 1 THEN
1198: DBMS_LOB.FREETEMPORARY(p_xml_blob);
1199: END IF;
1200:

Line 1198: DBMS_LOB.FREETEMPORARY(p_xml_blob);

1194:
1195: if trim(called_from) = 'get_final_xml' then
1196: l_is_temp_final_xml := dbms_lob.istemporary(p_xml_blob);
1197: IF l_is_temp_final_xml = 1 THEN
1198: DBMS_LOB.FREETEMPORARY(p_xml_blob);
1199: END IF;
1200:
1201: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);
1202: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);

Line 1201: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);

1197: IF l_is_temp_final_xml = 1 THEN
1198: DBMS_LOB.FREETEMPORARY(p_xml_blob);
1199: END IF;
1200:
1201: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);
1202: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
1203: p_xml_blob := append_to_lob(l_employee_xml);
1204:
1205: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 1202: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);

1198: DBMS_LOB.FREETEMPORARY(p_xml_blob);
1199: END IF;
1200:
1201: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);
1202: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
1203: p_xml_blob := append_to_lob(l_employee_xml);
1204:
1205: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1206: hr_utility.trace('Closing p_xml_blob' );

Line 1205: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

1201: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);
1202: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
1203: p_xml_blob := append_to_lob(l_employee_xml);
1204:
1205: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1206: hr_utility.trace('Closing p_xml_blob' );
1207: dbms_lob.close(p_xml_blob);
1208: hr_utility.trace('closed p_xml_blob');
1209: END IF;

Line 1207: dbms_lob.close(p_xml_blob);

1203: p_xml_blob := append_to_lob(l_employee_xml);
1204:
1205: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1206: hr_utility.trace('Closing p_xml_blob' );
1207: dbms_lob.close(p_xml_blob);
1208: hr_utility.trace('closed p_xml_blob');
1209: END IF;
1210: end if;
1211: hr_utility.trace(l_employee_xml);