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_RL1_MAG dependencies on DBMS_LOB

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

31:
32: raw_data:=utl_raw.cast_to_raw(p_text);
33: text_size:=utl_raw.length(raw_data);
34:
35: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
36: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
37:
38: dbms_lob.writeappend(temp_blob,
39: text_size,

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

32: raw_data:=utl_raw.cast_to_raw(p_text);
33: text_size:=utl_raw.length(raw_data);
34:
35: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
36: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
37:
38: dbms_lob.writeappend(temp_blob,
39: text_size,
40: raw_data);

Line 38: dbms_lob.writeappend(temp_blob,

34:
35: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
36: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
37:
38: dbms_lob.writeappend(temp_blob,
39: text_size,
40: raw_data);
41:
42: IF dbms_lob.ISOPEN(temp_blob)=1 THEN

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

38: dbms_lob.writeappend(temp_blob,
39: text_size,
40: raw_data);
41:
42: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
43: hr_utility.trace('Closing temp_lob' );
44: dbms_lob.close(temp_blob);
45: hr_utility.trace('Closed temp_lob' );
46: END IF;

Line 44: dbms_lob.close(temp_blob);

40: raw_data);
41:
42: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
43: hr_utility.trace('Closing temp_lob' );
44: dbms_lob.close(temp_blob);
45: hr_utility.trace('Closed temp_lob' );
46: END IF;
47:
48: return temp_blob;

Line 59: dbms_lob.createtemporary(v_blob, TRUE);

55: v_offsetwrite NUMBER DEFAULT 1;
56: v_amountwrite NUMBER;
57: v_buffer VARCHAR2(4096 CHAR);
58: BEGIN
59: dbms_lob.createtemporary(v_blob, TRUE);
60:
61: Begin
62: LOOP
63: dbms_lob.READ(p_clob, v_amount, v_offset, v_buffer);

Line 63: dbms_lob.READ(p_clob, v_amount, v_offset, v_buffer);

59: dbms_lob.createtemporary(v_blob, TRUE);
60:
61: Begin
62: LOOP
63: dbms_lob.READ(p_clob, v_amount, v_offset, v_buffer);
64:
65: v_amountwrite := utl_raw.length(utl_raw.cast_to_raw(v_buffer));
66: dbms_lob.WRITE(v_blob, v_amountwrite, v_offsetwrite, utl_raw.cast_to_raw(v_buffer));
67:

Line 66: dbms_lob.WRITE(v_blob, v_amountwrite, v_offsetwrite, utl_raw.cast_to_raw(v_buffer));

62: LOOP
63: dbms_lob.READ(p_clob, v_amount, v_offset, v_buffer);
64:
65: v_amountwrite := utl_raw.length(utl_raw.cast_to_raw(v_buffer));
66: dbms_lob.WRITE(v_blob, v_amountwrite, v_offsetwrite, utl_raw.cast_to_raw(v_buffer));
67:
68: v_offsetwrite := v_offsetwrite + v_amountwrite;
69:
70: v_offset := v_offset + v_amount;

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

1300: 'Y',
1301: 'get_final_xml',
1302: p_xml_blob);
1303:
1304: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
1305: hr_utility.trace('1. final 1. XML l_final_xml '||
1306: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1307: hr_utility.trace('In get_final_xml 30');
1308:

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

1302: p_xml_blob);
1303:
1304: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
1305: hr_utility.trace('1. final 1. XML l_final_xml '||
1306: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1307: hr_utility.trace('In get_final_xml 30');
1308:
1309: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1310: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );

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

