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.ZPB_OLAP_VIEWS_PKG dependencies on USER_VIEWS

Line 1584: select view_name from user_views

1580: l_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
1581:
1582: -- b 5751055 bkport from 5658636
1583: cursor c_views is
1584: select view_name from user_views
1585: where view_name like l_aw||'\_%' escape '\' or
1586: view_name like l_aw||'PRS\_%' escape '\' or
1587: view_name like 'ZPB' || p_business_area ||'PRS\_%' escape '\' or
1588: view_name like 'ZPB' || p_business_area || '\_D%' escape '\';

Line 1606: REMOVE_USER_VIEWS(each.user_id, p_business_area);

1602: drop_view(each.view_name);
1603: end loop;
1604:
1605: for each in c_users loop
1606: REMOVE_USER_VIEWS(each.user_id, p_business_area);
1607: end loop;
1608: end REMOVE_BUSAREA_VIEWS;
1609:
1610: -------------------------------------------------------------------------------

Line 1613: -- REMOVE_USER_VIEWS

1609:
1610: -------------------------------------------------------------------------------
1611:
1612: -------------------------------------------------------------------------------
1613: -- REMOVE_USER_VIEWS
1614: --
1615: -- Removes all relational views for the user
1616: -- IN: p_user varchar2 - The user ID
1617: --

Line 1619: procedure REMOVE_USER_VIEWS (p_user in varchar2,

1615: -- Removes all relational views for the user
1616: -- IN: p_user varchar2 - The user ID
1617: --
1618: -------------------------------------------------------------------------------
1619: procedure REMOVE_USER_VIEWS (p_user in varchar2,
1620: p_business_area in NUMBER)
1621: is
1622: l_aw varchar2(30);
1623:

Line 1624: cursor user_views is

1620: p_business_area in NUMBER)
1621: is
1622: l_aw varchar2(30);
1623:
1624: cursor user_views is
1625: select view_name
1626: from user_views
1627: where view_name like l_aw||'\_%' escape '\';
1628:

Line 1626: from user_views

1622: l_aw varchar2(30);
1623:
1624: cursor user_views is
1625: select view_name
1626: from user_views
1627: where view_name like l_aw||'\_%' escape '\';
1628:
1629: begin
1630: l_aw := zpb_aw.get_personal_aw(p_user, p_business_area);

Line 1632: for each in user_views loop

1628:
1629: begin
1630: l_aw := zpb_aw.get_personal_aw(p_user, p_business_area);
1631:
1632: for each in user_views loop
1633: drop_view(each.view_name);
1634: end loop;
1635:
1636: end REMOVE_USER_VIEWS;

Line 1636: end REMOVE_USER_VIEWS;

1632: for each in user_views loop
1633: drop_view(each.view_name);
1634: end loop;
1635:
1636: end REMOVE_USER_VIEWS;
1637:
1638: end ZPB_OLAP_VIEWS_PKG;