Search Results get_system




Overview
Explore in AI Chat

Overview

OKS_ENT_UTIL_PVT is a private (PVT) PL/SQL utility package in the APPS schema that supports the Oracle E-Business Suite Service Contracts (OKS) module, specifically the entitlement and contract-authoring functionality. It is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking session rather than the definer, which is common for internal helper packages that expose data already governed by the caller's access. The package provides getter-style functions that retrieve discrete attributes of a service contract header or line — duration, monetary amount, party, bill-to/ship-to, price list, discount, accounting and invoicing rules, billing profile and schedule, renter notes, terms, product, system, and inventory item details. It also defines several PL/SQL record types used as return structures. The user query "get_billrate" does not correspond to a documented member of this package; the closest documented analogues are functions returning pricing and rate-related contract attributes such as GET_PRICELIST, GET_DISCOUNT, and GET_QTYRATE_RULE. Rate information in ETRM is generally derived through those functions or through calling applications rather than a function literally named get_billrate.

Key Procedures and Functions

The package exposes 27 documented procedures and functions, grouped by purpose:

  • Date and amount utilities: GET_DURATION_PERIOD returns a formatted duration between two dates; GET_CONTRACT_AMOUNT returns the total contract value for a given header.
  • Party and address utilities: GET_PARTY returns the contracting party; GET_BILLTOSHIPTO returns bill-to or ship-to information; GET_CLVL_PARTY resolves party data in the contract-level hierarchy.
  • Pricing and rate-related utilities: GET_PRICELIST returns the applicable price list; GET_DISCOUNT returns discount information; GET_QTYRATE_RULE returns the quantity/rate rule for a line.
  • Accounting and invoicing utilities: GET_ACC_RULE, GET_INV_RULE, GET_BILLINGPROFILE, and GET_BILLINGSCHEDULE return accounting rules, invoicing rules, billing profile, and billing schedule respectively.
  • Contract descriptive utilities: GET_RENTERNOTES returns CLOB notes; GET_TERMS returns contract terms; GET_AGREEMENT returns the governing agreement.
  • Item and system utilities: GET_PRODUCT (overloaded) returns product identity and quantity via the l_pdt_rec record; GET_SYSTEM (overloaded) returns system identity via the l_sys_rec record; GET_INVITEM returns inventory item identity via the l_inv_rec record; GET_CONVRULE and GET_TAXRULE return conversion and tax rules.

Each function is documented with header or line identifiers and, where relevant, an input-type discriminator controlling the return format.

Tables Accessed

The package reads through APPS synonyms across the Service Contracts and Contracts Core schema:

Usage Notes

As a PVT-classified package, OKS_ENT_UTIL_PVT is not intended as a public API. It is typically invoked by other Service Contracts packages — metadata indicates it is referenced by five other packages — and by the OKS contract-authoring and entitlement forms when rendering or validating contract attributes. It may also be called from concurrent programs that generate contract documentation or extracts, and from custom code that needs to retrieve a single contract attribute without querying the underlying OKS/OKC tables directly. Because the package relies on APPS synonyms and runs with AUTHID CURRENT_USER, callers must ensure the correct operating unit context (org_id) is initialized, particularly for functions such as GET_SYSTEM that accept an organization identifier. Customers performing an ETRM-to-EBS 12.1.1 or 12.2.2 upgrade should treat this package as internal and verify availability against their specific patch level rather than depending on it as a stable integration surface.