Search Results fetch_all_rows




Overview
Explore in AI Chat

Overview

PAY_DBITL_UPDATE_ERRORS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API in the ETRM repository. It provides a narrow, table-specific data-access layer for the PAY_DBITL_UPDATE_ERRORS table, which stores error messages generated during Oracle Payroll direct deposit (electronic funds transfer) processing. The package is declared AUTHID CURRENT_USER, meaning its unqualified references to the PAY_DBITL_UPDATE_ERRORS table resolve through the caller's schema and synonym context rather than the definer's, a pattern commonly used in EBS for utility packages that must respect the invoker's privileges.

The package exposes a symmetric set of operations—insert, delete, and fetch—over a single error table. It contains no business rules, validation logic, or workflow branching; its purpose is to encapsulate DML and bulk row retrieval so that callers do not embed direct SQL against the underlying table. This isolation simplifies maintenance and allows the storage implementation of the error table to change without affecting dependent code.

Key Procedures and Functions

The ETRM metadata documents six entry points, implemented as overloaded procedures:

  • INSERT_ROW — Inserts a single error record into PAY_DBITL_UPDATE_ERRORS. Two overloads exist: one accepts the error attributes only, and a second additionally returns the ROWID of the newly created row via an OUT parameter, enabling the caller to track or later remove that specific record.
  • DELETE_ROWS — Removes error rows from PAY_DBITL_UPDATE_ERRORS. Two overloads are documented: one deletes by the logical key composed of user name, user entity identifier, and translated name; the other deletes a set of rows identified by a collection of ROWIDs supplied as a DBMS_SQL VARCHAR2S array.
  • DELETE_ROW — Deletes a single row from PAY_DBITL_UPDATE_ERRORS based on a supplied ROWID.
  • FETCH_ALL_ROWS — Retrieves all rows from PAY_DBITL_UPDATE_ERRORS in bulk, returning both an array of ROWIDs and a corresponding array of message texts.

The package also declares a private collection type, t_vc4k, a table of VARCHAR2(4096) indexed by BINARY_INTEGER. This is an internal construct for handling long message text and is not part of the public API.

Tables Accessed

The package operates principally on PAY_DBITL_UPDATE_ERRORS, the repository for direct deposit update error information. All insert, delete, and fetch operations target this table. DBMS_SQL and PLITBLM appear in the metadata as referenced objects; these are Oracle-supplied packages (PLITBLM is the underlying implementation of DBMS_SQL) used to support the bulk collection types VARCHAR2S and VARCHAR2_TABLE employed by the delete-by-ROWID and fetch-all-rows interfaces. No other application tables are touched, confirming the package's deliberately narrow scope.

Usage Notes

This package is a utility layer rather than a user-facing API. It is typically invoked from payroll direct deposit processing code and from other PL/SQL packages that detect and record update errors during electronic funds transfer runs. The ETRM metadata records that it is referenced by two other packages, indicating it is called programmatically rather than directly from a concurrent program or form.

Because the package is AUTHID CURRENT_USER and performs no validation, callers are responsible for supplying well-formed values and for managing transaction scope, including commits. The row-oriented fetch and delete interfaces make it suitable for bulk error-handling routines that must display or purge a full set of errors in one pass. The two OVERLOAD variations of DELETE_ROWS allow callers to choose between key-based removal and ROWID-based removal depending on whether the error rows were previously fetched.