Search Results igs_as_doc_dlvy_fee_s

Overview

The APPS.IGS_AS_DOC_DLVY_FEE_PKG package body is a server-side PL/SQL API belonging to the Oracle E-Business Suite Student System (formerly Oracle Student System / OSS) product family, specifically the Advanced Studies (IGS_AS) module. It encapsulates the transactional data manipulation logic for document delivery fees — the fees associated with the physical or electronic delivery of academic documents such as transcripts, certificates, diplomas, and official statements issued to students or third parties.

At Oracle EBS 12.1.1 and 12.2.2 the object resides in the APPS schema with a status of VALID, and ETRM classifies it as an OTHER API. Rather than exposing the base table directly to clients, the package provides a controlled interface — including row locking, primary/unique/foreign key validation, and pre-DML processing — consistent with the Oracle Forms "Table Handler" programming pattern used throughout the Student System data model. This ensures that direct inserts, updates, and deletes on document delivery fee records observe the same key-integrity and audit rules regardless of the calling channel.

Key Procedures and Functions

The package body exposes nine documented program units, all of which are standard components of the Student System table-handler convention:

• INSERT_ROW — Performs the core insert of a new document delivery fee record into the base table, populating key and descriptive columns.
• LOCK_ROW — Issues the row-level lock (typically SELECT ... FOR UPDATE) required before an update or delete, preventing concurrent modification of the same fee row.
• UPDATE_ROW — Applies modifications to an existing document delivery fee record.
• ADD_ROW — Convenience wrapper that validates and then delegates to the insert logic, used by Forms-level "add record" processing.
• DELETE_ROW — Removes a document delivery fee record from the base table.
• GET_PK_FOR_VALIDATION — Retrieves/derives the primary key value used to uniquely identify a fee row during validation.
• GET_UK_FOR_VALIDATION — Retrieves the unique key value used to enforce uniqueness checks on the fee record.
• GET_FK_IGS_AS_DOC_DLVY_TYP — Resolves the foreign key relationship to the document delivery type entity (IGS_AS_DOC_DLVY_TYP), validating that the fee is attached to a legitimate delivery type.
• BEFORE_DML — Central pre-DML hook that executes validation, defaulting, and audit-column stamping before any insert, update, or delete proceeds.

Parameter lists are not reproduced here, as they are not part of the documented metadata; callers should reference the live package specification (IGS_AS_DOC_DLVY_FEE_PKG) for exact signatures.

Tables Accessed

The package operates against the following documented objects, accessed via APPS synonyms:

• IGS_AS_DOC_DLVY_FEE — The base transactional table holding document delivery fee definitions; this is the primary insert/update/delete target.
• IGS_AS_DOC_DLVY_FEE_S — The corresponding localization/sequence-support table (the "_S" companion) referenced for key generation and validation. Notably, this is the object name returned by the user's search term igs_as_doc_dlvy_fee_s.
• DUAL — Used for single-row evaluations, sequence value retrieval, and validation lookups.

The dependency list also records references to supporting APIs used for integrity and messaging: IGS_AS_DOC_DLVY_TYP_PKG (delivery type validation), IGS_FI_FEE_TYPE_PKG (fee type validation), IGS_GE_MSG_STACK, FND_MESSAGE, and FND_GLOBAL (for message retrieval and session/user context), as well as APP_EXCEPTION for standardized error raising.

Usage Notes

Because this is a table-handler package body, it is invoked primarily from the Oracle Forms-based Document Delivery Fee maintenance windows within the Student System responsibility. Forms trigger events — record creation, modification, and deletion — map directly onto ADD_ROW, UPDATE_ROW, and DELETE_ROW, with LOCK_ROW enforcing optimistic concurrency and BEFORE_DML firing validation ahead of each DML operation.

Custom or extension code should call the documented procedures rather than issuing DML against IGS_AS_DOC_DLVY_FEE directly, since the package applies key-validation, foreign-key checks to the delivery type, and standardized error messaging via FND_MESSAGE/IGS_GE_MSG_STACK. ETRM records that this package is not referenced by any database object, confirming it acts as a top-level entry point rather than a utility consumed internally by other PL/SQL units. It is compiled as VALID in both EBS 12.1.1 and 12.2.2, and its behavior is consistent across those releases. When troubleshooting, ensure the underlying fee type and delivery type setup data exist, as the foreign-key helpers will reject a delivery fee whose associated type is not defined.