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_HRHD_RIR_WF dependencies on DBMS_XMLGEN

Line 1607: qryctx DBMS_XMLGEN.ctxHandle;

1603: p_asg_op_flag in varchar2,
1604: p_date in date)
1605: return clob
1606: is
1607: qryctx DBMS_XMLGEN.ctxHandle;
1608: v_xml clob;
1609: v_doc DBMS_XMLDOM.domdocument;
1610: v_root DBMS_XMLDOM.domelement;
1611: v_attr DBMS_XMLDOM.domattr;

Line 1618: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",

1614:
1615:
1616: begin
1617:
1618: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1619: pas.business_group_id as "BUSINESS_GROUP_ID",
1620: pas.person_id as "PERSON_ID",
1621: pas.assignment_id as "ASSIGNMENT_ID",
1622: pas.assignment_number as "ASSIGNMENT_NUMBER",

Line 1655: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);

1651: AND pas.person_id = pos.person_id (+)
1652: AND pas.assignment_id = :1
1653: AND :2 between pas.effective_start_date and pas.effective_end_date');
1654:
1655: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);
1656: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1657: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1658:
1659: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');

Line 1656: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);

1652: AND pas.assignment_id = :1
1653: AND :2 between pas.effective_start_date and pas.effective_end_date');
1654:
1655: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);
1656: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1657: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1658:
1659: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1660: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');

Line 1657: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);

1653: AND :2 between pas.effective_start_date and pas.effective_end_date');
1654:
1655: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);
1656: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1657: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1658:
1659: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1660: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');
1661:

Line 1659: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');

1655: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);
1656: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1657: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1658:
1659: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1660: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');
1661:
1662: dbms_xmlgen.setNullHandling(qryctx, 1);
1663:

Line 1660: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');

1656: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1657: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1658:
1659: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1660: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');
1661:
1662: dbms_xmlgen.setNullHandling(qryctx, 1);
1663:
1664:

Line 1662: dbms_xmlgen.setNullHandling(qryctx, 1);

1658:
1659: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1660: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');
1661:
1662: dbms_xmlgen.setNullHandling(qryctx, 1);
1663:
1664:
1665:
1666:

Line 1668: ( DBMS_XMLGEN.getXML(qryctx)

1664:
1665:
1666:
1667: v_xml := replace
1668: ( DBMS_XMLGEN.getXML(qryctx)
1669: , ''
1670: , ' 1671: xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance">'
1672: );

Line 1688: qryctx DBMS_XMLGEN.ctxHandle;

1684: p_org_op_flag in varchar2,
1685: p_date_to in boolean)
1686: return clob
1687: is
1688: qryctx DBMS_XMLGEN.ctxHandle;
1689: v_xml clob;
1690: v_doc DBMS_XMLDOM.domdocument;
1691: v_root DBMS_XMLDOM.domelement;
1692: v_attr DBMS_XMLDOM.domattr;

Line 1701: qryctx := DBMS_XMLGEN.newContext(

1697:
1698: if p_org_op_flag = 'D'
1699: then
1700:
1701: qryctx := DBMS_XMLGEN.newContext(
1702: 'SELECT ''U'' as "OPERATION_FLAG",
1703: null as "BUSINESS_GROUP_ID",
1704: :1 as "ORGANIZATION_ID",
1705: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 1713: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);

1709: null as "MANAGER_ID"
1710: from dual
1711: ');
1712:
1713: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);
1714:
1715: else
1716:
1717: if (p_date_to)

Line 1720: qryctx := DBMS_XMLGEN.newContext(

1716:
1717: if (p_date_to)
1718: then
1719:
1720: qryctx := DBMS_XMLGEN.newContext(
1721: 'SELECT :2 as "OPERATION_FLAG",
1722: ORG.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1723: ORG.ORGANIZATION_ID as "ORGANIZATION_ID",
1724: to_char(nvl(date_to,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 1744: qryctx := DBMS_XMLGEN.newContext(

1740: and hrorg.org_information1 = ''HR_ORG''
1741: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');
1742: else
1743:
1744: qryctx := DBMS_XMLGEN.newContext(
1745: 'SELECT :2 as "OPERATION_FLAG",
1746: ORG.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1747: ORG.ORGANIZATION_ID as "ORGANIZATION_ID",
1748: to_char(DATE_FROM,''YYYY-MM-DD'') as "EFFECTIVE_DATE" ,

Line 1769: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);

1765: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');
1766:
1767: end if;
1768:
1769: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);
1770: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_org_op_flag);
1771:
1772: end if;
1773:

Line 1770: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_org_op_flag);

1766:
1767: end if;
1768:
1769: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);
1770: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_org_op_flag);
1771:
1772: end if;
1773:
1774: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');

