APPS.BSC_KPI_PUB dependencies on BSC_UTILITY

Line 565: ,x_dim_list OUT NOCOPY BSC_UTILITY.t_array_of_varchar2

561: ************************************************************************************/
562:
563: PROCEDURE Get_KPI_Dim_ShortNames (
564: p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
565: ,x_dim_list OUT NOCOPY BSC_UTILITY.t_array_of_varchar2
566: ,x_return_status OUT NOCOPY varchar2
567: ,x_msg_count OUT NOCOPY number
568: ,x_msg_data OUT NOCOPY varchar2
569: )

Line 583: bsc_bis_dimension_pub.get_dimension_source(sys_dim.short_name) = BSC_UTILITY.c_PMF;

579: kpi.indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id AND
580: kpi.short_name IS NULL AND
581: kpi_dim.indicator = kpi.indicator AND
582: sys_dim.dim_group_id = kpi_dim.dim_group_id AND
583: bsc_bis_dimension_pub.get_dimension_source(sys_dim.short_name) = BSC_UTILITY.c_PMF;
584:
585: l_regions VARCHAR2(32000);
586: l_row_count NUMBER := 0;
587:

Line 611: ,p_dim_short_names IN BSC_UTILITY.t_array_of_varchar2

607: ************************************************************************************/
608:
609: PROCEDURE Delete_Unused_Imported_Dims(
610: p_commit IN VARCHAR2 := FND_API.G_FALSE
611: ,p_dim_short_names IN BSC_UTILITY.t_array_of_varchar2
612: ,x_return_status OUT NOCOPY varchar2
613: ,x_msg_count OUT NOCOPY number
614: ,x_msg_data OUT NOCOPY varchar2
615: ) IS

Line 619: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_names(i), BSC_UTILITY.c_DIMENSION);

615: ) IS
616: l_regions VARCHAR2(32000);
617: BEGIN
618: FOR i in 1..p_dim_short_names.COUNT LOOP
619: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_names(i), BSC_UTILITY.c_DIMENSION);
620: IF (l_regions IS NULL) THEN
621: BSC_BIS_DIMENSION_PUB.Delete_Dimension
622: ( p_commit => FND_API.G_FALSE
623: , p_dim_short_name => p_dim_short_names(i)

Line 670: x_dim_short_names BSC_UTILITY.t_array_of_varchar2;

666: l_share_flag NUMBER;
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;

Line 3314: l_Responsibility_Key := BSC_UTILITY.Get_Responsibility_Key;

3310: l_Kpi_Short_Name := NULL;
3311: END;
3312:
3313: -- added for Bug#4563456
3314: l_Responsibility_Key := BSC_UTILITY.Get_Responsibility_Key;
3315:
3316: IF (UPPER(l_Responsibility_Key) = 'BSC_DESIGNER') OR (UPPER(l_Responsibility_Key) = 'BSC_MANAGER') OR (l_Kpi_Short_Name IS NOT NULL )THEN
3317:
3318: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||

Line 3319: bsc_utility.c_BSC_Manager ||','||

3315:
3316: IF (UPPER(l_Responsibility_Key) = 'BSC_DESIGNER') OR (UPPER(l_Responsibility_Key) = 'BSC_MANAGER') OR (l_Kpi_Short_Name IS NOT NULL )THEN
3317:
3318: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
3319: bsc_utility.c_BSC_Manager ||','||
3320: bsc_utility.c_BSC_DESIGNER ||','||
3321: bsc_utility.c_BSC_PMD_USER ||','||
3322: bsc_utility.c_BIS_BID_RESP ||','||
3323: bsc_utility.c_BIS_DBI_ADMIN||','||

Line 3320: bsc_utility.c_BSC_DESIGNER ||','||

3316: IF (UPPER(l_Responsibility_Key) = 'BSC_DESIGNER') OR (UPPER(l_Responsibility_Key) = 'BSC_MANAGER') OR (l_Kpi_Short_Name IS NOT NULL )THEN
3317:
3318: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
3319: bsc_utility.c_BSC_Manager ||','||
3320: bsc_utility.c_BSC_DESIGNER ||','||
3321: bsc_utility.c_BSC_PMD_USER ||','||
3322: bsc_utility.c_BIS_BID_RESP ||','||
3323: bsc_utility.c_BIS_DBI_ADMIN||','||
3324: l_responsibility_key;

Line 3321: bsc_utility.c_BSC_PMD_USER ||','||

3317:
3318: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
3319: bsc_utility.c_BSC_Manager ||','||
3320: bsc_utility.c_BSC_DESIGNER ||','||
3321: bsc_utility.c_BSC_PMD_USER ||','||
3322: bsc_utility.c_BIS_BID_RESP ||','||
3323: bsc_utility.c_BIS_DBI_ADMIN||','||
3324: l_responsibility_key;
3325: ELSE

Line 3322: bsc_utility.c_BIS_BID_RESP ||','||

3318: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
3319: bsc_utility.c_BSC_Manager ||','||
3320: bsc_utility.c_BSC_DESIGNER ||','||
3321: bsc_utility.c_BSC_PMD_USER ||','||
3322: bsc_utility.c_BIS_BID_RESP ||','||
3323: bsc_utility.c_BIS_DBI_ADMIN||','||
3324: l_responsibility_key;
3325: ELSE
3326: l_Comma_Sep_Resp_Key := l_responsibility_key;

Line 3323: bsc_utility.c_BIS_DBI_ADMIN||','||

3319: bsc_utility.c_BSC_Manager ||','||
3320: bsc_utility.c_BSC_DESIGNER ||','||
3321: bsc_utility.c_BSC_PMD_USER ||','||
3322: bsc_utility.c_BIS_BID_RESP ||','||
3323: bsc_utility.c_BIS_DBI_ADMIN||','||
3324: l_responsibility_key;
3325: ELSE
3326: l_Comma_Sep_Resp_Key := l_responsibility_key;
3327: