Search Results igs_ru_gen_001
Overview
IGS_RU_GEN_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API within the Student System (IGS) product family. The "RU" prefix designates the Rules Engine component of Oracle Student System, and the package operates as a supporting validation routine invoked by the broader rules-processing framework. Its business purpose is to evaluate student academic records against configurable institutional rules, supplying the validation logic that determines whether a student satisfies criteria defined in admissions, enrollment, progression, and graduation rule structures.
The package holds a VALID status in the database and is documented with a single exposed program unit, RULP_VAL_SENNA, indicating a narrowly scoped routine dedicated to a specific validation scenario rather than a broad public API. Deployment compatibility spans both Oracle EBS 12.1.1 and 12.2.2, where the same package definition is retained.
Key Procedures and Functions
The ETRM documentation records one program unit for this package:
- RULP_VAL_SENNA — The sole documented procedure or function. Based on the naming convention used throughout the IGS_RU_GEN_00x series, the "RULP_" prefix indicates a Rules Engine local procedure, and "VAL" denotes a validation operation. The routine is designed to evaluate rule criteria against student data and return a validation outcome to the calling rule processor. No parameter list is documented in the ETRM metadata, and the program unit should be treated as an internal validation routine rather than a directly callable public interface.
Tables Accessed
The package reads from a substantial set of Student System tables through APPS synonyms, reflecting its cross-functional validation role:
- Admissions tables — IGS_AD_CODE_CLASSES, IGS_AD_TEST_RESULTS, IGS_AD_TST_RSLT_DTLS, IGS_AD_UP_DETAIL, and IGS_AD_UP_HEADER provide admissions test scores, test result detail, and applicant/application data required for admission-based rule evaluation.
- Academic records — IGS_AS_SU_SETATMPT, IGS_AS_GRD_SCH_GRADE, and IGS_GR_AWD_CRMN supply subject attempt records, grade scheme values, and award credit minimums used in progression and graduation checks.
- Enrollment tables — IGS_EN_STDNT_PS_ATT_ALL and IGS_EN_UNIT_SET_RULE hold student program attempt data and unit set rule definitions.
- Calendar and structural tables — IGS_CA_INST_REL, IGS_CA_STAT, and IGS_CA_TYPE define calendar instance relationships, statuses, and types; IGS_PS_STAGE and IGS_FI_F_TYP_CA_INST_ALL provide program stage and fee type calendar instance data.
Usage Notes
IGS_RU_GEN_001 is not intended for direct invocation by end users or standalone custom code. It is referenced by thirteen other packages, including the rule validation packages IGS_RU_VAL_CRS_RULE, IGS_RU_VAL_UNIT_RULE, IGS_RU_VAL_USET_RULE, and IGS_RU_VAL_FDFR, as well as eligibility packages (IGS_EN_ELGBL_PERSON, IGS_EN_ELGBL_PROGRAM, IGS_EN_ELGBL_UNIT), the admissions request package IGS_AD_ADM_REQ, the class rank package IGS_PR_CLASS_RANK, the financial aid rule caller IGF_AP_RULE_CALL_PKG, and sibling generation packages IGS_RU_GEN_003 through IGS_RU_GEN_005. It also contains internal self-references.
This dependency pattern confirms the package functions as a shared, lower-level validation utility consumed by higher-level rule and eligibility engines. Invocation occurs during rule evaluation executed through Student System forms and concurrent rule-processing programs. Customizations should avoid modifying the package directly; instead, extensions should be routed through the documented calling packages, as changes here propagate to all thirteen dependent objects.
-
PACKAGE: APPS.IGS_RU_GEN_001
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_RU_GEN_001, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_GEN_001
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RU_GEN_001, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_VAL_USET_RULE
12.1.1
-
PACKAGE BODY: APPS.IGS_RU_VAL_CRS_RULE
12.1.1
-
PACKAGE BODY: APPS.IGF_AP_RULE_CALL_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_AP_RULE_CALL_PKG, status:VALID,
-
SYNONYM: APPS.IGS_RU_SET
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_RU_SET, status:VALID,
-
SYNONYM: APPS.IGS_RU_CALL_RULE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_RU_CALL_RULE, status:VALID,
-
SYNONYM: APPS.IGS_AD_UP_DETAIL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_UP_DETAIL, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_VAL_USET_RULE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RU_VAL_USET_RULE, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_VAL_CRS_RULE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RU_VAL_CRS_RULE, status:VALID,
-
SYNONYM: APPS.IGS_RU_SET_MEMBER
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_RU_SET_MEMBER, status:VALID,
-
SYNONYM: APPS.IGS_AD_UP_HEADER
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_UP_HEADER, status:VALID,
-
PACKAGE: APPS.IGS_AV_VAL_ASU
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AV_VAL_ASU, status:VALID,
-
SYNONYM: APPS.IGS_PS_STAGE_RU
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_STAGE_RU, status:VALID,
-
SYNONYM: APPS.IGS_EN_UNIT_SET_RULE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_EN_UNIT_SET_RULE, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_VAL_FDFR
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RU_VAL_FDFR, status:VALID,
-
SYNONYM: APPS.IGS_PS_VER_RU
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_VER_RU, status:VALID,
-
PACKAGE: APPS.IGS_PR_GEN_002
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PR_GEN_002, status:VALID,
-
SYNONYM: APPS.IGS_PS_UNIT_VER_RU
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_UNIT_VER_RU, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_GEN_004
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RU_GEN_004, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_GEN_005
12.1.1
-
PACKAGE: APPS.IGS_PS_GEN_002
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PS_GEN_002, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_VAL_UNIT_RULE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RU_VAL_UNIT_RULE, status:VALID,
-
SYNONYM: APPS.IGS_FI_F_TYP_CA_INST_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_F_TYP_CA_INST_ALL, status:VALID,
-
SYNONYM: APPS.IGS_PS_STAGE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_STAGE, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_GEN_003
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RU_GEN_003, status:VALID,
-
SYNONYM: APPS.IGS_RU_ITEM
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_RU_ITEM, status:VALID,
-
SYNONYM: APPS.IGS_RU_NAMED_RULE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_RU_NAMED_RULE, status:VALID,
-
SYNONYM: APPS.IGS_AD_TST_RSLT_DTLS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_TST_RSLT_DTLS, status:VALID,
-
PACKAGE: APPS.IGS_RU_GEN_003
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_RU_GEN_003, status:VALID,
-
SYNONYM: APPS.IGS_RU_RULE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_RU_RULE, status:VALID,
-
PACKAGE: APPS.IGS_AS_GEN_002
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_GEN_002, status:VALID,
-
PACKAGE BODY: APPS.IGS_EN_ELGBL_PERSON
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_ELGBL_PERSON, status:VALID,
-
PACKAGE: APPS.IGS_PR_CP_GPA
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PR_CP_GPA, status:VALID,
-
SYNONYM: APPS.IGS_GR_AWD_CRMN
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_GR_AWD_CRMN, status:VALID,
-
PACKAGE: APPS.IGS_GE_GEN_004
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_GEN_004, status:VALID,
-
PACKAGE: APPS.IGS_EN_GEN_001
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_001, status:VALID,
-
SYNONYM: APPS.IGS_AD_TEST_RESULTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_TEST_RESULTS, status:VALID,
-
PACKAGE BODY: APPS.IGS_PR_CLASS_RANK
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_PR_CLASS_RANK, status:VALID,
-
PACKAGE: APPS.IGS_PR_GET_CLASS_STD
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PR_GET_CLASS_STD, status:VALID,
-
VIEW: APPS.IGS_PS_UNIT_LEVEL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PS_UNIT_LEVEL, object_name:IGS_PS_UNIT_LEVEL, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_GEN_005
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RU_GEN_005, status:VALID,
-
PACKAGE BODY: APPS.IGS_AD_ADM_REQ
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AD_ADM_REQ, status:VALID,
-
PACKAGE BODY: APPS.IGS_RU_VAL_FDFR
12.1.1
-
PACKAGE BODY: APPS.IGS_EN_ELGBL_UNIT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_ELGBL_UNIT, status:VALID,
-
PACKAGE: APPS.IGS_EN_PRC_LOAD
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_PRC_LOAD, status:VALID,
-
SYNONYM: APPS.IGS_PS_USEC_CPS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_USEC_CPS, status:VALID,
-
PACKAGE BODY: APPS.IGS_EN_ELGBL_PROGRAM
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_ELGBL_PROGRAM, status:VALID,
-
PACKAGE: APPS.IGS_AS_GEN_003
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_GEN_003, status:VALID,
-
PACKAGE: APPS.IGS_RU_GEN_001
12.1.1