53: p_api_call varchar2
54: );
55:
56: procedure Table_Generator(
57: p_commit IN VARCHAR2 := FND_API.G_TRUE
58: ,p_kpi_id number
59: ,p_meas_short_name varchar2
60: ,p_dim_level_short_name varchar2
61: );
60: ,p_dim_level_short_name varchar2
61: );
62:
63: procedure Add_Analysis_Option(
64: p_commit IN VARCHAR2 := FND_API.G_TRUE
65: ,p_option_name IN VARCHAR2
66: ,p_option_description IN VARCHAR2
67: ,p_meas_short_name IN VARCHAR2
68: ,p_dim_level_short_names IN VARCHAR2
73: ,x_msg_data OUT NOCOPY varchar2
74: );
75:
76: procedure Create_Kpi_Group(
77: p_commit IN VARCHAR2 := FND_API.G_TRUE
78: ,p_tab_id IN number
79: ,p_kpi_group_id IN number
80: ,x_return_status OUT NOCOPY varchar2
81: ,x_msg_count OUT NOCOPY number
84: ,p_kpi_group_help IN varchar2 DEFAULT null
85: );
86:
87: procedure Create_Kpi_Group(
88: p_commit IN VARCHAR2 := FND_API.G_FALSE
89: ,p_tab_id IN NUMBER -- It needs to pass NULL or -1
90: ,p_kpi_group_id IN NUMBER
91: ,p_kpi_group_name IN VARCHAR2
92: ,p_kpi_group_help IN VARCHAR2
97: ,x_msg_data OUT NOCOPY VARCHAR2
98: );
99:
100: procedure Update_Kpi_Group(
101: p_commit IN VARCHAR2 := FND_API.G_TRUE
102: ,p_kpi_group_id IN number
103: ,p_kpi_group_name IN varchar2
104: ,x_return_status OUT NOCOPY varchar2
105: ,x_msg_count OUT NOCOPY number
107: ,p_kpi_group_help IN varchar2 DEFAULT null
108: );
109:
110: procedure Create_Kpi(
111: p_commit IN VARCHAR2 := FND_API.G_TRUE
112: ,p_group_id IN number
113: ,p_responsibility_id IN number
114: ,x_return_status OUT NOCOPY varchar2
115: ,x_msg_count OUT NOCOPY number
118: ,p_kpi_help IN varchar2 DEFAULT null
119: );
120:
121: procedure Create_Kpi(
122: p_commit IN VARCHAR2 := FND_API.G_FALSE
123: ,p_group_id IN NUMBER
124: ,p_responsibility_id IN NUMBER
125: ,p_kpi_name IN VARCHAR2
126: ,p_kpi_help IN VARCHAR2
132: ,x_msg_data OUT NOCOPY VARCHAR2
133: );
134:
135: procedure Update_Kpi(
136: p_commit IN VARCHAR2 := FND_API.G_TRUE
137: ,p_kpi_id IN number
138: ,x_return_status OUT NOCOPY varchar2
139: ,x_msg_count OUT NOCOPY number
140: ,x_msg_data OUT NOCOPY varchar2
142: ,p_kpi_help IN varchar2 DEFAULT null
143: );
144:
145: procedure Create_Tab(
146: p_commit IN VARCHAR2 := FND_API.G_TRUE
147: ,p_responsibility_id IN number
148: ,x_return_status OUT NOCOPY varchar2
149: ,x_msg_count OUT NOCOPY number
150: ,x_msg_data OUT NOCOPY varchar2
152: ,p_tab_help IN varchar2 := NULL
153: );
154:
155: PROCEDURE Create_Tab
156: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
157: , p_responsibility_id IN NUMBER
158: , p_parent_tab_id IN NUMBER
159: , p_owner_id IN NUMBER
160: , p_Short_Name IN VARCHAR2 := NULL
167: , p_tab_info IN VARCHAR2 := NULL
168: );
169:
170: procedure Update_Tab(
171: p_commit IN VARCHAR2 := FND_API.G_TRUE
172: ,p_tab_id IN number
173: ,p_tab_name IN varchar2
174: ,x_return_status OUT NOCOPY varchar2
175: ,x_msg_count OUT NOCOPY number
177: ,p_tab_help IN varchar2 DEFAULT null
178: );
179:
180: procedure Update_Tab(
181: p_commit IN VARCHAR2 := FND_API.G_TRUE
182: ,p_tab_id IN number
183: ,p_owner_id IN number
184: ,p_tab_name IN varchar2
185: ,x_return_status OUT NOCOPY varchar2
191:
192: );
193:
194: procedure Update_Analysis_Option(
195: p_commit IN VARCHAR2 := FND_API.G_TRUE
196: ,p_kpi_id IN number
197: ,p_option_group_id IN number
198: ,p_option_id IN number
199: ,p_option_name IN varchar2
203: ,p_option_help IN varchar2 DEFAULT null
204: );
205:
206: procedure Delete_Analysis_Option(
207: p_commit IN VARCHAR2 := FND_API.G_TRUE
208: ,p_kpi_id IN number
209: ,p_option_group_id IN number
210: ,p_option_id IN number
211: ,x_return_status OUT NOCOPY varchar2
213: ,x_msg_data OUT NOCOPY varchar2
214: );
215:
216: procedure Delete_Kpi(
217: p_commit IN VARCHAR2 := FND_API.G_TRUE
218: ,p_kpi_id IN number
219: ,x_return_status OUT NOCOPY varchar2
220: ,x_msg_count OUT NOCOPY number
221: ,x_msg_data OUT NOCOPY varchar2
221: ,x_msg_data OUT NOCOPY varchar2
222: );
223:
224: procedure Delete_Kpi_Group(
225: p_commit IN VARCHAR2 := FND_API.G_TRUE
226: ,p_kpi_group_id IN number
227: ,p_tab_id IN number
228: ,x_return_status OUT NOCOPY varchar2
229: ,x_msg_count OUT NOCOPY number
230: ,x_msg_data OUT NOCOPY varchar2
231: );
232:
233: procedure Delete_Tab(
234: p_commit IN VARCHAR2 := FND_API.G_TRUE
235: ,p_tab_id IN number
236: ,x_return_status OUT NOCOPY varchar2
237: ,x_msg_count OUT NOCOPY number
238: ,x_msg_data OUT NOCOPY varchar2
238: ,x_msg_data OUT NOCOPY varchar2
239: );
240:
241: procedure Assign_KPI(
242: p_commit IN VARCHAR2 := FND_API.G_FALSE
243: ,p_kpi_id IN number
244: ,p_tab_id IN number
245: ,x_return_status IN OUT NOCOPY varchar2
246: ,x_msg_count IN OUT NOCOPY number
248: ,p_time_stamp IN varchar2 := NULL
249: );
250:
251: procedure Unassign_KPI(
252: p_commit IN VARCHAR2 := FND_API.G_TRUE
253: ,p_kpi_id IN number
254: ,p_tab_id IN number
255: ,x_return_status OUT NOCOPY varchar2
256: ,x_msg_count OUT NOCOPY number
263: ,p_tab_id IN number
264: ) return varchar2;
265:
266: procedure Assign_KPI_Group(
267: p_commit IN VARCHAR2 := FND_API.G_TRUE
268: ,p_kpi_Group_id IN number
269: ,p_tab_id IN number
270: ,x_return_status OUT NOCOPY varchar2
271: ,x_msg_count OUT NOCOPY number
280: ,p_grandparent_option_id IN number
281: ,x_return_status OUT NOCOPY varchar2
282: ,x_msg_count OUT NOCOPY number
283: ,x_msg_data OUT NOCOPY varchar2
284: ,p_commit IN varchar2 := FND_API.G_TRUE
285: ,p_time_stamp_to_check IN varchar2 := null
286: );
287:
288: procedure Unassign_Analysis_Option(
293: ,p_grandparent_Option_id IN number
294: ,x_return_status OUT NOCOPY varchar2
295: ,x_msg_count OUT NOCOPY number
296: ,x_msg_data OUT NOCOPY varchar2
297: ,p_commit IN varchar2 := FND_API.G_TRUE
298: ,p_time_stamp_to_check IN varchar2 := null
299: );
300:
301: function Is_Analysis_Option_Selected(
314: ,p_grandparent_Option_id IN number
315: ) return varchar2;
316:
317: procedure Populate_Option_Dependency_Rec(
318: p_commit IN VARCHAR2 := FND_API.G_TRUE
319: ,p_kpi_id IN number
320: ,p_analysis_group_id IN number
321: ,p_option_id IN number
322: ,p_parent_option_id IN number
330: /*********************************************************************************
331: -- Procedures to Handle Relationships between Dimension Levels
332: **********************************************************************************/
333: procedure Change_Error_Msg(
334: p_commit IN VARCHAR2 := FND_API.G_TRUE
335: ,p_msg_name IN varchar2 DEFAULT null
336: ,p_new_msg_name IN varchar2 DEFAULT null
337: ,p_token1 IN varchar2 DEFAULT null
338: ,p_token1_value IN varchar2 DEFAULT null
346:
347: );
348:
349: PROCEDURE Import_Dim_Level(
350: p_commit IN VARCHAR2 := FND_API.G_TRUE
351: ,p_Short_Name IN varchar2
352: ,x_return_status OUT NOCOPY varchar2
353: ,x_msg_count OUT NOCOPY number
354: ,x_msg_data OUT NOCOPY varchar2
354: ,x_msg_data OUT NOCOPY varchar2
355: );
356:
357: PROCEDURE Update_RelationShips(
358: p_commit IN VARCHAR2 := FND_API.G_TRUE
359: ,p_Dim_Level_Id IN number
360: ,p_Short_Name IN varchar2
361: ,p_Parents IN varchar2
362: ,x_return_status OUT NOCOPY varchar2
370: x_separator IN VARCHAR2
371: ) RETURN VARCHAR2;
372:
373: procedure Create_PMF_Relationship (
374: p_commit IN varchar := FND_API.G_FALSE
375: ,p_SHORT_NAME IN VARCHAR2
376: ,p_PARENT_SHORT_NAME IN VARCHAR2
377: ,p_RELATION_COL IN VARCHAR2
378: );
377: ,p_RELATION_COL IN VARCHAR2
378: );
379:
380: procedure Order_Tab_Index(
381: p_commit IN VARCHAR2 := FND_API.G_TRUE
382: ,p_tab_ids IN varchar2
383: ,x_return_status OUT NOCOPY varchar2
384: ,x_msg_count OUT NOCOPY number
385: ,x_msg_data OUT NOCOPY varchar2
385: ,x_msg_data OUT NOCOPY varchar2
386: );
387:
388: procedure Update_Tab_Parent(
389: p_commit IN VARCHAR2 := FND_API.G_TRUE
390: ,p_tab_id IN number
391: ,p_parent_tab_id IN number
392: ,x_return_status OUT NOCOPY varchar2
393: ,x_msg_count OUT NOCOPY number
394: ,x_msg_data OUT NOCOPY varchar2
395: );
396:
397: procedure Create_Measure(
398: p_commit IN VARCHAR2 := FND_API.G_TRUE
399: ,p_short_name IN varchar2
400: ,x_return_status OUT NOCOPY varchar2
401: ,x_msg_count OUT NOCOPY number
402: ,x_msg_data OUT NOCOPY varchar2
430: );
431:
432: PROCEDURE Assign_Kpi_Tab
433: (
434: p_commit IN VARCHAR2 := FND_API.G_FALSE
435: , p_tab_id IN NUMBER
436: , p_kpi_ids IN VARCHAR2
437: , x_return_status IN OUT NOCOPY VARCHAR2
438: , x_msg_count IN OUT NOCOPY NUMBER
463:
464: ) RETURN VARCHAR2;
465:
466: procedure Update_Kpi_Periodicities(
467: p_commit IN VARCHAR2 := FND_API.G_FALSE
468: ,p_kpi_id IN NUMBER
469: ,p_calendar_id IN NUMBER
470: ,p_periodicity_ids IN VARCHAR2
471: ,p_Dft_periodicity_id IN NUMBER