[Home] [Help]
PACKAGE: APPS.PO_VAL_LINES
Source
1 PACKAGE PO_VAL_LINES AUTHID CURRENT_USER AS
2 -- $Header: PO_VAL_LINES.pls 120.28.12020000.10 2013/04/25 12:33:02 akyanama ship $
3
4 PROCEDURE amt_agreed_ge_zero(
5 p_line_id_tbl IN PO_TBL_NUMBER
6 , p_committed_amount_tbl IN PO_TBL_NUMBER
7 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8 , x_result_type OUT NOCOPY VARCHAR2
9 );
10
11 PROCEDURE min_rel_amt_ge_zero(
12 p_line_id_tbl IN PO_TBL_NUMBER
13 , p_min_release_amount_tbl IN PO_TBL_NUMBER
14 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
15 , x_result_type OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE quantity_gt_zero(
19 p_line_id_tbl IN PO_TBL_NUMBER
20 , p_quantity_tbl IN PO_TBL_NUMBER
21 , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
22 , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
23 , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
24 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
25 , x_result_type OUT NOCOPY VARCHAR2
26 , p_header_id_tbl IN PO_TBL_NUMBER --<Bug 15871378>
27 );
28
29 -- <Complex Work R12 Start>
30 -- Removed: quantity_ge_quantity_billed, quantity_ge_quantity_rcvd,
31 -- Added: quantity_ge_quantity_exec
32 PROCEDURE quantity_ge_quantity_exec(
33 p_line_id_tbl IN PO_TBL_NUMBER
34 , p_quantity_tbl IN PO_TBL_NUMBER
35 , x_result_set_id IN OUT NOCOPY NUMBER
36 , x_result_type OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE recoupment_rate_range_check (
40 p_line_id_tbl IN PO_TBL_NUMBER
41 , p_recoupment_rate_tbl IN PO_TBL_NUMBER
42 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
43 , x_result_type OUT NOCOPY VARCHAR2
44 );
45
46 PROCEDURE retainage_rate_range_check (
47 p_line_id_tbl IN PO_TBL_NUMBER
48 , p_retainage_rate_tbl IN PO_TBL_NUMBER
49 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
50 , x_result_type OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE prog_pay_rate_range_check (
54 p_line_id_tbl IN PO_TBL_NUMBER
55 , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
56 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
57 , x_result_type OUT NOCOPY VARCHAR2
58 );
59
60 --Bug 5221843
61 PROCEDURE max_retain_amt_ge_zero (
62 p_line_id_tbl IN PO_TBL_NUMBER
63 , p_max_retain_amt_tbl IN PO_TBL_NUMBER
64 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
65 , x_result_type OUT NOCOPY VARCHAR2
66 );
67
68 --Bug 5453079
69 PROCEDURE max_retain_amt_ge_retained (
70 p_line_id_tbl IN PO_TBL_NUMBER
71 , p_max_retain_amt_tbl IN PO_TBL_NUMBER
72 , x_result_set_id IN OUT NOCOPY NUMBER
73 , x_result_type OUT NOCOPY VARCHAR2
74 );
75
76
77 -- <Complex Work R12 End>
78
79 PROCEDURE quantity_ge_quantity_enc(
80 p_line_id_tbl IN PO_TBL_NUMBER
81 , p_quantity_tbl IN PO_TBL_NUMBER
82 , x_result_set_id IN OUT NOCOPY NUMBER
83 , x_result_type OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE quantity_notif_change(
87 p_line_id_tbl IN PO_TBL_NUMBER
88 , p_quantity_tbl IN PO_TBL_NUMBER
89 , x_result_set_id IN OUT NOCOPY NUMBER
90 , x_result_type OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE amount_gt_zero(
94 p_line_id_tbl IN PO_TBL_NUMBER
95 , p_amount_tbl IN PO_TBL_NUMBER
96 , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
97 , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
98 , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
99 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
100 , x_result_type OUT NOCOPY VARCHAR2
101 , p_header_id_tbl IN PO_TBL_NUMBER --<Bug 15871378>
102 );
103
104 -- <Complex Work R12 Start>
105 -- Removed: amount_ge_amount_billed, amount_ge_amount_rcvd,
106 -- Added: amount_ge_amount_exec
107
108 PROCEDURE amount_ge_amount_exec(
109 p_line_id_tbl IN PO_TBL_NUMBER
110 , p_amount_tbl IN PO_TBL_NUMBER
111 , p_currency_code_tbl IN PO_TBL_VARCHAR30
112 , x_result_set_id IN OUT NOCOPY NUMBER
113 , x_result_type OUT NOCOPY VARCHAR2
114 );
115
116 -- <Complex Work R12 End>
117
118
119 PROCEDURE amount_ge_timecard(
120 p_line_id_tbl IN PO_TBL_NUMBER
121 , p_amount_tbl IN PO_TBL_NUMBER
122 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
123 , x_result_type OUT NOCOPY VARCHAR2
124 );
125
126 PROCEDURE line_num_unique(
127 p_line_id_tbl IN PO_TBL_NUMBER
128 , p_header_id_tbl IN PO_TBL_NUMBER
129 , p_line_num_tbl IN PO_TBL_NUMBER
130 , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL -- <PAR Project>
131 , p_draft_id_tbl IN PO_TBL_NUMBER -- <PAR Project>
132 , x_result_set_id IN OUT NOCOPY NUMBER
133 , x_result_type OUT NOCOPY VARCHAR2
134 );
135
136 PROCEDURE line_num_gt_zero(
137 p_line_id_tbl IN PO_TBL_NUMBER
138 , p_line_num_tbl IN PO_TBL_NUMBER
139 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
140 , x_result_type OUT NOCOPY VARCHAR2
141 );
142
143 PROCEDURE vmi_asl_exists(
144 p_line_id_tbl IN PO_TBL_NUMBER
145 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
146 , p_item_id_tbl IN PO_TBL_NUMBER
147 , p_org_id_tbl IN PO_TBL_NUMBER
148 , p_vendor_id_tbl IN PO_TBL_NUMBER
149 , p_vendor_site_id_tbl IN PO_TBL_NUMBER
150 , x_result_set_id IN OUT NOCOPY NUMBER
151 , x_result_type OUT NOCOPY VARCHAR2
152 );
153
154 PROCEDURE start_date_le_end_date(
155 p_line_id_tbl IN PO_TBL_NUMBER
156 , p_start_date_tbl IN PO_TBL_DATE
157 , p_expiration_date_tbl IN PO_TBL_DATE
158 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
159 , x_result_type OUT NOCOPY VARCHAR2
160 );
161
162 PROCEDURE otl_invalid_start_date_change(
163 p_line_id_tbl IN PO_TBL_NUMBER
164 , p_start_date_tbl IN PO_TBL_DATE
165 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
166 , x_result_type OUT NOCOPY VARCHAR2
167 );
168
169 PROCEDURE otl_invalid_end_date_change(
170 p_line_id_tbl IN PO_TBL_NUMBER
171 , p_expiration_date_tbl IN PO_TBL_DATE
172 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
173 , x_result_type OUT NOCOPY VARCHAR2
174 );
175
176 PROCEDURE unit_price_ge_zero(
177 p_line_id_tbl IN PO_TBL_NUMBER
178 , p_unit_price_tbl IN PO_TBL_NUMBER
179 , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
180 , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
181 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
182 , x_result_type OUT NOCOPY VARCHAR2
183 );
184
185 PROCEDURE list_price_ge_zero(
186 p_line_id_tbl IN PO_TBL_NUMBER
187 , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
188 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
189 , x_result_type OUT NOCOPY VARCHAR2
190 );
191
192 PROCEDURE market_price_ge_zero(
193 p_line_id_tbl IN PO_TBL_NUMBER
194 , p_market_price_tbl IN PO_TBL_NUMBER
195 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
196 , x_result_type OUT NOCOPY VARCHAR2
197 );
198
199 PROCEDURE validate_unit_price_change(
200 p_line_id_tbl IN PO_TBL_NUMBER
201 , p_unit_price_tbl IN PO_TBL_NUMBER
202 , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
203 , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1 --<Bug 13503748 Encumbrance ER>--
204 , x_result_set_id IN OUT NOCOPY NUMBER
205 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
206 , x_result_type OUT NOCOPY VARCHAR2
207 );
208
209 PROCEDURE expiration_ge_blanket_start(
210 p_line_id_tbl IN PO_TBL_NUMBER
211 , p_blanket_start_date_tbl IN PO_TBL_DATE
212 , p_expiration_date_tbl IN PO_TBL_DATE
213 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
214 , x_result_type OUT NOCOPY VARCHAR2
215 );
216
217 PROCEDURE expiration_le_blanket_end(
218 p_line_id_tbl IN PO_TBL_NUMBER
219 , p_blanket_end_date_tbl IN PO_TBL_DATE
220 , p_expiration_date_tbl IN PO_TBL_DATE
221 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
222 , x_result_type OUT NOCOPY VARCHAR2
223 );
224
225 -- <Complex Work R12 Start>
226
227 PROCEDURE qty_ge_qty_milestone_exec(
228 p_line_id_tbl IN PO_TBL_NUMBER
229 , p_quantity_tbl IN PO_TBL_NUMBER
230 , x_result_set_id IN OUT NOCOPY NUMBER
231 , x_result_type OUT NOCOPY VARCHAR2
232 );
233
234 PROCEDURE price_ge_price_milestone_exec(
235 p_line_id_tbl IN PO_TBL_NUMBER
236 , p_price_tbl IN PO_TBL_NUMBER
237 , x_result_set_id IN OUT NOCOPY NUMBER
238 , x_result_type OUT NOCOPY VARCHAR2
239 );
240
241 -- Bug 5070210 Start
242 PROCEDURE advance_amt_le_amt(
243 p_line_id_tbl IN PO_TBL_NUMBER
244 , p_advance_tbl IN PO_TBL_NUMBER
245 , p_amount_tbl IN PO_TBL_NUMBER
246 , p_quantity_tbl IN PO_TBL_NUMBER
247 , p_price_tbl IN PO_TBL_NUMBER
248 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
249 , x_result_type OUT NOCOPY VARCHAR2
250 );
251 -- Bug 5070210 End
252
253 -- <PDOI for Complex PO Project: Start>
254 PROCEDURE complex_po_attributes_check(
255 p_line_id_tbl IN PO_TBL_NUMBER
256 , p_style_id_tbl IN PO_TBL_NUMBER
257 , p_retainage_rate_tbl IN PO_TBL_NUMBER
258 , p_max_retain_amt_tbl IN PO_TBL_NUMBER
259 , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
260 , p_recoupment_rate_tbl IN PO_TBL_NUMBER
261 , p_advance_tbl IN PO_TBL_NUMBER
262 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
263 , x_result_type OUT NOCOPY VARCHAR2
264 );
265 -- <PDOI for Complex PO Project: End>
266
267 -- <Complex Work R12 End>
268
269 PROCEDURE unit_meas_not_null(
270 p_line_id_tbl IN PO_TBL_NUMBER
271 , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
272 , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
273 , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
274 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
275 , x_result_type OUT NOCOPY VARCHAR2
276 );
277
278 PROCEDURE item_description_not_null(
279 p_line_id_tbl IN PO_TBL_NUMBER
280 , p_item_description_tbl IN PO_TBL_VARCHAR2000
281 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
282 , x_result_type OUT NOCOPY VARCHAR2
283 );
284
285 PROCEDURE category_id_not_null(
286 p_line_id_tbl IN PO_TBL_NUMBER
287 , p_category_id_tbl IN PO_TBL_NUMBER
288 , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
289 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
290 , x_result_type OUT NOCOPY VARCHAR2
291 );
292
293 PROCEDURE item_id_not_null(
294 p_id_tbl IN PO_TBL_NUMBER
295 , p_item_id_tbl IN PO_TBL_NUMBER
296 , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
297 , p_line_type_id_tbl IN PO_TBL_NUMBER
298 , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
299 , p_message_name IN VARCHAR2
300 , x_result_set_id IN OUT NOCOPY NUMBER
301 , x_result_type OUT NOCOPY VARCHAR2
302 );
303
304 PROCEDURE temp_labor_job_id_not_null(
305 p_line_id_tbl IN PO_TBL_NUMBER
306 , p_job_id_tbl IN PO_TBL_NUMBER
307 , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
308 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
309 , x_result_type OUT NOCOPY VARCHAR2
310 );
311
312 PROCEDURE line_type_id_not_null(
313 p_line_id_tbl IN PO_TBL_NUMBER
314 , p_line_type_id_tbl IN PO_TBL_NUMBER
315 , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
316 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
317 , x_result_type OUT NOCOPY VARCHAR2
318 );
319
320 PROCEDURE temp_lbr_start_date_not_null(
321 p_line_id_tbl IN PO_TBL_NUMBER
322 , p_start_date_tbl IN PO_TBL_DATE
323 , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
324 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
325 , x_result_type OUT NOCOPY VARCHAR2
326 );
327
328 PROCEDURE src_doc_line_not_null(
329 p_line_id_tbl IN PO_TBL_NUMBER
330 , p_from_header_id_tbl IN PO_TBL_NUMBER
331 , p_from_line_id_tbl IN PO_TBL_NUMBER
335 -- OPM Integration R12 Start
332 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
333 , x_result_type OUT NOCOPY VARCHAR2
334 );
336 PROCEDURE line_sec_quantity_gt_zero(
337 p_line_id_tbl IN PO_TBL_NUMBER
338 , p_item_id_tbl IN PO_TBL_NUMBER
339 , p_sec_quantity_tbl IN PO_TBL_NUMBER
340 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
341 , x_result_type OUT NOCOPY VARCHAR2
342 );
343
344 PROCEDURE line_qtys_within_deviation (
345 p_line_id_tbl IN PO_TBL_NUMBER
346 , p_item_id_tbl IN PO_TBL_NUMBER
347 , p_quantity_tbl IN PO_TBL_NUMBER
348 , p_primary_uom_tbl IN PO_TBL_VARCHAR30
349 , p_sec_quantity_tbl IN PO_TBL_NUMBER
350 , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
351 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
352 , x_result_type OUT NOCOPY VARCHAR2
353 );
354 -- OPM Integration R12 End
355
356 PROCEDURE from_line_id_not_null (
357 p_line_id_tbl IN PO_TBL_NUMBER
358 , p_from_header_id_tbl IN PO_TBL_NUMBER
359 , p_from_line_id_tbl IN PO_TBL_NUMBER
360 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
361 , x_result_type OUT NOCOPY VARCHAR2
362 );
363
364 -- CLM changes start
365
366 PROCEDURE option_from_date_not_null (
367 p_line_id_tbl IN PO_TBL_NUMBER
368 , p_option_ind_tbl IN PO_TBL_VARCHAR1
369 ,p_option_from_date_tbl IN PO_TBL_DATE
370 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
371 , x_result_type OUT NOCOPY VARCHAR2
372 );
373
374 PROCEDURE option_to_date_not_null (
375 p_line_id_tbl IN PO_TBL_NUMBER
376 , p_option_ind_tbl IN PO_TBL_VARCHAR1
377 ,p_option_to_Date_tbl IN PO_TBL_DATE
378 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
379 , x_result_type OUT NOCOPY VARCHAR2
380 );
381
382 PROCEDURE option_to_date_le_from_date (
383 p_line_id_tbl IN PO_TBL_NUMBER
384 , p_option_ind_tbl IN PO_TBL_VARCHAR1
385 ,p_option_from_date_tbl IN PO_TBL_DATE
386 ,p_option_to_Date_tbl IN PO_TBL_DATE
387 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
388 , x_result_type OUT NOCOPY VARCHAR2
389 );
390
391 PROCEDURE option_from_date_le_sysdate (
392 p_line_id_tbl IN PO_TBL_NUMBER
393 , p_option_ind_tbl IN PO_TBL_VARCHAR1
394 ,p_option_from_date_tbl IN PO_TBL_DATE
395 , p_draft_id_tbl IN PO_TBL_NUMBER
396 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
397 , x_result_type OUT NOCOPY VARCHAR2
398 );
399
400 PROCEDURE option_fm_date_le_ex_date (
401 p_line_id_tbl IN PO_TBL_NUMBER
402 , p_exer_flag_tbl IN PO_TBL_VARCHAR1
403 , p_option_from_date_tbl IN PO_TBL_DATE
404 , p_option_exer_date_tbl IN PO_TBL_DATE
405 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
406 , x_result_type OUT NOCOPY VARCHAR2
407 );
408
409
410 PROCEDURE line_num_disp_check (
411 p_line_id_tbl IN PO_TBL_NUMBER
412 , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
413 , p_group_line_id_tbl IN PO_TBL_NUMBER
414 ,p_clm_exhibit_name_tbl IN PO_TBL_VARCHAR20
415 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
416 , x_result_type OUT NOCOPY VARCHAR2
417 );
418
419 -- CLM END
420 -- Mod Project
421 PROCEDURE mod_no_cancel_shp_complt(
422 p_line_id_tbl IN PO_TBL_NUMBER
423 ,p_control_action_tbl IN PO_TBL_VARCHAR30
424 ,x_result_set_id IN OUT NOCOPY NUMBER
425 ,x_result_type OUT NOCOPY VARCHAR2
426 );
427
428 -- For Fed Fileds CLM
429 PROCEDURE order_start_date_le_end_date
430 (
431 p_line_id_tbl IN PO_TBL_NUMBER
432 , p_start_date_tbl IN PO_TBL_DATE
433 , p_expiration_date_tbl IN PO_TBL_DATE
434 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
435 , x_result_type OUT NOCOPY VARCHAR2
436 );
437
438 PROCEDURE order_start_date_gt_sysdate
439 (
440 p_line_id_tbl IN PO_TBL_NUMBER
441 , p_order_from_date_tbl IN PO_TBL_DATE
442 , p_draft_id_tbl IN PO_TBL_NUMBER
443 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
444 , x_result_type OUT NOCOPY VARCHAR2
445 );
446
447 PROCEDURE max_tot_amt_le_line_tot_amt
448 (
449 p_line_id_tbl IN PO_TBL_NUMBER
450 , p_max_total_amt_tbl IN PO_TBL_NUMBER
451 , p_line_amount_tbl IN PO_TBL_NUMBER
452 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
453 , x_result_type OUT NOCOPY VARCHAR2
454 );
455
456 PROCEDURE max_tot_amt_ge_min_tot_amt
457 (
458 p_line_id_tbl IN PO_TBL_NUMBER
459 , p_max_total_amt_tbl IN PO_TBL_NUMBER
460 , p_min_total_amt_tbl IN PO_TBL_NUMBER
461 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
462 , x_result_type OUT NOCOPY VARCHAR2
463 );
464
465 PROCEDURE max_tot_qty_le_line_tot_qty
466 (
467 p_line_id_tbl IN PO_TBL_NUMBER
468 , p_max_total_qty_tbl IN PO_TBL_NUMBER
469 , p_line_qty_tbl IN PO_TBL_NUMBER
470 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
471 , x_result_type OUT NOCOPY VARCHAR2
472 );
473
474 PROCEDURE max_tot_qty_ge_min_tot_qty
475 (
476 p_line_id_tbl IN PO_TBL_NUMBER
477 , p_max_total_qty_tbl IN PO_TBL_NUMBER
481 );
478 , p_min_total_qty_tbl IN PO_TBL_NUMBER
479 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
480 , x_result_type OUT NOCOPY VARCHAR2
482
483 PROCEDURE max_ord_amt_le_max_tot_amt
484 (
485 p_line_id_tbl IN PO_TBL_NUMBER
486 , p_max_order_amt_tbl IN PO_TBL_NUMBER
487 , p_max_tot_amount_tbl IN PO_TBL_NUMBER
488 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
489 , x_result_type OUT NOCOPY VARCHAR2
490 );
491
492 PROCEDURE max_ord_amt_ge_min_ord_amt
493 (
494 p_line_id_tbl IN PO_TBL_NUMBER
495 , p_max_ord_amt_tbl IN PO_TBL_NUMBER
496 , p_min_ord_amt_tbl IN PO_TBL_NUMBER
497 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
498 , x_result_type OUT NOCOPY VARCHAR2
499 );
500
501 PROCEDURE max_ord_qty_le_max_tot_qty
502 (
503 p_line_id_tbl IN PO_TBL_NUMBER
504 , p_max_order_qty_tbl IN PO_TBL_NUMBER
505 , p_max_tot_qty_tbl IN PO_TBL_NUMBER
506 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
507 , x_result_type OUT NOCOPY VARCHAR2
508 );
509
510 PROCEDURE max_ord_qty_ge_min_ord_qty
511 (
512 p_line_id_tbl IN PO_TBL_NUMBER
513 , p_max_ord_qty_tbl IN PO_TBL_NUMBER
514 , p_min_ord_qty_tbl IN PO_TBL_NUMBER
515 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
516 , x_result_type OUT NOCOPY VARCHAR2
517 );
518
519 PROCEDURE clin_slin_num_check(
520 p_header_id_tbl IN PO_TBL_NUMBER,
521 p_draft_id_tbl IN PO_TBL_NUMBER,
522 p_line_id_tbl IN PO_TBL_NUMBER,
523 p_group_line_id_tbl IN PO_TBL_NUMBER,
524 p_line_num_display_tbl IN PO_TBL_VARCHAR100,
525 p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL, --<PAR Project>
526 x_result_set_id IN OUT NOCOPY NUMBER,
527 x_result_type OUT NOCOPY VARCHAR2
528 );
529
530 --CLM PDOI Integration Starts
531 PROCEDURE clin_slin_structure(
532 p_line_id_tbl IN PO_TBL_NUMBER,
533 --p_draft_id_tbl IN PO_TBL_NUMBER,
534 p_intf_line_id_tbl IN PO_TBL_NUMBER,
535 p_group_line_id_tbl IN PO_TBL_NUMBER,
536 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
537 x_result_type OUT NOCOPY VARCHAR2
538 );
539
540 PROCEDURE validate_contract_type(
541 p_intf_line_id_tbl IN PO_TBL_NUMBER
542 , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
543 , p_contract_type_tbl IN PO_TBL_VARCHAR240
544 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
545 , x_result_type OUT NOCOPY VARCHAR2
546 );
547
548 PROCEDURE validate_cost_constraint(
549 p_intf_line_id_tbl IN PO_TBL_NUMBER
550 , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
551 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
552 , x_result_type OUT NOCOPY VARCHAR2
553 );
554
555 PROCEDURE check_contract_num_and_ver(
556 p_intf_line_id_tbl IN PO_TBL_NUMBER
557 , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER
558 , p_oke_contract_header_num_tbl IN PO_TBL_VARCHAR240
559 , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER
560 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
561 , x_result_type OUT NOCOPY VARCHAR2
562 );
563
564 PROCEDURE validate_option_indicator(
565 p_intf_line_id_tbl IN PO_TBL_NUMBER
566 , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
567 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
568 , x_result_type OUT NOCOPY VARCHAR2
569 );
570
571 PROCEDURE validate_clm_base_line_num(
572 p_intf_line_id_tbl IN PO_TBL_NUMBER
573 , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
574 , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
575 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
576 , x_result_type OUT NOCOPY VARCHAR2
577 );
578
579 PROCEDURE validate_clm_option_num(
580 p_intf_line_id_tbl IN PO_TBL_NUMBER
581 , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
582 , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
583 , p_clm_option_num_tbl IN PO_TBL_NUMBER
584 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
585 , x_result_type OUT NOCOPY VARCHAR2
586 );
587
588 PROCEDURE validate_clm_idc_type(
589 p_intf_line_id_tbl IN PO_TBL_NUMBER
590 , p_clm_idc_type_tbl IN PO_TBL_VARCHAR240
591 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
592 , x_result_type OUT NOCOPY VARCHAR2
593 );
594
595 PROCEDURE validate_clin_line_num_disp(
596 p_intf_line_id_tbl IN PO_TBL_NUMBER
597 , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
598 , p_group_line_id_tbl IN PO_TBL_NUMBER
599 , p_intf_header_id_tbl IN PO_TBL_NUMBER
600 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
601 , x_result_type OUT NOCOPY VARCHAR2
602 );
603
604 PROCEDURE idv_reference_equal_check(
605 p_intf_line_id_tbl IN PO_TBL_NUMBER
606 , p_from_header_id_tbl IN PO_TBL_NUMBER
607 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
608 , x_result_type OUT NOCOPY VARCHAR2
609 );
610
614 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
611 PROCEDURE validate_clm_line_type_id(
612 p_intf_line_id_tbl IN PO_TBL_NUMBER
613 , p_line_type_id_tbl IN PO_TBL_NUMBER
615 , x_result_type OUT NOCOPY VARCHAR2
616 );
617 --CLM PDOI Integration Ends
618
619 PROCEDURE validate_comments_not_null(
620 p_line_id_tbl IN PO_TBL_NUMBER
621 , p_draft_id_tbl IN PO_TBL_NUMBER
622 , p_draft_type_tbl IN PO_TBL_VARCHAR30
623 , p_comments_tbl IN PO_TBL_VARCHAR2000
624 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
625 , x_result_type OUT NOCOPY VARCHAR2
626 );
627
628 -- CLM Phase 4 - Elins project
629 PROCEDURE validate_exhibit_name (
630 p_header_id_tbl IN PO_TBL_NUMBER,
631 p_draft_id_tbl IN PO_TBL_NUMBER,
632 p_line_id_tbl IN PO_TBL_NUMBER,
633 p_exhibit_name_tbl IN PO_TBL_VARCHAR20,
634 x_result_set_id IN OUT NOCOPY NUMBER,
635 x_result_type OUT NOCOPY VARCHAR2
636 );
637 -- bug 16461105
638 PROCEDURE validate_undef_amt_le_line_amt(
639 p_po_line_id IN PO_TBL_NUMBER,
640 p_order_type_lookup_code IN PO_TBL_VARCHAR30,
641 p_unit_price IN PO_TBL_NUMBER,
642 p_quantity IN PO_TBL_NUMBER,
643 p_old_quantity IN PO_TBL_NUMBER,
644 p_old_unit_price IN PO_TBL_NUMBER,
645 p_draft_id IN PO_TBL_NUMBER,
646 p_undef_amount IN PO_TBL_NUMBER,
647 p_po_line_uca_id IN PO_TBL_NUMBER,
648 p_ucas_po_line_id IN PO_TBL_NUMBER,
649 x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,
650 x_result_type OUT nocopy VARCHAR2);
651 -- bug 16461105
652
653 END PO_VAL_LINES;