[Home] [Help]
PACKAGE BODY: APPS.BIS_PMV_BSC_API_PUB
Source
1 PACKAGE BODY BIS_PMV_BSC_API_PUB AS
2 /* $Header: BISPVEWB.pls 115.1 2002/12/03 22:33:51 kiprabha noship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISPVEWB.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Public API for getting information about PMV Reports |
14 REM | |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | Date Developer Comments |
19 REM | 22-AUG-2002 nbarik Creation |
20 REM | |
21 REM | |
22 REM +=======================================================================+
23 */
24
25 -- Global package name
26 --
27 G_PKG_NAME CONSTANT VARCHAR2(30) := 'BIS_PMV_BSC_API_PUB';
28
29 --
30 -- Get all the Dimension+Dimension Level combination in the report
31 -- associated with a Measure, and whether View By applies to those
32 -- Dimension Levels
33 --
34 PROCEDURE Get_DimLevel_Viewby
35 ( p_api_version IN NUMBER DEFAULT NULL
36 , p_Region_Code IN VARCHAR2
37 , p_Measure_Short_Name IN VARCHAR2
38 , x_DimLevel_Viewby_Tbl OUT NOCOPY BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Tbl_Type
39 , x_return_status OUT NOCOPY VARCHAR2
40 , x_msg_count OUT NOCOPY NUMBER
41 , x_msg_data OUT NOCOPY VARCHAR2
42 ) IS
43 BEGIN
44
45 BIS_PMV_BSC_API_PVT.Get_DimLevel_Viewby
46 ( p_api_version => p_api_version
47 , p_Region_Code => p_Region_Code
48 , p_Measure_Short_Name => p_Measure_Short_Name
49 , x_DimLevel_Viewby_Tbl => x_DimLevel_Viewby_Tbl
50 , x_return_status => x_return_status
51 , x_msg_count => x_msg_count
52 , x_msg_data => x_msg_data
53 );
54
55 EXCEPTION
56 WHEN FND_API.G_EXC_ERROR THEN
57 x_return_status := FND_API.G_RET_STS_ERROR ;
58 FND_MSG_PUB.Count_And_Get
59 ( p_count => x_msg_count
60 ,p_data => x_msg_data
61 );
62
63 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
65 FND_MSG_PUB.Count_And_Get
66 ( p_count => x_msg_count
67 ,p_data => x_msg_data
68 );
69
70 WHEN others THEN
71 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
72 FND_MSG_PUB.Count_And_Get
73 ( p_count => x_msg_count
74 ,p_data => x_msg_data
75 );
76
77
78 END Get_DimLevel_Viewby;
79
80 END BIS_PMV_BSC_API_PUB;