Search Results create_bill_schedule

Overview

OKS_CONTRACTS_PUB is a public PL/SQL API package in the APPS schema that provides the programmatic entry point for creating and managing service contracts and subscriptions within Oracle Enterprise Asset Management and the Service Contracts (OKS) module. It is the publishable (PUB) interface exposed to integrators and internal callers, abstracting the underlying Contracts Core tables so that callers need not manipulate base tables directly. In Oracle EBS 12.1.1 and 12.2.2 the package is a VALID, compiled object and depends on OKC_API, OKC_PRICE_ATT_VALUES, OKS_BILL_SCH and the SYS STANDARD package. Its principal purpose is to instantiate contract headers, contract lines, service lines, bill schedules, and subscription state changes in a controlled, business-rule-compliant manner, ensuring that validations, defaults, and derived records are applied consistently.

Key Procedures and Functions

ETRM documents seven program units within the package, though the metadata below lists seven total with the following named entries:

• CREATE_CONTRACT_HEADER — Establishes the parent contract header record, assigning identifying and descriptive attributes and initializing the header-level context used by subsequent line and schedule calls.
• CREATE_CONTRACT — The composite creation routine that forms a complete contract from supplied header and line information, orchestrating the creation of the underlying structures in a single transactional call.
• CREATE_SERVICE_LINE — Creates an individual service line on an existing contract, linking the line to the appropriate line style and contract hierarchy.
• CREATE_BILL_SCHEDULE — Generates the billing schedule associated with a contract or subscription, determining billing periods and amounts through the billing engine.
• SUSPEND_SUBSCRIPTION — Places a subscription into a suspended state, interrupting service and billing activity while preserving the contract record for later resumption.
• REACTIVATE_SUBSCRIPTION — Restores a previously suspended subscription to active status, re-establishing service and billing.

Each routine follows standard EBS API conventions: validation of inputs, defaulting, and standardized return of success or error information to the caller.

Tables Accessed

Through APPS synonyms the package reads and writes the core Service Contracts and related reference tables:

• OKC_K_HEADERS_B and OKC_K_LINES_B — the contract header and line base tables that hold the master contract structures.
• OKS_K_LINES_B and OKS_SUBSCR_HEADER_B — service-specific line data and subscription header records.
• OKC_K_PARTY_ROLES_B, OKC_K_REL_OBJS, and OKC_LINE_STYLES_B — party role assignments, related-object links, and line style definitions that classify each line.
• OKC_PRICE_ATT_VALUES — pricing attribute values used when deriving contract pricing.
• CSI_COUNTERS_B, CSI_COUNTER_ASSOCIATIONS, and CS_CSI_COUNTER_GROUPS — counter and counter-group configuration applied to service contracts.
• HZ_CONTACT_POINTS and HZ_RELATIONSHIPS — Trading Community Architecture contact and relationship data for contract parties.
• DBMS_TRANSACTION and DUAL — used for transaction control and simple value retrieval.

Usage Notes

OKS_CONTRACTS_PUB is typically invoked through Service Contracts forms, concurrent programs such as contract and subscription generation, and custom PL/SQL integration code. It is referenced by OKL_UBB_INTEGRATION_PVT (the lease-to-service usage-based billing integration) and is self-referenced within OKS_CONTRACTS_PUB. Because it is classified as a PUB package, Oracle supports its direct invocation from customer extensions, provided callers supply required parameters and observe standard COMMIT/ROLLBACK discipline. Invoking the API rather than inserting into base tables is mandatory to preserve the integrity of contract hierarchies, pricing, and billing schedules across releases, and to benefit from built-in validation and defaulting logic.