GOBEQRC GOREQER GOREQNM GOREQPG GOREQRC GTVEQNM GTVEQPG GTVEQPM GTVEQTS

Model Event Queue Maintenance


Model Label : Banner General Event Queue Maintenance
Path : Default Folder/B70/General/Event_Queue_Maintenance

List of Objects

Object Name Object Type Layer Name
GOBEQRC TABLE Default
GOREQER TABLE Default
GOREQNM TABLE Default
GOREQPG TABLE Default
GOREQRC TABLE Default
GTVEQNM TABLE Default
GTVEQPG TABLE Default
GTVEQPM TABLE Default
GTVEQTS TABLE Default

Comments

Model View

''

Table GOBEQRC

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBEQRC_SEQNO GOBEQRC_SEQNO NUMBER(0,0) No *
GOBEQRC_EQTS_CODE GOBEQRC_EQTS_CODE VARCHAR2(10) No * *
GOBEQRC_EQNM_CODE GOBEQRC_EQNM_CODE VARCHAR2(20) No * *
GOBEQRC_STATUS_IND GOBEQRC_STATUS_IND VARCHAR2(1) No
GOBEQRC_USER_ID GOBEQRC_USER_ID VARCHAR2(30) No
GOBEQRC_ACTIVITY_DATE GOBEQRC_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
GOBEQRC_EQNM_CODE GTVEQNM_CODE GTVEQNM
GOBEQRC_EQTS_CODE GTVEQTS_CODE GTVEQTS

Index

