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.HR_GENERAL2 dependencies on DBMS_XMLGEN

Line 1443: qryCtx DBMS_XMLGEN.ctxHandle;

1439: l_uu_check varchar2(30);
1440: l_ll_check varchar2(30);
1441: l_first_char VARCHAR2(10);
1442: l_second_char varchar2(10);
1443: qryCtx DBMS_XMLGEN.ctxHandle;
1444:
1445: rc SYS_REFCURSOR;
1446:
1447: l_full_name varchar2(2000);

Line 1638: qryCtx := dbms_xmlgen.newContext(rc);

1634: and not exists (select 'x' from per_all_people_f per
1635: where per.party_id = p.party_id
1636: and l_session_date between nvl(per.effective_start_date,l_session_date) and nvl(per.effective_end_date,l_session_date) );*/
1637:
1638: qryCtx := dbms_xmlgen.newContext(rc);
1639: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1640: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1641:
1642: hr_utility.set_location('SSHR',10.3);

Line 1639: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');

1635: where per.party_id = p.party_id
1636: and l_session_date between nvl(per.effective_start_date,l_session_date) and nvl(per.effective_end_date,l_session_date) );*/
1637:
1638: qryCtx := dbms_xmlgen.newContext(rc);
1639: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1640: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1641:
1642: hr_utility.set_location('SSHR',10.3);
1643:

Line 1640: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');

1636: and l_session_date between nvl(per.effective_start_date,l_session_date) and nvl(per.effective_end_date,l_session_date) );*/
1637:
1638: qryCtx := dbms_xmlgen.newContext(rc);
1639: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1640: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1641:
1642: hr_utility.set_location('SSHR',10.3);
1643:
1644: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );

Line 1644: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );

1640: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1641:
1642: hr_utility.set_location('SSHR',10.3);
1643:
1644: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1645:
1646: hr_utility.set_location('SSHR',10.4);
1647:
1648: DBMS_XMLGEN.closeContext( qryCtx );

Line 1648: DBMS_XMLGEN.closeContext( qryCtx );

1644: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1645:
1646: hr_utility.set_location('SSHR',10.4);
1647:
1648: DBMS_XMLGEN.closeContext( qryCtx );
1649:
1650: hr_utility.set_location('SSHR',10.5);
1651:
1652: l_duplicate_found := TRUE;

Line 1770: qryCtx := dbms_xmlgen.newContext(rc);

1766: )
1767: )
1768: );
1769:
1770: qryCtx := dbms_xmlgen.newContext(rc);
1771: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1772: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1773:
1774: hr_utility.set_location('SSHR',50);

Line 1771: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');

1767: )
1768: );
1769:
1770: qryCtx := dbms_xmlgen.newContext(rc);
1771: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1772: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1773:
1774: hr_utility.set_location('SSHR',50);
1775:

Line 1772: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');

1768: );
1769:
1770: qryCtx := dbms_xmlgen.newContext(rc);
1771: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1772: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1773:
1774: hr_utility.set_location('SSHR',50);
1775:
1776: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );

Line 1776: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );

1772: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1773:
1774: hr_utility.set_location('SSHR',50);
1775:
1776: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1777:
1778: hr_utility.set_location('SSHR',60);
1779:
1780: DBMS_XMLGEN.closeContext( qryCtx );

Line 1780: DBMS_XMLGEN.closeContext( qryCtx );

1776: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1777:
1778: hr_utility.set_location('SSHR',60);
1779:
1780: DBMS_XMLGEN.closeContext( qryCtx );
1781:
1782: hr_utility.set_location('SSHR',70);
1783:
1784: l_duplicate_found := TRUE;