Search Results get_osp_order_number




Overview
Explore in AI Chat

Overview

The APPS.AHL_WARRANTY_ENTL_PVT package is a private (PVT) PL/SQL API within the Oracle E-Business Suite Depot Repair and Enterprise Asset Management (eAM) warranty framework. It encapsulates the business logic that governs warranty entitlement processing, including the creation, modification, approval, and expiration lifecycle of warranty entitlements recorded against a customer's installed base. The package operates under AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, which is characteristic of internal EBS API layers invoked from other packages and forms within the same APPS schema context.

The package is tightly coupled to the Oracle Workflow engine. Its declared constants map business objects to workflow process names (W_ENTL, W_EXPR, W_WOCL) registered against the AHL_APPR_OBJECT_TYPE lookup, and it references AOL notification functions, message codes, and subject templates used to render warranty entitlement, expiration, and work order completion notifications. Operation and approval constants (create, update, delete, approve; accept, reject) and user-role constants (planner, non-planner) indicate that the package supports approval routing where planners and non-planners have differentiated privileges.

Key Procedures and Functions

  • PROCESS_WARRANTY_ENTITLEMENTS — The primary driver procedure that processes warranty entitlement records against a requested operation (create, update, delete, or approve). It orchestrates validation, persistence, and downstream workflow initiation.
  • IS_TASK_WARRANTY_AVAILABLE — A Boolean-returning check that determines whether warranty coverage applies to a given service task, typically used before authorizing warranty-covered work in Depot Repair or field service flows.
  • LAUNCH_ENTL_NOTIFICATION — Initiates the workflow notification associated with a warranty entitlement approval or review event.
  • LAUNCH_EXPR_NOTIFICATION — Raises the notification generated when a warranty entitlement approaches or reaches expiration.
  • LAUNCH_WOCL_NOTIFICATION — Fires the notification tied to warranty work order completion.
  • GET_ENTITLEMENT_INSTANCE — Returns the entitlement instance context for a warranty entitlement, resolving the item instance association used in coverage evaluation.
  • GET_OSP_ORDER_NUMBER, GET_OSP_LINE_NUMBER, GET_OSP_LINE_STATUS — Helper functions that retrieve the order number, line number, and line status from the outside processing (OSP) order structures linked to a warranty transaction.

Tables Accessed

The package reads and writes the core warranty tables AHL_WARRANTY_ENTITLEMENTS and its sequence-backed surrogate AHL_WARRANTY_ENTITLEMENTS_S, and consults AHL_WARRANTY_CONTRACTS_B and AHL_WARRANTY_CLAIMS_B to establish contractual coverage and claim eligibility. Installed base context is resolved through CSI_ITEM_INSTANCES. Service execution data is drawn from AHL_WORKORDERS, AHL_VISIT_TASKS_B, AHL_MR_HEADERS_B, AHL_MR_ROUTES, and AHL_ROUTES_B. Outside processing linkage uses AHL_OSP_ORDERS_B and AHL_OSP_ORDER_LINES. Service request references come from CS_INCIDENTS_ALL_B, and workflow notification metadata is read from FND_NEW_MESSAGES. DUAL supports scalar evaluations.

Usage Notes

As a PVT-classified package, AHL_WARRANTY_ENTL_PVT is not intended as a public integration surface. It is referenced by seventeen other packages within the EBS codebase and is typically invoked indirectly through public warranty APIs, the Depot Repair and warranty entitlement forms, and Oracle Workflow background processes. Customizations that require entitlement processing should call the corresponding public API rather than this private layer. Direct invocation is appropriate only for diagnostic or administrative scripts operating with full APPS privileges, and any such use must account for the approval-role and workflow-object constants defined at package scope.