Search Results get_allocation_date

Overview

APPS.JMF_SHIKYU_UTIL is a utility PL/SQL package that serves the Charge Based SHIKYU (subcontracting charge) functionality within Oracle E-Business Suite manufacturing and subcontracting flows. It supports the SHIKYU project, which governs the calculation, allocation, pricing, and replenishment accounting associated with subcontracting charges and supplier-managed inventory scenarios. The package is declared AUTHID CURRENT_USER and owns the source file JMFUSHKS.pls, with an initial revision created on 29-APR-2005 by vchu and subsequent revisions through 20-SEP-2006. In Oracle EBS 12.1.1 and 12.2.2 the package is classified as a UTIL object under the APPS schema and exposes 26 documented procedures and functions. It is referenced by eight other packages, which confirms its role as a shared library of conversion, quantity, price, and attribute helpers consumed across the JMF subcontracting module.

Key Procedures and Functions

• TO_XSD_DATE_STRING — Converts Oracle DATE values into XSD-compliant date/time strings for correct formatting in XML Publisher reports. Added 08-SEP-2006 and revised twice; the second optional parameter specifies the timezone offset (Server or Client) and a subsequent revision denotes whether the time component is omitted. User timezone (UPTZ) support was dropped for R12.
• CLEAN_INVALID_DATA — Added 30-AUG-2006 to remove or repair invalid SHIKYU data.
• GET_PRIMARY_UOM / GET_PRIMARY_UOM_CODE / GET_UOM_CODE — Return primary and transactional unit of measure identifiers.
• GET_UOM_CONVERSION_RATE — Retrieves the conversion factor between units of measure.
• GET_REPLENISH_SO_RETURNED_QTY / GET_REPLENISH_SO_RECEIVED_QTY — Derive replenishment sales order quantities for returned and received stock.
• GET_USED_QUANTITY / GET_PRIMARY_QUANTITY — Compute consumed and primary quantities for SHIKYU components.
• GET_FINAL_SHIP_DATE / GET_ALLOCATION_DATE — Determine shipping and allocation dates used in charge calculation.
• GET_SUBCONTRACT_ORDER_ORG_IDS — Resolve organization identifiers for subcontract orders.
• GET_SHIKYU_ATTRIBUTES / GET_SHIKYU_COMPONENT_PRICE — Return SHIKYU attribute sets and component pricing (signature modified 28-SEP-2005).
• GET_REPLEN_PO_ALLOCATED_QTY / GET_REPLEN_PO_ORDERED_QTY / GET_REPLEN_SO_ALLOCATED_QTY / GET_SUBCONTRACT_ALLOCATED_QTY / GET_REPLENISHMENT_SO_PRICE — Supply allocated, ordered, and priced replenishment quantities across PO, SO, and subcontract streams.
• debug_output — Added 03-OCT-2005 for diagnostic logging.
• GET_SHIKYU_OFFSET_ACCOUNT — Added 21-OCT-2005 to return offset accounting flexfield information.

Tables Accessed

The package reads and writes SHIKYU transactional data through APPS synonyms, principally JMF_SHIKYU_ALLOCATIONS, JMF_SHIKYU_COMPONENTS, and JMF_SHIKYU_REPLENISHMENTS. Subcontracting context is drawn from JMF_SUBCONTRACT_ORDERS. Item and UOM master data come from MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, and MTL_UNITS_OF_MEASURE, with interorg setup from MTL_INTERORG_PARAMETERS and MTL_INTERORG_SHIP_METHODS. Order and receipt activity is sourced from OE_ORDER_LINES_ALL, PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and RCV_TRANSACTIONS. FND_CONCURRENT_REQUESTS is referenced for concurrent request context and logging.

Usage Notes

JMF_SHIKYU_UTIL is typically invoked from concurrent programs, XML Publisher report templates, and custom PL/SQL that supports subcontracting charge processing. Because it is AUTHID CURRENT_USER, callers must hold privileges on the underlying JMF and MTL objects. The TO_XSD_DATE_STRING function is most commonly called from XML Publisher data definitions and report queries to render dates in XSD format; developers searching for this routine should reference it directly from the APPS schema rather than reimplementing date formatting. The package is referenced by eight dependent packages, so changes to its public signatures can propagate widely across the JMF subcontracting module.