Line 1774: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');

1770: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_org_op_flag);
1771:
1772: end if;
1773:
1774: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');
1775: dbms_xmlgen.setrowtag(qryctx,'ORGANIZATION_DETAILS');
1776:
1777: dbms_xmlgen.setNullHandling(qryctx, 1);
1778:

Line 1775: dbms_xmlgen.setrowtag(qryctx,'ORGANIZATION_DETAILS');

1771:
1772: end if;
1773:
1774: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');
1775: dbms_xmlgen.setrowtag(qryctx,'ORGANIZATION_DETAILS');
1776:
1777: dbms_xmlgen.setNullHandling(qryctx, 1);
1778:
1779: v_xml := replace

Line 1777: dbms_xmlgen.setNullHandling(qryctx, 1);

1773:
1774: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');
1775: dbms_xmlgen.setrowtag(qryctx,'ORGANIZATION_DETAILS');
1776:
1777: dbms_xmlgen.setNullHandling(qryctx, 1);
1778:
1779: v_xml := replace
1780: ( DBMS_XMLGEN.getXML(qryctx)
1781: , 'ORGANIZATIONNAME_ROW>'

Line 1780: ( DBMS_XMLGEN.getXML(qryctx)

1776:
1777: dbms_xmlgen.setNullHandling(qryctx, 1);
1778:
1779: v_xml := replace
1780: ( DBMS_XMLGEN.getXML(qryctx)
1781: , 'ORGANIZATIONNAME_ROW>'
1782: , 'LANG>'
1783: );
1784:

Line 1806: qryctx DBMS_XMLGEN.ctxHandle;

1802: p_person_op_flag in varchar2,
1803: p_date in date)
1804: return clob
1805: is
1806: qryctx DBMS_XMLGEN.ctxHandle;
1807: v_xml clob;
1808: v_doc DBMS_XMLDOM.domdocument;
1809: v_root DBMS_XMLDOM.domelement;
1810: v_attr DBMS_XMLDOM.domattr;

Line 1819: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",

1815: begin
1816:
1817: if ((p_address_id is null) and (p_phone_id is null))
1818: then
1819: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1820: ppf.business_group_id as "BUSINESS_GROUP_ID",
1821: ppf.person_id as "PERSON_ID",
1822: (select org_information9 from
1823: hr_organization_information where organization_id = ppf.business_group_id

Line 1876: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);

1872: FROM PER_ALL_PEOPLE_F ppf
1873: where ppf.person_id = :1
1874: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1875:
1876: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1877: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1878: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1879:
1880: end if;

Line 1877: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);

1873: where ppf.person_id = :1
1874: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1875:
1876: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1877: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1878: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1879:
1880: end if;
1881: if (p_address_id is not null) then

Line 1878: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);

1874: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1875:
1876: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1877: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1878: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1879:
1880: end if;
1881: if (p_address_id is not null) then
1882: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",

Line 1882: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",

1878: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1879:
1880: end if;
1881: if (p_address_id is not null) then
1882: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1883: ppf.business_group_id as "BUSINESS_GROUP_ID",
1884: ppf.person_id as "PERSON_ID",
1885: (select org_information9 from
1886: hr_organization_information where organization_id = ppf.business_group_id

Line 1942: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);

1938: and paddr.address_id = :4
1939: AND :2 between nvl(paddr.date_from,:2) and nvl(paddr.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
1940: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1941:
1942: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1943: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1944: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1945:
1946: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);

Line 1943: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);

1939: AND :2 between nvl(paddr.date_from,:2) and nvl(paddr.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
1940: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1941:
1942: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1943: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1944: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1945:
1946: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);
1947: end if;

Line 1944: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);

1940: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1941:
1942: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1943: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1944: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1945:
1946: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);
1947: end if;
1948:

Line 1946: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);

1942: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1943: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1944: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1945:
1946: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);
1947: end if;
1948:
1949: if (p_phone_id is not null) then
1950: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",

Line 1950: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",

1946: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);
1947: end if;
1948:
1949: if (p_phone_id is not null) then
1950: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1951: ppf.business_group_id as "BUSINESS_GROUP_ID",
1952: ppf.person_id as "PERSON_ID",
1953: (select org_information9 from
1954: hr_organization_information where organization_id = ppf.business_group_id

Line 2011: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);

2007: AND PPN.PARENT_TABLE = ''PER_ALL_PEOPLE_F''
2008: AND :2 between nvl(ppn.date_from,:2) and nvl(ppn.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
2009: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
2010:
2011: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
2012: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
2013: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
2014: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
2015: end if;

Line 2012: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);

