APPS.PO_VAL_SHIPMENTS dependencies on PO_TBL_VARCHAR30

Line 344: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

340: -- : The match approval level of a payitem cannot be 4WAY
341: -------------------------------------------------------------------------
342: PROCEDURE match_4way_check(
343: p_line_loc_id_tbl IN PO_TBL_NUMBER
344: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
345: , p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1
346: , p_inspection_required_flag_tbl IN PO_TBL_VARCHAR1
347: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
348: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 347: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --

343: p_line_loc_id_tbl IN PO_TBL_NUMBER
344: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
345: , p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1
346: , p_inspection_required_flag_tbl IN PO_TBL_VARCHAR1
347: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
348: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
349: , x_result_type OUT NOCOPY VARCHAR2
350: )
351: IS

Line 511: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

507: -------------------------------------------------------------------------
508: PROCEDURE ship_to_org_null_check(
509: p_line_loc_id_tbl IN PO_TBL_NUMBER
510: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
511: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
512: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
513: , x_result_type OUT NOCOPY VARCHAR2
514: )
515: IS

Line 579: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

575: -------------------------------------------------------------------------
576: PROCEDURE ship_to_loc_null_check(
577: p_line_loc_id_tbl IN PO_TBL_NUMBER
578: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
579: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
580: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
581: , x_result_type OUT NOCOPY VARCHAR2
582: )
583: IS

Line 649: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --

645: -----------------------------------------------------------------------------
646: PROCEDURE ship_num_gt_zero(
647: p_line_loc_id_tbl IN PO_TBL_NUMBER
648: , p_shipment_num_tbl IN PO_TBL_NUMBER
649: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
650: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
651: , x_result_type OUT NOCOPY VARCHAR2
652: )
653: IS

Line 701: , p_shipment_type_tbl IN PO_TBL_VARCHAR30 --

697: PROCEDURE ship_num_unique_check(
698: p_line_loc_id_tbl IN PO_TBL_NUMBER
699: , p_line_id_tbl IN PO_TBL_NUMBER
700: , p_shipment_num_tbl IN PO_TBL_NUMBER
701: , p_shipment_type_tbl IN PO_TBL_VARCHAR30 --
702: , x_result_set_id IN OUT NOCOPY NUMBER
703: , x_result_type OUT NOCOPY VARCHAR2
704: )
705: IS

Line 866: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

862: -----------------------------------------------------------------------------
863: PROCEDURE quantity_gt_zero(
864: p_line_loc_id_tbl IN PO_TBL_NUMBER
865: , p_quantity_tbl IN PO_TBL_NUMBER
866: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
867: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
868: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
869: , x_result_type OUT NOCOPY VARCHAR2
870: )

Line 867: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

863: PROCEDURE quantity_gt_zero(
864: p_line_loc_id_tbl IN PO_TBL_NUMBER
865: , p_quantity_tbl IN PO_TBL_NUMBER
866: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
867: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
868: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
869: , x_result_type OUT NOCOPY VARCHAR2
870: )
871: IS

Line 1048: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

1044: -----------------------------------------------------------------------------
1045: PROCEDURE amount_gt_zero(
1046: p_line_loc_id_tbl IN PO_TBL_NUMBER
1047: , p_amount_tbl IN PO_TBL_NUMBER
1048: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
1049: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
1050: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1051: , x_result_type OUT NOCOPY VARCHAR2
1052: )

Line 1049: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

1045: PROCEDURE amount_gt_zero(
1046: p_line_loc_id_tbl IN PO_TBL_NUMBER
1047: , p_amount_tbl IN PO_TBL_NUMBER
1048: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
1049: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
1050: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1051: , x_result_type OUT NOCOPY VARCHAR2
1052: )
1053: IS

Line 1273: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

1269: p_line_loc_id_tbl IN PO_TBL_NUMBER
1270: , p_item_id_tbl IN PO_TBL_NUMBER
1271: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1272: , p_quantity_tbl IN PO_TBL_NUMBER
1273: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
1274: , p_sec_quantity_tbl IN PO_TBL_NUMBER
1275: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
1276: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1277: , x_result_type OUT NOCOPY VARCHAR2

Line 1275: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

1271: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1272: , p_quantity_tbl IN PO_TBL_NUMBER
1273: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
1274: , p_sec_quantity_tbl IN PO_TBL_NUMBER
1275: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
1276: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1277: , x_result_type OUT NOCOPY VARCHAR2
1278: )
1279: IS

Line 1323: , p_payment_type_tbl IN PO_TBL_VARCHAR30

1319: -- b. rate based Pay Items with payment type as Rate or Delivery
1320: -----------------------------------------------------------------------------
1321: PROCEDURE unit_of_measure_not_null(
1322: p_line_loc_id_tbl IN PO_TBL_NUMBER
1323: , p_payment_type_tbl IN PO_TBL_VARCHAR30
1324: , p_value_basis_tbl IN PO_TBL_VARCHAR30
1325: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
1326: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1327: , x_result_type OUT NOCOPY VARCHAR2

Line 1324: , p_value_basis_tbl IN PO_TBL_VARCHAR30

1320: -----------------------------------------------------------------------------
1321: PROCEDURE unit_of_measure_not_null(
1322: p_line_loc_id_tbl IN PO_TBL_NUMBER
1323: , p_payment_type_tbl IN PO_TBL_VARCHAR30
1324: , p_value_basis_tbl IN PO_TBL_VARCHAR30
1325: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
1326: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1327: , x_result_type OUT NOCOPY VARCHAR2
1328: ) IS

Line 1325: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30

1321: PROCEDURE unit_of_measure_not_null(
1322: p_line_loc_id_tbl IN PO_TBL_NUMBER
1323: , p_payment_type_tbl IN PO_TBL_VARCHAR30
1324: , p_value_basis_tbl IN PO_TBL_VARCHAR30
1325: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
1326: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1327: , x_result_type OUT NOCOPY VARCHAR2
1328: ) IS
1329: