APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on DBMS_LOB

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

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

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

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

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

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

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

68: l_concat_str := '';
69: END IF;
70: END LOOP;
71: IF length(l_concat_str) > 0 THEN
72: dbms_lob.writeAppend( p_xfdf_string, LENGTH(l_concat_str), l_concat_str);
73: END IF;
74: ELSE
75: --l_str1 := CONVERT(l_str,'UTF8');
76: dbms_lob.writeAppend( p_xfdf_string, LENGTH(l_str), l_str );

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

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

Line 1495: dbms_lob.freeTemporary(l_xml);

1491: WritetoCLOB(p_xfdf_string => l_xml);
1492: --
1493: p_xml := l_xml;
1494: --
1495: dbms_lob.freeTemporary(l_xml);
1496: --
1497: g_xml_nwr.delete();
1498: --
1499: END generate;