APPS.HXC_RDB_PRE_RETRIEVAL dependencies on DBMS_LOB

Line 1184: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);

1180: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
1181: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1182: dbms_xmlgen.closecontext(qryctx1);
1183: l_pre_xml := xmlresult1;
1184: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
1185: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1186: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
1187:
1188:

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

1181: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1182: dbms_xmlgen.closecontext(qryctx1);
1183: l_pre_xml := xmlresult1;
1184: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
1185: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1186: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
1187:
1188:
1189: dbms_lob.writeappend(l_pre_xml, length('

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

1182: dbms_xmlgen.closecontext(qryctx1);
1183: l_pre_xml := xmlresult1;
1184: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
1185: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1186: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
1187:
1188:
1189: dbms_lob.writeappend(l_pre_xml, length('
1190: ' || p_application_code || '

Line 1189: dbms_lob.writeappend(l_pre_xml, length('

1185: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1186: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
1187:
1188:
1189: dbms_lob.writeappend(l_pre_xml, length('
1190: ' || p_application_code || '
1191: ' || p_timecard_status || '
1192: ' || p_attribute_name || '
1193: ' || p_sup_name || '

Line 1206: dbms_lob.writeappend(l_pre_xml, length(' '), ' ');

1202:
1203: ');
1204:
1205:
1206: dbms_lob.writeappend(l_pre_xml, length(' '), ' ');
1207:
1208: OPEN l_dynamic_cursor FOR p_dynamic_sql;
1209: LOOP
1210: FETCH l_dynamic_cursor BULK COLLECT INTO timecard_details_tab LIMIT 300;

Line 1216: dbms_lob.writeappend(l_pre_xml, length('

1212:
1213: FOR l_index IN 1..timecard_details_tab.COUNT
1214: LOOP
1215:
1216: dbms_lob.writeappend(l_pre_xml, length('
1217: ' || timecard_details_tab(l_index).timecard_id || '
1218: ' || timecard_details_tab(l_index).start_time || '
1219: ' || timecard_details_tab(l_index).stop_time || '
1220: ' || timecard_details_tab(l_index).status || '

Line 1242: dbms_lob.writeappend(l_pre_xml, length('

1238: END LOOP;
1239:
1240: CLOSE l_dynamic_cursor;
1241:
1242: dbms_lob.writeappend(l_pre_xml, length('
1243:
1244: '), '
1245:
1246: ');