Results for “process_ponumber”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ITG_SYNCFIELDINBOUND_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name and procedure signature indicate that it supports the inbound synchronization of field data into Oracle Purchasing requisition records — specifically the linkage between purchase order numbers and the requisition lines that generated or reference them. The "PVT" classification in the ETRM metadata confirms that this is an internal helper package rather than a public, customer-callable API. It is intended to be invoked only by other packages within the same product family, not directly by external customizations.

The package file header (itgvsfis.pls) dates the original source to 2002, with a later revision in 2005, indicating it belongs to an older Oracle field-service or supplier-connectivity module whose objects were never re-versioned into a public API. The package therefore represents legacy integration plumbing retained for compatibility in 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents exactly one procedure:

• PROCESS_PONUMBER — The single documented entry point in the package. Its purpose is to process a purchase order number in the context of an inbound field synchronization operation. Based on its parameter names, it operates against a specific requisition (identified by request ID and requisition line number) and a purchase order (identified by PO ID), scoped to a particular operating unit or organization. It returns the standard concurrent-processing out parameters (return status, message count, and message data), allowing the calling program to determine success or failure and retrieve diagnostic text.

No other procedures or functions are documented in the ETRM extract. No public wrapper is listed, reinforcing the package's private, internal role.

Tables Accessed

The package reads and writes two Purchasing tables through APPS synonyms:

• PO_REQUISITION_HEADERS_ALL — The requisition header is the parent document for the inbound synchronization. The procedure likely validates or locates the requisition and may update header-level attributes when associating a purchase order number.
• PO_REQUISITION_LINES_ALL — The requisition line is the level at which the PO number and source document reference are typically stored (for example, the source document number and line reference columns). PROCESS_PONUMBER almost certainly updates or reads this table to bind the incoming PO number to the correct requisition line.

Because the procedure receives both a PO ID and a requisition line number, the access pattern is a targeted single-record lookup and update rather than a bulk set-based operation.

Usage Notes

As a PVT-classified package, it should not be called directly from customer forms, concurrent programs, or custom code. The metadata records that it is referenced by one other package, which is the intended caller; that parent package is presumably an inbound processing API that iterates across synchronized records and delegates PO number handling to this routine.

The presence of concurrent-style OUT parameters (return status, message count, message data) suggests the caller is a concurrent program or an interface program that logs errors through the standard EBS message stack. In practice, PROCESS_PONUMBER is invoked during inbound data loads or corrections in which a purchase order number must be re-established on an existing requisition line — for example, after a supplier or field-system feed supplies a PO reference that was not captured at requisition creation time.

Customizations in 12.1.1 or 12.2.2 that require this behavior should replicate the logic in their own code rather than calling ITG_SYNCFIELDINBOUND_PVT, because the package carries no public API guarantee and its signature may change without notice in patching. Any diagnostics should be routed through FND_MSG_PUB consistent with the OUT parameters the procedure already exposes.