APPS.BSC_TAB_VIEW_LABELS_PKG dependencies on BSC_TAB_VIEW_LABELS_B

Line 65: cursor C is select ROWID from BSC_TAB_VIEW_LABELS_B

61: X_LAST_UPDATE_DATE in DATE,
62: X_LAST_UPDATED_BY in NUMBER,
63: X_LAST_UPDATE_LOGIN in NUMBER
64: ) is
65: cursor C is select ROWID from BSC_TAB_VIEW_LABELS_B
66: where TAB_ID = X_TAB_ID
67: and TAB_VIEW_ID = X_TAB_VIEW_ID
68: and LABEL_ID = X_LABEL_ID
69: ;

Line 73: insert into BSC_TAB_VIEW_LABELS_B (

69: ;
70:
71: begin
72:
73: insert into BSC_TAB_VIEW_LABELS_B (
74: TAB_ID,
75: TAB_VIEW_ID,
76: LABEL_ID,
77: LABEL_TYPE,

Line 184: from BSC_TAB_VIEW_LABELS_B

180: ) is
181: cursor c is select
182: LABEL_TYPE,
183: LINK_ID
184: from BSC_TAB_VIEW_LABELS_B
185: where TAB_ID = X_TAB_ID
186: and TAB_VIEW_ID = X_TAB_VIEW_ID
187: and LABEL_ID = X_LABEL_ID
188: for update of TAB_ID nowait;

Line 278: update BSC_TAB_VIEW_LABELS_B set

274: ) is
275:
276: begin
277:
278: update BSC_TAB_VIEW_LABELS_B set
279: LABEL_TYPE = NVL(X_LABEL_TYPE, LABEL_TYPE),
280: LINK_ID = X_LINK_ID,
281: FUNCTION_ID = X_FUNCTION_ID,
282: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE, LAST_UPDATE_DATE),

Line 334: delete from BSC_TAB_VIEW_LABELS_B

330: if (sql%notfound) then
331: raise no_data_found;
332: end if;
333:
334: delete from BSC_TAB_VIEW_LABELS_B
335: where TAB_ID = X_TAB_ID
336: and LABEL_ID = X_LABEL_ID
337: and TAB_VIEW_ID = X_TAB_VIEW_ID;
338:

Line 354: from BSC_TAB_VIEW_LABELS_B B

350:
351: delete from BSC_TAB_VIEW_LABELS_TL T
352: where not exists
353: (select NULL
354: from BSC_TAB_VIEW_LABELS_B B
355: where B.TAB_ID = T.TAB_ID
356: and B.LABEL_ID = T.LABEL_ID
357: and B.TAB_VIEW_ID = T.TAB_VIEW_ID
358: );

Line 483: SELECT COUNT(*) INTO L_SHORT FROM BSC_TAB_VIEW_LABELS_B

479: X_LAST_UPDATE_DATE IN DATE
480: ) IS
481: L_SHORT NUMBER := -1;
482: BEGIN
483: SELECT COUNT(*) INTO L_SHORT FROM BSC_TAB_VIEW_LABELS_B
484: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)
485: AND TAB_VIEW_ID = X_TAB_VIEW_ID
486: AND LABEL_ID = X_LABEL_ID;
487: IF (L_SHORT > 0) THEN

Line 488: UPDATE BSC_TAB_VIEW_LABELS_B

484: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)
485: AND TAB_VIEW_ID = X_TAB_VIEW_ID
486: AND LABEL_ID = X_LABEL_ID;
487: IF (L_SHORT > 0) THEN
488: UPDATE BSC_TAB_VIEW_LABELS_B
489: SET LINK_ID = X_MENU_ID
490: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)
491: AND TAB_VIEW_ID = X_TAB_VIEW_ID
492: AND LABEL_ID = X_LABEL_ID

Line 498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');

494: -- AND LAST_UPDATE_DATE <= X_LAST_UPDATE_DATE;
495: ELSE
496: FND_MESSAGE.SET_NAME('BSC', 'NO DATA FOUND');
497: FND_MESSAGE.SET_TOKEN('PACKAGE', 'BSC_TAB_VIEW_LABELS_PKG');
498: FND_MESSAGE.SET_TOKEN('TABLE', 'BSC_TAB_VIEW_LABELS_B');
499: FND_MESSAGE.SET_TOKEN('COLUMN', 'TAB_ID');
500: FND_MESSAGE.SET_TOKEN('VALUE', X_SHORT_NAME);
501: FND_MESSAGE.SET_TOKEN('COLUMN', 'X_TAB_VIEW_ID');
502: FND_MESSAGE.SET_TOKEN('VALUE', X_TAB_VIEW_ID);