eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_JPP_GENERATOR dependencies on DBMS_XMLQUERY

Line 19: ctx DBMS_XMLQUERY.ctxType;

15: engine xslprocessor.Processor;
16: parser xmlparser.parser;
17: xmldoc xmldom.DOMDocument;
18: clobdoc CLOB;
19: ctx DBMS_XMLQUERY.ctxType;
20: tv_sheet utl_http.html_pieces;
21: l_index number;
22: begin
23: l_query:= 'select hr_xml_packet_id_s.nextval packetId'

Line 493: ctx:= dbms_xmlquery.newContext(l_query);

489: end if;
490: end if;
491:
492:
493: ctx:= dbms_xmlquery.newContext(l_query);
494: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
495: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
496: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
497: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');

Line 494: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);

490: end if;
491:
492:
493: ctx:= dbms_xmlquery.newContext(l_query);
494: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
495: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
496: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
497: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
498: clobdoc:=dbms_xmlquery.getXML(ctx);

Line 495: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);

491:
492:
493: ctx:= dbms_xmlquery.newContext(l_query);
494: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
495: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
496: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
497: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
498: clobdoc:=dbms_xmlquery.getXML(ctx);
499: dbms_xmlquery.closeContext(ctx);

Line 496: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);

492:
493: ctx:= dbms_xmlquery.newContext(l_query);
494: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
495: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
496: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
497: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
498: clobdoc:=dbms_xmlquery.getXML(ctx);
499: dbms_xmlquery.closeContext(ctx);
500: --

Line 497: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');

493: ctx:= dbms_xmlquery.newContext(l_query);
494: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
495: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
496: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
497: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
498: clobdoc:=dbms_xmlquery.getXML(ctx);
499: dbms_xmlquery.closeContext(ctx);
500: --
501: parser:=xmlparser.newparser;

Line 498: clobdoc:=dbms_xmlquery.getXML(ctx);

494: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
495: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
496: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
497: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
498: clobdoc:=dbms_xmlquery.getXML(ctx);
499: dbms_xmlquery.closeContext(ctx);
500: --
501: parser:=xmlparser.newparser;
502: -- parse the clob document

Line 499: dbms_xmlquery.closeContext(ctx);

495: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
496: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
497: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
498: clobdoc:=dbms_xmlquery.getXML(ctx);
499: dbms_xmlquery.closeContext(ctx);
500: --
501: parser:=xmlparser.newparser;
502: -- parse the clob document
503: xmlparser.parseCLOB(parser,clobdoc);

Line 559: ctx DBMS_XMLQUERY.ctxType;

555: function getXMLDataFromDB(p_recruitment_activity_id in number
556: ,p_sender_id in number) return clob is
557: l_query varchar2(32767);
558: clobdoc CLOB;
559: ctx DBMS_XMLQUERY.ctxType;
560: begin
561: hr_utility.set_location('Entering getXMLDataFromDB',10);
562: l_query:= 'select hr_xml_packet_id_s.nextval packetId'
563: ||' , ''CREATE'' action'

Line 735: ctx:= dbms_xmlquery.newContext(l_query);

731: ||' and vac.location_id = loc.location_id (+)'
732: ||' and vac.vacancy_id = irc_isc.object_id (+)'
733: ||' and irc_isc.object_type(+) = ''VACANCY'''
734: ||' and rownum=1';
735: ctx:= dbms_xmlquery.newContext(l_query);
736: hr_utility.set_location('After dbms_xmlquery.newContext',20);
737: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
738: hr_utility.set_location('p_recruitment_activity_id:'||p_recruitment_activity_id,30);
739: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);

Line 736: hr_utility.set_location('After dbms_xmlquery.newContext',20);

732: ||' and vac.vacancy_id = irc_isc.object_id (+)'
733: ||' and irc_isc.object_type(+) = ''VACANCY'''
734: ||' and rownum=1';
735: ctx:= dbms_xmlquery.newContext(l_query);
736: hr_utility.set_location('After dbms_xmlquery.newContext',20);
737: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
738: hr_utility.set_location('p_recruitment_activity_id:'||p_recruitment_activity_id,30);
739: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
740: hr_utility.set_location('p_sender_id:'||p_sender_id,40);

