Results for “p_show_flag”

20 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGW_PROP_PERSON_BIOSKETCH_TBH is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Grants and Proposal Management (IGW) product family. Its name follows the standard EBS naming convention in which the _TBH suffix denotes a "table handler" — a package whose purpose is to encapsulate row-level DML and validation logic against a single base table on behalf of higher-level APIs, forms, or concurrent processes. In this case the underlying table is IGW_PROP_PERSON_BIOSKETCH, which stores biographical sketch information for named persons attached to a proposal.

Functionally, the package provides the controlled write path through which biographical sketch records are created or modified for a given proposal and person. It is declared with AUTHID CURRENT_USER, meaning execution privileges are evaluated against the invoking schema rather than the definer, which is typical for a low-level handler invoked from within the APPS runtime environment.

Key Procedures and Functions

The ETRM metadata documents a single procedure in this package:

  • UPDATE_ROW — The sole documented entry point. As the name indicates, this procedure performs the update operation on a row of the biographical sketch table. Its signature accepts the row identifier of the target record, the proposal identifier and the person biographical sketch identifier that together identify the logical record, a show flag, a line sequence number, a processing mode indicator (defaulting to 'R'), the record version number used for optimistic concurrency checking, and an output return status parameter. The procedure therefore supports both the location of the target row and concurrency control, returning a status value to the caller so that errors or successful completion can be interpreted programmatically.

No other procedures or functions are listed in the documented metadata for this object.

Tables Accessed

The package operates against one documented base table:

  • IGW_PROP_PERSON_BIOSKETCH — referenced through an APPS synonym. This table holds the person biographical sketch rows associated with a proposal. UPDATE_ROW reads and writes rows in this table; the proposal identifier, person biographical sketch identifier, line sequence, and record version number supplied as parameters map directly into the table's key and descriptive columns.

Because the package is a table handler, its data access is intentionally narrow and confined to this single entity.

Usage Notes

As a table-handler package, IGW_PROP_PERSON_BIOSKETCH_TBH is not intended to be called directly by end users. It is normally invoked from the IGW forms or from higher-level proposal APIs that manage biographical sketch data. The ETRM metadata records that the package is referenced by one other package, confirming that it forms a lower layer of a small call hierarchy rather than a top-level integration point.

The P_MODE parameter, which defaults to 'R', allows callers to signal the required processing context — for example, a normal update versus a mode used during form-driven operations. The P_RECORD_VERSION_NUMBER parameter indicates that optimistic locking is enforced: callers must supply the version they read, and the procedure is expected to detect stale updates. The X_RETURN_STATUS output allows the calling layer to branch on success or failure without relying on exceptions.

Customizations that need to modify biographical sketch rows should call this package rather than issuing direct DML against IGW_PROP_PERSON_BIOSKETCH, so that the version checking and status conventions established by the package are preserved.