DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on FND_API

Line 57: p_commit IN VARCHAR2 := FND_API.G_TRUE

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: );

Line 64: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 77: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 88: p_commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 101: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 111: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 122: p_commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 136: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 146: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 156: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 171: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 181: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 195: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 207: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 217: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 225: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 234: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 242: p_commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 252: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 267: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 284: ,p_commit IN varchar2 := FND_API.G_TRUE

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(

Line 297: ,p_commit IN varchar2 := FND_API.G_TRUE

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(

Line 318: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 334: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 350: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 358: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 374: p_commit IN varchar := FND_API.G_FALSE

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: );

Line 381: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 389: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 398: p_commit IN VARCHAR2 := FND_API.G_TRUE

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

Line 434: p_commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 467: p_commit IN VARCHAR2 := FND_API.G_FALSE

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