1449: /* Bug 5244313 Setting the SOB based on the Reporting context */
1450:
1451: if p_reporting_level = 1000 then
1452: var.books_id := p_reporting_entity_id;
1453: mo_global.init('AR');
1454: mo_global.set_policy_context('M',null);
1455:
1456: elsif p_reporting_level = 3000 then
1457:
1450:
1451: if p_reporting_level = 1000 then
1452: var.books_id := p_reporting_entity_id;
1453: mo_global.init('AR');
1454: mo_global.set_policy_context('M',null);
1455:
1456: elsif p_reporting_level = 3000 then
1457:
1458: select set_of_books_id
1459: into var.books_id
1460: from ar_system_parameters_all
1461: where org_id = p_reporting_entity_id;
1462:
1463: mo_global.init('AR');
1464: mo_global.set_policy_context('S',p_reporting_entity_id);
1465:
1466: end if;
1467:
1460: from ar_system_parameters_all
1461: where org_id = p_reporting_entity_id;
1462:
1463: mo_global.init('AR');
1464: mo_global.set_policy_context('S',p_reporting_entity_id);
1465:
1466: end if;
1467:
1468: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1608: var.request_id := request_id;
1609:
1610: if p_reporting_level = 1000 then
1611: var.books_id := p_reporting_entity_id;
1612: mo_global.init('AR');
1613: mo_global.set_policy_context('M',null);
1614:
1615: elsif p_reporting_level = 3000 then
1616: select set_of_books_id
1609:
1610: if p_reporting_level = 1000 then
1611: var.books_id := p_reporting_entity_id;
1612: mo_global.init('AR');
1613: mo_global.set_policy_context('M',null);
1614:
1615: elsif p_reporting_level = 3000 then
1616: select set_of_books_id
1617: into var.books_id
1617: into var.books_id
1618: from ar_system_parameters_all
1619: where org_id = var.p_reporting_entity_id;
1620:
1621: mo_global.init('AR');
1622: mo_global.set_policy_context('S',var.p_reporting_entity_id);
1623:
1624: end if;
1625: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1618: from ar_system_parameters_all
1619: where org_id = var.p_reporting_entity_id;
1620:
1621: mo_global.init('AR');
1622: mo_global.set_policy_context('S',var.p_reporting_entity_id);
1623:
1624: end if;
1625: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1626: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1711:
1712: --5255926
1713: if p_reporting_level = 1000 then
1714: var.books_id := p_reporting_entity_id;
1715: mo_global.init('AR');
1716: mo_global.set_policy_context('M',null);
1717:
1718: elsif p_reporting_level = 3000 then
1719:
1712: --5255926
1713: if p_reporting_level = 1000 then
1714: var.books_id := p_reporting_entity_id;
1715: mo_global.init('AR');
1716: mo_global.set_policy_context('M',null);
1717:
1718: elsif p_reporting_level = 3000 then
1719:
1720: select set_of_books_id
1721: into var.books_id
1722: from ar_system_parameters_all
1723: where org_id = p_reporting_entity_id;
1724:
1725: mo_global.init('AR');
1726: mo_global.set_policy_context('S',p_reporting_entity_id);
1727:
1728: end if;
1729:
1722: from ar_system_parameters_all
1723: where org_id = p_reporting_entity_id;
1724:
1725: mo_global.init('AR');
1726: mo_global.set_policy_context('S',p_reporting_entity_id);
1727:
1728: end if;
1729:
1730:
1860: /* Bug 5255942 Setting the SOB based on the Reporting context */
1861:
1862: if p_reporting_level = 1000 then
1863: var.books_id := p_reporting_entity_id;
1864: mo_global.init('AR');
1865: mo_global.set_policy_context('M',null);
1866: elsif p_reporting_level = 3000 then
1867: select set_of_books_id
1868: into var.books_id
1861:
1862: if p_reporting_level = 1000 then
1863: var.books_id := p_reporting_entity_id;
1864: mo_global.init('AR');
1865: mo_global.set_policy_context('M',null);
1866: elsif p_reporting_level = 3000 then
1867: select set_of_books_id
1868: into var.books_id
1869: from ar_system_parameters_all
1867: select set_of_books_id
1868: into var.books_id
1869: from ar_system_parameters_all
1870: where org_id = p_reporting_entity_id;
1871: mo_global.init('AR');
1872: mo_global.set_policy_context('S',p_reporting_entity_id);
1873: end if;
1874:
1875:
1868: into var.books_id
1869: from ar_system_parameters_all
1870: where org_id = p_reporting_entity_id;
1871: mo_global.init('AR');
1872: mo_global.set_policy_context('S',p_reporting_entity_id);
1873: end if;
1874:
1875:
1876: /*