1 PACKAGE BIS_DIM_LEVEL_VALUE_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPDMVS.pls 115.7 2003/06/26 15:17:59 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 | BISPDMVS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Public 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 | |
20 REM | 26-JUN-03 RCHANDRA do away with hard coded length for name and |
21 REM | description for bug 2910316 |
22 REM | for dimension and dimension levels |
23 REM +=======================================================================+
24 */
25 --
26 -- Data Types: Records
27 --
28 TYPE Dim_Level_Value_Rec_Type IS RECORD
29 ( Dimension_Level_ID NUMBER
30 , Dimension_Level_Short_Name VARCHAR2(30)
31 , Dimension_Level_Name bis_levels_tl.name%TYPE
32 , Dimension_Level_Value_ID VARCHAR2(250)
33 , Dimension_Level_Value_Name VARCHAR2(250)
34 );
35 --
36 -- Data Types: Tables
37 --
38 TYPE Dim_Level_Value_Tbl_Type IS TABLE of Dim_Level_Value_Rec_Type
39 INDEX BY BINARY_INTEGER;
40 --
41 -- missing values
42 G_MISS_DIM_LEVEL_VALUE_REC Dim_Level_Value_Rec_Type;
43 G_MISS_DIM_LEVEL_VALUE_TBL Dim_Level_Value_Tbl_Type;
44 --
45 --
46 /*
47 Procedure Retrieve_Dim_Level_Values
48 ( p_api_version IN NUMBER
49 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
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 Retrieve_Resp_Dim_Level_Values
57 ( p_api_version IN NUMBER
58 , p_Responsibility_ID IN NUMBER
59 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
60 , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
61 , x_return_status OUT NOCOPY VARCHAR2
62 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
63 );
64 */
65 --
66 --
67 END BIS_DIM_LEVEL_VALUE_PUB;