APPS.PAY_IN_SOE dependencies on DBMS_LOB

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

145:
146: pay_in_utils.trace('l_str ',l_str);
147: pay_in_utils.set_location(g_debug,l_procedure,20);
148:
149: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
150:
151: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
152:
153: END append_tag;

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

182: pay_in_utils.trace ('**************************************************','********************');
183: END IF;
184:
185: l_str:= '<'||p_tag_name||'>';
186: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
187:
188: pay_in_utils.trace('l_str ',l_str);
189: pay_in_utils.set_location(g_debug,l_procedure,20);
190:

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

222: pay_in_utils.trace ('**************************************************','********************');
223: END IF;
224:
225: l_str:= '';
226: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
227:
228: pay_in_utils.trace('l_str ',l_str);
229: pay_in_utils.set_location(g_debug,l_procedure,20);
230:

Line 1454: dbms_lob.close(g_tmp_clob);

1450: --
1451: IF ( l_emp_cnt <> 0) THEN
1452: --
1453: close_tag('clob');
1454: dbms_lob.close(g_tmp_clob);
1455: g_clob(g_clob_cnt):=g_tmp_clob;
1456: l_emp_cnt := 0;
1457: --
1458: END IF;

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

1466:
1467: -- Open a new CLOB
1468: --
1469: pay_in_utils.set_location(g_debug,'Before Create Temporary',150);
1470: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
1471:
1472: pay_in_utils.set_location(g_debug,'Before Open',160);
1473: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
1474:

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

1469: pay_in_utils.set_location(g_debug,'Before Create Temporary',150);
1470: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
1471:
1472: pay_in_utils.set_location(g_debug,'Before Open',160);
1473: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
1474:
1475: -- Append Open tags to new CLOB
1476: --
1477: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

1473: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
1474:
1475: -- Append Open tags to new CLOB
1476: --
1477: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1478: --
1479: END IF;
1480:
1481: pay_in_utils.set_location(g_debug,'Before employee tag',170);

Line 1539: dbms_lob.close(g_tmp_clob);

1535: IF ( g_clob_cnt <> 0) THEN
1536: --
1537: pay_in_utils.set_location(g_debug,'Closing last clob',200);
1538: close_tag('clob');
1539: dbms_lob.close(g_tmp_clob);
1540: g_clob(g_clob_cnt):=g_tmp_clob;
1541: --
1542:
1543: END IF;