APPS.BSC_TAB_VIEWS_PKG dependencies on BSC_TAB_VIEWS_B

Line 47: cursor C is select ROWID from BSC_TAB_VIEWS_B

43: X_LAST_UPDATE_DATE in DATE,
44: X_LAST_UPDATED_BY in NUMBER,
45: X_LAST_UPDATE_LOGIN in NUMBER
46: ) is
47: cursor C is select ROWID from BSC_TAB_VIEWS_B
48: where TAB_ID = X_TAB_ID
49: and TAB_VIEW_ID = X_TAB_VIEW_ID
50: ;
51: begin

Line 52: insert into BSC_TAB_VIEWS_B (

48: where TAB_ID = X_TAB_ID
49: and TAB_VIEW_ID = X_TAB_VIEW_ID
50: ;
51: begin
52: insert into BSC_TAB_VIEWS_B (
53: TAB_ID,
54: TAB_VIEW_ID,
55: ENABLED_FLAG,
56: CREATION_DATE ,

Line 122: from BSC_TAB_VIEWS_B

118: X_HELP in VARCHAR2
119: ) is
120: cursor c is select
121: ENABLED_FLAG
122: from BSC_TAB_VIEWS_B
123: where TAB_ID = X_TAB_ID
124: and TAB_VIEW_ID = X_TAB_VIEW_ID
125: for update of TAB_ID nowait;
126: recinfo c%rowtype;

Line 180: update BSC_TAB_VIEWS_B

176: X_LAST_UPDATED_BY in NUMBER,
177: X_LAST_UPDATE_LOGIN in NUMBER
178: ) is
179: begin
180: update BSC_TAB_VIEWS_B
181: SET ENABLED_FLAG = NVL(X_ENABLED_FLAG, ENABLED_FLAG),
182: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE, SYSDATE),
183: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY, LAST_UPDATED_BY),
184: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN, LAST_UPDATE_LOGIN)

Line 215: delete from BSC_TAB_VIEWS_B

211: if (sql%notfound) then
212: raise no_data_found;
213: end if;
214:
215: delete from BSC_TAB_VIEWS_B
216: where TAB_ID = X_TAB_ID
217: and TAB_VIEW_ID = X_TAB_VIEW_ID;
218: if (sql%notfound) then
219: raise no_data_found;

Line 235: from BSC_TAB_VIEWS_B B

231:
232: delete from BSC_TAB_VIEWS_TL T
233: where not exists
234: (select NULL
235: from BSC_TAB_VIEWS_B B
236: where B.TAB_ID = T.TAB_ID
237: and B.TAB_VIEW_ID = T.TAB_VIEW_ID
238: );
239: