Search Results getselections_prod

Overview

OKS_AUTH_UTIL_PUB is a public API package in the Oracle E-Business Suite (EBS) Service Contracts (OKS) and Telecommunications/Service (OKC) module family. It is classified as a PUB package, meaning its procedures are intended for external invocation by other Oracle EBS products, forms, concurrent programs, and customizations. The package body wraps the corresponding private implementation, OKS_AUTH_UTIL_PVT, and enforces the standard Oracle EBS API execution model: activity start-up, message list initialization, error trapping, and the return-status protocol defined in OKC_API.

The package addresses service authorization and provisioning utilities, including the assembly of product and service selections for contract and subscription processing. This includes counter management, party and contact creation, party site maintenance, and customer account role management, supporting the authorization workflows that underpin service delivery in the telecommunications data model.

Key Procedures and Functions

The documented interface exposes 24 procedures and functions. GETSELECTIONS_PROD and GETSELECTIONS_OTHER retrieve product and non-product selections respectively, applying a level filter record to scope results. This is the procedure targeted by the user's search term getselections_prod.

• GETSELECTIONS_PROD — Returns product selections based on a filter record, delegating to OKS_AUTH_UTIL_PVT.GetSelections_prod.
• GETSELECTIONS_OTHER — Returns non-product (other) selections under the supplied filter criteria.
• COPYSERVICE and COPY_PARAMETER — Copy service definitions and associated parameters during authorization or configuration duplication.
• CHK_COUNTER and CHK_EVENT — Validate counter and event conditions prior to authorization or charging.
• CONTACT_POINT — Manages contact point data associated with a service or party.
• CREATE_CII_FOR_SUBSCRIPTION and DELETE_CII_FOR_SUBSCRIPTION — Create and remove customer interaction/installation records tied to a subscription.
• DEF_STS_CODE and GET_STE_CODE — Derive default and effective status codes for authorization processing.
• CREATE_PERSON, UPDATE_PERSON — Insert and modify person records in the TCA model.
• CREATE_ORG_CONTACT, UPDATE_ORG_CONTACT — Maintain organization contact records.
• CREATE_PARTY_SITE, UPDATE_PARTY_SITE — Manage party site addresses.
• CREATE_CUST_ACCOUNT_ROLE, UPDATE_CUST_ACCOUNT_ROLE — Assign and update customer account roles.
• CREATE_CUST_ACCT_SITE — Create the customer account site linkage.

Tables Accessed

The package operates across contract, subscription, counter, and TCA tables through APPS synonyms:

• OKC_K_HEADERS_B and OKC_K_LINES_B — Contract header and line entities; the base structures for service authorization.
• OKC_CONDITION_HEADERS_B and OKC_PRICE_ADJUSTMENTS — Conditions and pricing adjustments applied during authorization.
• CSI_COUNTERS_B, CSI_COUNTER_ASSOCIATIONS, CSI_COUNTER_TEMPLATE_B, and CS_CSI_COUNTER_GROUPS — Counter definitions, associations, templates, and groupings used by CHK_COUNTER.
• MTL_SYSTEM_ITEMS_KFV — Item master view for product identification.
• OKS_SUBSCR_HEADER_B — Subscription header used in the subscription record procedures.
• QP_LIST_HEADERS_B and PLITBLM — Advanced pricing list headers and the price list item interface table.

Usage Notes

This package is typically invoked from Service Contracts and Telecommunications forms, concurrent programs performing authorization validation or provisioning batch runs, and custom PL/SQL extensions. Callers must supply a valid API version and honor the standard return-status convention via x_return_status, x_msg_count, and x_msg_data. Because it is a PUB wrapper, messages and exceptions are managed centrally through OKC_API.START_ACTIVITY, END_ACTIVITY, and HANDLE_EXCEPTIONS. Two other packages reference this API. Custom code should rely on the public interface rather than invoking OKS_AUTH_UTIL_PVT directly.