Search Results is_all_progs_allowed

Overview

The APPS.IGS_AS_SS_DOC_REQUEST package belongs to the Oracle Student System (IGS) product family and supports the Academic Support (AS) module's self-service document request functionality. It provides the server-side PL/SQL logic used by students and staff to order academic documents such as transcripts, enrollment certificates, and other official records. The package governs fee determination, waiver evaluation, invoice generation, and the calculation of document and delivery charges associated with a document order.

As an API (ETRM classification: OTHER), the package exposes a set of public procedures and functions that encapsulate the business rules for document ordering, allowing forms, self-service pages, and concurrent programs to invoke that logic consistently. It is referenced by five other packages in the application, indicating a central role in the document request workflow.

Key Procedures and Functions

The documented interface includes 30 procedures and functions. The following are representative of the package's responsibilities, including the GET_TRANSCRIPT_FEE member that is the subject of the originating search:

• GET_TRANSCRIPT_FEE — Returns the fee (NUMBER) for a requested transcript. Inputs identify the person, document type, number of copies, and optionally whether a delivery fee and a specific delivery method and item number should be considered. Declared with PRAGMA RESTRICT_REFERENCES (WNDS, WNPS), meaning it performs no database writes and is safe for read-only use.
• CHECK_WAIVERS — Determines whether the specified person is eligible for a fee waiver.
• GET_SUMMARY_DISPLAY_MESSAGE — Returns hold, hint, and eligibility messages along with flags indicating whether request, transcript, e-certificate, and lifetime-fee options are allowed for a person.
• GET_ITEM_DETAILS_FOR_ORDER and GET_ORDER_DETAILS_INCLUDE_ADDR — Return formatted detail strings for an order or item, including address information.
• CREATE_INVOICE — Creates an invoice for an order, returning the invoice identifier, return status, message data, and any waiver amount.
• UPDATE_ORDER_FEE — Recalculates an order line fee when document type, delivery type, or copy count changes.
• GET_DOC_AND_DELIVERY_FEE and PAY_LIFETIME_FEES — Retrieve combined document/delivery charges and process lifetime fee payments.
• SHOW_BILL_ME_LATER — Advises whether a deferred-payment option is available.
• DELETE_ORDER_AND_ITEMS — Removes an order and its associated line items.
• Term and programme helpers such as GET_AS_CURRENT_TERM, GET_AS_NEXT_TERM, GET_AS_PREVIOUS_TERM, GET_PRG_ST_END_DTS, and ENRP_GET_CAREER_DATES — Supply academic calendar and programme context for document requests.

Tables Accessed

The package reads and writes the core Academic Support tables through APPS synonyms. Order header and line data reside in IGS_AS_ORDER_HDR, IGS_AS_DOC_DETAILS, and IGS_AS_DOC_DETAILS_S. Fee and delivery rules are drawn from IGS_AS_DOC_FEE_STUP, IGS_AS_DOC_FEE_PMNT, IGS_AS_DOC_DLVY_FEE, and IGS_AS_DOC_DLVY_TYP. Document processing configuration comes from IGS_AS_DOCPROC_STUP, with item integration data in IGS_AS_ORD_ITM_INT and financial application data in IGS_FI_APPLICATIONS. Party and contact information is resolved via HZ_PARTIES and HZ_CONTACT_POINTS. Currency and lookup values are obtained from FND_CURRENCIES_TL and FND_LOOKUP_VALUES, and user messages from FND_NEW_MESSAGES.

Usage Notes

The package is typically invoked from the Student System self-service document request pages, administrative forms that manage document orders, and any concurrent or custom code that must reproduce order pricing or eligibility logic. Because GET_TRANSCRIPT_FEE carries PRAGMA RESTRICT_REFERENCES (WNDS, WNPS), it can be called safely from SQL and read-only contexts; callers should supply the person identifier, document type, and copy count, and may rely on the default delivery-fee handling when a delivery charge should be included. When pricing an existing order, UPDATE_ORDER_FEE should be used instead, so that changed line attributes are re-evaluated against the fee setup tables.