APPS.PO_VAL_LINES dependencies on PO_VALIDATION_RESULTS_TYPE

Line 7: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 14: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 24: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 --
27: );
28:

Line 42: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 (

Line 49: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 (

Line 56: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 64: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 99: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 --
102: );
103:

Line 122: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 139: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 172: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 181: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 195: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 205: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 ----
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(

Line 213: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 221: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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: --

Line 248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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:

Line 262: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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: --
266:

Line 274: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 281: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 289: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 308: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 316: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 324: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 332: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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
332: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
333: , x_result_type OUT NOCOPY VARCHAR2
334: );
335: -- OPM Integration R12 Start
336: PROCEDURE line_sec_quantity_gt_zero(

Line 340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 (

Line 351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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:

Line 360: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 370: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 (

Line 378: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 (

Line 387: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 (

Line 396: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 (

Line 405: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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:

Line 415: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 434: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 443: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 452: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 461: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 470: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 479: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

475: (
476: p_line_id_tbl IN PO_TBL_NUMBER
477: , p_max_total_qty_tbl IN PO_TBL_NUMBER
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
481: );
482:
483: PROCEDURE max_ord_amt_le_max_tot_amt

Line 488: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 497: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 506: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 515: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 536: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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(

Line 544: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 551: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 560: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 567: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 575: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 591: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 600: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 607: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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:
611: PROCEDURE validate_clm_line_type_id(

Line 614: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

610:
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
614: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
615: , x_result_type OUT NOCOPY VARCHAR2
616: );
617: --CLM PDOI Integration Ends
618:

Line 624: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 649: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,

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;