GOBDIRO GOBFNXR GOBSRVR GOBTPAC GORADRL GORDADD GORDPRF GOREMAL GORPAUD GORPPRM GORSRVR GORTCTL GTVDIRO GTVEMAL GUBSRVY GURSRVQ GURSVRL GURUPRF SPBPERS SPRADDR SPRIDEN STVATYP GOVSRVR SPBPERS link SPRIDEN link

Model Web Management


Model Label : Banner General Web Management
Path : Default Folder/B70/General/Web_Management

List of Objects

Object Name Object Type Layer Name
GOBDIRO TABLE Default
GOBFNXR TABLE Default
GOBSRVR TABLE Default
GOBTPAC TABLE Default
GORADRL TABLE Default
GORDADD TABLE Default
GORDPRF TABLE Default
GOREMAL TABLE Default
GORPAUD TABLE Default
GORPPRM TABLE Default
GORSRVR TABLE Default
GORTCTL TABLE Default
GOVSRVR VIEW Default
GTVDIRO TABLE Default
GTVEMAL TABLE Default
GUBSRVY TABLE Default
GURSRVQ TABLE Default
GURSVRL TABLE Default
GURUPRF TABLE Default
SPBPERS TABLE Default
SPBPERS link User Object Default
SPRADDR TABLE Default
SPRIDEN TABLE Default
SPRIDEN link User Object Default
STVATYP TABLE Default

Comments

Model View

''

Table GOBDIRO

Schema Name GENERAL
Label GOBDIRO
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBDIRO_DIRO_CODE GOBDIRO_DIRO_CODE VARCHAR2(8) No * *
GOBDIRO_DIRECTORY_TYPE GOBDIRO_DIRECTORY_TYPE VARCHAR2(1) No
GOBDIRO_ITEM_TYPE GOBDIRO_ITEM_TYPE VARCHAR2(1) No
GOBDIRO_DISP_PROFILE_IND GOBDIRO_DISP_PROFILE_IND VARCHAR2(1) No
GOBDIRO_UPD_PROFILE_IND GOBDIRO_UPD_PROFILE_IND VARCHAR2(1) No
GOBDIRO_NON_PROFILE_DEF_IND GOBDIRO_NON_PROFILE_DEF_IND VARCHAR2(1) No
GOBDIRO_SYSTEM_REQ_IND GOBDIRO_SYSTEM_REQ_IND VARCHAR2(1) No
GOBDIRO_ACTIVITY_DATE GOBDIRO_ACTIVITY_DATE DATE No
GOBDIRO_SEQ_NO GOBDIRO_SEQ_NO NUMBER(2,0) No

Foreign Key information

Column name is Foreign Key For Column on Table
GOBDIRO_DIRO_CODE GTVDIRO_CODE GTVDIRO

Index

Index Name Index Type Column Name
PK_GOBDIRO Unique GOBDIRO_DIRO_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
sel_gobdiro_list C/C++ Function [F:\BANNER\C\BWPREDIR.PC] Use(select )
sel_gobdiro_list C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
GOBDIRO SYNONYM S4B70.PUBLIC Rely on ()
GORDADD TABLE S4B70."GENERAL" Refer( No Action )
GORDPRF TABLE S4B70."GENERAL" Refer( No Action )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOADPRF.GORDPRF.GORDPRF_DIRO_CODE Rely on () Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GOADPRF.GORDPRF.GORDPRF_DIRO_CODE Rely on () Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVDIRO Use(delete )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVDIRO Use(delete )
PRE_DELETE Forms Trigger BANNER7_FORMS.GTVDIRO Use(delete )
PRE_DELETE Forms Trigger BANNER7_FORMS_10G.GTVDIRO Use(delete )
INSERT_MISSING_PREFS Forms Procedure BANNER7_FORMS.GOADPRF Rely on () Use(select )
INSERT_MISSING_PREFS Forms Procedure BANNER7_FORMS_10G.GOADPRF Rely on () Use(select )
DUPL_SEQ_NO Forms Function BANNER7_FORMS.GOADIRO Use(select )
DUPL_SEQ_NO Forms Function BANNER7_FORMS_10G.GOADIRO Use(select )
ITEM_CODE_EXISTS Forms Function BANNER7_FORMS.GOADIRO Use(select )
ITEM_CODE_EXISTS Forms Function BANNER7_FORMS_10G.GOADIRO Use(select )
GOBDIRO_REC Package variable S4B70.BANINST1.BWAKSRCH Rely on ()
GOBDIRO_REC Package variable S4B70.BANINST1.BWAKSRCH Rely on ()
GOBDIROC Package cursor S4B70.BANINST1.BWGKOPRF Use(select )
GOBDIRO_REC Package variable S4B70.BANINST1.BWGKOPRF Rely on ()
GOBDIRO_REC Package variable S4B70.BANINST1.BWGKOPRF Rely on ()
GOBDIROLISTC Package cursor S4B70.BANINST1.BWGKOPRF Rely on () Use(select )
GOBDIROREADC Package cursor S4B70.BANINST1.BWAKSRCH Rely on () Use(select )
GOBDIRO Forms DataBlock BANNER7_FORMS.GOADIRO Rely on () Use(insert,update,delete,select )
GOBDIRO Forms DataBlock BANNER7_FORMS_10G.GOADIRO Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GOBDIRO INDEX S4B70."GENERAL" Rely on ()
GTVDIRO TABLE S4B70."GENERAL" Refer( No Action )

