[Home] [Help]
506: l_form_parameters VARCHAR2(32000);
507: l_max_seq_number NUMBER;
508: l_sequence NUMBER;
509: l_Bsc_Measure_Id NUMBER;
510: l_report_region_rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
511: l_Analysis_Option_Id NUMBER;
512: l_AO_Id NUMBER;
513: l_Region_Code VARCHAR2(30);
514: l_Has_Region_By_AO BOOLEAN;
839: l_Rowid ROWID;
840: l_form_parameters VARCHAR2(32000);
841: l_max_seq_number NUMBER;
842: l_sequence NUMBER := 10;
843: l_report_region_rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
844: l_Region_Code VARCHAR2(30);
845: l_Analysis_Option_Id NUMBER;
846: l_Count NUMBER;
847: l_Last_Analysis_Option NUMBER;
1327: ,x_msg_data OUT NOCOPY VARCHAR2)
1328: IS
1329:
1330: l_dim NUMBER;
1331: l_region_item_table_dim_set BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
1332: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
1333: l_real_counter NUMBER := 1;
1334: l_Region_Code VARCHAR2(80);
1335:
1328: IS
1329:
1330: l_dim NUMBER;
1331: l_region_item_table_dim_set BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
1332: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
1333: l_real_counter NUMBER := 1;
1334: l_Region_Code VARCHAR2(80);
1335:
1336: BEGIN
1741: x_msg_count OUT NOCOPY NUMBER,
1742: x_msg_data OUT NOCOPY VARCHAR2
1743: ) IS
1744:
1745: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
1746: l_region_item_table_measure BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
1747: l_Region_Code VARCHAR2(80);
1748:
1749: BEGIN
1742: x_msg_data OUT NOCOPY VARCHAR2
1743: ) IS
1744:
1745: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
1746: l_region_item_table_measure BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
1747: l_Region_Code VARCHAR2(80);
1748:
1749: BEGIN
1750:
2399: x_Msg_Count OUT NOCOPY NUMBER,
2400: x_Msg_Data OUT NOCOPY VARCHAR2)
2401: IS
2402:
2403: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
2404: l_region_item_table_measure BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
2405: l_Region_Code VARCHAR2(30);
2406: l_Colspan_Attr_Code VARCHAR2(30);
2407: BEGIN
2400: x_Msg_Data OUT NOCOPY VARCHAR2)
2401: IS
2402:
2403: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
2404: l_region_item_table_measure BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
2405: l_Region_Code VARCHAR2(30);
2406: l_Colspan_Attr_Code VARCHAR2(30);
2407: BEGIN
2408:
2945: , x_msg_count OUT NOCOPY NUMBER
2946: , x_msg_data OUT NOCOPY VARCHAR2
2947: ) IS
2948:
2949: l_report_region_rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
2950:
2951: BEGIN
2952:
2953:
3047: , x_msg_count OUT NOCOPY NUMBER
3048: , x_msg_data OUT NOCOPY VARCHAR2
3049: ) IS
3050:
3051: l_report_region_rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
3052:
3053: BEGIN
3054:
3055:
3296: , x_msg_data OUT NOCOPY VARCHAR2
3297: )
3298: IS
3299:
3300: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
3301: l_region_item_table_nest BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
3302:
3303: BEGIN
3304:
3297: )
3298: IS
3299:
3300: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
3301: l_region_item_table_nest BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
3302:
3303: BEGIN
3304:
3305: l_region_item_rec.Attribute_Code := p_Param_Portlet_Region_Code;
3313: l_region_item_rec.Sort_Sequence := NULL;
3314: l_region_item_rec.Initial_Sort_Sequence := NULL;
3315: l_region_item_rec.Sort_Direction := NULL;
3316:
3317: l_region_item_rec.Item_Style := BIS_AK_REGION_PUB.c_NESTED_REGION_STYLE;
3318: l_region_item_rec.Nested_Region_Code := p_Param_Portlet_Region_Code;
3319: l_region_item_rec.Nested_Region_Application_Id := Get_Region_Application_Id(p_Param_Portlet_Region_Code);
3320:
3321: l_region_item_rec.Url := NULL;
3609: , x_msg_count OUT NOCOPY NUMBER
3610: , x_msg_data OUT NOCOPY VARCHAR2
3611: ) IS
3612:
3613: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
3614: l_region_item_table_measure BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
3615: BEGIN
3616:
3617: l_region_item_rec.Attribute_Code := p_Attribute_Code;
3610: , x_msg_data OUT NOCOPY VARCHAR2
3611: ) IS
3612:
3613: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
3614: l_region_item_table_measure BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
3615: BEGIN
3616:
3617: l_region_item_rec.Attribute_Code := p_Attribute_Code;
3618: l_region_item_rec.Attribute_Application_Id := p_Attribute_Application_Id;
3734: , p_Graph_Style => NULL
3735: , p_Aggregate_Function => NULL
3736: , p_Display_Total => NULL
3737: , p_Graph_Measure_Type => NULL
3738: , p_Item_Style => BIS_AK_REGION_PUB.c_NESTED_REGION_STYLE
3739: , p_Grand_Total_Flag => NULL
3740: , p_Nested_Region_Code => p_Param_Portlet_Region_Code
3741: , p_Nested_Region_Application_Id => Get_Region_Application_Id(p_Param_Portlet_Region_Code)
3742: , x_return_status => x_return_status
4118: , x_msg_count OUT NOCOPY NUMBER
4119: , x_msg_data OUT NOCOPY VARCHAR2
4120: ) IS
4121:
4122: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
4123: l_region_item_table_measure BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
4124:
4125:
4126: BEGIN
4119: , x_msg_data OUT NOCOPY VARCHAR2
4120: ) IS
4121:
4122: l_region_item_rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
4123: l_region_item_table_measure BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
4124:
4125:
4126: BEGIN
4127:
4901: l_Rowid ROWID;
4902: l_Form_Parameters FND_FORM_FUNCTIONS.PARAMETERS%TYPE;
4903: l_Max_Seq_Number NUMBER;
4904: l_Sequence NUMBER;
4905: l_Report_Region_Rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
4906: l_User_Page_Report_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4907: l_User_Portlet_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4908: l_Analysis_Option NUMBER;
4909: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
6527: CURSOR cAttrCode IS
6528: SELECT ATTRIBUTE_CODE
6529: FROM AK_REGION_ITEMS
6530: WHERE REGION_CODE = p_Region_Code
6531: AND ITEM_STYLE = BIS_AK_REGION_PUB.c_NESTED_REGION_STYLE
6532: AND NESTED_REGION_CODE IS NOT NULL;
6533: BEGIN
6534:
6535: l_Region_Code := NULL;
7957: , x_Return_Status OUT NOCOPY VARCHAR2
7958: , x_Msg_Count OUT NOCOPY NUMBER
7959: , x_Msg_Data OUT NOCOPY VARCHAR2
7960: ) IS
7961: l_report_region_rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
7962: x_Non_Time_Dimension_Groups BSC_VARCHAR2_TBL_TYPE;
7963: x_Non_Time_Dimension_Objects BSC_VARCHAR2_TBL_TYPE;
7964: x_Non_Time_Dim_Obj_Short_Names VARCHAR2(2056);
7965: x_Time_Dimension_Groups BSC_VARCHAR2_TBL_TYPE;
8134:
8135: -- Update the Objective Name to correspond with the AK Region Code
8136: -- Modification for Bug#4448994
8137:
8138: BIS_AK_REGION_PUB.Get_Region_Code_TL_Data (
8139: p_Region_Code => p_Region_Code
8140: , p_Region_Application_Id => p_Region_Application_Id
8141: , x_Region_Name => l_Region_Name
8142: , x_Region_Description => l_Region_Description
8410: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
8411: l_Delete_Measure VARCHAR2(1);
8412: l_Delete_Dimensions VARCHAR2(1);
8413:
8414: l_report_region_rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
8415:
8416:
8417: CURSOR c_Measure_Short_Names IS
8418: SELECT I.SHORT_NAME
9851: ,A.NESTED_REGION_APPLICATION_ID
9852: FROM AK_REGION_ITEMS A
9853: WHERE A.REGION_CODE = p_Region_Code
9854: AND A.REGION_APPLICATION_ID = p_Region_Application_Id
9855: AND A.ITEM_STYLE = BIS_AK_REGION_PUB.c_NESTED_REGION_STYLE;
9856: BEGIN
9857:
9858: FOR cGNR IN c_Get_Nested_Region_Items LOOP
9859: IF (Is_Dim_Exist_In_Current_Region(
9987: , x_Msg_Count OUT NOCOPY NUMBER
9988: , x_Msg_Data OUT NOCOPY VARCHAR2
9989: ) IS
9990: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
9991: l_Report_Region_Rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
9992: l_Region_Item_Tbl BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
9993: BEGIN
9994:
9995: SAVEPOINT CascadeParamPortlet;
9988: , x_Msg_Data OUT NOCOPY VARCHAR2
9989: ) IS
9990: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
9991: l_Report_Region_Rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
9992: l_Region_Item_Tbl BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
9993: BEGIN
9994:
9995: SAVEPOINT CascadeParamPortlet;
9996: FND_MSG_PUB.Initialize;
10112: RETURN NULL;
10113: END Get_New_Region_Code;
10114:
10115:
10116: -- Unrolls all the Dimension based region items into the table BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10117: -- for any given region_code, this API all
10118: PROCEDURE Unroll_RegionItems_Into_Record (
10119: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
10120: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
10117: -- for any given region_code, this API all
10118: PROCEDURE Unroll_RegionItems_Into_Record (
10119: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
10120: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
10121: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10122: ) IS
10123:
10124: CURSOR c_Get_Nested_Region_Items IS
10125: SELECT A.NESTED_REGION_CODE
10126: ,A.NESTED_REGION_APPLICATION_ID
10127: FROM AK_REGION_ITEMS A
10128: WHERE A.REGION_CODE = p_Region_Code
10129: AND A.REGION_APPLICATION_ID = p_Region_Application_Id
10130: AND A.ITEM_STYLE = BIS_AK_REGION_PUB.c_NESTED_REGION_STYLE
10131: ORDER BY A.DISPLAY_SEQUENCE;
10132:
10133: l_Region_Item_Tbl BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
10134: l_Display_Sequence NUMBER;
10129: AND A.REGION_APPLICATION_ID = p_Region_Application_Id
10130: AND A.ITEM_STYLE = BIS_AK_REGION_PUB.c_NESTED_REGION_STYLE
10131: ORDER BY A.DISPLAY_SEQUENCE;
10132:
10133: l_Region_Item_Tbl BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
10134: l_Display_Sequence NUMBER;
10135: l_Count NUMBER;
10136: BEGIN
10137: l_Display_Sequence := 10;
10170: WHEN OTHERS THEN
10171: NULL;
10172: END Unroll_RegionItems_Into_Record;
10173:
10174: -- gets all the region items into the PL/SQL table BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
10175: PROCEDURE Get_Non_Nested_Into_Rec (
10176: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
10177: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
10178: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10174: -- gets all the region items into the PL/SQL table BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
10175: PROCEDURE Get_Non_Nested_Into_Rec (
10176: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
10177: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
10178: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10179: ) IS
10180: CURSOR c_NonNested IS
10181: SELECT
10182: AV.REGION_APPLICATION_ID
10208: , AV.ATTRIBUTE13
10209: , AV.ATTRIBUTE14
10210: , AV.ATTRIBUTE15
10211: FROM AK_REGION_ITEMS_VL AV
10212: WHERE AV.ITEM_STYLE <> BIS_AK_REGION_PUB.c_NESTED_REGION_STYLE
10213: AND AV.REGION_CODE = p_Region_Code
10214: AND AV.REGION_APPLICATION_ID = p_Region_Application_Id
10215: AND AV.ATTRIBUTE1 IN ('DIMENSION LEVEL',
10216: 'DIM LEVEL SINGLE VALUE',
10369: l_Count_New_Attribute_Codes NUMBER;
10370: l_Delete_Measure VARCHAR2(1);
10371: l_Delete_Dimensions VARCHAR2(1);
10372:
10373: l_report_region_rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
10374:
10375: BEGIN
10376: SAVEPOINT MigrateAGRTOPLSQL1;
10377: FND_MSG_PUB.Initialize;