APPS.PO_VAL_SHIPMENTS dependencies on PO_TBL_VARCHAR30

Line 361: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

357: -- : The match approval level of a payitem cannot be 4WAY
358: -------------------------------------------------------------------------
359: PROCEDURE match_4way_check(
360: p_line_loc_id_tbl IN PO_TBL_NUMBER
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

Line 364: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --

360: p_line_loc_id_tbl IN PO_TBL_NUMBER
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

Line 528: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

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

Line 596: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

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

Line 666: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --

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

Line 718: , p_shipment_type_tbl IN PO_TBL_VARCHAR30 --

714: PROCEDURE ship_num_unique_check(
715: p_line_loc_id_tbl IN PO_TBL_NUMBER
716: , p_line_id_tbl IN PO_TBL_NUMBER
717: , p_shipment_num_tbl IN PO_TBL_NUMBER
718: , p_shipment_type_tbl IN PO_TBL_VARCHAR30 --
719: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
720: , p_draft_id_tbl IN PO_TBL_NUMBER
721: , x_result_set_id IN OUT NOCOPY NUMBER
722: , x_result_type OUT NOCOPY VARCHAR2

Line 887: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

883: -----------------------------------------------------------------------------
884: PROCEDURE quantity_gt_zero(
885: p_line_loc_id_tbl IN PO_TBL_NUMBER
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

Line 888: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

884: PROCEDURE quantity_gt_zero(
885: p_line_loc_id_tbl IN PO_TBL_NUMBER
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 --

Line 889: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

885: p_line_loc_id_tbl IN PO_TBL_NUMBER
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: )

Line 1114: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

1110: -----------------------------------------------------------------------------
1111: PROCEDURE amount_gt_zero(
1112: p_line_loc_id_tbl IN PO_TBL_NUMBER
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

Line 1115: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

1111: PROCEDURE amount_gt_zero(
1112: p_line_loc_id_tbl IN PO_TBL_NUMBER
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 --

Line 1116: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

1112: p_line_loc_id_tbl IN PO_TBL_NUMBER
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: )

Line 1386: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

1382: p_line_loc_id_tbl IN PO_TBL_NUMBER
1383: , p_item_id_tbl IN PO_TBL_NUMBER
1384: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
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

Line 1388: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

1384: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
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

Line 1436: , p_payment_type_tbl IN PO_TBL_VARCHAR30

1432: -- b. rate based Pay Items with payment type as Rate or Delivery
1433: -----------------------------------------------------------------------------
1434: PROCEDURE unit_of_measure_not_null(
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

Line 1437: , p_value_basis_tbl IN PO_TBL_VARCHAR30

1433: -----------------------------------------------------------------------------
1434: PROCEDURE unit_of_measure_not_null(
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

Line 1438: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30

1434: PROCEDURE unit_of_measure_not_null(
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:

Line 1499: ,p_control_action_tbl IN PO_TBL_VARCHAR30

1495:
1496: --Mod Project
1497: PROCEDURE mod_no_cancel_shp_complt(
1498: p_line_loc_id_tbl IN PO_TBL_NUMBER
1499: ,p_control_action_tbl IN PO_TBL_VARCHAR30
1500: ,x_result_set_id IN OUT NOCOPY NUMBER
1501: ,x_result_type OUT NOCOPY VARCHAR2
1502: )
1503: IS

Line 1676: , p_value_basis_tbl IN PO_TBL_VARCHAR30

1672: -------------------------------------------------------------------------
1673: PROCEDURE complex_price_or_gt_zero(
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: )

Line 1677: , p_payment_type_tbl IN PO_TBL_VARCHAR30

1673: PROCEDURE complex_price_or_gt_zero(
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