1 PACKAGE PSB_WS_POS3 AS
2 /* $Header: PSBVWP3S.pls 120.4 2006/04/07 11:18:11 shtripat ship $ */
3
4 g_flex_code NUMBER ; -- Bug#4675858
5
6 /* ----------------------------------------------------------------------- */
7
8 -- API name : Apply_Element_Parameters
9 -- Type : Private <Implementation>
10 -- Pre-reqs : FND_API, FND_MESSAGE
11 -- .
12 -- Version : Current version 1.0
13 -- Initial version 1.0
14 -- Created 12/09/1997 by Supriyo Ghosh
15 --
16 -- Notes : Apply all Element Parameters
17 --
18
19 PROCEDURE Apply_Element_Parameters
20 ( p_api_version IN NUMBER,
21 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
22 p_return_status OUT NOCOPY VARCHAR2,
23 p_worksheet_id IN NUMBER,
24 p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
25 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
26 p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
27 p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
28 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
29 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
30 p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
31 );
32
33 /* ----------------------------------------------------------------------- */
34
35 -- API name : Apply_Position_Parameters
36 -- Type : Private <Implementation>
37 -- Pre-reqs : FND_API, FND_MESSAGE
38 -- .
39 -- Version : Current version 1.0
40 -- Initial version 1.0
41 -- Created 12/09/1997 by Supriyo Ghosh
42 --
43 -- Notes : Apply all Position Parameters
44 --
45
46 PROCEDURE Apply_Position_Parameters
47 ( p_api_version IN NUMBER,
48 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
49 p_return_status OUT NOCOPY VARCHAR2,
50 p_worksheet_id IN NUMBER,
51 p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
53 p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
54 p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
55 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
57 p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
58 );
59
60 /* ----------------------------------------------------------------------- */
61
62 -- API name : Redistribute_Follow_Salary
63 -- Type : Private <Implementation>
64 -- Pre-reqs : FND_API, FND_MESSAGE
65 -- .
66 -- Version : Current version 1.0
67 -- Initial version 1.0
68 -- Created 12/09/1997 by Supriyo Ghosh
69 --
70 -- Notes : Redistribute Follow Salary
71 --
72
73 PROCEDURE Redistribute_Follow_Salary
74 ( p_api_version IN NUMBER,
75 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
76 p_return_status OUT NOCOPY VARCHAR2,
77 p_worksheet_id IN NUMBER,
78 p_position_line_id IN NUMBER,
79 p_budget_year_id IN NUMBER := FND_API.G_MISS_NUM,
80 p_service_package_id IN NUMBER,
81 p_stage_set_id IN NUMBER,
82 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR
83 );
84
85 /* ----------------------------------------------------------------------- */
86
87 -- API name : Apply_Element_Constraints
88 -- Type : Private <Implementation>
89 -- Pre-reqs :
90 -- .
91 -- Version : Current version 1.0
92 -- Initial version 1.0
93 -- Created 12/09/1997 by Supriyo Ghosh
94 --
95 -- Notes : Apply Element Constraints and log all Constraint
96 -- Validation Errors
97
98 PROCEDURE Apply_Element_Constraints
99 ( p_return_status OUT NOCOPY VARCHAR2,
100 p_worksheet_id IN NUMBER,
101 p_budget_calendar_id IN NUMBER,
102 p_data_extract_id IN NUMBER,
103 p_constraint_set_id IN NUMBER,
104 p_constraint_set_name IN VARCHAR2,
105 p_constraint_threshold IN NUMBER
106 );
107
108 /* ----------------------------------------------------------------------- */
109
110 -- API name : Apply_Position_Constraints
111 -- Type : Private <Implementation>
112 -- Pre-reqs : FND_API, FND_MESSAGE
113 -- .
114 -- Version : Current version 1.0
115 -- Initial version 1.0
116 -- Created 12/09/1997 by Supriyo Ghosh
117 --
118 -- Notes : Apply Position Constraints and log all Constraint
119 -- Validation Errors
120
121 PROCEDURE Apply_Position_Constraints
122 ( p_return_status OUT NOCOPY VARCHAR2,
123 p_validation_status OUT NOCOPY VARCHAR2,
124 p_worksheet_id IN NUMBER,
125 p_budget_calendar_id IN NUMBER,
126 p_data_extract_id IN NUMBER,
127 p_business_group_id IN NUMBER,
128 p_func_currency IN VARCHAR2,
129 p_constraint_set_id IN NUMBER,
130 p_constraint_set_name IN VARCHAR2,
131 p_constraint_threshold IN NUMBER
132 );
133
134 /* ----------------------------------------------------------------------- */
135
136 PROCEDURE Process_ElemCons_Detailed
137 ( p_return_status OUT NOCOPY VARCHAR2,
138 p_worksheet_id IN NUMBER,
139 p_data_extract_id IN NUMBER,
140 p_constraint_id IN NUMBER,
141 p_start_date IN DATE,
142 p_end_date IN DATE
143 );
144
145 PROCEDURE Process_ElemParam
146 ( p_return_status OUT NOCOPY VARCHAR2,
147 p_worksheet_id IN NUMBER,
148 p_parameter_id IN NUMBER,
149 p_currency_code IN VARCHAR2,
150 p_start_date IN DATE,
151 p_end_date IN DATE,
152 p_compound_annually IN VARCHAR2,
153 p_compound_factor IN NUMBER
154 );
155
156 PROCEDURE Process_ElemParam_AutoInc
157 ( p_return_status OUT NOCOPY VARCHAR2,
158 p_worksheet_id IN NUMBER,
159 p_data_extract_id IN NUMBER,
160 p_business_group_id IN NUMBER,
161 p_parameter_id IN NUMBER,
162 p_currency_code IN VARCHAR2,
163 p_start_date IN DATE,
164 p_end_date IN DATE,
165 p_compound_factor IN NUMBER
166 );
167
168 PROCEDURE Process_PosParam_Detailed
169 ( p_return_status OUT NOCOPY VARCHAR2,
170 p_event_type IN VARCHAR2,
171 p_local_parameter IN VARCHAR2,
172 p_global_worksheet_id IN NUMBER,
173 p_worksheet_id IN NUMBER,
174 p_global_worksheet IN VARCHAR2,
175 p_data_extract_id IN NUMBER,
176 p_business_group_id IN NUMBER,
177 p_parameter_id IN NUMBER,
178 p_parameter_start_date IN DATE,
179 p_compound_annually IN VARCHAR2,
180 p_compound_factor IN NUMBER := FND_API.G_MISS_NUM,
181 p_parameter_autoinc_rule IN VARCHAR2,
182 p_currency_code IN VARCHAR2,
183 p_start_date IN DATE,
184 p_end_date IN DATE,
185 p_recalculate_flag IN BOOLEAN := FALSE
186 );
187
188 PROCEDURE Process_PosParam_AutoInc
189 ( p_return_status OUT NOCOPY VARCHAR2,
190 --Bug No 3315330 Start
191 x_msg_data OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 --Bug No 3315330 End
194 p_worksheet_id IN NUMBER,
195 p_data_extract_id IN NUMBER,
196 p_business_group_id IN NUMBER,
197 p_position_id IN NUMBER,
198 p_parameter_id IN NUMBER,
199 p_parameter_start_date IN DATE,
200 p_currency_code IN VARCHAR2,
201 p_start_date IN DATE,
202 p_end_date IN DATE
203 );
204
205 PROCEDURE Process_PosParam
206 ( p_return_status OUT NOCOPY VARCHAR2,
207 --Bug No 3315330 Start
208 x_msg_data OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 --Bug No 3315330 End
211 p_worksheet_id IN NUMBER,
212 p_global_worksheet_id IN NUMBER,
213 p_data_extract_id IN NUMBER,
214 p_position_id IN NUMBER,
215 p_parameter_id IN NUMBER,
216 p_currency_code IN VARCHAR2,
217 p_start_date IN DATE,
218 p_end_date IN DATE,
219 p_compound_annually IN VARCHAR2,
220 p_compound_factor IN NUMBER
221 );
222
223 /* ----------------------------------------------------------------------- */
224
225 -- API name : Revise_Position_Projections
226 -- Type : Private <Implementation>
227 -- Pre-reqs : FND_API, FND_MESSAGE
228 -- .
229 -- Version : Current version 1.0
230 -- Initial version 1.0
231 -- Created 04/10/2000 by Supriyo Ghosh
232 --
233 -- Notes : Revise Position Projections
234 --
235
236 PROCEDURE Revise_Position_Projections
237 ( p_api_version IN NUMBER,
238 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
239 p_return_status OUT NOCOPY VARCHAR2,
240 --Bug No 3315330 Start
241 x_msg_data OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 --Bug No 3315330 End
244 p_worksheet_id IN NUMBER,
245 p_parameter_id IN NUMBER
246 );
247
248 /* ----------------------------------------------------------------------- */
249 /* Bug No 2482305 Start */
250
251 PROCEDURE Revise_Element_Projections
252 ( p_api_version IN NUMBER,
253 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
254 p_return_status OUT NOCOPY VARCHAR2,
255 p_worksheet_id IN NUMBER,
256 p_parameter_id IN NUMBER,
257 p_recalculate_flag IN BOOLEAN := TRUE
258 );
259
260 /* Bug No 2482305 End */
261 /* ----------------------------------------------------------------------- */
262
263 -- API name : Get_Debug
264 -- Type : Private
265 -- Pre-reqs : None
266
267 FUNCTION Get_Debug RETURN VARCHAR2;
268
269 /* ----------------------------------------------------------------------- */
270 -- Global Name : note_parameter_id
271 -- Type : Private
272 -- Pre-reqs : None
273 -- Added for the Fix for Part II of Bug No 1584464
274
275 g_note_parameter_name VARCHAR2(100);
276
277 /* ----------------------------------------------------------------------- */
278
279 END PSB_WS_POS3;