1 PACKAGE BSC_KPI_SERIES_PUB AS
2 /* $Header: BSCPSERS.pls 120.1.12000000.1 2007/07/17 07:44:21 appldev noship $ */
3
4 TYPE Bsc_Dim_DataSet_Map IS RECORD(
5 dim_set_id NUMBER
6 ,dataset_id NUMBER
7 ,rec_count NUMBER
8 );
9
10 TYPE Bsc_Dim_Dataset_Table IS TABLE OF Bsc_Dim_DataSet_Map;
11
12 PROCEDURE Create_Analysis_Measure_UI(
13 p_commit IN VARCHAR2 := FND_API.G_FALSE
14 ,p_Indicator IN NUMBER
15 ,p_Analysis_Option0 IN NUMBER
16 ,p_Analysis_Option1 IN NUMBER
17 ,p_Analysis_Option2 IN NUMBER
18 ,p_Series_Id IN NUMBER
19 ,p_Axis IN NUMBER := 0
20 ,p_Series_Type IN NUMBER := 0
21 ,p_Bm_Flag IN NUMBER := 0
22 ,p_Budget_Flag IN NUMBER := 0
23 ,p_Default_Flag IN NUMBER := 0
24 ,p_Stack_Series_Id IN NUMBER := NULL
25 ,p_Series_Name IN VARCHAR2
26 ,p_Series_Help IN VARCHAR2
27 ,p_dataset_Id IN NUMBER := -1
28 ,p_Color_Values IN FND_TABLE_OF_NUMBER := NULL
29 ,p_default_calculation IN NUMBER := NULL
30 ,p_time_stamp IN VARCHAR2 := NULL
31 ,x_return_status OUT NOCOPY VARCHAR2
32 ,x_msg_count OUT NOCOPY NUMBER
33 ,x_msg_data OUT NOCOPY VARCHAR2
34 );
35
36 PROCEDURE Update_Analysis_Measure_UI(
37 p_commit IN VARCHAR2 := FND_API.G_FALSE
38 ,p_Indicator IN NUMBER
39 ,p_Analysis_Option0 IN NUMBER
40 ,p_Analysis_Option1 IN NUMBER
41 ,p_Analysis_Option2 IN NUMBER
42 ,p_Series_Id IN NUMBER
43 ,p_Axis IN NUMBER := 0
44 ,p_Series_Type IN NUMBER := 0
45 ,p_Bm_Flag IN NUMBER := 0
46 ,p_Budget_Flag IN NUMBER := 0
47 ,p_Default_Flag IN NUMBER := 0
48 ,p_Stack_Series_Id IN NUMBER := NULL
49 ,p_Series_Name IN VARCHAR2
50 ,p_Series_Help IN VARCHAR2
51 ,p_dataset_Id IN NUMBER := -1
52 ,p_Color_Values IN FND_TABLE_OF_NUMBER := NULL
53 ,p_default_calculation IN NUMBER := NULL
54 ,p_time_stamp IN VARCHAR2 := NULL
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57 ,x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE Delete_Analysis_Measure_UI(
61 p_commit IN VARCHAR2 := FND_API.G_FALSE
62 ,p_Indicator IN NUMBER
63 ,p_Analysis_Option0 IN NUMBER
64 ,p_Analysis_Option1 IN NUMBER
65 ,p_Analysis_Option2 IN NUMBER
66 ,p_Series_Id IN NUMBER
67 ,p_time_stamp IN VARCHAR2 := NULL
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE Populate_Kpi_Series_Colors(
74 p_commit IN VARCHAR2 := FND_API.G_FALSE
75 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
76 ,p_Color_Values IN FND_TABLE_OF_NUMBER
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE Delete_Kpi_Series_Colors(
83 p_commit IN VARCHAR2 := FND_API.G_FALSE
84 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE Check_Color_Props(
91 p_commit IN VARCHAR2 := FND_API.G_FALSE
92 ,p_Indicator IN NUMBER
93 ,p_Analysis_Option0 IN NUMBER
94 ,p_Analysis_Option1 IN NUMBER
95 ,p_Analysis_Option2 IN NUMBER
96 ,p_Series_Id IN NUMBER
97 ,p_Budget_Flag IN NUMBER := 0
98 ,p_Default_Flag IN NUMBER := 0
99 ,p_Dataset_Id IN NUMBER := -1
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE Check_Series_Default_Props(
106 p_commit IN VARCHAR2 := FND_API.G_FALSE
107 ,p_Indicator IN NUMBER
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE Update_Color_Structure_Flags (
114 p_commit IN VARCHAR2 := FND_API.G_FALSE
115 ,p_Indicator IN NUMBER
116 ,p_Action_Flag IN NUMBER := 3
117 ,x_return_status OUT NOCOPY VARCHAR2
118 ,x_msg_count OUT NOCOPY NUMBER
119 ,x_msg_data OUT NOCOPY VARCHAR2
120 );
121
122 PROCEDURE Update_Kpi_Time_Stamp(
123 p_commit IN varchar2 := FND_API.G_FALSE
124 ,p_Indicator IN NUMBER
125 ,x_return_status OUT NOCOPY varchar2
126 ,x_msg_count OUT NOCOPY number
127 ,x_msg_data OUT NOCOPY varchar2
128 );
129
130
131 PROCEDURE Check_Series_Structure_Change (
132 p_commit IN VARCHAR2 := FND_API.G_FALSE
133 ,p_Indicator IN NUMBER
134 ,p_Analysis_Option0 IN NUMBER
135 ,p_Analysis_Option1 IN NUMBER
136 ,p_Analysis_Option2 IN NUMBER
137 ,p_Series_Id IN NUMBER
138 ,p_New_Dataset_Map IN FND_TABLE_OF_NUMBER
139 ,p_Delete_Mode IN NUMBER := 0
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2
143 );
144
145 PROCEDURE Save_Default_Calculation(
146 p_commit IN VARCHAR2 := FND_API.G_FALSE
147 ,p_Indicator IN NUMBER
148 ,p_Analysis_Option0 IN NUMBER
149 ,p_Analysis_Option1 IN NUMBER
150 ,p_Analysis_Option2 IN NUMBER
151 ,p_Series_Id IN NUMBER
152 ,p_default_calculation IN NUMBER := NULL
153 ,p_casacade_shared IN VARCHAR2 := FND_API.G_TRUE
154 ,x_return_status OUT NOCOPY VARCHAR2
155 ,x_msg_count OUT NOCOPY NUMBER
156 ,x_msg_data OUT NOCOPY VARCHAR2
157 );
158
159 END BSC_KPI_SERIES_PUB;