APPS.PER_DATA_UPDATE_REPORT dependencies on DBMS_LOB

Line 237: dbms_lob.createtemporary(l_xfdf_string, FALSE, DBMS_LOB.CALL);

233: l_str_g_process := 'G_PROCESS';
234: l_str_g_status := 'G_STATUS';
235: l_str_g_criticality := 'G_CRITICALITY';
236: --
237: dbms_lob.createtemporary(l_xfdf_string, FALSE, DBMS_LOB.CALL);
238: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
239: dbms_lob.createtemporary(l_xfdf_blob,TRUE);
240: hr_xml_pub_utility.clob_to_blob(l_xfdf_string,l_xfdf_blob);
241: --

Line 238: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

234: l_str_g_status := 'G_STATUS';
235: l_str_g_criticality := 'G_CRITICALITY';
236: --
237: dbms_lob.createtemporary(l_xfdf_string, FALSE, DBMS_LOB.CALL);
238: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
239: dbms_lob.createtemporary(l_xfdf_blob,TRUE);
240: hr_xml_pub_utility.clob_to_blob(l_xfdf_string,l_xfdf_blob);
241: --
242: --

Line 239: dbms_lob.createtemporary(l_xfdf_blob,TRUE);

235: l_str_g_criticality := 'G_CRITICALITY';
236: --
237: dbms_lob.createtemporary(l_xfdf_string, FALSE, DBMS_LOB.CALL);
238: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
239: dbms_lob.createtemporary(l_xfdf_blob,TRUE);
240: hr_xml_pub_utility.clob_to_blob(l_xfdf_string,l_xfdf_blob);
241: --
242: --
243: dt_fndate.set_effective_date(trunc(sysdate));

Line 632: dbms_lob.writeAppend(l_xfdf_string, length('<' || l_str_start || '>'),

628: -- Writing to a BLOB
629: --
630: --
631: --
632: dbms_lob.writeAppend(l_xfdf_string, length('<' || l_str_start || '>'),
633: '<' || l_str_start || '>');
634: --
635: -- DATABASE NAME
636: --

Line 638: dbms_lob.writeAppend(l_xfdf_string,

634: --
635: -- DATABASE NAME
636: --
637: select name into l_database_name from v$database;
638: dbms_lob.writeAppend(l_xfdf_string,
639: length('' || l_database_name || ''),
640: '' || l_database_name || '');
641: --
642: -- derive SUMMARY information

Line 647: dbms_lob.writeAppend(l_xfdf_string,

643: --
644: IF summXMLTable.count > 0 then
645: FOR ctr_summ_table in summXMLTable.FIRST .. summXMLTable.LAST LOOP
646: l_strsumm1 := summXMLTable(ctr_summ_table).TagValue;
647: dbms_lob.writeAppend(l_xfdf_string,
648: length(l_strsumm1),
649: l_strsumm1);
650: END LOOP;
651: END IF;

Line 658: dbms_lob.writeAppend(l_xfdf_string,

654: --
655: IF critXMLTable.count > 0 then
656: FOR ctr_crit_table in critXMLTable.FIRST .. critXMLTable.LAST LOOP
657: l_strsumm2 := critXMLTable(ctr_crit_table).TagValue;
658: dbms_lob.writeAppend(l_xfdf_string,
659: length(l_strsumm2),
660: l_strsumm2);
661: END LOOP;
662: END IF;

Line 665: dbms_lob.writeAppend(l_xfdf_string,length(''),

661: END LOOP;
662: END IF;
663: --
664: --
665: dbms_lob.writeAppend(l_xfdf_string,length(''),
666: '');
667: --
668: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob, TRUE);
669: hr_xml_pub_utility.clob_to_blob(l_xfdf_string, l_xfdf_blob);

Line 668: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob, TRUE);

664: --
665: dbms_lob.writeAppend(l_xfdf_string,length(''),
666: '');
667: --
668: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob, TRUE);
669: hr_xml_pub_utility.clob_to_blob(l_xfdf_string, l_xfdf_blob);
670: --
671: end POPULATE_REPORT_DATA;
672: