Search Results reject_request

Overview

IGS_AS_CGR_WF_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supplies the server-side workflow logic for the academic change-of-grade request approval process. The package name follows the IGS (Student Systems) naming convention: AS identifies the Student Administration product family and CGR denotes the change-of-grade request entity. The suffix WF indicates that the package provides callable activities and functions invoked by the Oracle Workflow engine, while PKG is the standard package designator. The package is declared AUTHID CURRENT_USER, meaning its unqualified references resolve in the schema of the invoking user; in practice the package is executed under APPS, where the required synonyms reside.

The business purpose of the package is to expose the decision points of the change-of-grade approval workflow. When a change-of-grade request is submitted, the workflow routes it for review. Each of the four documented procedures corresponds to a workflow activity node executed as the notification is approved, rejected, returned for information, or as the approver is selected. The package therefore bridges the Workflow notification framework with the underlying student records, ensuring that a decision taken by a user in a notification results in the appropriate state change on the request and its associated grade data.

Key Procedures and Functions

• Select_Approver — Determines and returns the approver to whom the change-of-grade request should be routed. This activity typically queries the routing and approval hierarchy and writes the resulting approver identity into the workflow item attributes used by subsequent notification activities.
• Approve_Request — Executes the approval path of the workflow. It records the approver's positive decision against the request, advances the request status, and allows the workflow engine to continue toward completion or the next review level.
• Reject_Request — Executes the rejection path of the workflow. It records the approver's negative decision, terminates or returns the workflow according to the configured outcome, and prevents further processing of the request.
• Need_Information — Executes the "return for information" path. It suspends or routes the request back to the originating party so that supporting documentation or clarification can be supplied before the approval cycle resumes.

All four procedures are documented with a uniform signature consisting of the Workflow context parameters Itemtype, Itemkey, Actid, and Funcmode, together with the standard Resultout output parameter. The metadata does not document further parameters, and none should be assumed. The consistent signature confirms that these routines are registered as standard Workflow function activities rather than being called directly from user interface code.

Tables Accessed

The documented table references establish the package's data footprint:

• FND_USER — the Oracle Applications user repository. It is used to resolve user identifiers into valid application users, primarily during approver selection and to validate the identity of the acting approver.
• IGS_AS_CHN_GRD_REQ — the change-of-grade request table, the central transactional entity of the workflow. It stores the request details and its workflow status, which the approve, reject, and need-information procedures update.
• IGS_PS_USEC_TCH_RESP — records teaching responsibility assignments, used to derive the appropriate person or unit responsible for reviewing a change-of-grade request during approver selection.

Usage Notes

IGS_AS_CGR_WF_PKG is not intended for direct invocation by end users. Its procedures are registered against activities in the change-of-grade request item type within Oracle Workflow, so they are invoked by the Workflow engine at runtime as notifications are responded to. Customizations should therefore target the workflow definition and the underlying request data rather than the package body. The ETRM metadata records no downstream packages that reference IGS_AS_CGR_WF_PKG, indicating it is an entry point rather than a shared library. Because the package runs AUTHID CURRENT_USER, any custom extension calling it directly must qualify object references or run under APPS to guarantee that the expected synonyms resolve.