Search Results po_val_shipments
Overview
PO_VAL_SHIPMENTS is a validation package in the Oracle E-Business Suite (EBS) Purchasing module, owned by the APPS schema. It provides the server-side business rule engine that verifies shipment-level attributes on purchase order lines and line locations before a document can be saved or approved. In Oracle releases 12.1.1 and 12.2.2, the Purchasing forms and the underlying validation framework route shipment data through this package to ensure that receipt tolerances, invoice matching rules, dates, quantities, and organizational assignments conform to configured system parameters.
The package is registered in ETRM with an API classification of OTHER and exposes twenty-five documented procedures and functions. Its design follows the standard EBS validation pattern: callers pass a table of line-location identifiers together with the corresponding attribute values, and the procedures return results through PO_VALIDATION_RESULTS_TYPE collections and a result type indicator. This bulk, set-based approach allows the form to validate many shipments in a single round trip.
Key Procedures and Functions
The documented procedures cover several distinct validation domains.
- Tolerance checks: DAYS_EARLY_GTE_ZERO, DAYS_LATE_GTE_ZERO, RCV_CLOSE_TOL_WITHIN_RANGE, OVER_RCPT_TOL_WITHIN_RANGE, and INV_CLOSE_TOL_RANGE_CHECK enforce that early and late receipt allowances, receiving close tolerances, over-receipt tolerances, and invoice close tolerances fall within permitted ranges.
- Date checks: PLANNED_ITEM_NULL_DATE_CHECK, NEED_BY_DATE_OPEN_PERIOD_CHECK, and PROMISE_DATE_OPEN_PERIOD_CHECK verify that need-by and promised dates are populated where required and fall in an open accounting period.
- Matching rules: MATCH_4WAY_CHECK validates the four-way match configuration, evaluating value basis, receipt-required and inspection-required flags, and payment type — parameters that carry R12 Complex Work relevance.
- Organization and location checks: SHIP_TO_ORG_NULL_CHECK, SHIP_TO_LOC_NULL_CHECK, and IS_ORG_IN_CURRENT_SOB_CHECK confirm that ship-to organizations and locations are present and belong to the current set of books.
- Shipment numbering: SHIP_NUM_GT_ZERO and SHIP_NUM_UNIQUE_CHECK ensure shipment numbers are positive and unique.
- Quantity and amount checks: QUANTITY_GT_ZERO, QUANTITY_GE_QUANTITY_EXEC, AMOUNT_GT_ZERO, AMOUNT_GE_AMOUNT_EXEC, SHIP_SEC_QUANTITY_GT_ZERO, and SHIP_QTYS_WITHIN_DEVIATION confirm that ordered and secondary quantities and amounts are positive and consistent with executed values within allowed deviation.
Tables Accessed
The package reads and writes the following objects through APPS synonyms:
- PO_LINE_LOCATIONS_ALL — the primary shipment and distribution record set being validated.
- FINANCIALS_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMS_ALL — source of tolerance and matching configuration defaults.
- MTL_SYSTEM_ITEMS — item attributes needed by the planned-item date validation.
- PO_SESSION_GT — global temporary table holding session context for validation.
- PO_VALIDATION_RESULTS_GT — global temporary table storing validation outcomes returned to the caller.
- DUAL and PLITBLM — utility references used within the validation logic.
Usage Notes
PO_VAL_SHIPMENTS is typically invoked from the Purchasing forms during shipment entry and from the PO validation framework when a document is saved, submitted for approval, or processed by concurrent programs. It is referenced by one other package, indicating it participates in a layered validation call chain rather than being called directly by end users. Customizations and extensions that manipulate shipment tolerances, dates, or quantities should invoke these procedures in the same manner as the standard form to preserve consistency with seeded validation behavior. Because the package operates on collections, callers must populate the corresponding PO_TBL_NUMBER and PO_TBL_DATE structures before invocation. The presence of the "Complex Work R12" annotations on MATCH_4WAY_CHECK parameters indicates that the package was updated to support R12 procurement functionality, making it relevant to both 12.1.1 and 12.2.2 environments.
-
PACKAGE: APPS.PO_VAL_SHIPMENTS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_VAL_SHIPMENTS, status:VALID,
-
PACKAGE: APPS.PO_VAL_SHIPMENTS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_VAL_SHIPMENTS, status:VALID,
-
PACKAGE BODY: APPS.PO_VAL_SHIPMENTS
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_VAL_SHIPMENTS, status:VALID,
-
PACKAGE BODY: APPS.PO_VAL_SHIPMENTS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_VAL_SHIPMENTS, status:VALID,
-
TYPE: APPS.PO_TBL_VARCHAR4000
12.2.2
owner:APPS, object_type:TYPE, object_name:PO_TBL_VARCHAR4000, status:VALID,
-
TYPE: APPS.PO_VALIDATION_RESULTS_TYPE
12.1.1
owner:APPS, object_type:TYPE, object_name:PO_VALIDATION_RESULTS_TYPE, status:VALID,
-
PACKAGE: APPS.PO_VALIDATION_HELPER
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_VALIDATION_HELPER, status:VALID,
-
PACKAGE: APPS.PO_TYPE_CONVERTER
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_TYPE_CONVERTER, status:VALID,
-
TYPE: APPS.PO_VALIDATION_RESULTS_TYPE
12.2.2
owner:APPS, object_type:TYPE, object_name:PO_VALIDATION_RESULTS_TYPE, status:VALID,
-
SYNONYM: APPS.PO_VALIDATION_RESULTS_GT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_VALIDATION_RESULTS_GT, status:VALID,
-
PACKAGE: APPS.PO_TYPE_CONVERTER
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_TYPE_CONVERTER, status:VALID,
-
PACKAGE: APPS.PO_VALIDATION_HELPER
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_VALIDATION_HELPER, status:VALID,
-
SYNONYM: APPS.PO_VALIDATION_RESULTS_GT
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_VALIDATION_RESULTS_GT, status:VALID,
-
PACKAGE: APPS.PO_VALIDATIONS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_VALIDATIONS, status:VALID,
-
TYPE: APPS.PO_TBL_DATE
12.1.1
owner:APPS, object_type:TYPE, object_name:PO_TBL_DATE, status:VALID,
-
TYPE: APPS.PO_TBL_DATE
12.2.2
owner:APPS, object_type:TYPE, object_name:PO_TBL_DATE, status:VALID,
-
PACKAGE: APPS.PO_CLM_CLO_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CLM_CLO_UTIL, status:VALID,
-
TYPE: APPS.PO_TBL_VARCHAR4000
12.1.1
owner:APPS, object_type:TYPE, object_name:PO_TBL_VARCHAR4000, status:VALID,
-
PACKAGE BODY: APPS.PO_VALIDATIONS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_VALIDATIONS, status:VALID,
-
PACKAGE: APPS.PO_CLM_INTG_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CLM_INTG_GRP, status:VALID,
-
PACKAGE: APPS.PO_VALIDATIONS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_VALIDATIONS, status:VALID,
-
PACKAGE BODY: APPS.PO_VALIDATIONS
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_VALIDATIONS, status:VALID,
-
TYPE: APPS.PO_TBL_VARCHAR1
12.1.1
owner:APPS, object_type:TYPE, object_name:PO_TBL_VARCHAR1, status:VALID,
-
TYPE: APPS.PO_TBL_VARCHAR1
12.2.2
owner:APPS, object_type:TYPE, object_name:PO_TBL_VARCHAR1, status:VALID,
-
TYPE: APPS.PO_TBL_VARCHAR30
12.1.1
owner:APPS, object_type:TYPE, object_name:PO_TBL_VARCHAR30, status:VALID,
-
TYPE: APPS.PO_TBL_VARCHAR30
12.2.2
owner:APPS, object_type:TYPE, object_name:PO_TBL_VARCHAR30, status:VALID,
-
SYNONYM: APPS.PO_SESSION_GT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_SESSION_GT, status:VALID,
-
PACKAGE: APPS.PO_VAL_SHIPMENTS
12.1.1
-
SYNONYM: APPS.PO_SESSION_GT
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_SESSION_GT, status:VALID,
-
PACKAGE: APPS.PO_VAL_SHIPMENTS
12.2.2
-
TYPE: APPS.PO_TBL_NUMBER
12.1.1
owner:APPS, object_type:TYPE, object_name:PO_TBL_NUMBER, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
TYPE: APPS.PO_TBL_NUMBER
12.2.2
owner:APPS, object_type:TYPE, object_name:PO_TBL_NUMBER, status:VALID,
-
PACKAGE: APPS.PO_LOG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_LOG, status:VALID,
-
PACKAGE: APPS.PO_CORE_S
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_CORE_S, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
PACKAGE: APPS.PO_CORE_S
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CORE_S, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
PACKAGE: APPS.PO_LOG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_LOG, status:VALID,
-
SYNONYM: APPS.FINANCIALS_SYSTEM_PARAMETERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FINANCIALS_SYSTEM_PARAMETERS, status:VALID,
-
SYNONYM: APPS.FINANCIALS_SYSTEM_PARAMS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FINANCIALS_SYSTEM_PARAMS_ALL, status:VALID,
-
SYNONYM: APPS.FINANCIALS_SYSTEM_PARAMETERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FINANCIALS_SYSTEM_PARAMETERS, status:VALID,
-
SYNONYM: APPS.FINANCIALS_SYSTEM_PARAMS_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FINANCIALS_SYSTEM_PARAMS_ALL, status:VALID,
-
APPS.PO_VALIDATIONS dependencies on PO_VAL_SHIPMENTS
12.2.2
-
APPS.PO_VAL_SHIPMENTS dependencies on PO_VAL_SHIPMENTS
12.1.1
-
APPS.PO_VALIDATIONS dependencies on PO_VAL_SHIPMENTS
12.1.1
-
APPS.PO_VAL_SHIPMENTS dependencies on PO_VAL_SHIPMENTS
12.2.2
-
PACKAGE: APPS.PO_MESSAGE_S
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_MESSAGE_S, status:VALID,
-
PACKAGE: APPS.PO_MESSAGE_S
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_MESSAGE_S, status:VALID,