1305: hr_utility.trace('1. final 1. XML l_final_xml '||
1306: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1307: hr_utility.trace('In get_final_xml 30');
1308:
1309: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1310: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1311:
1312: IF l_is_temp_final_xml = 1 THEN
1313: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 1313: DBMS_LOB.FREETEMPORARY(l_final_xml);

1309: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1310: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1311:
1312: IF l_is_temp_final_xml = 1 THEN
1313: DBMS_LOB.FREETEMPORARY(l_final_xml);
1314: END IF;
1315:
1316: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1317: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

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

1312: IF l_is_temp_final_xml = 1 THEN
1313: DBMS_LOB.FREETEMPORARY(l_final_xml);
1314: END IF;
1315:
1316: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1317: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1318: l_final_xml := append_to_lob(l_header_xml_string);
1319: dbms_lob.append(l_final_xml,p_xml_blob);
1320: hr_utility.trace('In get_final_xml 40');

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

1313: DBMS_LOB.FREETEMPORARY(l_final_xml);
1314: END IF;
1315:
1316: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1317: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1318: l_final_xml := append_to_lob(l_header_xml_string);
1319: dbms_lob.append(l_final_xml,p_xml_blob);
1320: hr_utility.trace('In get_final_xml 40');
1321:

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

1315:
1316: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1317: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1318: l_final_xml := append_to_lob(l_header_xml_string);
1319: dbms_lob.append(l_final_xml,p_xml_blob);
1320: hr_utility.trace('In get_final_xml 40');
1321:
1322: l_trailer_xml := ''||EOL;
1323:

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

1321:
1322: l_trailer_xml := ''||EOL;
1323:
1324: hr_utility.trace('In get_final_xml 50');
1325: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1326: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1327: l_temp_blob := append_to_lob(l_trailer_xml);
1328: dbms_lob.append(l_final_xml,l_temp_blob);
1329:

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

1322: l_trailer_xml := ''||EOL;
1323:
1324: hr_utility.trace('In get_final_xml 50');
1325: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1326: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1327: l_temp_blob := append_to_lob(l_trailer_xml);
1328: dbms_lob.append(l_final_xml,l_temp_blob);
1329:
1330: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN

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

1324: hr_utility.trace('In get_final_xml 50');
1325: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1326: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1327: l_temp_blob := append_to_lob(l_trailer_xml);
1328: dbms_lob.append(l_final_xml,l_temp_blob);
1329:
1330: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1331: hr_utility.trace('Closing l_final_xml' );
1332: dbms_lob.close(l_final_xml);

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

1326: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1327: l_temp_blob := append_to_lob(l_trailer_xml);
1328: dbms_lob.append(l_final_xml,l_temp_blob);
1329:
1330: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1331: hr_utility.trace('Closing l_final_xml' );
1332: dbms_lob.close(l_final_xml);
1333: END IF;
1334: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 1332: dbms_lob.close(l_final_xml);

1328: dbms_lob.append(l_final_xml,l_temp_blob);
1329:
1330: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1331: hr_utility.trace('Closing l_final_xml' );
1332: dbms_lob.close(l_final_xml);
1333: END IF;
1334: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1335: hr_utility.trace('Closing p_xml_blob' );
1336: dbms_lob.close(p_xml_blob);

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

1330: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1331: hr_utility.trace('Closing l_final_xml' );
1332: dbms_lob.close(l_final_xml);
1333: END IF;
1334: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1335: hr_utility.trace('Closing p_xml_blob' );
1336: dbms_lob.close(p_xml_blob);
1337: END IF;
1338: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1336: dbms_lob.close(p_xml_blob);

1332: dbms_lob.close(l_final_xml);
1333: END IF;
1334: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1335: hr_utility.trace('Closing p_xml_blob' );
1336: dbms_lob.close(p_xml_blob);
1337: END IF;
1338: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1339: hr_utility.trace('Closing l_temp_blob' );
1340: dbms_lob.close(l_temp_blob);

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

1334: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1335: hr_utility.trace('Closing p_xml_blob' );
1336: dbms_lob.close(p_xml_blob);
1337: END IF;
1338: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1339: hr_utility.trace('Closing l_temp_blob' );
1340: dbms_lob.close(l_temp_blob);
1341: END IF;
1342: hr_utility.trace('In get_final_xml 60');

Line 1340: dbms_lob.close(l_temp_blob);

1336: dbms_lob.close(p_xml_blob);
1337: END IF;
1338: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1339: hr_utility.trace('Closing l_temp_blob' );
1340: dbms_lob.close(l_temp_blob);
1341: END IF;
1342: hr_utility.trace('In get_final_xml 60');
1343: else
1344: hr_utility.trace('Negative employee');

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

1347: INTO l_err_msg;
1348: CLOSE cur_get_meaning;
1349:
1350: l_err_msg := 'Error:'||l_err_msg;
1351: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1352: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1353:
1354: IF l_is_temp_final_xml = 1 THEN
1355: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 1355: DBMS_LOB.FREETEMPORARY(l_final_xml);

1351: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1352: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1353:
1354: IF l_is_temp_final_xml = 1 THEN
1355: DBMS_LOB.FREETEMPORARY(l_final_xml);
1356: END IF;
1357:
1358: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1359: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

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

1354: IF l_is_temp_final_xml = 1 THEN
1355: DBMS_LOB.FREETEMPORARY(l_final_xml);
1356: END IF;
1357:
1358: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1359: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1360: l_final_xml := append_to_lob(l_err_msg);
1361: hr_utility.trace('In get_final_xml 61');
1362: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN

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

1355: DBMS_LOB.FREETEMPORARY(l_final_xml);
1356: END IF;
1357:
1358: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1359: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1360: l_final_xml := append_to_lob(l_err_msg);
1361: hr_utility.trace('In get_final_xml 61');
1362: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1363: hr_utility.trace('Closing l_final_xml' );

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

1358: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1359: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1360: l_final_xml := append_to_lob(l_err_msg);
1361: hr_utility.trace('In get_final_xml 61');
1362: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1363: hr_utility.trace('Closing l_final_xml' );
1364: dbms_lob.close(l_final_xml);
1365: END IF;
1366: hr_utility.trace('In get_final_xml 62');

Line 1364: dbms_lob.close(l_final_xml);

1360: l_final_xml := append_to_lob(l_err_msg);
1361: hr_utility.trace('In get_final_xml 61');
1362: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1363: hr_utility.trace('Closing l_final_xml' );
1364: dbms_lob.close(l_final_xml);
1365: END IF;
1366: hr_utility.trace('In get_final_xml 62');
1367: end if;
1368: hr_utility.trace('In get_final_xml 65');

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

1372: exception
1373: when others then
1374: hr_utility.trace('In get_final_xml 70');
1375:
1376: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1377: hr_utility.trace('Raising exception and Closing l_final_xml' );
1378: dbms_lob.close(l_final_xml);
1379: END IF;
1380: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 1378: dbms_lob.close(l_final_xml);

1374: hr_utility.trace('In get_final_xml 70');
1375:
1376: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1377: hr_utility.trace('Raising exception and Closing l_final_xml' );
1378: dbms_lob.close(l_final_xml);
1379: END IF;
1380: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1381: hr_utility.trace('Raising exception and Closing p_xml_string' );
1382: dbms_lob.close(p_xml_blob);

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

1376: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1377: hr_utility.trace('Raising exception and Closing l_final_xml' );
1378: dbms_lob.close(l_final_xml);
1379: END IF;
1380: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1381: hr_utility.trace('Raising exception and Closing p_xml_string' );
1382: dbms_lob.close(p_xml_blob);
1383: END IF;
1384: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1382: dbms_lob.close(p_xml_blob);

1378: dbms_lob.close(l_final_xml);
1379: END IF;
1380: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1381: hr_utility.trace('Raising exception and Closing p_xml_string' );
1382: dbms_lob.close(p_xml_blob);
1383: END IF;
1384: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1385: hr_utility.trace('Closing l_temp_blob' );
1386: dbms_lob.close(l_temp_blob);

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

1380: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1381: hr_utility.trace('Raising exception and Closing p_xml_string' );
1382: dbms_lob.close(p_xml_blob);
1383: END IF;
1384: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1385: hr_utility.trace('Closing l_temp_blob' );
1386: dbms_lob.close(l_temp_blob);
1387: END IF;
1388: hr_utility.trace('sqleerm ' || SQLERRM);

Line 1386: dbms_lob.close(l_temp_blob);

1382: dbms_lob.close(p_xml_blob);
1383: END IF;
1384: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1385: hr_utility.trace('Closing l_temp_blob' );
1386: dbms_lob.close(l_temp_blob);
1387: END IF;
1388: hr_utility.trace('sqleerm ' || SQLERRM);
1389: raise;
1390: END get_final_xml;

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

3952: --l_page_break :=' ';
3953: --l_page_break :=''||l_page_break||'';
3954: -- pay_core_files.write_to_magtape_lob(l_page_break);
3955: else
3956: l_is_temp_final_xml := dbms_lob.istemporary(p_xml_blob);
3957: IF l_is_temp_final_xml = 1 THEN
3958: DBMS_LOB.FREETEMPORARY(p_xml_blob);
3959: END IF;
3960:

Line 3958: DBMS_LOB.FREETEMPORARY(p_xml_blob);

3954: -- pay_core_files.write_to_magtape_lob(l_page_break);
3955: else
3956: l_is_temp_final_xml := dbms_lob.istemporary(p_xml_blob);
3957: IF l_is_temp_final_xml = 1 THEN
3958: DBMS_LOB.FREETEMPORARY(p_xml_blob);
3959: END IF;
3960:
3961: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);
3962: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);

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

