[Home] [Help]
693: l_commodity_value = '' or
694: l_commodity_value = 'All') then
695: null;
696: /* Commented out, as the Security Clauses are handled in Util Package itself
697: l_in_join_rec.table_name := 'po_commodity_grants';
698: l_in_join_rec.table_alias := 'sec';
699: p_in_join_tbl.extend;
700: p_in_join_tbl(p_in_join_tbl.count) := l_in_join_rec;
701:
1445: end if;
1446: else
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
1705: -- for Commodity Secured dashboards
1706: l_exists := 0;
1707: /* select count(*) into l_exists
1708: from
1709: po_commodity_grants sec,
1710: fnd_user,
1711: fnd_menu_entries me,
1712: fnd_form_functions f
1713: where
1717: and f.function_name='POA_DBI_COMMODITY_RPTS_VIEW'
1718: and me.function_id=f.function_id
1719: and sec.menu_id=me.menu_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