eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on AK_REGION_ITEMS

Line 97: REM | Create_Addl_Ak_Region_Items() for Enh. 4065089 |

93: REM | Validate_Kpi_Delete |
94: REM | 02-NOV-04 akoduri Modified for bug#3977463 |
95: REM | 21-DEC-04 adrao Modified for 8i compatibility, Bug#4079898 |
96: REM | 28-JAN-05 visuri added Has_Compare_To_Or_Plan() , modified |
97: REM | Create_Addl_Ak_Region_Items() for Enh. 4065089 |
98: REM | 08-FEB-05 visuri Modified Create_Addl_Ak_Region_Items() for |
99: REM | Enh. 4065098 |
100: REM | 11-Feb-05 sawu Bug#4057761: create unique tab name, group |
101: REM | name |

Line 98: REM | 08-FEB-05 visuri Modified Create_Addl_Ak_Region_Items() for |

94: REM | 02-NOV-04 akoduri Modified for bug#3977463 |
95: REM | 21-DEC-04 adrao Modified for 8i compatibility, Bug#4079898 |
96: REM | 28-JAN-05 visuri added Has_Compare_To_Or_Plan() , modified |
97: REM | Create_Addl_Ak_Region_Items() for Enh. 4065089 |
98: REM | 08-FEB-05 visuri Modified Create_Addl_Ak_Region_Items() for |
99: REM | Enh. 4065098 |
100: REM | 11-Feb-05 sawu Bug#4057761: create unique tab name, group |
101: REM | name |
102: REM | 22-FEB-05 adrao Autogenerated Measures Enhancement for Report |

