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 1497: qryCtx DBMS_XMLGEN.ctxHandle;

1493: l_uu_check varchar2(30);
1494: l_ll_check varchar2(30);
1495: l_first_char VARCHAR2(10);
1496: l_second_char varchar2(10);
1497: qryCtx DBMS_XMLGEN.ctxHandle;
1498:
1499: rc SYS_REFCURSOR;
1500:
1501: l_full_name varchar2(2000);

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

1689: and not exists (select 'x' from per_all_people_f per
1690: where per.party_id = p.party_id
1691: and l_session_date between nvl(per.effective_start_date,l_session_date) and nvl(per.effective_end_date,l_session_date) );*/
1692:
1693: qryCtx := dbms_xmlgen.newContext(rc);
1694: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1695: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1696:
1697: hr_utility.set_location('SSHR',10.3);

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

1690: where per.party_id = p.party_id
1691: and l_session_date between nvl(per.effective_start_date,l_session_date) and nvl(per.effective_end_date,l_session_date) );*/
1692:
1693: qryCtx := dbms_xmlgen.newContext(rc);
1694: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1695: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1696:
1697: hr_utility.set_location('SSHR',10.3);
1698:

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

1691: and l_session_date between nvl(per.effective_start_date,l_session_date) and nvl(per.effective_end_date,l_session_date) );*/
1692:
1693: qryCtx := dbms_xmlgen.newContext(rc);
1694: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1695: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1696:
1697: hr_utility.set_location('SSHR',10.3);
1698:
1699: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );

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

1695: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1696:
1697: hr_utility.set_location('SSHR',10.3);
1698:
1699: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1700:
1701: hr_utility.set_location('SSHR',10.4);
1702:
1703: DBMS_XMLGEN.closeContext( qryCtx );

Line 1703: DBMS_XMLGEN.closeContext( qryCtx );

1699: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1700:
1701: hr_utility.set_location('SSHR',10.4);
1702:
1703: DBMS_XMLGEN.closeContext( qryCtx );
1704:
1705: hr_utility.set_location('SSHR',10.5);
1706:
1707: l_duplicate_found := TRUE;

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

1822: )
1823: )
1824: );
1825:
1826: qryCtx := dbms_xmlgen.newContext(rc);
1827: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1828: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1829:
1830: hr_utility.set_location('SSHR',50);

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

1823: )
1824: );
1825:
1826: qryCtx := dbms_xmlgen.newContext(rc);
1827: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1828: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1829:
1830: hr_utility.set_location('SSHR',50);
1831:

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

1824: );
1825:
1826: qryCtx := dbms_xmlgen.newContext(rc);
1827: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1828: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1829:
1830: hr_utility.set_location('SSHR',50);
1831:
1832: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );

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

1828: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1829:
1830: hr_utility.set_location('SSHR',50);
1831:
1832: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1833:
1834: hr_utility.set_location('SSHR',60);
1835:
1836: DBMS_XMLGEN.closeContext( qryCtx );

Line 1836: DBMS_XMLGEN.closeContext( qryCtx );

1832: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1833:
1834: hr_utility.set_location('SSHR',60);
1835:
1836: DBMS_XMLGEN.closeContext( qryCtx );
1837:
1838: hr_utility.set_location('SSHR',70);
1839:
1840: l_duplicate_found := TRUE;