APPS.PAY_PAYROLL_EXTRACT dependencies on DBMS_XMLGEN

Line 26: l_qryCtx DBMS_XMLGEN.ctxHandle;

22:
23: l_proc VARCHAR2(100) := g_package||'.get_xmldoc_clob';
24: tmp_clob CLOB;
25: l_query VARCHAR2(32000);
26: l_qryCtx DBMS_XMLGEN.ctxHandle;
27: storage_limit integer;
28: clob_length number;
29:
30: lv_assignment_set_id varchar2(30);

Line 318: l_qryCtx := dbms_xmlgen.newcontext(l_query);

314: hr_utility.trace ('Processing '||p_payroll_action_id);
315:
316: hr_utility.trace('setting l_qryCtx');
317:
318: l_qryCtx := dbms_xmlgen.newcontext(l_query);
319:
320: hr_utility.trace('calling xml l_qryCtx');
321:
322: tmp_clob := dbms_xmlgen.getxml(l_qryCtx);

Line 322: tmp_clob := dbms_xmlgen.getxml(l_qryCtx);

318: l_qryCtx := dbms_xmlgen.newcontext(l_query);
319:
320: hr_utility.trace('calling xml l_qryCtx');
321:
322: tmp_clob := dbms_xmlgen.getxml(l_qryCtx);
323:
324: rowKount := dbms_xmlgen.getnumrowsprocessed(l_qryCtx);
325: hr_utility.trace('rowKount = '||rowKount);
326:

Line 324: rowKount := dbms_xmlgen.getnumrowsprocessed(l_qryCtx);

320: hr_utility.trace('calling xml l_qryCtx');
321:
322: tmp_clob := dbms_xmlgen.getxml(l_qryCtx);
323:
324: rowKount := dbms_xmlgen.getnumrowsprocessed(l_qryCtx);
325: hr_utility.trace('rowKount = '||rowKount);
326:
327: --storage_limit := DBMS_LOB.GET_STORAGE_LIMIT();
328: --hr_utility.trace ('storage_limit '||to_char(storage_limit));

Line 338: DBMS_XMLGEN.closeContext(l_qryCtx);

334: clob_length := dbms_lob.getlength(tmp_clob);
335: hr_utility.trace('clob length '||to_char(clob_length));
336: end if;
337:
338: DBMS_XMLGEN.closeContext(l_qryCtx);
339: hr_utility.trace('Leaving '||l_proc);
340: return tmp_clob;
341:
342: EXCEPTION