DBA Data[Home] [Help]

APPS.BSC_ANALYSIS_OPTION_PUB dependencies on FND_API

Line 93: ,Bsc_Change_Action_Flag VARCHAR2(1) := FND_API.G_TRUE

89: ,Bsc_User_Level2_Default number
90: ,Bsc_Option_Short_Name BSC_KPI_ANALYSIS_OPTIONS_B.SHORT_NAME%TYPE
91: ,Bsc_Kpi_Measure_Id BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
92: ,Bsc_Option_Default_Value BSC_KPI_ANALYSIS_GROUPS.default_value%TYPE
93: ,Bsc_Change_Action_Flag VARCHAR2(1) := FND_API.G_TRUE
94: );
95:
96: TYPE Bsc_Option_Tbl_Type IS TABLE OF Bsc_Option_Rec_Type
97: INDEX BY BINARY_INTEGER;

Line 122: p_commit IN varchar2 -- := FND_API.G_FALSE

118:
119: TYPE Bsc_Anal_Opt_Det_Tbl_Type IS TABLE OF Bsc_Analysis_Option_Rec INDEX BY BINARY_INTEGER;
120:
121: procedure Create_Analysis_Options(
122: p_commit IN varchar2 -- := FND_API.G_FALSE
123: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
124: ,x_return_status OUT NOCOPY varchar2
125: ,x_msg_count OUT NOCOPY number
126: ,x_msg_data OUT NOCOPY varchar2

Line 130: p_commit IN varchar2 -- := FND_API.G_FALSE

126: ,x_msg_data OUT NOCOPY varchar2
127: );
128:
129: procedure Retrieve_Analysis_Options(
130: p_commit IN varchar2 -- := FND_API.G_FALSE
131: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
132: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
133: ,x_return_status OUT NOCOPY varchar2
134: ,x_msg_count OUT NOCOPY number

Line 139: p_commit IN varchar2 -- := FND_API.G_FALSE

135: ,x_msg_data OUT NOCOPY varchar2
136: );
137:
138: procedure Retrieve_Analysis_Options(
139: p_commit IN varchar2 -- := FND_API.G_FALSE
140: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
141: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
142: ,p_data_source IN VARCHAR2
143: ,x_return_status OUT NOCOPY varchar2

Line 149: p_commit IN varchar2 -- := FND_API.G_FALSE

145: ,x_msg_data OUT NOCOPY varchar2
146: );
147:
148: procedure Update_Analysis_Options(
149: p_commit IN varchar2 -- := FND_API.G_FALSE
150: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
151: ,p_data_Source IN VARCHAR2
152: ,x_return_status OUT NOCOPY varchar2
153: ,x_msg_count OUT NOCOPY number

Line 158: p_commit IN varchar2 -- := FND_API.G_FALSE

154: ,x_msg_data OUT NOCOPY varchar2
155: );
156:
157: procedure Update_Analysis_Options(
158: p_commit IN varchar2 -- := FND_API.G_FALSE
159: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
160: ,x_return_status OUT NOCOPY varchar2
161: ,x_msg_count OUT NOCOPY number
162: ,x_msg_data OUT NOCOPY varchar2

Line 166: p_commit IN varchar2 -- := FND_API.G_FALSE

162: ,x_msg_data OUT NOCOPY varchar2
163: );
164:
165: procedure Delete_Analysis_Options(
166: p_commit IN varchar2 -- := FND_API.G_FALSE
167: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
168: ,x_return_status OUT NOCOPY varchar2
169: ,x_msg_count OUT NOCOPY number
170: ,x_msg_data OUT NOCOPY varchar2

Line 174: p_commit IN VARCHAR2 := FND_API.G_FALSE

170: ,x_msg_data OUT NOCOPY varchar2
171: );
172:
173: procedure Create_Analysis_Measures(
174: p_commit IN VARCHAR2 := FND_API.G_FALSE
175: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
176: ,x_return_status OUT NOCOPY varchar2
177: ,x_msg_count OUT NOCOPY number
178: ,x_msg_data OUT NOCOPY varchar2

Line 182: p_commit IN varchar2 -- := FND_API.G_FALSE

178: ,x_msg_data OUT NOCOPY varchar2
179: );
180:
181: procedure Retrieve_Analysis_Measures(
182: p_commit IN varchar2 -- := FND_API.G_FALSE
183: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
184: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
185: ,x_return_status OUT NOCOPY varchar2
186: ,x_msg_count OUT NOCOPY number

Line 191: p_commit IN varchar2 -- := FND_API.G_FALSE

187: ,x_msg_data OUT NOCOPY varchar2
188: );
189:
190: procedure Update_Analysis_Measures(
191: p_commit IN varchar2 -- := FND_API.G_FALSE
192: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
193: ,x_return_status OUT NOCOPY varchar2
194: ,x_msg_count OUT NOCOPY number
195: ,x_msg_data OUT NOCOPY varchar2

Line 199: p_commit IN varchar2 -- := FND_API.G_FALSE

195: ,x_msg_data OUT NOCOPY varchar2
196: );
197:
198: procedure Delete_Analysis_Measures(
199: p_commit IN varchar2 -- := FND_API.G_FALSE
200: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
201: ,x_return_status OUT NOCOPY varchar2
202: ,x_msg_count OUT NOCOPY number
203: ,x_msg_data OUT NOCOPY varchar2

Line 210: ( p_commit IN VARCHAR2:=FND_API.G_FALSE

206: /*********************************************************
207:
208: /***********************************************************/
209: PROCEDURE Delete_Ana_Opt_Mult_Groups
210: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
211: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
212: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
213: , p_max_group_count IN NUMBER
214: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

Line 223: p_commit IN VARCHAR2:=FND_API.G_FALSE

219: );
220:
221: PROCEDURE Synch_Kpi_Anal_Group
222: (
223: p_commit IN VARCHAR2:=FND_API.G_FALSE
224: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
225: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
226: , x_return_status OUT NOCOPY VARCHAR2
227: , x_msg_count OUT NOCOPY NUMBER

Line 255: ( p_commit IN varchar2 -- := FND_API.G_FALSE

251: , x_msg_data OUT NOCOPY VARCHAR2
252: );
253: -----------------------------------------------------------
254: PROCEDURE Create_Data_Series
255: ( p_commit IN varchar2 -- := FND_API.G_FALSE
256: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
257: , x_Anal_Opt_Rec OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
258: , x_return_status OUT NOCOPY VARCHAR2
259: , x_msg_count OUT NOCOPY NUMBER

Line 263: p_commit IN varchar2 -- := FND_API.G_FALSE

259: , x_msg_count OUT NOCOPY NUMBER
260: , x_msg_data OUT NOCOPY VARCHAR2
261: );
262: procedure Delete_Data_Series(
263: p_commit IN varchar2 -- := FND_API.G_FALSE
264: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
265: ,x_return_status OUT NOCOPY varchar2
266: ,x_msg_count OUT NOCOPY number
267: ,x_msg_data OUT NOCOPY varchar2

Line 271: ( p_commit IN varchar2 -- := FND_API.G_FALSE

267: ,x_msg_data OUT NOCOPY varchar2
268: );
269:
270: procedure Update_Data_Series
271: ( p_commit IN varchar2 -- := FND_API.G_FALSE
272: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
273: , x_return_status OUT NOCOPY VARCHAR2
274: , x_msg_count OUT NOCOPY NUMBER
275: , x_msg_data OUT NOCOPY VARCHAR2

Line 279: p_commit IN varchar2 -- FND_API.G_FALSE

275: , x_msg_data OUT NOCOPY VARCHAR2
276: );
277:
278: procedure Rearrange_Data_Series(
279: p_commit IN varchar2 -- FND_API.G_FALSE
280: ,p_Kpi_Id IN number
281: ,p_option_group0 IN number
282: ,p_option_group1 IN number
283: ,p_option_group2 IN number

Line 284: ,p_Measure_Seq IN varchar2 -- FND_API.G_FALSE

280: ,p_Kpi_Id IN number
281: ,p_option_group0 IN number
282: ,p_option_group1 IN number
283: ,p_option_group2 IN number
284: ,p_Measure_Seq IN varchar2 -- FND_API.G_FALSE
285: ,p_add_flag IN varchar2 -- FND_API.G_FALSE
286: ,p_remove_flag IN varchar2
287: ,x_return_status OUT NOCOPY varchar2
288: ,x_msg_count OUT NOCOPY number

Line 285: ,p_add_flag IN varchar2 -- FND_API.G_FALSE

281: ,p_option_group0 IN number
282: ,p_option_group1 IN number
283: ,p_option_group2 IN number
284: ,p_Measure_Seq IN varchar2 -- FND_API.G_FALSE
285: ,p_add_flag IN varchar2 -- FND_API.G_FALSE
286: ,p_remove_flag IN varchar2
287: ,x_return_status OUT NOCOPY varchar2
288: ,x_msg_count OUT NOCOPY number
289: ,x_msg_data OUT NOCOPY varchar2

Line 324: p_commit IN VARCHAR2 := FND_API.G_FALSE

320: , p_Old_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
321: )RETURN BOOLEAN;
322:
323: PROCEDURE Cascade_Deletion_Color_Props (
324: p_commit IN VARCHAR2 := FND_API.G_FALSE
325: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
326: ,x_return_status OUT NOCOPY varchar2
327: ,x_msg_count OUT NOCOPY number
328: ,x_msg_data OUT NOCOPY varchar2