APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on DBMS_LOB

Line 63: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);

59: l_len NUMBER;
60: BEGIN
61: --l_str := ' ';
62: l_str := ' ';
63: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);
64: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);
65: IF g_xml_nwr.count > 0 THEN
66: l_concat_str := '';
67: FOR ctr_table IN g_xml_nwr.FIRST .. g_xml_nwr.LAST LOOP

Line 64: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);

60: BEGIN
61: --l_str := ' ';
62: l_str := ' ';
63: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);
64: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);
65: IF g_xml_nwr.count > 0 THEN
66: l_concat_str := '';
67: FOR ctr_table IN g_xml_nwr.FIRST .. g_xml_nwr.LAST LOOP
68: l_concat_str := l_concat_str || g_xml_nwr(ctr_table);

Line 71: dbms_lob.writeAppend( p_xfdf_string, l_len, l_concat_str);

67: FOR ctr_table IN g_xml_nwr.FIRST .. g_xml_nwr.LAST LOOP
68: l_concat_str := l_concat_str || g_xml_nwr(ctr_table);
69: l_len := length(l_concat_str);
70: IF l_len > 28000 then
71: dbms_lob.writeAppend( p_xfdf_string, l_len, l_concat_str);
72: l_concat_str := '';
73: END IF;
74: END LOOP;
75: IF length(l_concat_str) > 0 THEN

Line 76: dbms_lob.writeAppend( p_xfdf_string, LENGTH(l_concat_str), l_concat_str);

72: l_concat_str := '';
73: END IF;
74: END LOOP;
75: IF length(l_concat_str) > 0 THEN
76: dbms_lob.writeAppend( p_xfdf_string, LENGTH(l_concat_str), l_concat_str);
77: END IF;
78: ELSE
79: --l_str1 := CONVERT(l_str,'UTF8');
80: dbms_lob.writeAppend( p_xfdf_string, LENGTH(l_str), l_str );

Line 80: dbms_lob.writeAppend( p_xfdf_string, LENGTH(l_str), l_str );

76: dbms_lob.writeAppend( p_xfdf_string, LENGTH(l_concat_str), l_concat_str);
77: END IF;
78: ELSE
79: --l_str1 := CONVERT(l_str,'UTF8');
80: dbms_lob.writeAppend( p_xfdf_string, LENGTH(l_str), l_str );
81: END IF;
82: END WritetoCLOB;
83: -------------------------------------------------------------------------------
84: -- YES_NO

Line 2132: dbms_lob.freeTemporary(l_xml);

2128: WritetoCLOB(p_xfdf_string => l_xml);
2129: --
2130: p_xml := l_xml;
2131: --
2132: dbms_lob.freeTemporary(l_xml);
2133: --
2134: g_xml_nwr.delete();
2135: --
2136: END generate;