APPS.PAY_IN_SOE dependencies on DBMS_LOB

Line 159: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);

155:
156: pay_in_utils.trace('l_str ',l_str);
157: pay_in_utils.set_location(g_debug,l_procedure,20);
158:
159: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
160:
161: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
162:
163: END append_tag;

Line 196: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);

192: pay_in_utils.trace ('**************************************************','********************');
193: END IF;
194:
195: l_str:= '<'||p_tag_name||'>';
196: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
197:
198: pay_in_utils.trace('l_str ',l_str);
199: pay_in_utils.set_location(g_debug,l_procedure,20);
200:

Line 236: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);

232: pay_in_utils.trace ('**************************************************','********************');
233: END IF;
234:
235: l_str:= '';
236: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
237:
238: pay_in_utils.trace('l_str ',l_str);
239: pay_in_utils.set_location(g_debug,l_procedure,20);
240:

Line 1786: dbms_lob.close(g_tmp_clob);

1782: --
1783: IF ( l_emp_cnt <> 0) THEN
1784: --
1785: close_tag('clob');
1786: dbms_lob.close(g_tmp_clob);
1787: g_clob(g_clob_cnt):=g_tmp_clob;
1788: l_emp_cnt := 0;
1789: --
1790: END IF;

Line 1802: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);

1798:
1799: -- Open a new CLOB
1800: --
1801: pay_in_utils.set_location(g_debug,'Before Create Temporary',150);
1802: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
1803:
1804: pay_in_utils.set_location(g_debug,'Before Open',160);
1805: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
1806:

Line 1805: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);

1801: pay_in_utils.set_location(g_debug,'Before Create Temporary',150);
1802: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
1803:
1804: pay_in_utils.set_location(g_debug,'Before Open',160);
1805: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
1806:
1807: -- Append Open tags to new CLOB
1808: --
1809: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

Line 1809: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1805: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
1806:
1807: -- Append Open tags to new CLOB
1808: --
1809: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1810: --
1811: END IF;
1812:
1813: pay_in_utils.set_location(g_debug,'Before employee tag',170);

Line 1873: dbms_lob.close(g_tmp_clob);

1869: IF ( g_clob_cnt <> 0) THEN
1870: --
1871: pay_in_utils.set_location(g_debug,'Closing last clob',200);
1872: close_tag('clob');
1873: dbms_lob.close(g_tmp_clob);
1874: g_clob(g_clob_cnt):=g_tmp_clob;
1875: --
1876:
1877: END IF;

Line 2124: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);

2120:
2121: pay_in_utils.set_location(g_debug,'Before execute',50);
2122: l_dummy := dbms_sql.execute(l_sql_csr);
2123:
2124: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2125: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2126: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2127: open_tag('IN_SOE');
2128:

Line 2125: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);

2121: pay_in_utils.set_location(g_debug,'Before execute',50);
2122: l_dummy := dbms_sql.execute(l_sql_csr);
2123:
2124: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2125: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2126: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2127: open_tag('IN_SOE');
2128:
2129: LOOP

Line 2126: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

2122: l_dummy := dbms_sql.execute(l_sql_csr);
2123:
2124: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2125: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2126: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2127: open_tag('IN_SOE');
2128:
2129: LOOP
2130: --

Line 2245: dbms_lob.close(g_tmp_clob);

2241: dbms_sql.close_cursor(l_sql_csr);
2242:
2243:
2244:
2245: dbms_lob.close(g_tmp_clob);
2246: p_xml := g_tmp_clob;
2247: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,220);
2248:
2249: EXCEPTION