APPS.BSC_TABS_PKG dependencies on BSC_TABS_B

Line 18: AND TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME);

14: HELP = NVL(X_HELP, HELP),
15: ADDITIONAL_INFO = NVL(X_ADDITIONAL_INFO, ADDITIONAL_INFO),
16: SOURCE_LANG = USERENV('LANG')
17: WHERE USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
18: AND TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME);
19:
20: IF (SQL%NOTFOUND) THEN
21: RAISE NO_DATA_FOUND;
22: END IF;

Line 46: CURSOR C IS SELECT ROWID FROM BSC_TABS_B WHERE TAB_ID = X_TAB_ID;

42: X_NAME IN VARCHAR2,
43: X_HELP IN VARCHAR2,
44: X_ADDITIONAL_INFO IN VARCHAR2
45: ) IS
46: CURSOR C IS SELECT ROWID FROM BSC_TABS_B WHERE TAB_ID = X_TAB_ID;
47:
48: BEGIN
49: INSERT INTO BSC_TABS_B
50: (

Line 49: INSERT INTO BSC_TABS_B

45: ) IS
46: CURSOR C IS SELECT ROWID FROM BSC_TABS_B WHERE TAB_ID = X_TAB_ID;
47:
48: BEGIN
49: INSERT INTO BSC_TABS_B
50: (
51: TAB_ID,
52: KPI_MODEL,
53: BSC_MODEL,

Line 134: from BSC_TABS_B

130: BSC_MODEL,
131: CROSS_MODEL,
132: DEFAULT_MODEL,
133: ZOOM_FACTOR
134: from BSC_TABS_B
135: where TAB_ID = X_TAB_ID
136: for update of TAB_ID nowait;
137: recinfo c%rowtype;
138:

Line 213: UPDATE BSC_TABS_B

209: BEGIN
210:
211: IF X_TAB_ID IS NULL THEN
212: IF X_SHORT_NAME IS NOT NULL THEN
213: UPDATE BSC_TABS_B
214: SET KPI_MODEL = NVL(X_KPI_MODEL, KPI_MODEL),
215: BSC_MODEL = NVL(X_BSC_MODEL, BSC_MODEL),
216: CROSS_MODEL = NVL(X_CROSS_MODEL, CROSS_MODEL),
217: DEFAULT_MODEL = NVL(X_DEFAULT_MODEL, DEFAULT_MODEL),

Line 234: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)

230: SET NAME = NVL(X_NAME, NAME),
231: HELP = X_HELP,
232: ADDITIONAL_INFO = X_ADDITIONAL_INFO,
233: SOURCE_LANG = USERENV('LANG')
234: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)
235: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
236: END IF;
237: END IF;
238: ELSE

Line 240: UPDATE BSC_TABS_B

236: END IF;
237: END IF;
238: ELSE
239:
240: UPDATE BSC_TABS_B
241: SET KPI_MODEL = NVL(X_KPI_MODEL, KPI_MODEL),
242: BSC_MODEL = NVL(X_BSC_MODEL, BSC_MODEL),
243: CROSS_MODEL = NVL(X_CROSS_MODEL, CROSS_MODEL),
244: DEFAULT_MODEL = NVL(X_DEFAULT_MODEL, DEFAULT_MODEL),

Line 279: delete from BSC_TABS_B

275: if (sql%notfound) then
276: raise no_data_found;
277: end if;
278:
279: delete from BSC_TABS_B
280: where TAB_ID = X_TAB_ID;
281:
282: if (sql%notfound) then
283: raise no_data_found;

Line 293: from BSC_TABS_B B

289: begin
290: delete from BSC_TABS_TL T
291: where not exists
292: (select NULL
293: from BSC_TABS_B B
294: where B.TAB_ID = T.TAB_ID
295: );
296:
297: update BSC_TABS_TL T set (