1 PACKAGE BIS_PMF_DATA_SOURCE_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPDSCS.pls 115.16 2003/02/21 19:18:50 mdamle 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 | BISPDSCS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Public API for the Data Source Connector |
13 REM | |
14 REM | NOTES |
15 REM | |
16 REM | HISTORY |
17 REM | APR-2000 irchen Creation |
18 REM | 30-JAN-03 sugopal FND_API.G_MISS_xxx should not be used in |
19 REM | initialization or declaration (bug#2774644) |
20 REM | 30-JAN-03 mdamle SONAR Conversion to Java (APIs called from Java) |
21 REM +=======================================================================+
22 */
23 --
24 -- Constants
25 --
26
27
28 --
29 -- Procedures
30 --
31 Procedure Retrieve_Target_Level
32 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
33 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
34 , p_all_info IN VARCHAR2 := FND_API.G_TRUE
35 , x_target_level_rec OUT NOCOPY BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
36 );
37
38 Procedure Retrieve_Target
39 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
40 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
41 , p_all_info IN VARCHAR2 := FND_API.G_TRUE
42 , x_target_rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
43 );
44
45 Procedure Retrieve_Target_Owners
46 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
47 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
48 , p_alert_type IN VARCHAR2 := NULL
49 , p_alert_level IN VARCHAR2 := NULL
50 , p_all_info IN VARCHAR2 := FND_API.G_TRUE
51 , x_Target_owners_rec OUT NOCOPY BIS_TARGET_PUB.Target_Owners_Rec_Type
52 );
53
54 Procedure Retrieve_Actual
55 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
56 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
57 , p_all_info IN VARCHAR2 := FND_API.G_TRUE
58 , x_actual_rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
59 );
60
61 Procedure Retrieve_Actual
62 ( p_Measure_ID IN NUMBER := NULL
63 , p_Target_Level_ID IN NUMBER := NULL
64 , p_Plan_ID IN NUMBER := NULL
65 , p_Actual_ID IN NUMBER := NULL
66 , p_Target_ID IN NUMBER := NULL
67 , p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
68 , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
69 , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
70 , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
71 , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
72 , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
73 , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
74 , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
75 , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
76 , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
77 , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
78 , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
79 , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
80 , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81 , x_actual_value OUT NOCOPY NUMBER
82 );
83
84 -- mdamle 01/20/2003 - SONAR Conversion to Java
85 Procedure Retrieve_Target
86 ( p_measure_id IN NUMBER := NULL
87 , p_target_level_id IN NUMBER
88 , p_plan_id IN NUMBER := NULL
89 , p_dim1_level_value_id IN VARCHAR2 := NULL
90 , p_dim2_level_value_id IN VARCHAR2 := NULL
91 , p_dim3_level_value_id IN VARCHAR2 := NULL
92 , p_dim4_level_value_id IN VARCHAR2 := NULL
93 , p_dim5_level_value_id IN VARCHAR2 := NULL
94 , p_dim6_level_value_id IN VARCHAR2 := NULL
95 , p_dim7_level_value_id IN VARCHAR2 := NULL
96 , x_target_id OUT NOCOPY NUMBER
97 , x_target OUT NOCOPY NUMBER
98 , x_range1_low OUT NOCOPY NUMBER
99 , x_range1_high OUT NOCOPY NUMBER
100 , x_range2_low OUT NOCOPY NUMBER
101 , x_range2_high OUT NOCOPY NUMBER
102 , x_range3_low OUT NOCOPY NUMBER
103 , x_range3_high OUT NOCOPY NUMBER
104 , x_notify_resp1_id OUT NOCOPY NUMBER
105 , x_notify_resp1_short_name OUT NOCOPY VARCHAR2
106 , x_notify_resp1_name OUT NOCOPY VARCHAR2
107 , x_notify_resp2_id OUT NOCOPY NUMBER
108 , x_notify_resp2_short_name OUT NOCOPY VARCHAR2
109 , x_notify_resp2_name OUT NOCOPY VARCHAR2
110 , x_notify_resp3_id OUT NOCOPY NUMBER
111 , x_notify_resp3_short_name OUT NOCOPY VARCHAR2
112 , x_notify_resp3_name OUT NOCOPY VARCHAR2
113 , x_return_status OUT NOCOPY VARCHAR2
114 );
115
116 -- mdamle 01/20/2003 - SONAR Conversion to Java - APIs called from Java
117 PROCEDURE Post_Actual
118 ( p_Target_Level_ID IN NUMBER
119 ,p_Target_Level_Name IN VARCHAR2
120 ,p_Target_Level_Short_Name IN VARCHAR2
121 ,p_Dim1_Level_Value_ID IN VARCHAR2
122 ,p_Dim1_Level_Value_Name IN VARCHAR2
123 ,p_Dim2_Level_Value_ID IN VARCHAR2
124 ,p_Dim2_Level_Value_Name IN VARCHAR2
125 ,p_Dim3_Level_Value_ID IN VARCHAR2
126 ,p_Dim3_Level_Value_Name IN VARCHAR2
127 ,p_Dim4_Level_Value_ID IN VARCHAR2
128 ,p_Dim4_Level_Value_Name IN VARCHAR2
129 ,p_Dim5_Level_Value_ID IN VARCHAR2
130 ,p_Dim5_Level_Value_Name IN VARCHAR2
131 ,p_Dim6_level_Value_id IN VARCHAR2
132 ,p_Dim6_Level_Value_Name IN VARCHAR2
133 ,p_Dim7_Level_Value_ID IN VARCHAR2
134 ,p_Dim7_Level_Value_Name IN VARCHAR2
135 ,p_Actual IN NUMBER
136 ,p_Report_Url IN VARCHAR2
137 ,p_Comparison_actual_value IN NUMBER
138 ,x_return_status OUT NOCOPY VARCHAR2
139 );
140
141 END BIS_PMF_DATA_SOURCE_PUB;