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