APPS.HXC_SUPERVISOR_DASHBOARD dependencies on DBMS_LOB

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

3194: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
3195: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
3196: dbms_xmlgen.closecontext(qryctx1);
3197: l_pre_xml := xmlresult1;
3198: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
3199: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
3200: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
3201:
3202: IF g_debug THEN

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

3195: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
3196: dbms_xmlgen.closecontext(qryctx1);
3197: l_pre_xml := xmlresult1;
3198: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
3199: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
3200: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
3201:
3202: IF g_debug THEN
3203: l_proc := g_package||' Generate XML';

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

3196: dbms_xmlgen.closecontext(qryctx1);
3197: l_pre_xml := xmlresult1;
3198: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
3199: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
3200: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
3201:
3202: IF g_debug THEN
3203: l_proc := g_package||' Generate XML';
3204: hr_utility.set_location('Entering : '|| l_proc, 30);

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

3204: hr_utility.set_location('Entering : '|| l_proc, 30);
3205: END IF;
3206:
3207: l_time_period := p_start_time ||' - '||p_stop_time;
3208: dbms_lob.writeappend(l_pre_xml, length('
3209: '||p_recurring_period||'
3210: '||l_time_period||'
3211: '||l_supervisor_name||'
3212: '||l_location_name||'

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

3221: '||l_organization_name||'
3222: ');
3223:
3224:
3225: dbms_lob.writeappend(l_pre_xml, length(' '), ' ');
3226:
3227:
3228:
3229: IF p_supervisor_id IS NOT NULL

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

3262:
3263: FOR l_index IN 1..timecard_details_tab.COUNT
3264: LOOP
3265:
3266: dbms_lob.writeappend(l_pre_xml, length('
3267: ' || timecard_details_tab(l_index).person_type || '
3268: ' || timecard_details_tab(l_index).person_name || '
3269: ' || timecard_details_tab(l_index).person_number || '
3270: ' || timecard_details_tab(l_index).meaning || '

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

3300: END LOOP;
3301:
3302: CLOSE l_dynamic_cursor;
3303:
3304: dbms_lob.writeappend(l_pre_xml, length('
3305:
3306: '), '
3307:
3308: ');