2008: AND :2 between nvl(ppn.date_from,:2) and nvl(ppn.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
2009: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
2010:
2011: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
2012: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
2013: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
2014: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
2015: end if;
2016:

Line 2013: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);

2009: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
2010:
2011: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
2012: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
2013: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
2014: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
2015: end if;
2016:
2017:

Line 2014: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);

2010:
2011: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
2012: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
2013: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
2014: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
2015: end if;
2016:
2017:
2018: dbms_xmlgen.setrowsettag(qryctx,'PERSON');

Line 2018: dbms_xmlgen.setrowsettag(qryctx,'PERSON');

2014: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
2015: end if;
2016:
2017:
2018: dbms_xmlgen.setrowsettag(qryctx,'PERSON');
2019: dbms_xmlgen.setrowtag(qryctx,'PERSON_DETAILS');
2020:
2021: dbms_xmlgen.setNullHandling(qryctx, 1);
2022:

Line 2019: dbms_xmlgen.setrowtag(qryctx,'PERSON_DETAILS');

2015: end if;
2016:
2017:
2018: dbms_xmlgen.setrowsettag(qryctx,'PERSON');
2019: dbms_xmlgen.setrowtag(qryctx,'PERSON_DETAILS');
2020:
2021: dbms_xmlgen.setNullHandling(qryctx, 1);
2022:
2023:

Line 2021: dbms_xmlgen.setNullHandling(qryctx, 1);

2017:
2018: dbms_xmlgen.setrowsettag(qryctx,'PERSON');
2019: dbms_xmlgen.setrowtag(qryctx,'PERSON_DETAILS');
2020:
2021: dbms_xmlgen.setNullHandling(qryctx, 1);
2022:
2023:
2024:
2025: v_xml := replace

Line 2026: ( DBMS_XMLGEN.getXML(qryctx)

2022:
2023:
2024:
2025: v_xml := replace
2026: ( DBMS_XMLGEN.getXML(qryctx)
2027: , ''
2028: , ' 2029: xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance">'
2030: );

Line 2046: qryctx DBMS_XMLGEN.ctxHandle;

2042: p_loc_op_flag in varchar2,
2043: p_inactive_date in boolean)
2044: return clob
2045: is
2046: qryctx DBMS_XMLGEN.ctxHandle;
2047: v_xml clob;
2048: v_doc DBMS_XMLDOM.domdocument;
2049: v_root DBMS_XMLDOM.domelement;
2050: v_attr DBMS_XMLDOM.domattr;

Line 2059: qryctx := DBMS_XMLGEN.newContext(

2055:
2056: if p_loc_op_flag = 'D'
2057: then
2058:
2059: qryctx := DBMS_XMLGEN.newContext(
2060: 'SELECT ''U'' as "OPERATION_FLAG",
2061: ''*'' as "BUSINESS_GROUP_ID",
2062:
2063: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 2091: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);

2087: ''*'' as "LOC_INFORMATION20"
2088: from dual
2089: ');
2090:
2091: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);
2092:
2093: else
2094:
2095: if (p_inactive_date)

Line 2098: qryctx := DBMS_XMLGEN.newContext(

2094:
2095: if (p_inactive_date)
2096: then
2097:
2098: qryctx := DBMS_XMLGEN.newContext(
2099: 'SELECT :2 as "OPERATION_FLAG",
2100: hloc.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
2101:
2102: to_char(nvl(inactive_date,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 2132: qryctx := DBMS_XMLGEN.newContext(

2128: where location_id = :1
2129: and last_update_date = (select max(last_update_date) from hr_locations_all where location_id = :1)');
2130: else
2131:
2132: qryctx := DBMS_XMLGEN.newContext(
2133: 'SELECT :2 as "OPERATION_FLAG",
2134: hloc.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
2135: hloc.LOCATION_ID as "LOCATION_ID",
2136: to_char(hloc.creation_date,''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 2166: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);

2162: and last_update_date = (select max(last_update_date) from hr_locations_all where location_id = :1)');
2163:
2164: end if;
2165:
2166: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);
2167: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_loc_op_flag);
2168:
2169: end if;
2170:

Line 2167: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_loc_op_flag);

2163:
2164: end if;
2165:
2166: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);
2167: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_loc_op_flag);
2168:
2169: end if;
2170:
2171: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');

Line 2171: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');

2167: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_loc_op_flag);
2168:
2169: end if;
2170:
2171: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');
2172: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');
2173: dbms_xmlgen.setNullHandling(qryctx, 1);
2174:
2175: v_xml := replace

Line 2172: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');

