APPS.BSC_KPI_PUB dependencies on BSC_KPIS_B

Line 88: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_KPIS_B','INDICATOR');

84: l_Bsc_Kpi_Entity_Rec.Bsc_Calendar_Id := 1;
85: END IF;
86:
87: -- Get the next id available for the current Kpi.
88: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_KPIS_B','INDICATOR');
89:
90: -- If KPI name is null then assign default.
91: IF l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Name IS NOT NULL THEN
92: IF l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Help IS NULL THEN

Line 128: , BSC_KPIS_B B

124: IF (l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Share_Flag <> 2) THEN
125: SELECT COUNT(B.Indicator)
126: INTO l_No_Ind
127: FROM BSC_TAB_IND_GROUPS_B A
128: , BSC_KPIS_B B
129: WHERE A.Ind_Group_Id = B.Ind_Group_Id
130: AND A.Group_Type = 1
131: AND A.Ind_Group_Id = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id
132: AND A.Tab_Id = -1

Line 441: FROM BSC_KPIS_B

437: l_count number;
438:
439: CURSOR c_Select_Indicator IS
440: SELECT INDICATOR
441: FROM BSC_KPIS_B
442: WHERE SOURCE_INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
443: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.Delete_Kpi_Flag;
444:
445: begin

Line 575: bsc_kpis_b kpi,

571: CURSOR c_imported_dims IS
572: SELECT
573: sys_dim.short_name
574: FROM
575: bsc_kpis_b kpi,
576: bsc_kpi_dim_groups kpi_dim,
577: bsc_sys_dim_groups_vl sys_dim
578: WHERE
579: kpi.indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id AND

Line 658: FROM BSC_KPIS_B

654: ,x_msg_data OUT NOCOPY VARCHAR2
655: ) IS
656: CURSOR c_Select_Indicator IS
657: SELECT INDICATOR,CONFIG_TYPE
658: FROM BSC_KPIS_B
659: WHERE SOURCE_INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
660: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.Delete_Kpi_Flag;
661:
662: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

Line 671: l_config_type BSC_KPIS_B.config_type%TYPE;

667: l_count NUMBER;
668: l_ind_tab_count NUMBER;
669: l_tab_id NUMBER;
670: x_dim_short_names BSC_UTILITY.t_array_of_varchar2;
671: l_config_type BSC_KPIS_B.config_type%TYPE;
672:
673: BEGIN
674: FND_MSG_PUB.Initialize;
675: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 689: from bsc_kpis_b

685:
686:
687: SELECT config_type
688: INTO l_config_type
689: from bsc_kpis_b
690: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
691:
692: -- if indicator assigned to tab get indicator.
693: IF(l_ind_tab_count > 0) THEN

Line 3294: l_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;

3290: ) IS
3291:
3292: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
3293: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
3294: l_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
3295: l_Comma_Sep_Resp_Key VARCHAR2(32000):= NULL;
3296:
3297: BEGIN
3298: FND_MSG_PUB.Initialize;

Line 3305: FROM BSC_KPIS_B K

3301:
3302: BEGIN
3303: SELECT K.SHORT_NAME
3304: INTO l_Kpi_Short_Name
3305: FROM BSC_KPIS_B K
3306: WHERE K.INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
3307:
3308: EXCEPTION
3309: WHEN NO_DATA_FOUND THEN

Line 4680: from bsc_kpis_b

4676: begin
4677:
4678: select last_update_date
4679: into l_time_stamp
4680: from bsc_kpis_b
4681: where indicator = p_kpi_id;
4682: return l_time_stamp;
4683:
4684: EXCEPTION

Line 4738: from BSC_KPIS_B

4734: select indicator, tab_id
4735: into l_share_kpi, l_share_tab
4736: from BSC_TAB_INDICATORS
4737: where indicator in (select indicator
4738: from BSC_KPIS_B
4739: where source_indicator = l_master_kpi );
4740: -- Get Master Tab
4741: select tab_id
4742: into l_master_tab