Line 706: BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items(

702: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END IF;
705:
706: BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items(
707: p_commit => p_commit
708: , p_Region_Code => l_Region_Code
709: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
710: , p_Display_Format => Get_Format_Mask(p_Dataset_Format_Id)

Line 1151: FROM ak_region_items a

1147:
1148: -- attribute2 stores dim+dim obj
1149: CURSOR c_dim(p_region_code varchar2) IS
1150: SELECT DISTINCT a.attribute2, a.display_sequence
1151: FROM ak_region_items a
1152: WHERE a.region_code = p_region_code
1153: AND ATTRIBUTE1 IN ('DIMENSION LEVEL',
1154: 'DIM LEVEL SINGLE VALUE',
1155: 'DIMENSION VALUE',

Line 1865: FROM AK_REGION_ITEMS A

1861: BEGIN
1862:
1863: SELECT NVL(MAX(A.DISPLAY_SEQUENCE), 0)
1864: INTO l_max_seq_num
1865: FROM AK_REGION_ITEMS A
1866: WHERE A.REGION_CODE = p_Region_Code;
1867:
1868: return l_max_seq_num;
1869:

Line 1889: FROM ak_region_items a

1885: x_msg_count NUMBER;
1886:
1887: CURSOR c_dim(p_region_code varchar2) IS
1888: SELECT DISTINCT a.attribute2
1889: FROM ak_region_items a
1890: WHERE a.region_code = Get_Param_Portlet_By_Region(p_region_code)
1891: AND a.attribute2 like '%+%'
1892: AND a.attribute2 NOT LIKE 'TIME_COMPARISON_TYPE%'
1893: AND a.attribute1 <> C_COMP_TO_DIM_LEVEL

Line 1896: FROM ak_region_items a

1892: AND a.attribute2 NOT LIKE 'TIME_COMPARISON_TYPE%'
1893: AND a.attribute1 <> C_COMP_TO_DIM_LEVEL
1894: UNION
1895: SELECT DISTINCT a.attribute2
1896: FROM ak_region_items a
1897: WHERE a.region_code = p_region_code
1898: AND a.attribute2 like '%+%'
1899: AND a.attribute2 NOT LIKE 'TIME_COMPARISON_TYPE%'
1900: AND a.attribute1 <> C_COMP_TO_DIM_LEVEL;

Line 2842: FROM AK_REGION_ITEMS A

2838: BEGIN
2839: -- when there is no matching, return -1000 to inform the caller
2840: SELECT A.Display_Sequence
2841: INTO l_Sequence_Id
2842: FROM AK_REGION_ITEMS A
2843: WHERE A.REGION_APPLICATION_ID = p_Region_Application_Id
2844: AND A.REGION_CODE = p_Region_Code
2845: AND A.ATTRIBUTE_APPLICATION_ID = p_Attribute_Application_Id
2846: AND A.ATTRIBUTE_CODE = p_Attribute_Code;

Line 3235: FROM AK_REGION_ITEMS

3231: l_Count := 0;
3232:
3233: SELECT COUNT(1)
3234: INTO l_Count
3235: FROM AK_REGION_ITEMS
3236: WHERE REGION_CODE = p_Region_Code
3237: AND ( (ATTRIBUTE1 = 'DIMENSION LEVEL') OR
3238: (ATTRIBUTE1 = 'DIM LEVEL SINGLE VALUE') OR
3239: (ATTRIBUTE1 = 'DIMENSION VALUE') OR

Line 3471: FROM AK_REGION_ITEMS

3467:
3468: l_Count := 0;
3469:
3470: SELECT COUNT(1) INTO l_Count
3471: FROM AK_REGION_ITEMS
3472: WHERE Attribute_Code = p_Short_Name;
3473: --AND Attribute_Application_Id = 271;
3474:
3475: IF (l_Count = 0) THEN

Line 3565: FROM AK_REGION_ITEMS

3561: l_temp2 := REPLACE(l_appended , ' ', '_');
3562: l_Final_String := l_temp2 || l_Append_String;
3563:
3564: SELECT COUNT(1) INTO l_exist_cnt
3565: FROM AK_REGION_ITEMS
3566: WHERE REGION_CODE = p_Region_Code
3567: AND ATTRIBUTE_CODE = l_final_string;
3568: END LOOP;
3569: ELSE

Line 3676: PROCEDURE Create_Addl_Ak_Region_Items(

3672: /*
3673: The API creates a All additional Region Items for the specified
3674: AK Region
3675: */
3676: PROCEDURE Create_Addl_Ak_Region_Items(
3677: p_commit IN VARCHAR2 := FND_API.G_FALSE
3678: , p_Region_Code IN VARCHAR2
3679: , p_Region_Application_Id IN NUMBER
3680: , p_Display_Sequence IN NUMBER

Line 4026: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';

4022: END IF;
4023:
4024: WHEN NO_DATA_FOUND THEN
4025: IF (x_msg_data IS NOT NULL) THEN
4026: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4027: ELSE
4028: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4029: END IF;
4030: WHEN OTHERS THEN

Line 4028: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';

4024: WHEN NO_DATA_FOUND THEN
4025: IF (x_msg_data IS NOT NULL) THEN
4026: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4027: ELSE
4028: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4029: END IF;
4030: WHEN OTHERS THEN
4031: IF (x_msg_data IS NOT NULL) THEN
4032: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';

Line 4032: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';

4028: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4029: END IF;
4030: WHEN OTHERS THEN
4031: IF (x_msg_data IS NOT NULL) THEN
4032: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4033: ELSE
4034: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4035: END IF;
4036: END Create_Addl_Ak_Region_Items;

Line 4034: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';

4030: WHEN OTHERS THEN
4031: IF (x_msg_data IS NOT NULL) THEN
4032: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4033: ELSE
4034: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4035: END IF;
4036: END Create_Addl_Ak_Region_Items;
4037:
4038:

Line 4036: END Create_Addl_Ak_Region_Items;

4032: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4033: ELSE
4034: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4035: END IF;
4036: END Create_Addl_Ak_Region_Items;
4037:
4038:
4039: PROCEDURE Delete_Misc_Region_Items(
4040: p_commit VARCHAR2 := FND_API.G_FALSE,

Line 4054: FROM AK_REGION_ITEMS

4050: l_index NUMBER;
4051:
4052: CURSOR c_Attrs IS
4053: SELECT ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID
4054: FROM AK_REGION_ITEMS
4055: WHERE REGION_CODE = p_Region_Code;
4056: BEGIN
4057: l_index := 1;
4058:

Line 4186: PROCEDURE Update_Addl_Ak_Region_Items(

4182: END Update_Sim_Generic_Region_Item;
4183:
4184:
4185:
4186: PROCEDURE Update_Addl_Ak_Region_Items(
4187: p_commit IN VARCHAR2 := FND_API.G_FALSE
4188: , p_Region_Code IN VARCHAR2
4189: , p_Region_Application_Id IN NUMBER
4190: , p_Display_Format IN VARCHAR2

Line 4208: FROM AK_REGION_ITEMS

4204: l_Base_Column NUMBER;
4205:
4206: CURSOR c_Upd_Change IS
4207: SELECT ATTRIBUTE_CODE
4208: FROM AK_REGION_ITEMS
4209: WHERE REGION_CODE = p_Region_Code
4210: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_CHANGE_ATTRIBURE_TYPE;
4211:
4212: CURSOR c_Upd_CompareTo IS

Line 4214: FROM AK_REGION_ITEMS

4210: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_CHANGE_ATTRIBURE_TYPE;
4211:
4212: CURSOR c_Upd_CompareTo IS
4213: SELECT ATTRIBUTE_CODE
4214: FROM AK_REGION_ITEMS
4215: WHERE REGION_CODE = p_Region_Code
4216: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_COMPARE_ATTRIBURE_TYPE;
4217:
4218: CURSOR c_Upd_GT_Actual IS

Line 4220: FROM AK_REGION_ITEMS

4216: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_COMPARE_ATTRIBURE_TYPE;
4217:
4218: CURSOR c_Upd_GT_Actual IS
4219: SELECT ATTRIBUTE_CODE
4220: FROM AK_REGION_ITEMS
4221: WHERE REGION_CODE = p_Region_Code
4222: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_GRAND_TOTAL_ATTRIBURE_TYPE
4223: AND ATTRIBUTE3 = p_Measure_Short_Name;
4224:

Line 4227: FROM AK_REGION_ITEMS

4223: AND ATTRIBUTE3 = p_Measure_Short_Name;
4224:
4225: CURSOR c_Upd_GT_Compare IS
4226: SELECT ATTRIBUTE_CODE
4227: FROM AK_REGION_ITEMS
4228: WHERE REGION_CODE = p_Region_Code
4229: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_GRAND_TOTAL_ATTRIBURE_TYPE
4230: AND ATTRIBUTE3 = l_Compare_Column;
4231:

Line 4385: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';

4381: END IF;
4382:
4383: WHEN NO_DATA_FOUND THEN
4384: IF (x_msg_data IS NOT NULL) THEN
4385: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4386: ELSE
4387: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4388: END IF;
4389: WHEN OTHERS THEN

Line 4387: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';

4383: WHEN NO_DATA_FOUND THEN
4384: IF (x_msg_data IS NOT NULL) THEN
4385: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4386: ELSE
4387: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4388: END IF;
4389: WHEN OTHERS THEN
4390: IF (x_msg_data IS NOT NULL) THEN
4391: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';

Line 4391: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';

4387: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4388: END IF;
4389: WHEN OTHERS THEN
4390: IF (x_msg_data IS NOT NULL) THEN
4391: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4392: ELSE
4393: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4394: END IF;
4395: END Update_Addl_Ak_Region_Items;

Line 4393: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';

4389: WHEN OTHERS THEN
4390: IF (x_msg_data IS NOT NULL) THEN
4391: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4392: ELSE
4393: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4394: END IF;
4395: END Update_Addl_Ak_Region_Items;
4396:
4397:

Line 4395: END Update_Addl_Ak_Region_Items;

4391: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4392: ELSE
4393: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4394: END IF;
4395: END Update_Addl_Ak_Region_Items;
4396:
4397:
4398: FUNCTION Get_Measure_Group_Id (
4399: p_Kpi_Portlet_Function_Name IN VARCHAR2,

Line 4722: -- Passed p_measure_name instead of Page Name for Measure Long Label AK_REGION_ITEMS_VL

4718: l_Max_Seq_Number := Find_Max_Seq_Of_Region_Item(l_Region_Code);
4719: l_Max_Seq_Number := l_Max_Seq_Number + 10;
4720:
4721:
4722: -- Passed p_measure_name instead of Page Name for Measure Long Label AK_REGION_ITEMS_VL
4723: -- for Bug#3802192
4724: -- Create Compare TO and Change Region Items
4725: Create_Addl_Ak_Region_Items(
4726: p_commit => p_Commit

Line 4725: Create_Addl_Ak_Region_Items(

4721:
4722: -- Passed p_measure_name instead of Page Name for Measure Long Label AK_REGION_ITEMS_VL
4723: -- for Bug#3802192
4724: -- Create Compare TO and Change Region Items
4725: Create_Addl_Ak_Region_Items(
4726: p_commit => p_Commit
4727: , p_Region_Code => l_Region_Code
4728: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4729: , p_Display_Sequence => l_Max_Seq_Number

Line 4934: l_attribute_code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;

4930: l_Returned_Kpi_Id NUMBER;
4931: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4932: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4933: l_Count1 NUMBER;
4934: l_attribute_code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
4935: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4936: l_Compare_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
4937: l_as_of_date VARCHAR2(1);
4938:

Line 4936: l_Compare_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;

4932: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4933: l_Count1 NUMBER;
4934: l_attribute_code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
4935: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4936: l_Compare_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
4937: l_as_of_date VARCHAR2(1);
4938:
4939: l_obj_type NUMBER;
4940:

Line 6529: FROM AK_REGION_ITEMS

6525: l_Region_Code VARCHAR2(30);
6526:
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

Line 6565: FROM AK_REGION_ITEMS

6561: l_Count := 0;
6562:
6563: SELECT COUNT(1)
6564: INTO l_Count
6565: FROM AK_REGION_ITEMS
6566: WHERE REGION_CODE = p_Region_Code
6567: AND ATTRIBUTE_CODE = BSC_BIS_KPI_CRUD_PUB.C_AS_OF_DATE;
6568:
6569: IF (l_Count = 0) THEN

Line 6753: FROM AK_REGION_ITEMS RI,

6749: AND B.SHORT_NAME = l_Measure_Short_Name;
6750:
6751: CURSOR c_PMV_Report_List IS
6752: SELECT DISTINCT R.NAME NAME
6753: FROM AK_REGION_ITEMS RI,
6754: AK_REGIONS_VL R
6755: WHERE RI.ATTRIBUTE1 IN ('MEASURE', 'MEASURE_NOTARGET')
6756: AND RI.ATTRIBUTE2 = l_Measure_Short_Name
6757: AND RI.REGION_CODE = R.REGION_CODE;

Line 7680: FROM ak_region_items AK

7676: BEGIN
7677:
7678: SELECT COUNT(1)
7679: INTO l_count
7680: FROM ak_region_items AK
7681: WHERE AK.region_code = p_param_portlet_region_code
7682: AND ATTRIBUTE1 IN ('DIMENSION LEVEL',
7683: 'DIM LEVEL SINGLE VALUE',
7684: 'DIMENSION VALUE',

Line 7988: -- 1) Cascaded back to AK Metadata (AK_REGIONS, AK_REGION_ITEMS, FND_FORM_FUNCTIONS_VL

7984:
7985: FND_MSG_PUB.Initialize;
7986: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
7987:
7988: -- 1) Cascaded back to AK Metadata (AK_REGIONS, AK_REGION_ITEMS, FND_FORM_FUNCTIONS_VL
7989: l_report_region_rec.Region_Code := p_Region_Code;
7990: l_report_region_rec.Region_Name := BIS_COMMON_UTILS.G_DEF_CHAR;
7991: l_report_region_rec.Region_Description := BIS_COMMON_UTILS.G_DEF_CHAR;
7992: l_report_region_rec.Region_Application_Id := p_Region_Application_Id;

Line 8228: FROM AK_REGION_ITEMS

8224: , p_Kpi_Id IN VARCHAR2
8225: ) RETURN VARCHAR2 IS
8226: CURSOR cMeasureShortNames IS
8227: SELECT ATTRIBUTE2
8228: FROM AK_REGION_ITEMS
8229: WHERE REGION_CODE = p_Region_Code
8230: AND ATTRIBUTE1 IN ('BUCKET_MEASURE', 'MEASURE', 'MEASURE_NOTARGET', 'SUB MEASURE')
8231: ORDER BY DISPLAY_SEQUENCE;
8232:

Line 9407: , p_region_code IN AK_REGION_ITEMS.region_code%TYPE

9403:
9404: PROCEDURE Delete_Tab_And_TabViews
9405: (
9406: p_commit IN VARCHAR2 := FND_API.G_FALSE
9407: , p_region_code IN AK_REGION_ITEMS.region_code%TYPE
9408: , x_Return_Status OUT NOCOPY VARCHAR2
9409: , x_Msg_Count OUT NOCOPY NUMBER
9410: , x_Msg_Data OUT NOCOPY VARCHAR2
9411: )IS

Line 9505: p_region_code IN AK_REGION_ITEMS.region_code%TYPE

9501: Creator : ashankar 27-May-2005
9502: /************************************************************/
9503: PROCEDURE Get_Measures_From_CustomView
9504: (
9505: p_region_code IN AK_REGION_ITEMS.region_code%TYPE
9506: , p_region_app_id IN AK_REGION_ITEMS.region_application_id%TYPE
9507: , x_has_cust_view OUT NOCOPY VARCHAR2
9508: , x_meas_sht_names OUT NOCOPY VARCHAR2
9509: , x_scorecard_id OUT NOCOPY NUMBER

Line 9506: , p_region_app_id IN AK_REGION_ITEMS.region_application_id%TYPE

9502: /************************************************************/
9503: PROCEDURE Get_Measures_From_CustomView
9504: (
9505: p_region_code IN AK_REGION_ITEMS.region_code%TYPE
9506: , p_region_app_id IN AK_REGION_ITEMS.region_application_id%TYPE
9507: , x_has_cust_view OUT NOCOPY VARCHAR2
9508: , x_meas_sht_names OUT NOCOPY VARCHAR2
9509: , x_scorecard_id OUT NOCOPY NUMBER
9510: , x_tabview_id OUT NOCOPY NUMBER

Line 9545: FROM AK_REGION_ITEMS

9541: x_has_cust_view := FND_API.G_FALSE;
9542:
9543: SELECT COUNT(0)
9544: INTO l_count
9545: FROM AK_REGION_ITEMS
9546: WHERE region_code = p_region_code
9547: AND region_application_id = p_region_app_id;
9548:
9549: IF(l_count > 0) THEN

Line 9781: l_attribute_code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;

9777: FUNCTION Get_Attribute_Code_For_Measure
9778: ( p_Report_Region_Code IN VARCHAR2
9779: ,p_Measure_Short_Name IN VARCHAR2
9780: ) RETURN VARCHAR2 IS
9781: l_attribute_code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
9782: BEGIN
9783: IF (p_Report_Region_Code IS NOT NULL AND p_Measure_Short_Name IS NOT NULL) THEN
9784: SELECT attribute_code
9785: INTO l_attribute_code

Line 9786: FROM ak_region_items

9782: BEGIN
9783: IF (p_Report_Region_Code IS NOT NULL AND p_Measure_Short_Name IS NOT NULL) THEN
9784: SELECT attribute_code
9785: INTO l_attribute_code
9786: FROM ak_region_items
9787: WHERE region_code = p_Report_Region_Code
9788: AND attribute2 = p_Measure_Short_Name;
9789: END IF;
9790: RETURN l_attribute_code;

Line 9812: FROM AK_REGION_ITEMS A

9808: BEGIN
9809: l_Count := 0;
9810:
9811: SELECT COUNT(1) INTO l_Count
9812: FROM AK_REGION_ITEMS A
9813: WHERE A.REGION_CODE = p_Region_Code
9814: AND A.REGION_APPLICATION_ID = p_Region_Application_Id
9815: AND A.ATTRIBUTE1 IN
9816: ('DIMENSION LEVEL',

Line 9852: FROM AK_REGION_ITEMS A

9848: ) RETURN VARCHAR2 IS
9849: CURSOR c_Get_Nested_Region_Items IS
9850: SELECT A.NESTED_REGION_CODE
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

Line 10127: FROM AK_REGION_ITEMS A

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;

Line 10211: FROM AK_REGION_ITEMS_VL AV

10207: , AV.ATTRIBUTE12
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',

Line 10301: l_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;

10297: FUNCTION Get_Compare_Attribute_Code (
10298: p_Region_Code IN VARCHAR2
10299: , p_Measure_Short_Name IN VARCHAR2
10300: ) RETURN VARCHAR2 IS
10301: l_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10302: BEGIN
10303: l_Attribute_Code := NULL;
10304:
10305: SELECT R.ATTRIBUTE_CODE INTO l_Attribute_Code

Line 10306: FROM AK_REGION_ITEMS R

10302: BEGIN
10303: l_Attribute_Code := NULL;
10304:
10305: SELECT R.ATTRIBUTE_CODE INTO l_Attribute_Code
10306: FROM AK_REGION_ITEMS R
10307: WHERE R.ATTRIBUTE1 = C_COMPARE_ATTRIBURE_TYPE
10308: AND R.ATTRIBUTE2 = Get_Attribute_Code_For_Measure(p_Region_Code, p_Measure_Short_Name)
10309: AND R.REGION_CODE = p_Region_Code;
10310:

Line 10622: l_Measure_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;

10618: , x_Msg_Data OUT NOCOPY VARCHAR
10619: ) IS
10620:
10621: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
10622: l_Measure_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10623: l_Compare_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10624:
10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
10626: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

Line 10623: l_Compare_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;

10619: ) IS
10620:
10621: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
10622: l_Measure_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10623: l_Compare_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10624:
10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
10626: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
10627: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;

Line 10635: FROM AK_REGION_ITEMS AK

10631:
10632: CURSOR cMeasureShortNames IS
10633: SELECT AK.ATTRIBUTE_CODE
10634: , AK.ATTRIBUTE2
10635: FROM AK_REGION_ITEMS AK
10636: WHERE AK.REGION_CODE = p_Region_Code
10637: AND AK.REGION_APPLICATION_ID = p_Region_Application_Id
10638: AND AK.ATTRIBUTE1 IN ('BUCKET_MEASURE', 'MEASURE', 'MEASURE_NOTARGET', 'SUB MEASURE')
10639: ORDER BY AK.DISPLAY_SEQUENCE;

Line 11588: l_attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE;

11584: ,x_non_time_dim_dimObjs OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
11585: ,x_non_time_counter OUT NOCOPY NUMBER
11586: ) IS
11587:
11588: l_attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE;
11589: l_displayseq AK_REGION_ITEMS_VL.display_sequence%TYPE;
11590: l_dim VARCHAR2(1000);
11591:
11592: CURSOR c_dim_dimObj IS

Line 11589: l_displayseq AK_REGION_ITEMS_VL.display_sequence%TYPE;

11585: ,x_non_time_counter OUT NOCOPY NUMBER
11586: ) IS
11587:
11588: l_attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE;
11589: l_displayseq AK_REGION_ITEMS_VL.display_sequence%TYPE;
11590: l_dim VARCHAR2(1000);
11591:
11592: CURSOR c_dim_dimObj IS
11593: SELECT DISTINCT a.attribute2, a.display_sequence

Line 11594: FROM ak_region_items a

11590: l_dim VARCHAR2(1000);
11591:
11592: CURSOR c_dim_dimObj IS
11593: SELECT DISTINCT a.attribute2, a.display_sequence
11594: FROM ak_region_items a
11595: WHERE a.region_code = p_region_code
11596: AND ATTRIBUTE1 IN ('DIMENSION LEVEL',
11597: 'DIM LEVEL SINGLE VALUE',
11598: 'DIMENSION VALUE',