APPS.OTA_FR_PLAN_DFORM dependencies on DBMS_LOB

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

168: ref_csr_training_plan ref_cursor_type;
169: --
170: BEGIN
171: -- Starting to build the XML string
172: dbms_lob.createtemporary(p_xml, TRUE, dbms_lob.session);
173: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
174: load_xml_declaration(p_xml);
175: load_xml_label(p_xml,'FIELDS',TRUE);
176: --

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

169: --
170: BEGIN
171: -- Starting to build the XML string
172: dbms_lob.createtemporary(p_xml, TRUE, dbms_lob.session);
173: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
174: load_xml_declaration(p_xml);
175: load_xml_label(p_xml,'FIELDS',TRUE);
176: --
177: -- Building up the main cursor to fetch training plans and corresponding training plan values

Line 606: dbms_lob.writeappend(p_xml,

602: p_data varchar2) is
603: begin
604:
605: if g_convert_to_utf8 then
606: dbms_lob.writeappend(p_xml,
607: length(convert(p_data,'UTF8')),
608: convert(p_data,'UTF8'));
609: else
610: dbms_lob.writeappend(p_xml, length(p_data), p_data);

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

606: dbms_lob.writeappend(p_xml,
607: length(convert(p_data,'UTF8')),
608: convert(p_data,'UTF8'));
609: else
610: dbms_lob.writeappend(p_xml, length(p_data), p_data);
611: end if;
612: end write_to_clob;
613: --------------------------------------------------------------------
614: END OTA_FR_PLAN_DFORM;