14: engine xslprocessor.Processor;
15: parser xmlparser.parser;
16: xmldoc xmldom.DOMDocument;
17: clobdoc CLOB;
18: ctx DBMS_XMLQUERY.ctxType;
19: tv_sheet utl_http.html_pieces;
20: l_index number;
21: begin
22: l_query:= 'select hr_xml_packet_id_s.nextval packetId'
432: end loop;
433: end if;
434:
435:
436: ctx:= dbms_xmlquery.newContext(l_query);
437: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
438: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
439: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
440: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
433: end if;
434:
435:
436: ctx:= dbms_xmlquery.newContext(l_query);
437: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
438: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
439: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
440: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
441: clobdoc:=dbms_xmlquery.getXML(ctx);
434:
435:
436: ctx:= dbms_xmlquery.newContext(l_query);
437: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
438: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
439: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
440: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
441: clobdoc:=dbms_xmlquery.getXML(ctx);
442: dbms_xmlquery.closeContext(ctx);
435:
436: ctx:= dbms_xmlquery.newContext(l_query);
437: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
438: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
439: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
440: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
441: clobdoc:=dbms_xmlquery.getXML(ctx);
442: dbms_xmlquery.closeContext(ctx);
443: --
436: ctx:= dbms_xmlquery.newContext(l_query);
437: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
438: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
439: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
440: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
441: clobdoc:=dbms_xmlquery.getXML(ctx);
442: dbms_xmlquery.closeContext(ctx);
443: --
444: parser:=xmlparser.newparser;
437: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
438: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
439: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
440: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
441: clobdoc:=dbms_xmlquery.getXML(ctx);
442: dbms_xmlquery.closeContext(ctx);
443: --
444: parser:=xmlparser.newparser;
445: -- parse the clob document
438: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
439: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
440: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
441: clobdoc:=dbms_xmlquery.getXML(ctx);
442: dbms_xmlquery.closeContext(ctx);
443: --
444: parser:=xmlparser.newparser;
445: -- parse the clob document
446: xmlparser.parseCLOB(parser,clobdoc);