1 PACKAGE BIS_PMF_UTILITIES_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPPMUS.pls 115.2 99/10/11 15:03:55 porting sh $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISPPMUS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Public API for PMF utilities |
14 REM | |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | 10-AUG-99 surao Creation |
19 REM | |
20 REM +=======================================================================+
21 */
22 --
23 --
24 TYPE Target_Level_Rec_Type IS RECORD
25 ( Description VARCHAR2(2000) := NULL );
26 --
27 TYPE l_target_level_Tbl_Type IS
28 TABLE OF Target_Level_Rec_Type
29 INDEX BY BINARY_INTEGER;
30 --
31 FUNCTION Get_Target_For_Target_Level
32 ( p_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
33 , p_ORG_LEVEL_VALUE IN VARCHAR2
34 , p_TIME_LEVEL_VALUE IN VARCHAR2
35 , p_DIMENSION1_LEVEL_VALUE IN VARCHAR2
36 , p_DIMENSION2_LEVEL_VALUE IN VARCHAR2
37 , p_DIMENSION3_LEVEL_VALUE IN VARCHAR2
38 , p_DIMENSION4_LEVEL_VALUE IN VARCHAR2
39 , p_DIMENSION5_LEVEL_VALUE IN VARCHAR2
40 , p_PLAN_NAME IN VARCHAR2
41 )
42 RETURN NUMBER;
43 --
44 FUNCTION Get_Target_For_Level_ID
45 ( p_MEASURE_SHORT_NAME IN VARCHAR2
46 , p_ORG_LEVEL IN NUMBER
47 , p_TIME_LEVEL IN NUMBER
48 , p_DIMENSION1_LEVEL IN NUMBER
49 , p_DIMENSION2_LEVEL IN NUMBER
50 , p_DIMENSION3_LEVEL IN NUMBER
51 , p_DIMENSION4_LEVEL IN NUMBER
52 , p_DIMENSION5_LEVEL IN NUMBER
53 , p_ORG_LEVEL_VALUE IN VARCHAR2
54 , p_TIME_LEVEL_VALUE IN VARCHAR2
55 , p_DIMENSION1_LEVEL_VALUE IN VARCHAR2
56 , p_DIMENSION2_LEVEL_VALUE IN VARCHAR2
57 , p_DIMENSION3_LEVEL_VALUE IN VARCHAR2
58 , p_DIMENSION4_LEVEL_VALUE IN VARCHAR2
59 , p_DIMENSION5_LEVEL_VALUE IN VARCHAR2
60 , p_PLAN_NAME IN VARCHAR2
61 )
62 RETURN NUMBER;
63 --
64 FUNCTION Get_Target_For_Level
65 ( p_MEASURE_SHORT_NAME IN VARCHAR2
66 , p_ORG_LEVEL IN VARCHAR2
67 , p_TIME_LEVEL IN VARCHAR2
68 , p_DIMENSION1_LEVEL IN VARCHAR2
69 , p_DIMENSION2_LEVEL IN VARCHAR2
70 , p_DIMENSION3_LEVEL IN VARCHAR2
71 , p_DIMENSION4_LEVEL IN VARCHAR2
72 , p_DIMENSION5_LEVEL IN VARCHAR2
73 , p_ORG_LEVEL_VALUE IN VARCHAR2
74 , p_TIME_LEVEL_VALUE IN VARCHAR2
75 , p_DIMENSION1_LEVEL_VALUE IN VARCHAR2
76 , p_DIMENSION2_LEVEL_VALUE IN VARCHAR2
77 , p_DIMENSION3_LEVEL_VALUE IN VARCHAR2
78 , p_DIMENSION4_LEVEL_VALUE IN VARCHAR2
79 , p_DIMENSION5_LEVEL_VALUE IN VARCHAR2
80 , p_PLAN_NAME IN VARCHAR2
81 )
82 RETURN NUMBER;
83 --
84 FUNCTION Get_Target_Value
85 ( p_TARGET_LEVEL_ID IN NUMBER
86 , p_ORG_LEVEL_VALUE IN VARCHAR2
87 , p_TIME_LEVEL_VALUE IN VARCHAR2
88 , p_DIMENSION1_LEVEL_VALUE IN VARCHAR2
89 , p_DIMENSION2_LEVEL_VALUE IN VARCHAR2
90 , p_DIMENSION3_LEVEL_VALUE IN VARCHAR2
91 , p_DIMENSION4_LEVEL_VALUE IN VARCHAR2
92 , p_DIMENSION5_LEVEL_VALUE IN VARCHAR2
93 , p_PLAN_NAME IN VARCHAR2
94 )
95 RETURN NUMBER;
96 --
97 --
98 END BIS_PMF_UTILITIES_PUB;