Search Results update_sd_req_prices

Overview

OZF_SD_UTIL_PVT is a private (PVT) PL/SQL utility package in the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / ETRM) schema, owned by APPS. Its header indicates authorship by MBHATT and a creation date of November 2007, with the source file ozfvsdus.pls at version 120.7 (last modified April 2008). The package provides the shared low-level services required by the Ship and Debit (S&D) subsystem: currency conversion between a request currency and a plan currency, bidirectional conversion between database DATE values and the Run/Report "RN" date string format, time zone and date-time formatting, amount postback to the funds utilized table, interface table maintenance for S&D request prices, event raising, and batch/claim completion processing. Because it is classified as PVT, it is an internal implementation package; external callers should generally reach its functionality through the corresponding public S&D APIs, although a number of S&D internals and concurrent programs invoke it directly.

Key Procedures and Functions

The following procedures and functions are documented in the package metadata (16 total).

• SD_CONVERT_CURRENCY — converts an amount from the request currency into the plan currency for a given batch line.
• GET_CONVERTED_CURRENCY — returns the converted currency amount for S&D processing.
• SD_AMOUNT_POSTBACK — updates OZF_FUNDS_UTILIZED_ALL_B to post back the utilized amount for a batch line, returning a status and meaning through its OUT parameters.
• CONVERT_TO_RN_DATE — converts a server-side DATE into the RN date string representation. This is the object the user searched for and is the core of the package's date-format conversion responsibility.
• CONVERT_TO_DB_DATE — the inverse of the above: parses an RN date string back into a database DATE.
• CONVERT_TO_RN_TIMEZONE — expresses a date/time value in the RN time zone convention.
• CONVERT_TO_RN_DATETIME — converts a database date/time to the combined RN date-time string format.
• UPDATE_SD_REQ_PRICES — updates the Ship and Debit price interface table with the correct request line ID.
• UPDATE_SD_REQ_STALE_DATA — cleans up or refreshes stale S&D request data in the interface tables.
• PROCESS_SD_RESPONSE — processes the response returned from an external or downstream S&D call.
• SD_RAISE_EVENT — raises an Oracle Workflow / business event for the S&D flow.
• PROCESS_BATCH_ADJUST_CLAIM — handles adjustment claims against an S&D batch.
• CREATE_ADJUSTMENT — creates an adjustment record in the S&D process.
• PROCESS_SD_PEN_CLOSE_BATCHES — processes pending close operations for S&D batches.
• SET_COMPLETE_FLAGS — sets completion flags on the relevant S&D entities.
• CHECK_COMPLETE_FLAGS — evaluates whether processing is complete by checking those flags.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• OZF_SD_BATCH_HEADERS_ALL, OZF_SD_BATCH_LINES_ALL, OZF_SD_BATCH_LINE_DISPUTES — the S&D batch, batch line, and dispute entities that drive posting and completion logic.
• OZF_SD_REQUEST_HEADERS_ALL_B, OZF_SD_REQUEST_LINES_ALL — S&D request header and line data.
• OZF_FUNDS_UTILIZED_ALL_B — target of the amount postback routine.
• OZF_SD_RES_HEADER_INTF, OZF_SD_RES_PROD_INTF, OZF_SD_RES_CUST_INTF, OZF_SD_RES_DIST_PRICES_INTF — the S&D resolution interface tables populated and maintained during response processing and price updates.
• FND_CURRENCIES — currency definitions used by the conversion routines.
• FND_CONCURRENT_REQUESTS, FND_CONCURRENT_PROGRAMS — concurrent request context and parameter information.
• FND_NEW_MESSAGES — message text retrieval for returned status/meaning values.
• AMS_USER_STATUSES_B — user status reference data used in S&D workflow transitions.

Usage Notes

OZF_SD_UTIL_PVT is invoked indirectly rather than as an end-user entry point. Its most visible use is the date/time conversion family: CONVERT_TO_RN_DATE and CONVERT_TO_DB_DATE are called wherever S&D request data must be exchanged with external systems or stored in the RN string convention, making them relevant to interface and integration troubleshooting. SD_CONVERT_CURRENCY and SD_AMOUNT_POSTBACK are called during batch resolution and funds utilization, while UPDATE_SD_REQ_PRICES and UPDATE_SD_REQ_STALE_DATA support the interface-table refresh paths used by concurrent programs. PROCESS_SD_PEN_CLOSE_BATCHES, CREATE_ADJUSTMENT, and PROCESS_BATCH_ADJUST_CLAIM are reached through the batch processing and claim adjustment flows, and SET_COMPLETE_FLAGS / CHECK_COMPLETE_FLAGS gate batch completion. The package is referenced by two other packages, confirming it is a shared dependency within the S&D module. Because the metadata is limited to signatures and table references, the exact functional conditions under which each routine executes should be confirmed against the source in ozfvsdus.pls for the specific release (12.1.1 or 12.2.2). As a PVT package, it is not part of the supported public API surface, and custom code should call the corresponding public S&D APIs instead of these private procedures to remain upgrade-safe.