DBA Data[Home] [Help]

APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on BSC_TAB_VIEW_LABELS_PKG

Line 195: BSC_TAB_VIEW_LABELS_PKG.DELETE_ROW (

191: --loop for all existing labels and remove all those that are not in the l_labels
192: FOR l_label_cur IN label_cur
193: LOOP
194: IF (l_lables_table.exists(l_label_cur.label_id) = FALSE) THEN
195: BSC_TAB_VIEW_LABELS_PKG.DELETE_ROW (
196: X_TAB_ID => p_tab_id,
197: X_TAB_VIEW_ID => p_tab_view_id,
198: X_LABEL_ID => l_label_cur.label_id
199: );

Line 210: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG

206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: x_msg_data := SQLERRM;
208: END remove_custom_view_items;
209:
210: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG
211: PROCEDURE add_or_update_kpi_actual(
212: p_tab_id IN NUMBER
213: ,p_tab_view_id IN NUMBER
214: ,p_object_id IN NUMBER

Line 264: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG

260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: x_msg_data := SQLERRM;
262: END add_or_update_kpi_actual;
263:
264: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG
265: PROCEDURE add_or_update_kpi_change(
266: p_tab_id IN NUMBER
267: ,p_tab_view_id IN NUMBER
268: ,p_object_id IN NUMBER

Line 318: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG

314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: x_msg_data := SQLERRM;
316: END add_or_update_kpi_change;
317:
318: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG
319: PROCEDURE add_or_update_kpi_label(
320: p_tab_id IN NUMBER
321: ,p_tab_view_id IN NUMBER
322: ,p_object_id IN NUMBER

Line 421: -- Add specified entry for objectives to BSC_TAB_VIEW_LABELS_PKG

417: SAVEPOINT RollBackPt;
418: fnd_msg_pub.initialize;
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: -- Add specified entry for objectives to BSC_TAB_VIEW_LABELS_PKG
422: -- position and color info is stored in BSC_TAB_VIEW_KPI_TL entries
423: add_or_update_kpi_label(
424: p_tab_id => p_tab_id
425: ,p_tab_view_id => p_tab_view_id

Line 465: -- Add specified entry for actual to BSC_TAB_VIEW_LABELS_PKG

461: ,x_msg_count => x_msg_count
462: ,x_msg_data => x_msg_data
463: );
464:
465: -- Add specified entry for actual to BSC_TAB_VIEW_LABELS_PKG
466: add_or_update_kpi_actual(
467: p_tab_id => p_tab_id
468: ,p_tab_view_id => p_tab_view_id
469: ,p_object_id => p_actual_object_id

Line 486: -- Add specified entry for change to BSC_TAB_VIEW_LABELS_PKG

482: ,x_msg_count => x_msg_count
483: ,x_msg_data => x_msg_data
484: );
485:
486: -- Add specified entry for change to BSC_TAB_VIEW_LABELS_PKG
487: add_or_update_kpi_change(
488: p_tab_id => p_tab_id
489: ,p_tab_view_id => p_tab_view_id
490: ,p_object_id => p_change_object_id

Line 507: -- Add Specified entry for trend to BSC_TAB_VIEW_LABELS_PKG

503: ,x_msg_count => x_msg_count
504: ,x_msg_data => x_msg_data
505: );
506:
507: -- Add Specified entry for trend to BSC_TAB_VIEW_LABELS_PKG
508:
509: add_or_update_kpi_trend(
510: p_tab_id => p_tab_id
511: ,p_tab_view_id => p_tab_view_id

Line 538: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG

534: x_msg_data := SQLERRM;
535: END add_or_update_kpi;
536:
537:
538: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG
539: PROCEDURE add_or_update_label(
540: p_tab_id IN NUMBER
541: ,p_tab_view_id IN NUMBER
542: ,p_object_id IN NUMBER

Line 589: -- Add specified hotspot to BSC_TAB_VIEW_LABELS_PKG

585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: x_msg_data := SQLERRM;
587: END add_or_update_label;
588:
589: -- Add specified hotspot to BSC_TAB_VIEW_LABELS_PKG
590: PROCEDURE add_or_update_hotspot(
591: p_tab_id IN NUMBER
592: ,p_tab_view_id IN NUMBER
593: ,p_object_id IN NUMBER

Line 637: -- Add specified custom view link to BSC_TAB_VIEW_LABELS_PKG

633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: x_msg_data := SQLERRM;
635: END add_or_update_hotspot;
636:
637: -- Add specified custom view link to BSC_TAB_VIEW_LABELS_PKG
638: PROCEDURE add_or_update_custom_view_link(
639: p_tab_id IN NUMBER
640: ,p_tab_view_id IN NUMBER
641: ,p_object_id IN NUMBER

Line 690: -- Add specified launchpad to BSC_TAB_VIEW_LABELS_PKG

686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: x_msg_data := SQLERRM;
688: END add_or_update_custom_view_link;
689:
690: -- Add specified launchpad to BSC_TAB_VIEW_LABELS_PKG
691: PROCEDURE add_or_update_launch_pad(
692: p_tab_id IN NUMBER
693: ,p_tab_view_id IN NUMBER
694: ,p_object_id IN NUMBER

Line 740: -- Add specified measure (existing kpi) to BSC_TAB_VIEW_LABELS_PKG

736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: x_msg_data := SQLERRM;
738: END add_or_update_launch_pad;
739:
740: -- Add specified measure (existing kpi) to BSC_TAB_VIEW_LABELS_PKG
741: PROCEDURE add_or_update_measure(
742: p_tab_id IN NUMBER
743: ,p_tab_view_id IN NUMBER
744: ,p_text_object_id IN NUMBER

Line 881: -- Wrapper for calling BSC_TAB_VIEW_LABELS_PKG procedures

877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: x_msg_data := SQLERRM;
879: END add_or_update_measure;
880:
881: -- Wrapper for calling BSC_TAB_VIEW_LABELS_PKG procedures
882: PROCEDURE add_or_update_tab_view_label(
883: p_tab_id IN NUMBER
884: ,p_tab_view_id IN NUMBER
885: ,p_object_id IN NUMBER

Line 930: BSC_TAB_VIEW_LABELS_PKG.INSERT_ROW (

926: IF (l_object_id IS NULL) THEN
927: l_object_id := 0;
928: END IF;
929:
930: BSC_TAB_VIEW_LABELS_PKG.INSERT_ROW (
931: X_ROWID => l_str,
932: X_TAB_ID => p_tab_id,
933: X_TAB_VIEW_ID => p_tab_view_id,
934: X_LABEL_ID => l_object_id,

Line 957: BSC_TAB_VIEW_LABELS_PKG.UPDATE_ROW (

953: X_LAST_UPDATE_LOGIN => fnd_global.login_id
954: );
955: ELSE
956: --update
957: BSC_TAB_VIEW_LABELS_PKG.UPDATE_ROW (
958: X_TAB_ID => p_tab_id,
959: X_TAB_VIEW_ID => p_tab_view_id,
960: X_LABEL_ID => p_object_id,
961: X_LABEL_TYPE => p_object_type,