3957: IF l_is_temp_final_xml = 1 THEN
3958: DBMS_LOB.FREETEMPORARY(p_xml_blob);
3959: END IF;
3960:
3961: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);
3962: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
3963: p_xml_blob := append_to_lob(l_final_xml_string1);
3964:
3965: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);

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

3958: DBMS_LOB.FREETEMPORARY(p_xml_blob);
3959: END IF;
3960:
3961: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);
3962: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
3963: p_xml_blob := append_to_lob(l_final_xml_string1);
3964:
3965: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
3966: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);

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

3961: dbms_lob.createtemporary(p_xml_blob,false,DBMS_LOB.CALL);
3962: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
3963: p_xml_blob := append_to_lob(l_final_xml_string1);
3964:
3965: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
3966: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
3967:
3968: l_temp_blob := append_to_lob(l_final_xml_string2);
3969: dbms_lob.append(p_xml_blob,l_temp_blob);

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

3962: dbms_lob.open(p_xml_blob,dbms_lob.lob_readwrite);
3963: p_xml_blob := append_to_lob(l_final_xml_string1);
3964:
3965: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
3966: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
3967:
3968: l_temp_blob := append_to_lob(l_final_xml_string2);
3969: dbms_lob.append(p_xml_blob,l_temp_blob);
3970:

