APBWIDN GOREMAL GTVEMAL ROTEMAL SARADAP SARWAPP SPBPERS SRBWPRO SRTEMAL SARADAP links SPBPERS link

Model E-mail View and Update


Model Label : Web General E-mail View and Update
Path : Default Folder/B70/Web General/E-mail_View_and_Update

List of Objects

Object Name Object Type Layer Name
APBWIDN TABLE Default
GOREMAL TABLE Default
GTVEMAL TABLE Default
ROTEMAL TABLE Default
SARADAP TABLE Default
SARADAP links User Object Default
SARWAPP TABLE Default
SPBPERS TABLE Default
SPBPERS link User Object Default
SRBWPRO TABLE Default
SRTEMAL TABLE Default

Comments

Model View

''

Table APBWIDN

Schema Name ALUMNI
Label APBWIDN
Server name S4B70
Creation Date 09/29/2003 12:12:53:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APBWIDN_ID APBWIDN_ID VARCHAR2(9) No *
APBWIDN_PIN APBWIDN_PIN VARCHAR2(6) No
APBWIDN_ACTIVITY_DATE APBWIDN_ACTIVITY_DATE DATE No
APBWIDN_USER APBWIDN_USER VARCHAR2(30) No
APBWIDN_ACCEPTED_IND APBWIDN_ACCEPTED_IND VARCHAR2(1) No
APBWIDN_QUESTION APBWIDN_QUESTION VARCHAR2(90) Yes
APBWIDN_ANSWER APBWIDN_ANSWER VARCHAR2(30) Yes
APBWIDN_PIDM APBWIDN_PIDM NUMBER(8,0) Yes
APBWIDN_LAST_NAME APBWIDN_LAST_NAME VARCHAR2(60) Yes
APBWIDN_FIRST_NAME APBWIDN_FIRST_NAME VARCHAR2(15) Yes
APBWIDN_MI APBWIDN_MI VARCHAR2(15) Yes
APBWIDN_MAIDEN_NAME APBWIDN_MAIDEN_NAME VARCHAR2(60) Yes
APBWIDN_NAME_PREFIX APBWIDN_NAME_PREFIX VARCHAR2(20) Yes
APBWIDN_NAME_SUFFIX APBWIDN_NAME_SUFFIX VARCHAR2(20) Yes
APBWIDN_BIRTH_DATE APBWIDN_BIRTH_DATE DATE Yes
APBWIDN_SEX APBWIDN_SEX VARCHAR2(1) Yes
APBWIDN_ATYP_CODE APBWIDN_ATYP_CODE VARCHAR2(2) Yes *
APBWIDN_STREET_LINE1 APBWIDN_STREET_LINE1 VARCHAR2(30) Yes
APBWIDN_STREET_LINE2 APBWIDN_STREET_LINE2 VARCHAR2(30) Yes
APBWIDN_STREET_LINE3 APBWIDN_STREET_LINE3 VARCHAR2(30) Yes
APBWIDN_CITY APBWIDN_CITY VARCHAR2(20) Yes
APBWIDN_STAT_CODE APBWIDN_STAT_CODE VARCHAR2(3) Yes *
APBWIDN_ZIP APBWIDN_ZIP VARCHAR2(10) Yes
APBWIDN_CNTY_CODE APBWIDN_CNTY_CODE VARCHAR2(5) Yes *
APBWIDN_NATN_CODE APBWIDN_NATN_CODE VARCHAR2(5) Yes *
APBWIDN_TELE_CODE APBWIDN_TELE_CODE VARCHAR2(4) Yes *
APBWIDN_PHONE_AREA APBWIDN_PHONE_AREA VARCHAR2(3) Yes
APBWIDN_PHONE_NUMBER APBWIDN_PHONE_NUMBER VARCHAR2(7) Yes
APBWIDN_PHONE_EXT APBWIDN_PHONE_EXT VARCHAR2(4) Yes
APBWIDN_INTL_ACCESS APBWIDN_INTL_ACCESS VARCHAR2(16) Yes
APBWIDN_UNLIST_IND APBWIDN_UNLIST_IND VARCHAR2(1) Yes
APBWIDN_FAX_TELE_CODE APBWIDN_FAX_TELE_CODE VARCHAR2(4) Yes *
APBWIDN_FAX_AREA APBWIDN_FAX_AREA VARCHAR2(3) Yes
APBWIDN_FAX_NUMBER APBWIDN_FAX_NUMBER VARCHAR2(7) Yes
APBWIDN_FAX_INTL_ACCESS APBWIDN_FAX_INTL_ACCESS VARCHAR2(16) Yes
APBWIDN_FAX_UNLIST_IND APBWIDN_FAX_UNLIST_IND VARCHAR2(1) Yes
APBWIDN_EMAIL_ADDRESS APBWIDN_EMAIL_ADDRESS VARCHAR2(90) Yes
APBWIDN_EMAL_CODE APBWIDN_EMAL_CODE VARCHAR2(4) Yes *
APBWIDN_SPS_LAST_NAME APBWIDN_SPS_LAST_NAME VARCHAR2(60) Yes
APBWIDN_SPS_FIRST_NAME APBWIDN_SPS_FIRST_NAME VARCHAR2(15) Yes
APBWIDN_SPS_MI APBWIDN_SPS_MI VARCHAR2(15) Yes
APBWIDN_PREF_CLAS APBWIDN_PREF_CLAS VARCHAR2(4) Yes
APBWIDN_PREF_COLL APBWIDN_PREF_COLL VARCHAR2(2) Yes
APBWIDN_DONR_CODE APBWIDN_DONR_CODE VARCHAR2(4) Yes *
APBWIDN_LAST_LOGIN_DATE APBWIDN_LAST_LOGIN_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
APBWIDN_EMAL_CODE GTVEMAL_CODE GTVEMAL
APBWIDN_DONR_CODE ATVDONR_CODE ATVDONR
APBWIDN_ATYP_CODE STVATYP_CODE STVATYP
APBWIDN_CNTY_CODE STVCNTY_CODE STVCNTY
APBWIDN_NATN_CODE STVNATN_CODE STVNATN
APBWIDN_STAT_CODE STVSTAT_CODE STVSTAT
APBWIDN_TELE_CODE STVTELE_CODE STVTELE
APBWIDN_FAX_TELE_CODE STVTELE_CODE STVTELE