Index Name Index Type Column Name
GOBEQRC_EQTS_INDEX Unique GOBEQRC_EQTS_CODE
GOBEQRC_EQTS_INDEX Unique GOBEQRC_STATUS_IND
GOBEQRC_EQTS_INDEX Unique GOBEQRC_SEQNO
GOBEQRC_EQTS_INDEX Unique GOBEQRC_EQNM_CODE
PK_GOBEQRC Unique GOBEQRC_SEQNO
PK_GOBEQRC Unique GOBEQRC_EQTS_CODE
PK_GOBEQRC Unique GOBEQRC_EQNM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOBEQRC SYNONYM S4B70.PUBLIC Rely on ()
CHK_GOBEQRC_PARM Forms Function BANNER7_FORMS.GOREQNM Use(select )
CHK_GOBEQRC_PARM Forms Function BANNER7_FORMS_10G.GOREQNM Use(select )
HANDLE_ERROR Package procedure S4B70.BANINST1.GOKPARM Use(delete )
SEND_PARAM_LIST Package procedure S4B70.BANINST1.GOKPARM Use(insert )
SEND_PARAM_LIST Package procedure S4B70.BANINST1.GOKPARM Use(insert )
SEND_PARAM_LIST Package procedure S4B70.BANINST1.GOKPARM Use(insert )
GOBEQRC Forms DataBlock BANNER7_FORMS.GOAEQRM Rely on () Use(update,select )
GOBEQRC Forms DataBlock BANNER7_FORMS_10G.GOAEQRM Rely on () Use(update,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GOBEQRC_EQTS_INDEX INDEX S4B70."GENERAL" Rely on ()
PK_GOBEQRC INDEX S4B70."GENERAL" Rely on ()
GTVEQNM TABLE S4B70."GENERAL" Refer( No Action )
GTVEQTS TABLE S4B70."GENERAL" Refer( No Action )

Comments

Source Code Comments

Event Queue Record Maintenance Table.

Columns Comments for GOBEQRC_SEQNO (1)

Source Code Comments

SEQUENCE NUMBER: Sequence Number of an Event within the Target System. Generated by GOBESEQ.

Columns Comments for GOBEQRC_EQTS_CODE (2)

Source Code Comments

TARGET SYSTEM CODE: Target System Code.

Columns Comments for GOBEQRC_EQNM_CODE (3)

Source Code Comments

EVENT CODE: Event Code to be processed.

Columns Comments for GOBEQRC_STATUS_IND (4)

Source Code Comments

STATUS INDICATOR: 0=Ready for Processing, 1=Being Processed, 2=Complete.

Columns Comments for GOBEQRC_USER_ID (5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOBEQRC_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GOREQER

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREQER_EQTS_CODE GOREQER_EQTS_CODE VARCHAR2(10) No * *
GOREQER_EQNM_CODE GOREQER_EQNM_CODE VARCHAR2(20) No * *
GOREQER_SEQNO GOREQER_SEQNO NUMBER(0,0) No *
GOREQER_ERROR_MESSAGE GOREQER_ERROR_MESSAGE VARCHAR2(2000) No
GOREQER_USER_ID GOREQER_USER_ID VARCHAR2(30) No
GOREQER_ACTIVITY_DATE GOREQER_ACTIVITY_DATE DATE No
GOREQER_ERROR_NUMBER GOREQER_ERROR_NUMBER NUMBER(0,0) Yes
GOREQER_ERROR_SEND_TO GOREQER_ERROR_SEND_TO VARCHAR2(30) Yes
GOREQER_SEVERITY_LEVEL GOREQER_SEVERITY_LEVEL VARCHAR2(1) Yes
GOREQER_ERROR_TYPE GOREQER_ERROR_TYPE VARCHAR2(6) Yes
GOREQER_ERROR_STACK GOREQER_ERROR_STACK VARCHAR2(2000) Yes
GOREQER_CALL_STACK GOREQER_CALL_STACK VARCHAR2(2000) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GOREQER_EQNM_CODE GTVEQNM_CODE GTVEQNM
GOREQER_EQTS_CODE GTVEQTS_CODE GTVEQTS

Index

Index Name Index Type Column Name
PK_GOREQER Unique GOREQER_EQTS_CODE
PK_GOREQER Unique GOREQER_EQNM_CODE
PK_GOREQER Unique GOREQER_SEQNO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOREQER SYNONYM S4B70.PUBLIC Rely on ()
CHK_ERR Forms Function BANNER7_FORMS.GOAEQRM Use(select )
CHK_ERR Forms Function BANNER7_FORMS_10G.GOAEQRM Use(select )
HANDLE_ERROR Package procedure S4B70.BANINST1.GOKPARM Use(insert )
GOREQER Forms DataBlock BANNER7_FORMS.GOAEQRM Rely on () Use(delete,select )
GOREQER Forms DataBlock BANNER7_FORMS_10G.GOAEQRM Rely on () Use(delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GOREQER INDEX S4B70."GENERAL" Rely on ()
GTVEQNM TABLE S4B70."GENERAL" Refer( No Action )
GTVEQTS TABLE S4B70."GENERAL" Refer( No Action )

Comments

Source Code Comments

Error Log Event Queue Table.

Columns Comments for GOREQER_EQTS_CODE (1)

Source Code Comments

TARGET SYSTEM CODE: Target System Code in the Error Log.

Columns Comments for GOREQER_EQNM_CODE (2)

Source Code Comments

EVENT CODE: Event Code ine the Error Log.

Columns Comments for GOREQER_SEQNO (3)

Source Code Comments

SEQUENCE NUMBER: Error sequence Number generated by GOBRSEQ sequence.

Columns Comments for GOREQER_ERROR_MESSAGE (4)

Source Code Comments

ERROR MESSAGE: Oracle error Message

Columns Comments for GOREQER_USER_ID (5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOREQER_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Columns Comments for GOREQER_ERROR_NUMBER (7)

Source Code Comments

ERROR NUMBER: Oracle Error Number

Columns Comments for GOREQER_ERROR_SEND_TO (8)

Source Code Comments

SEND TO: User Name to be notified of the Error.

Columns Comments for GOREQER_SEVERITY_LEVEL (9)

Source Code Comments

SEVERITY LEVEL: Error Severity level (reserved for future release).

Columns Comments for GOREQER_ERROR_TYPE (10)

Source Code Comments

ERROR TYPE: Error Type ( reserved for future release)

Columns Comments for GOREQER_ERROR_STACK (11)

Source Code Comments

ERROR STACK: Error Stack Messages.

Columns Comments for GOREQER_CALL_STACK (12)

Source Code Comments

CALL STACK: The call stack of pl/sql units( triggers, procedures).

Table GOREQNM

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREQNM_EQNM_CODE GOREQNM_EQNM_CODE VARCHAR2(20) No * *
GOREQNM_EQPG_CODE GOREQNM_EQPG_CODE VARCHAR2(10) No *
GOREQNM_EQTS_CODE GOREQNM_EQTS_CODE VARCHAR2(10) No * *
GOREQNM_STATUS_IND GOREQNM_STATUS_IND VARCHAR2(1) No
GOREQNM_USER_ID GOREQNM_USER_ID VARCHAR2(30) No
GOREQNM_ACTIVITY_DATE GOREQNM_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
GOREQNM_EQNM_CODE GTVEQNM_CODE GTVEQNM
GOREQNM_EQPG_CODE GTVEQPG_CODE GTVEQPG
GOREQNM_EQTS_CODE GTVEQTS_CODE GTVEQTS

Index

Index Name Index Type Column Name
PK_GOREQNM Unique GOREQNM_EQNM_CODE
PK_GOREQNM Unique GOREQNM_EQTS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOREQNM SYNONYM S4B70.PUBLIC Rely on ()
CHK_EQNM_CODE Forms Function BANNER7_FORMS.GTVEQNM Use(select )
CHK_EQNM_CODE Forms Function BANNER7_FORMS_10G.GTVEQNM Use(select )
CHK_EQPG_CODE Forms Function BANNER7_FORMS.GOREQPG Use(select )
CHK_EQPG_CODE Forms Function BANNER7_FORMS_10G.GOREQPG Use(select )
CHK_EQTS_CODE Forms Function BANNER7_FORMS.GTVEQTS Use(select )
CHK_EQTS_CODE Forms Function BANNER7_FORMS_10G.GTVEQTS Use(select )
C_GOREQNM Package cursor S4B70.BANINST1.GOKPARM Use(select )
GOREQNM_C Package cursor S4B70.BANINST1.ICGOKCOM Use(select )
P_SAVE_ADD_NEW_FAC_USER Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SAVE_ADD_NEW_STU_USER Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SAVE_ADD_PERSON Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SAVE_ASSIGNMENT Package procedure S4B70.BANINST1.ICSIKLDI Rely on ()
P_SAVE_CHANGE_COURSE_DEPT Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SAVE_CHANGE_COURSE_TITLE Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SAVE_CHANGE_MAJOR Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SAVE_CHANGE_MEETINGS Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SAVE_COLLEGE Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SAVE_COURSE Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SAVE_CROSSLIST_GROUP Package procedure S4B70.BANINST1.ICSSKLDI Rely on ()
P_SAVE_CROSSLIST_MEMBERSHIP Package procedure S4B70.BANINST1.ICSSKLDI Rely on ()
P_SAVE_CROSS_LIST Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SAVE_DEPARTMENT Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SAVE_ENROLLMENT Package procedure S4B70.BANINST1.ICSFKLDI Rely on ()
P_SAVE_PERSON Package procedure S4B70.BANINST1.ICSPKLDI Rely on ()
P_SAVE_SECTION Package procedure S4B70.BANINST1.ICSSKLDI Rely on ()
P_SAVE_TERM Package procedure S4B70.BANINST1.ICSOKLDI Rely on ()
P_SAVE_UPD_PERSON_ADDRESS Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SAVE_UPD_PERSON_EMAIL Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SAVE_UPD_SECTION_COURSE Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_ADD_CROSS_LIST Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_ADD_ENROLL Package procedure S4B70.BANINST1.ICSFKEVN Rely on ()
P_SEND_ADD_HOLD Package procedure S4B70.BANINST1.ICSPKBEV Rely on ()
P_SEND_ADD_NEW_FAC_USER Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_ADD_NEW_STU_USER Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SEND_ADD_PERSON Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_ADD_REGISTRATION Package procedure S4B70.BANINST1.ICSFKSEV Rely on ()
P_SEND_ADD_REGISTRATION Package procedure S4B70.BANINST1.SFKSEVN Rely on ()
P_SEND_ADD_SECTION Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_ADD_SECTION Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_ADD_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_ADD_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKEVN Rely on ()
P_SEND_ADD_TERM Package procedure S4B70.BANINST1.ICSOKSEV Rely on ()
P_SEND_ADD_TERM Package procedure S4B70.BANINST1.ICSOKEVN Rely on ()
P_SEND_CHANGE_COURSE_DEPT Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SEND_CHANGE_COURSE_TITLE Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SEND_CHANGE_MAJOR Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SEND_CHANGE_MEETINGS Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_CHANGE_SCHEDULE_CODE Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_CHANGE_SECTION_NUM Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_CHANGE_SECTION_TITLE Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_DELETE_CROSS_LIST Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_DELETE_SECTION Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_DELETE_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_DEL_ENROLL Package procedure S4B70.BANINST1.ICSFKEVN Rely on ()
P_SEND_DEL_SECTION Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_DEL_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKEVN Rely on ()
P_SEND_DROP_REGISTRATION Package procedure S4B70.BANINST1.ICSFKSEV Rely on ()
P_SEND_DROP_REGISTRATION Package procedure S4B70.BANINST1.SFKSEVN Rely on ()
P_SEND_END_TERM Package procedure S4B70.BANINST1.ICSOKSEV Rely on ()
P_SEND_PERSON Package procedure S4B70.BANINST1.ICSPKLDI Rely on ()
P_SEND_UPD_CROSS_LIST Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_UPD_ENROLL Package procedure S4B70.BANINST1.ICSFKEVN Rely on ()
P_SEND_UPD_PERSON Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_UPD_PERSON_ADDRESS Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_UPD_PERSON_EMAIL Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_UPD_PERSON_IDEN Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_UPD_PERSON_TPACCESS Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_UPD_SECTION Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_UPD_SECTION_COURSE Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_UPD_TERM Package procedure S4B70.BANINST1.ICSOKEVN Rely on ()
F_CHECKEVENT Package function S4B70.BANINST1.ICGOKCOM Rely on ()
F_CHECKEVENT Package function S4B70.BANINST1.GOKEVNT Use(select )
GOREQNM Forms DataBlock BANNER7_FORMS.GOREQNM Rely on () Use(insert,update,delete,select )
GOREQNM Forms DataBlock BANNER7_FORMS_10G.GOREQNM Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GOREQNM INDEX S4B70."GENERAL" Rely on ()
GTVEQNM TABLE S4B70."GENERAL" Refer( No Action )
GTVEQPG TABLE S4B70."GENERAL" Refer( No Action )
GTVEQTS TABLE S4B70."GENERAL" Refer( No Action )

Comments

Source Code Comments

Event Queue Name Definition Table

Columns Comments for GOREQNM_EQNM_CODE (1)

Source Code Comments

EVENT CODE: Event Code.

Columns Comments for GOREQNM_EQPG_CODE (2)

Source Code Comments

GROUP CODE: Group Code.

Columns Comments for GOREQNM_EQTS_CODE (3)

Source Code Comments

TARGET SYSTEM CODE: Target System Code.

Columns Comments for GOREQNM_STATUS_IND (4)

Source Code Comments

STATUS INDICATOR: Status Indicator for Events. Valid Values are (A)ctive and (I)nactive.

Columns Comments for GOREQNM_USER_ID (5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOREQNM_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GOREQPG

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREQPG_EQPG_CODE GOREQPG_EQPG_CODE VARCHAR2(10) No * *
GOREQPG_EQPM_CODE GOREQPG_EQPM_CODE VARCHAR2(100) No * *
GOREQPG_SEQNO GOREQPG_SEQNO NUMBER(2,0) No *
GOREQPG_DEFAULT_VALUE GOREQPG_DEFAULT_VALUE VARCHAR2(2000) Yes
GOREQPG_TARGET_NAME GOREQPG_TARGET_NAME VARCHAR2(100) Yes
GOREQPG_USER_ID GOREQPG_USER_ID VARCHAR2(30) No
GOREQPG_ACTIVITY_DATE GOREQPG_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
GOREQPG_EQPG_CODE GTVEQPG_CODE GTVEQPG
GOREQPG_EQPM_CODE GTVEQPM_CODE GTVEQPM

Index

Index Name Index Type Column Name
PK_GOREQPG Unique GOREQPG_EQPG_CODE
PK_GOREQPG Unique GOREQPG_EQPM_CODE
PK_GOREQPG Unique GOREQPG_SEQNO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOREQPG SYNONYM S4B70.PUBLIC Rely on ()
CHK_EQPG_CODE Forms Function BANNER7_FORMS.GTVEQPG Use(select )
CHK_EQPG_CODE Forms Function BANNER7_FORMS_10G.GTVEQPG Use(select )
CHK_EQPM_CODE Forms Function BANNER7_FORMS.GTVEQPM Use(select )
CHK_EQPM_CODE Forms Function BANNER7_FORMS_10G.GTVEQPM Use(select )
C_GOREQPG Package cursor S4B70.BANINST1.GOKPARM Use(select )
GET_EQPM_CODE_C Package cursor S4B70.BANINST1.GOKPARM Rely on () Use(select )
SEND_PARAM_LIST Package procedure S4B70.BANINST1.GOKPARM Rely on ()
SEND_PARAM_LIST Package procedure S4B70.BANINST1.GOKPARM Rely on ()
GOREQPG Forms DataBlock BANNER7_FORMS.GOREQPG Rely on () Use(insert,update,delete,select )
GOREQPG Forms DataBlock BANNER7_FORMS_10G.GOREQPG Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GOREQPG INDEX S4B70."GENERAL" Rely on ()
GTVEQPG TABLE S4B70."GENERAL" Refer( No Action )
GTVEQPM TABLE S4B70."GENERAL" Refer( No Action )

Comments

Source Code Comments

Parameter Group Code Rule Table

Columns Comments for GOREQPG_EQPG_CODE (1)

Source Code Comments

GROUP CODE: Group Code for the Parameter Set

Columns Comments for GOREQPG_EQPM_CODE (2)

Source Code Comments

PARAMETER CODE: Parameter Code.

Columns Comments for GOREQPG_SEQNO (3)

Source Code Comments

SEQUENCE NUMBER: Sequence Number for Parameters attached to the Group Code

Columns Comments for GOREQPG_DEFAULT_VALUE (4)

Source Code Comments

DEFAULT VALUE: Default Value for Parameters

Columns Comments for GOREQPG_TARGET_NAME (5)

Source Code Comments

TARGET NAME: Name for the Target Object to receive the value

Columns Comments for GOREQPG_USER_ID (6)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOREQPG_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GOREQRC

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREQRC_SEQNO GOREQRC_SEQNO NUMBER(0,0) No *
GOREQRC_PARM_SEQNO GOREQRC_PARM_SEQNO NUMBER(0,0) No *
GOREQRC_PARM_NAME GOREQRC_PARM_NAME VARCHAR2(100) No
GOREQRC_PARM_VALUE GOREQRC_PARM_VALUE VARCHAR2(2000) No
GOREQRC_USER_ID GOREQRC_USER_ID VARCHAR2(30) No
GOREQRC_ACTIVITY_DATE GOREQRC_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GOREQRC Unique GOREQRC_SEQNO
PK_GOREQRC Unique GOREQRC_PARM_SEQNO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOREQRC SYNONYM S4B70.PUBLIC Rely on ()
PRE-DELETE Forms Trigger BANNER7_FORMS.GOAEQRM.GOBEQRC Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.GOAEQRM.GOBEQRC Use(delete )
PARAM_REC_TYPE Package Type S4B70.BANINST1.GOKPARM Rely on ()
HANDLE_ERROR Package procedure S4B70.BANINST1.GOKPARM Use(delete )
P_SEND_CHANGE_COURSE_DEPT Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SEND_PERSON Package procedure S4B70.BANINST1.ICSPKLDI Rely on ()
SEND_PARAM_LIST Package procedure S4B70.BANINST1.GOKPARM Use(insert )
SEND_PARAM_LIST Package procedure S4B70.BANINST1.GOKPARM Use(insert )
SEND_PARAM_LIST Package procedure S4B70.BANINST1.GOKPARM Use(insert )
GOREQRC Forms DataBlock BANNER7_FORMS.GOAEQRM Rely on () Use(select )
GOREQRC Forms DataBlock BANNER7_FORMS_10G.GOAEQRM Rely on () Use(select )

Called objects (non escalated)

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

Comments

Source Code Comments

Event Queue Record Maintenance Detail Table.

Columns Comments for GOREQRC_SEQNO (1)

Source Code Comments

SEQUENCE NUMBER:Event Sequence Number.

Columns Comments for GOREQRC_PARM_SEQNO (2)

Source Code Comments

SEQUENCE NUMBER: Parameter Sequence Number.

Columns Comments for GOREQRC_PARM_NAME (3)

Source Code Comments

PARAMETER NAME: Parameter Name.

Columns Comments for GOREQRC_PARM_VALUE (4)

Source Code Comments

PARAMETER VALUE: Value for the Parameter

Columns Comments for GOREQRC_USER_ID (5)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for GOREQRC_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date that the information for the record was entered or updated.

Table GTVEQNM

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVEQNM_CODE GTVEQNM_CODE VARCHAR2(20) No *
GTVEQNM_DESC GTVEQNM_DESC VARCHAR2(30) No
GTVEQNM_USER_ID GTVEQNM_USER_ID VARCHAR2(30) No
GTVEQNM_ACTIVITY_DATE GTVEQNM_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVEQNM Unique GTVEQNM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GTVEQNM SYNONYM S4B70.PUBLIC Rely on ()
GOBEQRC TABLE S4B70."GENERAL" Refer( No Action )
GOREQER TABLE S4B70."GENERAL" Refer( No Action )
GOREQNM TABLE S4B70."GENERAL" Refer( No Action )
GTVEQNM_RG Forms Record Group BANNER7_FORMS.GOQOLIB Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS.GOREQNM Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS_10G.GOQOLIB Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS_10G.GOAEQRM Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS_10G.GOREQPG Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS_10G.GOREQNM Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS_10G.GORCCRD Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS.GOREQPG Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS.GOAEQRM Use(select )
GTVEQNM_RG Forms Record Group BANNER7_FORMS.GORCCRD Use(select )
CHK_EQNM_CODE Forms Function BANNER7_FORMS.GOAEQRM Use(select )
CHK_EQNM_CODE Forms Function BANNER7_FORMS_10G.GOAEQRM Use(select )
CHK_EVNT_CODE Forms Function BANNER7_FORMS.GOREQNM Use(select )
CHK_EVNT_CODE Forms Function BANNER7_FORMS_10G.GOREQPG Use(select )
CHK_EVNT_CODE Forms Function BANNER7_FORMS_10G.GOREQNM Use(select )
CHK_EVNT_CODE Forms Function BANNER7_FORMS.GOREQPG Use(select )
GET_EQNM_DESC Forms Function BANNER7_FORMS.GOREQNM Rely on () Use(select )
GET_EQNM_DESC Forms Function BANNER7_FORMS.GOAEQRM Rely on () Use(select )
GET_EQNM_DESC Forms Function BANNER7_FORMS_10G.GOAEQRM Rely on () Use(select )
GET_EQNM_DESC Forms Function BANNER7_FORMS_10G.GOREQNM Rely on () Use(select )
EVENT_TYPE Package Type S4B70.BANINST1.ICSGKSEV Rely on ()
EVENT_TYPE Package Type S4B70.BANINST1.ICSIKSEV Rely on ()
EVENT_TYPE Package Type S4B70.BANINST1.ICSPKEVN Rely on ()
EVENT_TYPE Package Type S4B70.BANINST1.ICSSKSEV Rely on ()
EVENT_TYPE Package Type S4B70.BANINST1.ICSSKEVN Rely on ()
EVENT_TYPE Package Type S4B70.BANINST1.ICSCKSEV Rely on ()
GOREQNM_C Package cursor S4B70.BANINST1.ICGOKCOM Rely on ()
V_EQNM_CODE Package variable S4B70.BANINST1.GOKPARM Rely on ()
HANDLE_ERROR Package procedure S4B70.BANINST1.GOKPARM Rely on ()
P_AGBGIFTNEWGIFT Package procedure S4B70.BANINST1.AOKWEVN Rely on ()
P_CHANGE_EMAIL_ID Package procedure S4B70.BANINST1.ICGOKSEV Rely on ()
P_CHANGE_PERSON_ID Package procedure S4B70.BANINST1.ICGOKSEV Rely on ()
P_CHANGE_PIN Package procedure S4B70.BANINST1.ICGOKSEV Rely on ()
P_CHANGE_PIN Package procedure S4B70.BANINST1.GOKSEVN Rely on ()
P_EMAILEVENTCHECK Package procedure S4B70.BANINST1.GOKSEVN Rely on ()
P_FAWITHDRAW Package procedure S4B70.BANINST1.SHKWEVN Rely on ()
P_GRADE_CHANGE Package procedure S4B70.BANINST1.ICSHKBEV Rely on ()
P_GRADE_ROLL Package procedure S4B70.BANINST1.ICSHKBEV Rely on ()
P_PASSWORDEVNT Package procedure S4B70.BANINST1.GOKSEVN Rely on ()
P_SAVE_ADD_NEW_FAC_USER Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SAVE_ADD_NEW_STU_USER Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SAVE_ADD_PERSON Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SAVE_ASSIGNMENT Package procedure S4B70.BANINST1.ICSIKLDI Rely on ()
P_SAVE_CHANGE_COURSE_DEPT Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SAVE_CHANGE_COURSE_TITLE Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SAVE_CHANGE_MAJOR Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SAVE_CHANGE_MEETINGS Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SAVE_COLLEGE Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SAVE_COURSE Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SAVE_CROSSLIST_GROUP Package procedure S4B70.BANINST1.ICSSKLDI Rely on ()
P_SAVE_CROSSLIST_MEMBERSHIP Package procedure S4B70.BANINST1.ICSSKLDI Rely on ()
P_SAVE_CROSS_LIST Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SAVE_DEPARTMENT Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SAVE_ENROLLMENT Package procedure S4B70.BANINST1.ICSFKLDI Rely on ()
P_SAVE_PERSON Package procedure S4B70.BANINST1.ICSPKLDI Rely on ()
P_SAVE_SECTION Package procedure S4B70.BANINST1.ICSSKLDI Rely on ()
P_SAVE_TERM Package procedure S4B70.BANINST1.ICSOKLDI Rely on ()
P_SAVE_UPD_PERSON_ADDRESS Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SAVE_UPD_PERSON_EMAIL Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SAVE_UPD_SECTION_COURSE Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SECTION_CANCELLED Package procedure S4B70.BANINST1.ICSSKBEV Rely on ()
P_SEND_ADD_CROSS_LIST Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_ADD_ENROLL Package procedure S4B70.BANINST1.ICSFKEVN Rely on ()
P_SEND_ADD_HOLD Package procedure S4B70.BANINST1.ICSPKBEV Rely on ()
P_SEND_ADD_NEW_FAC_USER Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_ADD_NEW_STU_USER Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SEND_ADD_PERSON Package procedure S4B70.BANINST1.ICSPKEVN Rely on ()
P_SEND_ADD_REGISTRATION Package procedure S4B70.BANINST1.ICSFKSEV Rely on ()
P_SEND_ADD_REGISTRATION Package procedure S4B70.BANINST1.SFKSEVN Rely on ()
P_SEND_ADD_SECTION Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_ADD_SECTION Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_ADD_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_ADD_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKEVN Rely on ()
P_SEND_ADD_TERM Package procedure S4B70.BANINST1.ICSOKSEV Rely on ()
P_SEND_ADD_TERM Package procedure S4B70.BANINST1.ICSOKEVN Rely on ()
P_SEND_ASSIGNMENT Package procedure S4B70.BANINST1.ICSIKLDI Rely on ()
P_SEND_CHANGE_COURSE_DEPT Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SEND_CHANGE_COURSE_TITLE Package procedure S4B70.BANINST1.ICSCKSEV Rely on ()
P_SEND_CHANGE_MAJOR Package procedure S4B70.BANINST1.ICSGKSEV Rely on ()
P_SEND_CHANGE_MEETINGS Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_CHANGE_SCHEDULE_CODE Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_CHANGE_SECTION_NUM Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_CHANGE_SECTION_TITLE Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_COLLEGE Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SEND_COURSE Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SEND_CROSSLIST_GROUP Package procedure S4B70.BANINST1.ICSSKLDI Rely on ()
P_SEND_CROSSLIST_MEMBERSHIP Package procedure S4B70.BANINST1.ICSSKLDI Rely on ()
P_SEND_DELETE_CROSS_LIST Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_DELETE_SECTION Package procedure S4B70.BANINST1.ICSSKSEV Rely on ()
P_SEND_DELETE_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_DEL_ENROLL Package procedure S4B70.BANINST1.ICSFKEVN Rely on ()
P_SEND_DEL_SECTION Package procedure S4B70.BANINST1.ICSSKEVN Rely on ()
P_SEND_DEL_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKEVN Rely on ()
P_SEND_DEPARTMENT Package procedure S4B70.BANINST1.ICSCKLDI Rely on ()
P_SEND_DROP_REGISTRATION Package procedure S4B70.BANINST1.ICSFKSEV Rely on ()
P_SEND_DROP_REGISTRATION Package procedure S4B70.BANINST1.SFKSEVN Rely on ()
P_SEND_END_TERM Package procedure S4B70.BANINST1.ICSOKSEV