Line 3969: dbms_lob.append(p_xml_blob,l_temp_blob);

3965: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
3966: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
3967:
3968: l_temp_blob := append_to_lob(l_final_xml_string2);
3969: dbms_lob.append(p_xml_blob,l_temp_blob);
3970:
3971: l_temp_blob := append_to_lob(l_final_xml_string3);
3972: dbms_lob.append(p_xml_blob,l_temp_blob);
3973:

Line 3972: dbms_lob.append(p_xml_blob,l_temp_blob);

3968: l_temp_blob := append_to_lob(l_final_xml_string2);
3969: dbms_lob.append(p_xml_blob,l_temp_blob);
3970:
3971: l_temp_blob := append_to_lob(l_final_xml_string3);
3972: dbms_lob.append(p_xml_blob,l_temp_blob);
3973:
3974: l_temp_blob := append_to_lob(l_final_xml_string4);
3975: dbms_lob.append(p_xml_blob,l_temp_blob);
3976:

Line 3975: dbms_lob.append(p_xml_blob,l_temp_blob);

3971: l_temp_blob := append_to_lob(l_final_xml_string3);
3972: dbms_lob.append(p_xml_blob,l_temp_blob);
3973:
3974: l_temp_blob := append_to_lob(l_final_xml_string4);
3975: dbms_lob.append(p_xml_blob,l_temp_blob);
3976:
3977: l_temp_blob := append_to_lob(l_final_xml_string5);
3978: dbms_lob.append(p_xml_blob,l_temp_blob);
3979:

