Results for “ast_api_records_pkg”

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

Overview

AST_API_RECORDS_PKG is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, shipped under the Asset Tracking (AST) product family and documented in the ETRM repository for releases 12.1.1 and 12.2.2. Despite its AST-prefixed name, the package does not implement asset lifecycle transaction logic. Its documented purpose is to centralize the construction of record-type and table-type data structures required by the Oracle JTF (Java Technology Foundation) personalization and profile APIs. The package exposes a family of initializer functions that return fully formed PL/SQL record and collection types so that callers need not bind each attribute individually. The header comment block identifies the current version as 1.0, with the source header string indicating a last revision at 120.4 dated 2005/11/07. The API classification recorded in ETRM is "OTHER," and the package is not referenced by any other documented package.

Key Procedures and Functions

Twelve procedures and functions are documented. The initializer group supplies new record instances:

• INIT_JTF_PERZ_QUERY_RAW_REC — Returns a new raw SQL query record conforming to JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE.
• INIT_JTF_PERZ_QUERY_PARAM_REC — Returns a new query parameter record conforming to JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE.
• INIT_JTF_PERZ_QUERY_ORDER_REC — Returns a new order-by record conforming to JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE.
• INIT_JTF_PERZ_PROF_ATTR_REC — Returns a new personal profile attribute record conforming to JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_REC_TYPE.
• INIT_JTF_NOTES_PUB_CONTEXT_TBL — Initializes the context table type used by the JTF Notes public API.
• INIT_RECORD — A general-purpose initializer that returns a new record instance.
• INIT_AS_INTEREST_REC — Builds an interest record for the asset tracking interest entity.
• GET_PV_ENTITY_REC_TYPE — Returns the record type describing a page-view entity used for personalization lookups.
• GET_OE_ORDER_HEADER_REC — Returns an Order Entry order header record type.

The remaining documented entries complete the twelve-count set and follow the same initialization pattern. Each function carries no pre-requisites and no input parameters; callers invoke them directly and assign the return value to a local variable before populating individual fields.

Tables Accessed

The ETRM metadata documents no direct table access for this package. No APPS synonyms are listed among the referenced objects, and the package is not recorded as referencing any base table. Its work is entirely in-memory: it declares and returns PL/SQL record and table types defined in the JTF and Order Entry specification packages. Any persistent data movement occurs in the calling modules, which use the returned structures as arguments to JTF_PERZ_QUERY_PUB, JTF_PERZ_PROFILE_PUB, JTF_NOTES_PUB, or Order Entry APIs.

Usage Notes

AST_API_RECORDS_PKG is a server-side utility invoked from PL/SQL. Typically a form, concurrent program, or custom extension calls the appropriate INIT function to obtain an empty record, populates the fields, and then passes the record to the JTF personalization or profile API, or to an Order Entry call. The returned types are not instantiated automatically, so the initializer acts as a factory that guarantees the caller receives a valid, non-null record instance. Because the package is not referenced by other packages, it is best treated as a leaf utility. With no table dependencies, it carries no transactional or locking implications, and changes to it affect only callers that instantiate these record types. The version 1.0 declaration indicates a stable interface retained across the 12.1.1 and 12.2.2 releases.