Search Results get_fk_igs_as_doc_dlvy_typ

Overview

The APPS.IGS_AS_DOC_DLVY_FEE_PKG package is a table-handler API within the Oracle EBS Student Systems (IGS) product family, specifically the Admissions (AS) module. It encapsulates the business logic required to maintain records in the document delivery fee entity, which governs the fees charged to applicants or students when academic documents (such as transcripts, certificates, or admission letters) are dispatched through a particular delivery mechanism. Because the package is declared AUTHID CURRENT_USER, it executes with the privileges of the calling schema rather than the defining schema, which is consistent with standard Oracle EBS table-handler conventions.

The package is classified as an OTHER API in the ETRM repository for 12.1.1, and the same metadata applies to 12.2.2. It exposes the full complement of DML operations (insert, update, delete, lock, and a combined "add") together with validation helpers and a foreign-key resolver. The foreign-key procedure GET_FK_IGS_AS_DOC_DLVY_TYP is the object most frequently located by developers searching for get_fk_igs_as_doc_dlvy_typ.

Key Procedures and Functions

• INSERT_ROW — Creates a new document delivery fee record, accepting the row identifier, the fee identifier, the delivery method type, amount, fee type, and an operating mode that defaults to 'R'.
• LOCK_ROW — Obtains a pessimistic lock on an existing row, using the rowid and primary key values, to prevent concurrent modification during a form update.
• UPDATE_ROW — Modifies the delivery method type, amount, and fee type of an existing record identified by rowid and primary key.
• ADD_ROW — A convenience routine that inserts a record and returns the generated rowid and primary key, typically used when the caller does not already hold an identifier.
• DELETE_ROW — Removes a single document delivery fee record, located by rowid.
• GET_PK_FOR_VALIDATION — Returns a Boolean indicating whether the supplied primary key (fee identifier) exists, supporting referential validation.
• GET_UK_FOR_validation — Verifies uniqueness of the delivery method type, the natural key for this entity.
• GET_FK_IGS_AS_DOC_DLVY_TYP — Validates that the supplied delivery method type exists in the parent delivery type table, enforcing the foreign-key relationship.
• BEFORE_DML — A central pre-processing routine that populates WHO columns (creation date, created by, last update date, last updated by, last update login) and applies standard validation before any DML action is performed.

Tables Accessed

The package operates against IGS_AS_DOC_DLVY_FEE, the base table storing delivery fee definitions, and IGS_AS_DOC_DLVY_FEE_S, its corresponding sequence or secondary/translation table used for identifier generation. DUAL is referenced for singleton queries, typically within the validation functions to test existence without returning a row set. All access is made through APPS synonyms, and the foreign-key procedure additionally resolves against the parent document delivery type entity named in the procedure title.

Usage Notes

This package is intended for programmatic use rather than direct end-user invocation. It is most commonly called from Oracle Forms-based setup windows where administrators define or amend delivery fee amounts, and from custom PL/SQL that needs to insert delivery fee rows during data migration or integration. The BEFORE_DML helper must be invoked before the DML procedures to ensure WHO audit columns and validations are applied consistently. Developers should call GET_FK_IGS_AS_DOC_DLVY_TYP to validate a delivery method type before attempting an insert or update, thereby avoiding unhandled foreign-key errors. Because the package is referenced by one other package, changes to its signatures may affect dependent code; the API should be treated as a stable interface and extended rather than modified.