DBA Data[Home] [Help]

APPS.OTFR2483 dependencies on DBMS_LOB

Line 25: dbms_lob.writeappend(p_xml, length(p_data), p_data);

21: --
22: procedure load_xml (p_xml in out nocopy clob,
23: p_data varchar2) is
24: begin
25: dbms_lob.writeappend(p_xml, length(p_data), p_data);
26: end load_xml;
27: --
28: procedure load_xml_declaration(p_xml in out nocopy clob)
29: is

Line 488: dbms_lob.createtemporary(p_xml, TRUE, dbms_lob.session);

484: --
485: l_training_contrib_rec csr_comp_training_contrib_info%ROWTYPE;
486: --
487: begin
488: dbms_lob.createtemporary(p_xml, TRUE, dbms_lob.session);
489: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
490: load_xml_declaration(p_xml);
491: load_xml(p_xml,'FIELDS',c_OpenGrpTag);
492: --

Line 489: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);

485: l_training_contrib_rec csr_comp_training_contrib_info%ROWTYPE;
486: --
487: begin
488: dbms_lob.createtemporary(p_xml, TRUE, dbms_lob.session);
489: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
490: load_xml_declaration(p_xml);
491: load_xml(p_xml,'FIELDS',c_OpenGrpTag);
492: --
493: open csr_header;

Line 3197: --dbms_lob.createtemporary(p_xml,TRUE);

3193: end if;
3194: end if; -- section Fh
3195: load_xml(p_xml,'FIELDS',c_CloseGrpTag);
3196: --
3197: --dbms_lob.createtemporary(p_xml,TRUE);
3198: --p_xml := g_xml;
3199: hr_utility.trace('Leaving otfr2483.build_XML');
3200: end build_XML;
3201: --