Comments

Source Code Comments

Directory Options Rule Table

Columns Comments for GOBDIRO_DIRO_CODE (1)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GOBDIRO_DIRECTORY_TYPE (2)

Source Code Comments

DIRECTORY TYPE INDICATOR: Indicator to print in (S)tudent, (E)mployee, or (A)ll Directories.

Columns Comments for GOBDIRO_ITEM_TYPE (3)

Source Code Comments

DIRECTORY ITEM TYPE INDICATOR: Indicator for Item Type; (A)ddress, (T)elephone, or (N)ot Applicable.

Columns Comments for GOBDIRO_DISP_PROFILE_IND (4)

Source Code Comments

INCLUDE IN DIRECTORY INDICATOR: Indicator to display in Directory; (Y)es or (N)o.

Columns Comments for GOBDIRO_UPD_PROFILE_IND (5)

Source Code Comments

DISPLAY IN DIRECTORY INDICATOR: Indicator to allow User to choose to display in directory; (Y)es or (N)o.

Columns Comments for GOBDIRO_NON_PROFILE_DEF_IND (6)

Source Code Comments

DEFAULT INDICATOR: Indicator to default to directory for users without a directory profile; (Y)es or (N)o.

Columns Comments for GOBDIRO_SYSTEM_REQ_IND (7)

Source Code Comments

SYSTEM REQUIRED INDICATOR: System Required Indicator.

Columns Comments for GOBDIRO_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for GOBDIRO_SEQ_NO (9)

Source Code Comments

SEQUENCE NUMBER: Directory profile indicator.

Table GOBFNXR

Schema Name GENERAL
Label GOBFNXR
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBFNXR_FUNCTION GOBFNXR_FUNCTION VARCHAR2(30) No *
GOBFNXR_PACKAGE GOBFNXR_PACKAGE VARCHAR2(80) No *
GOBFNXR_SYS_REQ_IND GOBFNXR_SYS_REQ_IND VARCHAR2(1) No
GOBFNXR_ACTIVITY_DATE GOBFNXR_ACTIVITY_DATE DATE No
GOBFNXR_USER_ID GOBFNXR_USER_ID VARCHAR2(30) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GOBFNXR Unique GOBFNXR_PACKAGE
PK_GOBFNXR Unique GOBFNXR_FUNCTION

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOBFNXR SYNONYM S4B70.PUBLIC Rely on ()
POST-QUERY Forms Trigger BANNER7_FORMS.GOAFNXR.GOBFNXR Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.GOAFNXR.GOBFNXR Use(select )
GOBFNXRC Package cursor S4B70.BANINST1.VRGKOINT Rely on () Use(select )
GOBFNXR_REC Package variable S4B70.BANINST1.VRGKOINT Rely on ()
GOBFNXR_REC Package variable S4B70.BANINST1.VRGKOINT Rely on ()
P_VR_ACCT_REVIEW_BALANCE Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_ADD_CLASS Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_ADM_APPT_OPER_OPT Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_ADM_INFO_OPTION Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_ADM_MATERIALS_OPTION Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_ADM_ORIENTATION_OPT Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_ADM_REQUEST_OPTION Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_ALL_REQ_SPEAK_OPT Package procedure S4B70.BANINST1.VRRKRREQ Rely on ()
P_VR_APPLY_CC_PAYMENT Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_ASSESS_FEES Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_AUTODROP_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_AW_MULTI_OPT Package procedure S4B70.BANINST1.VRRKRAWD Rely on ()
P_VR_AW_SINGLE_OPT Package procedure S4B70.BANINST1.VRRKRAWD Rely on ()
P_VR_BIL_INFO_MENU_OPT Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_BIL_OPTIONS_MENU Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_BUILD_BAD_CC_MENU Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_BUILD_CC_MENU Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_BUILD_EXPIR_OPTIONS Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_BUILD_PAYMENT_OPTIONS Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_BUILD_ST_ACCOUNT_MENU Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_BYPASS_TERM_CHECKS Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_CHANGE_PIN Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_CHANGE_PIN_OPT Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_CHECK_CLAS_AVAIL Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_CHECK_GRADES Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_CHECK_HOLDS Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_CHECK_OPEN_SECTIONS Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_CHECK_OPEN_SECTIONS_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_CONFIRM_NEEDED_CHECK Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONFIRM_NEEDED_OPT Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONFIRM_REG Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONFIRM_REG_OPT Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CONTINUE_CONFIRM Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_CREDIT_HOURS_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_CRN_EXCEPTION Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_CRN_LIST Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_CRN_LIST_MULTI_OPT Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_CRN_LIST_OPT Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_DAY_TIME_OPT Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_DROP_CLASS Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_DROP_CLASS_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_END_CALL Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_END_GRADES Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_END_INFC_TABLE Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_EXCEPTION Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_FIN_INFO_OPTION Package procedure S4B70.BANINST1.VRRKRGNS Rely on ()
P_VR_FIN_MATERIALS_OPTION Package procedure S4B70.BANINST1.VRRKRGNS Rely on ()
P_VR_FIN_PROGRAM_OPTION Package procedure S4B70.BANINST1.VRRKRGNS Rely on ()
P_VR_FIN_REQUEST_OPTION Package procedure S4B70.BANINST1.VRRKRGNS Rely on ()
P_VR_GEN_GRDE_INFO Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_GET_AIDY_DATES Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_GET_APPL_STATUS Package procedure S4B70.BANINST1.VRRKRAWD Rely on ()
P_VR_GET_BILLING_DEADLN_DATES Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_GET_DAY_TIME Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_GET_DISBURSEMENTS Package procedure S4B70.BANINST1.VRRKRPMT Rely on ()
P_VR_GET_FIN_HOLDS Package procedure S4B70.BANINST1.VRRKRGNS Rely on ()
P_VR_GET_LOAN_INFO Package procedure S4B70.BANINST1.VRRKRLAP Rely on ()
P_VR_GET_MENU Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_GET_OFFER_INFO Package procedure S4B70.BANINST1.VRRKRAWD Rely on ()
P_VR_GET_PROGRESS_DATA Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_GET_TERM_DATES Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_GIVE_DECISION Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_GIVE_STATUS Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_GRADE_MODE_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_GRDE_INFO_OPT Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_GRDE_MENU_OPT Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_GRDE_OPT Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_HOLD_OPER_OPT Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_HOLD_OPT Package procedure S4B70.BANINST1.VRRKRGNS Rely on ()
P_VR_INIT_INFC_TABLE Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_LIKE_TO_REG_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_LIST_AWARDS Package procedure S4B70.BANINST1.VRRKRAWD Rely on ()
P_VR_LIST_CLASSES Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_LIST_CURRENT_CLASSES Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_LIST_GRADES Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_LIST_MORE_AWARDS Package procedure S4B70.BANINST1.VRRKRAWD Rely on ()
P_VR_MAIN_MENU_RETURN Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_MAX_TRIES_EXCEEDED Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_MENU_OPTION Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_MORE_DISBURSEMENTS Package procedure S4B70.BANINST1.VRRKRPMT Rely on ()
P_VR_MORE_REQMNTS Package procedure S4B70.BANINST1.VRRKRREQ Rely on ()
P_VR_MULTI_TERMS Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_NOAPP_OPT Package procedure S4B70.BANINST1.VRRKRREQ Rely on ()
P_VR_NO_APPLICATION Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_NO_HOLD_OPT Package procedure S4B70.BANINST1.VRRKRGNS Rely on ()
P_VR_PMPT_ST_BILLING_OPTIONS Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_PROCESS_ADM_APPL Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_PROCESS_ANOTHER_APPL Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_PROCESS_BAD_AMT_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_BAD_CC_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_BAD_CC_STATUS Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_BAD_EXPDATE Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_BAD_EXPDATE_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_BILLING_OPTIONS Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_PROCESS_CC_NUMBER_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_CC_STATUS Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_CC_TYPE Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_DETAIL_OPTIONS Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_PROCESS_DIFF_AMOUNT_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_EXPIR_OPTIONS Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_EXP_DATE_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_GOOD_AMT_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_GOOD_CC_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_MISSING_REQMNTS Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_PROCESS_MORE_REQ Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_PROCESS_MULTI_CC_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_MULT_TERMS Package procedure S4B70.BANINST1.VRRKRPMT Rely on ()
P_VR_PROCESS_NEW_AMT_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_OFFER_OPT Package procedure S4B70.BANINST1.VRRKRAWD Rely on ()
P_VR_PROCESS_OPTIONS Package procedure S4B70.BANINST1.VRRKRAWD Rely on ()
P_VR_PROCESS_REQMNTS Package procedure S4B70.BANINST1.VRRKRREQ Rely on ()
P_VR_PROCESS_REVIEW_OPTIONS Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_PROCESS_SINGLE_CC_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCESS_TOTAL_AMT_OPT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROCES_NONSTU_DET_OPT Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_PROC_ST_ADM_APPL Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_PROMPT_ANOTHER_APPL Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_PROMPT_BILLING_OPTIONS Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_PROMPT_CC_NUMBER Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROMPT_DIFF_AMT Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROMPT_EXP_DATE Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_PROMPT_MISSING_REQMNTS Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_PROMPT_MORE_REQMNTS Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_REBUILD_CURRENT_MENU Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_REG_APPL_MENU_OPT Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_REG_APPL_MENU_OPT_CONT Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_REG_CLASS_MENU_OPT Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_REG_DATA_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_REG_INFO_OPTION Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_REG_TERM_ELIGIBLE Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_RESULT_OPT Package procedure S4B70.BANINST1.VRRKRREQ Rely on ()
P_VR_REVIEW_CHRGS_AND_PYMNTS Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_REVIEW_DETAIL_MENU Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_REVIEW_INSTL_PMNT Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_REVIEW_MORE_CHPY Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_REVIEW_MORE_INSTL Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_REVIEW_NONSTU_BALANCE Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_REVIEW_NONSTU_DETAIL_MENU Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_REV_AND_SPK_ACCT_MENU Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_REV_NONSTU_CHRG_AND_PMNT Package procedure S4B70.BANINST1.VRTKSBIL Rely on ()
P_VR_SCHED_DAY_OPT Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_SELECT_ANOTHER_APPL Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_SELECT_APPLICATION Package procedure S4B70.BANINST1.VRSKAADM Rely on ()
P_VR_SINGLE_TERM Package procedure S4B70.BANINST1.VRRKRPMT Rely on ()
P_VR_SINGLE_TERM Package procedure S4B70.BANINST1.VRHKGRDS Rely on ()
P_VR_SPEAK_REQMNTS Package procedure S4B70.BANINST1.VRRKRREQ Rely on ()
P_VR_START_DATE_OPT Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_SYSTEM_PROBLEM Package procedure S4B70.BANINST1.VRGKOCTL Rely on ()
P_VR_TERM_OPTION Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
P_VR_VALIDATE_ALT_PIN Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_VALIDATE_BIRTH_DATE Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_VALIDATE_ID Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_VALIDATE_PIN Package procedure S4B70.BANINST1.VRSKPVAL Rely on ()
P_VR_VERIFY_CREDIT_CARD Package procedure S4B70.BANINST1.VRTKSPAY Rely on ()
P_VR_VERIFY_DROP Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_VERIFY_START_DATE_OPT Package procedure S4B70.BANINST1.VRSKFOLR Rely on ()
P_VR_WAITLIST_OPT Package procedure S4B70.BANINST1.VRSKFREG Rely on ()
P_VR_WITHDRAW_FROM_TERM Package procedure S4B70.BANINST1.VRSKFORG Rely on ()
GOBFNXR_ROW_BY_FUNC_C Package cursor S4B70.BANINST1.GOKSELS Rely on ()
GOBFNXR_ROW_BY_FUNC_C Package cursor S4B70.BANINST1.GOKSELS Rely on () Use(select )
GOBFNXR_ROW_BY_PKG_FUNC_C Package cursor S4B70.BANINST1.GOKSELS Rely on ()
GOBFNXR_ROW_BY_PKG_FUNC_C Package cursor S4B70.BANINST1.GOKSELS Rely on () Use(select )
F_GET_COMMAND Package function S4B70.BANINST1.GOKSELS Rely on ()
F_GET_COMMAND Package function S4B70.BANINST1.GOKSELS Rely on ()
F_GET_GOBFNXR_REC Package function S4B70.BANINST1.GOKSELS Rely on ()
F_GET_GOBFNXR_REC Package function S4B70.BANINST1.GOKSELS Rely on ()
F_GET_PROC Package function S4B70.BANINST1.GOKSELS Rely on ()
F_GET_PROCESS Package function S4B70.BANINST1.GOKSELS Rely on ()
F_GET_PROCESS Package function S4B70.BANINST1.GOKSELS Rely on ()
F_VR_GET_NEXT_TRANS Package function S4B70.BANINST1.VRGKOCTL Rely on ()
F_VR_GET_NEXT_TRANS Package function S4B70.BANINST1.VRGKOCTL Rely on ()
GOBFNXR Forms DataBlock BANNER7_FORMS.GOAFNXR Rely on () Use(insert,update,delete,select )
GOBFNXR Forms DataBlock BANNER7_FORMS_10G.GOAFNXR Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GOBFNXR INDEX S4B70."GENERAL" Rely on ()

