APPS.HXC_RDB_POST_RETRIEVAL dependencies on DBMS_LOB

Line 2425: dbms_lob.write(l_post_xml, length(l_report_info), 1, l_report_info);

2421: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
2422: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
2423: dbms_xmlgen.closecontext(qryctx1);
2424: l_post_xml := xmlresult1;
2425: dbms_lob.write(l_post_xml, length(l_report_info), 1, l_report_info);
2426: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
2427: dbms_lob.copy(l_post_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
2428:
2429:

Line 2426: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

2422: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
2423: dbms_xmlgen.closecontext(qryctx1);
2424: l_post_xml := xmlresult1;
2425: dbms_lob.write(l_post_xml, length(l_report_info), 1, l_report_info);
2426: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
2427: dbms_lob.copy(l_post_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
2428:
2429:
2430: dbms_lob.writeappend(l_post_xml, length('

Line 2427: dbms_lob.copy(l_post_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);

2423: dbms_xmlgen.closecontext(qryctx1);
2424: l_post_xml := xmlresult1;
2425: dbms_lob.write(l_post_xml, length(l_report_info), 1, l_report_info);
2426: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
2427: dbms_lob.copy(l_post_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
2428:
2429:
2430: dbms_lob.writeappend(l_post_xml, length('
2431: ' || p_application_code || '

Line 2430: dbms_lob.writeappend(l_post_xml, length('

2426: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
2427: dbms_lob.copy(l_post_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
2428:
2429:
2430: dbms_lob.writeappend(l_post_xml, length('
2431: ' || p_application_code || '
2432: ' || p_batch_name || '
2433: ' || p_attribute_name || '
2434: ' || p_sup_name || '

Line 2453: dbms_lob.writeappend(l_post_xml, length(' '), ' ');

2449:
2450: ');
2451:
2452:
2453: dbms_lob.writeappend(l_post_xml, length(' '), ' ');
2454:
2455: OPEN l_dynamic_cursor FOR p_dynamic_sql;
2456: LOOP
2457: FETCH l_dynamic_cursor BULK COLLECT INTO timecard_details_tab LIMIT 300;

Line 2463: dbms_lob.writeappend(l_post_xml, length('

2459:
2460: FOR l_index IN 1..timecard_details_tab.COUNT
2461: LOOP
2462:
2463: dbms_lob.writeappend(l_post_xml, length('
2464: ' || timecard_details_tab(l_index).timecard_id || '
2465: ' || timecard_details_tab(l_index).start_time || '
2466: ' || timecard_details_tab(l_index).stop_time || '
2467: ' || timecard_details_tab(l_index).status || '

Line 2487: dbms_lob.writeappend(l_post_xml, length('

2483: END LOOP;
2484:
2485: CLOSE l_dynamic_cursor;
2486:
2487: dbms_lob.writeappend(l_post_xml, length('
2488:
2489: '), '
2490:
2491: ');