Search Results insert_ap_request




Overview
Explore in AI Chat

Overview

OKL_INSURANCE_POLICIES_PUB is the public API package body for insurance policy processing within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. The package exposes a controlled, versioned interface through which calling programs—primarily Oracle Forms, concurrent programs, and custom extensions—can create, modify, and terminate insurance policies associated with lease and financing contracts. The _PUB suffix indicates that this package is the published, supported entry point: it validates and normalizes parameters, then delegates the substantive business logic to the corresponding private package, OKL_INSURANCE_POLICIES_Pvt. In the documented implementation, each public procedure declares a savepoint, copies inbound parameters into local variables, and invokes the private counterpart with the standard API return-status and message-count conventions (x_return_status, x_msg_count, x_msg_data). This layering isolates callers from schema changes and centralizes error handling and message propagation.

Key Procedures and Functions

  • INSERT_AP_REQUEST — Creates an AP (Accounts Payable) request associated with an insurance policy transaction. Based on the documented signature, it accepts identifiers for the transaction, credit, vendor site, and related contract entities, a credit amount, an invoice date, and returns a request identifier. This procedure is the target of the user's search term "insert_ap_request."
  • CANCEL_POLICY — Cancels a single insurance policy, reversing its associated financial and contractual effects.
  • CANCEL_POLICIES — Cancels multiple insurance policies, providing a bulk alternative to CANCEL_POLICY.
  • CANCEL_CREATE_POLICIES — Handles cancellation and creation of policies in a combined processing path, used when a policy must be replaced rather than simply terminated.
  • DELETE_POLICY — Removes an insurance policy record that should not be retained in the system.
  • CHECK_CLAIMS — Evaluates whether an insurance policy has claims activity, typically to prevent or constrain cancellation or deletion when claims exist.

The metadata documents eight procedures or functions in total; the six named above constitute the documented public surface relevant to policy maintenance.

Tables Accessed

The ETRM metadata for this package does not enumerate the underlying tables explicitly. The procedures operate against the OKL insurance policy tables through APPS synonyms—principally the insurance policy header and its related credit and transaction detail tables, along with vendor site and AP request reference data used by INSERT_AP_REQUEST. Because access occurs via APPS synonyms, the package is insulated from the base schema names. The metadata records that no tables are documented directly against this object, so table-level detail should be confirmed by inspecting the private package OKL_INSURANCE_POLICIES_Pvt, which performs the physical DML.

Usage Notes

OKL_INSURANCE_POLICIES_PUB is normally invoked from Oracle Forms within the Lease Management responsibility, from concurrent programs that process insurance policy maintenance in batch, and from custom code that requires a supported entry point rather than direct DML. The ETRM metadata states that this package is referenced by eight other packages, indicating it is a foundational component in the OKL insurance area. Callers should always pass a valid p_api_version and p_init_msg_list, then inspect x_return_status before proceeding; the package follows the standard EBS convention in which a status of U indicates an unexpected error, E an expected error, and S success. Message details are retrieved through x_msg_count and x_msg_data. Because the public body wraps each call in a savepoint and delegates to the private package, custom integrations should not bypass it in favor of the private package, and should be validated against both release 12.1.1 and 12.2.2 environments before deployment.