1 PACKAGE BSC_COMMON_DIM_LEVELS_PUB AS
2 /* $Header: BSCPCDLS.pls 120.2 2007/02/20 17:03:45 psomesul ship $ */
3 /*-------------------------------------------------------------------------------------------------------------------
4 Check_Common_Dim_Levels
5 -------------------------------------------------------------------------------------------------------------------*/
6 PROCEDURE Check_Common_Dim_Levels(
7 p_commit IN varchar2 := FND_API.G_FALSE
8 ,p_Tab_Id IN number
9 ,x_return_status OUT NOCOPY varchar2
10 ,x_msg_count OUT NOCOPY number
11 ,x_msg_data OUT NOCOPY varchar2
12 );
13
14 -------------------------------------------------------------------------------------------------------------------
15 -- Check_Common_Dim_Levels
16 -- Return x_return_status = 'DISABLE' if it disables one or more common
17 -- Dimension in the Checking.
18 -------------------------------------------------------------------------------------------------------------------
19 PROCEDURE Check_Common_Dim_Levels_DL(
20 p_Dim_Level_Id IN number
21 ,x_return_status OUT NOCOPY varchar2
22 ,x_msg_count OUT NOCOPY number
23 ,x_msg_data OUT NOCOPY varchar2
24 );
25
26
27 /*------------------------------------------------------------------------------
28 Check_Common_Dim_Levels_by_Dim
29 Top be use when a Dimension (Dimension Group )is updated
30 ---------------------------------------------------------------------------------*/
31 PROCEDURE Check_Common_Dim_Levels_by_Dim(
32 p_Dimension_Id IN number
33 ,x_return_status OUT NOCOPY varchar2
34 ,x_msg_count OUT NOCOPY number
35 ,x_msg_data OUT NOCOPY varchar2
36 );
37
38 /*-------------------------------------------------------------------------------------------------------------------
39 Find_Common_Dim_Levels
40 -------------------------------------------------------------------------------------------------------------------*/
41 PROCEDURE Find_Common_Dim_Levels(
42 p_commit IN varchar2 := FND_API.G_FALSE
43 ,p_Tab_Id IN number
44 ,x_Dim_Level_Tbl OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type
45 ,x_return_status OUT NOCOPY varchar2
46 ,x_msg_count OUT NOCOPY number
47 ,x_msg_data OUT NOCOPY varchar2
48 );
49 /*-------------------------------------------------------------------------------------------------------------------
50 Retrieve_Common_Dim_Levels
51 -------------------------------------------------------------------------------------------------------------------*/
52 PROCEDURE Retrieve_Common_Dim_Levels(
53 p_commit IN varchar2 := FND_API.G_FALSE
54 ,p_Tab_Id IN number
55 ,x_Dim_Level_Tbl OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type
56 ,x_return_status OUT NOCOPY varchar2
57 ,x_msg_count OUT NOCOPY number
58 ,x_msg_data OUT NOCOPY varchar2
59 );
60 /*-------------------------------------------------------------------------------------------------------------------
61 Check_Dim_Level_Default_Value
62 -------------------------------------------------------------------------------------------------------------------*/
63 PROCEDURE Check_Dim_Level_Default_Value(
64 p_commit IN varchar2 := FND_API.G_FALSE
65 ,p_Tab_Id IN number
66 ,x_return_status OUT NOCOPY varchar2
67 ,x_msg_count OUT NOCOPY number
68 ,x_msg_data OUT NOCOPY varchar2
69 );
70
71 /*************************************************************************
72 This procedure validates the List Button.
73 /*************************************************************************/
74 PROCEDURE Validate_List_Button
75 (
76 p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE :=NULL
77 ,p_Dim_Level_Id IN NUMBER :=NULL
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83
84
85 END BSC_COMMON_DIM_LEVELS_PUB;