APPS.PAY_PAYROLL_EXTRACT dependencies on DBMS_LOB

Line 327: --storage_limit := DBMS_LOB.GET_STORAGE_LIMIT();

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));
329:
330: if rowKount = 0 then
331: debug_mesg := 'In get_xmldoc_clob Query return: No Data Found';

Line 334: clob_length := dbms_lob.getlength(tmp_clob);

330: if rowKount = 0 then
331: debug_mesg := 'In get_xmldoc_clob Query return: No Data Found';
332: raise noDataFound;
333: else
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);