1 PACKAGE BSC_OBJ_ANALYSIS_OPTIONS_PUB AS
2 /* $Header: BSCPOAOS.pls 120.4.12000000.1 2007/07/17 07:44:18 appldev noship $ */
3
4
5 PROCEDURE Create_Analysis_Option_UI(
6 p_commit IN VARCHAR2 := FND_API.G_FALSE
7 ,p_Indicator IN NUMBER
8 ,p_Analysis_Group_Id IN NUMBER := 0
9 ,p_Option_Id IN NUMBER := 0
10 ,p_Parent_Option_Id IN NUMBER := 0
11 ,p_GrandParent_Option_Id IN NUMBER := 0
12 ,p_Dependency_Flag IN NUMBER := 0
13 ,p_DataSet_Id IN NUMBER := -1
14 ,p_DimSet_Id IN NUMBER := 0
15 ,p_Default_Flag IN NUMBER := 0
16 ,p_Option_Name IN VARCHAR2
17 ,p_Option_Help IN VARCHAR2
18 ,p_Change_Dim_Set IN NUMBER := 0
19 ,p_default_calculation IN NUMBER := NULL
20 ,p_time_stamp IN VARCHAR2 := NULL
21 ,x_return_status OUT NOCOPY VARCHAR2
22 ,x_msg_count OUT NOCOPY NUMBER
23 ,x_msg_data OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE Update_Analysis_Option_UI(
27 p_commit IN VARCHAR2 := FND_API.G_FALSE
28 ,p_Indicator IN NUMBER
29 ,p_Analysis_Group_Id IN NUMBER := 0
30 ,p_Option_Id IN NUMBER := 0
31 ,p_Parent_Option_Id IN NUMBER := 0
32 ,p_GrandParent_Option_Id IN NUMBER := 0
33 ,p_Dependency_Flag IN NUMBER := 0
34 ,p_DataSet_Id IN NUMBER := NULL
35 ,p_DimSet_Id IN NUMBER := 0
36 ,p_Default_Flag IN NUMBER := 0
37 ,p_Option_Name IN VARCHAR2
38 ,p_Option_Help IN VARCHAR2
39 ,p_Change_Dim_Set IN NUMBER := 0
40 ,p_default_calculation IN NUMBER := NULL
41 ,p_Create_Flow IN VARCHAR2 := FND_API.G_FALSE
42 ,p_time_stamp IN VARCHAR2 := NULL
43 ,p_olddim_Dataset_map IN BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table := NULL
44 ,x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,x_msg_data OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE Delete_Analysis_Option_UI(
50 p_commit IN VARCHAR2 := FND_API.G_FALSE
51 ,p_Indicator IN NUMBER
52 ,p_Analysis_Group_Id IN NUMBER := 0
53 ,p_Option_Id IN NUMBER := 0
54 ,p_Parent_Option_Id IN NUMBER := 0
55 ,p_GrandParent_Option_Id IN NUMBER := 0
56 ,p_time_stamp IN VARCHAR2 := NULL
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE Val_Delete_Analysis_Option(
63 p_Indicator IN NUMBER
64 ,p_Analysis_Group_Id IN NUMBER := 0
65 ,p_Option_Id IN NUMBER := 0
66 ,p_Parent_Option_Id IN NUMBER := 0
67 ,p_GrandParent_Option_Id IN NUMBER := 0
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 Get_Next_Option_Id (
74 p_Indicator IN NUMBER
75 ,p_Analysis_Group_Id IN NUMBER
76 ,p_Parent_Option_Id IN NUMBER
77 ,p_Grandparent_Option_Id IN NUMBER
78 ,x_Option_Id OUT NOCOPY NUMBER
79 );
80
81 FUNCTION Get_DataSetId_For_AO_Comb (
82 p_Indicator IN NUMBER
83 ,p_Analayis_Group_Id IN NUMBER
84 ,p_Option_Id IN NUMBER
85 ,p_Parent_Option_Id IN NUMBER
86 ,p_GrandParent_Option_Id IN NUMBER
87 ) RETURN NUMBER;
88
89 FUNCTION Get_Dependency (
90 p_Indicator IN NUMBER
91 ,p_Analysis_Group_Id IN NUMBER
92 ) RETURN NUMBER;
93
94 FUNCTION Get_Analysis_Option_Default (
95 p_Indicator IN NUMBER
96 ,p_Analysis_Group_Id IN NUMBER
97 ) RETURN NUMBER;
98
99 PROCEDURE Get_Parent_GrandParent_Ids(
100 p_Indicator IN NUMBER
101 ,p_Analysis_Group_Id IN NUMBER
102 ,p_Parent_Id IN NUMBER
103 ,p_GrandParent_Id IN NUMBER
104 ,p_Independent_Par_Id IN NUMBER := 0
105 ,x_Parent_Id OUT NOCOPY NUMBER
106 ,x_GrandParent_Id OUT NOCOPY NUMBER
107 ,x_Parent_Group_Id OUT NOCOPY NUMBER
108 ,x_GrandParent_Group_Id OUT NOCOPY NUMBER
109 );
110
111 FUNCTION Get_Analysis_Option_Name(
112 p_Indicator NUMBER,
113 p_Analysis_Option0 NUMBER,
114 p_Analysis_Option1 NUMBER,
115 p_Analysis_Option2 NUMBER,
116 p_Group_Id NUMBER
117 ) RETURN VARCHAR2;
118
119 FUNCTION Is_Analayis_Option_Valid(
120 p_Indicator NUMBER,
121 p_Analysis_Option0 NUMBER,
122 p_Analysis_Option1 NUMBER,
123 p_Analysis_Option2 NUMBER,
124 p_Group_Id NUMBER
125 ) RETURN VARCHAR2 ;
126
127 FUNCTION Get_Parent_Id (
128 p_Indicator NUMBER,
129 p_Analysis_GroupId NUMBER,
130 p_Option_Id NUMBER,
131 p_Parent_Id NUMBER
132 )RETURN NUMBER;
133
134 FUNCTION Get_Grand_Parent_Id (
135 p_Indicator NUMBER,
136 p_Analysis_GroupId NUMBER,
137 p_Option_Id NUMBER,
138 p_GrandParent_Id NUMBER
139 )RETURN NUMBER;
140
141 FUNCTION Get_Dim_Set_Id(
142 p_Indicator IN NUMBER
143 ,p_Analysis_Option0 IN NUMBER := 0
144 ,p_Analysis_Option1 IN NUMBER := 0
145 ,p_Analysis_Option2 IN NUMBER := 0
146 ,p_Dim_Set_Group IN NUMBER := 0
147 ) RETURN NUMBER;
148
149 PROCEDURE Check_YTD_Apply(
150 p_commit IN VARCHAR2 := FND_API.G_FALSE
151 ,p_Indicator IN NUMBER
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2
155 );
156
157 FUNCTION Get_Kpi_Property (
158 p_Indicator IN NUMBER
159 ,p_Analayis_Group_Id IN NUMBER
160 ,p_Option_Id IN NUMBER
161 ,p_Parent_Option_Id IN NUMBER
162 ,p_GrandParent_Option_Id IN NUMBER
163 ,p_Property_Name IN VARCHAR2
164 ) RETURN NUMBER;
165
166 END BSC_OBJ_ANALYSIS_OPTIONS_PUB;