1 PACKAGE PA_BILLING_SETUP_PUB AS
2 /* $Header: PABLSTPS.pls 120.3 2005/08/19 16:16:48 mwasowic noship $ */
3
4
5 -- API name : update_revenue_and_billing
6 -- Type : Public procedure
7 -- Pre-reqs : None
8 -- Return Value : N/A
9 -- Prameters
10 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
11 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
12 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
13 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
14 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
15 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
16 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
17 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
18 -- p_project_id IN NUMBER REQUIRED
19 -- p_distribution_rule IN VARCHAR2 REQUIRED
20 -- p_billing_cycle_id IN NUMBER REQUIRED
21 -- p_first_bill_offset IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
22 -- p_next_billing_date OUT DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
23 -- p_output_tax_code IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24 -- p_billing_job_group_id IN NUMBER REQUIRED
25 -- p_invoice_comment IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
26 -- p_labor_id IN NUMBER REQUIRED
27 -- p_non_labor_id IN NUMBER OPTIONAL
28 -- p_retention_inv_format_id IN VARCHAR2 OPTIONAL
29 -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL
30 -- p_retention_percent IN NUMBER OPTIONAL
31 -- p_retention_output_tax_code IN VARCHAR2 OPTIONAL
32 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
33 -- x_return_status OUT VARCHAR2 REQUIRED
34 -- x_msg_count OUT VARCHAR2 REQUIRED
35 -- x_msg_data OUT VARCHAR2 REQUIRED
36 --
37 -- History
38 --
39 -- 25-MAY-01 Majid Ansari -Created
40 --
41 --
42
43 PROCEDURE update_revenue_and_billing(
44 p_api_version IN NUMBER DEFAULT 1.0,
45 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
46 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
48 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
50 p_debug_mode IN VARCHAR2 DEFAULT 'N',
51 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52 p_project_id IN NUMBER ,
53 p_distribution_rule IN VARCHAR2 ,
54 p_billing_cycle_id IN NUMBER ,
55 p_first_bill_offset IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56 p_next_billing_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
57 p_output_tax_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
58 p_billing_job_group_id IN NUMBER ,
59 p_invoice_comment IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
60 p_labor_id IN NUMBER ,
61 p_non_labor_id IN NUMBER ,
62 p_retention_inv_format_id IN VARCHAR2 ,
63 p_retention_inv_format_name IN VARCHAR2 ,
64 p_retention_percent IN NUMBER ,
65 p_retention_output_tax_code IN VARCHAR2 ,
66 p_record_version_number IN NUMBER DEFAULT 1,
67 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
68 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
69 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
70 );
71
72
73 -- API name : create_credit_receivers
74 -- Type : Public procedure
75 -- Pre-reqs : None
76 -- Return Value : N/A
77 -- Prameters
78 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
79 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
80 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
81 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
82 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
83 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
84 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
85 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
86 -- p_project_id IN NUMBER REQUIRED
87 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
88 -- p_credit_type IN VARCHAR2 REQUIRED
89 -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
90 -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
91 -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
92 -- p_credit_percentage IN NUMBER REQUIRED
93 -- p_transfer_to_AR IN VARCHAR2 REQUIRED
94 -- p_effective_from_date IN DATE REQUIRED
95 -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
96 -- x_credit_receiver_id OUT NUMBER REQUIRED
97 -- x_return_status OUT VARCHAR2 REQUIRED
98 -- x_msg_count OUT VARCHAR2 REQUIRED
99 -- x_msg_data OUT VARCHAR2 REQUIRED
100 --
101 -- History
102 --
103 -- 25-MAY-01 Majid Ansari -Created
104 --
105 --
106
107 PROCEDURE create_credit_receivers(
108 p_api_version IN NUMBER DEFAULT 1.0,
109 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
110 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
112 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
113 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
114 p_debug_mode IN VARCHAR2 DEFAULT 'N',
115 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116 p_project_id IN NUMBER ,
117 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
118 p_credit_type IN VARCHAR2 ,
119 p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
120 p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
121 p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
122 p_credit_percentage IN NUMBER ,
123 p_transfer_to_AR IN VARCHAR2 ,
124 p_effective_from_date IN DATE ,
125 p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
126 x_credit_receiver_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
128 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
129 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
130 );
131
132 -- API name : update_credit_receivers
133 -- Type : Public procedure
134 -- Pre-reqs : None
135 -- Return Value : N/A
136 -- Prameters
137 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
138 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
139 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
140 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
141 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
142 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
143 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
144 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
145 -- p_credit_receiver_id IN NUMBER REQUIRED
146 -- p_project_id IN NUMBER REQUIRED
147 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
148 -- p_credit_type IN VARCHAR2 REQUIRED
149 -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
150 -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
151 -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
152 -- p_credit_percentage IN NUMBER REQUIRED
153 -- p_transfer_to_AR IN VARCHAR2 REQUIRED
154 -- p_effective_from_date IN DATE REQUIRED
155 -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
156 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
157 -- x_return_status OUT VARCHAR2 REQUIRED
158 -- x_msg_count OUT VARCHAR2 REQUIRED
159 -- x_msg_data OUT VARCHAR2 REQUIRED
160 --
161 -- History
162 --
163 -- 25-MAY-01 Majid Ansari -Created
164 --
165 --
166
167 PROCEDURE update_credit_receivers(
168 p_api_version IN NUMBER DEFAULT 1.0,
169 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
170 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
172 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
173 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
174 p_debug_mode IN VARCHAR2 DEFAULT 'N',
175 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176 p_credit_receiver_id IN NUMBER ,
177 p_project_id IN NUMBER ,
178 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
179 p_credit_type IN VARCHAR2 ,
180 p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
181 p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182 p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
183 p_credit_percentage IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184 p_transfer_to_AR IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
185 p_effective_from_date IN DATE ,
186 p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
187 p_record_version_number IN NUMBER DEFAULT 1,
188 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
189 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
190 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
191 );
192
193
194 -- API name : delete_credit_receivers
195 -- Type : Public procedure
196 -- Pre-reqs : None
197 -- Return Value : N/A
198 -- Prameters
199 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
200 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
201 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
202 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
203 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
204 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
205 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
206 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
207 -- p_credit_receiver_id IN NUMBER REQUIRED
208 -- p_project_id IN NUMBER REQUIRED
209 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
210 -- p_credit_type IN VARCHAR2 REQUIRED
211 -- p_person_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
212 -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CAHR
216 -- x_msg_count OUT VARCHAR2 REQUIRED
213 -- p_effective_from_date IN DATE REQUIRED
214 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
215 -- x_return_status OUT VARCHAR2 REQUIRED
217 -- x_msg_data OUT VARCHAR2 REQUIRED
218 --
219 -- History
220 --
221 -- 25-MAY-01 Majid Ansari -Created
222 --
223 --
224
225 PROCEDURE delete_credit_receivers(
226 p_api_version IN NUMBER DEFAULT 1.0,
227 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
228 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
230 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
231 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
232 p_debug_mode IN VARCHAR2 DEFAULT 'N',
233 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234 p_credit_receiver_id IN NUMBER,
235 p_project_id IN NUMBER ,
236 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237 p_credit_type IN VARCHAR2 ,
238 p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239 p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
240 p_effective_from_date IN DATE ,
241 p_record_version_number IN NUMBER DEFAULT 1,
242 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
243 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
244 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245 );
246
247 -- API name : create_billing_assignments
248 -- Type : Public procedure
249 -- Pre-reqs : None
250 -- Return Value : N/A
251 -- Prameters
252 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
253 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
254 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
255 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
256 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
257 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
258 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
259 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
260 -- p_project_id IN NUMBER REQUIRED
261 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
262 -- p_billing_extension_id IN NUMBER REQUIRED
263 -- p_amount IN NUMBER REQUIRED
264 -- p_percent IN NUMBER REQUIRED
265 -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
266 -- x_billing_assignment_id OUT NUMBER REQUIRED
267 -- x_return_status OUT VARCHAR2 REQUIRED
268 -- x_msg_count OUT VARCHAR2 REQUIRED
269 -- x_msg_data OUT VARCHAR2 REQUIRED
270 --
271 -- History
272 --
273 -- 25-MAY-01 Majid Ansari -Created
274 --
275 --
276
277 PROCEDURE create_billing_assignments(
278 p_api_version IN NUMBER DEFAULT 1.0,
279 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
280 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
282 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
283 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
284 p_debug_mode IN VARCHAR2 DEFAULT 'N',
285 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
286 p_project_id IN NUMBER ,
287 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
288 p_billing_extension_id IN NUMBER ,
289 p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
290 p_percent IN NUMBER DEFAULT FND_API.G_MISS_NUM,
291 p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
292 x_billing_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
293 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
294 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
295 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
296 );
297
298
299 -- API name : update_billing_assignments
300 -- Type : Public procedure
301 -- Pre-reqs : None
302 -- Return Value : N/A
303 -- Prameters
304 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
305 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
306 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
307 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
308 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
309 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
310 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
311 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
312 -- p_project_id IN NUMBER REQUIRED
313 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
314 -- p_billing_extension_id IN NUMBER REQUIRED
315 -- p_billing_assignment_id IN NUMBER ,
316 -- p_amount IN NUMBER REQUIRED
317 -- p_percent IN NUMBER REQUIRED
318 -- p_active IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
319 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
320 -- x_return_status OUT VARCHAR2 REQUIRED
321 -- x_msg_count OUT VARCHAR2 REQUIRED
325 --
322 -- x_msg_data OUT VARCHAR2 REQUIRED
323 --
324 -- History
326 -- 25-MAY-01 Majid Ansari -Created
327 --
328 --
329
330 PROCEDURE update_billing_assignments(
331 p_api_version IN NUMBER DEFAULT 1.0,
332 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
333 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
334 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
335 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
336 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
337 p_debug_mode IN VARCHAR2 DEFAULT 'N',
338 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339 p_project_id IN NUMBER ,
340 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341 p_billing_extension_id IN NUMBER ,
342 p_billing_assignment_id IN NUMBER ,
343 p_amount IN NUMBER ,
344 p_percent IN NUMBER ,
345 p_active IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
346 p_record_version_number IN NUMBER DEFAULT 1,
347 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
348 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
349 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
350 );
351
352
353 -- API name : delete_billing_assignments
354 -- Type : Public procedure
355 -- Pre-reqs : None
356 -- Return Value : N/A
357 -- Prameters
358 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
359 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
360 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
361 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
362 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
363 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
364 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
365 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
366 -- p_project_id IN NUMBER REQUIRED
367 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
368 -- p_billing_extension_id IN NUMBER REQUIRED
369 -- p_billing_assignment_id IN NUMBER ,
370 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
371 -- x_return_status OUT VARCHAR2 REQUIRED
372 -- x_msg_count OUT VARCHAR2 REQUIRED
373 -- x_msg_data OUT VARCHAR2 REQUIRED
374 --
375 -- History
376 --
377 -- 25-MAY-01 Majid Ansari -Created
378 --
379 --
380
381 PROCEDURE delete_billing_assignments(
382 p_api_version IN NUMBER DEFAULT 1.0,
383 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
384 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
385 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
386 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
387 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
388 p_debug_mode IN VARCHAR2 DEFAULT 'N',
389 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
390 p_project_id IN NUMBER ,
391 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
392 p_billing_extension_id IN NUMBER ,
393 p_billing_assignment_id IN NUMBER ,
394 p_record_version_number IN NUMBER DEFAULT 1,
395 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
396 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
400
397 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
398 );
399
401
402 END PA_BILLING_SETUP_PUB;