Search Results delete_finance_line

Overview

The APPS.OTA_FINANCE_LINE_API package body is a public application programming interface within the Oracle E-Business Suite OTA (Oracle Training Administration) product family. It encapsulates the business logic required to create, maintain, and remove individual finance line records associated with training finance headers. In ETRM terms, a finance line represents a discrete monetary entry — for example a course fee, a cancellation charge, or a transfer amount — that rolls up under a finance header maintained by the training administration subsystem. By exposing the line-level operations through a single API rather than permitting direct DML against the underlying tables, Oracle ensures that validation logic, sequence numbering, object version numbering, and audit columns are consistently applied regardless of the calling channel. The package body carries the RCS header ottflapi.pkb 120.1 and is owned by APPS, confirming it is a supported, published interface rather than a private implementation unit.

Key Procedures and Functions

ETRM documents three public procedures within this package body:

• CREATE_FINANCE_LINE — Inserts a new finance line row. Based on the documented signature, it accepts the parent finance header identifier, line type, cancellation flag, transfer status, currency and monetary amounts (money, standard, and unitary), comments, a date raised, transfer information flexfield attributes (category plus segments 1 through 20), transfer date and message, and the associated booking deal, booking, resource allocation, and resource booking identifiers. It returns the generated finance line identifier and object version number, and treats the date raised and sequence number as in-out parameters.
• UPDATE_FINANCE_LINE — Modifies an existing finance line, applying attribute changes while preserving entity integrity and maintaining the object version number used for optimistic locking by the consuming forms.
• DELETE_FINANCE_LINE — Removes a finance line record. This is the procedure most commonly located by users searching the string delete_finance_line. It is the supported mechanism for programmatic deletion, ensuring any required validation or parent-child coordination is performed before the physical delete.

Tables Accessed

The package operates against the OTA finance line and finance header tables through APPS synonyms. The finance line table holds the transaction-level rows manipulated by all three procedures, while the finance header table supplies the parent context for the header identifier and roll-up amounts. The transfer information columns correspond to a descriptive flexfield structure, so the API also implicitly validates against the registered flexfield definition. Because the procedures accept object version numbers and sequence numbers, the tables carry the standard Oracle audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, and related fields). No documented standalone table list is supplied in the extracted metadata; table names should be verified against the package body source and the OTA schema before writing custom DML.

Usage Notes

OTA_FINANCE_LINE_API is a server-side API and is not itself an executable; it is invoked from the OTA finance maintenance forms, from other OTA packages, and from customer extensions. ETRM records that it is referenced by one other package, indicating the finance header or finance processing package calls these routines to manage child lines. For custom development, the API should be called directly rather than issuing inserts, updates, or deletes against the finance line table, because the API enforces sequence assignment, versioning, and flexfield handling. Callers must supply a valid finance header identifier and, for updates and deletes, the correct object version number to avoid stale-data conditions. The package is present in both EBS 12.1.1 and 12.2.2; the 12.2.2 ETRM entry confirms the same three procedures remain the documented public interface.