Search Results g_level_current

Overview

OKS_SUBSCRIPTION_PVT is a private PL/SQL package owned by APPS that encapsulates the internal business logic governing Oracle Service Contracts subscription processing. It supports the creation, regeneration, and lifecycle management of subscription schedules and instances, handling operations that are invoked by higher-level public APIs rather than by external callers directly. Typical use cases include generating a default billing or service schedule for a contract line, re-deriving schedule quantity attributes, recreating subscription instances, and copying subscriptions across accounts.

The package header declares internal logging constants, including G_LEVEL_UNEXPECTED, G_LEVEL_ERROR, G_LEVEL_EXCEPTION, G_LEVEL_EVENT, G_LEVEL_PROCEDURE, G_LEVEL_STATEMENT, and G_LEVEL_CURRENT. G_LEVEL_CURRENT maps to FND_LOG.G_CURRENT_RUNTIME_LEVEL, the runtime logging threshold used by Oracle EBS diagnostics. G_MODULE_CURRENT carries the module identifier 'oks.plsql.oks_subscription_pvt', and shared error constants are inherited from OKC_API. Internal data structures rangerec and rangetab support range-based numeric processing. The user search term "g_level_current" corresponds to this standard message-logging constant convention.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. No parameter lists are reproduced here; purposes follow the documented API surface.

• CREATE_DEFAULT_SCHEDULE — Generates the default schedule for a subscription identified by contract line element.
• RECREATE_SCHEDULE — Rebuilds an existing schedule and returns the recalculated quantity.
• RECREATE_INSTANCE — Regenerates a subscription instance for a given contract line element and customer account.
• COPY_SUBSCRIPTION — Duplicates a subscription definition for reuse.
• UNDO_SUBSCRIPTION — Reverses subscription creation or regeneration effects.
• VALIDATE_PATTERN — Checks a subscription pattern for validity.
• GET_SUBS_QTY — Derives subscription quantity for a subscription.
• STRETCH_EFFECTIVITY — Extends or adjusts effective dates across periods.
• SUBS_TERMN_AMOUNT — Computes the termination amount for a subscription.
• IS_SUBS_TANGIBLE — Determines whether a subscription is tangible.
• MAP_FREQ_UOM — Maps a frequency to its associated unit of measure.
• DB_COMMIT — Performs an explicit database commit within transactional flow.
• GET_SUBSCRIPTION_QTY_OM — Returns subscription quantity in the appropriate unit of measure.

Tables Accessed

All table access is performed through APPS synonyms. Core subscription tables are OKS_SUBSCR_HEADERS_B, OKS_SUBSCR_ELEMENTS, and OKS_SUBSCR_PATTERNS, which hold subscription headers, element definitions, and pattern rules. OKS_K_HEADERS_B and OKC_K_ITEMS, OKC_K_LINES_B link subscriptions to the contract headers, items, and lines defined in Oracle Contracts. MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_TL resolve item and item description data used when deriving quantities and tangibility. PLITBLM is the PL/SQL table used for bulk processing.

Usage Notes

Because this package is classified as a private API, it is invoked by Oracle Service Contracts public APIs, service contract forms, and internal concurrent processes rather than being called directly by customers. The DB_COMMIT procedure indicates that certain operations, such as schedule creation and recreation, manage transaction boundaries internally. Custom extensions should generally call the supported public APIs of Oracle Service Contracts that indirectly reach OKS_SUBSCRIPTION_PVT, ensuring logging via FND_LOG and consistent error handling through OKC_API constants. The package is referenced by three other packages, confirming its position as a shared internal utility.