1 PACKAGE BSC_COMMON_DIMENSIONS_PVT AS
2 /* $Header: BSCVLIBS.pls 120.2.12000000.1 2007/07/17 07:44:54 appldev noship $ */
3
4 C_ALL CONSTANT VARCHAR2(1) := 'T';
5 C_COM_DIM_DEFAULT_VALUE CONSTANT VARCHAR2(3) := 'D%';
6
7
8 -- The following API saves LIST BUTTON (Common Dimension) configuration
9 -- for a particular SCORECARD.
10 -- INPUT :
11 -- p_new_list_config A semicolon(;) seperated values of common dimension objects
12 -- that have to be saved.
13 -- NOTE: Each common dimension object record contains a commma seperated list of the following
14 -- properties in order:
15 -- (dim_level_index, dim_level_id, parent_level_index, parent_level_id)
16
17 PROCEDURE insert_common_dimensions
18 (
19 p_tab_id IN NUMBER
20 ,p_new_list_config IN VARCHAR2
21 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22 ,x_return_status OUT NOCOPY VARCHAR2
23 ,x_msg_count OUT NOCOPY NUMBER
24 ,x_msg_data OUT NOCOPY VARCHAR2
25 ) ;
26
27
28
29 -- The following API removes common dimensions for a given scorecard.
30
31 PROCEDURE delete_common_dimensions
32 (
33 p_tab_id IN NUMBER
34 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE delete_common_dimensions_tabs (
41 p_commit IN VARCHAR2 := FND_API.G_FALSE
42 , p_tab_ids IN VARCHAR2
43 , x_return_status OUT NOCOPY VARCHAR2
44 , x_msg_count OUT NOCOPY NUMBER
45 , x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48
49 PROCEDURE delete_user_list_access
50 (
51 p_tab_id IN NUMBER
52 ,p_dim_level_index IN NUMBER
53 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59
60 PROCEDURE insert_user_list_access
61 (
62 p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
63 ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
64 ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
65 ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66 ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67 ,p_created_by IN bsc_user_list_access.created_by%TYPE
68 ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
69 ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
70 ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
71 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER
74 ,x_msg_data OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE reset_dim_default_value
78 (
79 p_Tab_Id IN BSC_TABS_B.tab_id%TYPE
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE set_dim_default_value
86 (
87 p_dim_level_id IN BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
88 ,p_default_value IN BSC_KPI_DIM_LEVELS_B.default_value%TYPE
89 ,p_Tab_Id IN BSC_TABS_B.tab_id%TYPE
90 ,x_return_status OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95 END BSC_COMMON_DIMENSIONS_PVT;