APPS.BSC_KPI_GROUP_PVT dependencies on BSC_TAB_IND_GROUPS_TL

Line 24: | 1. Modified Update Query for BSC_TAB_IND_GROUPS_TL. |

20: | BSC Kpi Group information. |
21: | |
22: | History: |
23: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
24: | 1. Modified Update Query for BSC_TAB_IND_GROUPS_TL. |
25: | 2. Changed nvl(.Bsc_Language, userenv('LANG')) |
26: | to userenv('LANG') |
27: | 30-Oct-2003 ADEULGAO Fixed Bug#3208420, modified Delete_Kpi_Group to handle |
28: | Bsc_Tab_Id <> -1 condition. |

Line 143: g_db_object := 'BSC_TAB_IND_GROUPS_TL';

139: ,p_Bsc_Kpi_Group_Rec.Bsc_Group_Width
140: ,p_Bsc_Kpi_Group_Rec.Bsc_Group_Height
141: ,p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Short_Name);
142:
143: g_db_object := 'BSC_TAB_IND_GROUPS_TL';
144:
145: INSERT INTO BSC_TAB_IND_GROUPS_TL( TAB_ID
146: ,CSF_ID
147: ,IND_GROUP_ID

Line 145: INSERT INTO BSC_TAB_IND_GROUPS_TL( TAB_ID

141: ,p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Short_Name);
142:
143: g_db_object := 'BSC_TAB_IND_GROUPS_TL';
144:
145: INSERT INTO BSC_TAB_IND_GROUPS_TL( TAB_ID
146: ,CSF_ID
147: ,IND_GROUP_ID
148: ,LANGUAGE
149: ,SOURCE_LANG

Line 164: FROM BSC_TAB_IND_GROUPS_TL T

160: FROM FND_LANGUAGES L
161: WHERE L.INSTALLED_FLAG IN ('I', 'B')
162: AND NOT EXISTS
163: (SELECT NULL
164: FROM BSC_TAB_IND_GROUPS_TL T
165: WHERE T.tab_id = p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id
166: AND T.csf_id = p_Bsc_Kpi_Group_Rec.Bsc_Csf_Id
167: AND T.ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
168: AND T.LANGUAGE = L.LANGUAGE_CODE);

Line 268: ,BSC_TAB_IND_GROUPS_TL b

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')
272: AND a.tab_id = -1

Line 368: from BSC_TAB_IND_GROUPS_TL

364: --BSC_DEBUG.PUT_LINE(' BSC_KPI_GROUP_PVT.Update_Kpi_Group - Flag 1' );
365:
366: select count(ind_group_id)
367: into l_name_count
368: from BSC_TAB_IND_GROUPS_TL
369: where name = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Name
370: and ind_group_id <> p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
371: and tab_id = -1;
372:

Line 488: update BSC_TAB_IND_GROUPS_TL

484: where ind_group_id = l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id;
485:
486: if l_update_TL = 1 then
487: --BSC_DEBUG.PUT_LINE(' BSC_KPI_GROUP_PVT.Update_Kpi_Group - Flag 4.5 ' );
488: update BSC_TAB_IND_GROUPS_TL
489: set csf_id = l_Bsc_Kpi_Group_Rec.Bsc_Csf_Id
490: ,name = l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Name
491: ,help = l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Help
492: ,source_lang = userenv('LANG')

Line 616: delete from BSC_TAB_IND_GROUPS_TL

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
617: where ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
618: and tab_id = p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id;
619: else
620: FND_MSG_PUB.Initialize;

Line 641: delete from BSC_TAB_IND_GROUPS_TL

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;
643: else
644: FND_MSG_PUB.Initialize;
645: FND_MESSAGE.SET_NAME('BSC','BSC_CANNOT_DELETE_KGROUP');