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