Search Results get_effective_end_date
Overview
OKS_ENTITLEMENTS_PVT is a private PL/SQL package in the APPS schema that implements the internal business logic layer for Oracle Service Contracts (OKS) entitlement processing within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Entitlements define the service coverage, reaction times, business processes, and coverage windows that a customer is entitled to under a service contract. The PKG classification (PVT) indicates that this package is not a public API; it exposes its logic to the corresponding public package, OKS_ENTITLEMENTS_PUB, and to other internal OKS packages, and its signatures are not guaranteed for external customizations. Its central responsibility is to validate entitlement lines against contract structure and business rules, compute effective dates and reaction/coverage timings, and reconcile timezone and resource attributes before entitlement data is persisted. In the dependency chain it is referenced by OKS_ENTITLEMENTS_PUB, OKS_COV_ENT_PVT, OKS_PM_ENTITLEMENTS_PVT, and CS_CHARGE_DETAILS_PVT, and it references FND_API, OKC_API, and the OKC contract tables. It therefore acts as a validation and computation utility class within the Service Contracts engine.
Key Procedures and Functions
The documented interface contains 99 procedures and functions. They fall into distinct functional groups.
- Required-value validators: VALIDATE_REQUIRED_NUMVALUE, VALIDATE_REQUIRED_DATEVALUE, VALIDATE_REQUIRED_CHARVALUE, and VALIDATE_REQUIRED_RT_TOKENS enforce mandatory fields and reaction-time token formats on entitlement input records, typically via FND_API error handlers.
- Line and contract validators: VALIDATE_SERVICE_LINE, VALIDATE_COVERAGE_LINE, VALIDATE_BUSINESSPROCESS_LINE, and VALIDATE_CONTRACT_BP verify that each entitlement line type maps correctly to the parent contract, business process, and coverage definition.
- Effectivity logic: VALIDATE_EFFECTIVITY, GET_EFFECTIVE_END_DATE, and GET_CONT_EFFECTIVE_DATES derive the effective start and end dates of entitlement lines from contract header and line dates.
- Business process and reaction-time computation: GET_BP_LINE_START_OFFSET, GET_BP_COVER_TIMES, GET_BP_REACTION_TIMES, GET_BP_REACTRESOLTIME_LINE, GET_REACTN_DURN_IN_DAYS, and COMPUTE_REACT_BY_DATETIME and COMPUTE_DAY_REACT_BY_DATETIME calculate reaction and resolution durations, including day-based reaction attributes via GET_COVER_DAY_ATTRIBS.
- Timezone handling: CONVERT_TIMEZONE normalizes timestamps between contract and resource timezones.
All members operate on entitlement records in memory and return status or computed values to the caller.
Tables Accessed
The package reads and writes through APPS synonyms against the OKC and CSI schemas. Contract definition data is drawn from OKC_K_HEADERS_B and OKC_K_HEADERS_TL (header and translated name), OKC_K_LINES_B (contract lines), OKC_K_ITEMS (contract line items), and OKC_K_PARTY_ROLES_B (party roles). Status validation uses OKC_STATUSES_V. Installed base context comes from CSI_ITEM_INSTANCES, CSI_II_RELATIONSHIPS, CSI_I_ORG_ASSIGNMENTS, and CSI_SYSTEMS_B, which link entitlements to the specific customer assets covered. CS_BUSINESS_PROCESSES supplies business process definitions. User and resource data come from FND_USER, HZ_PARTIES, JTF_RS_RESOURCE_EXTNS and JTF_RS_RESOURCE_EXTNS_TL, and HR_ALL_ORGANIZATION_UNITS_TL, supporting resource-based reaction time calculation and party validation.
Usage Notes
OKS_ENTITLEMENTS_PVT is invoked indirectly through OKS_ENTITLEMENTS_PUB rather than being called by external code. Oracle Service Contracts forms and concurrent programs that create or maintain entitlements route their logic through the public wrapper, and this private package performs validation and computation before DML. Downstream packages such as CS_CHARGE_DETAILS_PVT, OKS_COV_ENT_PVT, and OKS_PM_ENTITLEMENTS_PVT also call it to obtain computed reaction times and coverage data, and views such as CS_CONTRACT_COVERAGES_V and OKS_ENT_TXN_GROUPS_V depend on its exposed logic. Because the package is classified PVT, customizations should target OKS_ENTITLEMENTS_PUB; direct calls to this package risk breakage on patching or upgrade.