APPS.OTA_FR_TRG_SUM dependencies on DBMS_LOB

Line 44: dbms_lob.writeappend(p_xml, length(p_tag), p_tag);

40: procedure xml_t (p_xml in out nocopy clob,
41: p_tag varchar2) is
42: begin
43:
44: dbms_lob.writeappend(p_xml, length(p_tag), p_tag);
45:
46: end xml_t;
47:
48:

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

127:
128: BEGIN
129:
130: -- hr_utility.trace_on(NULL,'TRG');
131: dbms_lob.createtemporary(p_xml, TRUE, dbms_lob.session);
132: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
133: xml_utf8(p_xml);
134: xml_t(p_xml,'');
135: l_date_from:=trunc(fnd_date.canonical_to_date(p_date_from));

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

128: BEGIN
129:
130: -- hr_utility.trace_on(NULL,'TRG');
131: dbms_lob.createtemporary(p_xml, TRUE, dbms_lob.session);
132: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
133: xml_utf8(p_xml);
134: xml_t(p_xml,'');
135: l_date_from:=trunc(fnd_date.canonical_to_date(p_date_from));
136: l_date_to:=trunc(fnd_date.canonical_to_date(p_date_to));