Search Results get_fk_igs_pr_ms_stat




Overview
Explore in AI Chat

Overview

IGS_PR_MILESTONE_PKG is an Oracle EBS Applications (APPS) PL/SQL package within the Student Systems / Recruiting and Admissions product family, identified by the IGS prefix and the PR (Prospective/Recruitment) schema area. It provides the procedural interface for the IGS_PR_MILESTONE_ALL entity, which stores admissions and recruitment milestone records associated with prospective students. Milestones represent discrete events or requirements in a prospect's candidature lifecycle, such as application submission, document receipt, interview scheduling, or offer response. Each milestone carries a status, due date, actual reached date, notification override intervals, and predecessor sequencing used to model interdependencies between milestones.

The package follows the standard Oracle EBS table-handler pattern, exposing DML operations, validation helpers, and constraint enforcement routines that are bound to the underlying base table through the APPS synonym. Although the header comments date from 2005, the package remains available in both 12.1.1 and 12.2.2 environments as part of the IGS product data model.

Key Procedures and Functions

The package exposes twelve documented procedures and functions:

  • INSERT_ROW — Creates a new milestone row in the base table, accepting all principal attributes (person, candidature sequence, milestone sequence, type, status, due date, description, actual reached date, predecessor sequence, three notification override intervals, comments), an organization identifier, and a mode flag defaulting to 'R'.
  • LOCK_ROW — Acquires a row-level lock for the identified milestone record to support optimistic concurrency in forms.
  • UPDATE_ROW — Modifies an existing milestone row, taking the row identifier plus the updatable attributes and mode flag.
  • ADD_ROW — Inserts a new milestone using a similar parameter set to INSERT_ROW, typically used where the surrogate key (rowid) must be returned to the caller.
  • DELETE_ROW — Removes a milestone row.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of the base record for validation purposes, allowing callers to confirm existence before dependent processing.
  • GET_FK_IGS_RE_CANDIDATURE — Foreign-key lookup against IGS_RE_CANDIDATURE, resolving the candidature context to which the milestone belongs.
  • GET_FK_IGS_PR_MILESTONE — Foreign-key lookup against the milestone table itself, supporting predecessor or parent milestone resolution.
  • GET_FK_IGS_PR_MS_STAT — Foreign-key lookup resolving the milestone status value against the IGS_PR_MS_STAT reference entity. This is the routine surfaced by the search term "get_fk_igs_pr_ms_stat".
  • GET_FK_IGS_PR_MILESTONE_TYPE — Foreign-key lookup resolving the milestone type against the IGS_PR_MILESTONE_TYPE reference entity.
  • CHECK_CONSTRAINTS — Validates business and referential constraints before a DML operation proceeds.
  • BEFORE_DML — Standard pre-DML trigger handler, invoked to enforce WHO-column maintenance and constraint checks prior to insert, update, or delete.

Tables Accessed

The documented table referenced via APPS synonym is IGS_PR_MILESTONE_ALL, which holds all milestone records across operating units (the _ALL suffix indicating multi-org partitioning via ORG_ID). It is the sole documented base table. The GET_FK_* routines additionally imply reads against the reference and parent entities — IGS_RE_CANDIDATURE, IGS_PR_MS_STAT, and IGS_PR_MILESTONE_TYPE — used to validate foreign-key values supplied by forms.

Usage Notes

IGS_PR_MILESTONE_PKG is classified as OTHER in the ETRM catalog and is referenced by seven other packages, indicating it is consumed primarily by internal IGS processing rather than being called directly by end users. Typical invocation paths include the Oracle Forms UI for admissions milestone maintenance, concurrent programs that generate or advance milestone schedules, and custom extensions or integrations requiring programmatic maintenance of milestone data. Callers should pass a valid ORG_ID on insert and use the LOCK_ROW routine before UPDATE_ROW to maintain concurrency integrity. For the searched term get_fk_igs_pr_ms_stat, the routine returns the descriptive context for a milestone status code and is normally invoked from LOV validation logic within the milestone form.