Index

Index Name Index Type Column Name
PK_APBWIDN Unique APBWIDN_ID

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
APBWIDN SYNONYM S4B70.PUBLIC Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.APAWPRS.KEY_BLOCK.ID Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.AGAWGIF.KEY_BLOCK.ID Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.APAWPRS.KEY_BLOCK.ID Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.APAWPRS.KEY_BLOCK.ID Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.APAWPRS.KEY_BLOCK.ID Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.AGAWGIF.KEY_BLOCK.ID Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.AGAWGIF.KEY_BLOCK.ID Use(select )
MNU_OPT_FRM_AGAWGIF Forms Trigger BANNER7_FORMS.APAWPRS Use(select )
MNU_OPT_FRM_AGAWGIF Forms Trigger BANNER7_FORMS_10G.APAWPRS Use(select )
APBWIDN_RG Forms Record Group BANNER7_FORMS.AGAWGIF Use(select )
APBWIDN_RG Forms Record Group BANNER7_FORMS_10G.AGAWGIF Use(select )
APBWIDN_RG Forms Record Group BANNER7_FORMS.APAWPRS Use(select )
APBWIDN_RG Forms Record Group BANNER7_FORMS_10G.APAWPRS Use(select )
CREATE_GIFTS Forms Procedure BANNER7_FORMS.AGAWGIF Use(delete )
CREATE_GIFTS Forms Procedure BANNER7_FORMS_10G.AGAWGIF Use(delete )
APBWIDN_REC Package variable S4B70.BANINST1.BWAKALOG Rely on ()
APBWIDN_REC Package variable S4B70.BANINST1.BWAKALOG Rely on ()
P_DISPFORGOTPIN Package procedure S4B70.BANINST1.BWAKALOG Rely on ()
P_UPDATEADVIDNON Package procedure S4B70.BANINST1.BWAKALOG Use(update )
P_VALIDATEQUESTIONANSWER Package procedure S4B70.BANINST1.BWAKALOG Use(update )
APBWIDNVIEWC Package cursor S4B70.BANINST1.BWAKNGFT Use(select )
GETAPBWIDNBYPIDMC Package cursor S4B70.BANINST1.BWAKALOG Use(select )
GETAPBWIDNC Package cursor S4B70.BANINST1.BWAKALOG Use(select )
AIDM Package variable S4B70.BANINST1.BWAKNGFT Rely on ()
APBWIDN_REC Package variable S4B70.BANINST1.BWAKNGFT Rely on ()
APBWIDN_REC Package variable S4B70.BANINST1.BWAKNGFT Rely on ()
HOLD_AIDM Package variable S4B70.BANINST1.BWAKALOG Rely on ()
PIDM Package variable S4B70.BANINST1.BWAKNGFT Rely on ()
P_DISPLOGOUTNON Package procedure S4B70.BANINST1.BWAKALOG Use(update )
P_PROCFORCEPINCHANGE Package procedure S4B70.BANINST1.BWAKALOG Use(update )
P_PROCFORGOTPIN Package procedure S4B70.BANINST1.BWAKALOG Rely on ()
P_PROCLOGINNON Package procedure S4B70.BANINST1.BWAKALOG Rely on ()
P_PROCLOGINNON Package procedure S4B70.BANINST1.BWAKALOG Use(insert )
P_PROCPERSINFO Package procedure S4B70.BANINST1.BWAKALOG Use(update )
P_PROCPINCHANGE Package procedure S4B70.BANINST1.BWAKALOG Use(update )
P_PROCPININVALID Package procedure S4B70.BANINST1.BWAKALOG Use(update )
P_PROCPINVERIFYEXIST Package procedure S4B70.BANINST1.BWAKALOG Use(update )
P_PROCPINVERIFYNEW Package procedure S4B70.BANINST1.BWAKALOG Use(delete )
APBWIDN Forms DataBlock BANNER7_FORMS.APAWPRS Rely on () Use(update,delete,select )
APBWIDN Forms DataBlock BANNER7_FORMS_10G.APAWPRS Rely on () Use(update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_APBWIDN INDEX S4B70.ALUMNI Rely on ()
ATVDONR TABLE S4B70.ALUMNI Refer( No Action )
GTVEMAL TABLE S4B70."GENERAL" Refer( No Action )
STVATYP TABLE S4B70.SATURN Refer( No Action )
STVCNTY TABLE S4B70.SATURN Refer( No Action )
STVNATN TABLE S4B70.SATURN Refer( No Action )
STVSTAT TABLE S4B70.SATURN Refer( No Action )
STVTELE TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Web Access Base Record Hold Table.

Columns Comments for APBWIDN_ID (1)

Source Code Comments

Web ID created by a user not found in Banner.

Columns Comments for APBWIDN_PIN (2)

Source Code Comments

Personal Identification Number selected by the Web user.

Columns Comments for APBWIDN_ACTIVITY_DATE (3)

Source Code Comments

Date record created or updated.

Columns Comments for APBWIDN_USER (4)

Source Code Comments

User who created or changed the record.

Columns Comments for APBWIDN_ACCEPTED_IND (5)

Source Code Comments

Accepted Indicator, Y = Accepted, N = not Accepted.

Columns Comments for APBWIDN_QUESTION (6)

Source Code Comments

Security Question created by user with no Banner PIDM.

Columns Comments for APBWIDN_ANSWER (7)

Source Code Comments

Answer to Security Question created by user with no Banner PIDM.

Columns Comments for APBWIDN_PIDM (8)

Source Code Comments

Internal ID of person in Banner.

Columns Comments for APBWIDN_LAST_NAME (9)

Source Code Comments

Last Name of user with no Banner PIDM.

Columns Comments for APBWIDN_FIRST_NAME (10)

Source Code Comments

First Name of user with no Banner PIDM.

Columns Comments for APBWIDN_MI (11)

Source Code Comments

Middle Name of user with no Banner PIDM.

Columns Comments for APBWIDN_MAIDEN_NAME (12)

Source Code Comments

Maiden Name of user with no Banner PIDM.

Columns Comments for APBWIDN_NAME_PREFIX (13)

Source Code Comments

Name prefix of user with no Banner PIDM.

Columns Comments for APBWIDN_NAME_SUFFIX (14)

Source Code Comments

Name suffix of user with no Banner PIDM.

Columns Comments for APBWIDN_BIRTH_DATE (15)

Source Code Comments

Birth Date of user with no Banner PIDM.

Columns Comments for APBWIDN_SEX (16)

Source Code Comments

Gender of user with no Banner PIDM.

Columns Comments for APBWIDN_ATYP_CODE (17)

Source Code Comments

Address Type of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE1 (18)

Source Code Comments

Street Line 1 of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE2 (19)

Source Code Comments

Street Line 2 of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE3 (20)

Source Code Comments

Street Line 3 of user with no Banner PIDM.

Columns Comments for APBWIDN_CITY (21)

Source Code Comments

Address City of user with no Banner PIDM.

Columns Comments for APBWIDN_STAT_CODE (22)

Source Code Comments

Address State of user with no Banner PIDM.

Columns Comments for APBWIDN_ZIP (23)

Source Code Comments

Address Zip/Postal Code of user with no Banner PIDM.

Columns Comments for APBWIDN_CNTY_CODE (24)

Source Code Comments

Address County of user with no Banner PIDM.

Columns Comments for APBWIDN_NATN_CODE (25)

Source Code Comments

Address Nation of user with no Banner PIDM.

Columns Comments for APBWIDN_TELE_CODE (26)

Source Code Comments

Telephone Type of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_AREA (27)

Source Code Comments

Phone Number Area Code of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_NUMBER (28)

Source Code Comments

Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_EXT (29)

Source Code Comments

Phone Number Extension of user with no Banner PIDM.

Columns Comments for APBWIDN_INTL_ACCESS (30)

Source Code Comments

Internation Access Code of Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_UNLIST_IND (31)

Source Code Comments

Unlisted Indicator of Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_TELE_CODE (32)

Source Code Comments

FAX Telephone Type of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_AREA (33)

Source Code Comments

FAX Area Code of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_NUMBER (34)

Source Code Comments

FAX Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_INTL_ACCESS (35)

Source Code Comments

Internation Access Code of Fax Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_UNLIST_IND (36)

Source Code Comments

Unlisted Indicator of Fax Number of user with no Banner PIDM.

Columns Comments for APBWIDN_EMAIL_ADDRESS (37)

Source Code Comments

Email Address of user with no Banner PIDM.

Columns Comments for APBWIDN_EMAL_CODE (38)

Source Code Comments

Email Code of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_LAST_NAME (39)

Source Code Comments

Spouse Last Name of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_FIRST_NAME (40)

Source Code Comments

Spouse First Name of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_MI (41)

Source Code Comments

Spouse Middle Name of user with no Banner PIDM.

Columns Comments for APBWIDN_PREF_CLAS (42)

Source Code Comments

Preferred class of user with no Banner PIDM.

Columns Comments for APBWIDN_DONR_CODE (44)

Source Code Comments

Donor Code of user with no Banner PIDM.

Columns Comments for APBWIDN_LAST_LOGIN_DATE (45)

Source Code Comments

Date user with no Banner PIDM last logged into the web.

Table GOREMAL

Schema Name GENERAL
Label GOREMAL
Server name S4B70
Creation Date 09/22/2004 12:27:27:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREMAL_PIDM GOREMAL_PIDM NUMBER(8,0) No *
GOREMAL_EMAL_CODE GOREMAL_EMAL_CODE VARCHAR2(4) No * *
GOREMAL_EMAIL_ADDRESS GOREMAL_EMAIL_ADDRESS VARCHAR2(90) No *
GOREMAL_STATUS_IND GOREMAL_STATUS_IND VARCHAR2(1) No
GOREMAL_PREFERRED_IND GOREMAL_PREFERRED_IND VARCHAR2(1) No
GOREMAL_ACTIVITY_DATE GOREMAL_ACTIVITY_DATE DATE No
GOREMAL_USER_ID GOREMAL_USER_ID VARCHAR2(30) No
GOREMAL_COMMENT GOREMAL_COMMENT VARCHAR2(60) Yes
GOREMAL_DISP_WEB_IND GOREMAL_DISP_WEB_IND VARCHAR2(1) No
GOREMAL_DATA_ORIGIN GOREMAL_DATA_ORIGIN VARCHAR2(30) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GOREMAL_EMAL_CODE GTVEMAL_CODE GTVEMAL

Index

Index Name Index Type Column Name
PK_GOREMAL Unique GOREMAL_PIDM
PK_GOREMAL Unique GOREMAL_EMAL_CODE
PK_GOREMAL Unique GOREMAL_EMAIL_ADDRESS

Calling objects (non escalated)

<
Object Name Object Type Parent Name Link Type
load_into_tab C/C++ Function [F:\BANNER\C\APPCUPD.PC] Use()
check_emal_updt C/C++ Function [F:\BANNER\C\SAPAMAL.PC] Use(select )
check_pref_ind C/C++ Function [F:\BANNER\C\SAPAMAL.PC] Use(select )
getEmailAddress C/C++ Function [F:\BANNER\C\ICGORIMS.PC] Use(select )
getEmailAddress C/C++ Function [F:\BANNER\C\ICSORIMS.PC] Use(select )
getEmailAddress C/C++ Function [F:\BANNER\C\SCROIMS.PC] Use(select )
get_active_email C/C++ Function [F:\BANNER\C\SOREMAL.PC] Use(select )
get_email C/C++ Function [F:\BANNER\C\APPDEXT.PC] Use(select )
get_email C/C++ Function [F:\BANNER\C\SOREMAL.PC] Use(select )
get_employer_email C/C++ Function [F:\BANNER\C\APPDEXT.PC] Use(select )
initialized C/C++ Function [F:\BANNER\C\APPCUPD.PC] Use()
ins_goremal_n C/C++ Function [F:\BANNER\C\RCRTP00.PC] Use(insert )
ins_goremal_n C/C++ Function [F:\BANNER\C\RCRTP01.PC] Use(insert )
ins_goremal_n C/C++ Function [F:\BANNER\C\RCRTP05.PC] Use()
ins_goremal_n C/C++ Function [F:\BANNER\C\RCRTP04.PC] Use(insert )
ins_goremal_n C/C++ Function [F:\BANNER\C\RCRTP03.PC] Use(insert )
ins_goremal_n C/C++ Function [F:\BANNER\C\RCRTP06.PC] Use()
ins_goremal_n C/C++ Function [F:\BANNER\C\RCRTP02.PC] Use(insert )
insert_emal C/C++ Function [F:\BANNER\C\AGPMATC.PC] Use(select )
insert_url C/C++ Function [F:\BANNER\C\AGPMATC.PC] Use(insert,select )
load_record C/C++ Function [F:\BANNER\C\APPCUPD.PC] Use()
sel_goremal C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
GOREMAL SYNONYM S4B70.PUBLIC Rely on ()
GT_GOREMAL_AR_LDI TRIGGER S4B70."GENERAL" Rely on ()
AA_ORGANIZATION_CONTACT VIEW S4B70.BANINST1 Use(select )
AS_ORGANIZATION_ENTITY VIEW S4B70.BANINST1 Use(select )
AS_PERSON VIEW S4B70.BANINST1 Use(select )
SAVAMCD VIEW S4B70.BANINST1 Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS.APAIDEN.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS_10G.GOAEMAL.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS_10G.GOQCLIB.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS_10G.APAIDEN.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS_10G.FOAIDEN.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS_10G.SPAIDEN.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS.GOQOLIB.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS.GOQCLIB.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS.GOAEMAL.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-CHECKBOX-CHANGED Forms Trigger BANNER7_FORMS.SPAIDEN.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.APAEMAL.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.APAIDEN.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOQOLIB.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOQCLIB.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GOAEMAL.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GOQCLIB.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.APAIDEN.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.FOAIDEN.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SPAIDEN.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.APAEMAL.GOREMAL.GOREMAL_PREFERRED_IND Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SPAIDEN.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOAEMAL.GOREMAL.GOREMAL_EMAIL_ADDRESS Rely on ()
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVEMAL Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVEMAL Use(select )
GOREMAL Forms DataBlock BANNER7_FORMS.GOQOLIB Rely on () Use(insert,update,delete,select )
GOREMAL Forms DataBlock BANNER7_FORMS.GOQCLIB Rely on () Use(insert,update,delete,select )
GOREMAL Forms DataBlock BANNER7_FORMS_10G.GOQCLIB Rely on () Use(insert,update,delete,select )
GET_MATCH_DETAILS Forms Trigger BANNER7_FORMS.GOAMTCH.GOTCMRT_MATCH Rely on () Use(select )
GET_MATCH_DETAILS Forms Trigger BANNER7_FORMS.GOAMTCH.GOTCMRT_SUSPENSE Rely on () Use(select )
GET_MATCH_DETAILS Forms Trigger BANNER7_FORMS_10G.GOAMTCH.GOTCMRT_SUSPENSE Rely on () Use(select )
GET_MATCH_DETAILS Forms Trigger BANNER7_FORMS_10G.GOAMTCH.GOTCMRT_MATCH Rely on () Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.RCRSUSP.SPRIDEN Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.APAEMAL.GOREMAL Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.APAEMAL.GOREMAL Use(select )
PRE-UPDATE Forms Trigger BANNER7_FORMS.APAEMAL.GOREMAL Use(select )
PRE-UPDATE Forms Trigger BANNER7_FORMS_10G.APAEMAL.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS.APAIDEN.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS.GOQOLIB.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS.GOAEMAL.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS_10G.SPAIDEN.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS_10G.FOAIDEN.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS_10G.GOAEMAL.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS_10G.GOQCLIB.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS_10G.APAIDEN.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS.SPAIDEN.GOREMAL Use(select )
PRE_COMMIT_VALIDATE Forms Trigger BANNER7_FORMS.GOQCLIB.GOREMAL Use(select )
P_GETEMAILADDRESS PROCEDURE S4B70.BANINST1 Rely on ()
P_GETEMAILADDRESS PROCEDURE S4B70.BANINST1 Rely on () Use(select )
UPDATE_CONSTITUENT Forms Procedure BANNER7_FORMS.APAWPRS Rely on ()
UPDATE_CONSTITUENT Forms Procedure BANNER7_FORMS_10G.APAWPRS Rely on ()
F_GET_EMAIL_ROWID FUNCTION S4B70.BANINST1 Use(select )
EMAILS_EXIST Forms Function BANNER7_FORMS.APAIDEN Use(select )
EMAILS_EXIST Forms Function BANNER7_FORMS.APASRVW Use(select )
EMAILS_EXIST Forms Function BANNER7_FORMS_10G.GOAADDR Use(select )
EMAILS_EXIST Forms Function BANNER7_FORMS_10G.APASRVW Use(select )
EMAILS_EXIST Forms Function BANNER7_FORMS_10G.APAIDEN Use(select )
EMAILS_EXIST Forms Function BANNER7_FORMS.GOAADDR Use(select )
EMAIL_ADDRESSES_EXIST Forms Function BANNER7_FORMS.APASBIO Use(select )
EMAIL_ADDRESSES_EXIST Forms Function BANNER7_FORMS_10G.APASBIO Use(select )
EMAIL_REC Package Type S4B70.BANINST1.GB_EMAIL Rely on ()
EMAIL_RECORD Package Type S4B70.BANINST1.GOKSEVN Rely on ()
EMAIL_TYPE Package Type S4B70.BANINST1.BWGKOADR Rely on ()
EMAIL_TYPE Package Type S4B70.BANINST1.EFDTEST Rely on ()
EMAL_TYPE Package Type S4B70.BANINST1.BWAKADVS Rely on ()
GOREMAL_LINK_TYPE Package Type S4B70.BANINST1.BWGKOADR Rely on ()
GOREMAL_LINK_TYPE Package Type S4B70.BANINST1.EFDTEST Rely on ()
TEST_REC Package Type S4B70.BANINST1.EFD_TEST Rely on ()
GOREMAL_REC Package variable S4B70.BANINST1.BWDKCPRF Rely on ()
GOREMAL_REC Package variable S4B70.BANINST1.BWDKCPRF Rely on ()
PREV_EMAL Package variable S4B70.BANINST1.BWGKOADR Rely on ()
PREV_EMAL Package variable S4B70.BANINST1.EFDTEST Rely on ()
P_OPEN_GOREMAL_CV Package procedure S4B70.BANINST1.GOKCMPK Use(select )
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.GB_EMAIL Rely on ()
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.EFD_TEST Rely on ()
GET_GOREMAL_EMAIL_C Package cursor S4B70.BANINST1.BWLKFCWL Use(select )
GOREMALC Package cursor S4B70.BANINST1.BWGKOPRF Use(select )
GOREMALEMALEADDC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALEMALEADDC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMALERIDC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALERIDC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMALLINKC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALLINKC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMALPREFC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALPREFC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMALPREFERIDC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALPREFERIDC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMALVIEWC Package cursor S4B70.BANINST1.BWAKADVS Use(select )
GOREMALVIEWC Package cursor S4B70.BANINST1.BWDKCPRF Rely on () Use(select )
GOREMAL_C Package cursor S4B70.BANINST1.ICSPKCOM Use(select )
GOREMAL_C Package cursor S4B70.BANINST1.ICSPKCOM Rely on ()
GOREMAL_ETYP_C Package cursor S4B70.BANINST1.APKLDRD Rely on ()
GOREMAL_ETYP_C Package cursor S4B70.BANINST1.APKLDRD Rely on () Use(select )
LATEST_SPBPERSC Package cursor S4B70.BANINST1.BWSKALOG Use(select )
EMAIL Package variable S4B70.BANINST1.BWLKFCWL Rely on ()
GOREMAL_REC Package variable S4B70.BANINST1.BWGKOPRF Rely on ()
GOREMAL_REC Package variable S4B70.BANINST1.BWGKOPRF Rely on ()
F_BUILD_GOREMAL_REC Package function S4B70.BANINST1.GB_EMAIL Rely on ()
F_BUILD_GOREMAL_REC Package function S4B70.BANINST1.EFD_TEST Rely on ()
F_BUILD_GOREMAL_REC Package function S4B70.BANINST1.EFD_TEST Rely on ()
F_BUILD_GOREMAL_REC Package function S4B70.BANINST1.GB_EMAIL Rely on ()
F_EMAILSDAXEXISTS Package function S4B70.BANINST1.GOKSEVN Use(select )
F_GOREMAL_EXISTS Package function S4B70.BANINST1.GOKCMPK Use(select )
P_CREATE Package procedure S4B70.BANINST1.GB_EMAIL Rely on ()
P_CREATE Package procedure S4B70.BANINST1.EFD_TEST Rely on ()
P_CREATE Package procedure S4B70.BANINST1.GB_EMAIL Rely on ()
P_CREATE Package procedure S4B70.BANINST1.EFD_TEST Rely on ()
P_DELETE Package procedure S4B70.BANINST1.GB_EMAIL Rely on ()
P_DELETE Package procedure S4B70.BANINST1.EFD_TEST Rely on ()
P_DELETE Package procedure S4B70.BANINST1.EFD_TEST Rely on ()
P_DELETE Package procedure S4B70.BANINST1.GB_EMAIL Rely on ()
P_DELETE Package procedure S4B70.BANINST1.DML_GOREMAL Use(delete )
P_DISPADVISEES Package procedure S4B70.BANINST1.BWLKADVR Rely on ()
P_DISPADVISEES Package procedure S4B70.BANINST1.BWLKADVR Use(select )
P_DISPCURRENT Package procedure S4B70.BANINST1.BWCKCAPP Rely on ()
P_DISPEVALADDITIONAL Package procedure S4B70.BANINST1.BWCKSNCR Rely on ()
P_DISPEVALDETAILREQ Package procedure S4B70.BANINST1.BWCKSMLT Rely on ()
P_DISPEVALGENERALREQ Package procedure S4B70.BANINST1.BWCKSMLT Rely on ()
P_EMAILEVENTCHECK Package procedure S4B70.BANINST1.GOKSEVN Rely on ()
P_EMAIL_INSERT Package procedure S4B70.BANINST1.GOKSEVN Rely on ()
P_EMAIL_UPDATE Package procedure S4B70.BANINST1.GOKSEVN Rely on ()
P_GETEMAILS Package procedure S4B70.BANINST1.BWPKEDIR Use(select )
P_GET_GIFT_INFO Package procedure S4B70.BANINST1.AOKWEVN Rely on ()
P_GET_GIFT_INFO Package procedure S4B70.BANINST1.AOKWEVN Use(select )
P_GET_STUDENT_ADVISORS Package procedure S4B70.BANINST1.BWSCBREF Use(select )
P_GET_STUDENT_ADVISORS Package procedure S4B70.BANINST1.BWSCJREF Use(select )
P_INSERT Package procedure S4B70.BANINST1.DML_GOREMAL Rely on () Use(insert )
P_INSERT_GOREMAL Package procedure S4B70.BANINST1.SRKPREL Use(select )
P_LOAD_EMAIL Package procedure S4B70.BANINST1.APKLDRD Rely on ()
P_LOAD_EMAIL Package procedure S4B70.BANINST1.APKLDRD Rely on () Use(update )
P_LOAD_GOREMAL Package procedure S4B70.BANINST1.SAKL045 Rely on ()
P_LOAD_GOREMAL Package procedure S4B70.BANINST1.SAKL045 Use(select )
P_LOCK Package procedure S4B70.BANINST1.GB_EMAIL Rely on ()
P_LOCK Package procedure S4B70.BANINST1.GB_EMAIL Use(select )
P_LOCK Package procedure S4B70.BANINST1.EFD_TEST Use(select )
P_LOCK Package procedure S4B70.BANINST1.EFD_TEST Rely on ()
P_PROCNEWAPP Package procedure S4B70.BANINST1.BWSKALOG Rely on ()
P_PROCNEWAPP Package procedure S4B70.BANINST1.BWSKALOG Rely on ()
P_REGISTER_ENTITY Package procedure S4B70.BANINST1.GB_EMAIL_RULES Rely on ()
P_REGISTER_ENTITY Package procedure S4B70.BANINST1.EFD_TEST_RULES Rely on ()
P_SAVE_UPD_PERSON_EMAIL Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_ADD_PERSON Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_PERSON Package procedure S4B70.BANINST1.ICSPKLDI Rely on ()
P_SEND_UPD_PERSON_EMAIL Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.GB_EMAIL Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.EFD_TEST Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.EFD_TEST Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.DML_GOREMAL Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.GB_EMAIL Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.GB_EMAIL_RULES Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.GB_EMAIL_RULES Use(select )
P_VALIDATE Package procedure S4B70.BANINST1.EFD_TEST_RULES Rely on ()
P_VERIFYDISPEVALVIEWOPTION Package procedure S4B70.BANINST1.BWCKCAPP Rely on ()
GOREMALC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALC Package cursor S4B70.BANINST1.BWSKALOG Rely on () Use(select )
GOREMALC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMAL_EMAIL_C Package cursor S4B70.BANINST1.ICGOKLIB Rely on ()
GTVEMALVIEWC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GTVEMALVIEWC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
F_CLASS_EMAIL_STR Package function S4B70.BANINST1.BWLCBREF Use(select )
F_CLASS_EMAIL_STR Package function S4B70.BANINST1.BWLCBREF Rely on ()
F_DISP_INSTR_EMAIL_ICON Package function S4B70.BANINST1.BWCKFRMT Rely on ()
F_DISP_INSTR_EMAIL_ICON Package function