DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BISVIEWER

Line 170: REM |07-NOV-2005 arhegde bug# 4720781 Handle bisviewer.showReport changed to|

166: REM | 2.Has_Measure_Column_Changed |
167: REM | 30-SEP-2005 adrao Modified code to ensure that the compare is |
168: REM | populated when the measure is created |
169: REM | Fixed Bug#4638384 |
170: REM |07-NOV-2005 arhegde bug# 4720781 Handle bisviewer.showReport changed to|
171: REM | OA.jsp?page=/oracle/apps/bis/report/webui/BISReportPG |
172: REM | 25-DEC-2005 adrao Added APIs following APIs for Enh#3909868 |
173: REM | - Migrate_AGR_To_PLSQL |
174: REM | - Is_Primary_Source_Of_Measure |

Line 2531: l_Attribute_Code_Tbl BISVIEWER.t_char ;

2527: x_return_status OUT NOCOPY VARCHAR2,
2528: x_msg_count OUT NOCOPY NUMBER,
2529: x_msg_data OUT NOCOPY VARCHAR2)
2530: IS
2531: l_Attribute_Code_Tbl BISVIEWER.t_char ;
2532: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
2533: BEGIN
2534:
2535: l_Attribute_Code_Tbl(1) := p_Measure_Short_Name;

Line 2532: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;

2528: x_msg_count OUT NOCOPY NUMBER,
2529: x_msg_data OUT NOCOPY VARCHAR2)
2530: IS
2531: l_Attribute_Code_Tbl BISVIEWER.t_char ;
2532: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
2533: BEGIN
2534:
2535: l_Attribute_Code_Tbl(1) := p_Measure_Short_Name;
2536: l_Attribute_App_Id_Tbl(1) := p_Application_Id;

Line 2690: l_Attribute_Code_Tbl BISVIEWER.t_char ;

2686: ,x_Return_Status OUT NOCOPY VARCHAR2
2687: ,x_Msg_Count OUT NOCOPY NUMBER
2688: ,x_Msg_Data OUT NOCOPY VARCHAR2)
2689: IS
2690: l_Attribute_Code_Tbl BISVIEWER.t_char ;
2691: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
2692: l_Dim NUMBER;
2693: l_Real_Counter NUMBER;
2694: BEGIN

Line 2691: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;

2687: ,x_Msg_Count OUT NOCOPY NUMBER
2688: ,x_Msg_Data OUT NOCOPY VARCHAR2)
2689: IS
2690: l_Attribute_Code_Tbl BISVIEWER.t_char ;
2691: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
2692: l_Dim NUMBER;
2693: l_Real_Counter NUMBER;
2694: BEGIN
2695:

Line 3373: l_Attribute_Code_Tbl BISVIEWER.t_char ;

3369: x_return_status OUT NOCOPY VARCHAR2,
3370: x_msg_count OUT NOCOPY NUMBER,
3371: x_msg_data OUT NOCOPY VARCHAR2
3372: ) IS
3373: l_Attribute_Code_Tbl BISVIEWER.t_char ;
3374: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
3375: BEGIN
3376:
3377: l_Attribute_Code_Tbl(1) := p_Nested_Region_Code;

Line 3374: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;

3370: x_msg_count OUT NOCOPY NUMBER,
3371: x_msg_data OUT NOCOPY VARCHAR2
3372: ) IS
3373: l_Attribute_Code_Tbl BISVIEWER.t_char ;
3374: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
3375: BEGIN
3376:
3377: l_Attribute_Code_Tbl(1) := p_Nested_Region_Code;
3378: l_Attribute_App_Id_Tbl(1) := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;

Line 4047: l_Attribute_Code_Tbl BISVIEWER.t_char ;

4043: x_return_status OUT NOCOPY VARCHAR2,
4044: x_msg_count OUT NOCOPY NUMBER,
4045: x_msg_data OUT NOCOPY VARCHAR2
4046: ) IS
4047: l_Attribute_Code_Tbl BISVIEWER.t_char ;
4048: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
4049:
4050: l_index NUMBER;
4051:

Line 4048: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;

4044: x_msg_count OUT NOCOPY NUMBER,
4045: x_msg_data OUT NOCOPY VARCHAR2
4046: ) IS
4047: l_Attribute_Code_Tbl BISVIEWER.t_char ;
4048: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
4049:
4050: l_index NUMBER;
4051:
4052: CURSOR c_Attrs IS

Line 9583: from report designer or not.If WEB_HTML_CALL of FND_FORM_FUNCTIONS is bisviewer.showreport or BISReportPG then it is created

9579:
9580: /*****************************************************
9581: Name : is_Scorecard_From_Reports
9582: Description : This API checks if the scoreacrd was created
9583: from report designer or not.If WEB_HTML_CALL of FND_FORM_FUNCTIONS is bisviewer.showreport or BISReportPG then it is created
9584: from report designer.If it is OA.jsp?akRegionCode=BIS_COMPONENT_PAGE?akRegionApplicationId=191 then it is created from page designer.
9585: Scorecard created from page designer can be deleted from Scorecard designers but not the scorecard created from
9586: report designer.
9587: INPUT : p_tab_sht_name

Line 9613: IF((UPPER(l_web_html_call)=BSC_BIS_KPI_CRUD_PUB.C_BISVIEWER_SHOWREPORT) OR (UPPER(l_web_html_call) = UPPER(BSC_BIS_KPI_CRUD_PUB.c_bisreportpg)))THEN

9609: OPEN c_form_function;
9610: FETCH c_form_function INTO l_web_html_call;
9611: CLOSE c_form_function;
9612:
9613: IF((UPPER(l_web_html_call)=BSC_BIS_KPI_CRUD_PUB.C_BISVIEWER_SHOWREPORT) OR (UPPER(l_web_html_call) = UPPER(BSC_BIS_KPI_CRUD_PUB.c_bisreportpg)))THEN
9614: RETURN FND_API.G_TRUE;
9615: END IF;
9616:
9617: RETURN FND_API.G_FALSE;