Search Results return_value

Overview

QLTNINRB is a server-side PL/SQL package body owned by APPS within the Oracle E-Business Suite quality module (QL prefix). Its documented purpose, per the source header comment, is to implement a "Server Side Name In" facility. In Oracle EBS Forms architecture, the Name_In built-in reads the current value of a form field from the client-side form into PL/SQL server-side logic. Because that built-in cannot reach the server directly, a supporting server-side package is required; QLTNINRB provides exactly that bridge for the Quality/QA results data model.

The package is therefore a data-retrieval layer used by quality-related forms to fetch QA_RESULTS row values into form-level Name_In variables, buffering rows through explicit cursors so that the form does not need to re-query for every field reference. It is an internal, non-public API (API classification OTHER), positioned behind the APPS synonym layer and consumed by other packages rather than by end users directly.

Key Procedures and Functions

• INIT_CURSOR — Initializes the package-level cursor state from the caller-supplied plan, transaction header, collection, and occurrence identifiers. The source comments record that it replaced an earlier combined table_stuff cursor with two separate cursors (qa_results_txn on TXN_HEADER_ID and qa_results_col on COLLECTION_ID) for performance, and note that the cursor is opened in an exclusive-OR fashion: the caller supplies a transaction header id or a collection id, not both. A third cursor, qa_results_occ, keys on plan_id, collection_id, and occurrence.
• NEXT_ROW — Advances the active cursor and populates the package-global table_rec record (declared qa_results%ROWTYPE), which holds the current QA_RESULTS row for subsequent field reads.
• CLOSE_CURSOR — Releases the open cursor at the end of a form-level fetch sequence, preventing cursor leakage across form navigation.
• NAME_IN — Returns the value of a named column from the currently buffered QA_RESULTS row, emulating the client Name_In built-in on the server side.
• RES_CHAR_COLUMNS — Resolves and returns the character-typed columns of the QA_RESULTS result set, supporting generic field mapping.
• SET_VALUE — Assigns a value to the package's in-memory row buffer, allowing the form layer to programmatically modify a retrieved result value before it is consumed.

Tables Accessed

The package references a single documented table, accessed through its APPS synonym: QA_RESULTS. QA_RESULTS stores quality results collected against a transaction header, a collection plan, and an occurrence — the three keying paths reflected by the package's three cursors. All access is read-oriented row retrieval; the SET_VALUE procedure operates on the package's local table_rec buffer rather than issuing DML against QA_RESULTS.

Usage Notes

QLTNINRB is a supporting library rather than an entry-point API. It is referenced by six other packages, which is consistent with a role as a shared server-side value provider. Typical invocation follows the sequence INIT_CURSOR, repeated NEXT_ROW plus NAME_IN (and optionally SET_VALUE), then CLOSE_CURSOR — mirroring the fetch loop of a form block.

The package is version-controlled through the embedded header ($Header: qltninrb.plb 120.3.12010000.2 2008/10/17), placing it in the 12.1.1 file lineage; the same body is shipped and documented under ETRM 12.2.2, and the source comments reference fixes for Bugs 1293975 and 1843356. Custom code should not call it directly, since it forms part of the Oracle-internal Forms Name_In infrastructure and is subject to change across patch levels.