Search Results close_cursor

Overview

QLTNINRB is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name reflects its role as a "server side name in" utility within the Oracle Quality (QA) module. The package provides a server-side implementation of the name-in / next-row navigation model traditionally associated with Oracle Forms, allowing PL/SQL code executing on the database tier to iterate over a result set column by column and row by row. This design is particularly important for Oracle Quality collection import and results processing, where characteristic values must be resolved dynamically by column name rather than by positional reference.

The package declares AUTHID CURRENT_USER, meaning that privilege checking and unqualified name resolution occur under the invoker's schema, and it is compiled against the standard EBS 12.1.1 and 12.2.2 code line (the header records version 120.1.12020000.1, dated June 2012). The API classification is OTHER, indicating it is not part of a formal public API family but is nonetheless referenced broadly within the application, including by six other packages.

Key Procedures and Functions

• INIT_CURSOR — Initializes the package's internal cursor context. Per the header commentary, its signature was extended to include plan and occurrence identifiers (referencing an early bug fix), and it accepts transaction header and collection identifiers so the cursor can be scoped to a specific collection import or results context.
• NAME_IN — Returns the value of a named column from the current cursor row as a VARCHAR2. This is the core "name in" accessor that lets callers retrieve fields by column name instead of position.
• NEXT_ROW — Advances the cursor to the next row of the result set and returns a BOOLEAN indicating whether a row was successfully fetched. Callers typically loop on this function until it returns FALSE.
• CLOSE_CURSOR — Releases the cursor context established by INIT_CURSOR. This is the procedure most relevant to the originating search term "close_cursor," and it should be invoked once iteration is complete to free session resources and avoid leaking open cursors.
• RES_CHAR_COLUMNS — Returns the maximum number of result characteristic columns available, allowing callers to size their processing loops or dynamically discover the width of the characteristic result structure.
• SET_VALUE — Added under a 12.1.1 fix (bug 7491253) to assign a value to a named field for the current record in session, supporting collection import scenarios where values must be written back to the in-memory row image.

Tables Accessed

The only documented table referenced through APPS synonyms is QA_RESULTS, the core Oracle Quality table storing quality results records. QLTNINRB uses QA_RESULTS as the primary source for the cursor it opens in INIT_CURSOR, and it drives NAME_IN, NEXT_ROW, and SET_VALUE against rows of that table as filtered by the plan, transaction header, collection, and occurrence identifiers supplied at initialization.

Usage Notes

QLTNINRB is normally invoked from server-side PL/SQL — most commonly from other Quality packages that need to walk a collection of results records and read characteristic values by name. It is not an end-user API and is not a concurrent program entry point. Custom code that reuses it should follow the standard lifecycle: call INIT_CURSOR to establish context, loop on NEXT_ROW while it returns TRUE, read fields via NAME_IN, optionally write fields through SET_VALUE, and always call CLOSE_CURSOR on exit (including exception handlers) to release the cursor. Because it runs under AUTHID CURRENT_USER and resolves QA_RESULTS through APPS synonyms, callers must ensure appropriate Quality privileges are active in their session.