Search Results populate_bio_tables




Overview
Explore in AI Chat

Overview

The APPS.IGW_PROP_PERSON_DEGREES_PVT package body is a private (PVT-classified) PL/SQL API belonging to the Oracle EBS Grants/Proposals (IGW) product family. It manages the degree records associated with proposal personnel, maintaining the link between a proposal, a person, and that person's academic or professional degrees displayed on a proposal biosketch. The package encapsulates the business logic that validates, updates, and repopulates degree and biosketch data when proposal personnel information changes, ensuring that the degrees shown on a proposal record remain consistent with the underlying person and proposal data structures. Because it is a PVT package, it is intended for internal consumption by other IGW proposal APIs and forms rather than as a public integration surface.

Key Procedures and Functions

  • UPDATE_PROP_PERSON_DEGREES — The primary DML driver of the package. It follows the standard EBS API pattern: optionally creating a savepoint when p_commit is true, initializing the message list when p_init_msg_list is true, and setting x_return_status to success. It performs a locking/version check via CHECK_LOCK before delegating the physical row modification to the underlying table handler IGW_PROP_PERSON_DEGREES_TBH.UPDATE_ROW. Validation-only execution is honored through the p_validate_only flag.
  • CHECK_LOCK — Enforces optimistic concurrency control. It compares the supplied x_rowid and p_record_version_number against the persisted row so that stale updates are rejected before any write occurs.
  • CHECK_ERRORS — Examines the accumulated FND message stack and translates error conditions into the appropriate x_return_status value, propagating message count and message data back to the caller. It is invoked after each significant validation step.
  • VALIDATE_LOGGED_USER_RIGHTS — Validates that the logged-in user possesses the authority to modify the given proposal personnel degree record. In the documented body this invocation is commented out, indicating a legacy or placeholder check retained within the package.
  • POPULATE_BIO_TABLES — Populates the biosketch-related tables from the proposal personnel and degree data. This procedure is the anchor point for users searching on "populate_bio_tables," as it is responsible for synchronizing the biosketch snapshot used for proposal rendering.

Tables Accessed

  • IGW_PROP_PERSON_DEGREES — The primary transaction table holding degrees of proposal personnel; the target of the update logic.
  • IGW_PROP_PERSON_BIOSKETCH — Stores the proposal-specific biosketch records for personnel, populated or refreshed by POPULATE_BIO_TABLES.
  • IGW_PERSON_DEGREES — The underlying person-level degree master data from which proposal degrees are derived.
  • IGW_PERSON_BIOSKETCH — The base person biosketch source data used to populate the proposal biosketch tables.

All tables are referenced through APPS synonyms, consistent with standard EBS schema layering.

Usage Notes

This package is typically invoked indirectly rather than called directly by end users. The Proposals and Grants forms and the associated proposal personnel APIs call UPDATE_PROP_PERSON_DEGREES when a user edits the degrees of a proposal team member, and they invoke POPULATE_BIO_TABLES when a biosketch must be generated or refreshed from the person's stored credentials. Custom code extending IGW proposal personnel functionality may call these procedures directly, adhering to the FND_API conventions for message list initialization, savepoint handling, and return status interpretation. Because the package is classified as PVT and is referenced by zero other documented packages, it should be treated as an internal implementation detail; any direct dependency on its signatures risks breakage across patch levels. Callers should always inspect x_return_status and drain the FND message stack via CHECK_ERRORS semantics after invocation.