DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on FND_API

Line 88: p_commit IN VARCHAR2 := FND_API.G_FALSE

84:
85: --Wrapper of Create_Measure that takes in p_default_short_name
86: -- 18-OCT-2004 ADRAO, changed signature added p_measure_col_help, Bug#3817894
87: procedure Create_Measure(
88: p_commit IN VARCHAR2 := FND_API.G_FALSE
89: ,x_dataset_id OUT NOCOPY NUMBER
90: ,p_dataset_source IN VARCHAR2
91: ,p_dataset_name IN VARCHAR2
92: ,p_dataset_help IN VARCHAR2 := NULL

Line 124: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE

120: ,p_measure_type IN NUMBER := NULL
121: ,p_measure_apply_rollup IN VARCHAR2 := NULL
122: ,p_measure_function_name IN VARCHAR2 := NULL
123: ,p_measure_enable_link IN VARCHAR2 := NULL
124: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
125: ,p_type IN VARCHAR2 := NULL
126: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
127: ,p_dimension1_id IN NUMBER
128: ,p_dimension2_id IN NUMBER

Line 126: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236

122: ,p_measure_function_name IN VARCHAR2 := NULL
123: ,p_measure_enable_link IN VARCHAR2 := NULL
124: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
125: ,p_type IN VARCHAR2 := NULL
126: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
127: ,p_dimension1_id IN NUMBER
128: ,p_dimension2_id IN NUMBER
129: ,p_dimension3_id IN NUMBER
130: ,p_dimension4_id IN NUMBER

Line 146: p_commit IN VARCHAR2 := FND_API.G_FALSE

142: );
143:
144: -- 18-OCT-2004 ADRAO, changed signature added p_measure_col_help, Bug#3817894
145: procedure Create_Measure(
146: p_commit IN VARCHAR2 := FND_API.G_FALSE
147: ,x_dataset_id OUT NOCOPY NUMBER
148: ,p_dataset_source IN VARCHAR2
149: ,p_dataset_name IN VARCHAR2
150: ,p_dataset_help IN VARCHAR2 := NULL

Line 182: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE

178: ,p_measure_type IN NUMBER := NULL
179: ,p_measure_apply_rollup IN VARCHAR2 := NULL
180: ,p_measure_function_name IN VARCHAR2 := NULL
181: ,p_measure_enable_link IN VARCHAR2 := NULL
182: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
183: ,p_type IN VARCHAR2 := NULL
184: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
185: ,p_dimension1_id IN NUMBER
186: ,p_dimension2_id IN NUMBER

Line 184: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236

180: ,p_measure_function_name IN VARCHAR2 := NULL
181: ,p_measure_enable_link IN VARCHAR2 := NULL
182: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
183: ,p_type IN VARCHAR2 := NULL
184: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
185: ,p_dimension1_id IN NUMBER
186: ,p_dimension2_id IN NUMBER
187: ,p_dimension3_id IN NUMBER
188: ,p_dimension4_id IN NUMBER

Line 203: p_commit IN VARCHAR2 := FND_API.G_FALSE

199: );
200:
201: --Bug#4045278: Wrapper for Create_Measure that takes in last_update_date
202: procedure Create_Measure(
203: p_commit IN VARCHAR2 := FND_API.G_FALSE
204: ,x_dataset_id OUT NOCOPY NUMBER
205: ,p_dataset_source IN VARCHAR2
206: ,p_dataset_name IN VARCHAR2
207: ,p_dataset_help IN VARCHAR2 := NULL

Line 239: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE

235: ,p_measure_type IN NUMBER := NULL
236: ,p_measure_apply_rollup IN VARCHAR2 := NULL
237: ,p_measure_function_name IN VARCHAR2 := NULL
238: ,p_measure_enable_link IN VARCHAR2 := NULL
239: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
240: ,p_type IN VARCHAR2 := NULL
241: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
242: ,p_dimension1_id IN NUMBER
243: ,p_dimension2_id IN NUMBER

Line 241: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236

237: ,p_measure_function_name IN VARCHAR2 := NULL
238: ,p_measure_enable_link IN VARCHAR2 := NULL
239: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
240: ,p_type IN VARCHAR2 := NULL
241: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
242: ,p_dimension1_id IN NUMBER
243: ,p_dimension2_id IN NUMBER
244: ,p_dimension3_id IN NUMBER
245: ,p_dimension4_id IN NUMBER

Line 262: p_commit IN VARCHAR2 := FND_API.G_FALSE

258:
259:
260: -- 18-OCT-2004 ADRAO, changed signature added p_measure_col_help, Bug#3817894
261: procedure Update_Measure(
262: p_commit IN VARCHAR2 := FND_API.G_FALSE
263: ,p_dataset_id IN NUMBER
264: ,p_dataset_source IN VARCHAR2
265: ,p_dataset_name IN VARCHAR2
266: ,p_dataset_help IN VARCHAR2 := NULL

Line 298: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE

294: ,p_measure_type IN NUMBER := NULL
295: ,p_measure_apply_rollup IN VARCHAR2 := NULL
296: ,p_measure_function_name IN VARCHAR2 := NULL
297: ,p_measure_enable_link IN VARCHAR2 := NULL
298: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
299: ,p_type IN VARCHAR2 := NULL
300: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
301: ,p_time_stamp IN VARCHAR2 := NULL -- Added for Granular Locking
302: ,p_dimension1_id IN NUMBER

Line 300: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236

296: ,p_measure_function_name IN VARCHAR2 := NULL
297: ,p_measure_enable_link IN VARCHAR2 := NULL
298: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
299: ,p_type IN VARCHAR2 := NULL
300: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
301: ,p_time_stamp IN VARCHAR2 := NULL -- Added for Granular Locking
302: ,p_dimension1_id IN NUMBER
303: ,p_dimension2_id IN NUMBER
304: ,p_dimension3_id IN NUMBER

Line 320: p_commit IN VARCHAR2 := FND_API.G_FALSE

316: );
317:
318: --Bug#4045278: Wrapper for Update_Measure that takes in last_update_date
319: procedure Update_Measure(
320: p_commit IN VARCHAR2 := FND_API.G_FALSE
321: ,p_dataset_id IN NUMBER
322: ,p_dataset_source IN VARCHAR2
323: ,p_dataset_name IN VARCHAR2
324: ,p_dataset_help IN VARCHAR2 := NULL

Line 356: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE

352: ,p_measure_type IN NUMBER := NULL
353: ,p_measure_apply_rollup IN VARCHAR2 := NULL
354: ,p_measure_function_name IN VARCHAR2 := NULL
355: ,p_measure_enable_link IN VARCHAR2 := NULL
356: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
357: ,p_type IN VARCHAR2 := NULL
358: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
359: ,p_time_stamp IN VARCHAR2 := NULL -- Added for Granular Locking
360: ,p_dimension1_id IN NUMBER

Line 358: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236

354: ,p_measure_function_name IN VARCHAR2 := NULL
355: ,p_measure_enable_link IN VARCHAR2 := NULL
356: ,p_measure_obsolete IN VARCHAR2 := FND_API.G_FALSE
357: ,p_type IN VARCHAR2 := NULL
358: ,p_measure_is_validate IN VARCHAR2 := FND_API.G_TRUE -- ankgoel: bug#3557236
359: ,p_time_stamp IN VARCHAR2 := NULL -- Added for Granular Locking
360: ,p_dimension1_id IN NUMBER
361: ,p_dimension2_id IN NUMBER
362: ,p_dimension3_id IN NUMBER

Line 379: p_commit IN VARCHAR2 := FND_API.G_FALSE

375: );
376:
377:
378: procedure Delete_measure(
379: p_commit IN VARCHAR2 := FND_API.G_FALSE
380: ,p_dataset_id IN NUMBER
381: ,p_time_stamp IN VARCHAR2 := NULL -- Added for Granular Locking
382: ,x_return_status OUT NOCOPY VARCHAR2
383: ,x_msg_count OUT NOCOPY NUMBER

Line 389: p_commit IN VARCHAR2 := FND_API.G_FALSE

385: );
386:
387:
388: procedure Apply_Dataset_Calc(
389: p_commit IN VARCHAR2 := FND_API.G_FALSE
390: ,p_dataset_id IN NUMBER
391: ,p_Disabled_Calc_table IN BSC_NUM_LIST
392: ,x_return_status OUT NOCOPY VARCHAR2
393: ,x_msg_count OUT NOCOPY NUMBER

Line 399: p_commit IN VARCHAR2 := FND_API.G_FALSE

395: );
396:
397:
398: PROCEDURE Apply_Cause_Effect_Rels(
399: p_commit IN VARCHAR2 := FND_API.G_FALSE
400: ,p_dataset_id IN NUMBER
401: ,p_causes_table IN BSC_NUM_LIST
402: ,p_effects_table IN BSC_NUM_LIST
403: ,x_return_status OUT NOCOPY VARCHAR2

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

430:
431: --=============================================================================
432:
433: Procedure Load_Measure
434: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
435: ,p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
436: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
437: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
438: ,p_custom_mode IN VARCHAR2 := NULL

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

446: ,x_msg_data OUT NOCOPY VARCHAR2
447: );
448: --=============================================================================
449: PROCEDURE Translate_Measure
450: (p_commit IN VARCHAR2 := FND_API.G_FALSE
451: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
452: ,p_custom_mode IN VARCHAR2 := NULL
453: ,p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
454: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

Line 503: p_commit in varchar2 := fnd_api.g_false

499: )
500: return varchar2;
501:
502: procedure Get_Incr_Trigger(
503: p_commit in varchar2 := fnd_api.g_false
504: ,p_dataset_id in number
505: ,p_measure_projection_id in number := -1
506: ,p_measure_type in number := -1
507: ,p_is_ytd_enabled in varchar2 := null