APPS.BSC_KPI_GROUP_PVT dependencies on BSC_TAB_IND_GROUPS_B

Line 63: FROM BSC_TAB_IND_GROUPS_B

59: IF p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id <> -1 THEN
60: -- Check that valid Kpi group id was entered.
61: IF p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id IS NOT NULL THEN
62: SELECT COUNT(1) INTO l_Count
63: FROM BSC_TAB_IND_GROUPS_B
64: WHERE IND_GROUP_ID = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id;
65:
66: IF l_count = 0 THEN
67: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KGROUP_ID');

Line 102: FROM BSC_TAB_IND_GROUPS_B

98: ELSE -- New KPI Group to be added
99: IF p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Short_Name IS NOT NULL THEN
100:
101: SELECT COUNT(1) INTO l_Count
102: FROM BSC_TAB_IND_GROUPS_B
103: WHERE SHORT_NAME = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Short_Name;
104:
105: -- Need to review if this validation is required, since we are not deleting KPI Group
106: -- and it can have multiple rows

Line 117: g_db_object := 'BSC_TAB_IND_GROUPS_B';

113: -- END IF;
114: END IF;
115: END IF;
116:
117: g_db_object := 'BSC_TAB_IND_GROUPS_B';
118:
119:
120: INSERT INTO BSC_TAB_IND_GROUPS_B( TAB_ID
121: ,CSF_ID

Line 120: INSERT INTO BSC_TAB_IND_GROUPS_B( TAB_ID

116:
117: g_db_object := 'BSC_TAB_IND_GROUPS_B';
118:
119:
120: INSERT INTO BSC_TAB_IND_GROUPS_B( TAB_ID
121: ,CSF_ID
122: ,IND_GROUP_ID
123: ,GROUP_TYPE
124: ,NAME_POSITION

Line 267: FROM BSC_TAB_IND_GROUPS_B a

263: ,x_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Short_Name
264: ,x_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Name
265: ,x_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Help
266: ,x_Bsc_Kpi_Group_Rec.Bsc_Source_Language
267: FROM BSC_TAB_IND_GROUPS_B a
268: ,BSC_TAB_IND_GROUPS_TL b
269: WHERE a.ind_group_id = b.ind_group_id
270: AND b.ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
271: AND b.language = USERENV('LANG')

Line 348: FROM BSC_TAB_IND_GROUPS_B

344: -- Check that valid Kpi group id was entered.
345: if p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id is not null then
346:
347: SELECT COUNT(1) INTO l_Count
348: FROM BSC_TAB_IND_GROUPS_B
349: WHERE ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id;
350:
351: if l_count = 0 then
352: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KGROUP_ID');

Line 464: from BSC_TAB_IND_GROUPS_B

460: -- need to create entry for this group with this tab.
461: if p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id is not null and p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id <> -1 then
462: select count(*)
463: into l_count
464: from BSC_TAB_IND_GROUPS_B
465: where tab_id = p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id
466: and ind_group_id = l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id;
467: end if;
468: --BSC_DEBUG.PUT_LINE('l_count = ' || l_count );

Line 479: update BSC_TAB_IND_GROUPS_B

475: ,x_msg_count
476: ,x_msg_data);
477: end if;
478:
479: update BSC_TAB_IND_GROUPS_B
480: set csf_id = l_Bsc_Kpi_Group_Rec.Bsc_Csf_Id
481: ,group_type = l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Type
482: ,name_position = l_Bsc_Kpi_Group_Rec.Bsc_Name_Pos_In_Tab
483: ,name_justification = l_Bsc_Kpi_Group_Rec.Bsc_Name_Justif_In_Tab

Line 503: update BSC_TAB_IND_GROUPS_B

499:
500: -- The previous UPDATES are for the group in all tabs. The following
501: -- updates are applied to individual tabs.
502:
503: update BSC_TAB_IND_GROUPS_B
504: set left_position = l_Bsc_Kpi_Group_Rec.Bsc_Left_Position_In_Tab
505: ,top_position = l_Bsc_Kpi_Group_Rec.Bsc_Top_Position_In_Tab
506: ,width = l_Bsc_Kpi_Group_Rec.Bsc_Group_Width
507: ,height = l_Bsc_Kpi_Group_Rec.Bsc_Group_Height

Line 584: FROM BSC_TAB_IND_GROUPS_B

580: -- Check that Group id is valid.
581: if p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id is not null then
582:
583: SELECT COUNT(1) INTO l_Count
584: FROM BSC_TAB_IND_GROUPS_B
585: WHERE IND_GROUP_ID = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id;
586:
587: if l_count = 0 then
588: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KGROUP_ID');

Line 612: delete from BSC_TAB_IND_GROUPS_B

608: and a.indicator = b.indicator
609: and b.tab_id = p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id;
610:
611: if l_count_kpi = 0 then
612: delete from BSC_TAB_IND_GROUPS_B
613: where ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
614: and tab_id = p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id;
615:
616: delete from BSC_TAB_IND_GROUPS_TL

Line 638: delete from BSC_TAB_IND_GROUPS_B

634: where ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
635: and PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG; -- Added to fix bug 3267470
636:
637: if l_count = 0 then
638: delete from BSC_TAB_IND_GROUPS_B
639: where ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id;
640:
641: delete from BSC_TAB_IND_GROUPS_TL
642: where ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id;