2168:
2169: end if;
2170:
2171: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');
2172: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');
2173: dbms_xmlgen.setNullHandling(qryctx, 1);
2174:
2175: v_xml := replace
2176: ( DBMS_XMLGEN.getXML(qryctx)

Line 2173: dbms_xmlgen.setNullHandling(qryctx, 1);

2169: end if;
2170:
2171: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');
2172: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');
2173: dbms_xmlgen.setNullHandling(qryctx, 1);
2174:
2175: v_xml := replace
2176: ( DBMS_XMLGEN.getXML(qryctx)
2177: , 'LOCATIONNAME_ROW>'

Line 2176: ( DBMS_XMLGEN.getXML(qryctx)

2172: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');
2173: dbms_xmlgen.setNullHandling(qryctx, 1);
2174:
2175: v_xml := replace
2176: ( DBMS_XMLGEN.getXML(qryctx)
2177: , 'LOCATIONNAME_ROW>'
2178: , 'LANG>'
2179: );
2180:

Line 2199: qryctx DBMS_XMLGEN.ctxHandle;

2195: p_job_op_flag in varchar2,
2196: p_date_to in boolean)
2197: return clob
2198: is
2199: qryctx DBMS_XMLGEN.ctxHandle;
2200: v_xml clob;
2201: v_doc DBMS_XMLDOM.domdocument;
2202: v_root DBMS_XMLDOM.domelement;
2203: v_attr DBMS_XMLDOM.domattr;

Line 2212: qryctx := DBMS_XMLGEN.newContext(

2208: begin
2209:
2210: if p_job_op_flag = 'D'
2211: then
2212: qryctx := DBMS_XMLGEN.newContext(
2213: 'SELECT ''U'' as "OPERATION_FLAG",
2214: ''*'' as "BUSINESS_GROUP_ID",
2215: :1 as "JOB_ID",
2216: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 2222: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);

2218: cursor(select ''*'' lang_code ,''*'' data from dual) as "JOBNAME"
2219: from dual
2220: ');
2221:
2222: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2223: else
2224:
2225: if (p_date_to)
2226: then

Line 2228: qryctx := DBMS_XMLGEN.newContext(

2224:
2225: if (p_date_to)
2226: then
2227:
2228: qryctx := DBMS_XMLGEN.newContext(
2229: 'SELECT :2 as "OPERATION_FLAG",
2230: pj.Business_group_id as "BUSINESS_GROUP_ID",
2231: pj.job_id as "JOB_ID",
2232: to_char(nvl(pj.date_to,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 2242: qryctx := DBMS_XMLGEN.newContext(

2238: ');
2239:
2240: else
2241:
2242: qryctx := DBMS_XMLGEN.newContext(
2243: 'SELECT :2 as "OPERATION_FLAG",
2244: pj.Business_group_id as "BUSINESS_GROUP_ID",
2245: pj.JOB_ID as "JOB_ID",
2246: to_char(pj.date_from,''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 2256: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);

2252: ');
2253:
2254: end if;
2255:
2256: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2257: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_job_op_flag);
2258:
2259: end if;
2260:

Line 2257: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_job_op_flag);

2253:
2254: end if;
2255:
2256: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2257: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_job_op_flag);
2258:
2259: end if;
2260:
2261:

Line 2262: dbms_xmlgen.setrowsettag(qryctx,'JOB');

2258:
2259: end if;
2260:
2261:
2262: dbms_xmlgen.setrowsettag(qryctx,'JOB');
2263: dbms_xmlgen.setrowtag(qryctx,'JOB_DETAILS');
2264:
2265: dbms_xmlgen.setNullHandling(qryctx, 1);
2266:

Line 2263: dbms_xmlgen.setrowtag(qryctx,'JOB_DETAILS');

2259: end if;
2260:
2261:
2262: dbms_xmlgen.setrowsettag(qryctx,'JOB');
2263: dbms_xmlgen.setrowtag(qryctx,'JOB_DETAILS');
2264:
2265: dbms_xmlgen.setNullHandling(qryctx, 1);
2266:
2267:

Line 2265: dbms_xmlgen.setNullHandling(qryctx, 1);

2261:
2262: dbms_xmlgen.setrowsettag(qryctx,'JOB');
2263: dbms_xmlgen.setrowtag(qryctx,'JOB_DETAILS');
2264:
2265: dbms_xmlgen.setNullHandling(qryctx, 1);
2266:
2267:
2268:
2269: v_xml := replace

Line 2270: ( DBMS_XMLGEN.getXML(qryctx)

2266:
2267:
2268:
2269: v_xml := replace
2270: ( DBMS_XMLGEN.getXML(qryctx)
2271: ,'JOBNAME_ROW>'
2272: ,'LANG>');
2273:
2274: return ( replace