Search Results get_latest_batch_id




Overview
Explore in AI Chat

Overview

IGR_GEN_002 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM taxonomy as OTHER. It was created by nsinha on 27-Aug-2003 to support the functionality tracked under bug/feature reference 2885789, described in the header as "Admin_Quick_Entry_RC". A subsequent modification by jchin on 14-Feb-2005 adapted the package for the IGR pseudo product, indicating the original design was later generalized to service more than one Oracle product family.

The package belongs to the IGR (Oracle Grants/Proposal) and IGS (Oracle Student Systems) integration space. Its source header references IGSRT07S.pls, and its procedures operate on interface staging tables used by the Student Systems admission and person interfaces. In practical terms, IGR_GEN_002 serves as a lightweight utility layer for the administrative quick-entry workflow, providing batch-identifier generation and cleanup services for records staged in the IGS interface tables before they are processed into the base application tables.

Key Procedures and Functions

The documented package exposes three procedures, none of which are functions:

  • GET_LATEST_BATCH_ID — Returns the most recently assigned batch identifier. This is the procedure most commonly sought when developers or support analysts search for "get_latest_batch_id". It supplies the current high-water batch value so that callers can determine which batch was last created, typically before deciding whether to reuse, increment, or reconcile against staged interface rows.
  • GET_BATCH_ID — Returns a batch identifier value to the caller. It complements GET_LATEST_BATCH_ID by providing a batch ID for use by the calling process, drawing on the same sequence/control mechanism that underpins batch allocation.
  • DELETE_INQUIRY_DTLS — Removes inquiry detail records associated with a supplied interface identifier. This is a housekeeping procedure used to clear staged administrative quick-entry data from the interface tables once the inquiry has been processed or abandoned.

Both GET_LATEST_BATCH_ID and GET_BATCH_ID use an OUT NOCOPY parameter for the batch identifier, which is a performance-oriented PL/SQL construct that avoids copying the value back to the caller. DELETE_INQUIRY_DTLS takes an IN parameter for the interface identifier. No other parameters are publicly documented.

Tables Accessed

The package works primarily against the IGS interface and staging tables, accessed through APPS synonyms:

Usage Notes

IGR_GEN_002 is an internal utility package rather than a public API. The ETRM metadata records zero packages referencing it, meaning no other documented PL/SQL package depends on it directly. Invocation therefore occurs from forms, concurrent programs, OAF pages, or custom extensions that implement the administrative quick-entry and inquiry-detail workflows. Typical usage patterns include calling GET_LATEST_BATCH_ID to display or validate the current batch in a quick-entry screen, calling GET_BATCH_ID when creating a new staged batch, and calling DELETE_INQUIRY_DTLS as a cleanup step after inquiry processing completes.

Because the package was modified for the IGR pseudo product, developers should confirm behavior against both the IGS and IGR interface table populations before relying on it in new customizations. In 12.1.1 and 12.2.2 the package remains available under the APPS schema; the 12.2 online patching model does not alter its callable interface, but code depending on it should be registered as a dependent object where applicable.