1 PACKAGE JG_PO_EXTENSION_PKG AUTHID CURRENT_USER as
2 /* $Header: jggicxus.pls 120.4.12010000.7 2010/07/05 06:18:28 vspuli noship $ */
3
4
5 -- Customize this procedure to add custom globalization 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
44
45 -- Customize this procedure to add logic for validation related to globalization of the attribute values
46 -- on a requisition header. This would be any custom validation, that would
47 -- be in addition to all the validations done for a requisition header.
48 -- The return_msg and the error_code can be used to return the results of
49 -- the validation
50 -- The return code can be used to indicate on which tab the error message
51 -- needs to be displayed on the Edit Lines page
52 -- If the result code is 1, error is displayed on the Delivery tab
53 -- If the result code is 2, error is displayed on the Billing tab
54 -- If the result code is 3, error is displayed on the Accounts tab
55
56 PROCEDURE CUSTOM_VALIDATE_REQ_HEADER (
57 req_header_id IN NUMBER, -- 1
58 req_num IN VARCHAR2, -- 2
59 preparer_id IN NUMBER, -- 3
60 req_type IN VARCHAR2, -- 4
61 emergency_po_num IN VARCHAR2, -- 5
62 approval_status_code IN VARCHAR2, -- 6
63 cancel_flag IN VARCHAR2, -- 7
64 closed_code IN VARCHAR2, -- 8
65 org_id IN NUMBER, -- 9
66 wf_item_type IN VARCHAR2, -- 10
67 wf_item_key IN VARCHAR2, -- 11
68 pcard_id IN NUMBER, -- 12
69 attribute1 IN VARCHAR2, -- 13
70 attribute2 IN VARCHAR2, -- 14
71 attribute3 IN VARCHAR2, -- 15
72 attribute4 IN VARCHAR2, -- 16
73 attribute5 IN VARCHAR2, -- 17
74 attribute6 IN VARCHAR2, -- 18
75 attribute7 IN VARCHAR2, -- 19
76 attribute8 IN VARCHAR2, -- 20
77 attribute9 IN VARCHAR2, -- 21
78 attribute10 IN VARCHAR2, -- 22
79 attribute11 IN VARCHAR2, -- 23
80 attribute12 IN VARCHAR2, -- 24
81 attribute13 IN VARCHAR2, -- 25
82 attribute14 IN VARCHAR2, -- 26
83 attribute15 IN VARCHAR2, -- 27
84 x_return_code OUT NOCOPY NUMBER, -- 28
85 x_error_msg OUT NOCOPY VARCHAR2 -- 29
86 );
87
88
89 -- Customize this procedure to add custom globalization defaulting logic for all the
90 -- attributes on a requisition line.
91 -- This is called when a new line gets added to the requisition.
92 -- The attribute id's are passed as IN OUT NOCOPY parameters to this procedure and
93 -- can be modified to reflect any custom defaulting logic.
94 -- The values corresponding to the id's are recalculated in the calling ReqLine
95 -- Java class
96
97 PROCEDURE CUSTOM_DEFAULT_REQ_LINE (
98 -- READ ONLY data
99 req_header_id IN NUMBER, -- 1
100 req_line_id IN NUMBER, -- 2
101 old_req_line_id IN NUMBER, -- 3
102 line_num IN NUMBER, -- 4
103
104 -- header data
105 preparer_id IN NUMBER, -- 5
106 header_attribute_1 IN VARCHAR2, -- 6
107 header_attribute_2 IN VARCHAR2, -- 7
108 header_attribute_3 IN VARCHAR2, -- 8
109 header_attribute_4 IN VARCHAR2, -- 9
110 header_attribute_5 IN VARCHAR2, -- 10
111 header_attribute_6 IN VARCHAR2, -- 11
112 header_attribute_7 IN VARCHAR2, -- 12
113 header_attribute_8 IN VARCHAR2, -- 13
114 header_attribute_9 IN VARCHAR2, -- 14
115 header_attribute_10 IN VARCHAR2, -- 15
116 header_attribute_11 IN VARCHAR2, -- 16
117 header_attribute_12 IN VARCHAR2, -- 17
118 header_attribute_13 IN VARCHAR2, -- 18
119 header_attribute_14 IN VARCHAR2, -- 19
120 header_attribute_15 IN VARCHAR2, -- 20
121
122 -- line data: update any of the following parameters as default for line
123 x_line_type_id IN OUT NOCOPY NUMBER, -- 21
124 x_item_id IN OUT NOCOPY NUMBER, -- 22
125 x_item_revision IN OUT NOCOPY VARCHAR2, -- 23
126 x_category_id IN OUT NOCOPY NUMBER, -- 24
127 x_catalog_source IN OUT NOCOPY VARCHAR2, -- 25
128 x_catalog_type IN OUT NOCOPY VARCHAR2, -- 26
129 x_currency_code IN OUT NOCOPY VARCHAR2, -- 27
130 x_currency_unit_price IN OUT NOCOPY NUMBER, -- 28
131 x_manufacturer_name IN OUT NOCOPY VARCHAR2, -- 29
132 x_manufacturer_part_num IN OUT NOCOPY VARCHAR2, -- 30
133 x_deliver_to_loc_id IN OUT NOCOPY NUMBER, -- 31
134 x_deliver_to_org_id IN OUT NOCOPY NUMBER, -- 32
135 x_deliver_to_subinv IN OUT NOCOPY VARCHAR2, -- 33
136 x_destination_type_code IN OUT NOCOPY VARCHAR2, -- 34
137 x_requester_id IN OUT NOCOPY NUMBER, -- 35
138 x_encumbered_flag IN OUT NOCOPY VARCHAR2, -- 36
139 x_hazard_class_id IN OUT NOCOPY NUMBER, -- 37
140 x_modified_by_buyer IN OUT NOCOPY VARCHAR2, -- 38
141 x_need_by_date IN OUT NOCOPY DATE, -- 39
142 x_new_supplier_flag IN OUT NOCOPY VARCHAR2, -- 40
143 x_on_rfq_flag IN OUT NOCOPY VARCHAR2, -- 41
144 x_org_id IN OUT NOCOPY NUMBER, -- 42
145 x_parent_req_line_id IN OUT NOCOPY NUMBER, -- 43
146 x_po_line_loc_id IN OUT NOCOPY NUMBER, -- 44
147 x_qty_cancelled IN OUT NOCOPY NUMBER, -- 45
148 x_qty_delivered IN OUT NOCOPY NUMBER, -- 46
149 x_qty_ordered IN OUT NOCOPY NUMBER, -- 47
150 x_qty_received IN OUT NOCOPY NUMBER, -- 48
151 x_rate IN OUT NOCOPY NUMBER, -- 49
152 x_rate_date IN OUT NOCOPY DATE, -- 50
153 x_rate_type IN OUT NOCOPY VARCHAR2, -- 51
154 x_rfq_required IN OUT NOCOPY VARCHAR2, -- 52
155 x_source_type_code IN OUT NOCOPY VARCHAR2, -- 53
156 x_spsc_code IN OUT NOCOPY VARCHAR2, -- 54
157 x_other_category_code IN OUT NOCOPY VARCHAR2, -- 55
158 x_suggested_buyer_id IN OUT NOCOPY NUMBER, -- 56
159 x_source_doc_header_id IN OUT NOCOPY NUMBER, -- 57
160 x_source_doc_line_num IN OUT NOCOPY NUMBER, -- 58
161 x_source_doc_type_code IN OUT NOCOPY VARCHAR2, -- 59
162 x_supplier_duns IN OUT NOCOPY VARCHAR2, -- 60
163 x_supplier_item_num IN OUT NOCOPY VARCHAR2, -- 61
164 x_taxable_status IN OUT NOCOPY VARCHAR2, -- 62
165 x_unit_of_measure IN OUT NOCOPY VARCHAR2, -- 63
166 x_unit_price IN OUT NOCOPY NUMBER, -- 64
167 x_urgent IN OUT NOCOPY VARCHAR2, -- 65
168 x_supplier_contact_id IN OUT NOCOPY NUMBER, -- 66
169 x_supplier_id IN OUT NOCOPY NUMBER, -- 67
170 x_supplier_site_id IN OUT NOCOPY NUMBER, -- 68
171 x_cancel_date IN OUT NOCOPY DATE, -- 69
172 x_cancel_flag IN OUT NOCOPY VARCHAR2, -- 70
173 x_closed_code IN OUT NOCOPY VARCHAR2, -- 71
174 x_closed_date IN OUT NOCOPY DATE, -- 72
175 x_auto_receive_flag IN OUT NOCOPY VARCHAR2, -- 73
176 x_pcard_flag IN OUT NOCOPY VARCHAR2, -- 74
177 x_attribute1 IN OUT NOCOPY VARCHAR2, -- 75
178 x_attribute2 IN OUT NOCOPY VARCHAR2, -- 76
179 x_attribute3 IN OUT NOCOPY VARCHAR2, -- 77
180 x_attribute4 IN OUT NOCOPY VARCHAR2, -- 78
181 x_attribute5 IN OUT NOCOPY VARCHAR2, -- 79
182 x_attribute6 IN OUT NOCOPY VARCHAR2, -- 80
183 x_attribute7 IN OUT NOCOPY VARCHAR2, -- 81
184 x_attribute8 IN OUT NOCOPY VARCHAR2, -- 82
185 x_attribute9 IN OUT NOCOPY VARCHAR2, -- 83
186 x_attribute10 IN OUT NOCOPY VARCHAR2, -- 84
187 x_attribute11 IN OUT NOCOPY VARCHAR2, -- 85
188 x_attribute12 IN OUT NOCOPY VARCHAR2, -- 86
189 x_attribute13 IN OUT NOCOPY VARCHAR2, -- 87
190 x_attribute14 IN OUT NOCOPY VARCHAR2, -- 88
191 x_attribute15 IN OUT NOCOPY VARCHAR2, -- 89
192 X_return_code OUT NOCOPY NUMBER, -- 90
193 X_error_msg OUT NOCOPY VARCHAR2, -- 91
194 x_supplierContact IN OUT NOCOPY VARCHAR2, -- 92
195 x_supplierContactPhone IN OUT NOCOPY VARCHAR2, -- 93
196 x_supplier IN OUT NOCOPY VARCHAR2, -- 94
197 x_supplierSite IN OUT NOCOPY VARCHAR2, -- 95
198 x_taxCodeId IN OUT NOCOPY NUMBER, -- 96
199 x_source_org_id IN OUT NOCOPY NUMBER, -- 97
200 x_txn_reason_code IN OUT NOCOPY VARCHAR2 -- 98
201 );
202
203
204 -- Customize this procedure to add logic for validation related to globalization of the attribute values
205 -- on a requisition line. This would be any custom validation, that would be
206 -- in addition to all the validations done for a requisition line
207 -- This is called whenever the requisition line gets updated and is called
208 -- on every page in the checkOUT NOCOPY flow.
209 -- The return_msg and the error_code can be used to return the results of
210 -- the validation
211 -- The return code can be used to indicate on which tab the error message
212 -- needs to be displayed on the Edit Lines page
213 -- If the result code is 1, error is displayed on the Delivery tab
214 -- If the result code is 2, error is displayed on the Billing tab
215 -- If the result code is 3, error is displayed on the Accounts tab
216
217 PROCEDURE CUSTOM_VALIDATE_REQ_LINE (
218 x_req_header_id IN NUMBER, -- 1
219 x_req_line_id IN NUMBER, -- 2
220 x_line_num IN NUMBER, -- 3
221
222 -- header data
223 preparer_id IN NUMBER, -- 4
224 header_attribute_1 IN VARCHAR2, -- 5
225 header_attribute_2 IN VARCHAR2, -- 6
226 header_attribute_3 IN VARCHAR2, -- 7
227 header_attribute_4 IN VARCHAR2, -- 8
228 header_attribute_5 IN VARCHAR2, -- 9
229 header_attribute_6 IN VARCHAR2, -- 10
230 header_attribute_7 IN VARCHAR2, -- 11
231 header_attribute_8 IN VARCHAR2, -- 12
232 header_attribute_9 IN VARCHAR2, -- 13
233 header_attribute_10 IN VARCHAR2, -- 14
234 header_attribute_11 IN VARCHAR2, -- 15
235 header_attribute_12 IN VARCHAR2, -- 16
236 header_attribute_13 IN VARCHAR2, -- 17
237 header_attribute_14 IN VARCHAR2, -- 18
238 header_attribute_15 IN VARCHAR2, -- 19
239
240 -- line data
241 line_type_id IN NUMBER, -- 20
242 item_id IN NUMBER, -- 21
243 item_revision IN VARCHAR2, -- 22
244 category_id IN NUMBER, -- 23
245 catalog_source IN VARCHAR2, -- 24
246 catalog_type IN VARCHAR2, -- 25
247 currency_code IN VARCHAR2, -- 26
248 currency_unit_price IN NUMBER, -- 27
249 manufacturer_name IN VARCHAR2, --28
250 manufacturer_part_num IN VARCHAR2, -- 29
251 deliver_to_loc_id IN NUMBER, -- 30
252 deliver_to_org_id IN NUMBER, -- 31
253 deliver_to_subinv IN VARCHAR2, -- 32
254 destination_type_code IN VARCHAR2, -- 33
255 requester_id IN NUMBER, -- 34
256 encumbered_flag IN VARCHAR2, -- 35
257 hazard_class_id IN NUMBER, -- 36
258 modified_by_buyer IN VARCHAR2, -- 37
259 need_by_date IN DATE, -- 38
260 new_supplier_flag IN VARCHAR2, -- 39
261 on_rfq_flag IN VARCHAR2, -- 40
262 org_id IN NUMBER, -- 41
263 parent_req_line_id IN NUMBER, -- 42
264 po_line_loc_id IN NUMBER, -- 43
265 qty_cancelled IN NUMBER, -- 44
266 qty_delivered IN NUMBER, -- 45
267 qty_ordered IN NUMBER, -- 46
268 qty_received IN NUMBER, -- 47
269 rate IN NUMBER, -- 48
270 rate_date IN DATE, -- 49
271 rate_type IN VARCHAR2, -- 50
272 rfq_required IN VARCHAR2, -- 51
273 source_type_code IN VARCHAR2, -- 52
274 spsc_code IN VARCHAR2, -- 53
275 other_category_code IN VARCHAR2, -- 54
276 suggested_buyer_id IN OUT NOCOPY NUMBER, -- 55
277 source_doc_header_id IN NUMBER, -- 56
278 source_doc_line_num IN NUMBER, -- 57
279 source_doc_type_code IN VARCHAR2, -- 58
280 supplier_duns IN VARCHAR2, -- 59
281 supplier_item_num IN VARCHAR2, -- 60
282 taxable_status IN VARCHAR2, -- 61
283 unit_of_measure IN VARCHAR2, -- 62
284 unit_price IN NUMBER, -- 63
285 urgent IN VARCHAR2, -- 64
286 supplier_contact_id IN NUMBER, -- 65
290 cancel_flag IN VARCHAR2, -- 69
287 supplier_id IN NUMBER, -- 66
288 supplier_site_id IN NUMBER, -- 67
289 cancel_date IN DATE, -- 68
291 closed_code IN VARCHAR2, -- 70
292 closed_date IN DATE, -- 71
293 auto_receive_flag IN VARCHAR2, -- 72
294 pcard_flag IN VARCHAR2, -- 73
295 attribute1 IN VARCHAR2, -- 74
296 attribute2 IN VARCHAR2, -- 75
297 attribute3 IN VARCHAR2, -- 76
298 attribute4 IN VARCHAR2, -- 77
299 attribute5 IN VARCHAR2, -- 78
300 attribute6 IN VARCHAR2, -- 79
301 attribute7 IN VARCHAR2, -- 80
302 attribute8 IN VARCHAR2, -- 81
303 attribute9 IN VARCHAR2, -- 82
304 attribute10 IN VARCHAR2, -- 83
305 attribute11 IN VARCHAR2, -- 84
306 attribute12 IN VARCHAR2, -- 85
307 attribute13 IN VARCHAR2, -- 86
308 attribute14 IN VARCHAR2, -- 87
309 attribute15 IN VARCHAR2, -- 88
310 x_taxCodeId IN NUMBER, -- 89
311 x_return_code OUT NOCOPY NUMBER, -- 90 no error
312 x_error_msg OUT NOCOPY VARCHAR2, -- 91
313 x_source_org_id IN NUMBER, -- 92
314 x_txn_reason_code IN VARCHAR2 -- 93
315 );
316
317
318
319
320 -- Customize this procedure to add custom globalization defaulting logic for all the
321 -- attributes on a requisition distribution.
322 -- This is called when a new distribution gets added to the requisition.
323 -- The attribute id's are passed as IN OUT NOCOPY parameters to this procedure and
324 -- can be modified to reflect any custom defaulting logic.
325
326 PROCEDURE CUSTOM_DEFAULT_REQ_DIST (
327
328 x_distribution_id IN NUMBER, -- 1
329 x_old_distribution_id IN NUMBER, -- 2
330 x_code_combination_id IN OUT NOCOPY NUMBER, -- 3
331 x_budget_account_id IN OUT NOCOPY NUMBER, -- 4
332 x_variance_account_id IN OUT NOCOPY NUMBER, -- 5
333 x_accrual_account_id IN OUT NOCOPY NUMBER, -- 6
334 project_id IN OUT NOCOPY NUMBER, -- 7
335 task_id IN OUT NOCOPY NUMBER, -- 8
336 expenditure_type IN OUT NOCOPY VARCHAR2, -- 9
337 expenditure_organization_id IN OUT NOCOPY NUMBER, -- 10
338 expenditure_item_date IN OUT NOCOPY DATE, -- 11
339 award_id IN OUT NOCOPY NUMBER, -- 12
340 gl_encumbered_date IN OUT NOCOPY DATE, -- 13
341 gl_period_name IN OUT NOCOPY VARCHAR2, -- 14
342 gl_cancelled_date IN OUT NOCOPY DATE, -- 15
343 gl_closed_date IN OUT NOCOPY DATE,--16
344 gl_date IN OUT NOCOPY DATE,--17
345 gl_encumbered_period IN OUT NOCOPY VARCHAR2,--18
346 recovery_rate IN OUT NOCOPY NUMBER, -- 19
347 tax_recovery_override_flag IN OUT NOCOPY VARCHAR2, -- 20
348 chart_of_accounts_id IN NUMBER, -- 21
349 category_id IN NUMBER, -- 22
350 catalog_source IN VARCHAR2, -- 23
354 destination_organization_id IN NUMBER, -- 27
351 catalog_type IN VARCHAR2, -- 24
352 destination_type_code IN VARCHAR2, -- 25
353 deliver_to_location_id IN NUMBER, -- 26
355 destination_subinventory IN VARCHAR2, -- 28
356 item_id IN NUMBER, -- 29
357 sob_id IN NUMBER, -- 30
358 currency_code IN VARCHAR2, -- 31
359 currency_unit_price IN NUMBER, -- 32
360 manufacturer_name IN VARCHAR2, -- 33
361 manufacturer_part_num IN VARCHAR2,-- 34
362 need_by_date IN DATE, -- 35
363 new_supplier_flag IN VARCHAR2, -- 36
364 business_org_id IN NUMBER, -- 37
365 org_id IN NUMBER, -- 38
366 employee_id IN NUMBER, -- 39
367 employee_org_id IN NUMBER, -- 40
368 default_code_combination_id IN NUMBER, -- 41
369 parent_req_line_id IN NUMBER, -- 42
370 qty_cancelled IN NUMBER, -- 43
371 qty_delivered IN NUMBER, -- 44
372 qty_ordered IN NUMBER, -- 45
373 qty_received IN NUMBER, -- 46
374 rate IN NUMBER, -- 47
375 rate_date IN DATE, -- 48
376 rate_type IN VARCHAR2, -- 49
377 source_type_code IN VARCHAR2, -- 50
378 spsc_code IN VARCHAR2, -- 51
379 suggested_buyer_id IN NUMBER, -- 52
380 source_doc_header_id IN NUMBER, -- 53
381 source_doc_line_num IN NUMBER, -- 54
382 source_doc_type_code IN VARCHAR2, -- 55
383 supplier_item_num IN VARCHAR2, -- 56
384 taxable_status IN VARCHAR2, -- 57
385 unit_of_measure IN VARCHAR2, -- 58
386 unit_price IN NUMBER, -- 59
387 supplier_contact_id IN NUMBER, -- 60
388 supplier_id IN NUMBER, -- 61
389 supplier_site_id IN NUMBER, -- 62
390 pcard_flag IN VARCHAR2, -- 63
391 line_type_id IN NUMBER, -- 64
392 taxCodeId IN NUMBER, -- 65
393 results_billable_flag IN VARCHAR2,-- 66
394 preparer_id IN NUMBER, -- 67
395 deliver_to_person_id IN NUMBER, -- 68
396 po_encumberance_flag IN VARCHAR2, -- 69
397 DATE_FORMAT IN VARCHAR2, -- 70
398 header_att1 IN VARCHAR2, -- 71
399 header_att2 IN VARCHAR2, -- 72
400 header_att3 IN VARCHAR2, -- 73
401 header_att4 IN VARCHAR2, -- 74
402 header_att5 IN VARCHAR2, -- 75
403 header_att6 IN VARCHAR2, -- 76
404 header_att7 IN VARCHAR2, -- 77
405 header_att8 IN VARCHAR2, -- 78
406 header_att9 IN VARCHAR2, -- 79
407 header_att10 IN VARCHAR2, -- 80
408 header_att11 IN VARCHAR2, -- 81
409 header_att12 IN VARCHAR2, -- 82
410 header_att13 IN VARCHAR2, -- 83
411 header_att14 IN VARCHAR2, -- 84
412 header_att15 IN VARCHAR2, -- 85
413 line_att1 IN VARCHAR2, -- 86
414 line_att2 IN VARCHAR2, -- 87
415 line_att3 IN VARCHAR2, -- 88
416 line_att4 IN VARCHAR2, -- 89
417 line_att5 IN VARCHAR2, -- 90
418 line_att6 IN VARCHAR2, -- 91
419 line_att7 IN VARCHAR2, -- 92
420 line_att8 IN VARCHAR2, -- 93
421 line_att9 IN VARCHAR2, -- 94
422 line_att10 IN VARCHAR2, -- 95
423 line_att11 IN VARCHAR2, -- 96
424 line_att12 IN VARCHAR2, -- 97
425 line_att13 IN VARCHAR2, -- 98
426 line_att14 IN VARCHAR2, -- 99
427 line_att15 IN VARCHAR2, -- 100
428 distribution_att1 IN OUT NOCOPY VARCHAR2, -- 101
429 distribution_att2 IN OUT NOCOPY VARCHAR2, -- 102
430 distribution_att3 IN OUT NOCOPY VARCHAR2, -- 103
431 distribution_att4 IN OUT NOCOPY VARCHAR2, -- 104
432 distribution_att5 IN OUT NOCOPY VARCHAR2, -- 105
433 distribution_att6 IN OUT NOCOPY VARCHAR2, -- 106
434 distribution_att7 IN OUT NOCOPY VARCHAR2, -- 107
435 distribution_att8 IN OUT NOCOPY VARCHAR2, -- 108
436 distribution_att9 IN OUT NOCOPY VARCHAR2, -- 109
437 distribution_att10 IN OUT NOCOPY VARCHAR2, -- 110
438 distribution_att11 IN OUT NOCOPY VARCHAR2, -- 111
439 distribution_att12 IN OUT NOCOPY VARCHAR2, -- 112
440 distribution_att13 IN OUT NOCOPY VARCHAR2, -- 113
441 distribution_att14 IN OUT NOCOPY VARCHAR2, -- 114
442 distribution_att15 IN OUT NOCOPY VARCHAR2, -- 115
443 result_code OUT NOCOPY NUMBER, -- 116
444 x_error_msg OUT NOCOPY VARCHAR2 -- 117
445 );
446
447 -- Customize this procedure to add logic for validation related to globalization of the attribute values
448 -- on a requisition distribution. This would be any custom validation, that
449 -- would be in addition to all the validations done for a requisition
450 -- distribution.
451 -- The return_msg and the error_code can be used to return the results of
452 -- the validation
453 -- The return code can be used to indicate on which tab the error message
454 -- needs to be displayed on the Edit Lines page
455 -- If the result code is 1, error is displayed on the Delivery tab
456 -- If the result code is 2, error is displayed on the Billing tab
457 -- If the result code is 3, error is displayed on the Accounts tab
458
459 PROCEDURE CUSTOM_VALIDATE_REQ_DIST (
460
461 x_distribution_id IN NUMBER, -- 1
462 x_code_combination_id IN NUMBER, -- 2
463 x_budget_account_id IN NUMBER, -- 3
464 x_variance_account_id IN NUMBER, -- 4
465 x_accrual_account_id IN NUMBER, -- 5
466 project_id IN NUMBER, -- 6
467 task_id IN NUMBER, -- 7
468 expenditure_type IN VARCHAR2, -- 8
469 expenditure_organization_id IN NUMBER, -- 9
470 expenditure_item_date IN DATE, -- 10
474 gl_cancelled_date IN DATE, -- 14
471 award_id IN NUMBER, -- 11
472 gl_encumbered_date IN DATE, -- 12
473 gl_period_name IN VARCHAR2, -- 13
475 gl_closed_date IN DATE,--15
476 gl_date IN DATE,--16
477 gl_encumbered_period IN VARCHAR2,--17
478 recovery_rate IN NUMBER, -- 18
479 tax_recovery_override_flag IN VARCHAR2, -- 19
480 chart_of_accounts_id IN NUMBER, -- 20
481 category_id IN NUMBER, -- 21
482 catalog_source IN VARCHAR2, -- 22
483 catalog_type IN VARCHAR2, -- 23
484 destination_type_code IN VARCHAR2, -- 24
485 deliver_to_location_id IN NUMBER, -- 25
486 destination_organization_id IN NUMBER, -- 26
487 destination_subinventory IN VARCHAR2, -- 27
488 item_id IN NUMBER, -- 28
489 sob_id IN NUMBER, -- 29
490 currency_code IN VARCHAR2, -- 30
491 currency_unit_price IN NUMBER, -- 31
492 manufacturer_name IN VARCHAR2, -- 32
493 manufacturer_part_num IN VARCHAR2,-- 33
494 need_by_date IN DATE, -- 34
495 new_supplier_flag IN VARCHAR2, -- 35
496 business_org_id IN NUMBER, -- 36
497 org_id IN NUMBER, -- 37
498 employee_id IN NUMBER, -- 38
499 employee_org_id IN NUMBER, -- 39
500 default_code_combination_id IN NUMBER, -- 40
501 parent_req_line_id IN NUMBER, -- 41
502 qty_cancelled IN NUMBER, -- 42
503 qty_delivered IN NUMBER, -- 43
504 qty_ordered IN NUMBER, -- 44
505 qty_received IN NUMBER, -- 45
506 rate IN NUMBER, -- 46
507 rate_date IN DATE, -- 47
508 rate_type IN VARCHAR2, -- 48
509 source_type_code IN VARCHAR2, -- 49
510 spsc_code IN VARCHAR2, -- 50
511 suggested_buyer_id IN NUMBER, -- 51
512 source_doc_header_id IN NUMBER, -- 52
513 source_doc_line_num IN NUMBER, -- 53
514 source_doc_type_code IN VARCHAR2, -- 54
515 supplier_item_num IN VARCHAR2, -- 55
516 taxable_status IN VARCHAR2, -- 56
517 unit_of_measure IN VARCHAR2, -- 57
518 unit_price IN NUMBER, -- 58
519 supplier_contact_id IN NUMBER, -- 59
520 supplier_id IN NUMBER, -- 60
521 supplier_site_id IN NUMBER, -- 61
522 pcard_flag IN VARCHAR2, -- 62
523 line_type_id IN NUMBER, -- 63
524 taxCodeId IN NUMBER, -- 64
525 results_billable_flag IN VARCHAR2,-- 65
526 preparer_id IN NUMBER, -- 66
527 deliver_to_person_id IN NUMBER, -- 67
528 po_encumberance_flag IN VARCHAR2, -- 68
529 DATE_FORMAT IN VARCHAR2, -- 69
530 header_att1 IN VARCHAR2, -- 70
531 header_att2 IN VARCHAR2, -- 71
532 header_att3 IN VARCHAR2, -- 72
533 header_att4 IN VARCHAR2, -- 73
534 header_att5 IN VARCHAR2, -- 74
535 header_att6 IN VARCHAR2, -- 75
536 header_att7 IN VARCHAR2, -- 76
537 header_att8 IN VARCHAR2, -- 77
538 header_att9 IN VARCHAR2, -- 78
539 header_att10 IN VARCHAR2, -- 79
540 header_att11 IN VARCHAR2, -- 80
541 header_att12 IN VARCHAR2, -- 81
542 header_att13 IN VARCHAR2, -- 82
543 header_att14 IN VARCHAR2, -- 83
544 header_att15 IN VARCHAR2, -- 84
545 line_att1 IN VARCHAR2, -- 85
546 line_att2 IN VARCHAR2, -- 86
547 line_att3 IN VARCHAR2, -- 87
548 line_att4 IN VARCHAR2, -- 88
549 line_att5 IN VARCHAR2, -- 89
550 line_att6 IN VARCHAR2, -- 90
551 line_att7 IN VARCHAR2, -- 91
552 line_att8 IN VARCHAR2, -- 92
553 line_att9 IN VARCHAR2, -- 93
554 line_att10 IN VARCHAR2, -- 94
555 line_att11 IN VARCHAR2, -- 95
556 line_att12 IN VARCHAR2, -- 96
557 line_att13 IN VARCHAR2, -- 97
558 line_att14 IN VARCHAR2, -- 98
559 line_att15 IN VARCHAR2, -- 99
560 distribution_att1 IN VARCHAR2, -- 100
561 distribution_att2 IN VARCHAR2, -- 101
562 distribution_att3 IN VARCHAR2, -- 102
563 distribution_att4 IN VARCHAR2, -- 103
564 distribution_att5 IN VARCHAR2, -- 104
565 distribution_att6 IN VARCHAR2, -- 105
566 distribution_att7 IN VARCHAR2, -- 106
567 distribution_att8 IN VARCHAR2, -- 107
568 distribution_att9 IN VARCHAR2, -- 108
569 distribution_att10 IN VARCHAR2, -- 109
570 distribution_att11 IN VARCHAR2, -- 110
571 distribution_att12 IN VARCHAR2, -- 111
572 distribution_att13 IN VARCHAR2, -- 112
573 distribution_att14 IN VARCHAR2, -- 113
574 distribution_att15 IN VARCHAR2, -- 114
575 result_code OUT NOCOPY NUMBER, -- 115
576 x_error_msg OUT NOCOPY VARCHAR2 -- 116
577 );
578
579
580 END JG_PO_EXTENSION_PKG;
581
[Home] [Help]