DBA Data[Home] [Help]

PACKAGE: APPS.PA_BILLING_SETUP_PVT

Source


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