Line 737: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);

733: ||' and irc_isc.object_type(+) = ''VACANCY'''
734: ||' and rownum=1';
735: ctx:= dbms_xmlquery.newContext(l_query);
736: hr_utility.set_location('After dbms_xmlquery.newContext',20);
737: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
738: hr_utility.set_location('p_recruitment_activity_id:'||p_recruitment_activity_id,30);
739: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
740: hr_utility.set_location('p_sender_id:'||p_sender_id,40);
741: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);

Line 739: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);

735: ctx:= dbms_xmlquery.newContext(l_query);
736: hr_utility.set_location('After dbms_xmlquery.newContext',20);
737: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
738: hr_utility.set_location('p_recruitment_activity_id:'||p_recruitment_activity_id,30);
739: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
740: hr_utility.set_location('p_sender_id:'||p_sender_id,40);
741: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);

Line 741: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);

737: dbms_xmlquery.setBindValue(ctx,'1',p_recruitment_activity_id);
738: hr_utility.set_location('p_recruitment_activity_id:'||p_recruitment_activity_id,30);
739: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
740: hr_utility.set_location('p_sender_id:'||p_sender_id,40);
741: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);
744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);
745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);

Line 742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');

738: hr_utility.set_location('p_recruitment_activity_id:'||p_recruitment_activity_id,30);
739: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
740: hr_utility.set_location('p_sender_id:'||p_sender_id,40);
741: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);
744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);
745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);
746: clobdoc:=dbms_xmlquery.getXML(ctx);

Line 743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);

739: dbms_xmlquery.setBindValue(ctx,'2',p_sender_id);
740: hr_utility.set_location('p_sender_id:'||p_sender_id,40);
741: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);
744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);
745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);
746: clobdoc:=dbms_xmlquery.getXML(ctx);
747: hr_utility.set_location('After dbms_xmlquery.getXML',60);

Line 744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);

740: hr_utility.set_location('p_sender_id:'||p_sender_id,40);
741: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);
744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);
745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);
746: clobdoc:=dbms_xmlquery.getXML(ctx);
747: hr_utility.set_location('After dbms_xmlquery.getXML',60);
748: dbms_xmlquery.closeContext(ctx);

Line 745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);

741: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);
744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);
745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);
746: clobdoc:=dbms_xmlquery.getXML(ctx);
747: hr_utility.set_location('After dbms_xmlquery.getXML',60);
748: dbms_xmlquery.closeContext(ctx);
749: hr_utility.set_location('Leaving getXMLDataFromDB',70);

Line 746: clobdoc:=dbms_xmlquery.getXML(ctx);

742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');
743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);
744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);
745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);
746: clobdoc:=dbms_xmlquery.getXML(ctx);
747: hr_utility.set_location('After dbms_xmlquery.getXML',60);
748: dbms_xmlquery.closeContext(ctx);
749: hr_utility.set_location('Leaving getXMLDataFromDB',70);
750: return clobdoc;

Line 747: hr_utility.set_location('After dbms_xmlquery.getXML',60);

743: dbms_xmlquery.setSqlToXmlNameEscaping(ctx,true);
744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);
745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);
746: clobdoc:=dbms_xmlquery.getXML(ctx);
747: hr_utility.set_location('After dbms_xmlquery.getXML',60);
748: dbms_xmlquery.closeContext(ctx);
749: hr_utility.set_location('Leaving getXMLDataFromDB',70);
750: return clobdoc;
751:

Line 748: dbms_xmlquery.closeContext(ctx);

744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);
745: hr_utility.set_location('After dbms_xmlquery.setEncodingTag',50);
746: clobdoc:=dbms_xmlquery.getXML(ctx);
747: hr_utility.set_location('After dbms_xmlquery.getXML',60);
748: dbms_xmlquery.closeContext(ctx);
749: hr_utility.set_location('Leaving getXMLDataFromDB',70);
750: return clobdoc;
751:
752: exception when others then