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_PMF_UI_API_PUB dependencies on BSC_PMF_UI_API_PUB

Line 1: package body BSC_PMF_UI_API_PUB as

1: package body BSC_PMF_UI_API_PUB as
2: /* $Header: BSCUIAPB.pls 120.3 2006/02/10 01:31:26 ppandey noship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 33: G_PKG_NAME varchar2(30) := 'BSC_PMF_UI_API_PUB';

29: | 27-FEB-2004 adeulgao fixed bug#3431750 |
30: | 25-OCT-2005 kyadamak Removed literals for Enhancement#4618419 |
31: +======================================================================================+
32: */
33: G_PKG_NAME varchar2(30) := 'BSC_PMF_UI_API_PUB';
34:
35: g_Bsc_Pmf_Ui_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;
36: g_Bsc_Pmf_Dim_Tbl BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;
37: g_Bsc_Dim_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

Line 35: g_Bsc_Pmf_Ui_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;

31: +======================================================================================+
32: */
33: G_PKG_NAME varchar2(30) := 'BSC_PMF_UI_API_PUB';
34:
35: g_Bsc_Pmf_Ui_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;
36: g_Bsc_Pmf_Dim_Tbl BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;
37: g_Bsc_Dim_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
38: g_Bsc_Dim_Group_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
39: g_Bsc_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

Line 36: g_Bsc_Pmf_Dim_Tbl BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;

32: */
33: G_PKG_NAME varchar2(30) := 'BSC_PMF_UI_API_PUB';
34:
35: g_Bsc_Pmf_Ui_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;
36: g_Bsc_Pmf_Dim_Tbl BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;
37: g_Bsc_Dim_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
38: g_Bsc_Dim_Group_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
39: g_Bsc_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
40: g_Bsc_Dimset_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

Line 50: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type

