[Home] [Help]
PACKAGE: APPS.BSC_DATASETS_PVT
Source
1 package BSC_DATASETS_PVT as
2 /* $Header: BSCVDTSS.pls 120.2 2006/01/05 05:59:56 ppandey noship $ */
3
4
5 procedure Create_Measures(
6 p_commit IN varchar2 := FND_API.G_FALSE
7 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
8 ,x_return_status OUT NOCOPY varchar2
9 ,x_msg_count OUT NOCOPY number
10 ,x_msg_data OUT NOCOPY varchar2
11 );
12
13 procedure Retrieve_Measures(
14 p_commit IN varchar2 := FND_API.G_FALSE
15 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
16 ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
17 ,x_return_status OUT NOCOPY varchar2
18 ,x_msg_count OUT NOCOPY number
19 ,x_msg_data OUT NOCOPY varchar2
20 );
21
22 procedure Update_Measures(
23 p_commit IN varchar2 := FND_API.G_FALSE
24 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
25 ,x_return_status OUT NOCOPY varchar2
26 ,x_msg_count OUT NOCOPY number
27 ,x_msg_data OUT NOCOPY varchar2
28 );
29
30 procedure Delete_Measures(
31 p_commit IN varchar2 := FND_API.G_FALSE
32 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
33 ,x_return_status OUT NOCOPY varchar2
34 ,x_msg_count OUT NOCOPY number
35 ,x_msg_data OUT NOCOPY varchar2
36 );
37
38 procedure Create_Dataset(
39 p_commit IN varchar2 := FND_API.G_FALSE
40 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
41 ,x_return_status OUT NOCOPY varchar2
42 ,x_msg_count OUT NOCOPY number
43 ,x_msg_data OUT NOCOPY varchar2
44 );
45
46 procedure Retrieve_Dataset(
47 p_commit IN varchar2 := FND_API.G_FALSE
48 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
49 ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
50 ,x_return_status OUT NOCOPY varchar2
51 ,x_msg_count OUT NOCOPY number
52 ,x_msg_data OUT NOCOPY varchar2
53 );
54
55 procedure Update_Dataset(
56 p_commit IN varchar2 := FND_API.G_FALSE
57 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
58 ,x_return_status OUT NOCOPY varchar2
59 ,x_msg_count OUT NOCOPY number
60 ,x_msg_data OUT NOCOPY varchar2
61 );
62
63 procedure Delete_Dataset(
64 p_commit IN varchar2 := FND_API.G_FALSE
65 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
66 ,x_return_status OUT NOCOPY varchar2
67 ,x_msg_count OUT NOCOPY number
68 ,x_msg_data OUT NOCOPY varchar2
69 );
70
71 procedure Create_Dataset_Calc(
72 p_commit IN varchar2 := FND_API.G_FALSE
73 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
74 ,x_return_status OUT NOCOPY varchar2
75 ,x_msg_count OUT NOCOPY number
76 ,x_msg_data OUT NOCOPY varchar2
77 );
78
79 procedure Retrieve_Dataset_Calc(
80 p_commit IN varchar2 := FND_API.G_FALSE
81 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
82 ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
83 ,x_return_status OUT NOCOPY varchar2
84 ,x_msg_count OUT NOCOPY number
85 ,x_msg_data OUT NOCOPY varchar2
86 );
87
88 procedure Update_Dataset_Calc(
89 p_commit IN varchar2 := FND_API.G_FALSE
90 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
91 ,x_return_status OUT NOCOPY varchar2
92 ,x_msg_count OUT NOCOPY number
93 ,x_msg_data OUT NOCOPY varchar2
94 );
95
96 procedure Delete_Dataset_Calc(
97 p_commit IN varchar2 := FND_API.G_FALSE
98 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_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 function Validate_Measure(
105 p_Measure_Name varchar2
106 ) return number;
107
108 --=============================================================================
109 PROCEDURE Translate_Measure
110 ( p_commit IN VARCHAR2
111 , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
112 , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
113 , x_return_status OUT NOCOPY VARCHAR2
114 , x_msg_count OUT NOCOPY NUMBER
115 , x_msg_data OUT NOCOPY VARCHAR2
116 ) ;
117 --=============================================================================
118
119 -- mdamle 09/25/2003 - Sync up measures for all installed languages
120 PROCEDURE Translate_Measure_By_lang
121 ( p_commit IN VARCHAR2
122 , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
123 , p_lang IN VARCHAR2
124 , p_source_lang IN VARCHAR2
125 , x_return_status OUT NOCOPY VARCHAR2
126 , x_msg_count OUT NOCOPY NUMBER
127 , x_msg_data OUT NOCOPY VARCHAR2
128 );
129
130 FUNCTION Is_Structure_change (
131 p_old_formula IN varchar2
132 ,p_new_formula IN varchar2
133 ) RETURN BOOLEAN;
134
135 end BSC_DATASETS_PVT;