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.

[Home] [Help]

APPS.POA_DBI_SUTIL_PKG dependencies on FND_GLOBAL

Line 817: || fnd_global.newline

813: or (p_viewby = 'SUPPLIER+POA_SUPPLIERS') ) THEN
814: return
815: 'select decode(v.value,null,fnd_message.get_string'
816: || '(''POA'', ''POA_DBI_APL_UNASSIGNED''),v.value) VIEWBY,'
817: || fnd_global.newline
818: || ' decode(v.id, null, -1, v.id) VIEWBYID,'
819: || fnd_global.newline;
820: end if;
821: end if;

Line 819: || fnd_global.newline;

815: 'select decode(v.value,null,fnd_message.get_string'
816: || '(''POA'', ''POA_DBI_APL_UNASSIGNED''),v.value) VIEWBY,'
817: || fnd_global.newline
818: || ' decode(v.id, null, -1, v.id) VIEWBYID,'
819: || fnd_global.newline;
820: end if;
821: end if;
822:
823: IF(p_func_area = 'PO' and p_version = '8.0') THEN

Line 829: || fnd_global.newline

825: or (p_viewby = 'LOOKUP+NEG_DOCTYPES') ) THEN
826: return
827: 'select decode(v.value,null,fnd_message.get_string'
828: || '(''POA'', ''POA_DBI_APL_UNASSIGNED''),v.value) VIEWBY,'
829: || fnd_global.newline
830: || ' decode(v.id, null, -1, v.id) VIEWBYID,'
831: || fnd_global.newline;
832: end if;
833: end if;

Line 831: || fnd_global.newline;

827: 'select decode(v.value,null,fnd_message.get_string'
828: || '(''POA'', ''POA_DBI_APL_UNASSIGNED''),v.value) VIEWBY,'
829: || fnd_global.newline
830: || ' decode(v.id, null, -1, v.id) VIEWBYID,'
831: || fnd_global.newline;
832: end if;
833: end if;
834:
835: if(p_viewby = 'ITEM+POA_COMMODITIES') then

Line 1451: where usr.user_id = fnd_global.user_id

1447: select count(*) into l_exists
1448: from po_commodity_categories cat,
1449: po_commodity_grants gr,
1450: fnd_user usr
1451: where usr.user_id = fnd_global.user_id
1452: and gr.person_id = usr.employee_id
1453: and cat.commodity_id = gr.commodity_id
1454: and cat.category_id = p_category_code
1455: and (to_char(gr.commodity_id) = p_selected_commodity or p_selected_commodity = 'ALL');

Line 1490: where isp.web_user_id = fnd_global.user_id

1486: /* Check if user has access to p_supplier_id based on iSP Securing Attributes */
1487: select count(*) into l_exists
1488: from ak_web_user_sec_attr_values isp,
1489: fnd_application appl
1490: where isp.web_user_id = fnd_global.user_id
1491: and isp.attribute_application_id = appl.application_id
1492: and appl.application_short_name = 'POS'
1493: and isp.attribute_code = 'ICX_SUPPLIER_ORG_ID'
1494: and isp.number_value = p_supplier_id;

Line 1534: and isp.web_user_id = fnd_global.user_id

1530: ak_web_user_sec_attr_values isp,
1531: fnd_application appl
1532: where isp.attribute_application_id = appl.application_id
1533: and isp.number_value = sup.vendor_id
1534: and isp.web_user_id = fnd_global.user_id
1535: and isp.attribute_code = 'ICX_SUPPLIER_ORG_ID'
1536: and to_char(sup.id) = p_supplier_site_id
1537: and appl.application_short_name = 'POS';
1538:

Line 1623: where user_id = fnd_global.user_id

