[Home] [Help]
PACKAGE: APPS.BSC_CALCULATIONS_PUB
Source
1 PACKAGE BSC_CALCULATIONS_PUB AS
2 /* $Header: BSCPCLCS.pls 120.1.12000000.1 2007/07/17 07:43:46 appldev noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCPCLCS.pls |
10 | |
11 | Creation Date: |
12 | December 28, 2006 |
13 | |
14 | Creator: |
15 | Pradeep Kishore Somesula |
16 | |
17 | Description: |
18 | Public Specs version. |
19 | This package handles calculations |
20 | |
21 +======================================================================================+
22 */
23
24 PROCEDURE save_obj_calculations(
25 p_obj_id IN NUMBER
26 , p_params IN VARCHAR2
27 , p_ytd_as_default IN VARCHAR2
28 , p_commit IN VARCHAR2 := FND_API.G_FALSE
29 , x_return_status OUT NOCOPY VARCHAR2
30 , x_msg_count OUT NOCOPY NUMBER
31 , x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE save_ytd_as_default_calc(
35 p_obj_id IN NUMBER
36 , p_ytd_as_default IN VARCHAR2
37 , p_commit IN VARCHAR2 := FND_API.G_FALSE
38 , x_return_status OUT NOCOPY VARCHAR2
39 , x_msg_count OUT NOCOPY NUMBER
40 , x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43
44 PROCEDURE save_user_wizard_calculations
45 (p_tab_id IN NUMBER
46 ,p_obj_id IN NUMBER
47 ,p_calcs_list IN VARCHAR2
48 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 FUNCTION is_balance_measure(
55 p_kpi_measure_id IN NUMBER
56 ) RETURN VARCHAR2 ;
57
58 FUNCTION is_YTD_enabled_in_def_measure(
59 p_obj_id IN NUMBER
60 ) RETURN VARCHAR2;
61
62 FUNCTION is_calculation_default(
63 p_obj_id IN NUMBER
64 ,p_cal_id IN NUMBER
65 ) RETURN VARCHAR2;
66
67 FUNCTION Is_Dataset_Balance_Type(
68 p_dataset_id IN NUMBER
69 ) RETURN VARCHAR2;
70
71 FUNCTION Is_Calculation_Enabled(
72 p_dataset_id IN NUMBER
73 ,p_calculation_id IN NUMBER
74 ) RETURN VARCHAR2 ;
75
76 END BSC_CALCULATIONS_PUB;