Search Results get_appl_type_fee_details




Overview
Explore in AI Chat

Overview

IGS_AD_SS_APPL_FEE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the fee assessment and application-fee processing logic within the Oracle Student System (formerly Oracle iLearning/Recruiting and Admissions) admissions module. Its name reflects its role in the "SS" (Student System) admissions sub-module, functioning alongside objects such as IGS_AD_SS_APPL_FEE_PKG, IGS_AD_SS_GEN_001, and the broader IGS_AD family of admissions packages. In the 12.1.1 and 12.2.2 release streams, this package is documented as VALID and is classified as API type OTHER, indicating it is an internal supporting package rather than a formally published public API. Its primary purpose is to evaluate and validate application fee information associated with admission applications, offers, and applicant response records, and to retrieve or update application type fee details as applicants progress through the admissions lifecycle.

Key Procedures and Functions

The package exposes five documented program units, each addressing a specific validation or data-retrieval activity in the application fee workflow:

  • CHECK_OFFER_UPDATE — Validates whether an offer record may be updated in the context of application fee processing, ensuring fee-related dependencies and business rules are satisfied before an offer change is permitted.
  • CHECK_OFFER_RESP_UPDATE — Performs the equivalent validation for offer response updates, allowing the system to enforce fee-related constraints when an applicant responds to an offer.
  • CHECK_UPDATE_AEPS_ACS — Verifies preconditions governing updates to AEPS/ACS (applicant/application status) data, guarding status transitions that could affect fees or application processing.
  • GET_APPL_TYPE_FEE_DETAILS — Retrieves the fee details configured for a given application type, returning the applicable fee structure needed for assessment and display.
  • UPD_FEE_DETAILS — Writes or updates application fee detail records, persisting fee information generated by the admissions process.

Parameter lists are not documented in the ETRM excerpt; callers should inspect the package specification directly for exact signatures.

Tables Accessed

The package operates against several admissions tables through APPS synonyms:

  • IGS_AD_APPL_ALL — the master admission application table, the primary anchor for application records.
  • IGS_AD_APP_REQ — application request data linked to an applicant's submission.
  • IGS_AD_CODE_CLASSES — code class definitions, likely used for fee code validation or classification.
  • IGS_AD_PS_APPL_INST_ALL — application instance data tied to the applicant's person record.
  • IGS_AD_SS_APPL_TYP — application type definitions, used when retrieving or validating application type fee details.
  • IGS_TR_TYPE_ALL — transfer/transaction type data, likely used to resolve fee-related transaction categories.

Usage Notes

IGS_AD_SS_APPL_FEE_PKG is an internal package referenced by the admissions module's own code, most notably IGS_AD_SS_GEN_001 and one additional package. It is typically invoked indirectly from admission application entry forms and from admissions processing concurrent programs that assess or maintain application fees, rather than being called directly by end users. Customizations and extensions should avoid modifying the package and instead rely on supported APIs or extension hooks, since the package is classified as OTHER (not a public API) and its interfaces are subject to change without notice. Customers who wish to understand its exact behavior should review the package body in the APPS schema, since the ETRM metadata documents only the program unit names and table dependencies. Dependency tracing confirms SYS.STANDARD as its only documented external reference, indicating the package is self-contained with respect to Oracle-supplied PL/SQL objects.