Search Results add_concurrent_sub

Overview

OKS_ATTR_DEFAULTS_PVT is an Oracle E-Business Suite private PL/SQL package owned by the APPS schema that supports the Service Contracts (OKS) and Contracts Core (OKC) subsystems. Its classification as a "PVT" (private) API indicates that it is an internal implementation package rather than a published, externally supported interface. The package encapsulates logic used to default attribute values from contract headers down to lines and sublines, to manage credit card information associated with service contracts, and to orchestrate cascading, concurrent processing requests. Because it is private, Oracle does not guarantee the API signatures across releases; it is intended for consumption by sibling OKS packages and Oracle-authored concurrent programs rather than by customer extensions.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within the package. Their names and inferred purposes follow.

• DEFAULT_HEADER_TO_LINES — Propagates attribute or setup values established at the contract header level downward to the associated contract lines, ensuring consistent defaults.
• DEFAULT_LINES_TO_SUBLINES — Extends the same defaulting behavior from contract lines to their sublines.
• UPDATE_LINE — Performs the write-back of updated line information after defaults or user edits are applied.
• CREATE_CREDIT_CARD — Creates a credit card record, typically deriving values from customer account or billing profile data used by the contract.
• DELETE_CREDIT_CARD — Removes a stored credit card record associated with a contract.
• ADD_CONCURRENT — Registers a concurrent processing request used by the cascade mechanism.
• ADD_CONCURRENT_SUB — Registers a subordinate or child concurrent request tied to a parent request.
• CONCURRENT_TEMP_PURGE — Cleans up temporary cascade request records after processing completes.
• CASCADE_CONCURRENT — Drives the cascading update process across contract structures using concurrent requests.
• ROLLBACK_WORK — Reverts uncommitted work when an operation fails, maintaining transactional integrity.

Tables Accessed

The package reads and writes several core Service Contracts and shared reference tables through APPS synonyms.

• OKC_K_HEADERS_ALL_B, OKC_K_HEADERS_B, OKC_K_LINES_B, OKS_K_LINES_B — Contract header and line tables, the primary targets for header-to-line and line-to-subline defaulting.
• OKS_BILL_CONT_LINES, OKS_BILL_SUB_LINES, OKS_BILLING_PROFILES_B — Billing line, subline, and billing profile data used when defaulting billing attributes and credit card information.
• OKS_CASCADE_CONC_REQ, OKS_CASCADE_CONC_REQ_SUB — Working tables that track parent and child concurrent requests generated by the cascade process.
• OKC_CONTACTS, OKC_K_PARTY_ROLES_B, HZ_CUST_ACCOUNTS — Contact, party role, and customer account data used to resolve default values and credit card associations.
• CS_INCIDENTS_ALL_B — Incident data referenced during defaulting logic.
• ZX_EXEMPTIONS — Tax exemption information used when applying billing defaults.
• PLITBLM — A standard Oracle Applications PL/SQL table used internally for bulk processing.

External API dependencies include FND_API, FND_GLOBAL, OKC_API, and OKC_CONTRACT_PUB, which supply the standard API framework, environment context, and contract publication services.

Usage Notes

OKS_ATTR_DEFAULTS_PVT is invoked indirectly through Service Contracts forms and concurrent programs rather than by direct customer call. Header and line defaulting procedures fire during contract entry, copy, and amendment, allowing attributes configured at higher levels to flow to subordinate records. The credit card procedures support payment instrument capture during contract authoring. The ADD_CONCURRENT, CONCURRENT_TEMP_PURGE, and CASCADE_CONCURRENT routines support large-scale cascading updates executed as concurrent requests, which is why temporary request-tracking tables are required. Because the package is classified as private and is referenced by only one other package, custom development should avoid direct dependency on it; Oracle may change its internal signatures without notice across 12.1.1 and 12.2.2.