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 1429: qryctx DBMS_XMLGEN.ctxHandle;

1425: p_asg_op_flag in varchar2,
1426: p_date in date)
1427: return clob
1428: is
1429: qryctx DBMS_XMLGEN.ctxHandle;
1430: v_xml clob;
1431: v_doc DBMS_XMLDOM.domdocument;
1432: v_root DBMS_XMLDOM.domelement;
1433: v_attr DBMS_XMLDOM.domattr;

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

1436:
1437:
1438: begin
1439:
1440: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1441: pas.business_group_id as "BUSINESS_GROUP_ID",
1442: pas.person_id as "PERSON_ID",
1443: pas.assignment_id as "ASSIGNMENT_ID",
1444: pas.assignment_number as "ASSIGNMENT_NUMBER",

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

1471: AND pas.person_id = pos.person_id (+)
1472: AND pas.assignment_id = :1
1473: AND :2 between pas.effective_start_date and pas.effective_end_date');
1474:
1475: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);
1476: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1477: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1478:
1479: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');

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

1472: AND pas.assignment_id = :1
1473: AND :2 between pas.effective_start_date and pas.effective_end_date');
1474:
1475: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);
1476: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1477: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1478:
1479: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1480: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');

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

1473: AND :2 between pas.effective_start_date and pas.effective_end_date');
1474:
1475: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);
1476: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1477: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1478:
1479: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1480: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');
1481:

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

1475: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_assignment_id);
1476: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1477: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1478:
1479: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1480: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');
1481:
1482: dbms_xmlgen.setNullHandling(qryctx, 1);
1483:

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

1476: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1477: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_asg_op_flag);
1478:
1479: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1480: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');
1481:
1482: dbms_xmlgen.setNullHandling(qryctx, 1);
1483:
1484:

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

1478:
1479: dbms_xmlgen.setrowsettag(qryctx,'WORKFORCE');
1480: dbms_xmlgen.setrowtag(qryctx,'WORKFORCE_DETAILS');
1481:
1482: dbms_xmlgen.setNullHandling(qryctx, 1);
1483:
1484:
1485:
1486:

Line 1488: ( DBMS_XMLGEN.getXML(qryctx)

1484:
1485:
1486:
1487: v_xml := replace
1488: ( DBMS_XMLGEN.getXML(qryctx)
1489: , ''
1490: , ' 1491: xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance">'
1492: );

Line 1508: qryctx DBMS_XMLGEN.ctxHandle;

1504: p_org_op_flag in varchar2,
1505: p_date_to in boolean)
1506: return clob
1507: is
1508: qryctx DBMS_XMLGEN.ctxHandle;
1509: v_xml clob;
1510: v_doc DBMS_XMLDOM.domdocument;
1511: v_root DBMS_XMLDOM.domelement;
1512: v_attr DBMS_XMLDOM.domattr;

