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 HR_UTILITY

Line 561: hr_utility.set_location('Entering getXMLDataFromDB',10);

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'
564: ||' , hr_xml_transaction_id_s.nextval transactionid'
565: ||' , translate(to_char(sysdate,''RRRR-MM-DD HH:MM:SS''),'' '',''T'') timestamp'

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 738: hr_utility.set_location('p_recruitment_activity_id:'||p_recruitment_activity_id,30);

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);
742: dbms_xmlquery.setRowsetTag(ctx,'JobPositionPosting');

Line 740: hr_utility.set_location('p_sender_id:'||p_sender_id,40);

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);
744: dbms_xmlquery.setEncodingTag(ctx,dbms_xmlquery.DB_ENCODING);

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 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 749: hr_utility.set_location('Leaving getXMLDataFromDB',70);

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
753: hr_utility.set_location('Exception occured',100);

Line 753: hr_utility.set_location('Exception occured',100);

749: hr_utility.set_location('Leaving getXMLDataFromDB',70);
750: return clobdoc;
751:
752: exception when others then
753: hr_utility.set_location('Exception occured',100);
754: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),110);
755: hr_utility.set_location('Exception: '||sqlcode,120);
756: raise;
757: end getXMLDataFromDB;

Line 754: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),110);

750: return clobdoc;
751:
752: exception when others then
753: hr_utility.set_location('Exception occured',100);
754: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),110);
755: hr_utility.set_location('Exception: '||sqlcode,120);
756: raise;
757: end getXMLDataFromDB;
758:

Line 755: hr_utility.set_location('Exception: '||sqlcode,120);

751:
752: exception when others then
753: hr_utility.set_location('Exception occured',100);
754: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),110);
755: hr_utility.set_location('Exception: '||sqlcode,120);
756: raise;
757: end getXMLDataFromDB;
758:
759: end;