DBA Data[Home] [Help]

APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on BSC_TABS_B

Line 1363: UPDATE BSC_TABS_B

1359: x_msg_data := 'Insertion to BSC_TAB_VIEWS_PKG failed' || SQLERRM;
1360: RETURN;
1361: END;
1362:
1363: UPDATE BSC_TABS_B
1364: SET LAST_UPDATE_DATE = SYSDATE,
1365: LAST_UPDATED_BY = fnd_global.user_id,
1366: LAST_UPDATE_LOGIN = fnd_global.login_id
1367: WHERE TAB_ID = p_tab_id;

Line 1810: l_tabId BSC_TABS_B.tab_Id%TYPE;

1806: , x_msg_count OUT NOCOPY NUMBER
1807: , x_msg_data OUT NOCOPY VARCHAR2
1808: )IS
1809: l_count NUMBER;
1810: l_tabId BSC_TABS_B.tab_Id%TYPE;
1811: l_tab_name BSC_TABS_VL.name%TYPE;
1812: l_Time_Stamp DATE;
1813: l_last_update_date DATE;
1814: -- Date Format used in Report Designer.

Line 1848: FROM BSC_TABS_B

1844:
1845:
1846: SELECT COUNT(0)
1847: INTO l_count
1848: FROM BSC_TABS_B
1849: WHERE SHORT_NAME = p_report_sht_name;
1850:
1851: IF(l_count=0)THEN
1852:

Line 1880: FROM BSC_TABS_B

1876: END IF;
1877: ELSE
1878: SELECT tab_Id
1879: INTO l_tabId
1880: FROM BSC_TABS_B
1881: WHERE SHORT_NAME = p_report_sht_name;
1882: END IF;
1883:
1884: x_tab_Id := l_tabId;