Comments

Source Code Comments

Third-Party Function Calls Table.

Columns Comments for GOBFNXR_FUNCTION (1)

Source Code Comments

Function or transaction label associated with the package and procedure e.g. MAIN_MENU, REG_MENU, FIN_MENU.

Columns Comments for GOBFNXR_PACKAGE (2)

Source Code Comments

Name of package and procedure associated with function.

Columns Comments for GOBFNXR_SYS_REQ_IND (3)

Source Code Comments

System Required Indicator. Indicates whether the record is required by the SCT system.

Columns Comments for GOBFNXR_ACTIVITY_DATE (4)

Source Code Comments

Date on which the record was last updated or created.

Columns Comments for GOBFNXR_USER_ID (5)

Source Code Comments

The user id of the person who updates this record.

Table GOBSRVR

Schema Name GENERAL
Label GOBSRVR
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBSRVR_PIDM GOBSRVR_PIDM NUMBER(8,0) No *
GOBSRVR_NAME GOBSRVR_NAME VARCHAR2(15) No *
GOBSRVR_ACTIVITY_DATE GOBSRVR_ACTIVITY_DATE DATE No
GOBSRVR_USER GOBSRVR_USER VARCHAR2(30) No
GOBSRVR_DECLINED_IND GOBSRVR_DECLINED_IND VARCHAR2(1) No
GOBSRVR_COMPLETE_IND GOBSRVR_COMPLETE_IND VARCHAR2(1) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GOBSRVR Unique GOBSRVR_PIDM
PK_GOBSRVR Unique GOBSRVR_NAME

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOBSRVR SYNONYM S4B70.PUBLIC Rely on ()
GORSRVR TABLE S4B70."GENERAL" Refer( No Action )
SPRIDEN TABLE S4B70.SATURN Join
GOVSRVR VIEW S4B70.BANINST1 Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.GUISRVS.GUBSRVY Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.GUISRVS.GUBSRVY Use(select )
GOBSRVR_REC Package variable S4B70.BANINST1.BWGKSRVY Rely on ()
GOBSRVR_REC Package variable S4B70.BANINST1.BWGKSRVY Rely on ()
P_MODIFYRESPONSEHEAD Package procedure S4B70.BANINST1.BWGKSRVY Use(insert,update )
GOBSRVRREADC Package cursor S4B70.BANINST1.BWGKSRVY Rely on () Use(select )
GOBSRVR Forms DataBlock BANNER7_FORMS.GOISRVY Rely on () Use(select )
GOBSRVR Forms DataBlock BANNER7_FORMS_10G.GOISRVY Rely on () Use(select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GOBSRVR INDEX S4B70."GENERAL" Rely on ()

Comments

Source Code Comments

Survey Response Header Table. This table contains one row for each person who responds to the survey.

Columns Comments for GOBSRVR_PIDM (1)

Source Code Comments

Internal Identification Number of the person who responded to the survey.

Columns Comments for GOBSRVR_NAME (2)

Source Code Comments

Survey Name.

Columns Comments for GOBSRVR_ACTIVITY_DATE (3)

Source Code Comments

The date that the person last responded to the survey.

Columns Comments for GOBSRVR_USER (4)

Source Code Comments

The User ID(Oracle) of the person who responded to the survey.

Columns Comments for GOBSRVR_DECLINED_IND (5)

Source Code Comments

Declined Indicator. Y = user declined to answer the survey.

Columns Comments for GOBSRVR_COMPLETE_IND (6)

Source Code Comments

Complete Indicator. Y indicates complete, N indicates incomplete.

Table GOBTPAC

Schema Name GENERAL
Label GOBTPAC
Server name S4B70
Creation Date 09/23/2004 00:25:28:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBTPAC_PIDM GOBTPAC_PIDM NUMBER(8,0) No *
GOBTPAC_PIN_DISABLED_IND GOBTPAC_PIN_DISABLED_IND VARCHAR2(1) No
GOBTPAC_USAGE_ACCEPT_IND GOBTPAC_USAGE_ACCEPT_IND VARCHAR2(1) No
GOBTPAC_ACTIVITY_DATE GOBTPAC_ACTIVITY_DATE DATE No
GOBTPAC_USER GOBTPAC_USER VARCHAR2(30) No
GOBTPAC_PIN GOBTPAC_PIN VARCHAR2(6) Yes
GOBTPAC_PIN_EXP_DATE GOBTPAC_PIN_EXP_DATE DATE Yes
GOBTPAC_EXTERNAL_USER GOBTPAC_EXTERNAL_USER VARCHAR2(30) Yes
GOBTPAC_QUESTION GOBTPAC_QUESTION VARCHAR2(90) Yes
GOBTPAC_RESPONSE GOBTPAC_RESPONSE VARCHAR2(30) Yes
GOBTPAC_INSERT_SOURCE GOBTPAC_INSERT_SOURCE VARCHAR2(8) Yes
GOBTPAC_LDAP_USER GOBTPAC_LDAP_USER VARCHAR2(255) Yes
GOBTPAC_DATA_ORIGIN GOBTPAC_DATA_ORIGIN VARCHAR2(30) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
GOBTPAC_KEY_INDEX Unique GOBTPAC_EXTERNAL_USER
PK_GOBTPAC Unique GOBTPAC_PIDM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
employee C/C++ Function [F:\BANNER\C\PORPOFL.PC] Use(select )
get_glbextr_key C/C++ Function [F:\BANNER\C\ICGORGMK.PC] Use(select )
get_userid C/C++ Function [F:\BANNER\C\ICGORLDI.PC] Use(select )
printRole C/C++ Function [F:\BANNER\C\APPAOFL.PC] Use(select )
printUserData C/C++ Function [F:\BANNER\C\APPAOFL.PC] Use(select )
select_student_pin C/C++ Function [F:\BANNER\C\IRRKTRK.PC] Use(select )
validate_pin C/C++ Function [F:\BANNER\C\IRRKAWD.PC] Use(select )
validate_pin C/C++ Function [F:\BANNER\C\IRRKTRN.PC] Use(select )
validate_pin C/C++ Function [F:\BANNER\C\ISRKADM.PC] Use(select )
validate_pin C/C++ Function [F:\BANNER\C\ISRKBIL.PC] Use(select )
validate_pin C/C++ Function [F:\BANNER\C\ISRKSCH.PC] Use(select )
validate_pin C/C++ Function [F:\BANNER\C\ISRKGRD.PC] Use(select )
validate_scrn_student_pin C/C++ Function [F:\BANNER\C\ISRKTRN.PC] Use(select )
writeDeletableEnrolled C/C++ Function [F:\BANNER\C\ICSORIMS.PC] Use(select )
writeEnrolled C/C++ Function [F:\BANNER\C\ICSORIMS.PC] Use(select )
writeInstruct C/C++ Function [F:\BANNER\C\ICSORIMS.PC] Use(select )
writeUser C/C++ Function [F:\BANNER\C\ICSORIMS.PC] Use(select )
write_enrolled C/C++ Function [F:\BANNER\C\ICSORSPF.PC] Use(select )
write_major C/C++ Function [F:\BANNER\C\ICSORSPF.PC] Use(select )
write_user C/C++ Function [F:\BANNER\C\ICSORODM.PC] Use(select )
write_user C/C++ Function [F:\BANNER\C\ICSORSPF.PC] Use(select )
GOBTPAC SYNONYM S4B70.PUBLIC Rely on ()
GT_GOBTPAC_AR_LDI TRIGGER S4B70."GENERAL" Rely on ()
WHEN-LIST-CHANGED Forms Trigger BANNER7_FORMS.GUAPPRF.GUBPPRF.GUBPPRF_FORMAT Use(select )
WHEN-LIST-CHANGED Forms Trigger BANNER7_FORMS_10G.GUAPPRF.GUBPPRF.GUBPPRF_FORMAT Use(select )
ON-INSERT Forms Trigger BANNER7_FORMS.GOATPAC.GOBTPAC Rely on ()
ON-INSERT Forms Trigger BANNER7_FORMS_10G.GOATPAC.GOBTPAC Rely on ()
CREATE_CONSTITUENT Forms Procedure BANNER7_FORMS.APAWPRS Rely on ()
CREATE_CONSTITUENT Forms Procedure BANNER7_FORMS_10G.APAWPRS Rely on ()
UPDATE_CONSTITUENT Forms Procedure BANNER7_FORMS.APAWPRS Rely on () Use(select )
UPDATE_CONSTITUENT Forms Procedure BANNER7_FORMS_10G.APAWPRS Rely on () Use(select )
CHECK_PRESENT_ID Forms Function BANNER7_FORMS.GOATPAD Rely on () Use(select )
CHECK_PRESENT_ID Forms Function BANNER7_FORMS_10G.GOATPAD Rely on () Use(select )
PERSON_REC_TYPE Package Type S4B70.BANINST1.ICSPKCOM Rely on ()
THIRD_PARTY_ACCESS_REC Package Type S4B70.BANINST1.GB_THIRD_PARTY_ACCESS Rely on ()
TPAC_REC Package Type S4B70.BANINST1.GB_TPAC Rely on ()
P_AUTHENTICATE_BANNER Package procedure S4B70.WTAILOR.TWBKLOGN Rely on ()
P_AUTHENTICATE_BANNER Package procedure S4B70.WTAILOR.TWBKLOGN Rely on ()
P_AUTHENTICATE_LDAP Package procedure S4B70.WTAILOR.TWBKLOGN Rely on ()
P_AUTHENTICATE_LDAP Package procedure S4B70.WTAILOR.TWBKLOGN Rely on () Use(insert )
P_INSERT_GOBSRID_REC Package procedure S4B70.BANINST1.GB_THIRD_PARTY_ACCESS Rely on ()
P_INSERT_GORPAUD_REC Package procedure S4B70.BANINST1.GB_THIRD_PARTY_ACCESS Rely on ()
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.GB_TPAC Rely on ()
P_OVERLAY_VALIDATION_REC Package procedure