DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_VALIDATION_RESULTS_TYPE

Line 149: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

145:
146: PROCEDURE days_early_gte_zero(
147: p_line_loc_id_tbl IN PO_TBL_NUMBER
148: , p_days_early_rcpt_allowed_tbl IN PO_TBL_NUMBER
149: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
150: , x_result_type OUT NOCOPY VARCHAR2
151: )
152: IS
153: BEGIN

Line 176: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

172: -------------------------------------------------------------------------
173: PROCEDURE days_late_gte_zero(
174: p_line_loc_id_tbl IN PO_TBL_NUMBER
175: , p_days_late_rcpt_allowed_tbl IN PO_TBL_NUMBER
176: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
177: , x_result_type OUT NOCOPY VARCHAR2
178: )
179: IS
180: BEGIN

Line 204: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

200:
201: PROCEDURE rcv_close_tol_within_range (
202: p_line_loc_id_tbl IN PO_TBL_NUMBER
203: , p_receive_close_tolerance_tbl IN PO_TBL_NUMBER
204: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
205: , x_result_type OUT NOCOPY VARCHAR2
206: )
207: IS
208: BEGIN

Line 231: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

227:
228: PROCEDURE over_rcpt_tol_within_range (
229: p_line_loc_id_tbl IN PO_TBL_NUMBER
230: , p_qty_rcv_tolerance_tbl IN PO_TBL_NUMBER
231: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
232: , x_result_type OUT NOCOPY VARCHAR2
233: )
234: IS
235: BEGIN

Line 365: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

361: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
362: , p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1
363: , p_inspection_required_flag_tbl IN PO_TBL_VARCHAR1
364: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
365: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
366: , x_result_type OUT NOCOPY VARCHAR2
367: )
368: IS
369: d_mod CONSTANT VARCHAR2(100) := D_match_4way_check;

Line 384: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

380: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
381: END IF;
382:
383: IF (x_results IS NULL) THEN
384: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
385: END IF;
386:
387: l_results_count := x_results.result_type.COUNT;
388:

Line 432: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

428: -------------------------------------------------------------------------
429: PROCEDURE inv_close_tol_range_check (
430: p_line_loc_id_tbl IN PO_TBL_NUMBER
431: , p_invoice_close_tolerance_tbl IN PO_TBL_NUMBER
432: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
433: , x_result_type OUT NOCOPY VARCHAR2
434: )
435: IS
436: BEGIN

Line 529: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

525: PROCEDURE ship_to_org_null_check(
526: p_line_loc_id_tbl IN PO_TBL_NUMBER
527: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
528: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
529: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
530: , x_result_type OUT NOCOPY VARCHAR2
531: )
532: IS
533: d_mod CONSTANT VARCHAR2(100) := D_ship_to_org_null_check;

Line 597: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

593: PROCEDURE ship_to_loc_null_check(
594: p_line_loc_id_tbl IN PO_TBL_NUMBER
595: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
596: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
597: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
598: , x_result_type OUT NOCOPY VARCHAR2
599: )
600: IS
601: d_mod CONSTANT VARCHAR2(100) := D_ship_to_loc_null_check;

Line 667: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

663: PROCEDURE ship_num_gt_zero(
664: p_line_loc_id_tbl IN PO_TBL_NUMBER
665: , p_shipment_num_tbl IN PO_TBL_NUMBER
666: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
667: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
668: , x_result_type OUT NOCOPY VARCHAR2
669: )
670: IS
671: l_line_loc_id_tbl PO_TBL_NUMBER; --

Line 753: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

749: , p_line_id_tbl IN PO_TBL_NUMBER
750: , p_org_id_tbl IN PO_TBL_NUMBER
751: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
752: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
753: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
754: , x_result_type OUT NOCOPY VARCHAR2
755: )
756: IS
757: d_mod CONSTANT VARCHAR2(100) := D_is_org_in_current_sob_check;

Line 781: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

