[Home] [Help]
PACKAGE: APPS.BSC_PMF_UI_API_PUB
Source
1 package BSC_PMF_UI_API_PUB as
2 /* $Header: BSCUIAPS.pls 120.0 2005/06/01 16:56:43 appldev noship $ */
3
4
5 /* ------- Temporaly Definition for Dimension Levels View By API ------------ */
6 TYPE Dimlevel_Viewby_Rec_Type IS RECORD
7 ( Dim_DimLevel VARCHAR2(150)
8 , Viewby_Applicable VARCHAR2(1)
9 , All_Applicable VARCHAR2(1)
10 );
11
12 TYPE DimLevel_Viewby_Tbl_Type IS TABLE of Dimlevel_Viewby_Rec_Type
13 INDEX BY BINARY_INTEGER;
14 /* --------------------------------------------------------------------------- */
15
16 TYPE Bsc_Pmf_Ui_Rec_Type is RECORD(
17 Kpi_Id number
18 ,Kpi_Group_Id number
19 ,Tab_Id number
20 ,Measure_Short_Name varchar2(30)
21 ,Measure_Long_Name varchar2(255)
22 ,Dimension_Short_Name varchar2(30)
23 ,Dimension_Long_Name varchar2(255)
24 ,Option_Name varchar2(80) -- changed for bug 3165012
25 ,Option_Description varchar2(240)
26 ,Language varchar2(5)
27 ,Source_Language varchar2(5)
28 );
29
30 TYPE Bsc_Pmf_Ui_Tbl_Type IS TABLE OF Bsc_Pmf_Ui_Rec_Type
31 INDEX BY BINARY_INTEGER;
32
33 TYPE Bsc_Pmf_Dim_Rec_Type is RECORD(
34 Dimension_Short_Name varchar2(30)
35 ,Dimension_Long_Name varchar2(255)
36 ,Dimension_Level_Disp_Size number
37 ,Dimension_Level_Short_Name varchar2(30)
38 ,Dimension_Level_Status varchar2(15)
39 ,Dimension_Level_Long_Name varchar2(255)
40 ,Dimension_Level_View_Name varchar2(30)
41 ,Dimension_Level_Pk_Key varchar2(30)
42 ,Dimension_Level_Pk_Key_edw varchar2(30)
43 ,Dimension_Level_Name_Column varchar2(30)
44 ,Dimension_Level_Source varchar2(5)
45 );
46
47 TYPE Bsc_Pmf_Dim_Tbl_Type IS TABLE OF Bsc_Pmf_Dim_Rec_Type
48 INDEX BY BINARY_INTEGER;
49
50 procedure Bsc_Pmf_Ui_Api(
51 p_commit IN varchar2 := FND_API.G_TRUE
52 ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
53 ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
54 ,p_Dim_Count IN number
55 ,x_bad_level OUT NOCOPY varchar2
56 ,x_return_status OUT NOCOPY varchar2
57 ,x_msg_count OUT NOCOPY number
58 ,x_msg_data OUT NOCOPY varchar2
59 );
60
61 procedure Get_Measure_Long_Name(
62 p_commit IN varchar2 := FND_API.G_TRUE
63 ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
64 ,x_return_status OUT NOCOPY varchar2
65 ,x_msg_count OUT NOCOPY number
66 ,x_msg_data OUT NOCOPY varchar2
67 );
68
69 procedure Get_Dimension_Long_Name(
70 p_commit IN varchar2 := FND_API.G_TRUE
71 ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
72 ,x_return_status OUT NOCOPY varchar2
73 ,x_msg_count OUT NOCOPY number
74 ,x_msg_data OUT NOCOPY varchar2
75 );
76
77 /*
78 procedure Get_Dimension_Level_Name(
79 p_commit IN varchar2 := FND_API.G_TRUE
80 ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
81 ,x_return_status OUT NOCOPY varchar2
82 ,x_msg_count OUT NOCOPY number
83 ,x_msg_data OUT NOCOPY varchar2
84 );
85 */
86
87 procedure Modify_Passed_Parameters(
88 p_commit IN varchar2 := FND_API.G_TRUE
89 ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
90 ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
91 ,p_Dim_Count IN number
92 ,x_return_status OUT NOCOPY varchar2
93 ,x_msg_count OUT NOCOPY number
94 ,x_msg_data OUT NOCOPY varchar2
95 );
96
97 procedure Update_Bsc_Dataset(
98 p_commit IN varchar2 := FND_API.G_TRUE
99 ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
100 ,x_return_status OUT NOCOPY varchar2
101 ,x_msg_count OUT NOCOPY number
102 ,x_msg_data OUT NOCOPY varchar2
103 );
104
105
106 procedure Create_Bsc_Dimension(
107 p_commit IN varchar2 := FND_API.G_TRUE
108 ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
109 ,p_Dim_Count IN number
110 ,x_return_status OUT NOCOPY varchar2
111 ,x_msg_count OUT NOCOPY number
112 ,x_msg_data OUT NOCOPY varchar2
113 );
114
115 procedure Create_Bsc_Dataset(
116 p_commit IN varchar2 := FND_API.G_TRUE
117 ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
118 ,x_return_status OUT NOCOPY varchar2
119 ,x_msg_count OUT NOCOPY number
120 ,x_msg_data OUT NOCOPY varchar2
121 );
122
123 procedure Create_Bsc_Dimension_Set(
124 p_commit IN varchar2 := FND_API.G_TRUE
125 ,p_Bsc_Pmf_Ui_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type
126 ,p_Bsc_Pmf_Dim_Tbl IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type
127 ,p_Dim_Count IN number
128 ,x_return_status OUT NOCOPY varchar2
129 ,x_msg_count OUT NOCOPY number
130 ,x_msg_data OUT NOCOPY varchar2
131 );
132
133 procedure Create_Bsc_Analysis_Option(
134 p_commit IN varchar2 := FND_API.G_TRUE
135 ,x_return_status OUT NOCOPY varchar2
136 ,x_msg_count OUT NOCOPY number
137 ,x_msg_data OUT NOCOPY varchar2
138 );
139
140 /*********************************************************************************
141 -- Procedures to Handle Relationships between Dimension Levels
142 **********************************************************************************/
143
144 procedure Import_PMF_Dim_Level(
145 p_commit IN varchar2 := FND_API.G_TRUE
146 ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
147 ,x_return_status OUT NOCOPY varchar2
148 ,x_msg_count OUT NOCOPY number
149 ,x_msg_data OUT NOCOPY varchar2
150 );
151
152 procedure Populate_Bsc_Pmf_Dim_Rec(
153 p_commit IN varchar2 := FND_API.G_TRUE
154 ,p_Dim_Level_Short_Name IN varchar2
155 ,x_Bsc_Pmf_Dim_Rec OUT NOCOPY BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
156 ,x_return_status OUT NOCOPY varchar2
157 ,x_msg_count OUT NOCOPY number
158 ,x_msg_data OUT NOCOPY varchar2
159 );
160
161 FUNCTION get_Dim_Level_View_Name(
162 p_Short_Name IN VARCHAR2
163 ) RETURN VARCHAR2;
164
165 /*********************************************************************************
166 **********************************************************************************/
167
168 PROCEDURE Get_DimLevel_Viewby
169 ( p_api_version IN NUMBER
170 , p_Region_Code IN VARCHAR2
171 , p_Measure_Short_Name IN VARCHAR2
172 , x_DimLevel_Viewby_Tbl OUT NOCOPY DimLevel_Viewby_Tbl_Type /* BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Tbl_Type */
173 , x_return_status OUT NOCOPY VARCHAR2
174 , x_msg_count OUT NOCOPY NUMBER
175 , x_msg_data OUT NOCOPY VARCHAR2
176 );
177
178 /*********************************************************************************
179 **********************************************************************************/
180
181
182 end BSC_PMF_UI_API_PUB;