[Home] [Help]
PACKAGE BODY: APPS.IGW_AWARDS_PVT
Source
1 PACKAGE BODY Igw_Awards_Pvt AS
2 --$Header: igwvawib.pls 120.12 2005/09/12 21:05:36 vmedikon ship $
3
4 ---------------------------------------------------------------------------
5
6 G_PKG_NAME VARCHAR2(30) := 'IGW_AWARDS_PVT';
7
8 ---------------------------------------------------------------------------
9
10 PROCEDURE Check_Lock
11 (
12 p_rowid IN VARCHAR2,
13 p_record_version_number IN NUMBER
14 ) IS
15
16 l_api_name CONSTANT VARCHAR2(30) := 'Check_Lock';
17
18 l_locked VARCHAR2(1);
19
20 BEGIN
21 null;
22
23 END Check_Lock;
24
25 ---------------------------------------------------------------------------
26
27 PROCEDURE Get_Award_Numbering_Method
28 (
29 x_award_numbering_method OUT NOCOPY VARCHAR2,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 ) IS
34
35 l_api_name CONSTANT VARCHAR2(30) := 'Get_Award_Numbering_Method';
36
37 BEGIN
38
39 null;
40
41 END Get_Award_Numbering_Method;
42
43 ---------------------------------------------------------------------------
44
45 FUNCTION Get_Gms_Lookup_Code( p_lookup_type VARCHAR2, p_meaning VARCHAR2 )
46 RETURN varchar2 IS
47
48 l_api_name CONSTANT VARCHAR2(30) := 'Get_Gms_Lookup_Code';
49
50 l_lookup_code VARCHAR2(30);
51
52 BEGIN
53
54 null;
55
56 END Get_Gms_Lookup_Code;
57
58 ---------------------------------------------------------------------------
59
60 FUNCTION Get_Funding_Source_Id(p_funding_source_name VARCHAR2,p_funding_source_id NUMBER)
61 RETURN number IS
62
63 l_api_name CONSTANT VARCHAR2(30) := 'Get_Funding_Source_Id';
64
65 l_funding_source_id NUMBER;
66
67 BEGIN
68
69 null;
70
71 END Get_Funding_Source_Id;
72
73 ---------------------------------------------------------------------------
74
75 FUNCTION Get_Award_Manager_Id(p_award_manager_name VARCHAR2,p_award_manager_id NUMBER)
76 RETURN number IS
77
78 l_api_name CONSTANT VARCHAR2(30) := 'Get_Award_Manager_Id';
79
80 l_award_manager_id NUMBER;
81
82 BEGIN
83
84 null;
85
86 END Get_Award_Manager_Id;
87
88 ---------------------------------------------------------------------------
89
90 FUNCTION Get_Allowable_Schedule_Id( p_allowable_schedule_desc VARCHAR2 )
91 RETURN number IS
92
93 l_api_name CONSTANT VARCHAR2(30) := 'Get_Allowable_Schedule_Id';
94
95 l_allowable_schedule_id NUMBER;
96
97 BEGIN
98
99 null;
100
101 END Get_Allowable_Schedule_Id;
102
103 ---------------------------------------------------------------------------
104
105 FUNCTION Get_Indirect_Schedule_Id( p_indirect_schedule_desc VARCHAR2 )
106 RETURN number IS
107
108 l_api_name CONSTANT VARCHAR2(30) := 'Get_Indirect_Schedule_Id';
109
110 l_indirect_schedule_id NUMBER;
111
112 BEGIN
113 null;
114
115 END Get_Indirect_Schedule_Id;
116
117 ---------------------------------------------------------------------------
118
119 FUNCTION Get_Billing_Term_Id( p_billing_term_desc VARCHAR2 )
120 RETURN number IS
121
122 l_api_name CONSTANT VARCHAR2(30) := 'Get_Billing_Term_Id';
123
124 l_billing_term_id NUMBER;
125
126 BEGIN
127 null;
128
129 END Get_Billing_Term_Id;
130
131 ---------------------------------------------------------------------------
132
133 FUNCTION Get_Billing_Cycle_Id( p_billing_cycle_desc VARCHAR2 )
134 RETURN number IS
135
136 l_api_name CONSTANT VARCHAR2(30) := 'Get_Billing_Cycle_Id';
137
138 l_billing_cycle_id NUMBER;
139
140 BEGIN
141
142 null;
143
144 END Get_Billing_Cycle_Id;
145
146 ---------------------------------------------------------------------------
147
148 FUNCTION Get_Invoice_Format_Id( p_invoice_format_type VARCHAR2,
149 p_invoice_format_desc VARCHAR2 ) RETURN number IS
150
151 l_api_name CONSTANT VARCHAR2(30) := 'Get_Invoice_Format_Id';
152
153 l_invoice_format_id NUMBER;
154
155 BEGIN
156
157 null;
158
159 END Get_Invoice_Format_Id;
160
161 ---------------------------------------------------------------------------
162
163 FUNCTION Get_Award_Organization_Id(p_award_organization_name VARCHAR2,p_award_organization_id NUMBER)
164 RETURN number IS
165
166 l_api_name CONSTANT VARCHAR2(30) := 'Get_Award_Organization_Id';
167
168 l_award_organization_id NUMBER;
169
170 BEGIN
171 null;
172
173 END Get_Award_Organization_Id;
174
175 ---------------------------------------------------------------------------
176
177 FUNCTION Get_Award_Role(p_proposal_role_code VARCHAR2) RETURN VARCHAR2 IS
178
179 l_award_role VARCHAR2(30);
180
181 BEGIN
182 null;
183
184 END Get_Award_Role;
185
186 ---------------------------------------------------------------------------
187
188 PROCEDURE Validate_Award_Number( p_award_number VARCHAR2 ) IS
189
190 l_api_name CONSTANT VARCHAR2(30) := 'Validate_Award_Number';
191
192 l_award_numbering_method VARCHAR2(30);
193 l_count NUMBER;
194
195 l_return_status VARCHAR2(1);
196 l_msg_data VARCHAR2(255);
197 l_msg_count NUMBER;
198
199 BEGIN
200
201 null;
202
203 END Validate_Award_Number;
204
205 ---------------------------------------------------------------------------
206
207 PROCEDURE Validate_Award_Type( p_award_type VARCHAR2 ) IS
208
209 l_api_name CONSTANT VARCHAR2(30) := 'Validate_Award_Type';
210
211 l_valid VARCHAR2(30);
212
213 BEGIN
214
215 null;
216
217 END Validate_Award_Type;
218
219 ---------------------------------------------------------------------------
220
221 PROCEDURE Create_Award_Installment
222 (
223 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
224 p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
225 p_commit IN VARCHAR2 := Fnd_Api.G_False,
226 p_select_option IN VARCHAR2,
227 p_proposal_id IN NUMBER,
228 p_award_template_number IN VARCHAR2,
229 p_award_number1 IN VARCHAR2,
230 p_award_number2 IN VARCHAR2,
231 x_proposal_award_id OUT NOCOPY NUMBER,
232 x_proposal_installment_id OUT NOCOPY NUMBER,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2
236 ) IS
237
238 l_api_name CONSTANT VARCHAR2(30) := 'Create_Award_Installment';
239
240
241
242 BEGIN
243
244 null;
245
246 END Create_Award_Installment;
247
248 ---------------------------------------------------------------------------
249
250 PROCEDURE Create_Award
251 (
252 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
253 p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
254 p_commit IN VARCHAR2 := Fnd_Api.G_False,
255 x_rowid OUT NOCOPY VARCHAR2,
256 x_proposal_award_id OUT NOCOPY NUMBER,
257 p_proposal_id IN NUMBER,
258 p_award_template_id IN NUMBER,
259 p_award_id IN NUMBER,
260 p_award_number IN VARCHAR2,
261 p_award_short_name IN VARCHAR2,
262 p_award_full_name IN VARCHAR2,
263 p_funding_source_name IN VARCHAR2,
264 p_funding_source_id IN NUMBER,
265 p_funding_source_award_number IN VARCHAR2,
266 p_start_date IN DATE,
267 p_end_date IN DATE,
268 p_close_date IN DATE,
269 p_award_type IN VARCHAR2,
270 p_award_purpose_desc IN VARCHAR2,
271 p_award_purpose_code IN VARCHAR2,
272 p_award_organization_name IN VARCHAR2,
273 p_award_organization_id IN NUMBER,
274 p_award_status_desc IN VARCHAR2,
275 p_award_status_code IN VARCHAR2,
276 p_award_manager_name IN VARCHAR2,
277 p_award_manager_id IN NUMBER,
278 p_revenue_distribution_rule IN VARCHAR2,
279 p_billing_distribution_rule IN VARCHAR2,
280 p_billing_term_desc IN VARCHAR2,
281 p_billing_term_id IN NUMBER,
282 p_billing_cycle_desc IN VARCHAR2,
283 p_billing_cycle_id IN NUMBER,
284 p_labor_invoice_format_desc IN VARCHAR2,
285 p_labor_invoice_format_id IN NUMBER,
286 p_non_labor_inv_format_desc IN VARCHAR2,
287 p_non_labor_invoice_format_id IN NUMBER,
288 p_allowable_schedule_desc IN VARCHAR2,
289 p_allowable_schedule_id IN NUMBER,
290 p_indirect_schedule_desc IN VARCHAR2,
291 p_indirect_schedule_id IN NUMBER,
292 p_amount_type_desc IN VARCHAR2,
293 p_amount_type_code IN VARCHAR2,
294 p_boundary_desc IN VARCHAR2,
295 p_boundary_code IN VARCHAR2,
296 p_transfer_as IN VARCHAR2,
297 p_transferred_flag IN VARCHAR2,
298 p_attribute_category IN VARCHAR2,
299 p_attribute1 IN VARCHAR2,
300 p_attribute2 IN VARCHAR2,
301 p_attribute3 IN VARCHAR2,
302 p_attribute4 IN VARCHAR2,
303 p_attribute5 IN VARCHAR2,
304 p_attribute6 IN VARCHAR2,
305 p_attribute7 IN VARCHAR2,
306 p_attribute8 IN VARCHAR2,
307 p_attribute9 IN VARCHAR2,
308 p_attribute10 IN VARCHAR2,
309 p_attribute11 IN VARCHAR2,
310 p_attribute12 IN VARCHAR2,
311 p_attribute13 IN VARCHAR2,
312 p_attribute14 IN VARCHAR2,
313 p_attribute15 IN VARCHAR2,
314 x_return_status OUT NOCOPY VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2
317 ) IS
318
319 l_api_name CONSTANT VARCHAR2(30) := 'Create_Award';
320
321 l_award_manager_id NUMBER;
322 l_start_date DATE;
323 l_end_date DATE;
324 l_close_date DATE;
325 l_award_id NUMBER;
326 l_award_template_id NUMBER;
327 p_award_template_number VARCHAR2(15);
328
329 l_count NUMBER;
330
331 BEGIN
332
333 null;
334
335 END Create_Award;
336
337 ---------------------------------------------------------------------------
338
339 PROCEDURE Update_Award
340 (
341 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
342 p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
343 p_commit IN VARCHAR2 := Fnd_Api.G_False,
344 p_rowid IN VARCHAR2,
345 p_proposal_award_id IN NUMBER,
346 p_record_version_number IN NUMBER,
347 p_proposal_id IN NUMBER,
348 p_award_template_id IN NUMBER,
349 p_award_id IN NUMBER,
350 p_award_number IN VARCHAR2,
351 p_award_short_name IN VARCHAR2,
352 p_award_full_name IN VARCHAR2,
353 p_funding_source_name IN VARCHAR2,
354 p_funding_source_id IN NUMBER,
355 p_funding_source_award_number IN VARCHAR2,
356 p_start_date IN DATE,
357 p_end_date IN DATE,
358 p_close_date IN DATE,
359 p_award_type IN VARCHAR2,
360 p_award_purpose_desc IN VARCHAR2,
361 p_award_purpose_code IN VARCHAR2,
362 p_award_organization_name IN VARCHAR2,
363 p_award_organization_id IN NUMBER,
364 p_award_status_desc IN VARCHAR2,
365 p_award_status_code IN VARCHAR2,
366 p_award_manager_name IN VARCHAR2,
367 p_award_manager_id IN NUMBER,
368 p_revenue_distribution_rule IN VARCHAR2,
369 p_billing_distribution_rule IN VARCHAR2,
370 p_billing_term_desc IN VARCHAR2,
371 p_billing_term_id IN NUMBER,
372 p_billing_cycle_desc IN VARCHAR2,
373 p_billing_cycle_id IN NUMBER,
374 p_labor_invoice_format_desc IN VARCHAR2,
375 p_labor_invoice_format_id IN NUMBER,
376 p_non_labor_inv_format_desc IN VARCHAR2,
377 p_non_labor_invoice_format_id IN NUMBER,
378 p_allowable_schedule_desc IN VARCHAR2,
379 p_allowable_schedule_id IN NUMBER,
380 p_indirect_schedule_desc IN VARCHAR2,
381 p_indirect_schedule_id IN NUMBER,
382 p_amount_type_desc IN VARCHAR2,
383 p_amount_type_code IN VARCHAR2,
384 p_boundary_desc IN VARCHAR2,
385 p_boundary_code IN VARCHAR2,
386 p_transfer_as IN VARCHAR2,
387 p_transferred_flag IN VARCHAR2,
388 p_attribute_category IN VARCHAR2,
389 p_attribute1 IN VARCHAR2,
390 p_attribute2 IN VARCHAR2,
391 p_attribute3 IN VARCHAR2,
392 p_attribute4 IN VARCHAR2,
393 p_attribute5 IN VARCHAR2,
394 p_attribute6 IN VARCHAR2,
395 p_attribute7 IN VARCHAR2,
396 p_attribute8 IN VARCHAR2,
397 p_attribute9 IN VARCHAR2,
398 p_attribute10 IN VARCHAR2,
399 p_attribute11 IN VARCHAR2,
400 p_attribute12 IN VARCHAR2,
401 p_attribute13 IN VARCHAR2,
402 p_attribute14 IN VARCHAR2,
403 p_attribute15 IN VARCHAR2,
404 x_return_status OUT NOCOPY VARCHAR2,
405 x_msg_count OUT NOCOPY NUMBER,
406 x_msg_data OUT NOCOPY VARCHAR2
407 ) IS
408
409 l_api_name CONSTANT VARCHAR2(30) := 'Update_Award';
410
411 l_funding_source_id NUMBER(15);
412 l_award_purpose_code VARCHAR2(30);
413 l_award_organization_id NUMBER(15);
414 l_award_status_code VARCHAR2(30);
415 l_award_manager_id NUMBER(15);
416 l_billing_term_id NUMBER(15);
417 l_billing_cycle_id NUMBER(15);
418 l_labor_invoice_format_id NUMBER(15);
419 l_non_labor_invoice_format_id NUMBER(15);
420 l_allowable_schedule_id NUMBER(15);
421 l_indirect_schedule_id NUMBER(15);
422 l_amount_type_code VARCHAR2(30);
423 l_boundary_code VARCHAR2(30);
424
425 l_count NUMBER;
426
427 BEGIN
428
429 null;
430
431 END Update_Award;
432
433 ---------------------------------------------------------------------------
434
435 PROCEDURE Delete_Award
436 (
437 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
438 p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
439 p_commit IN VARCHAR2 := Fnd_Api.G_False,
440 p_proposal_award_id IN NUMBER,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2
444 ) IS
445
446 l_api_name CONSTANT VARCHAR2(30) := 'Delete_Award';
447
448 BEGIN
449 null;
450 END Delete_Award;
451
452 ---------------------------------------------------------------------------
453
454 PROCEDURE Transfer_Award_Installment
455 (
456 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
457 p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
458 p_commit IN VARCHAR2 := Fnd_Api.G_False,
459 p_proposal_award_id IN NUMBER,
460 p_proposal_installment_id IN NUMBER,
461 x_award_id OUT NOCOPY NUMBER,
462 x_return_status OUT NOCOPY VARCHAR2,
463 x_msg_count OUT NOCOPY NUMBER,
464 x_msg_data OUT NOCOPY VARCHAR2
465 ) IS
466
467 BEGIN
468 null;
469 END Transfer_Award_Installment;
470
471 ---------------------------------------------------------------------------
472
473 PROCEDURE Delete_Temp_Award(p_proposal_award_id IN NUMBER) IS
474
475 l_temporary_flag VARCHAR2(1);
476 l_return_status VARCHAR2(1);
477
478 BEGIN
479
480 null;
481
482 END Delete_Temp_Award;
483
484 ---------------------------------------------------------------------------
485
486 PROCEDURE Make_Permanent(p_proposal_award_id IN NUMBER) IS
487 BEGIN
488
489 null;
490
491 END Make_Permanent;
492
493 ---------------------------------------------------------------------------
494
495 END Igw_Awards_Pvt;