1 PACKAGE PA_BILLING_SETUP_PVT 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
221 -- Return Value : N/A
218 -- API name : create_billing_assignments
219 -- Type : Private procedure
220 -- Pre-reqs : None
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
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 );
314
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
331 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
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 ,
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;