[Home] [Help]
PACKAGE: APPS.BSC_DIMENSION_GROUPS_PVT
Source
1 package BSC_DIMENSION_GROUPS_PVT as
2 /* $Header: BSCVDMGS.pls 120.0 2005/06/01 15:54:32 appldev noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCVDMGS.pls |
10 | |
11 | Creation Date: |
12 | October 9, 2001 |
13 | |
14 | Creator: |
15 | Mario-Jair Campos |
16 | |
17 | Description: |
18 | Public specs version. |
19 | This package creates a Dimension Group in BSC. |
20 | 14-JUN-03 mahrao Added Translate_dimesnsion_group procedure |
21 | |
22 +======================================================================================+
23 */
24
25 procedure Create_Dimension_Group(
26 p_commit IN varchar2 := FND_API.G_FALSE
27 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
28 ,x_return_status OUT NOCOPY varchar2
29 ,x_msg_count OUT NOCOPY number
30 ,x_msg_data OUT NOCOPY varchar2
31 );
32
33 procedure Retrieve_Dimension_Group(
34 p_commit IN varchar2 := FND_API.G_FALSE
35 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
36 ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
37 ,x_return_status OUT NOCOPY varchar2
38 ,x_msg_count OUT NOCOPY number
39 ,x_msg_data OUT NOCOPY varchar2
40 );
41
42 procedure Update_Dimension_Group(
43 p_commit IN varchar2 := FND_API.G_FALSE
44 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_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 procedure Delete_Dimension_Group(
51 p_commit IN varchar2 := FND_API.G_FALSE
52 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
53 ,x_return_status OUT NOCOPY varchar2
54 ,x_msg_count OUT NOCOPY number
55 ,x_msg_data OUT NOCOPY varchar2
56 );
57
58 procedure Create_Dim_Levels_In_Group(
59 p_commit IN varchar2 := FND_API.G_FALSE
60 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
61 ,x_return_status OUT NOCOPY varchar2
62 ,x_msg_count OUT NOCOPY number
63 ,x_msg_data OUT NOCOPY varchar2
64 );
65
66 procedure Retrieve_Dim_Levels_In_Group(
67 p_commit IN varchar2 := FND_API.G_FALSE
68 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
69 ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
70 ,x_return_status OUT NOCOPY varchar2
71 ,x_msg_count OUT NOCOPY number
72 ,x_msg_data OUT NOCOPY varchar2
73 );
74
75 procedure Update_Dim_Levels_In_Group(
76 p_commit IN varchar2 := FND_API.G_FALSE
77 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
78 ,x_return_status OUT NOCOPY varchar2
79 ,x_msg_count OUT NOCOPY number
80 ,x_msg_data OUT NOCOPY varchar2
81 );
82
83 procedure Delete_Dim_Levels_In_Group(
84 p_commit IN varchar2 := FND_API.G_FALSE
85 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
86 ,x_return_status OUT NOCOPY varchar2
87 ,x_msg_count OUT NOCOPY number
88 ,x_msg_data OUT NOCOPY varchar2
89 );
90
91 FUNCTION get_Dim_Group_Id(
92 p_Short_Name IN varchar2
93 ) RETURN number;
94
95 --
96 PROCEDURE Translate_Dimension_Group
97 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
98 ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_count OUT NOCOPY NUMBER
101 ,x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104 -- ADDED TO SYNC THE LANGUAGE DATA FROM PMF TO BSC
105
106 procedure Translate_Dim_By_Given_Lang
107 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
108 , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
109 , x_return_status OUT NOCOPY VARCHAR2
110 , x_msg_count OUT NOCOPY NUMBER
111 , x_msg_data OUT NOCOPY VARCHAR2
112 );
113
114
115 end BSC_DIMENSION_GROUPS_PVT;