1619: return '0';
1620: else
1621: select count(*) into l_count
1622: from fii_company_grants
1623: where user_id = fnd_global.user_id
1624: and company_id = to_number(p_id)
1625: and report_region_code = 'POA_DBI_INV_STATUS';
1626: /* we are using Invoice Amount report as a reference to determine the
1627: * companies the user has access to

Line 1665: where user_id = fnd_global.user_id

1661: return '0';
1662: else
1663: select count(*) into l_count
1664: from fii_cost_center_grants
1665: where user_id = fnd_global.user_id
1666: and cost_center_id = to_number(p_id)
1667: and report_region_code = 'POA_DBI_INV_STATUS';
1668: /* we are using Invoice Amount report as a reference to determine the
1669: * cost centers the user has access to

Line 1714: user_id=fnd_global.user_id

1710: fnd_user,
1711: fnd_menu_entries me,
1712: fnd_form_functions f
1713: where
1714: user_id=fnd_global.user_id
1715: and person_id=employee_id
1716: and sec.commodity_id=p_commodity_id
1717: and f.function_name='POA_DBI_COMMODITY_RPTS_VIEW'
1718: and me.function_id=f.function_id

Line 1724: where usr.user_id = fnd_global.user_id

1720: select count(*) into l_exists
1721: from po_commodity_grants sec,
1722: fnd_menus menu,
1723: fnd_user usr
1724: where usr.user_id = fnd_global.user_id
1725: and sec.person_id = usr.employee_id
1726: and sec.commodity_id = p_commodity_id
1727: and menu.menu_name = 'PO_COMMODITY_MANAGER'
1728: and sec.menu_id = menu.menu_id;

Line 1868: l_rtn := fnd_global.newline;

1864: l_rtn varchar2(5);
1865: l_top_node varchar2(20);
1866: l_non_agrt_nodes number;
1867: begin
1868: l_rtn := fnd_global.newline;
1869: l_non_agrt_nodes := 0;
1870:
1871: if(p_viewby <> 'FII_COMPANIES+FII_COMPANIES') then
1872: if(p_company_id = 'All') then

Line 1875: 'where user_id = fnd_global.user_id '||l_rtn||

1871: if(p_viewby <> 'FII_COMPANIES+FII_COMPANIES') then
1872: if(p_company_id = 'All') then
1873: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1874: 'from fii_company_grants '||l_rtn||
1875: 'where user_id = fnd_global.user_id '||l_rtn||
1876: 'and report_region_code = ®IONCODE';
1877: select count(*) into l_non_agrt_nodes
1878: from fii_company_grants
1879: where user_id = fnd_global.user_id

Line 1879: where user_id = fnd_global.user_id

1875: 'where user_id = fnd_global.user_id '||l_rtn||
1876: 'and report_region_code = ®IONCODE';
1877: select count(*) into l_non_agrt_nodes
1878: from fii_company_grants
1879: where user_id = fnd_global.user_id
1880: and report_region_code = p_region_code
1881: and aggregated_flag = 'N';
1882: else
1883: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||

Line 1896: where user_id = fnd_global.user_id

1892: if(p_company_id = 'All') then
1893:
1894: select count(1) into l_company_count
1895: from fii_company_grants
1896: where user_id = fnd_global.user_id
1897: and report_region_code = p_region_code;
1898:
1899: if(l_company_count = 1) then
1900:

Line 1903: where user_id = fnd_global.user_id

1899: if(l_company_count = 1) then
1900:
1901: select to_char(company_id) into l_top_node
1902: from fii_company_grants
1903: where user_id = fnd_global.user_id
1904: and report_region_code = p_region_code;
1905:
1906: select is_leaf_flag into l_leaf_flag
1907: from fii_company_hierarchies

Line 1933: 'where user_id = fnd_global.user_id '||l_rtn||

1929: end if;
1930: else
1931: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1932: 'from fii_company_grants '||l_rtn||
1933: 'where user_id = fnd_global.user_id '||l_rtn||
1934: 'and report_region_code = ®IONCODE';
1935: select count(*) into l_non_agrt_nodes
1936: from fii_company_grants
1937: where user_id = fnd_global.user_id

Line 1937: where user_id = fnd_global.user_id

1933: 'where user_id = fnd_global.user_id '||l_rtn||
1934: 'and report_region_code = ®IONCODE';
1935: select count(*) into l_non_agrt_nodes
1936: from fii_company_grants
1937: where user_id = fnd_global.user_id
1938: and report_region_code = p_region_code
1939: and aggregated_flag = 'N';
1940: end if;
1941: else

Line 1996: l_rtn := fnd_global.newline;

1992: l_rtn varchar2(5);
1993: l_top_node varchar2(20);
1994: l_non_agrt_nodes number;
1995: begin
1996: l_rtn := fnd_global.newline;
1997: l_non_agrt_nodes := 0;
1998:
1999: if(p_viewby <> 'ORGANIZATION+HRI_CL_ORGCC') then
2000: if(p_cost_center_id = 'All') then

Line 2003: 'where user_id = fnd_global.user_id '||l_rtn||

1999: if(p_viewby <> 'ORGANIZATION+HRI_CL_ORGCC') then
2000: if(p_cost_center_id = 'All') then
2001: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2002: 'from fii_cost_center_grants '||l_rtn||
2003: 'where user_id = fnd_global.user_id '||l_rtn||
2004: 'and report_region_code = ®IONCODE';
2005: select count(*) into l_non_agrt_nodes
2006: from fii_cost_center_grants
2007: where user_id = fnd_global.user_id

Line 2007: where user_id = fnd_global.user_id

2003: 'where user_id = fnd_global.user_id '||l_rtn||
2004: 'and report_region_code = ®IONCODE';
2005: select count(*) into l_non_agrt_nodes
2006: from fii_cost_center_grants
2007: where user_id = fnd_global.user_id
2008: and report_region_code = p_region_code
2009: and aggregated_flag = 'N';
2010: else
2011: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||

Line 2024: where user_id = fnd_global.user_id

2020: if(p_cost_center_id = 'All') then
2021:
2022: select count(1) into l_cost_center_count
2023: from fii_cost_center_grants
2024: where user_id = fnd_global.user_id
2025: and report_region_code = p_region_code;
2026:
2027: if(l_cost_center_count = 1) then
2028:

Line 2031: where user_id = fnd_global.user_id

2027: if(l_cost_center_count = 1) then
2028:
2029: select to_char(cost_center_id) into l_top_node
2030: from fii_cost_center_grants
2031: where user_id = fnd_global.user_id
2032: and report_region_code = p_region_code;
2033:
2034: select is_leaf_flag into l_leaf_flag
2035: from fii_cost_ctr_hierarchies

Line 2061: 'where user_id = fnd_global.user_id '||l_rtn||

2057: end if;
2058: else
2059: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2060: 'from fii_cost_center_grants '||l_rtn||
2061: 'where user_id = fnd_global.user_id '||l_rtn||
2062: 'and report_region_code = ®IONCODE';
2063: select count(*) into l_non_agrt_nodes
2064: from fii_cost_center_grants
2065: where user_id = fnd_global.user_id

Line 2065: where user_id = fnd_global.user_id

2061: 'where user_id = fnd_global.user_id '||l_rtn||
2062: 'and report_region_code = ®IONCODE';
2063: select count(*) into l_non_agrt_nodes
2064: from fii_cost_center_grants
2065: where user_id = fnd_global.user_id
2066: and report_region_code = p_region_code
2067: and aggregated_flag = 'N';
2068: end if;
2069: else

Line 2183: fnd_global.user_id = isp.web_user_id

2179: poa_suppliers_v v,
2180: ak_web_user_sec_attr_values isp,
2181: fnd_application appl
2182: WHERE
2183: fnd_global.user_id = isp.web_user_id
2184: AND isp.attribute_application_id = appl.application_id
2185: AND appl.application_short_name = 'POS'
2186: AND isp.attribute_code = 'ICX_SUPPLIER_ORG_ID'
2187: AND v.id = isp.number_value

Line 2342: where user_id = fnd_global.user_id

2338: /* check how many companies the user has access to
2339: */
2340: select count(1) into l_count
2341: from fii_company_grants
2342: where user_id = fnd_global.user_id
2343: and report_region_code = l_region_code;
2344:
2345: if (l_count = 1) then
2346: select to_char(company_id) into l_top_company_value

Line 2348: where user_id = fnd_global.user_id

2344:
2345: if (l_count = 1) then
2346: select to_char(company_id) into l_top_company_value
2347: from fii_company_grants
2348: where user_id = fnd_global.user_id
2349: and report_region_code = l_region_code;
2350: else
2351: /* if the user does not have access to exactly one company, then the
2352: * l_top_company_value should have an unused value

Line 2361: where user_id = fnd_global.user_id

2357: /* check how many cost-centers the user has access to
2358: */
2359: select count(1) into l_count
2360: from fii_cost_center_grants
2361: where user_id = fnd_global.user_id
2362: and report_region_code = l_region_code;
2363:
2364: if (l_count = 1) then
2365: select to_char(cost_center_id) into l_top_cost_ctr_value

Line 2367: where user_id = fnd_global.user_id

2363:
2364: if (l_count = 1) then
2365: select to_char(cost_center_id) into l_top_cost_ctr_value
2366: from fii_cost_center_grants
2367: where user_id = fnd_global.user_id
2368: and report_region_code = l_region_code;
2369: else
2370: /* if the user does not have access to exactly one cost-center, then the
2371: * l_top_cost_ctr_value should have an unused value