Search Results ap_pbatch_set_header_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_PBATCH_SET_HEADER_PKG is a PL/SQL package that belongs to the Oracle Payables (AP) module of Oracle E-Business Suite. Its classification in the ETRM repository is OTHER, indicating that it is not an externally published open interface or standard public API, but rather an internal implementation package. The package operates against the batch set header entity, which is the grouping construct used by Oracle Payables to organize payment batches into a parent "payment batch set." A payment batch set allows a Payables user or process to consolidate multiple payment batches that are processed or transmitted together, most notably in the context of electronic payment creation. AP_PBATCH_SET_HEADER_PKG therefore provides the low-level persistence logic for maintaining the header record of such a set — the single row that identifies and describes a payment batch set within the application's data model.

Key Procedures and Functions

The package exposes four documented procedures. No parameter lists are published in the ETRM metadata, so the descriptions below are limited to purpose.

  • INSERT_ROW — Creates a new payment batch set header record. This procedure performs the row insertion that establishes a new batch set, populating the header-level attributes required to uniquely identify the set.
  • LOCK_ROW — Acquires a lock on the specified batch set header row. This is used to serialize concurrent operations on the same header, preventing conflicting updates or deletes while a transaction is in progress.
  • UPDATE_ROW — Modifies the attributes of an existing payment batch set header. This supports changes to the batch set's descriptive or control fields after the header has been created.
  • DELETE_ROW — Removes a payment batch set header record. This is typically invoked when a batch set is being discarded or cleaned up as part of batch set maintenance.

Collectively, these procedures form a conventional CRUD set built on the Oracle Forms row-handling pattern that is common throughout EBS internal table-handler packages.

Tables Accessed

The ETRM dependency information identifies two tables referenced through APPS synonyms:

  • AP_PBATCH_SETS — The primary payment batch set header table. Insert, update, lock, and delete operations described above act against this table.
  • AP_PBATCH_SETS_S — The corresponding Oracle Forms "S" (sequence/shadow) table, which stores the next available primary key value for new rows created in AP_PBATCH_SETS. This table is read during insert processing to obtain the unique identifier for a new header row.

The package also declares a dependency on the SYS.STANDARD package, which is the standard PL/SQL library available to all stored program units.

Usage Notes

AP_PBATCH_SET_HEADER_PKG is an internal table-handler package rather than a documented public API. Based on the Oracle Forms key-table pattern reflected in its procedures, it is most commonly invoked by Oracle Payables application forms that maintain payment batch set information — the form block triggers call INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW as the user creates, edits, or removes a batch set header. It may also be called by other PL/SQL program units within the Payables schema that need to create or maintain batch set headers programmatically. Because it is not part of a documented public interface, customizations should not call this package directly unless the calling code fully replicates the locking and key-generation conventions used by the application forms. The metadata indicates the package is VALID and that no other packages reference it, suggesting its use is confined to form-level and direct database operations.