Line 1521: qryctx := DBMS_XMLGEN.newContext(

1517:
1518: if p_org_op_flag = 'D'
1519: then
1520:
1521: qryctx := DBMS_XMLGEN.newContext(
1522: 'SELECT ''U'' as "OPERATION_FLAG",
1523: null as "BUSINESS_GROUP_ID",
1524: :1 as "ORGANIZATION_ID",
1525: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

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

1529: null as "MANAGER_ID"
1530: from dual
1531: ');
1532:
1533: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);
1534:
1535: else
1536:
1537: if (p_date_to)

Line 1540: qryctx := DBMS_XMLGEN.newContext(

1536:
1537: if (p_date_to)
1538: then
1539:
1540: qryctx := DBMS_XMLGEN.newContext(
1541: 'SELECT :2 as "OPERATION_FLAG",
1542: ORG.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1543: ORG.ORGANIZATION_ID as "ORGANIZATION_ID",
1544: to_char(nvl(date_to,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 1564: qryctx := DBMS_XMLGEN.newContext(

1560: and hrorg.org_information1 = ''HR_ORG''
1561: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');
1562: else
1563:
1564: qryctx := DBMS_XMLGEN.newContext(
1565: 'SELECT :2 as "OPERATION_FLAG",
1566: ORG.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1567: ORG.ORGANIZATION_ID as "ORGANIZATION_ID",
1568: to_char(DATE_FROM,''YYYY-MM-DD'') as "EFFECTIVE_DATE" ,

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

1585: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');
1586:
1587: end if;
1588:
1589: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);
1590: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_org_op_flag);
1591:
1592: end if;
1593:

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

1586:
1587: end if;
1588:
1589: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);
1590: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_org_op_flag);
1591:
1592: end if;
1593:
1594: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');

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

1590: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_org_op_flag);
1591:
1592: end if;
1593:
1594: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');
1595: dbms_xmlgen.setrowtag(qryctx,'ORGANIZATION_DETAILS');
1596:
1597: dbms_xmlgen.setNullHandling(qryctx, 1);
1598:

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

1591:
1592: end if;
1593:
1594: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');
1595: dbms_xmlgen.setrowtag(qryctx,'ORGANIZATION_DETAILS');
1596:
1597: dbms_xmlgen.setNullHandling(qryctx, 1);
1598:
1599: v_xml := replace

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

1593:
1594: dbms_xmlgen.setrowsettag(qryctx,'ORGANIZATION');
1595: dbms_xmlgen.setrowtag(qryctx,'ORGANIZATION_DETAILS');
1596:
1597: dbms_xmlgen.setNullHandling(qryctx, 1);
1598:
1599: v_xml := replace
1600: ( DBMS_XMLGEN.getXML(qryctx)
1601: , 'ORGANIZATIONNAME_ROW>'

Line 1600: ( DBMS_XMLGEN.getXML(qryctx)

1596:
1597: dbms_xmlgen.setNullHandling(qryctx, 1);
1598:
1599: v_xml := replace
1600: ( DBMS_XMLGEN.getXML(qryctx)
1601: , 'ORGANIZATIONNAME_ROW>'
1602: , 'LANG>'
1603: );
1604:

Line 1626: qryctx DBMS_XMLGEN.ctxHandle;

1622: p_person_op_flag in varchar2,
1623: p_date in date)
1624: return clob
1625: is
1626: qryctx DBMS_XMLGEN.ctxHandle;
1627: v_xml clob;
1628: v_doc DBMS_XMLDOM.domdocument;
1629: v_root DBMS_XMLDOM.domelement;
1630: v_attr DBMS_XMLDOM.domattr;

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

1635: begin
1636:
1637: if ((p_address_id is null) and (p_phone_id is null))
1638: then
1639: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1640: ppf.business_group_id as "BUSINESS_GROUP_ID",
1641: ppf.person_id as "PERSON_ID",
1642: (select org_information9 from
1643: hr_organization_information where organization_id = ppf.business_group_id

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

1691: FROM PER_ALL_PEOPLE_F ppf
1692: where ppf.person_id = :1
1693: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1694:
1695: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1696: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1697: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1698:
1699: end if;

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

1692: where ppf.person_id = :1
1693: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1694:
1695: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1696: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1697: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1698:
1699: end if;
1700: if (p_address_id is not null) then

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

1693: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1694:
1695: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1696: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1697: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1698:
1699: end if;
1700: if (p_address_id is not null) then
1701: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",

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

1697: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1698:
1699: end if;
1700: if (p_address_id is not null) then
1701: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1702: ppf.business_group_id as "BUSINESS_GROUP_ID",
1703: ppf.person_id as "PERSON_ID",
1704: (select org_information9 from
1705: hr_organization_information where organization_id = ppf.business_group_id

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

1756: and paddr.address_id = :4
1757: AND :2 between nvl(paddr.date_from,:2) and nvl(paddr.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
1758: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1759:
1760: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1761: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1762: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1763:
1764: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);

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

1757: AND :2 between nvl(paddr.date_from,:2) and nvl(paddr.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
1758: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1759:
1760: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1761: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1762: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1763:
1764: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);
1765: end if;

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

1758: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1759:
1760: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1761: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1762: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1763:
1764: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);
1765: end if;
1766:

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

1760: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1761: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1762: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1763:
1764: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);
1765: end if;
1766:
1767: if (p_phone_id is not null) then
1768: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",

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

1764: DBMS_XMLGEN.setbindvalue (qryctx, '4', p_address_id);
1765: end if;
1766:
1767: if (p_phone_id is not null) then
1768: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1769: ppf.business_group_id as "BUSINESS_GROUP_ID",
1770: ppf.person_id as "PERSON_ID",
1771: (select org_information9 from
1772: hr_organization_information where organization_id = ppf.business_group_id

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

1824: AND PPN.PARENT_TABLE = ''PER_ALL_PEOPLE_F''
1825: AND :2 between nvl(ppn.date_from,:2) and nvl(ppn.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
1826: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1827:
1828: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1829: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1830: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1831: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
1832: end if;

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

1825: AND :2 between nvl(ppn.date_from,:2) and nvl(ppn.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
1826: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1827:
1828: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1829: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1830: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1831: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
1832: end if;
1833:

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

1826: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1827:
1828: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1829: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1830: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1831: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
1832: end if;
1833:
1834:

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

1827:
1828: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);
1829: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_date);
1830: DBMS_XMLGEN.setbindvalue (qryctx, '3', p_person_op_flag);
1831: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
1832: end if;
1833:
1834:
1835: dbms_xmlgen.setrowsettag(qryctx,'PERSON');

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

1831: DBMS_XMLGEN.setbindvalue (qryctx, '5', p_phone_id);
1832: end if;
1833:
1834:
1835: dbms_xmlgen.setrowsettag(qryctx,'PERSON');
1836: dbms_xmlgen.setrowtag(qryctx,'PERSON_DETAILS');
1837:
1838: dbms_xmlgen.setNullHandling(qryctx, 1);
1839:

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

1832: end if;
1833:
1834:
1835: dbms_xmlgen.setrowsettag(qryctx,'PERSON');
1836: dbms_xmlgen.setrowtag(qryctx,'PERSON_DETAILS');
1837:
1838: dbms_xmlgen.setNullHandling(qryctx, 1);
1839:
1840:

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

1834:
1835: dbms_xmlgen.setrowsettag(qryctx,'PERSON');
1836: dbms_xmlgen.setrowtag(qryctx,'PERSON_DETAILS');
1837:
1838: dbms_xmlgen.setNullHandling(qryctx, 1);
1839:
1840:
1841:
1842: v_xml := replace

Line 1843: ( DBMS_XMLGEN.getXML(qryctx)

1839:
1840:
1841:
1842: v_xml := replace
1843: ( DBMS_XMLGEN.getXML(qryctx)
1844: , ''
1845: , ' 1846: xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance">'
1847: );

Line 1863: qryctx DBMS_XMLGEN.ctxHandle;

1859: p_loc_op_flag in varchar2,
1860: p_inactive_date in boolean)
1861: return clob
1862: is
1863: qryctx DBMS_XMLGEN.ctxHandle;
1864: v_xml clob;
1865: v_doc DBMS_XMLDOM.domdocument;
1866: v_root DBMS_XMLDOM.domelement;
1867: v_attr DBMS_XMLDOM.domattr;

Line 1876: qryctx := DBMS_XMLGEN.newContext(

1872:
1873: if p_loc_op_flag = 'D'
1874: then
1875:
1876: qryctx := DBMS_XMLGEN.newContext(
1877: 'SELECT ''U'' as "OPERATION_FLAG",
1878: ''*'' as "BUSINESS_GROUP_ID",
1879:
1880: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

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

1904: ''*'' as "LOC_INFORMATION20"
1905: from dual
1906: ');
1907:
1908: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);
1909:
1910: else
1911:
1912: if (p_inactive_date)

Line 1915: qryctx := DBMS_XMLGEN.newContext(

1911:
1912: if (p_inactive_date)
1913: then
1914:
1915: qryctx := DBMS_XMLGEN.newContext(
1916: 'SELECT :2 as "OPERATION_FLAG",
1917: hloc.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1918:
1919: to_char(nvl(inactive_date,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 1949: qryctx := DBMS_XMLGEN.newContext(

1945: where location_id = :1
1946: and last_update_date = (select max(last_update_date) from hr_locations_all where location_id = :1)');
1947: else
1948:
1949: qryctx := DBMS_XMLGEN.newContext(
1950: 'SELECT :2 as "OPERATION_FLAG",
1951: hloc.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1952: hloc.LOCATION_ID as "LOCATION_ID",
1953: to_char(hloc.creation_date,''YYYY-MM-DD'') as "EFFECTIVE_DATE",

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

1979: and last_update_date = (select max(last_update_date) from hr_locations_all where location_id = :1)');
1980:
1981: end if;
1982:
1983: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);
1984: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_loc_op_flag);
1985:
1986: end if;
1987:

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

1980:
1981: end if;
1982:
1983: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_location_id);
1984: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_loc_op_flag);
1985:
1986: end if;
1987:
1988: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');

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

1984: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_loc_op_flag);
1985:
1986: end if;
1987:
1988: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');
1989: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');
1990: dbms_xmlgen.setNullHandling(qryctx, 1);
1991:
1992: v_xml := replace

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

1985:
1986: end if;
1987:
1988: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');
1989: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');
1990: dbms_xmlgen.setNullHandling(qryctx, 1);
1991:
1992: v_xml := replace
1993: ( DBMS_XMLGEN.getXML(qryctx)

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

1986: end if;
1987:
1988: dbms_xmlgen.setrowsettag(qryctx,'LOCATION');
1989: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');
1990: dbms_xmlgen.setNullHandling(qryctx, 1);
1991:
1992: v_xml := replace
1993: ( DBMS_XMLGEN.getXML(qryctx)
1994: , 'LOCATIONNAME_ROW>'

Line 1993: ( DBMS_XMLGEN.getXML(qryctx)

1989: dbms_xmlgen.setrowtag(qryctx,'LOCATION_DETAILS');
1990: dbms_xmlgen.setNullHandling(qryctx, 1);
1991:
1992: v_xml := replace
1993: ( DBMS_XMLGEN.getXML(qryctx)
1994: , 'LOCATIONNAME_ROW>'
1995: , 'LANG>'
1996: );
1997:

Line 2016: qryctx DBMS_XMLGEN.ctxHandle;

2012: p_job_op_flag in varchar2,
2013: p_date_to in boolean)
2014: return clob
2015: is
2016: qryctx DBMS_XMLGEN.ctxHandle;
2017: v_xml clob;
2018: v_doc DBMS_XMLDOM.domdocument;
2019: v_root DBMS_XMLDOM.domelement;
2020: v_attr DBMS_XMLDOM.domattr;

Line 2029: qryctx := DBMS_XMLGEN.newContext(

2025: begin
2026:
2027: if p_job_op_flag = 'D'
2028: then
2029: qryctx := DBMS_XMLGEN.newContext(
2030: 'SELECT ''U'' as "OPERATION_FLAG",
2031: ''*'' as "BUSINESS_GROUP_ID",
2032: :1 as "JOB_ID",
2033: to_char(trunc(sysdate),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

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

2035: cursor(select ''*'' lang_code ,''*'' data from dual) as "JOBNAME"
2036: from dual
2037: ');
2038:
2039: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2040: else
2041:
2042: if (p_date_to)
2043: then

Line 2045: qryctx := DBMS_XMLGEN.newContext(

2041:
2042: if (p_date_to)
2043: then
2044:
2045: qryctx := DBMS_XMLGEN.newContext(
2046: 'SELECT :2 as "OPERATION_FLAG",
2047: pj.Business_group_id as "BUSINESS_GROUP_ID",
2048: pj.job_id as "JOB_ID",
2049: to_char(nvl(pj.date_to,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",

Line 2059: qryctx := DBMS_XMLGEN.newContext(

2055: ');
2056:
2057: else
2058:
2059: qryctx := DBMS_XMLGEN.newContext(
2060: 'SELECT :2 as "OPERATION_FLAG",
2061: pj.Business_group_id as "BUSINESS_GROUP_ID",
2062: pj.JOB_ID as "JOB_ID",
2063: to_char(pj.date_from,''YYYY-MM-DD'') as "EFFECTIVE_DATE",

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

2069: ');
2070:
2071: end if;
2072:
2073: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2074: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_job_op_flag);
2075:
2076: end if;
2077:

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

2070:
2071: end if;
2072:
2073: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_job_id);
2074: DBMS_XMLGEN.setbindvalue (qryctx, '2', p_job_op_flag);
2075:
2076: end if;
2077:
2078:

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

2075:
2076: end if;
2077:
2078:
2079: dbms_xmlgen.setrowsettag(qryctx,'JOB');
2080: dbms_xmlgen.setrowtag(qryctx,'JOB_DETAILS');
2081:
2082: dbms_xmlgen.setNullHandling(qryctx, 1);
2083:

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

2076: end if;
2077:
2078:
2079: dbms_xmlgen.setrowsettag(qryctx,'JOB');
2080: dbms_xmlgen.setrowtag(qryctx,'JOB_DETAILS');
2081:
2082: dbms_xmlgen.setNullHandling(qryctx, 1);
2083:
2084:

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

2078:
2079: dbms_xmlgen.setrowsettag(qryctx,'JOB');
2080: dbms_xmlgen.setrowtag(qryctx,'JOB_DETAILS');
2081:
2082: dbms_xmlgen.setNullHandling(qryctx, 1);
2083:
2084:
2085:
2086: v_xml := replace

Line 2087: ( DBMS_XMLGEN.getXML(qryctx)

2083:
2084:
2085:
2086: v_xml := replace
2087: ( DBMS_XMLGEN.getXML(qryctx)
2088: ,'JOBNAME_ROW>'
2089: ,'LANG>');
2090:
2091: return ( replace