Search Results wf_set_role

Overview

IGS_AV_VAL_ASULEB is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification of OTHER. Its name follows the Oracle Student System (IGS) naming conventions, where the IGS_AV prefix denotes the Advanced Standing component of the Student Records/Admissions functionality and VAL_ASULEB indicates validation logic relating to Advanced Standing Units, Levels, and Basis records. The package is declared with AUTHID CURRENT_USER, meaning its procedures and functions execute with the privileges of the calling user rather than the definer, and it relies on APPS synonyms for its underlying tables.

The package addresses two related business concerns. First, it validates Advanced Standing records — including basis year units or levels and transcript submissions — against the data held in the IGS Advanced Standing tables. Second, it provides the integration glue between Advanced Standing validation and the Oracle Workflow engine, including a procedure that sets the Workflow role for Advanced Standing processing. The header comment notes that the Workflow-related procedures were added as part of the RECR50 change, tracking Bug# 3270446, which is consistent with the recruitment and records feature set in the Oracle Student System.

Key Procedures and Functions

• advp_val_basis_year — A function that validates the basis year of advanced standing units or levels, accepting basis year, course code, and version number inputs and returning a boolean result along with message name and return type outputs.
• validate_transcript — A procedure that validates Advanced Standing records when a new transcript is submitted, operating against person, education, and transcript identifiers.
• wf_set_role — A procedure that sets the Advanced Standing Workflow role. This is the Workflow callback function invoked by the Workflow engine, taking the standard itemtype, itemkey, activity id, function mode, and result output parameters typical of Oracle Workflow role-setting activities. This procedure is the object matching the user search term "wf_set_role".
• create_transcript — A procedure that launches the Advanced Standing Workflow, accepting document id, display type, a CLOB document, and a document type, both passed as IN OUT NOCOPY parameters.
• get_transcript_data — A procedure that sets attribute values for Advanced Standing notifications, taking itemtype, itemkey, person id, education id, and transcript id parameters.

Tables Accessed

The package references the following tables through APPS synonyms: IGS_AD_TERM_DETAILS and IGS_AD_TERM_UNITDTLS (term and term unit detail information), IGS_AV_STD_ULVLBASIS_ALL and IGS_AV_STD_UNT_BASIS_ALL (advanced standing unit-level and unit basis records), IGS_AV_STND_ALT_UNIT, IGS_AV_STND_UNIT_ALL, and IGS_AV_STND_UNIT_LVL_ALL (advanced standing unit and unit-level definitions), and PLITBLM (the PL/SQL integer table type used for bulk collections). These tables supply the master and transactional data validated by advp_val_basis_year and validate_transcript, and the data used to populate Advanced Standing Workflow notification attributes.

Usage Notes

Because wf_set_role and get_transcript_data use the Workflow itemtype, itemkey, actid, and funcmode parameter signatures, they are designed to be invoked directly by the Oracle Workflow engine as activity function callbacks rather than by end users. The create_transcript procedure raises the Advanced Standing workflow from the transcript submission process; get_transcript_data then populates message attributes for the resulting notifications; and wf_set_role resolves and assigns the appropriate role. validate_transcript and advp_val_basis_year are called during transcript entry and advanced standing maintenance, typically from the Oracle Student System forms or from concurrent processing. The package is referenced by five other packages, indicating shared use across the IGS Advanced Standing and Records modules. Customizations should treat these procedures as internal integration points and prefer the sanctioned forms and self-service flows over direct invocation.