[Home] [Help]
PACKAGE: APPS.BIS_DIM_LEVEL_VALUE_PVT
Source
1 PACKAGE BIS_DIM_LEVEL_VALUE_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVDMVS.pls 115.14 2002/12/16 10:25:22 rchandra ship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISVDMVS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Private API for managing dimension level valuesfor the
13 REM | Key Performance Framework.
14 REM |
15 REM | This package should be maintaind by EDW once it gets integrated
16 REM | with BIS.
17 REM |
18 REM | NOTES |
19 REM | 01.23.02 sashaik Modified Is_Current_Time_Period and Is_Previous_Time_Period |
20 REM | for 1740789 |
21 REM | 13-NOV-2002 mahrao Fix for 2665526 |
22 REM | |
23 REM +=======================================================================+
24 */
25 --
26 --
27 PROCEDURE Retrieve_Dim_Level_Values
28 ( p_api_version IN NUMBER
29 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
30 , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
31 , x_return_status OUT NOCOPY VARCHAR2
32 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
33 );
34 --
35 --
36 PROCEDURE Get_Org_Dim_Values
37 ( p_api_version IN NUMBER
38 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
39 , p_Responsibility_Tbl IN BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type
40 , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
41 , x_return_status OUT NOCOPY VARCHAR2
42 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
43 );
44 --
45 --
46 PROCEDURE Get_Org_Dim_Values
47 ( p_api_version IN NUMBER
48 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
49 , p_Responsibility_ID IN NUMBER
50 , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
51 , x_return_status OUT NOCOPY VARCHAR2
52 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
53 );
54 --
55 --
56 PROCEDURE Get_Org_Dim_Values
57 ( p_api_version IN NUMBER
58 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
59 , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
60 , x_return_status OUT NOCOPY VARCHAR2
61 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
62 );
63 --
64 --
65 PROCEDURE Get_Time_Dim_Values
66 ( p_api_version IN NUMBER
67 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
68 , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
69 , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
72 );
73 --
74 --
75 PROCEDURE Get_DimensionX_Values
76 ( p_api_version IN NUMBER
77 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
78 , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81 );
82 --
83 --
84 PROCEDURE Remove_Dup_Dim_Level_Values
85 ( p_api_version IN NUMBER
86 , p_Dim_Level_Value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
87 , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
88 , x_return_status OUT NOCOPY VARCHAR2
89 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
90 );
91 --
92 --
93 PROCEDURE Get_Start_Date
94 ( p_api_version IN NUMBER
95 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
96 , p_start_period IN VARCHAR2
97 , x_start_date OUT NOCOPY DATE
98 , x_return_status OUT NOCOPY VARCHAR2
99 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
100 );
101 --
102 --
103 PROCEDURE Get_End_Date
104 ( p_api_version IN NUMBER
105 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
106 , p_end_period IN VARCHAR2
107 , x_end_date OUT NOCOPY DATE
108 , x_return_status OUT NOCOPY VARCHAR2
109 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
110 );
111 --
112 --
113 PROCEDURE Org_ID_to_Value
114 ( p_api_version IN NUMBER
115 , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
116 , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
117 , x_return_status OUT NOCOPY VARCHAR2
118 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
119 );
120 --
121 --
122 PROCEDURE Org_Value_to_ID
123 ( p_api_version IN NUMBER
124 , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
125 , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
126 , x_return_status OUT NOCOPY VARCHAR2
127 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
128 );
129 --
130 --
131 PROCEDURE Time_ID_to_Value
132 ( p_api_version IN NUMBER
133 , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
134 , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
135 , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
136 , x_return_status OUT NOCOPY VARCHAR2
137 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
138 );
139 --
140 --
141 PROCEDURE Time_Value_to_ID
142 ( p_api_version IN NUMBER
143 , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
144 , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
145 , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
146 , x_return_status OUT NOCOPY VARCHAR2
147 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
148 );
149 --
150 --
151 PROCEDURE DimensionX_ID_to_Value
152 ( p_api_version IN NUMBER
153 , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
154 , p_set_of_books_id IN VARCHAR2 := NULL
155 , x_Dim_Level_Value_Rec IN OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
156 , x_return_status OUT NOCOPY VARCHAR2
157 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
158 );
159 --
160 --
161 PROCEDURE DimensionX_Value_to_ID
162 ( p_api_version IN NUMBER
163 , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
164 , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
165 , x_return_status OUT NOCOPY VARCHAR2
166 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
167 );
168
169 Function Is_Current_Time_Period
170 ( p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
171 , p_Org_Level_ID IN VARCHAR2
172 , p_Org_Level_Short_name IN VARCHAR2
173 , x_current_time_id OUT NOCOPY VARCHAR2
174 ) RETURN BOOLEAN;
175
176
177 Function Is_Previous_Time_Period
178 ( p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
179 , p_Org_Level_ID IN VARCHAR2
180 , p_Org_Level_Short_name IN VARCHAR2
181 , x_Previous_time_id OUT NOCOPY VARCHAR2
182 ) RETURN BOOLEAN;
183
184 --
185 --
186 END BIS_DIM_LEVEL_VALUE_PVT;