Search Results igs_as_ss_doc_request
Overview
The APPS.IGS_AS_SS_DOC_REQUEST package body is a core component of the Oracle E-Business Suite Student System (Oracle Student System / IGS) Academic Support (AS) module. Its primary business function is to manage student requests for academic documents — such as transcripts, certification letters, and award statements — and the associated financial and logistical workflows that surround them. This encompasses document ordering, delivery fee determination, invoice creation, waiver evaluation, and integration of delivery charges into the student's fee account. The package status is documented as VALID, and it is classified under the API classification "OTHER," indicating it is a supporting programmatic unit rather than a formal public API, though it is referenced by five other database packages, confirming its role as a shared utility within the Academic Support and Financials intersection.
Key Procedures and Functions
The package exposes thirty documented procedures and functions supporting document request operations. Key routines include:
- CHECK_WAIVERS — Evaluates whether a document request qualifies for a fee waiver based on setup and student criteria.
- GET_SUMMARY_DISPLAY_MESSAGE — Retrieves user-facing messages summarizing request status or outcomes.
- GET_ITEM_DETAILS_FOR_ORDER — Returns line-item detail for a document order.
- GET_ORDER_DETAILS_INCLUDE_ADDR — Retrieves order header information including delivery address.
- GET_TRANSCRIPT_FEE — Determines the applicable transcript fee for a request.
- ENRP_GET_CAREER_DATES — Returns enrollment career date ranges for the student.
- CREATE_INVOICE — Generates the financial invoice for document and delivery charges.
- SHOW_BILL_ME_LATER — Flags requests permitted for deferred billing.
- UPDATE_ORDER_FEE — Adjusts order fee amounts following recalculation.
- INST_IS_EDI_PARTNER — Determines whether an institution operates as an EDI partner for electronic delivery.
- IS_ALL_PROGS_ALLOWED — Validates whether all programs are permitted for the request.
- CREATE_AS_APPLICATION — Creates the underlying academic support application record.
- GET_PRG_ST_END_DTS — Retrieves program start and end dates.
- DELETE_ORDER_AND_ITEMS — Removes an order and its associated line items.
- GET_DOC_AND_DELIVERY_FEE — Computes combined document and delivery charges.
- PAY_LIFETIME_FEES — Processes payment for lifetime document privileges.
- RECALC_AFTER_LFT_PAID — Recalculates fees after lifetime payment posting.
- GET_AS_CURRENT_TERM / GET_AS_NEXT_TERM / GET_AS_PREVIOUS_TERM — Return the academic support term relative to the current period.
Tables Accessed
The package reads and writes through APPS synonyms across Academic Support, Financials, and party-model tables, including:
- IGS_AS_ORDER_HDR, IGS_AS_ORD_ITM_INT — Document order headers and line items.
- IGS_AS_DOC_DETAILS, IGS_AS_DOC_DETAILS_S, IGS_AS_DOCPROC_STUP, IGS_AS_DOC_DLVY_FEE, IGS_AS_DOC_DLVY_TYP, IGS_AS_DOC_FEE_PMNT, IGS_AS_DOC_FEE_STUP — Document setup, delivery types, and fee configuration.
- IGS_FI_APPLICATIONS — Financial application context for invoicing.
- FND_CURRENCIES_TL, FND_LOOKUP_VALUES, FND_NEW_MESSAGES — Currency descriptions, lookup codes, and message publishing.
- HZ_PARTIES, HZ_CONTACT_POINTS — Party and contact/delivery information.
- Enrollment, graduation, and person tables (IGS_EN_*, IGS_GR_*, IGS_PE_*) supply student and career context; Financial packages (IGS_FI_GEN_007, IGS_FI_GEN_GL) perform downstream accounting.
Usage Notes
This package is typically invoked indirectly from Student System forms, concurrent programs, and fee-calculation routines in the Academic Support flow rather than called directly by end users. It is referenced by five other database packages, indicating it is consumed programmatically within the broader document request and fee assessment logic. Customizations extending transcript or document billing should reuse the documented procedures — particularly CREATE_INVOICE, GET_DOC_AND_DELIVERY_FEE, and CHECK_WAIVERS — to preserve fee, waiver, and delivery consistency. Because the body is not documented as referenced by other database objects in the ETRM dependency listing, direct external dependencies on it should be introduced with caution.
-
SYNONYM: APPS.IGS_AS_ORDER_HDR
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_ORDER_HDR, status:VALID,
-
PACKAGE BODY: APPS.IGS_AS_SS_DOC_REQUEST
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AS_SS_DOC_REQUEST, status:VALID,
-
SYNONYM: APPS.IGS_AS_DOC_DETAILS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_DOC_DETAILS, status:VALID,
-
SYNONYM: APPS.IGS_FI_APPLICATIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_APPLICATIONS, status:VALID,
-
PACKAGE: APPS.IGS_AS_SS_DOC_REQUEST
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_SS_DOC_REQUEST, status:VALID,
-
SYNONYM: APPS.IGS_AS_DOC_FEE_STUP
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_DOC_FEE_STUP, status:VALID,
-
SYNONYM: APPS.IGS_AS_SERVIC_PLAN
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_SERVIC_PLAN, status:VALID,
-
SYNONYM: APPS.IGS_FI_WAV_STD_PGMS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_WAV_STD_PGMS, status:VALID,
-
SYNONYM: APPS.IGS_AS_DOC_DLVY_FEE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_DOC_DLVY_FEE, status:VALID,
-
PACKAGE BODY: APPS.IGS_AS_DOC_FEE_PMNT_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AS_DOC_FEE_PMNT_PKG, status:VALID,
-
PACKAGE: APPS.IGS_AS_DOCUMENTS_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_DOCUMENTS_API, status:VALID,
-
SYNONYM: APPS.IGS_AS_DOCPROC_STUP
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_DOCPROC_STUP, status:VALID,
-
PACKAGE: APPS.IGS_AS_DOC_FEE_PMNT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_DOC_FEE_PMNT_PKG, status:VALID,
-
SYNONYM: APPS.IGS_AS_ORD_ITM_INT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_ORD_ITM_INT, status:VALID,
-
PACKAGE: APPS.IGS_FI_SS_CHARGES_API_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_SS_CHARGES_API_PVT, status:VALID,
-
PACKAGE: APPS.IGS_AS_DOC_DETAILS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_DOC_DETAILS_PKG, status:VALID,
-
PACKAGE: APPS.IGS_AS_ORDER_HDR_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_ORDER_HDR_PKG, status:VALID,
-
SYNONYM: APPS.IGS_AS_DOC_DETAILS_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_DOC_DETAILS_S, status:VALID,
-
SYNONYM: APPS.IGS_GR_STAT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_GR_STAT, status:VALID,
-
SYNONYM: APPS.IGS_AS_DOC_DLVY_TYP
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_DOC_DLVY_TYP, status:VALID,
-
SYNONYM: APPS.IGS_AS_DOC_FEE_PMNT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_DOC_FEE_PMNT, status:VALID,
-
SYNONYM: APPS.IGS_FI_INVLN_INT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_INVLN_INT_ALL, status:VALID,
-
PACKAGE BODY: APPS.IGS_AS_DOCUMENTS_API
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AS_DOCUMENTS_API, status:VALID,
-
SYNONYM: APPS.IGS_PE_PERSENC_EFFCT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_PERSENC_EFFCT, status:VALID,
-
SYNONYM: APPS.IGS_EN_SPA_AWD_AIM
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_EN_SPA_AWD_AIM, status:VALID,
-
VIEW: APPS.IGS_AS_ORDER_HDR_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_AS_ORDER_HDR_V, object_name:IGS_AS_ORDER_HDR_V, status:VALID,
-
SYNONYM: APPS.IGS_GR_GRADUAND_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_GR_GRADUAND_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_FEE_STR_STAT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_FEE_STR_STAT, status:VALID,
-
PACKAGE BODY: APPS.IGS_AS_DOC_DETAILS_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AS_DOC_DETAILS_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_CR_ACTIVITIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_CR_ACTIVITIES, status:VALID,
-
PACKAGE BODY: APPS.IGS_EN_SEVIS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_SEVIS, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_007
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_007, status:VALID,
-
SYNONYM: APPS.FND_CURRENCIES_TL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_CURRENCIES_TL, status:VALID,
-
SYNONYM: APPS.IGS_FI_CREDITS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_CREDITS_ALL, status:VALID,
-
SYNONYM: APPS.IGS_PE_TYP_INSTANCES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_TYP_INSTANCES_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_INV_INT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_INV_INT_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_CONTROL_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_CONTROL_ALL, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_GL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_GL, status:VALID,
-
SYNONYM: APPS.IGS_PE_PERSON_TYPES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_PERSON_TYPES, status:VALID,
-
SYNONYM: APPS.IGS_AS_SU_SETATMPT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_SU_SETATMPT, status:VALID,
-
SYNONYM: APPS.IGS_EN_STDNT_PS_ATT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_EN_STDNT_PS_ATT_ALL, status:VALID,
-
SYNONYM: APPS.IGS_PS_VER_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_VER_ALL, status:VALID,
-
SYNONYM: APPS.IGS_PE_HZ_PARTIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_HZ_PARTIES, status:VALID,
-
VIEW: APPS.IGS_CA_DA_INST_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_CA_DA_INST_V, object_name:IGS_CA_DA_INST_V, status:VALID,
-
VIEW: APPS.IGS_PS_TYPE
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PS_TYPE, object_name:IGS_PS_TYPE, status:VALID,
-
PACKAGE: APPS.IGS_AS_SS_DOC_REQUEST
12.1.1
-
VIEW: APPS.IGS_FI_F_TYP_CA_INST
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_F_TYP_CA_INST, object_name:IGS_FI_F_TYP_CA_INST, status:VALID,
-
VIEW: APPS.IGS_FI_FEE_TYPE
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_FEE_TYPE, object_name:IGS_FI_FEE_TYPE, status:VALID,
-
VIEW: APPS.IGS_PS_VER
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PS_VER, object_name:IGS_PS_VER, status:VALID,
-
VIEW: APPS.IGS_CA_TEACH_TO_LOAD_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_CA_TEACH_TO_LOAD_V, object_name:IGS_CA_TEACH_TO_LOAD_V, status:VALID,