1 PACKAGE PSB_WS_Ops_Pvt AS
2 /* $Header: PSBVWLOS.pls 120.2 2005/07/13 11:31:14 shtripat ship $ */
3
4
5 -- Record type to store a set_id and its account or position type.
6 TYPE account_position_set_rec_type IS RECORD
7 ( account_position_set_id
8 psb_account_position_sets.account_position_set_id%TYPE ,
9 account_or_position_type
10 psb_account_position_sets.account_or_position_type%TYPE
11 );
12
13 -- Table type to store a set_id and its account or position type.
14 TYPE account_position_set_tbl_type IS TABLE OF account_position_set_rec_type
15 INDEX BY BINARY_INTEGER;
16
17 --
18 -- Table type to store Worksheet_Id
19 --
20 TYPE Worksheet_Tbl_Type IS TABLE OF NUMBER
21 INDEX BY BINARY_INTEGER;
22
23
24 PROCEDURE Enforce_WS_Concurrency
25 (
26 p_api_version IN NUMBER ,
27 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
28 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
29 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
30 p_return_status OUT NOCOPY VARCHAR2 ,
31 p_msg_count OUT NOCOPY NUMBER ,
32 p_msg_data OUT NOCOPY VARCHAR2 ,
33 --
34 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
35 p_parent_or_child_mode IN VARCHAR2 ,
36 p_maintenance_mode IN VARCHAR2 := 'MAINTENANCE'
37 );
38
39
40 PROCEDURE Check_WS_Ops_Concurrency
41 (
42 p_api_version IN NUMBER ,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
46 p_return_status OUT NOCOPY VARCHAR2 ,
47 p_msg_count OUT NOCOPY NUMBER ,
48 p_msg_data OUT NOCOPY VARCHAR2 ,
49 --
50 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
51 p_operation_type IN VARCHAR2
52 );
53
54
55 PROCEDURE Create_Worksheet
56 (
57 p_api_version IN NUMBER ,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
61 p_return_status OUT NOCOPY VARCHAR2 ,
62 p_msg_count OUT NOCOPY NUMBER ,
63 p_msg_data OUT NOCOPY VARCHAR2 ,
64 --
65 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
66 p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
67 p_account_position_set_tbl IN account_position_set_tbl_type ,
68 p_service_package_operation_id
69 IN NUMBER := FND_API.G_MISS_NUM ,
70 p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
71 );
72
73
74 PROCEDURE Create_Worksheet
75 (
76 p_api_version IN NUMBER ,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
79 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
80 p_return_status OUT NOCOPY VARCHAR2 ,
81 p_msg_count OUT NOCOPY NUMBER ,
82 p_msg_data OUT NOCOPY VARCHAR2 ,
83 --
84 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
85 p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
86 p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
87 );
88
89
90 PROCEDURE Copy_Worksheet
91 (
92 p_api_version IN NUMBER ,
93 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
94 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
96 p_return_status OUT NOCOPY VARCHAR2 ,
97 p_msg_count OUT NOCOPY NUMBER ,
98 p_msg_data OUT NOCOPY VARCHAR2 ,
99 --
100 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
101 p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
102 );
103
104
105 PROCEDURE Merge_Worksheets
106 (
107 p_api_version IN NUMBER ,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
111 p_return_status OUT NOCOPY VARCHAR2 ,
112 p_msg_count OUT NOCOPY NUMBER ,
113 p_msg_data OUT NOCOPY VARCHAR2 ,
114 --
115 p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
116 p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
117 );
118
119
120 PROCEDURE Delete_Worksheet
121 (
122 p_api_version IN NUMBER ,
123 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
124 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
126 p_return_status OUT NOCOPY VARCHAR2 ,
127 p_msg_count OUT NOCOPY NUMBER ,
128 p_msg_data OUT NOCOPY VARCHAR2 ,
129 --
130 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
131 p_keep_local_copy_flag IN VARCHAR2 := 'N'
132 );
133
134
135 PROCEDURE Add_Worksheet_Line
136 (
137 p_api_version IN NUMBER ,
138 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
139 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
140 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
141 p_return_status OUT NOCOPY VARCHAR2 ,
142 p_msg_count OUT NOCOPY NUMBER ,
143 p_msg_data OUT NOCOPY VARCHAR2 ,
144 --
145 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
146 p_account_line_id IN psb_ws_account_lines.account_line_id%TYPE,
147 p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE
148 );
149
150
151 PROCEDURE Add_Worksheet_Line
152 ( p_api_version IN NUMBER ,
153 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
154 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
155 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
156 p_return_status OUT NOCOPY VARCHAR2 ,
157 p_msg_count OUT NOCOPY NUMBER ,
158 p_msg_data OUT NOCOPY VARCHAR2 ,
159 p_worksheet_id IN NUMBER,
160 p_position_line_id IN NUMBER
161 );
162
163
164 PROCEDURE Add_Line_To_Worksheets
165 (
166 p_api_version IN NUMBER ,
167 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
168 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
169 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
170 p_return_status OUT NOCOPY VARCHAR2 ,
171 p_msg_count OUT NOCOPY NUMBER ,
172 p_msg_data OUT NOCOPY VARCHAR2 ,
173 --
174 p_account_line_id IN psb_ws_account_lines.account_line_id%TYPE,
175 p_worksheet_tbl IN Worksheet_Tbl_Type
176 );
177
178
179 PROCEDURE Add_Worksheet_Position_Line
180 (
181 p_api_version IN NUMBER ,
182 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
183 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
184 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
185 p_return_status OUT NOCOPY VARCHAR2 ,
186 p_msg_count OUT NOCOPY NUMBER ,
187 p_msg_data OUT NOCOPY VARCHAR2 ,
188 --
189 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
190 p_position_line_id IN psb_ws_position_lines.position_line_id%TYPE,
191 p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE
192 );
193
194
195 PROCEDURE Add_Pos_Line_To_Worksheets
196 (
197 p_api_version IN NUMBER ,
198 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
199 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
200 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
201 p_return_status OUT NOCOPY VARCHAR2 ,
202 p_msg_count OUT NOCOPY NUMBER ,
203 p_msg_data OUT NOCOPY VARCHAR2 ,
204 --
205 p_position_line_id IN psb_ws_position_lines.position_line_id%TYPE,
206 p_worksheet_tbl IN Worksheet_Tbl_Type
207 );
208
209
210 PROCEDURE Freeze_Worksheet
211 (
212 p_api_version IN NUMBER ,
213 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
214 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
215 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
216 p_return_status OUT NOCOPY VARCHAR2 ,
217 p_msg_count OUT NOCOPY NUMBER ,
218 p_msg_data OUT NOCOPY VARCHAR2 ,
219 --
220 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
221 p_freeze_flag IN psb_ws_lines.freeze_flag%TYPE
222 );
223
224
225 PROCEDURE Change_Worksheet_Stage
226 (
227 p_api_version IN NUMBER ,
228 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
229 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
230 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
231 p_return_status OUT NOCOPY VARCHAR2 ,
232 p_msg_count OUT NOCOPY NUMBER ,
233 p_msg_data OUT NOCOPY VARCHAR2 ,
234 --
235 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
236 p_stage_seq IN psb_worksheets.current_stage_seq%TYPE
237 := FND_API.G_MISS_NUM ,
238 p_operation_id IN NUMBER := FND_API.G_MISS_NUM
239 );
240
241
242
243 PROCEDURE Find_Parent_Worksheet
244 (
245 p_api_version IN NUMBER ,
246 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
247 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
248 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
249 p_return_status OUT NOCOPY VARCHAR2 ,
250 p_msg_count OUT NOCOPY NUMBER ,
251 p_msg_data OUT NOCOPY VARCHAR2 ,
252 --
253 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
254 p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
255 );
256
257
258 PROCEDURE Find_Parent_Worksheets
259 (
260 p_api_version IN NUMBER ,
261 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
262 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
263 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
264 p_return_status OUT NOCOPY VARCHAR2 ,
265 p_msg_count OUT NOCOPY NUMBER ,
266 p_msg_data OUT NOCOPY VARCHAR2 ,
267 --
268 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
269 p_worksheet_tbl IN OUT NOCOPY Worksheet_Tbl_Type
270 );
271
272
273 PROCEDURE Find_Child_Worksheets
274 ( p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276 p_commit IN VARCHAR2 := FND_API.G_FALSE,
277 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278 p_return_status OUT NOCOPY VARCHAR2 ,
279 p_msg_count OUT NOCOPY NUMBER ,
280 p_msg_data OUT NOCOPY VARCHAR2 ,
281 --
282 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
283 p_worksheet_tbl IN OUT NOCOPY Worksheet_Tbl_Type
284 );
285
286
287 PROCEDURE Update_Worksheet
288 (
289 p_api_version IN NUMBER ,
290 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
291 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
292 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
293 p_return_status OUT NOCOPY VARCHAR2 ,
294 p_msg_count OUT NOCOPY NUMBER ,
295 p_msg_data OUT NOCOPY VARCHAR2 ,
296 --
297 p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
298 p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
299 );
300
301
302 PROCEDURE Delete_Worksheet_CP
303 (
304 errbuf OUT NOCOPY VARCHAR2,
305 retcode OUT NOCOPY VARCHAR2,
306 --
307 p_worksheet_id IN NUMBER ,
308 p_keep_local_copy_flag IN VARCHAR2
309 );
310
311
312 PROCEDURE Create_New_Position_Worksheet
313 (
314 p_api_version IN NUMBER ,
315 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
316 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
317 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
318 p_return_status OUT NOCOPY VARCHAR2 ,
319 p_msg_count OUT NOCOPY NUMBER ,
320 p_msg_data OUT NOCOPY VARCHAR2 ,
321 --
322 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
323 p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
324 p_service_package_operation_id
325 IN NUMBER := FND_API.G_MISS_NUM ,
326 p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
327 );
328
329
330 END PSB_WS_Ops_Pvt ;