777: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
778: END IF;
779:
780: IF (x_results IS NULL) THEN
781: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
782: END IF;
783:
784: l_results_count := x_results.result_type.COUNT;
785:

Line 890: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

886: , p_quantity_tbl IN PO_TBL_NUMBER
887: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
888: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
889: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
890: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
891: , x_result_type OUT NOCOPY VARCHAR2
892: , p_header_id_tbl IN PO_TBL_NUMBER --
893: )
894: IS

Line 1117: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1113: , p_amount_tbl IN PO_TBL_NUMBER
1114: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
1115: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
1116: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
1117: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1118: , x_result_type OUT NOCOPY VARCHAR2
1119: , p_header_id_tbl IN PO_TBL_NUMBER --
1120: )
1121: IS

Line 1342: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1338: p_line_loc_id_tbl IN PO_TBL_NUMBER
1339: , p_item_id_tbl IN PO_TBL_NUMBER
1340: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1341: , p_sec_quantity_tbl IN PO_TBL_NUMBER
1342: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1343: , x_result_type OUT NOCOPY VARCHAR2
1344: )
1345: IS
1346: d_mod CONSTANT VARCHAR2(100) := D_ship_sec_quantity_gt_zero;

Line 1389: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1385: , p_quantity_tbl IN PO_TBL_NUMBER
1386: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
1387: , p_sec_quantity_tbl IN PO_TBL_NUMBER
1388: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
1389: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1390: , x_result_type OUT NOCOPY VARCHAR2
1391: )
1392: IS
1393:

Line 1439: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1435: p_line_loc_id_tbl IN PO_TBL_NUMBER
1436: , p_payment_type_tbl IN PO_TBL_VARCHAR30
1437: , p_value_basis_tbl IN PO_TBL_VARCHAR30
1438: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
1439: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1440: , x_result_type OUT NOCOPY VARCHAR2
1441: ) IS
1442:
1443: d_mod CONSTANT VARCHAR2(100) := D_unit_of_meas_not_null;

Line 1456: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1453: END IF;
1454:
1455: IF (x_results IS NULL) THEN
1456: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1457: END IF;
1458:
1459: l_results_count := x_results.result_type.COUNT; -- Bug 5532560
1460:

Line 1565: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1561: (
1562: p_line_id_tbl IN PO_TBL_NUMBER
1563: , p_start_date_tbl IN PO_TBL_DATE
1564: , p_expiration_date_tbl IN PO_TBL_DATE
1565: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1566: , x_result_type OUT NOCOPY VARCHAR2
1567: )
1568: IS
1569: l_results_count NUMBER;

Line 1578: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1574: RETURN;
1575: END IF;
1576:
1577: IF (x_results IS NULL) THEN
1578: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1579: END IF;
1580:
1581: l_results_count := x_results.result_type.COUNT;
1582:

Line 1627: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1623: p_line_id_tbl IN PO_TBL_NUMBER
1624: , p_start_date_tbl IN PO_TBL_DATE
1625: , p_end_date_tbl IN PO_TBL_DATE
1626: , p_need_by_date_tbl IN PO_TBL_DATE
1627: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1628: , x_result_type OUT NOCOPY VARCHAR2
1629: )
1630: IS
1631: l_results_count NUMBER;

Line 1640: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1636: RETURN;
1637: END IF;
1638:
1639: IF (x_results IS NULL) THEN
1640: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1641: END IF;
1642:
1643: l_results_count := x_results.result_type.COUNT;
1644:

Line 1678: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1674: p_line_loc_id_tbl IN PO_TBL_NUMBER
1675: , p_price_override_tbl IN PO_TBL_NUMBER
1676: , p_value_basis_tbl IN PO_TBL_VARCHAR30
1677: , p_payment_type_tbl IN PO_TBL_VARCHAR30
1678: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1679: , x_result_type OUT NOCOPY VARCHAR2
1680: )
1681: IS
1682: d_mod CONSTANT VARCHAR2(100) := D_complex_price_or_gt_zero;