DBA Data[Home] [Help]

APPS.PAY_NO_ARC_RSEA_07 dependencies on DBMS_LOB

Line 67: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

63: --
64: -- l_str1 := ' ';
65: l_str1 := '';
66:
67: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
68: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
69: --
70: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
71: --

Line 68: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);

64: -- l_str1 := ' ';
65: l_str1 := '';
66:
67: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
68: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
69: --
70: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
71: --
72: IF g_xml_element_table.COUNT > 0 THEN

Line 70: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);

66:
67: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
68: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
69: --
70: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
71: --
72: IF g_xml_element_table.COUNT > 0 THEN
73: --
74: FOR table_counter IN g_xml_element_table.FIRST .. g_xml_element_table.LAST LOOP

Line 96: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);

92: '>' || g_xml_element_table(table_counter).tagvalue ||
93: '';
94: END IF;
95: --
96: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);
97: --
98: END LOOP;
99: --
100: END IF;

Line 134: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

130: --
131: -- l_str1 := ' ';
132: l_str1 := '';
133:
134: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
135: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
136: --
137: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
138: --

Line 135: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);

131: -- l_str1 := ' ';
132: l_str1 := '';
133:
134: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
135: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
136: --
137: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
138: --
139: IF g_xml_element_table.COUNT > 0 THEN

Line 137: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);

133:
134: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
135: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
136: --
137: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
138: --
139: IF g_xml_element_table.COUNT > 0 THEN
140: --
141: FOR table_counter IN g_xml_element_table.FIRST .. g_xml_element_table.LAST LOOP

Line 155: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);

151: || g_xml_element_table(table_counter).tagvalue ||
152: '' || EOL;
153: END IF;
154: --
155: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);
156: --
157: END LOOP;
158: --
159: END IF;