Search Results container_tare_weight_self

Overview

WSH_TPA_CONTAINER_PKG is a generated PL/SQL package owned by APPS that supports Oracle EBS shipping and container (packing) functionality within the Order Management, Shipping Execution, and warehouse management flows. The package header explicitly states that the file is always generated by the TPA Generate Utility and must not be edited manually. It is declared with AUTHID CURRENT_USER, meaning that runtime privileges are evaluated in the context of the calling user rather than the package owner. In EBS 12.1.1 and 12.2.2, this package operates in the container and delivery model — a two-tier structure in which a master container holds detail containers, and detail containers hold delivery details and items. It is closely related to the Trading Partner Agreement (TPA) / container packing infrastructure. Functions include calculating tare weights, fill percentages, gross and net weights, and volumes for containers, validating serial numbers, and estimating the number of master or detail containers required for a shipment. The package header revision provided (115.4, dated 2003) is the base version; later releases may hold higher revision levels, but the documented procedure set remains as listed below. ETRM classifies the API type as OTHER.

Key Procedures and Functions

The documented interface exposes six procedures:

• Container_Tare_Weight_Self — Derives the tare (empty) weight of a container. It takes a container instance ID, the container item ID, a weight unit of measure, and an organization ID, and returns the tare weight along with a return status. It is used when a container's own empty weight must be established before net weight can be calculated.
• Calc_Cont_Fill_Pc — Calculates the fill percentage of a container. Its documented inputs are the container instance ID, an update flag, and a fill percentage basis; it returns the fill percent and a return status. The p_update_flag controls whether the calculated value is persisted back to the container record, and p_fill_pc_basis selects the metric (weight or volume) used to express how full the container is.
• Container_Weight_Volume — Computes gross weight, net weight, and volume for a container, accepting an override flag, a fill percentage flag, and a flag indicating whether weights and volumes should be calculated for frozen containers.
• Validate_Master_Serial_Number — Checks the validity of a master serial number against a container instance and returns a status.
• Estimate_Master_Containers — Estimates the number of master containers needed, given a container instance, master and detail container item IDs, and an organization ID.
• Estimate_Detail_Containers — Estimates the number of detail containers, taking a container instance, container item ID, delivery detail ID, and organization ID.

Tables Accessed

No specific tables are listed in the ETRM metadata for this package. Based on its documented role, it operates against the Shipping Execution container tables, such as the container instance and container item structures in the WSH schema, and delivery detail tables referenced by the estimate procedures. Access is through APPS synonyms, so the definitions resolve to the WSH-owned objects.

Usage Notes

This package is typically invoked from Shipping Execution forms and concurrent programs that manage container packing, and from custom extensions that need to compute container fill percentages or weights. Because the file is generated, customization should occur only through the TPA Generate Utility and the underlying TPA setup, never by editing the package. Callers must supply valid container instance IDs and handle the returned x_return_status values. The metadata records that this package is referenced by five other packages, confirming it is a supporting dependency rather than a standalone top-level API.