46: g_invalid_level varchar2(50);
47:
48: procedure Bsc_Pmf_Ui_Api(
49: p_commit IN varchar2 := FND_API.G_TRUE
50: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
51: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
52: ,p_Dim_Count IN number
53: ,x_bad_level OUT NOCOPY varchar2
54: ,x_return_status OUT NOCOPY varchar2

Line 51: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type

47:
48: procedure Bsc_Pmf_Ui_Api(
49: p_commit IN varchar2 := FND_API.G_TRUE
50: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
51: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
52: ,p_Dim_Count IN number
53: ,x_bad_level OUT NOCOPY varchar2
54: ,x_return_status OUT NOCOPY varchar2
55: ,x_msg_count OUT NOCOPY number

Line 184: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type

180: ************************************************************************************/
181:
182: procedure Get_Measure_Long_Name(
183: p_commit IN varchar2 := FND_API.G_TRUE
184: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
185: ,x_return_status OUT NOCOPY varchar2
186: ,x_msg_count OUT NOCOPY number
187: ,x_msg_data OUT NOCOPY varchar2
188: ) is

Line 244: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type

240: ************************************************************************************/
241:
242: procedure Get_Dimension_Long_Name(
243: p_commit IN varchar2 := FND_API.G_TRUE
244: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
245: ,x_return_status OUT NOCOPY varchar2
246: ,x_msg_count OUT NOCOPY number
247: ,x_msg_data OUT NOCOPY varchar2
248: ) is

Line 294: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type

290:
291: /*
292: procedure Get_Dimension_Level_Name(
293: p_commit IN varchar2 := FND_API.G_TRUE
294: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
295: ,x_return_status OUT NOCOPY varchar2
296: ,x_msg_count OUT NOCOPY number
297: ,x_msg_data OUT NOCOPY varchar2
298: ) is

Line 338: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type

334: ************************************************************************************/
335:
336: procedure Modify_Passed_Parameters(
337: p_commit IN varchar2 := FND_API.G_TRUE
338: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
339: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
340: ,p_Dim_Count IN number
341: ,x_return_status OUT NOCOPY varchar2
342: ,x_msg_count OUT NOCOPY number

Line 339: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type

335:
336: procedure Modify_Passed_Parameters(
337: p_commit IN varchar2 := FND_API.G_TRUE
338: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
339: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
340: ,p_Dim_Count IN number
341: ,x_return_status OUT NOCOPY varchar2
342: ,x_msg_count OUT NOCOPY number
343: ,x_msg_data OUT NOCOPY varchar2

Line 533: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type

529: ************************************************************************************/
530:
531: procedure Create_Bsc_Dimension(
532: p_commit IN varchar2 := FND_API.G_TRUE
533: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
534: ,p_Dim_Count IN number
535: ,x_return_status OUT NOCOPY varchar2
536: ,x_msg_count OUT NOCOPY number
537: ,x_msg_data OUT NOCOPY varchar2

Line 650: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type

646: /************************************************************************************
647: ************************************************************************************/
648: procedure Update_Bsc_Dataset(
649: p_commit IN VARCHAR2 := FND_API.G_TRUE
650: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
651: ,x_return_status OUT NOCOPY VARCHAR2
652: ,x_msg_count OUT NOCOPY NUMBER
653: ,x_msg_data OUT NOCOPY VARCHAR2
654: ) is

Line 769: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type

765:
766:
767: procedure Create_Bsc_Dataset(
768: p_commit IN varchar2 := FND_API.G_TRUE
769: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
770: ,x_return_status OUT NOCOPY varchar2
771: ,x_msg_count OUT NOCOPY number
772: ,x_msg_data OUT NOCOPY varchar2
773: ) is

Line 843: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type

839: ************************************************************************************/
840:
841: procedure Create_Bsc_Dimension_Set(
842: p_commit IN varchar2 := FND_API.G_TRUE
843: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
844: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
845: ,p_Dim_Count IN number
846: ,x_return_status OUT NOCOPY varchar2
847: ,x_msg_count OUT NOCOPY number

Line 844: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type

840:
841: procedure Create_Bsc_Dimension_Set(
842: p_commit IN varchar2 := FND_API.G_TRUE
843: ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
844: ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
845: ,p_Dim_Count IN number
846: ,x_return_status OUT NOCOPY varchar2
847: ,x_msg_count OUT NOCOPY number
848: ,x_msg_data OUT NOCOPY varchar2

Line 1086: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

1082: ************************************************************************************/
1083:
1084: procedure Import_PMF_Dim_Level(
1085: p_commit IN varchar2 := FND_API.G_TRUE
1086: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
1087: ,x_return_status OUT NOCOPY varchar2
1088: ,x_msg_count OUT NOCOPY number
1089: ,x_msg_data OUT NOCOPY varchar2
1090: ) is

Line 1092: v_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;

1088: ,x_msg_count OUT NOCOPY number
1089: ,x_msg_data OUT NOCOPY varchar2
1090: ) is
1091:
1092: v_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;
1093: v_Bsc_Dim_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1094: v_Bsc_Dim_Group_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1095:
1096:

Line 1214: ,x_Bsc_Pmf_Dim_Rec OUT NOCOPY BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

1210:
1211: procedure Populate_Bsc_Pmf_Dim_Rec(
1212: p_commit IN varchar2 := FND_API.G_TRUE
1213: ,p_Dim_Level_Short_Name IN varchar2
1214: ,x_Bsc_Pmf_Dim_Rec OUT NOCOPY BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
1215: ,x_return_status OUT NOCOPY varchar2
1216: ,x_msg_count OUT NOCOPY number
1217: ,x_msg_data OUT NOCOPY varchar2
1218: ) is

Line 1502: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby');

1498: AND (attribute1 = 'DIMENSION LEVEL' OR attribute1 = 'HIDE PARAMETER' OR attribute1 = 'HIDE VIEW BY DIMENSION')
1499: ORDER BY attribute2, attribute1, region_code;
1500: Begin
1501:
1502: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby');
1503: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - p_Measure_Short_Name = ' || p_Measure_Short_Name);
1504:
1505: -- Check the Region code passed to the API
1506: if p_Region_Code is null then

Line 1503: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - p_Measure_Short_Name = ' || p_Measure_Short_Name);

1499: ORDER BY attribute2, attribute1, region_code;
1500: Begin
1501:
1502: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby');
1503: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - p_Measure_Short_Name = ' || p_Measure_Short_Name);
1504:
1505: -- Check the Region code passed to the API
1506: if p_Region_Code is null then
1507: --If the region_code passed to the API is NULL, then the Measure is not associated with any Report.

Line 1515: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - Measure does not exist ' );

1511: FETCH c_region INTO l_Region_Code;
1512: if c_region%NOTFOUND then
1513: l_Region_Code := null;
1514: -- through and Error : Measure does not exist
1515: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - Measure does not exist ' );
1516: end if;
1517: close c_region;
1518: else
1519: l_Region_Code := p_Region_Code;

Line 1522: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - l_Region_Code = ' || l_Region_Code);

1518: else
1519: l_Region_Code := p_Region_Code;
1520: end if;
1521:
1522: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - l_Region_Code = ' || l_Region_Code);
1523:
1524: -- Check whether the report region contains a Nested Region (DBI Report). -----
1525: OPEN c_nested_region;
1526: FETCH c_nested_region INTO l_nested_region_code;

Line 1531: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - l_nested_region_code = ' || l_nested_region_code);

1527: if c_nested_region%NOTFOUND then
1528: l_nested_region_code := null;
1529: end if;
1530: close c_nested_region;
1531: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - l_nested_region_code = ' || l_nested_region_code);
1532:
1533: -- Check whether the report is 'View By' or 'not View By' -------------------
1534: l_Report_View_By_Flag := 'Y';
1535: OPEN c_Viewby_Report;

Line 1543: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - l_Report_View_By_Flag = ' || l_Report_View_By_Flag);

1539: l_Report_View_By_Flag := 'N';
1540: end if;
1541: end if;
1542: close c_Viewby_Report;
1543: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - l_Report_View_By_Flag = ' || l_Report_View_By_Flag);
1544:
1545: -- Get the Dimension Level Info from the main Region -------------------------
1546: -- When not exits a Nested Region
1547:

Line 1550: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - NESTED REGION NOT EXISTS ');

1546: -- When not exits a Nested Region
1547:
1548: if l_nested_region_code is null then
1549:
1550: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - NESTED REGION NOT EXISTS ');
1551:
1552: l_Dimlevel_Viewby_Rec.Dim_DimLevel := NOT_VALID_DIMENSION;
1553: l_index := 1;
1554:

Line 1596: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - NESTED REGION EXISTS ');

1592:
1593: else -- Get the Dimension Level Info from the main Region and Nested Region -----
1594: -- When exits a Nested Region
1595:
1596: --DBMS_OUTPUT.PUT_LINE('--- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby - NESTED REGION EXISTS ');
1597:
1598: l_Dimlevel_Viewby_Rec.Dim_DimLevel := NOT_VALID_DIMENSION;
1599: l_index := 1;
1600: OPEN c_dim_levels1;

Line 1659: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby');

1655: end if;
1656:
1657: x_DimLevel_Viewby_Tbl := l_DimLevel_Viewby_Tbl;
1658:
1659: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby');
1660:
1661: EXCEPTION
1662: WHEN FND_API.G_EXC_ERROR THEN
1663: rollback;

Line 1695: end BSC_PMF_UI_API_PUB;

1691: **********************************************************************************/
1692:
1693:
1694:
1695: end BSC_PMF_UI_API_PUB;