[Home] [Help]
PACKAGE BODY: APPS.POR_GLOBAL_PKG
Source
1 PACKAGE BODY por_global_pkg AS
2 /* $Header: PORGLOBB.pls 120.2 2011/01/24 12:14:15 krsethur ship $ */
3
4
5 -- Customize this procedure to add custom gloabalization defaulting logic for all the
6 -- attributes on a requisition header.
7 -- This is called when a new requisition gets created.
8 -- The attribute id's are passed as IN OUT NOCOPY parameters to this procedure and
9 -- can be modified to reflect any custom defaulting logic.
10
11 PROCEDURE CUSTOM_DEFAULT_REQ_HEADER (
12 req_header_id IN NUMBER, -- 1
13 old_req_header_id IN NUMBER, -- 2
14 req_num IN VARCHAR2, -- 3
15 preparer_id IN NUMBER, -- 4
16 x_req_type IN OUT NOCOPY VARCHAR2, -- 5
17 x_emergency_po_num IN OUT NOCOPY VARCHAR2, -- 6
18 x_approval_status_code IN OUT NOCOPY VARCHAR2, -- 7
19 x_cancel_flag IN OUT NOCOPY VARCHAR2, -- 8
20 x_closed_code IN OUT NOCOPY VARCHAR2, -- 9
21 x_org_id IN OUT NOCOPY NUMBER, -- 10
22 x_wf_item_type IN OUT NOCOPY VARCHAR2, -- 11
23 x_wf_item_key IN OUT NOCOPY VARCHAR2, -- 12
24 x_pcard_id IN OUT NOCOPY NUMBER, -- 13
25 x_attribute1 IN OUT NOCOPY VARCHAR2, -- 14
26 x_attribute2 IN OUT NOCOPY VARCHAR2, -- 15
27 x_attribute3 IN OUT NOCOPY VARCHAR2, -- 16
28 x_attribute4 IN OUT NOCOPY VARCHAR2, -- 17
29 x_attribute5 IN OUT NOCOPY VARCHAR2, -- 18
30 x_attribute6 IN OUT NOCOPY VARCHAR2, -- 19
31 x_attribute7 IN OUT NOCOPY VARCHAR2, -- 20
32 x_attribute8 IN OUT NOCOPY VARCHAR2, -- 21
33 x_attribute9 IN OUT NOCOPY VARCHAR2, -- 22
34 x_attribute10 IN OUT NOCOPY VARCHAR2, -- 23
35 x_attribute11 IN OUT NOCOPY VARCHAR2, -- 24
36 x_attribute12 IN OUT NOCOPY VARCHAR2, -- 25
37 x_attribute13 IN OUT NOCOPY VARCHAR2, -- 26
38 x_attribute14 IN OUT NOCOPY VARCHAR2, -- 27
39 x_attribute15 IN OUT NOCOPY VARCHAR2, -- 28
40 x_return_code OUT NOCOPY NUMBER, -- 29
41 x_error_msg OUT NOCOPY VARCHAR2 -- 30
42 )
43 is
44 BEGIN
45 JG_PO_EXTENSION_PKG.CUSTOM_DEFAULT_REQ_HEADER (
46 req_header_id ,
47 old_req_header_id ,
48 req_num ,
49 preparer_id ,
50 x_req_type ,
51 x_emergency_po_num ,
52 x_approval_status_code ,
53 x_cancel_flag ,
54 x_closed_code ,
55 x_org_id ,
56 x_wf_item_type ,
57 x_wf_item_key ,
58 x_pcard_id ,
59 x_attribute1 ,
60 x_attribute2 ,
61 x_attribute3 ,
62 x_attribute4 ,
63 x_attribute5 ,
64 x_attribute6 ,
65 x_attribute7 ,
66 x_attribute8 ,
67 x_attribute9 ,
68 x_attribute10 ,
69 x_attribute11 ,
70 x_attribute12 ,
71 x_attribute13 ,
72 x_attribute14 ,
73 x_attribute15 ,
74 x_return_code ,
75 x_error_msg
76 );
77
78 END CUSTOM_DEFAULT_REQ_HEADER;
79
80
81 -- Customize this procedure to add logic for validation related to globalization
82 -- of the attribute values
83 -- on a requisition header. This would be any custom validation, that would
84 -- be in addition to all the validations done for a requisition header.
85 -- The return_msg and the error_code can be used to return the results of
86 -- the validation
87 -- The return code can be used to indicate on which tab the error message
88 -- needs to be displayed on the Edit Lines page
89 -- If the result code is 1, error is displayed on the Delivery tab
90 -- If the result code is 2, error is displayed on the Billing tab
91 -- If the result code is 3, error is displayed on the Accounts tab
92
93 PROCEDURE CUSTOM_VALIDATE_REQ_HEADER (
94 req_header_id IN NUMBER, -- 1
95 req_num IN VARCHAR2, -- 2
96 preparer_id IN NUMBER, -- 3
97 req_type IN VARCHAR2, -- 4
98 emergency_po_num IN VARCHAR2, -- 5
99 approval_status_code IN VARCHAR2, -- 6
100 cancel_flag IN VARCHAR2, -- 7
101 closed_code IN VARCHAR2, -- 8
102 org_id IN NUMBER, -- 9
103 wf_item_type IN VARCHAR2, -- 10
104 wf_item_key IN VARCHAR2, -- 11
105 pcard_id IN NUMBER, -- 12
106 attribute1 IN VARCHAR2, -- 13
107 attribute2 IN VARCHAR2, -- 14
108 attribute3 IN VARCHAR2, -- 15
109 attribute4 IN VARCHAR2, -- 16
110 attribute5 IN VARCHAR2, -- 17
111 attribute6 IN VARCHAR2, -- 18
112 attribute7 IN VARCHAR2, -- 19
113 attribute8 IN VARCHAR2, -- 20
114 attribute9 IN VARCHAR2, -- 21
115 attribute10 IN VARCHAR2, -- 22
116 attribute11 IN VARCHAR2, -- 23
117 attribute12 IN VARCHAR2, -- 24
118 attribute13 IN VARCHAR2, -- 25
119 attribute14 IN VARCHAR2, -- 26
120 attribute15 IN VARCHAR2, -- 27
121 x_return_code OUT NOCOPY NUMBER, -- 28
122 x_error_msg OUT NOCOPY VARCHAR2 -- 29
123 )
124 IS
125 BEGIN
126 JG_PO_EXTENSION_PKG.CUSTOM_VALIDATE_REQ_HEADER (
127 req_header_id ,
128 req_num ,
129 preparer_id ,
130 req_type ,
131 emergency_po_num ,
132 approval_status_code ,
133 cancel_flag ,
134 closed_code ,
135 org_id ,
136 wf_item_type ,
137 wf_item_key ,
138 pcard_id ,
139 attribute1 ,
140 attribute2 ,
141 attribute3 ,
142 attribute4 ,
143 attribute5 ,
144 attribute6 ,
145 attribute7 ,
146 attribute8 ,
147 attribute9 ,
148 attribute10 ,
149 attribute11 ,
150 attribute12 ,
151 attribute13 ,
152 attribute14 ,
153 attribute15 ,
154 x_return_code ,
155 x_error_msg
156 );
157
158 END CUSTOM_VALIDATE_REQ_HEADER;
159
160
161 -- Customize this procedure to add custom globalization defaulting logic for all the
162 -- attributes on a requisition line.
163 -- This is called when a new line gets added to the requisition.
164 -- The attribute id's are passed as IN OUT NOCOPY parameters to this procedure and
165 -- can be modified to reflect any custom defaulting logic.
166 -- The values corresponding to the id's are recalculated in the calling ReqLine
167 -- Java class
168
169 PROCEDURE CUSTOM_DEFAULT_REQ_LINE (
170 -- READ ONLY data
171 req_header_id IN NUMBER, -- 1
172 req_line_id IN NUMBER, -- 2
173 old_req_line_id IN NUMBER, -- 3
174 line_num IN NUMBER, -- 4
175
176 -- header data
177 preparer_id IN NUMBER, -- 5
178 header_attribute_1 IN VARCHAR2, -- 6
179 header_attribute_2 IN VARCHAR2, -- 7
180 header_attribute_3 IN VARCHAR2, -- 8
181 header_attribute_4 IN VARCHAR2, -- 9
182 header_attribute_5 IN VARCHAR2, -- 10
183 header_attribute_6 IN VARCHAR2, -- 11
184 header_attribute_7 IN VARCHAR2, -- 12
185 header_attribute_8 IN VARCHAR2, -- 13
186 header_attribute_9 IN VARCHAR2, -- 14
187 header_attribute_10 IN VARCHAR2, -- 15
188 header_attribute_11 IN VARCHAR2, -- 16
189 header_attribute_12 IN VARCHAR2, -- 17
190 header_attribute_13 IN VARCHAR2, -- 18
191 header_attribute_14 IN VARCHAR2, -- 19
192 header_attribute_15 IN VARCHAR2, -- 20
193
194 -- line data: update any of the following parameters as default for line
195 x_line_type_id IN OUT NOCOPY NUMBER, -- 21
196 x_item_id IN OUT NOCOPY NUMBER, -- 22
197 x_item_revision IN OUT NOCOPY VARCHAR2, -- 23
198 x_category_id IN OUT NOCOPY NUMBER, -- 24
199 x_catalog_source IN OUT NOCOPY VARCHAR2, -- 25
200 x_catalog_type IN OUT NOCOPY VARCHAR2, -- 26
201 x_currency_code IN OUT NOCOPY VARCHAR2, -- 27
202 x_currency_unit_price IN OUT NOCOPY NUMBER, -- 28
203 x_manufacturer_name IN OUT NOCOPY VARCHAR2, -- 29
204 x_manufacturer_part_num IN OUT NOCOPY VARCHAR2, -- 30
205 x_deliver_to_loc_id IN OUT NOCOPY NUMBER, -- 31
206 x_deliver_to_org_id IN OUT NOCOPY NUMBER, -- 32
207 x_deliver_to_subinv IN OUT NOCOPY VARCHAR2, -- 33
208 x_destination_type_code IN OUT NOCOPY VARCHAR2, -- 34
209 x_requester_id IN OUT NOCOPY NUMBER, -- 35
210 x_encumbered_flag IN OUT NOCOPY VARCHAR2, -- 36
211 x_hazard_class_id IN OUT NOCOPY NUMBER, -- 37
212 x_modified_by_buyer IN OUT NOCOPY VARCHAR2, -- 38
213 x_need_by_date IN OUT NOCOPY DATE, -- 39
214 x_new_supplier_flag IN OUT NOCOPY VARCHAR2, -- 40
215 x_on_rfq_flag IN OUT NOCOPY VARCHAR2, -- 41
216 x_org_id IN OUT NOCOPY NUMBER, -- 42
217 x_parent_req_line_id IN OUT NOCOPY NUMBER, -- 43
218 x_po_line_loc_id IN OUT NOCOPY NUMBER, -- 44
219 x_qty_cancelled IN OUT NOCOPY NUMBER, -- 45
220 x_qty_delivered IN OUT NOCOPY NUMBER, -- 46
221 x_qty_ordered IN OUT NOCOPY NUMBER, -- 47
222 x_qty_received IN OUT NOCOPY NUMBER, -- 48
223 x_rate IN OUT NOCOPY NUMBER, -- 49
224 x_rate_date IN OUT NOCOPY DATE, -- 50
225 x_rate_type IN OUT NOCOPY VARCHAR2, -- 51
226 x_rfq_required IN OUT NOCOPY VARCHAR2, -- 52
227 x_source_type_code IN OUT NOCOPY VARCHAR2, -- 53
228 x_spsc_code IN OUT NOCOPY VARCHAR2, -- 54
229 x_other_category_code IN OUT NOCOPY VARCHAR2, -- 55
230 x_suggested_buyer_id IN OUT NOCOPY NUMBER, -- 56
231 x_source_doc_header_id IN OUT NOCOPY NUMBER, -- 57
232 x_source_doc_line_num IN OUT NOCOPY NUMBER, -- 58
233 x_source_doc_type_code IN OUT NOCOPY VARCHAR2, -- 59
234 x_supplier_duns IN OUT NOCOPY VARCHAR2, -- 60
235 x_supplier_item_num IN OUT NOCOPY VARCHAR2, -- 61
236 x_taxable_status IN OUT NOCOPY VARCHAR2, -- 62
237 x_unit_of_measure IN OUT NOCOPY VARCHAR2, -- 63
238 x_unit_price IN OUT NOCOPY NUMBER, -- 64
239 x_urgent IN OUT NOCOPY VARCHAR2, -- 65
240 x_supplier_contact_id IN OUT NOCOPY NUMBER, -- 66
241 x_supplier_id IN OUT NOCOPY NUMBER, -- 67
242 x_supplier_site_id IN OUT NOCOPY NUMBER, -- 68
243 x_cancel_date IN OUT NOCOPY DATE, -- 69
244 x_cancel_flag IN OUT NOCOPY VARCHAR2, -- 70
245 x_closed_code IN OUT NOCOPY VARCHAR2, -- 71
246 x_closed_date IN OUT NOCOPY DATE, -- 72
247 x_auto_receive_flag IN OUT NOCOPY VARCHAR2, -- 73
248 x_pcard_flag IN OUT NOCOPY VARCHAR2, -- 74
249 x_attribute1 IN OUT NOCOPY VARCHAR2, -- 75
250 x_attribute2 IN OUT NOCOPY VARCHAR2, -- 76
251 x_attribute3 IN OUT NOCOPY VARCHAR2, -- 77
252 x_attribute4 IN OUT NOCOPY VARCHAR2, -- 78
253 x_attribute5 IN OUT NOCOPY VARCHAR2, -- 79
254 x_attribute6 IN OUT NOCOPY VARCHAR2, -- 80
255 x_attribute7 IN OUT NOCOPY VARCHAR2, -- 81
256 x_attribute8 IN OUT NOCOPY VARCHAR2, -- 82
257 x_attribute9 IN OUT NOCOPY VARCHAR2, -- 83
258 x_attribute10 IN OUT NOCOPY VARCHAR2, -- 84
259 x_attribute11 IN OUT NOCOPY VARCHAR2, -- 85
260 x_attribute12 IN OUT NOCOPY VARCHAR2, -- 86
261 x_attribute13 IN OUT NOCOPY VARCHAR2, -- 87
262 x_attribute14 IN OUT NOCOPY VARCHAR2, -- 88
263 x_attribute15 IN OUT NOCOPY VARCHAR2, -- 89
264 X_return_code OUT NOCOPY NUMBER, -- 90
265 X_error_msg OUT NOCOPY VARCHAR2, -- 91
266 x_supplierContact IN OUT NOCOPY VARCHAR2, -- 92
267 x_supplierContactPhone IN OUT NOCOPY VARCHAR2, -- 93
268 x_supplier IN OUT NOCOPY VARCHAR2, -- 94
269 x_supplierSite IN OUT NOCOPY VARCHAR2, -- 95
270 x_taxCodeId IN OUT NOCOPY NUMBER, -- 96
271 x_source_org_id IN OUT NOCOPY NUMBER, -- 97
272 x_txn_reason_code IN OUT NOCOPY VARCHAR2 -- 98
273
274
275 )
276 IS
277 BEGIN
278 JG_PO_EXTENSION_PKG.CUSTOM_DEFAULT_REQ_LINE (
279 req_header_id ,
280 req_line_id ,
281 old_req_line_id ,
282 line_num ,
283 preparer_id ,
284 header_attribute_1 ,
285 header_attribute_2 ,
286 header_attribute_3 ,
287 header_attribute_4 ,
288 header_attribute_5 ,
289 header_attribute_6 ,
290 header_attribute_7 ,
291 header_attribute_8 ,
292 header_attribute_9 ,
293 header_attribute_10 ,
294 header_attribute_11 ,
295 header_attribute_12 ,
296 header_attribute_13 ,
297 header_attribute_14 ,
298 header_attribute_15 ,
299 x_line_type_id ,
300 x_item_id ,
301 x_item_revision ,
302 x_category_id ,
303 x_catalog_source ,
304 x_catalog_type ,
305 x_currency_code ,
306 x_currency_unit_price ,
307 x_manufacturer_name ,
308 x_manufacturer_part_num ,
309 x_deliver_to_loc_id ,
310 x_deliver_to_org_id ,
311 x_deliver_to_subinv ,
312 x_destination_type_code ,
313 x_requester_id ,
314 x_encumbered_flag ,
315 x_hazard_class_id ,
316 x_modified_by_buyer ,
317 x_need_by_date ,
318 x_new_supplier_flag ,
319 x_on_rfq_flag ,
323 x_qty_cancelled ,
320 x_org_id ,
321 x_parent_req_line_id ,
322 x_po_line_loc_id ,
324 x_qty_delivered ,
325 x_qty_ordered ,
326 x_qty_received ,
327 x_rate ,
328 x_rate_date ,
329 x_rate_type ,
330 x_rfq_required ,
331 x_source_type_code ,
332 x_spsc_code ,
333 x_other_category_code ,
334 x_suggested_buyer_id ,
335 x_source_doc_header_id ,
336 x_source_doc_line_num ,
337 x_source_doc_type_code ,
338 x_supplier_duns ,
339 x_supplier_item_num ,
340 x_taxable_status ,
341 x_unit_of_measure ,
342 x_unit_price ,
343 x_urgent ,
344 x_supplier_contact_id ,
345 x_supplier_id ,
346 x_supplier_site_id ,
347 x_cancel_date ,
348 x_cancel_flag ,
349 x_closed_code ,
350 x_closed_date ,
351 x_auto_receive_flag ,
352 x_pcard_flag ,
353 x_attribute1 ,
354 x_attribute2 ,
355 x_attribute3 ,
356 x_attribute4 ,
357 x_attribute5 ,
358 x_attribute6 ,
359 x_attribute7 ,
360 x_attribute8 ,
361 x_attribute9 ,
362 x_attribute10 ,
363 x_attribute11 ,
364 x_attribute12 ,
365 x_attribute13 ,
366 x_attribute14 ,
367 x_attribute15 ,
368 X_return_code ,
369 X_error_msg ,
370 x_supplierContact ,
371 x_supplierContactPhone ,
372 x_supplier ,
373 x_supplierSite ,
374 x_taxCodeId ,
375 x_source_org_id ,
376 x_txn_reason_code
377 );
378
379 END;
380
381
382 -- Customize this procedure to add logic for validation related to globalization of the attribute values
383 -- on a requisition line. This would be any custom validation, that would be
384 -- in addition to all the validations done for a requisition line
385 -- This is called whenever the requisition line gets updated and is called
386 -- on every page in the checkOUT NOCOPY flow.
387 -- The return_msg and the error_code can be used to return the results of
388 -- the validation
389 -- The return code can be used to indicate on which tab the error message
390 -- needs to be displayed on the Edit Lines page
391 -- If the result code is 1, error is displayed on the Delivery tab
392 -- If the result code is 2, error is displayed on the Billing tab
393 -- If the result code is 3, error is displayed on the Accounts tab
394
395
396 PROCEDURE CUSTOM_VALIDATE_REQ_LINE (
397 x_req_header_id IN NUMBER, -- 1
398 x_req_line_id IN NUMBER, -- 2
399 x_line_num IN NUMBER, -- 3
400
401
402 -- header data
403 preparer_id IN NUMBER, -- 4
404 header_attribute_1 IN VARCHAR2, -- 5
405 header_attribute_2 IN VARCHAR2, -- 6
406 header_attribute_3 IN VARCHAR2, -- 7
407 header_attribute_4 IN VARCHAR2, -- 8
408 header_attribute_5 IN VARCHAR2, -- 9
409 header_attribute_6 IN VARCHAR2, -- 10
410 header_attribute_7 IN VARCHAR2, -- 11
411 header_attribute_8 IN VARCHAR2, -- 12
412 header_attribute_9 IN VARCHAR2, -- 13
413 header_attribute_10 IN VARCHAR2, -- 14
414 header_attribute_11 IN VARCHAR2, -- 15
415 header_attribute_12 IN VARCHAR2, -- 16
416 header_attribute_13 IN VARCHAR2, -- 17
417 header_attribute_14 IN VARCHAR2, -- 18
418 header_attribute_15 IN VARCHAR2, -- 19
419
420 -- line data
421 line_type_id IN NUMBER, -- 20
422 item_id IN NUMBER, -- 21
423 item_revision IN VARCHAR2, -- 22
424 category_id IN NUMBER, -- 23
425 catalog_source IN VARCHAR2, -- 24
426 catalog_type IN VARCHAR2, -- 25
427 currency_code IN VARCHAR2, -- 26
428 currency_unit_price IN NUMBER, -- 27
429 manufacturer_name IN VARCHAR2, --28
430 manufacturer_part_num IN VARCHAR2, -- 29
431 deliver_to_loc_id IN NUMBER, -- 30
432 deliver_to_org_id IN NUMBER, -- 31
433 deliver_to_subinv IN VARCHAR2, -- 32
434 destination_type_code IN VARCHAR2, -- 33
435 requester_id IN NUMBER, -- 34
436 encumbered_flag IN VARCHAR2, -- 35
437 hazard_class_id IN NUMBER, -- 36
438 modified_by_buyer IN VARCHAR2, -- 37
439 need_by_date IN DATE, -- 38
440 new_supplier_flag IN VARCHAR2, -- 39
441 on_rfq_flag IN VARCHAR2, -- 40
442 org_id IN NUMBER, -- 41
443 parent_req_line_id IN NUMBER, -- 42
444 po_line_loc_id IN NUMBER, -- 43
445 qty_cancelled IN NUMBER, -- 44
446 qty_delivered IN NUMBER, -- 45
447 qty_ordered IN NUMBER, -- 46
448 qty_received IN NUMBER, -- 47
452 rfq_required IN VARCHAR2, -- 51
449 rate IN NUMBER, -- 48
450 rate_date IN DATE, -- 49
451 rate_type IN VARCHAR2, -- 50
453 source_type_code IN VARCHAR2, -- 52
454 spsc_code IN VARCHAR2, -- 53
455 other_category_code IN VARCHAR2, -- 54
456 suggested_buyer_id IN OUT NOCOPY NUMBER, -- 55
457 source_doc_header_id IN NUMBER, -- 56
458 source_doc_line_num IN NUMBER, -- 57
459 source_doc_type_code IN VARCHAR2, -- 58
460 supplier_duns IN VARCHAR2, -- 59
461 supplier_item_num IN VARCHAR2, -- 60
462 taxable_status IN VARCHAR2, -- 61
463 unit_of_measure IN VARCHAR2, -- 62
464 unit_price IN NUMBER, -- 63
465 urgent IN VARCHAR2, -- 64
466 supplier_contact_id IN NUMBER, -- 65
467 supplier_id IN NUMBER, -- 66
468 supplier_site_id IN NUMBER, -- 67
469 cancel_date IN DATE, -- 68
470 cancel_flag IN VARCHAR2, -- 69
471 closed_code IN VARCHAR2, -- 70
472 closed_date IN DATE, -- 71
473 auto_receive_flag IN VARCHAR2, -- 72
474 pcard_flag IN VARCHAR2, -- 73
475 attribute1 IN VARCHAR2, -- 74
476 attribute2 IN VARCHAR2, -- 75
477 attribute3 IN VARCHAR2, -- 76
478 attribute4 IN VARCHAR2, -- 77
479 attribute5 IN VARCHAR2, -- 78
480 attribute6 IN VARCHAR2, -- 79
481 attribute7 IN VARCHAR2, -- 80
482 attribute8 IN VARCHAR2, -- 81
483 attribute9 IN VARCHAR2, -- 82
484 attribute10 IN VARCHAR2, -- 83
485 attribute11 IN VARCHAR2, -- 84
486 attribute12 IN VARCHAR2, -- 85
487 attribute13 IN VARCHAR2, -- 86
488 attribute14 IN VARCHAR2, -- 87
489 attribute15 IN VARCHAR2, -- 88
490 x_taxCodeId IN NUMBER, -- 89
491 x_return_code OUT NOCOPY NUMBER, -- 90 no error
492 x_error_msg OUT NOCOPY VARCHAR2, -- 91
493 x_source_org_id IN NUMBER, -- 92
494 x_txn_reason_code IN VARCHAR2 -- 93
495
496 )
497 IS
498 BEGIN
499 JG_PO_EXTENSION_PKG.CUSTOM_VALIDATE_REQ_LINE (
500 x_req_header_id ,
501 x_req_line_id ,
502 x_line_num ,
503
504 -- header data
505 preparer_id ,
506 header_attribute_1 ,
507 header_attribute_2 ,
508 header_attribute_3 ,
509 header_attribute_4 ,
510 header_attribute_5 ,
511 header_attribute_6 ,
512 header_attribute_7 ,
513 header_attribute_8 ,
514 header_attribute_9 ,
515 header_attribute_10 ,
516 header_attribute_11 ,
517 header_attribute_12 ,
518 header_attribute_13 ,
519 header_attribute_14 ,
520 header_attribute_15 ,
521
522 -- line data
523 line_type_id ,
524 item_id ,
525 item_revision ,
526 category_id ,
527 catalog_source ,
528 catalog_type ,
529 currency_code ,
530 currency_unit_price ,
531 manufacturer_name ,
532 manufacturer_part_num ,
533 deliver_to_loc_id ,
534 deliver_to_org_id ,
535 deliver_to_subinv ,
536 destination_type_code ,
537 requester_id ,
538 encumbered_flag ,
539 hazard_class_id ,
540 modified_by_buyer ,
541 need_by_date ,
542 new_supplier_flag ,
543 on_rfq_flag ,
544 org_id ,
545 parent_req_line_id ,
546 po_line_loc_id ,
547 qty_cancelled ,
548 qty_delivered ,
549 qty_ordered ,
550 qty_received ,
551 rate ,
552 rate_date ,
553 rate_type ,
554 rfq_required ,
555 source_type_code ,
556 spsc_code ,
557 other_category_code ,
558 suggested_buyer_id ,
559 source_doc_header_id ,
560 source_doc_line_num ,
561 source_doc_type_code ,
562 supplier_duns ,
563 supplier_item_num ,
564 taxable_status ,
565 unit_of_measure ,
566 unit_price ,
567 urgent ,
568 supplier_contact_id ,
569 supplier_id ,
570 supplier_site_id ,
571 cancel_date ,
572 cancel_flag ,
573 closed_code ,
574 closed_date ,
575 auto_receive_flag ,
576 pcard_flag ,
577 attribute1 ,
581 attribute5 ,
578 attribute2 ,
579 attribute3 ,
580 attribute4 ,
582 attribute6 ,
583 attribute7 ,
584 attribute8 ,
585 attribute9 ,
586 attribute10 ,
587 attribute11 ,
588 attribute12 ,
589 attribute13 ,
590 attribute14 ,
591 attribute15 ,
592 x_taxCodeId ,
593 x_return_code ,
594 x_error_msg ,
595 x_source_org_id ,
596 x_txn_reason_code
597 );
598
599 END;
600
601
602
603
604 -- Customize this procedure to add custom globalization defaulting logic for all the
605 -- attributes on a requisition distribution.
606 -- This is called when a new distribution gets added to the requisition.
607 -- The attribute id's are passed as IN OUT NOCOPY parameters to this procedure and
608 -- can be modified to reflect any custom defaulting logic.
609
610 PROCEDURE CUSTOM_DEFAULT_REQ_DIST (
611 x_distribution_id IN NUMBER, -- 1
612 x_old_distribution_id IN NUMBER, -- 2
613 x_code_combination_id IN OUT NOCOPY NUMBER, -- 3
614 x_budget_account_id IN OUT NOCOPY NUMBER, -- 4
615 x_variance_account_id IN OUT NOCOPY NUMBER, -- 5
616 x_accrual_account_id IN OUT NOCOPY NUMBER, -- 6
617 project_id IN OUT NOCOPY NUMBER, -- 7
618 task_id IN OUT NOCOPY NUMBER, -- 8
619 expenditure_type IN OUT NOCOPY VARCHAR2, -- 9
620 expenditure_organization_id IN OUT NOCOPY NUMBER, -- 10
621 expenditure_item_date IN OUT NOCOPY DATE, -- 11
622 award_id IN OUT NOCOPY NUMBER, -- 12
623 gl_encumbered_date IN OUT NOCOPY DATE, -- 13
624 gl_period_name IN OUT NOCOPY VARCHAR2, -- 14
625 gl_cancelled_date IN OUT NOCOPY DATE, -- 15
626 gl_closed_date IN OUT NOCOPY DATE,--16
627 gl_date IN OUT NOCOPY DATE,--17
628 gl_encumbered_period IN OUT NOCOPY VARCHAR2,--18
629 recovery_rate IN OUT NOCOPY NUMBER, -- 19
630 tax_recovery_override_flag IN OUT NOCOPY VARCHAR2, -- 20
631 chart_of_accounts_id IN NUMBER, -- 21
632 category_id IN NUMBER, -- 22
633 catalog_source IN VARCHAR2, -- 23
634 catalog_type IN VARCHAR2, -- 24
635 destination_type_code IN VARCHAR2, -- 25
636 deliver_to_location_id IN NUMBER, -- 26
637 destination_organization_id IN NUMBER, -- 27
638 destination_subinventory IN VARCHAR2, -- 28
639 item_id IN NUMBER, -- 29
640 sob_id IN NUMBER, -- 30
641 currency_code IN VARCHAR2, -- 31
642 currency_unit_price IN NUMBER, -- 32
643 manufacturer_name IN VARCHAR2, -- 33
644 manufacturer_part_num IN VARCHAR2,-- 34
645 need_by_date IN DATE, -- 35
646 new_supplier_flag IN VARCHAR2, -- 36
647 business_org_id IN NUMBER, -- 37
648 org_id IN NUMBER, -- 38
649 employee_id IN NUMBER, -- 39
650 employee_org_id IN NUMBER, -- 40
651 default_code_combination_id IN NUMBER, -- 41
652 parent_req_line_id IN NUMBER, -- 42
653 qty_cancelled IN NUMBER, -- 43
654 qty_delivered IN NUMBER, -- 44
655 qty_ordered IN NUMBER, -- 45
656 qty_received IN NUMBER, -- 46
657 rate IN NUMBER, -- 47
658 rate_date IN DATE, -- 48
659 rate_type IN VARCHAR2, -- 49
660 source_type_code IN VARCHAR2, -- 50
661 spsc_code IN VARCHAR2, -- 51
662 suggested_buyer_id IN NUMBER, -- 52
663 source_doc_header_id IN NUMBER, -- 53
664 source_doc_line_num IN NUMBER, -- 54
665 source_doc_type_code IN VARCHAR2, -- 55
666 supplier_item_num IN VARCHAR2, -- 56
667 taxable_status IN VARCHAR2, -- 57
668 unit_of_measure IN VARCHAR2, -- 58
669 unit_price IN NUMBER, -- 59
670 supplier_contact_id IN NUMBER, -- 60
671 supplier_id IN NUMBER, -- 61
672 supplier_site_id IN NUMBER, -- 62
673 pcard_flag IN VARCHAR2, -- 63
674 line_type_id IN NUMBER, -- 64
675 taxCodeId IN NUMBER, -- 65
676 results_billable_flag IN VARCHAR2,-- 66
677 preparer_id IN NUMBER, -- 67
678 deliver_to_person_id IN NUMBER, -- 68
679 po_encumberance_flag IN VARCHAR2, -- 69
680 DATE_FORMAT IN VARCHAR2, -- 70
681 header_att1 IN VARCHAR2, -- 71
682 header_att2 IN VARCHAR2, -- 72
683 header_att3 IN VARCHAR2, -- 73
684 header_att4 IN VARCHAR2, -- 74
685 header_att5 IN VARCHAR2, -- 75
686 header_att6 IN VARCHAR2, -- 76
687 header_att7 IN VARCHAR2, -- 77
688 header_att8 IN VARCHAR2, -- 78
689 header_att9 IN VARCHAR2, -- 79
690 header_att10 IN VARCHAR2, -- 80
691 header_att11 IN VARCHAR2, -- 81
692 header_att12 IN VARCHAR2, -- 82
693 header_att13 IN VARCHAR2, -- 83
697 line_att2 IN VARCHAR2, -- 87
694 header_att14 IN VARCHAR2, -- 84
695 header_att15 IN VARCHAR2, -- 85
696 line_att1 IN VARCHAR2, -- 86
698 line_att3 IN VARCHAR2, -- 88
699 line_att4 IN VARCHAR2, -- 89
700 line_att5 IN VARCHAR2, -- 90
701 line_att6 IN VARCHAR2, -- 91
702 line_att7 IN VARCHAR2, -- 92
703 line_att8 IN VARCHAR2, -- 93
704 line_att9 IN VARCHAR2, -- 94
705 line_att10 IN VARCHAR2, -- 95
706 line_att11 IN VARCHAR2, -- 96
707 line_att12 IN VARCHAR2, -- 97
708 line_att13 IN VARCHAR2, -- 98
709 line_att14 IN VARCHAR2, -- 99
710 line_att15 IN VARCHAR2, -- 100
711 distribution_att1 IN OUT NOCOPY VARCHAR2, -- 101
712 distribution_att2 IN OUT NOCOPY VARCHAR2, -- 102
713 distribution_att3 IN OUT NOCOPY VARCHAR2, -- 103
714 distribution_att4 IN OUT NOCOPY VARCHAR2, -- 104
715 distribution_att5 IN OUT NOCOPY VARCHAR2, -- 105
716 distribution_att6 IN OUT NOCOPY VARCHAR2, -- 106
717 distribution_att7 IN OUT NOCOPY VARCHAR2, -- 107
718 distribution_att8 IN OUT NOCOPY VARCHAR2, -- 108
719 distribution_att9 IN OUT NOCOPY VARCHAR2, -- 109
720 distribution_att10 IN OUT NOCOPY VARCHAR2, -- 110
721 distribution_att11 IN OUT NOCOPY VARCHAR2, -- 111
722 distribution_att12 IN OUT NOCOPY VARCHAR2, -- 112
723 distribution_att13 IN OUT NOCOPY VARCHAR2, -- 113
724 distribution_att14 IN OUT NOCOPY VARCHAR2, -- 114
725 distribution_att15 IN OUT NOCOPY VARCHAR2, -- 115
726 result_code OUT NOCOPY NUMBER, -- 116
727 x_error_msg OUT NOCOPY VARCHAR2 -- 117
728 )
729
730 IS
731 BEGIN
732 JG_PO_EXTENSION_PKG.CUSTOM_DEFAULT_REQ_DIST (
733 x_distribution_id ,
734 x_old_distribution_id ,
735 x_code_combination_id ,
736 x_budget_account_id ,
737 x_variance_account_id ,
738 x_accrual_account_id ,
739 project_id ,
740 task_id ,
741 expenditure_type ,
742 expenditure_organization_id ,
743 expenditure_item_date ,
744 award_id ,
745 gl_encumbered_date ,
746 gl_period_name ,
747 gl_cancelled_date ,
748 gl_closed_date ,
749 gl_date ,
750 gl_encumbered_period ,
751 recovery_rate ,
752 tax_recovery_override_flag ,
753 chart_of_accounts_id ,
754 category_id ,
755 catalog_source ,
756 catalog_type ,
757 destination_type_code ,
758 deliver_to_location_id ,
759 destination_organization_id ,
760 destination_subinventory ,
761 item_id ,
762 sob_id ,
763 currency_code ,
764 currency_unit_price ,
765 manufacturer_name ,
766 manufacturer_part_num ,
767 need_by_date ,
768 new_supplier_flag ,
769 business_org_id ,
770 org_id ,
771 employee_id ,
772 employee_org_id ,
773 default_code_combination_id ,
774 parent_req_line_id ,
775 qty_cancelled ,
776 qty_delivered ,
777 qty_ordered ,
778 qty_received ,
779 rate ,
780 rate_date ,
781 rate_type ,
782 source_type_code ,
783 spsc_code ,
784 suggested_buyer_id ,
785 source_doc_header_id ,
786 source_doc_line_num ,
787 source_doc_type_code ,
788 supplier_item_num ,
789 taxable_status ,
790 unit_of_measure ,
791 unit_price ,
792 supplier_contact_id ,
793 supplier_id ,
794 supplier_site_id ,
795 pcard_flag ,
796 line_type_id ,
797 taxCodeId ,
798 results_billable_flag ,
799 preparer_id ,
800 deliver_to_person_id ,
801 po_encumberance_flag ,
802 DATE_FORMAT ,
803 header_att1 ,
804 header_att2 ,
805 header_att3 ,
806 header_att4 ,
807 header_att5 ,
808 header_att6 ,
809 header_att7 ,
810 header_att8 ,
811 header_att9 ,
812 header_att10 ,
813 header_att11 ,
814 header_att12 ,
815 header_att13 ,
816 header_att14 ,
817 header_att15 ,
818 line_att1 ,
819 line_att2 ,
820 line_att3 ,
821 line_att4 ,
822 line_att5 ,
823 line_att6 ,
824 line_att7 ,
825 line_att8 ,
826 line_att9 ,
827 line_att10 ,
828 line_att11 ,
829 line_att12 ,
830 line_att13 ,
831 line_att14 ,
832 line_att15 ,
836 distribution_att4 ,
833 distribution_att1 ,
834 distribution_att2 ,
835 distribution_att3 ,
837 distribution_att5 ,
838 distribution_att6 ,
839 distribution_att7 ,
840 distribution_att8 ,
841 distribution_att9 ,
842 distribution_att10 ,
843 distribution_att11 ,
844 distribution_att12 ,
845 distribution_att13 ,
846 distribution_att14 ,
847 distribution_att15 ,
848 result_code ,
849 x_error_msg
850 );
851
852
853 END;
854
855 -- Customize this procedure to add logic for validation related to globalization of the attribute values
856 -- on a requisition distribution. This would be any custom validation, that
857 -- would be in addition to all the validations done for a requisition
858 -- distribution.
859 -- The return_msg and the error_code can be used to return the results of
860 -- the validation
861 -- The return code can be used to indicate on which tab the error message
862 -- needs to be displayed on the Edit Lines page
863 -- If the result code is 1, error is displayed on the Delivery tab
864 -- If the result code is 2, error is displayed on the Billing tab
865 -- If the result code is 3, error is displayed on the Accounts tab
866
867 PROCEDURE CUSTOM_VALIDATE_REQ_DIST (
868
869 x_distribution_id IN NUMBER, -- 1
870 x_code_combination_id IN NUMBER, -- 2
871 x_budget_account_id IN NUMBER, -- 3
872 x_variance_account_id IN NUMBER, -- 4
873 x_accrual_account_id IN NUMBER, -- 5
874 project_id IN NUMBER, -- 6
875 task_id IN NUMBER, -- 7
876 expenditure_type IN VARCHAR2, -- 8
877 expenditure_organization_id IN NUMBER, -- 9
878 expenditure_item_date IN DATE, -- 10
879 award_id IN NUMBER, -- 11
880 gl_encumbered_date IN DATE, -- 12
881 gl_period_name IN VARCHAR2, -- 13
882 gl_cancelled_date IN DATE, -- 14
883 gl_closed_date IN DATE,--15
884 gl_date IN DATE,--16
885 gl_encumbered_period IN VARCHAR2,--17
886 recovery_rate IN NUMBER, -- 18
887 tax_recovery_override_flag IN VARCHAR2, -- 19
888 chart_of_accounts_id IN NUMBER, -- 20
889 category_id IN NUMBER, -- 21
890 catalog_source IN VARCHAR2, -- 22
891 catalog_type IN VARCHAR2, -- 23
892 destination_type_code IN VARCHAR2, -- 24
893 deliver_to_location_id IN NUMBER, -- 25
894 destination_organization_id IN NUMBER, -- 26
895 destination_subinventory IN VARCHAR2, -- 27
896 item_id IN NUMBER, -- 28
897 sob_id IN NUMBER, -- 29
898 currency_code IN VARCHAR2, -- 30
899 currency_unit_price IN NUMBER, -- 31
900 manufacturer_name IN VARCHAR2, --32
901 manufacturer_part_num IN VARCHAR2,-- 33
902 need_by_date IN DATE, -- 34
903 new_supplier_flag IN VARCHAR2, -- 35
904 business_org_id IN NUMBER, -- 36
905 org_id IN NUMBER, -- 37
906 employee_id IN NUMBER, -- 38
907 employee_org_id IN NUMBER, -- 39
908 default_code_combination_id IN NUMBER, -- 40
909 parent_req_line_id IN NUMBER, -- 41
910 qty_cancelled IN NUMBER, -- 42
911 qty_delivered IN NUMBER, -- 43
912 qty_ordered IN NUMBER, -- 44
913 qty_received IN NUMBER, -- 45
914 rate IN NUMBER, -- 46
915 rate_date IN DATE, -- 47
916 rate_type IN VARCHAR2, -- 48
917 source_type_code IN VARCHAR2, -- 49
918 spsc_code IN VARCHAR2, -- 50
919 suggested_buyer_id IN NUMBER, -- 51
920 source_doc_header_id IN NUMBER, -- 52
921 source_doc_line_num IN NUMBER, -- 53
922 source_doc_type_code IN VARCHAR2, -- 54
923 supplier_item_num IN VARCHAR2, -- 55
924 taxable_status IN VARCHAR2, -- 56
925 unit_of_measure IN VARCHAR2, -- 57
926 unit_price IN NUMBER, -- 58
927 supplier_contact_id IN NUMBER, -- 59
928 supplier_id IN NUMBER, -- 60
929 supplier_site_id IN NUMBER, -- 61
930 pcard_flag IN VARCHAR2, -- 62
931 line_type_id IN NUMBER, -- 63
932 taxCodeId IN NUMBER, -- 64
933 results_billable_flag IN VARCHAR2,-- 65
934 preparer_id IN NUMBER, -- 66
935 deliver_to_person_id IN NUMBER, -- 67
936 po_encumberance_flag IN VARCHAR2, -- 68
937 DATE_FORMAT IN VARCHAR2, -- 69
938 header_att1 IN VARCHAR2, -- 70
939 header_att2 IN VARCHAR2, -- 71
940 header_att3 IN VARCHAR2, -- 72
941 header_att4 IN VARCHAR2, -- 73
942 header_att5 IN VARCHAR2, -- 74
943 header_att6 IN VARCHAR2, -- 75
944 header_att7 IN VARCHAR2, -- 76
945 header_att8 IN VARCHAR2, -- 77
946 header_att9 IN VARCHAR2, -- 78
947 header_att10 IN VARCHAR2, -- 79
948 header_att11 IN VARCHAR2, -- 80
949 header_att12 IN VARCHAR2, -- 81
950 header_att13 IN VARCHAR2, -- 82
951 header_att14 IN VARCHAR2, -- 83
952 header_att15 IN VARCHAR2, -- 84
953 line_att1 IN VARCHAR2, -- 85
954 line_att2 IN VARCHAR2, -- 86
955 line_att3 IN VARCHAR2, -- 87
956 line_att4 IN VARCHAR2, -- 88
957 line_att5 IN VARCHAR2, -- 89
958 line_att6 IN VARCHAR2, -- 90
959 line_att7 IN VARCHAR2, -- 91
960 line_att8 IN VARCHAR2, -- 92
961 line_att9 IN VARCHAR2, -- 93
962 line_att10 IN VARCHAR2, -- 94
963 line_att11 IN VARCHAR2, -- 95
967 line_att15 IN VARCHAR2, -- 99
964 line_att12 IN VARCHAR2, -- 96
965 line_att13 IN VARCHAR2, -- 97
966 line_att14 IN VARCHAR2, -- 98
968 distribution_att1 IN VARCHAR2, -- 100
969 distribution_att2 IN VARCHAR2, -- 101
970 distribution_att3 IN VARCHAR2, -- 102
971 distribution_att4 IN VARCHAR2, -- 103
972 distribution_att5 IN VARCHAR2, -- 104
973 distribution_att6 IN VARCHAR2, -- 105
974 distribution_att7 IN VARCHAR2, -- 106
975 distribution_att8 IN VARCHAR2, -- 107
976 distribution_att9 IN VARCHAR2, -- 108
977 distribution_att10 IN VARCHAR2, -- 109
978 distribution_att11 IN VARCHAR2, -- 110
979 distribution_att12 IN VARCHAR2, -- 111
980 distribution_att13 IN VARCHAR2, -- 112
981 distribution_att14 IN VARCHAR2, -- 113
982 distribution_att15 IN VARCHAR2, -- 114
983 result_code OUT NOCOPY NUMBER, -- 115
984 x_error_msg OUT NOCOPY VARCHAR2 -- 116
985 )
986 IS
987 BEGIN
988 JG_PO_EXTENSION_PKG.CUSTOM_VALIDATE_REQ_DIST (
989 x_distribution_id ,
990 x_code_combination_id ,
991 x_budget_account_id ,
992 x_variance_account_id ,
993 x_accrual_account_id ,
994 project_id ,
995 task_id ,
996 expenditure_type ,
997 expenditure_organization_id ,
998 expenditure_item_date ,
999 award_id ,
1000 gl_encumbered_date ,
1001 gl_period_name ,
1002 gl_cancelled_date ,
1003 gl_closed_date ,
1004 gl_date ,
1005 gl_encumbered_period ,
1006 recovery_rate ,
1007 tax_recovery_override_flag ,
1008 chart_of_accounts_id ,
1009 category_id ,
1010 catalog_source ,
1011 catalog_type ,
1012 destination_type_code ,
1013 deliver_to_location_id ,
1014 destination_organization_id ,
1015 destination_subinventory ,
1016 item_id ,
1017 sob_id ,
1018 currency_code ,
1019 currency_unit_price ,
1020 manufacturer_name ,
1021 manufacturer_part_num ,
1022 need_by_date ,
1023 new_supplier_flag ,
1024 business_org_id ,
1025 org_id ,
1026 employee_id ,
1027 employee_org_id ,
1028 default_code_combination_id ,
1029 parent_req_line_id ,
1030 qty_cancelled ,
1031 qty_delivered ,
1032 qty_ordered ,
1033 qty_received ,
1034 rate ,
1035 rate_date ,
1036 rate_type ,
1037 source_type_code ,
1038 spsc_code ,
1039 suggested_buyer_id ,
1040 source_doc_header_id ,
1041 source_doc_line_num ,
1042 source_doc_type_code ,
1043 supplier_item_num ,
1044 taxable_status ,
1045 unit_of_measure ,
1046 unit_price ,
1047 supplier_contact_id ,
1048 supplier_id ,
1049 supplier_site_id ,
1050 pcard_flag ,
1051 line_type_id ,
1052 taxCodeId ,
1053 results_billable_flag ,
1054 preparer_id ,
1055 deliver_to_person_id ,
1056 po_encumberance_flag ,
1057 DATE_FORMAT ,
1058 header_att1 ,
1059 header_att2 ,
1060 header_att3 ,
1061 header_att4 ,
1062 header_att5 ,
1063 header_att6 ,
1064 header_att7 ,
1065 header_att8 ,
1066 header_att9 ,
1067 header_att10 ,
1068 header_att11 ,
1069 header_att12 ,
1070 header_att13 ,
1071 header_att14 ,
1072 header_att15 ,
1073 line_att1 ,
1074 line_att2 ,
1075 line_att3 ,
1076 line_att4 ,
1077 line_att5 ,
1078 line_att6 ,
1079 line_att7 ,
1080 line_att8 ,
1081 line_att9 ,
1082 line_att10 ,
1083 line_att11 ,
1084 line_att12 ,
1085 line_att13 ,
1086 line_att14 ,
1087 line_att15 ,
1088 distribution_att1 ,
1089 distribution_att2 ,
1090 distribution_att3 ,
1091 distribution_att4 ,
1092 distribution_att5 ,
1093 distribution_att6 ,
1094 distribution_att7 ,
1095 distribution_att8 ,
1096 distribution_att9 ,
1097 distribution_att10 ,
1098 distribution_att11 ,
1099 distribution_att12 ,
1100 distribution_att13 ,
1101 distribution_att14 ,
1102 distribution_att15 ,
1103 result_code ,
1104 x_error_msg
1105 );
1106
1107
1108 END;
1109
1110 END POR_global_PKG;