Line 3978: dbms_lob.append(p_xml_blob,l_temp_blob);

3974: l_temp_blob := append_to_lob(l_final_xml_string4);
3975: dbms_lob.append(p_xml_blob,l_temp_blob);
3976:
3977: l_temp_blob := append_to_lob(l_final_xml_string5);
3978: dbms_lob.append(p_xml_blob,l_temp_blob);
3979:
3980: l_temp_blob := append_to_lob(l_final_xml_string6);
3981: dbms_lob.append(p_xml_blob,l_temp_blob);
3982:

Line 3981: dbms_lob.append(p_xml_blob,l_temp_blob);

3977: l_temp_blob := append_to_lob(l_final_xml_string5);
3978: dbms_lob.append(p_xml_blob,l_temp_blob);
3979:
3980: l_temp_blob := append_to_lob(l_final_xml_string6);
3981: dbms_lob.append(p_xml_blob,l_temp_blob);
3982:
3983: l_temp_blob := clob_to_blob(l_final_xml_string);
3984: dbms_lob.append(p_xml_blob,l_temp_blob);
3985:

Line 3984: dbms_lob.append(p_xml_blob,l_temp_blob);

3980: l_temp_blob := append_to_lob(l_final_xml_string6);
3981: dbms_lob.append(p_xml_blob,l_temp_blob);
3982:
3983: l_temp_blob := clob_to_blob(l_final_xml_string);
3984: dbms_lob.append(p_xml_blob,l_temp_blob);
3985:
3986: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
3987: hr_utility.trace('Closing p_xml_blob' );
3988: dbms_lob.close(p_xml_blob);

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

3982:
3983: l_temp_blob := clob_to_blob(l_final_xml_string);
3984: dbms_lob.append(p_xml_blob,l_temp_blob);
3985:
3986: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
3987: hr_utility.trace('Closing p_xml_blob' );
3988: dbms_lob.close(p_xml_blob);
3989: hr_utility.trace('closed p_xml_blob');
3990: END IF;

Line 3988: dbms_lob.close(p_xml_blob);

3984: dbms_lob.append(p_xml_blob,l_temp_blob);
3985:
3986: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
3987: hr_utility.trace('Closing p_xml_blob' );
3988: dbms_lob.close(p_xml_blob);
3989: hr_utility.trace('closed p_xml_blob');
3990: END IF;
3991: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
3992: hr_utility.trace('Closing l_temp_blob' );

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

3987: hr_utility.trace('Closing p_xml_blob' );
3988: dbms_lob.close(p_xml_blob);
3989: hr_utility.trace('closed p_xml_blob');
3990: END IF;
3991: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
3992: hr_utility.trace('Closing l_temp_blob' );
3993: dbms_lob.close(l_temp_blob);
3994: END IF;
3995: end if; -- called_from

Line 3993: dbms_lob.close(l_temp_blob);

3989: hr_utility.trace('closed p_xml_blob');
3990: END IF;
3991: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
3992: hr_utility.trace('Closing l_temp_blob' );
3993: dbms_lob.close(l_temp_blob);
3994: END IF;
3995: end if; -- called_from
3996: end if; /* end if of if l_neg_balance_exists */
3997: else