Search Results get_billed_amount

Overview

OKS_BILL_SCH is a PL/SQL package body owned by the APPS schema that governs the creation, maintenance, and termination of billing schedules in Oracle E-Business Suite service contracts. Within the Oracle Service Contracts (OKS) module, a billing schedule determines the dates, amounts, and stream-level line assignments used to invoice a subscription or service contract over its life. This package serves as the central engine for translating contract terms, billing profiles, and subscription elements into the bill lines, sub-lines, and level-element records that feed downstream receivables and order management processing.

The package is classified as OTHER in the ETRM registry and carries a VALID status. It is documented with 25 procedures and functions and is referenced by 18 other database objects, while itself depending on a broad set of public APIs and service contracts base tables. Because the object is not referenced by any other database object listed in the ETRM dependency data, it functions principally as a controller invoked by higher-level service modules, forms, and concurrent processes rather than as a low-level utility consumed internally by peers.

Key Procedures and Functions

The documented procedures fall into several functional clusters.

• Schedule creation: CREATE_BILL_SCH_RULES, CREATE_HEADER_BILL_SCH, CREATE_HDR_SCHEDULE, CREATE_SUBCRIPTION_BS, and CREATE_BILL_SCH_CP build billing schedule rules, header-level schedules, and subscription-driven schedules respectively.
• Amount calculation: UPDATE_SLL_AMOUNT, CAL_HDR_SLL_AMOUNT, and CAL_SLLID_AMOUNT compute or refresh stream-level line amounts for the header and for individual schedule line identifiers.
• Date management: CASCADE_DATES_SLL and CASCADE_DT_LINES_SLL propagate date changes across schedule lines and stream levels, while UPDATE_BS_ENDDATE, UPDATE_BS_INTERFACE_DATE, and UPDATE_OM_SLL_DATE adjust end dates and the interface dates communicated to order management.
• Copy and maintenance: COPY_BILL_SCH duplicates an existing schedule, and ADJUST_REPLACE_PRODUCT_BS handles product replacement and adjustment scenarios.
• Deletion and termination: DEL_RUL_ELEMENTS, DEL_SUBLINE_LVL_RULE, DELETE_CONTRACT_BS_SLL, and TERMINATE_BILL_SCH remove rule elements, sub-line level rules, contract schedule lines, and terminate an active schedule.
• Preview: PREVIEW_SUBSCRIPTION_BS generates a non-persistent preview of a subscription billing schedule for user review.

Tables Accessed

The package reads and writes service contracts core tables, including OKC_K_HEADERS_ALL_B, OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, and OKC_K_REL_OBJS, which hold contract headers, items, related objects, and line definitions. It operates on billing-specific structures such as OKS_BILL_CONT_LINES, OKS_BILL_SUB_LINES, OKS_BILLING_PROFILES_V, OKS_LEVEL_ELEMENTS, OKS_STREAM_LEVELS_B, OKS_SUBSCR_ELEMENTS, OKS_SUBSCR_HEADER_B, OKS_K_HEADERS_B, and OKS_K_LINES_B. Order line data is drawn from OE_ORDER_LINES_ALL, and DUAL is used for single-row PL/SQL evaluations.

Usage Notes

OKS_BILL_SCH is typically invoked from the Service Contracts authoring forms, the subscription and billing concurrent programs, and the Order Management interface when billing schedules must be generated, recalculated, or terminated. Because it depends on FND_API, FND_LOG, and FND_PROFILE, it follows standard EBS API error-handling, logging, and profile-option conventions. The supporting private packages OKS_BILL_UTIL_PUB, OKS_TIME_MEASURES_PUB, OKS_BILL_LEVEL_ELEMENTS_PVT, OKS_RENEW_UTIL_PUB, OKS_EXTWAR_UTIL_PVT, OKS_SUBSCRIPTION_PUB, OKS_SLL_PVT, OKC_API, and OKC_TIME_UTIL_PUB should be treated as internal dependencies; custom code should call the documented public procedures of OKS_BILL_SCH rather than these subordinate units directly.