Search Results g_miss_date

Overview

OKS_HZ_CUSTOMER_ACCOUNTS_PVT is a private (PVT) PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Service Contracts (OKS) module and functions as an internal helper layer that integrates Service Contracts account processing with the Oracle Receivables customer model implemented through the HZ_CUST_ACCOUNT_V2PUB public API. The package encapsulates the construction and submission of customer account records to the Trading Community Architecture (TCA) customer account API.

Its primary business purpose is to allow Service Contracts flows — such as the creation of customer accounts for contract parties — to build a fully populated hz_cust_account_v2pub.cust_account_rec_type record, initialize it with standard placeholder values, and pass it to the TCA API for validation and persistence. Because the package is classified as PVT, it is not intended for direct invocation by external consumers; it supports the public Service Contracts APIs that need to synchronize contract-related customer information into Receivables.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package body:

• INIT — Initializes the customer account record and the customer profile record that are passed to the TCA customer account API. It accepts two OUT NOCOPY parameters: one of type hz_cust_account_v2pub.cust_account_rec_type and one of type hz_customer_profile_v2pub.customer_profile_rec_type. The procedure assigns default "missing" sentinel values to every field of the account record, including the customer account identifier, account number, descriptive flexfield columns (attribute_category, attribute1 through attribute20), and the global descriptive flexfield columns (global_attribute_category, global_attribute1 through global_attribute7). This ensures that only fields explicitly set by the caller are interpreted as meaningful by the TCA API.
• UPDATE_ROW — Performs the update operation against the customer account data, committing the assembled record through the TCA customer account API pathways. It represents the write-side entry point for modifications to customer account information originating from Service Contracts.

Tables Accessed

The package references the APPS synonym HZ_CUST_ACCOUNTS, the base table in the Trading Community Architecture that stores customer account header information — account numbers, status, profile class, and links to parties and account sites. This table is read and written indirectly through the HZ_CUST_ACCOUNT_V2PUB public API rather than through direct DML, which preserves TCA integrity rules, validation logic, and audit columns. The G_MISS_NUM, G_MISS_CHAR, and G_MISS_DATE constants — where G_MISS_CHAR is defined as VARCHAR2(1) := chr(0) — mirror the standard Oracle EBS "missing value" convention used throughout TCA public APIs to distinguish unset fields from deliberately null ones.

Usage Notes

Because this is a PVT package, it is never called from Oracle Forms user exits, concurrent program definitions, or customer-facing extension code directly. It is invoked internally by Service Contracts public API packages when a contract operation requires a customer account to be created or updated in Receivables, typically during contract authoring or party synchronization in the Service Contracts module. The ETRM metadata records no other packages referencing it, confirming its role as a leaf-level implementation detail.

Developers extending Service Contracts should call the supported public APIs rather than OKS_HZ_CUSTOMER_ACCOUNTS_PVT. The INIT procedure's exhaustive assignment of G_MISS_CHAR to every flexfield column illustrates the standard defensive pattern required before passing a record to a TCA V2PUB API; any custom code building similar records should observe the same convention. The package is version-stamped 120.2 with an "noship" designation, indicating it is shipped as part of the Service Contracts product but not intended for standalone use.