Search Results po_asl_documents_ths1

Overview

PO_ASL_DOCUMENTS_THS1 is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as an "OTHER" API type. In Oracle EBS 12.1.1 and 12.2.2, the "THS" suffix conventionally identifies a Table Handler (or trigger-handler style) package, indicating that this object encapsulates the low-level data-manipulation logic associated with the PO_ASL_DOCUMENTS entity. Its business function is therefore to support the Approved Supplier List (ASL) document-attachment model, in which supplier, supplier-site, and item-level ASL entries may be linked to supporting documentation (for example, supplier qualification documents or licensing attestations). Rather than exposing a public business API, the package provides the internal plumbing that keeps ASL document records consistent when their parent ASL entries are inserted, updated, or deleted, or when documents are added or removed.

Key Procedures and Functions

The ETRM metadata documents a single callable unit within the package: the procedure or function named NAMES. Its recorded purpose is consistent with the table-handler pattern described above — namely, to materialise and manage the association between ASL document definitions and their identifiers, ensuring that document-name or document-record references remain synchronised with the underlying PO_ASL_DOCUMENTS rows. No parameter lists are documented in the metadata, and none are asserted here; the object's signature must be inspected directly in the database (for example, via ALL_ARGUMENTS) before any invocation from custom code. No other procedures or functions are recorded, and no overloaded variants are documented.

Tables Accessed

Through APPS synonyms, PO_ASL_DOCUMENTS_THS1 references one documented table: PO_ASL_DOCUMENTS. This is the base table that stores the document metadata attached to an Approved Supplier List entry, and the package accesses it to read, insert, update, or delete rows as part of its handler logic. Because the dependency listing also shows a reference to SYS.STANDARD, the package uses only standard PL/SQL constructs alongside its table access. No other application tables are documented as being touched.

Usage Notes

PO_ASL_DOCUMENTS_THS1 is not a customer-facing business API and is not intended for direct invocation from concurrent programs or custom extensions. In a standard EBS 12.1.1 or 12.2.2 instance it is most commonly reached indirectly: from Approved Supplier List maintenance forms (the Purchasing supplier/item ASL windows) that manipulate ASL documents, or from trigger and table-handler logic fired when the corresponding base table rows change. The metadata records no other packages as referencing it, which is consistent with it being a leaf-level, internal handler. Custom developers who need to maintain ASL document data should prefer the documented Purchasing ASL APIs; where PO_ASL_DOCUMENTS_THS1 must be used, the procedure signature and any state assumptions should first be verified against the deployed source in APPS, since the ETRM entry documents only the object's existence and its NAMES unit rather than its full interface contract.