Model WebTailor

Model Label :

List of Objects

Object Name	Object Type	Layer Name
TWGBFRAM	SQL Table	Default
TWGBGLUI	SQL Table	Default
TWGBIMAG	SQL Table	Default
TWGBLDAP	SQL Table	Default
TWGBOVRR	SQL Table	Default
TWGBPARM	SQL Table	Default
TWGBRETC	SQL Table	Default
TWGBTLBR	SQL Table	Default
TWGBWMNU	SQL Table	Default
TWGBWRUL	SQL Table	Default
TWGBWSES	SQL Table	Default
TWGRCHNL	SQL Table	Default
TWGRCMAP	SQL Table	Default
TWGRFRRL	SQL Table	Default
TWGRINFO	SQL Table	Default
TWGRMENU	SQL Table	Default
TWGRRETC	SQL Table	Default
TWGRROLE	SQL Table	Default
TWGRTLBR	SQL Table	Default
TWGRUPRF	SQL Table	Default
TWGRVERS	SQL Table	Default
TWGRWMRL	SQL Table	Default
TWGRWPRM	SQL Table	Default
TWTVMODU	SQL Table	Default
TWTVROLE	SQL Table	Default

Model View

Table TWGBFRAM

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGBFRAM_NAME	VARCHAR2(120)	No	*
TWGBFRAM_DESC	VARCHAR2(120)	No
TWGBFRAM_NAVBAR_NAME	VARCHAR2(120)	Yes
TWGBFRAM_STARTPAGE	VARCHAR2(120)	No
TWGBFRAM_START_MENU_IND	VARCHAR2(1)	No
TWGBFRAM_TITLE	VARCHAR2(120)	No
TWGBFRAM_COMMENT	VARCHAR2(120)	Yes
TWGBFRAM_INSECURE_ALLOWED_IND	VARCHAR2(1)	No
TWGBFRAM_MODULE	VARCHAR2(3)	No
TWGBFRAM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGBFRAM	Unique	TWGBFRAM_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRFRRL	SQL Table	S10B80.WTAILOR	Refer (no action)
GETALLFRAMESETSC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
F_FRAMESETNAME	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_CREATETOOLBAR	Oracle Package Procedure	S10B80.WTAILOR.TWBKTLBR	Use (select)
F_VALIDLINK	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
F_VALIDROLE	Oracle Package Function	S10B80.WTAILOR.TWBKSLIB	Rely On
TWGBFRAM	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBFRAM	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBFRAM

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:08:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor HTML Frameset Information table

Columns Comments for TWGBFRAM_NAME (# 1)

Source Code Comments

Name of the frameset - associated with one of the main functional areas of the system.

Columns Comments for TWGBFRAM_DESC (# 2)

Source Code Comments

Description of the frameset.

Columns Comments for TWGBFRAM_NAVBAR_NAME (# 3)

Source Code Comments

Name of navigation bar to be used as default for this frameset (as in TWGBTLBR).

Columns Comments for TWGBFRAM_STARTPAGE (# 4)

Source Code Comments

Name of default page to be displayed within frameset (as in TWGBMAIN).

Columns Comments for TWGBFRAM_START_MENU_IND (# 5)

Source Code Comments

If start page is a P_GenMenu-generated menu, this is set to "Y".

Columns Comments for TWGBFRAM_TITLE (# 6)

Source Code Comments

Title text to be displayed in browser title bar.

Columns Comments for TWGBFRAM_COMMENT (# 7)

Source Code Comments

Comment about this frameset.

Columns Comments for TWGBFRAM_INSECURE_ALLOWED_IND (# 8)

Source Code Comments

"Y" if users may access this frameset without authentication.

Columns Comments for TWGBFRAM_MODULE (# 9)

Source Code Comments

Web system that this frameset belongs to.

Columns Comments for TWGBFRAM_ACTIVITY_DATE (# 10)

Source Code Comments

Date last modified.

Table TWGBGLUI

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
TWGBGLUI_SYSTEM_NAME	VARCHAR2(120)	Yes
TWGBGLUI_BODY_BG_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_BODY_BG_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_HELP_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_MAIN_MENU_NAME	VARCHAR2(120)	Yes
TWGBGLUI_HEADER_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_HEADER_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_HEADER_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_DEFAULT_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_LABEL_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_HILITE_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_SEP_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_DEAD_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_FONT_FACE	VARCHAR2(255)	Yes
TWGBGLUI_ACTIVITY_DATE	DATE	Yes
TWGBGLUI_SUBMENU_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_APP_PAGE_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_CSS_URL	VARCHAR2(255)	Yes
TWGBGLUI_HELP_URL	VARCHAR2(255)	Yes
TWGBGLUI_SCT_HOMEPAGE	VARCHAR2(255)	Yes
TWGBGLUI_ERROR_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_WARNING_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_EXIT_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_MENU_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_BACK_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_REQUIRED_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_HELP_CSS	VARCHAR2(255)	Yes

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGBGLUI_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
GETRULESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKGLUI	Use (select)
P_GENERATEFORM	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Rely On
P_GENERATEFORM	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
P_MODIFYPGGLOBALUI	Oracle Package Procedure	S10B80.WTAILOR.TWBKGLUI	Rely On
P_SAVEGLOBALUI	Oracle Package Procedure	S10B80.WTAILOR.TWBKGLUI	Use (Insert,update)Rely On
TWBKLIBS	Oracle Package	S10B80.WTAILOR	Use (select)
TWGBGLUI	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBGLUI

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:53:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor - Global Web User Interface settings table

Columns Comments for TWGBGLUI_SYSTEM_NAME (# 1)

Source Code Comments

Name of Web System, displayed in the header bar of each page when in standalone mode.

Columns Comments for TWGBGLUI_BODY_BG_COLOR (# 2)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_BODY_BG_IMAGE (# 3)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_HELP_IMAGE (# 4)

Source Code Comments

Global help graphic name.

Columns Comments for TWGBGLUI_MAIN_MENU_NAME (# 5)

Source Code Comments

Name of central menu page.

Columns Comments for TWGBGLUI_HEADER_IMAGE (# 6)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_HEADER_COLOR (# 7)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_TABLE_HEADER_COLOR (# 8)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_TABLE_DEFAULT_COLOR (# 9)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_TABLE_LABEL_COLOR (# 10)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_TABLE_HILITE_COLOR (# 11)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_TABLE_SEP_COLOR (# 12)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_TABLE_DEAD_COLOR (# 13)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_FONT_FACE (# 14)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBGLUI_ACTIVITY_DATE (# 15)

Source Code Comments

Date last modified.

Columns Comments for TWGBGLUI_SUBMENU_IMAGE (# 16)

Source Code Comments

Graphic to be displayed to the left of full-page menu items that point to a submenu.

Columns Comments for TWGBGLUI_APP_PAGE_IMAGE (# 17)

Source Code Comments

Graphic to be displayed to the left of full-page menu items that point to an application page.

Columns Comments for TWGBGLUI_CSS_URL (# 18)

Source Code Comments

CSS URL: This field indicates the physical address of the System Level cascading style sheet.

Columns Comments for TWGBGLUI_HELP_URL (# 19)

Source Code Comments

HELP_URL: This field indicates the URL of the System Level static HTML help page.

Columns Comments for TWGBGLUI_SCT_HOMEPAGE (# 20)

Source Code Comments

SCT Homepage: This field indicates the URL to be associated with the Powered By logo on the bottom of each web page.

Columns Comments for TWGBGLUI_ERROR_IMAGE (# 21)

Source Code Comments

Error Image: This field indicates the name of an image (twgbimag) to be used as the System Level Error Image.

Columns Comments for TWGBGLUI_WARNING_IMAGE (# 22)

Source Code Comments

Warning Image: This field indicates the name of an image (twgbimag) to be used as the System Level Warning Image.

Columns Comments for TWGBGLUI_EXIT_IMAGE (# 23)

Source Code Comments

Exit Image: This field indicates the name of an image (twgbimag) to be used as the System Level Exit Image.

Columns Comments for TWGBGLUI_MENU_IMAGE (# 24)

Source Code Comments

Menu Image: This field indicates the name of an image (twgbimag) to be used as the System Level Menu Image.

Columns Comments for TWGBGLUI_BACK_IMAGE (# 25)

Source Code Comments

Back Image: This field indicates the name of an image (twgbimag) to be used as the System Level Back Link Image.

Columns Comments for TWGBGLUI_REQUIRED_IMAGE (# 26)

Source Code Comments

Required Image: This field indicates the name of an image (twgbimag) to be used as the System Level Required Indicator Image.

Columns Comments for TWGBGLUI_HELP_CSS (# 27)

Source Code Comments

TWGBGLUI_HELP_CSS: The location of the system level CSS that controls the presentation of help.

Table TWGBIMAG

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGBIMAG_NAME	VARCHAR2(120)	No	*
TWGBIMAG_IMAGE_URL	VARCHAR2(120)	No
TWGBIMAG_IMAGE_WIDTH	NUMBER(0,0)	Yes
TWGBIMAG_IMAGE_HEIGHT	NUMBER(0,0)	Yes
TWGBIMAG_IMAGE_ON_URL	VARCHAR2(120)	Yes
TWGBIMAG_ALT	VARCHAR2(120)	Yes
TWGBIMAG_STATUS_BAR	VARCHAR2(120)	Yes
TWGBIMAG_COMMENT	VARCHAR2(255)	Yes
TWGBIMAG_ALIGN	VARCHAR2(30)	Yes
TWGBIMAG_BORDER	VARCHAR2(10)	Yes
TWGBIMAG_VSPACE	VARCHAR2(10)	Yes
TWGBIMAG_HSPACE	VARCHAR2(10)	Yes
TWGBIMAG_DESC	VARCHAR2(120)	Yes
TWGBIMAG_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGBIMAG	Unique	TWGBIMAG_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGBWMNU	SQL Table	S10B80.WTAILOR	Join
GETALLIMAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWMNU	Use (select)
GETALLIMAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMENU	Use (select)
GETALLIMAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMODU	Use (select)
GETALLIMAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWINF	Use (select)
GETALLIMAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKIMAG	Use (select)
GETALLIMAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKCHNL	Use (select)
GETALLIMAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWRUL	Use (select)
GETALLIMAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKGLUI	Use (select)
GETIMAGEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKFRMT	Use (select)
GETIMAGEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWBIS	Use (select)
GETIMAGEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKIMAG	Use (select)
IMAGE_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKWBIS	Rely On
P_DISPADMSMNUNON	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)
P_DISPADVMNUNON	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (select)
P_JSCRIPTPREVIEWIMAGEOPEN	Oracle Package Procedure	S10B80.WTAILOR.TWBKJSCR	Use (select)
P_MODIFYPGIMAGE	Oracle Package Procedure	S10B80.WTAILOR.TWBKIMAG	Rely On
P_SAVEIMAGE	Oracle Package Procedure	S10B80.WTAILOR.TWBKIMAG	Use (Insert,update,delete)Rely On
F_IMAGELINK	Oracle Package Function	S10B80.WTAILOR.TWBKFRMT	Rely On
F_PRINTIMAGE	Oracle Package Function	S10B80.WTAILOR.TWBKFRMT	Rely On
TWGBIMAG	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBIMAG	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBIMAG

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:38:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Image Information table

Columns Comments for TWGBIMAG_NAME (# 1)

Source Code Comments

Unique name for image.

Columns Comments for TWGBIMAG_IMAGE_URL (# 2)

Source Code Comments

URL of image (will be the "off" image when part of a javascript-dynamic image).

Columns Comments for TWGBIMAG_IMAGE_WIDTH (# 3)

Source Code Comments

Width of image in pixels.

Columns Comments for TWGBIMAG_IMAGE_HEIGHT (# 4)

Source Code Comments

Height of image in pixels.

Columns Comments for TWGBIMAG_IMAGE_ON_URL (# 5)

Source Code Comments

URL of image displayed when user's cursor moves over the "off" image.

Columns Comments for TWGBIMAG_ALT (# 6)

Source Code Comments

Alternate text to be associated with image.

Columns Comments for TWGBIMAG_STATUS_BAR (# 7)

Source Code Comments

Text to be displayed in window status bar when user's cursor moves over image area.

Columns Comments for TWGBIMAG_COMMENT (# 8)

Source Code Comments

Freeform comments about the image.

Columns Comments for TWGBIMAG_ALIGN (# 9)

Source Code Comments

Alignment of image.

Columns Comments for TWGBIMAG_BORDER (# 10)

Source Code Comments

If image is a link hotspot, width of border highlight.

Columns Comments for TWGBIMAG_VSPACE (# 11)

Source Code Comments

Amount of empty space (in pixels) to be displayed to top and bottom of image.

Columns Comments for TWGBIMAG_HSPACE (# 12)

Source Code Comments

Amount of empty space (in pixels) to be displayed to right and left of image.

Columns Comments for TWGBIMAG_DESC (# 13)

Source Code Comments

Description of image.

Columns Comments for TWGBIMAG_ACTIVITY_DATE (# 14)

Source Code Comments

Last date modified.

Table TWGBLDAP

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
TWGBLDAP_PROTOCOL	VARCHAR2(20)	No
TWGBLDAP_SEARCH_IND	VARCHAR2(1)	No
TWGBLDAP_ACTIVITY_DATE	DATE	No
TWGBLDAP_CERTIFICATE_LOCATION	VARCHAR2(255)	Yes
TWGBLDAP_CERTIFICATE_PASSWD	VARCHAR2(255)	Yes
TWGBLDAP_SSL_AUTH_MODE	VARCHAR2(20)	Yes
TWGBLDAP_SERVER_NAME	VARCHAR2(255)	Yes
TWGBLDAP_PORT	VARCHAR2(20)	Yes
TWGBLDAP_SEARCH_BASE	VARCHAR2(255)	Yes
TWGBLDAP_SEARCH_FLTR_SUFX	VARCHAR2(255)	Yes
TWGBLDAP_SEARCH_FLTR_PRFX	VARCHAR2(255)	Yes
TWGBLDAP_SEARCH_ATTRIBUTE	VARCHAR2(255)	Yes

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGBLDAP_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
GETLDAP	Oracle Package Cursor	S10B80.WTAILOR.TWBKLDAP	Use (select)
F_LDAPSEARCH	Oracle Package Function	S10B80.WTAILOR.TWBKLOGN	Rely On
F_VALIDATE_LDAP	Oracle Package Function	S10B80.WTAILOR.TWBKLOGN	Rely On
P_MODIFYPGLDAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKLDAP	Rely On
P_SAVELDAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKLDAP	Use (Insert,update)Rely On
TWBKLIBS	Oracle Package	S10B80.WTAILOR	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBLDAP

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:34:000	04/02/2008 21:18:26:000

Source Code Comments

This table will store LDAP specific parameters.

Columns Comments for TWGBLDAP_PROTOCOL (# 1)

Source Code Comments

LDAP PROTOCOL: This field indicates current protocol being used for self service authentication

Columns Comments for TWGBLDAP_SEARCH_IND (# 2)

Source Code Comments

LDAP Search Indicator: This indicator specifies if anonymous search will be performed

Columns Comments for TWGBLDAP_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: This indicates date when this table was created or updated

Columns Comments for TWGBLDAP_CERTIFICATE_LOCATION (# 4)

Source Code Comments

LDAP Wallet Location: This indicates wallet location for SSL
Authentication

Columns Comments for TWGBLDAP_CERTIFICATE_PASSWD (# 5)

Source Code Comments

LDAP Wallet Password: This indicates Wallet Password for LDAP Authentication

Columns Comments for TWGBLDAP_SSL_AUTH_MODE (# 6)

Source Code Comments

LDAP Search Indicator: This indicates SSL authentication mode. Valid values are 1,2 or 3.

Columns Comments for TWGBLDAP_SERVER_NAME (# 7)

Source Code Comments

LDAP Server Name: This indicates location of LDAP server

Columns Comments for TWGBLDAP_PORT (# 8)

Source Code Comments

LDAP Server Port: This This indicates location of LDAP server port

Columns Comments for TWGBLDAP_SEARCH_BASE (# 9)

Source Code Comments

LDAP Base Search Directory : This indicates base from which LDAP search should start

Columns Comments for TWGBLDAP_SEARCH_FLTR_SUFX (# 10)

Source Code Comments

LDAP Search Indicator: This indicates search filter suffix to be used in search

Columns Comments for TWGBLDAP_SEARCH_FLTR_PRFX (# 11)

Source Code Comments

LDAP Search Indicator: This indicates search filter prefix to be used in search

Columns Comments for TWGBLDAP_SEARCH_ATTRIBUTE (# 12)

Source Code Comments

LDAP Search Indicator: This indicates attribute in LDAP which will store banner id

Table TWGBOVRR

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGBOVRR_CONDITION	VARCHAR2(120)	No	*
TWGBOVRR_REPLACE_VALUE	VARCHAR2(120)	No
TWGBOVRR_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGBOVRR	Unique	TWGBOVRR_CONDITION

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GETOVERRIDEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKOVRR	Use (select)
OVERRIDE_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKOVRR	Rely On
F_GETOVERRIDE	Oracle Package Function	S10B80.WTAILOR.TWBKSLIB	Use (select)
P_DISPALLOVERRIDES	Oracle Package Procedure	S10B80.WTAILOR.TWBKOVRR	Use (select)
P_FORWARDFROMBANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (select)
P_MODIFYPGOVERRIDE	Oracle Package Procedure	S10B80.WTAILOR.TWBKOVRR	Rely On
P_SAVEOVERRIDE	Oracle Package Procedure	S10B80.WTAILOR.TWBKOVRR	Use (Insert,update,delete)
P_SECURITYERRORPAGE	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBOVRR	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBOVRR

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:14:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor - Web Overrides table

Columns Comments for TWGBOVRR_CONDITION (# 1)

Source Code Comments

Condition that must exist for override to occur.

Columns Comments for TWGBOVRR_REPLACE_VALUE (# 2)

Source Code Comments

Value that replaces original when override condition is detected.

Columns Comments for TWGBOVRR_ACTIVITY_DATE (# 3)

Source Code Comments

Date last modified.

Table TWGBPARM

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGBPARM_PARAM_NAME	VARCHAR2(30)	No	*
TWGBPARM_PARAM_VALUE	VARCHAR2(255)	No
TWGBPARM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGBPARM	Unique	TWGBPARM_PARAM_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GETPARAMC	Oracle Package Cursor	S10B80.WTAILOR.TWBKPARM	Use (select)
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Rely On
CC_USE_ADDR_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
CC_USE_ADDR_CODE	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
PARAM_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKPARM	Rely On
F_FETCHPARAM	Oracle Package Function	S10B80.WTAILOR.TWBKSRCH	Use (select)Rely On
F_GETBASEURL	Oracle Package Function	S10B80.BANINST1.BWGKIPAY	Use (select)
F_GETBASEURL	Oracle Package Function	S10B80.BANINST1.BWGKTPAY	Use (select)
F_GET_MAINPIDM	Oracle Package Function	S10B80.WTAILOR.TWBKLOGN	Rely On
F_SELECTNULLDISPVALUE	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_CCPAYMENTVERIFICATION	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CCPAYMENTVERIFICATION	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CC_PAYMENT_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CREDIT_CARD_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_DISPALLPARAMS	Oracle Package Procedure	S10B80.WTAILOR.TWBKPARM	Use (select)
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_FORWARDFROMBANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (select)
P_FORWARDTOOTHER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (select)
P_IDM_LOGIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_MODIFYPGPARAM	Oracle Package Procedure	S10B80.WTAILOR.TWBKPARM	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_RETURNTOBANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (select)
P_SAVEPARAM	Oracle Package Procedure	S10B80.WTAILOR.TWBKPARM	Use (Insert,update,delete)
F_FETCHWTPARAM	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
F_FORMSELECTOPTION	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
F_GETBASEURL	Oracle Package Function	S10B80.BANINST1.BWGKEPAY	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBPARM	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBPARM

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:54:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor - Web Parameters table

Columns Comments for TWGBPARM_PARAM_NAME (# 1)

Source Code Comments

Name of global parameter used in WebTailor.

Columns Comments for TWGBPARM_PARAM_VALUE (# 2)

Source Code Comments

Value of parameter.

Columns Comments for TWGBPARM_ACTIVITY_DATE (# 3)

Source Code Comments

Date last modified.

Table TWGBRETC

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGBRETC_RETURN_CDE	VARCHAR2(1)	No	*
TWGBRETC_RETURN_LOCATION	VARCHAR2(120)	No
TWGBRETC_FRAMESET_IND	VARCHAR2(1)	No
TWGBRETC_MENU_IND	VARCHAR2(1)	No
TWGBRETC_OVR_STARTPAGE	VARCHAR2(120)	Yes
TWGBRETC_DESC	VARCHAR2(120)	No
TWGBRETC_LOGIN_FORWARD_IND	VARCHAR2(1)	No
TWGBRETC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGBRETC	Unique	TWGBRETC_RETURN_CDE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRRETC	SQL Table	S10B80.WTAILOR	Refer (no action)
GETALLRETURNLOCSC	Oracle Package Cursor	S10B80.WTAILOR.TWBKRETC	Use (select)
GETRETURNLOCC	Oracle Package Cursor	S10B80.WTAILOR.TWBKRETC	Use (select)
P_FIRSTMENU	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)
P_MODIFYPGRETURNLOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKRETC	Rely On
P_SAVERETURNLOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKRETC	Use (Insert,update,delete)Rely On
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBRETC	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBRETC

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:07:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor Login Return Code base table

Columns Comments for TWGBRETC_RETURN_CDE (# 1)

Source Code Comments

Columns Comments for TWGBRETC_RETURN_LOCATION (# 2)

Source Code Comments

Location to return to after successful login, either a valid frameset or web menu or procedure.

Columns Comments for TWGBRETC_FRAMESET_IND (# 3)

Source Code Comments

Indicates whether or not return location is a frameset. Y = frameset, N = web menu or procedure.

Columns Comments for TWGBRETC_MENU_IND (# 4)

Source Code Comments

Indicates whether or not return location is a web menu. Y = menu, N = frameset or normal web procedure.

Columns Comments for TWGBRETC_OVR_STARTPAGE (# 5)

Source Code Comments

Web menu or procedure name to override default start page of location frameset.

Columns Comments for TWGBRETC_DESC (# 6)

Source Code Comments

Short description of return location.

Columns Comments for TWGBRETC_LOGIN_FORWARD_IND (# 7)

Source Code Comments

"Y" if login is to be forwarded to a window without a frameset.

Columns Comments for TWGBRETC_ACTIVITY_DATE (# 8)

Source Code Comments

Date last modified.

Table TWGBTLBR

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGBTLBR_NAME	VARCHAR2(120)	No	*
TWGBTLBR_DESC	VARCHAR2(120)	No
TWGBTLBR_WIDTH	VARCHAR2(10)	Yes
TWGBTLBR_MARGINWIDTH	NUMBER(8,0)	Yes
TWGBTLBR_MARGINHEIGHT	NUMBER(8,0)	Yes
TWGBTLBR_SCROLLING	VARCHAR2(10)	Yes
TWGBTLBR_ALIGN	VARCHAR2(30)	Yes
TWGBTLBR_BGCOLOR	VARCHAR2(6)	Yes
TWGBTLBR_BG_IMAGE	VARCHAR2(120)	Yes
TWGBTLBR_COLORBAR_WIDTH	VARCHAR2(10)	Yes
TWGBTLBR_COLORBAR_BGCOLOR	VARCHAR2(120)	Yes
TWGBTLBR_COLORBAR_BG_IMAGE	VARCHAR2(120)	Yes
TWGBTLBR_TEXT_COLOR	VARCHAR2(6)	Yes
TWGBTLBR_LINK_COLOR	VARCHAR2(6)	Yes
TWGBTLBR_ALINK_COLOR	VARCHAR2(6)	Yes
TWGBTLBR_VLINK_COLOR	VARCHAR2(6)	Yes
TWGBTLBR_URL	VARCHAR2(120)	Yes
TWGBTLBR_URL_DB_IND	VARCHAR2(1)	Yes
TWGBTLBR_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGBTLBR	Unique	TWGBTLBR_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRTLBR	SQL Table	S10B80.WTAILOR	Refer (no action)
GETTOOLBARC	Oracle Package Cursor	S10B80.WTAILOR.TWBKTLBR	Use (select)Rely On
P_CREATECOLORBAR	Oracle Package Procedure	S10B80.WTAILOR.TWBKTLBR	Rely On
P_CREATETOOLBAR	Oracle Package Procedure	S10B80.WTAILOR.TWBKTLBR	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBTLBR	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBTLBR

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:46:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Navigation Bar Information table

Columns Comments for TWGBTLBR_NAME (# 1)

Source Code Comments

Name of the navigation bar - associated with a functional area of the system.

Columns Comments for TWGBTLBR_DESC (# 2)

Source Code Comments

Description of the navigation bar.

Columns Comments for TWGBTLBR_WIDTH (# 3)

Source Code Comments

Width of the navigation bar frame.

Columns Comments for TWGBTLBR_MARGINWIDTH (# 4)

Source Code Comments

Width of margin within navigation bar.

Columns Comments for TWGBTLBR_MARGINHEIGHT (# 5)

Source Code Comments

Height of margin within navigation bar.

Columns Comments for TWGBTLBR_SCROLLING (# 6)

Source Code Comments

Indicates whether or not the navigation bar scrolls: 'AUTO', 'NO', or 'YES'.

Columns Comments for TWGBTLBR_ALIGN (# 7)

Source Code Comments

Alignment of text within navigation bar.

Columns Comments for TWGBTLBR_BGCOLOR (# 8)

Source Code Comments

Background color of navigation bar - RGB hexadecimal value representing color.

Columns Comments for TWGBTLBR_BG_IMAGE (# 9)

Source Code Comments

Background image to be used for navigation bar.

Columns Comments for TWGBTLBR_COLORBAR_WIDTH (# 10)

Source Code Comments

Width of the color bar between the navigation bar and main page.

Columns Comments for TWGBTLBR_COLORBAR_BGCOLOR (# 11)

Source Code Comments

Color (RGB hexadecimal value) of colorbar separating navigation bar and main page.

Columns Comments for TWGBTLBR_COLORBAR_BG_IMAGE (# 12)

Source Code Comments

Background image for colorbar separating navigation bar and main page.

Columns Comments for TWGBTLBR_TEXT_COLOR (# 13)

Source Code Comments

Color of normal text on the page - 6 character RBG hexadecimal code.

Columns Comments for TWGBTLBR_LINK_COLOR (# 14)

Source Code Comments

Color of unvisited links on the page - 6 character RBG hexadecimal code.

Columns Comments for TWGBTLBR_ALINK_COLOR (# 15)

Source Code Comments

Color of active links (while user clicks on them) on the page - 6 character RBG hexadecimal code.

Columns Comments for TWGBTLBR_VLINK_COLOR (# 16)

Source Code Comments

Color of visited links on the page - 6 character RBG hexadecimal code.

Columns Comments for TWGBTLBR_URL (# 17)

Source Code Comments

If navbar is not generated from TWGRTLBR elements, this URL is used.

Columns Comments for TWGBTLBR_URL_DB_IND (# 18)

Source Code Comments

If navbar is a URL which references a DB procedure, this is "Y".

Columns Comments for TWGBTLBR_ACTIVITY_DATE (# 19)

Source Code Comments

Date last modified.

Table TWGBWMNU

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
TWGBWMNU_NAME	VARCHAR2(120)	No	*
TWGBWMNU_DESC	VARCHAR2(120)	No
TWGBWMNU_PAGE_TITLE	VARCHAR2(120)	Yes
TWGBWMNU_HEADER	VARCHAR2(120)	Yes
TWGBWMNU_HEADER_IMAGE	VARCHAR2(120)	Yes		*
TWGBWMNU_SUBTITLE_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_TOP_RIGHT_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_TOP_LEFT_IMAGE	VARCHAR2(120)	Yes		*
TWGBWMNU_BULLET_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_SEP_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_L_MARGIN_WIDTH	VARCHAR2(10)	Yes
TWGBWMNU_MAIN_TEXT_WIDTH	VARCHAR2(10)	Yes
TWGBWMNU_R_MARGIN_WIDTH	VARCHAR2(10)	Yes
TWGBWMNU_HELP_URL	VARCHAR2(120)	Yes
TWGBWMNU_HELP_LINK	VARCHAR2(120)	Yes
TWGBWMNU_HELP_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_BGCOLOR	VARCHAR2(6)	Yes
TWGBWMNU_BG_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_COMMENT	VARCHAR2(255)	Yes
TWGBWMNU_TEXT_COLOR	VARCHAR2(6)	Yes
TWGBWMNU_LINK_COLOR	VARCHAR2(6)	Yes
TWGBWMNU_ALINK_COLOR	VARCHAR2(6)	Yes
TWGBWMNU_VLINK_COLOR	VARCHAR2(6)	Yes
TWGBWMNU_BACK_URL	VARCHAR2(120)	Yes
TWGBWMNU_BACK_LINK	VARCHAR2(120)	Yes
TWGBWMNU_BACK_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_BACK_MENU_IND	VARCHAR2(1)	No
TWGBWMNU_MODULE	VARCHAR2(3)	Yes
TWGBWMNU_ENABLED_IND	VARCHAR2(1)	No
TWGBWMNU_INSECURE_ALLOWED_IND	VARCHAR2(1)	No
TWGBWMNU_ACTIVITY_DATE	DATE	No
TWGBWMNU_CSS_URL	VARCHAR2(255)	Yes
TWGBWMNU_MAP_TITLE	VARCHAR2(120)	Yes
TWGBWMNU_CACHE_OVERRIDE	VARCHAR2(1)	Yes
TWGBWMNU_EXIT_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_MENU_IMAGE	VARCHAR2(120)	Yes
TWGBWMNU_SOURCE_IND	VARCHAR2(1)	No	*
TWGBWMNU_HELP_CSS	VARCHAR2(255)	Yes
TWGBWMNU_ADM_ACCESS_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
TWGBWMNU_TOP_LEFT_IMAGE	TWGBIMAG_NAME	TWGBIMAG
TWGBWMNU_HEADER_IMAGE	TWGBIMAG_NAME	TWGBIMAG

Index

Index Name	Index Type	Column Name
PK_TWGBWMNU	Unique	TWGBWMNU_NAME
PK_TWGBWMNU	Unique	TWGBWMNU_SOURCE_IND

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRINFO	SQL Table	S10B80.WTAILOR	Refer (no action)
TWGRMENU	SQL Table	S10B80.WTAILOR	Refer (no action)
TWGBWMNU_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
GETALLMAINC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWMNU	Use (select)
GETALLPAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWRUL	Use (select)
GETALLPAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKGLUI	Use (select)
GETMAINC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWMNU	Use (select)
GETMENUC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMENU	Use (select)
P_CREATEMENURECORD	Oracle Package Procedure	S10B80.WTAILOR.TWBKWINF	Use (Insert,select)
MENU_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKMENU	Rely On
MENU_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKWINF	Rely On
F_BOTTOMLINKSEXIST	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
F_GET_ADMINPATH	Oracle Package Function	S10B80.WTAILOR.TWBKFRMT	Rely On
F_GET_MODULE	Oracle Package Function	S10B80.WTAILOR.TWBKFRMT	Rely On
GETBACKLINK	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
GETMENUC	Oracle Package Cursor	S10B80.WTAILOR.TWBKLIBS	Use (select)Rely On
P_ADDFROMSEARCH	Oracle Package Procedure	S10B80.BANINST1.BWCKCOMS	Rely On
P_CLOSEDOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_COPYTOLOCALMENUITEM	Oracle Package Procedure	S10B80.WTAILOR.TWBKMENU	Use (Insert,select)
P_COPYTOLOCALPGWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Use (Insert,select)
P_CREATETOOLBAR	Oracle Package Procedure	S10B80.WTAILOR.TWBKTLBR	Use (select)
P_DISPADMSMNUNON	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)
P_DISPADVMNUNON	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (select)
P_DISPCHGCRSEOPT	Oracle Package Procedure	S10B80.BANINST1.BWCKSAMS	Rely On
P_FACSCHED	Oracle Package Procedure	S10B80.BANINST1.BWLKIFAC	Rely On
P_FACSCHED	Oracle Package Procedure	S10B80.BANINST1.BWLKIFAC	Use (select)
P_GENMENU	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_INFO_TEXT_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.VIEWINFO	Rely On
P_INFO_TEXT_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.CMPRINFO	Rely On
P_MAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKLIST	Use (select)
P_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.VIEWMENU	Use (select)Rely On
P_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.CMPRMENU	Rely On
P_MODIFYPGMODULE	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODU	Use (select)
P_MODIFYPGRETURNLOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKRETC	Use (select)
P_MODIFYPGWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Use (select)Rely On
P_OPENDOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_PRINTMENU	Oracle Package Procedure	S10B80.WTAILOR.TWBKFRMT	Rely On
P_REGSRESULT	Oracle Package Procedure	S10B80.BANINST1.BWCKSAMS	Rely On
P_REORDERPGINFOTEXT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWINF	Rely On
P_REORDERPGMENUITEM	Oracle Package Procedure	S10B80.WTAILOR.TWBKMENU	Rely On
P_SAVEWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Use (Insert,update,delete)Rely On
P_SHOWRESULTS	Oracle Package Procedure	S10B80.WTAILOR.TWBKSRCH	Use (select)
P_TEST	Oracle Package Procedure	S10B80.WTAILOR.TESTENV	Rely On
P_WEB_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.CMPRWMNU	Use (select)Rely On
F_PROCEDUREENABLED	Oracle Package Function	S10B80.BANINST1.BWPKOLIB	Rely On
F_VALIDLINK	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
F_VALIDROLE	Oracle Package Function	S10B80.WTAILOR.TWBKSLIB	Rely On
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
TWGBWMNU	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBWMNU	SQL Index	S10B80.WTAILOR	Rely On
TWGBIMAG	SQL Table	S10B80.WTAILOR	Join
TW_TWGBWMNU_AUDIT	SQL Trigger	S10B80.WTAILOR	Fire (Insert,update,delete,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBWMNU

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:04:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor Main Web Page Settings table

Columns Comments for TWGBWMNU_NAME (# 1)

Source Code Comments

Name of the web page - should match the name of the package.procedure that generates the HTML.

Columns Comments for TWGBWMNU_DESC (# 2)

Source Code Comments

Description of the web page.

Columns Comments for TWGBWMNU_PAGE_TITLE (# 3)

Source Code Comments

HTML title of the page - appears in browser window title area.

Columns Comments for TWGBWMNU_HEADER (# 4)

Source Code Comments

Page header, if no title graphic exists.

Columns Comments for TWGBWMNU_HEADER_IMAGE (# 5)

Source Code Comments

Name of main header graphic (e.g. stylized text) for the page.

Columns Comments for TWGBWMNU_SUBTITLE_IMAGE (# 6)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_TOP_RIGHT_IMAGE (# 7)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_TOP_LEFT_IMAGE (# 8)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_BULLET_IMAGE (# 9)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_SEP_IMAGE (# 10)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_L_MARGIN_WIDTH (# 11)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_MAIN_TEXT_WIDTH (# 12)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_R_MARGIN_WIDTH (# 13)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_HELP_URL (# 14)

Source Code Comments

URL of help page associated with this page.

Columns Comments for TWGBWMNU_HELP_LINK (# 15)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_HELP_IMAGE (# 16)

Source Code Comments

Image for hyperlink to help page associated with this page.

Columns Comments for TWGBWMNU_BGCOLOR (# 17)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_BG_IMAGE (# 18)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_COMMENT (# 19)

Source Code Comments

Description of page - used to identify page in select boxes.

Columns Comments for TWGBWMNU_TEXT_COLOR (# 20)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_LINK_COLOR (# 21)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_ALINK_COLOR (# 22)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_VLINK_COLOR (# 23)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWMNU_BACK_URL (# 24)

Source Code Comments

URL of Back link for the page.

Columns Comments for TWGBWMNU_BACK_LINK (# 25)

Source Code Comments

Text for the Back link.

Columns Comments for TWGBWMNU_BACK_IMAGE (# 26)

Source Code Comments

Image name to be used as Back link, instead of text.

Columns Comments for TWGBWMNU_BACK_MENU_IND (# 27)

Source Code Comments

Indicates whether or not the Back link URL is a database procedure - "Y" for yes, "N" for no.

Columns Comments for TWGBWMNU_MODULE (# 28)

Source Code Comments

Web system that this page belongs to.

Columns Comments for TWGBWMNU_ENABLED_IND (# 29)

Source Code Comments

"Y" if web access is currently allowed to this procedure or menu.

Columns Comments for TWGBWMNU_INSECURE_ALLOWED_IND (# 30)

Source Code Comments

"Y" if users may access this menu or procedure without authentication.

Columns Comments for TWGBWMNU_ACTIVITY_DATE (# 31)

Source Code Comments

Date last modified.

Columns Comments for TWGBWMNU_CSS_URL (# 32)

Source Code Comments

CSS URL: This field indicates the physical address of the Page Level cascading style sheet.

Columns Comments for TWGBWMNU_MAP_TITLE (# 33)

Source Code Comments

Map Title: This field indicates the title of the map created when a menu is generated as a series of links on a page.

Columns Comments for TWGBWMNU_CACHE_OVERRIDE (# 34)

Source Code Comments

Cache Override: This field indicates the Page Level setting to control web page caching.

Columns Comments for TWGBWMNU_EXIT_IMAGE (# 35)

Source Code Comments

Exit Image: This field indicates the name of an image (twgbimag) to be used as the Page Level Exit Image.

Columns Comments for TWGBWMNU_MENU_IMAGE (# 36)

Source Code Comments

Menu Image: This field indicates the name of an image (twgbimag) to be used as the Page Level Menu Image.

Columns Comments for TWGBWMNU_SOURCE_IND (# 37)

Source Code Comments

Source Indicator: This field indicates if the row is (B)aseline or (L)ocal. The source_ind column has a default value of B.

Columns Comments for TWGBWMNU_HELP_CSS (# 38)

Source Code Comments

TWGBWMNU_HELP_CSS:The location of page level CSS that controls presentation of help

Columns Comments for TWGBWMNU_ADM_ACCESS_IND (# 39)

Source Code Comments

This field indicates if the web page is Admin scured for VBS

Table TWGBWRUL

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
TWGBWRUL_TIME_OUT	NUMBER(0,0)	No
TWGBWRUL_CGIBIN_DIR	VARCHAR2(60)	No
TWGBWRUL_DATE_FMT	VARCHAR2(30)	No
TWGBWRUL_TIME_FMT	VARCHAR2(30)	No
TWGBWRUL_LOGIN_ATTEMPTS	NUMBER(2,0)	No
TWGBWRUL_ACTIVITY_DATE	DATE	No
TWGBWRUL_ERROR_GIF	VARCHAR2(60)	Yes
TWGBWRUL_WARNING_GIF	VARCHAR2(60)	Yes
TWGBWRUL_START_FRAMESET	VARCHAR2(120)	Yes
TWGBWRUL_DISP_USAGE_IND	VARCHAR2(1)	No
TWGBWRUL_EXIT_GIF	VARCHAR2(60)	Yes
TWGBWRUL_PIN_EXP_DAYS	NUMBER(4,0)	Yes
TWGBWRUL_JAVA_CLASSPATH	VARCHAR2(255)	Yes
TWGBWRUL_DISP_ADMIN_DESC_IND	VARCHAR2(1)	No
TWGBWRUL_ASRC_CODE	VARCHAR2(4)	Yes
TWGBWRUL_DISP_DEAD_IND	VARCHAR2(1)	No
TWGBWRUL_CACHE_IND	VARCHAR2(1)	No
TWGBWRUL_HTTP_REDIRECT_IND	VARCHAR2(1)	No
TWGBWRUL_START_PAGE	VARCHAR2(120)	Yes
TWGBWRUL_START_PAGE_MENU_IND	VARCHAR2(1)	No
TWGBWRUL_DATE_INPUT_FMT	VARCHAR2(30)	No
TWGBWRUL_DTD_TYPE	VARCHAR2(255)	Yes
TWGBWRUL_DTD_FPI	VARCHAR2(255)	Yes
TWGBWRUL_DTD_URL	VARCHAR2(255)	Yes
TWGBWRUL_LANGUAGE	VARCHAR2(5)	Yes
TWGBWRUL_CGIBIN_DIR_ADM	VARCHAR2(255)	No

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGBWRUL_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
GETALLMAINC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWMNU	Use (select)
GETALLPAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWRUL	Rely On
GETRULESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWRUL	Use (select)
GETTWGBRULESC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
TIME_OUT	Oracle Package Variable	S10B80.BANINST1.BWLKINCG	Rely On
GET_DATE_FMT	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Rely On
GET_DATE_FMT	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Use (select)
DISPLAY_ENV	Oracle Package Procedure	S10B80.WTAILOR.TESTLESV	Use (select)Rely On
P_CERTIFICATIONDRIVER	Oracle Package Procedure	S10B80.BANINST1.BWPKTESB	Use (select)
P_FACFINGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFFGD	Rely On
P_FACFINGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFFGD	Use (select)
P_FACINCMPGRDFINAL	Oracle Package Procedure	S10B80.BANINST1.BWLKINCG	Use (select)
P_FACINCMPGRDSUM	Oracle Package Procedure	S10B80.BANINST1.BWLKINCG	Use (select)
P_FACMIDGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFMGD	Rely On
P_FACMIDGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFMGD	Use (select)
P_GET_DEANSLIST_STRING	Oracle Package Procedure	S10B80.BANINST1.SCHANNL	Rely On
P_MODIFYPGMODULE	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODU	Use (select)Rely On
P_MODIFYPGRETURNLOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKRETC	Use (select)
P_MODIFYPGWEBRULES	Oracle Package Procedure	S10B80.WTAILOR.TWBKWRUL	Rely On
P_MODIFYPGWEBRULES	Oracle Package Procedure	S10B80.BANINST1.BWAKWRUL	Rely On
P_SAVEWEBRULES	Oracle Package Procedure	S10B80.WTAILOR.TWBKWRUL	Use (Insert,update)Rely On
P_SAVEWEBRULES	Oracle Package Procedure	S10B80.BANINST1.BWAKWRUL	Rely On
P_SAVEWEBRULES	Oracle Package Procedure	S10B80.BANINST1.BWAKWRUL	Use (update)Rely On
P_VALIDATE_PIN	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Use (select)
F_GET_DATE_FMT	Oracle Package Function	S10B80.BANINST1.SREFCUR	Rely On
F_GET_DATE_FMT	Oracle Package Function	S10B80.BANINST1.SREFCUR	Use (select)
F_PINNEXTEXPDATE	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Use (select)
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
GET_DATE_FMT	Oracle Package Function	S10B80.BANINST1.BWCKSMMT	Rely On
GET_DATE_FMT	Oracle Package Function	S10B80.BANINST1.BWCKSMMT	Use (select)
GET_TIME_FMT	Oracle Package Function	S10B80.BANINST1.BWCKSMMT	Rely On
GET_TIME_FMT	Oracle Package Function	S10B80.BANINST1.BWCKSMMT	Use (select)
TWBKLIBS	Oracle Package	S10B80.WTAILOR	Use (select)
TWGBWRUL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBWRUL

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:52:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor - Web Rules table

Columns Comments for TWGBWRUL_TIME_OUT (# 1)

Source Code Comments

Period of incactivity on the web which will cause a timeout (in minutes).

Columns Comments for TWGBWRUL_CGIBIN_DIR (# 2)

Source Code Comments

Relative URL of the cgi-bin directory on the web server.

Columns Comments for TWGBWRUL_DATE_FMT (# 3)

Source Code Comments

Default Oracle date format for display of dates on the web.

Columns Comments for TWGBWRUL_TIME_FMT (# 4)

Source Code Comments

Default time format for the web.

Columns Comments for TWGBWRUL_LOGIN_ATTEMPTS (# 5)

Source Code Comments

Number of unsuccessful login attempts for the same userid before the account is disabled.

Columns Comments for TWGBWRUL_ACTIVITY_DATE (# 6)

Source Code Comments

Date last modified.

Columns Comments for TWGBWRUL_ERROR_GIF (# 7)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWRUL_WARNING_GIF (# 8)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWRUL_START_FRAMESET (# 9)

Source Code Comments

Name of frameset to load after successful logon.

Columns Comments for TWGBWRUL_DISP_USAGE_IND (# 10)

Source Code Comments

Indicates whether or not a usage agreement statement is displayed after first login.

Columns Comments for TWGBWRUL_EXIT_GIF (# 11)

Source Code Comments

This column is being obsoleted

Columns Comments for TWGBWRUL_PIN_EXP_DAYS (# 12)

Source Code Comments

Number of days a user PIN remains valid.

Columns Comments for TWGBWRUL_JAVA_CLASSPATH (# 13)

Source Code Comments

Java classpath for web system.

Columns Comments for TWGBWRUL_DISP_ADMIN_DESC_IND (# 14)

Source Code Comments

Indicates whether or not the descriptive name of web tailor objects are displayed on the web tailor administrative web pages.

Columns Comments for TWGBWRUL_ASRC_CODE (# 15)

Source Code Comments

Address source code information.

Columns Comments for TWGBWRUL_DISP_DEAD_IND (# 16)

Source Code Comments

Indicate whether information for a deceased person should appear on the Web.

Columns Comments for TWGBWRUL_CACHE_IND (# 17)

Source Code Comments

Indicates whether web page caching is enabled for the entire system.

Columns Comments for TWGBWRUL_HTTP_REDIRECT_IND (# 18)

Source Code Comments

If "Y", redirects with owa_util.redirect_url. Otherwise uses an HTML META refresh tag.

Columns Comments for TWGBWRUL_START_PAGE (# 19)

Source Code Comments

Page users will see directly after web login.

Columns Comments for TWGBWRUL_START_PAGE_MENU_IND (# 20)

Source Code Comments

Indicates whether or not the start page is a WebTailor-generated menu.

Columns Comments for TWGBWRUL_DATE_INPUT_FMT (# 21)

Source Code Comments

Default Oracle date format mask for input of dates on the web.

Columns Comments for TWGBWRUL_DTD_TYPE (# 22)

Source Code Comments

DTD Type: This field indicates Document Type Definition Type used to define the HTML Level and type for Banner web pages.

Columns Comments for TWGBWRUL_DTD_FPI (# 23)

Source Code Comments

DTD FPI: This field indicates Document Type Definition Formal Public Identifier for Banner Web Pages.

Columns Comments for TWGBWRUL_DTD_URL (# 24)

Source Code Comments

DTD URL: This field indicates Document Type Definition URL where the actual DTD can be found.

Columns Comments for TWGBWRUL_LANGUAGE (# 25)

Source Code Comments

Language: This field indicates the language used on the Banner Web pages. Values should conform to ISO 639 standards.

Table TWGBWSES

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGBWSES_PIDM	NUMBER(8,0)	No	*
TWGBWSES_WEBID	VARCHAR2(6)	Yes
TWGBWSES_LAST_ACCESS	DATE	Yes
TWGBWSES_LOGIN_ATTEMPTS	NUMBER(2,0)	Yes
TWGBWSES_LOGIN_REQ_IND	VARCHAR2(1)	Yes
TWGBWSES_SESSIONID	NUMBER(0,0)	Yes
TWGBWSES_PREV_WEBID	VARCHAR2(6)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGBWSES	Unique	TWGBWSES_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGBWSES_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
P_AUTHENTICATE_BANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKLOGN	Use (Insert,update)Rely On
P_AUTHENTICATE_LDAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKLOGN	Use (Insert,update)Rely On
P_PROCESS_IDM	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (Insert,delete,select)Rely On
P_PROCSECURITYPIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (Insert,update)
P_RECORD_LOGIN_ATTEMPT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (Insert,update)
P_VALLOGIN	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Rely On
P_VALLOGIN	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (Insert,update)
TWGBWSES_REC	Oracle Package Variable	S10B80.BANINST1.BWSKFREG	Rely On
GETSESSIONC	Oracle Package Cursor	S10B80.WTAILOR.TWBKLIBS	Use (select)Rely On
TWGBWSES_ROW_BY_PIDM_C	Oracle Package Cursor	S10B80.WTAILOR.TWBKSELS	Use (select)Rely On
P_CHECKALTPIN	Oracle Package Procedure	S10B80.BANINST1.BWSKFREG	Use (update)
P_CHECKALTPIN1	Oracle Package Procedure	S10B80.BANINST1.BWSKFREG	Use (update)
P_CREATETOOLBAR	Oracle Package Procedure	S10B80.WTAILOR.TWBKTLBR	Use (update)
P_FIRSTMENU	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (update)
P_FORWARDFROMBANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (Insert,update,select)Rely On
P_FORWARDTOOTHER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (select)
P_INSERT_TWGBWSES	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODS	Use (Insert)Rely On
P_LOGOUT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (update)
P_PROCLOGINNON	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (Insert,update)Rely On
P_REGISTERNOW	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_REGISTERNOW	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (Insert,update)Rely On
P_RETURNFROMOTHER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (select)Rely On
P_RETURNTOBANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (update,select)
P_UPDATE_TWGBWSES	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODS	Use (update)Rely On
P_VALIDATE_SESSION_ID	Oracle Package Procedure	S10B80.WTAILOR.TWBKFUNC	Rely On
P_VALLOGIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_VR_ACCT_REVIEW_BALANCE	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_ADD_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_ADM_APPT_OPER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_MATERIALS_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_ORIENTATION_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_REQUEST_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ALL_REQ_SPEAK_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_APPLY_CC_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_ASSESS_FEES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_AUTODROP_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_AW_MULTI_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_AW_SINGLE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_BIL_INFO_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BIL_OPTIONS_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BUILD_BAD_CC_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_EXPIR_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_PAYMENT_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_ST_ACCOUNT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BYPASS_TERM_CHECKS	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CHANGE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHANGE_PIN_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHECK_CLAS_AVAIL	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CHECK_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_CHECK_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHECK_OPEN_SECTIONS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CHECK_OPEN_SECTIONS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CONFIRM_NEEDED_CHECK	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_NEEDED_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONTINUE_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CREDIT_HOURS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CRN_EXCEPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CRN_LIST	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CRN_LIST_MULTI_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CRN_LIST_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_DAY_TIME_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_DROP_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_DROP_CLASS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_END_CALL	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_END_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_END_INFC_TABLE	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_EXCEPTION	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_FIN_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_MATERIALS_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_PROGRAM_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_REQUEST_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_GEN_GRDE_INFO	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GET_AIDY_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_APPL_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_BILLING_DEADLN_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_DAY_TIME	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_GET_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_GET_FIN_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_GET_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRLAP	Rely On
P_VR_GET_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_OFFER_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_PROGRESS_DATA	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GET_TERM_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GIVE_DECISION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_GIVE_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_GRADE_MODE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_GRDE_INFO_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GRDE_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GRDE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_HOLD_OPER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_HOLD_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_INVALID_TERM	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_LIKE_TO_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_LIST_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_LIST_CLASSES	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_LIST_CURRENT_CLASSES	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_LIST_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_LIST_MORE_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_MAIN_MENU_RETURN	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MAX_TRIES_EXCEEDED	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MENU_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MIF_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MORE_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_MORE_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_MULTI_TERMS	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_NOAPP_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_NO_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_NO_HOLD_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_PMPT_ST_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_ADM_APPL_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_BAD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_EXPDATE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_EXPDATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_CC_NUMBER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_CC_TYPE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_DETAIL_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_DIFF_AMOUNT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXPIR_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXP_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MISSING_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MORE_REQ	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MULTI_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MULT_TERMS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_PROCESS_NEW_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_OFFER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_PROCESS_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_PROCESS_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_PROCESS_REVIEW_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_SINGLE_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_TOTAL_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCES_NONSTU_DET_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROC_ST_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROMPT_CC_NUMBER	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_DIFF_AMT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_EXP_DATE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_MISSING_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_MORE_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_REBUILD_CURRENT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_REG_APPL_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_APPL_MENU_OPT_CONT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_REG_CLASS_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_DATA_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_REG_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_TERM_DATES	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_REG_TERM_ELIGIBLE	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_RESULT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_REVIEW_CHRGS_AND_PYMNTS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_INSTL_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_MORE_CHPY	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_MORE_INSTL	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_BALANCE	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_AND_SPK_ACCT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_NONSTU_CHRG_AND_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_SCHED_DAY_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_SELECT_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_SINGLE_TERM	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_SINGLE_TERM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_SINGLE_TERM	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_SPEAK_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_START_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_SYSTEM_PROBLEM	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_TERM_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_VALIDATE_ALT_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_BIRTH_DATE	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_ID	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_NEWPIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_VERPIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VERIFY_CREDIT_CARD	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_VERIFY_DROP	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_VERIFY_START_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_WAITLIST_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_WITHDRAW_FROM_TERM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
F_CPAUTHENTICATE	Oracle Package Function	S10B80.WTAILOR.TWBKAUTH	Use (Insert,update)Rely On
F_GETLASTACTIVITYTIME	Oracle Package Function	S10B80.WTAILOR.TWBKAUTH	Rely On
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (update)Rely On
F_VALIDUSERNON	Oracle Package Function	S10B80.BANINST1.BWSKALOG	Rely On
TWGBWSES	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBWSES	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGBWSES

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:58:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor Web SessionID table

Columns Comments for TWGBWSES_PIDM (# 1)

Source Code Comments

PIDM of user.

Columns Comments for TWGBWSES_WEBID (# 2)

Source Code Comments

Randomly generated web session id.

Columns Comments for TWGBWSES_LAST_ACCESS (# 3)

Source Code Comments

Last date the user logged into the system.

Columns Comments for TWGBWSES_LOGIN_ATTEMPTS (# 4)

Source Code Comments

Counter for number of times an unsuccessful login has been attempted for same ID.

Columns Comments for TWGBWSES_LOGIN_REQ_IND (# 5)

Source Code Comments

For systems which include insecure pages - "Y" if user should be required to login at next secure page.

Columns Comments for TWGBWSES_SESSIONID (# 6)

Source Code Comments

Current Oracle sessionid for this database transaction.

Columns Comments for TWGBWSES_PREV_WEBID (# 7)

Source Code Comments

Previous web session id.

Table TWGRCHNL

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGRCHNL_NAME	VARCHAR2(50)	No	*
TWGRCHNL_MODULE_CODE	VARCHAR2(3)	No
TWGRCHNL_SECURE_IND	VARCHAR2(1)	No
TWGRCHNL_ACTIVITY_DATE	DATE	No
TWGRCHNL_USER_ID	VARCHAR2(30)	No
TWGRCHNL_TYPE	VARCHAR2(10)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGRCHNL	Unique	TWGRCHNL_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRCMAP	SQL Table	S10B80.WTAILOR	Refer (no action)
CHNL_REC	Oracle Package Type	S10B80.WTAILOR.TWBCCOMN	Rely On
CHNL_REC	Oracle Package Type	S10B80.BANINST1.TWBCCOMN	Rely On
GETALLMAINC	Oracle Package Cursor	S10B80.WTAILOR.TWBKCHNL	Use (select)
GETMAINC	Oracle Package Cursor	S10B80.WTAILOR.TWBKCHNL	Use (select)
F_GET_CHNL	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Use (select)
F_GET_CHNL	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Use (select)
F_GET_CHNL_LIST	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Use (select)
F_GET_CHNL_LIST	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Use (select)
P_DISPCHANNELMAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKCMAP	Rely On
P_DISPCHANNELPREF	Oracle Package Procedure	S10B80.WTAILOR.TWBKCPRF	Rely On
P_DISPLAY_CHANNEL_MAP_TABLE	Oracle Package Procedure	S10B80.WTAILOR.TWBKCMAP	Rely On
P_MODIFYCHANNEL	Oracle Package Procedure	S10B80.WTAILOR.TWBKCHNL	Use (select)Rely On
P_SAVECHANNEL	Oracle Package Procedure	S10B80.WTAILOR.TWBKCHNL	Use (Insert,update,delete)Rely On
P_SELECTCHANNEL	Oracle Package Procedure	S10B80.WTAILOR.TWBKCPRF	Use (select)
P_UPDATECHANNELPREF	Oracle Package Procedure	S10B80.WTAILOR.TWBKCPRF	Rely On
P_VIEWUPDATECHANNELMAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKCMAP	Rely On
P_VIEWUPDATECHANNELPREF	Oracle Package Procedure	S10B80.WTAILOR.TWBKCPRF	Use (select)Rely On
F_CHNL_DEFAULT	Oracle Package Function	S10B80.WTAILOR.TWBCMAIN	Use (select)Rely On
F_DEL_PREF_XML	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Rely On
F_DEL_PREF_XML	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
F_GET_CHNL_XML	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Rely On
F_GET_CHNL_XML	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
F_GET_PREF_XML	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Rely On
F_GET_PREF_XML	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
F_MAIN_XML	Oracle Package Function	S10B80.WTAILOR.TWBCMAIN	Use (select)Rely On
F_SET_PREF_XML	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Rely On
F_SET_PREF_XML	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
TWGRCHNL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRCHNL	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRCHNL

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:15:000	04/02/2008 21:18:26:000

Columns Comments for TWGRCHNL_NAME (# 1)

Source Code Comments

The name of the Source Info as defined during the channel publishing process.

Columns Comments for TWGRCHNL_SECURE_IND (# 3)

Source Code Comments

Specifies if the channel must be secured.

Columns Comments for TWGRCHNL_ACTIVITY_DATE (# 4)

Source Code Comments

The Oracle ID of the person who created or last updated the record.

Columns Comments for TWGRCHNL_TYPE (# 6)

Source Code Comments

Type of channel

Table TWGRCMAP

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
TWGRCMAP_NAME	VARCHAR2(50)	No	*	*
TWGRCMAP_MODE	VARCHAR2(10)	No	*
TWGRCMAP_VIEW	VARCHAR2(10)	No	*
TWGRCMAP_PROCEDURE	VARCHAR2(255)	No
TWGRCMAP_USER_ID	VARCHAR2(30)	No
TWGRCMAP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
TWGRCMAP_NAME	TWGRCHNL_NAME	TWGRCHNL

Index

Index Name	Index Type	Column Name
PK_TWGRCMAP	Unique	TWGRCMAP_NAME
PK_TWGRCMAP	Unique	TWGRCMAP_MODE
PK_TWGRCMAP	Unique	TWGRCMAP_VIEW

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_CURRENT_VIEW	Oracle Package Function	S10B80.WTAILOR.TWBCMAIN	Rely On
P_DISPCHANNELMAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKCMAP	Use (select)Rely On
P_DISPLAY_CHANNEL_MAP_TABLE	Oracle Package Procedure	S10B80.WTAILOR.TWBKCMAP	Use (select)Rely On
P_MODIFYCHANNEL	Oracle Package Procedure	S10B80.WTAILOR.TWBKCHNL	Use (select)
P_UPDATECHANNELMAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKCMAP	Use (Insert,update,delete)Rely On
P_VIEWUPDATECHANNELMAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKCMAP	Use (select)Rely On
F_CHNL_DEFAULT	Oracle Package Function	S10B80.WTAILOR.TWBCMAIN	Use (select)Rely On
F_MAIN_XML	Oracle Package Function	S10B80.WTAILOR.TWBCMAIN	Use (select)Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRCMAP	SQL Index	S10B80.WTAILOR	Rely On
TWGRCHNL	SQL Table	S10B80.WTAILOR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRCMAP

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:55:000	04/02/2008 21:18:25:000

Columns Comments for TWGRCMAP_MODE (# 2)

Source Code Comments

This represents the different mode(s) within a channel.

Columns Comments for TWGRCMAP_VIEW (# 3)

Source Code Comments

This will show a different view from within the mode of the channel.

Columns Comments for TWGRCMAP_PROCEDURE (# 4)

Source Code Comments

The name of the database package that will be called from the channel.

Columns Comments for TWGRCMAP_USER_ID (# 5)

Source Code Comments

The Banner ID of the person who created or last updated the record.

Columns Comments for TWGRCMAP_ACTIVITY_DATE (# 6)

Source Code Comments

The date the record was created or last updated.

Table TWGRFRRL

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
TWGRFRRL_NAME	VARCHAR2(120)	No	*	*
TWGRFRRL_ROLE	VARCHAR2(30)	No	*
TWGRFRRL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
TWGRFRRL_NAME	TWGBFRAM_NAME	TWGBFRAM

Index

Index Name	Index Type	Column Name
PK_TWGRFRRL	Unique	TWGRFRRL_NAME
PK_TWGRFRRL	Unique	TWGRFRRL_ROLE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_VALIDROLE	Oracle Package Function	S10B80.WTAILOR.TWBKSLIB	Use (select)Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRFRRL	SQL Index	S10B80.WTAILOR	Rely On
TWGBFRAM	SQL Table	S10B80.WTAILOR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRFRRL

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:44:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Frameset Roles table

Columns Comments for TWGRFRRL_NAME (# 1)

Source Code Comments

Name of frameset from TWGBFRAM.

Columns Comments for TWGRFRRL_ROLE (# 2)

Source Code Comments

User role associated with this frameset.

Columns Comments for TWGRFRRL_ACTIVITY_DATE (# 3)

Source Code Comments

Last date modified.

Table TWGRINFO

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
TWGRINFO_NAME	VARCHAR2(120)	No	*	*
TWGRINFO_SEQUENCE	NUMBER(0,0)	No	*
TWGRINFO_LABEL	VARCHAR2(20)	No	*
TWGRINFO_IMAGE	VARCHAR2(120)	Yes
TWGRINFO_TEXT	VARCHAR2(2000)	Yes
TWGRINFO_COMMENT	VARCHAR2(120)	Yes
TWGRINFO_ACTIVITY_DATE	DATE	No
TWGRINFO_SOURCE_IND	VARCHAR2(1)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
TWGRINFO_NAME	TWGBWMNU_NAME	TWGBWMNU
TWGRINFO_SOURCE_IND	TWGBWMNU_SOURCE_IND	TWGBWMNU

Index

Index Name	Index Type	Column Name
PK_TWGRINFO	Unique	TWGRINFO_NAME
PK_TWGRINFO	Unique	TWGRINFO_LABEL
PK_TWGRINFO	Unique	TWGRINFO_SEQUENCE
PK_TWGRINFO	Unique	TWGRINFO_SOURCE_IND

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRINFO_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
GETALLINFOTEXTC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWINF	Use (select)
GETINFOTEXTC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWINF	Use (select)
GETLOCALINFOTEXTC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWINF	Use (select)
GETNUMELSC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWINF	Use (select)
GETNUMPERLABELC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWINF	Use (select)
GETSPECINFOTEXTC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWINF	Use (select)
P_RESEQUENCEINFOTEXT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWINF	Use (update,select)Rely On
TWGRINFO_REC	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
GET_HELP_URL	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
GETINFOC	Oracle Package Cursor	S10B80.WTAILOR.TWBKLIBS	Use (select)Rely On
P_ADDDROP2	Oracle Package Procedure	S10B80.BANINST1.BWCKCOMS	Rely On
P_COPYTOLOCAL	Oracle Package Procedure	S10B80.WTAILOR.TWBKWINF	Use (Insert,select)
P_DISPHELP	Oracle Package Procedure	S10B80.WTAILOR.TWBKFRMT	Use (select)Rely On
P_FINAL_UPDATES	Oracle Package Procedure	S10B80.BANINST1.BWCKREGS	Rely On
P_FORMAT_SEPARATOR	Oracle Package Procedure	S10B80.BANINST1.BWCKSMLT	Rely On
P_INFO_TEXT_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.VIEWINFO	Rely On
P_INFO_TEXT_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.CMPRINFO	Use (select)Rely On
P_MODIFYPGINFOTEXT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWINF	Use (select)
P_MODIFYPGWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Use (select)
P_REGSRESULT	Oracle Package Procedure	S10B80.BANINST1.BWCKSAMS	Rely On
P_REORDERINFOTEXT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWINF	Use (Insert,delete,select)Rely On
P_REORDERPGINFOTEXT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWINF	Rely On
P_SAVEINFOTEXT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWINF	Use (Insert,update,delete)Rely On
P_SHOWRESULTS	Oracle Package Procedure	S10B80.WTAILOR.TWBKSRCH	Use (select)
P_VIEWT4	Oracle Package Procedure	S10B80.BANINST1.BWPKXTCS	Use (select)
F_DISPLAY_SEPARATOR	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Rely On
F_DISPLAY_SEPARATOR	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Use (select)
F_TWGRINFO_PROGRAM_TEXT	Oracle Package Function	S10B80.BANINST1.BWCKSMDS	Use (select)
TWGRINFO	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRINFO	SQL Index	S10B80.WTAILOR	Rely On
TWGBWMNU	SQL Table	S10B80.WTAILOR	Refer (no action)
TW_TWGRINFO_AUDIT	SQL Trigger	S10B80.WTAILOR	Fire (Insert,update,delete,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRINFO

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:22:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Repeating Information Text table

Columns Comments for TWGRINFO_NAME (# 1)

Source Code Comments

Name of associated page.

Columns Comments for TWGRINFO_SEQUENCE (# 2)

Source Code Comments

Sequence number for this text item.

Columns Comments for TWGRINFO_LABEL (# 3)

Source Code Comments

Short label, used to select which set of text items to print for a page. Default is "DEFAULT".

Columns Comments for TWGRINFO_IMAGE (# 4)

Source Code Comments

Image associated with this text - overrides programmatic choice of image.

Columns Comments for TWGRINFO_TEXT (# 5)

Source Code Comments

Text to be displayed on web page when this item is selected.

Columns Comments for TWGRINFO_COMMENT (# 6)

Source Code Comments

Comment about this text item.

Columns Comments for TWGRINFO_ACTIVITY_DATE (# 7)

Source Code Comments

Last date modified.

Columns Comments for TWGRINFO_SOURCE_IND (# 8)

Source Code Comments

Source Indicator: This field indicates if the row is (B)aseline or (L)ocal. The source_ind column has a default value of B.

Table TWGRMENU

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
TWGRMENU_NAME	VARCHAR2(120)	No	*	*
TWGRMENU_SEQUENCE	NUMBER(0,0)	No	*
TWGRMENU_URL_TEXT	VARCHAR2(120)	Yes
TWGRMENU_URL	VARCHAR2(120)	No
TWGRMENU_URL_DESC	VARCHAR2(2000)	Yes
TWGRMENU_IMAGE	VARCHAR2(120)	Yes
TWGRMENU_ENABLED	VARCHAR2(1)	Yes
TWGRMENU_DB_LINK_IND	VARCHAR2(1)	No
TWGRMENU_SUBMENU_IND	VARCHAR2(1)	No
TWGRMENU_TARGET_FRAME	VARCHAR2(120)	Yes
TWGRMENU_STATUS_TEXT	VARCHAR2(120)	Yes
TWGRMENU_ACTIVITY_DATE	DATE	No
TWGRMENU_URL_IMAGE	VARCHAR2(120)	Yes
TWGRMENU_SOURCE_IND	VARCHAR2(1)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
TWGRMENU_NAME	TWGBWMNU_NAME	TWGBWMNU
TWGRMENU_SOURCE_IND	TWGBWMNU_SOURCE_IND	TWGBWMNU

Index

Index Name	Index Type	Column Name
PK_TWGRMENU	Unique	TWGRMENU_NAME
PK_TWGRMENU	Unique	TWGRMENU_SEQUENCE
PK_TWGRMENU	Unique	TWGRMENU_SOURCE_IND

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
MENU_ITEM_RECORD_TYPE	Oracle Package Type	S10B80.WTAILOR.TWBKSITE	Rely On
GETALLMENUITEMSC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMENU	Use (select)
GETLOCALMENUITEMSC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMENU	Use (select)
GETMENUITEMSC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMENU	Use (select)
GETNUMELSC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMENU	Use (select)
GETURLC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
P_DISPLAY_PRODUCTION	Oracle Package Procedure	S10B80.WTAILOR.CMPRMENU	Use (select)Rely On
P_DISP_GIFT_SUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_DISP_GIFT_SUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Use (select)
P_RESEQUENCEMENUITEMS	Oracle Package Procedure	S10B80.WTAILOR.TWBKMENU	Use (update,select)
LOCALMENUITEM_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKMENU	Rely On
MAIL_LINK	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
MENUITEM_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKMENU	Rely On
F_GETMENUTYPE	Oracle Package Function	S10B80.WTAILOR.TWBKSITE	Rely On
GETBACKLINK	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On
GETMITEMC	Oracle Package Cursor	S10B80.WTAILOR.TWBKLIBS	Use (select)Rely On
P_CLOSEDOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_COPYTOLOCALMENUITEM	Oracle Package Procedure	S10B80.WTAILOR.TWBKMENU	Use (Insert,select)
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Use (select)
P_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.VIEWMENU	Use (select)
P_MODIFYPGWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Use (select)
P_OPENDOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_REORDERMENUITEM	Oracle Package Procedure	S10B80.WTAILOR.TWBKMENU	Use (Insert,delete,select)
P_SAVEMENUITEM	Oracle Package Procedure	S10B80.WTAILOR.TWBKMENU	Use (Insert,update,delete)
P_SHOWRESULTS	Oracle Package Procedure	S10B80.WTAILOR.TWBKSRCH	Use (select)Rely On
F_GETSITEMAP	Oracle Package Function	S10B80.WTAILOR.TWBKSITE	Use (select)Rely On
TWGRMENU	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRMENU	SQL Index	S10B80.WTAILOR	Rely On
TWGBWMNU	SQL Table	S10B80.WTAILOR	Refer (no action)
TW_TWGRMENU_AUDIT	SQL Trigger	S10B80.WTAILOR	Fire (Insert,update,delete,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRMENU

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:40:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Repeating Menu Item table

Columns Comments for TWGRMENU_NAME (# 1)

Source Code Comments

Unique name of menu - associated with entry in TWGBWMNU.

Columns Comments for TWGRMENU_SEQUENCE (# 2)

Source Code Comments

Sequence number for appearance on menu (order is top->bottom).

Columns Comments for TWGRMENU_URL_TEXT (# 3)

Source Code Comments

The text string to be used as the hyperlink.

Columns Comments for TWGRMENU_URL (# 4)

Source Code Comments

Text or expression that represents URL to link to when menu item is selected.

Columns Comments for TWGRMENU_URL_DESC (# 5)

Source Code Comments

Optional informational text that will be displayed below the link in the menu.

Columns Comments for TWGRMENU_IMAGE (# 6)

Source Code Comments

Name of image to be printed to the left of the menu item, as found in TWGBIMAG.

Columns Comments for TWGRMENU_ENABLED (# 7)

Source Code Comments

Menu item ebabled switch.

Columns Comments for TWGRMENU_DB_LINK_IND (# 8)

Source Code Comments

"Y" indicates that this link is to a PL/SQL stored procedure; "N" for a static HTML link.

Columns Comments for TWGRMENU_SUBMENU_IND (# 9)

Source Code Comments

SCT Sub Menu item indicator, Y = Sub menu, N or NULL = Not a sub menu.

Columns Comments for TWGRMENU_TARGET_FRAME (# 10)

Source Code Comments

Target frame for link - defaults to "_top".

Columns Comments for TWGRMENU_STATUS_TEXT (# 11)

Source Code Comments

Text to display in the status bar when cursor is over this link.

Columns Comments for TWGRMENU_ACTIVITY_DATE (# 12)

Source Code Comments

Last date modified.

Columns Comments for TWGRMENU_URL_IMAGE (# 13)

Source Code Comments

Name of image to be printed in place of text hyperlink, as found in TWGBIMAG.

Columns Comments for TWGRMENU_SOURCE_IND (# 14)

Source Code Comments

Source Indicator: This field indicates if the row is (B)aseline or (L)ocal. The source_ind column has a default value of B.

Table TWGRRETC

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
TWGRRETC_RETURN_CDE	VARCHAR2(1)	No	*
TWGRRETC_ASSOC_PACKAGE	VARCHAR2(12)	Yes
TWGRRETC_ASSOC_MODULE	VARCHAR2(3)	Yes
TWGRRETC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
TWGRRETC_RETURN_CDE	TWGBRETC_RETURN_CDE	TWGBRETC

Index

Index Name	Index Type	Column Name
TWGRRETC_INDEX_MODULE		TWGRRETC_RETURN_CDE
TWGRRETC_INDEX_MODULE		TWGRRETC_ASSOC_MODULE
TWGRRETC_INDEX_PACKAGE		TWGRRETC_RETURN_CDE
TWGRRETC_INDEX_PACKAGE		TWGRRETC_ASSOC_PACKAGE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GETASSOCMODULESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKRETC	Use (select)
GETASSOCPACKAGESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKRETC	Use (select)
P_MODIFYPGRETURNLOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKRETC	Rely On
P_SAVEMODULE	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODU	Use (delete)
P_SAVERETURNLOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKRETC	Use (Insert,delete,select)
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRRETC_INDEX_MODULE	SQL Index	S10B80.WTAILOR	Rely On
TWGRRETC_INDEX_PACKAGE	SQL Index	S10B80.WTAILOR	Rely On
TWGBRETC	SQL Table	S10B80.WTAILOR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRRETC

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:39:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Login Return Code repeating table

Columns Comments for TWGRRETC_RETURN_CDE (# 1)

Source Code Comments

Columns Comments for TWGRRETC_ASSOC_PACKAGE (# 2)

Source Code Comments

PL/SQL Package name associated with this return code.

Columns Comments for TWGRRETC_ASSOC_MODULE (# 3)

Source Code Comments

Module associated with this return code.

Columns Comments for TWGRRETC_ACTIVITY_DATE (# 4)

Source Code Comments

Date last modified.

Table TWGRROLE

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGRROLE_PIDM	NUMBER(8,0)	No	*
TWGRROLE_ROLE	VARCHAR2(30)	No	*
TWGRROLE_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGRROLE	Unique	TWGRROLE_PIDM
PK_TWGRROLE	Unique	TWGRROLE_ROLE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TW_TWGRROLE_AR_LDI	SQL Trigger	S10B80.WTAILOR	Rely On
CHECKTWGRROLEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKUROL	Use (select)
TWGRROLEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKSLIB	Use (select)Rely On
UT_GB_INSTITUTION_ROLEQ_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Use (delete)
F_HAS_ROLE	Oracle Package Function	S10B80.BANINST1.ICGOKROL	Use (select)
P_FETCHROLES	Oracle Package Procedure	S10B80.WTAILOR.TWBKSLIB	Use (select)
P_FORWARDFROMBANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKINTE	Use (delete)
P_SAVED_TEMPLATE_DEL	Oracle Package Procedure	S10B80.BANINST1.BWFKTDEL	Rely On
P_SAVED_TEMPLATE_DEL	Oracle Package Procedure	S10B80.BANINST1.BWFKTDEL	Use (select)Rely On
P_SAVED_TEMPLATE_DEL	Oracle Package Procedure	S10B80.BANINST1.BWFKTDEL	Rely On
P_SAVED_TEMPLATE_DEL	Oracle Package Procedure	S10B80.BANINST1.BWFKTDEL	Use (select)Rely On
P_SAVEUSERROLES	Oracle Package Procedure	S10B80.WTAILOR.TWBKUROL	Use (delete)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_INSTITUTION_ROLE	Use (Insert)
F_VALIDMASTERBUDGMGR	Oracle Package Function	S10B80.BANINST1.BWPKSALA	Use (select)
TWGRROLE	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRROLE	SQL Index	S10B80.WTAILOR	Rely On
TW_TWGRROLE_AR_LDI	SQL Trigger	S10B80.WTAILOR	Fire (Insert,delete,after,each row)
TW_TWGRROLE_AS_LDI	SQL Trigger	S10B80.WTAILOR	Fire (Insert,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRROLE

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:01:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor User Roles repeating table

Columns Comments for TWGRROLE_PIDM (# 1)

Source Code Comments

User PIDM

Columns Comments for TWGRROLE_ROLE (# 2)

Source Code Comments

Role associated with this user (from twtvrole).

Columns Comments for TWGRROLE_ACTIVITY_DATE (# 3)

Source Code Comments

Date last modified.

Table TWGRTLBR

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
TWGRTLBR_NAME	VARCHAR2(120)	No	*	*
TWGRTLBR_IMAGE	VARCHAR2(120)	Yes
TWGRTLBR_SEQUENCE	NUMBER(8,0)	No	*
TWGRTLBR_URL	VARCHAR2(120)	Yes
TWGRTLBR_URL_TEXT	VARCHAR2(120)	No
TWGRTLBR_DB_LINK_IND	VARCHAR2(1)	No
TWGRTLBR_MENU_IND	VARCHAR2(1)	No
TWGRTLBR_TARGET_FRAME	VARCHAR2(120)	Yes
TWGRTLBR_DISPLAY_TEXT_IND	VARCHAR2(120)	No
TWGRTLBR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
TWGRTLBR_NAME	TWGBTLBR_NAME	TWGBTLBR

Index

Index Name	Index Type	Column Name
PK_TWGRTLBR	Unique	TWGRTLBR_NAME
PK_TWGRTLBR	Unique	TWGRTLBR_SEQUENCE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GETTBREPEATC	Oracle Package Cursor	S10B80.WTAILOR.TWBKTLBR	Use (select)Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRTLBR	SQL Index	S10B80.WTAILOR	Rely On
TWGBTLBR	SQL Table	S10B80.WTAILOR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRTLBR

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:19:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Navigation Bar Elements table

Columns Comments for TWGRTLBR_NAME (# 1)

Source Code Comments

Unique name of navigation bar - associated with one of the functional areas of the system.

Columns Comments for TWGRTLBR_IMAGE (# 2)

Source Code Comments

Name of image, as found in TWGBIMAG.

Columns Comments for TWGRTLBR_SEQUENCE (# 3)

Source Code Comments

Sequence number for appearance on navigation bar (order is top->bottom).

Columns Comments for TWGRTLBR_URL (# 4)

Source Code Comments

Text or expression that represents URL to link to when menu item is selected.

Columns Comments for TWGRTLBR_URL_TEXT (# 5)

Source Code Comments

If image is null, or image name cannot be found, this text is used for the link.

Columns Comments for TWGRTLBR_DB_LINK_IND (# 6)

Source Code Comments

"Y" indicates that this link is to a PL/SQL stored procedure; "N" for a static HTML link.

Columns Comments for TWGRTLBR_MENU_IND (# 7)

Source Code Comments

"Y" indicates that this link is to a P_GenMenu-generated menu page.

Columns Comments for TWGRTLBR_TARGET_FRAME (# 8)

Source Code Comments

Name of the frame that the specified URL will open in. Programmatically defaults to "_top".

Columns Comments for TWGRTLBR_DISPLAY_TEXT_IND (# 9)

Source Code Comments

If "Y", the url_text will print with the assigned image, if "N", only the image will display.

Columns Comments for TWGRTLBR_ACTIVITY_DATE (# 10)

Source Code Comments

Last date modified.

Table TWGRUPRF

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGRUPRF_NAME	VARCHAR2(50)	No	*
TWGRUPRF_GROUP	VARCHAR2(30)	No	*
TWGRUPRF_KEY	VARCHAR2(30)	No	*
TWGRUPRF_PREF_USER	VARCHAR2(30)	No	*
TWGRUPRF_SUB_ID	VARCHAR2(30)	No	*
TWGRUPRF_EDIT_IND	VARCHAR2(1)	No
TWGRUPRF_USER_ID	VARCHAR2(30)	No
TWGRUPRF_ACTIVITY_DATE	DATE	No
TWGRUPRF_DESC	VARCHAR2(255)	No
TWGRUPRF_VALUE	VARCHAR2(255)	No
TWGRUPRF_SORT_ORDER	NUMBER(0,0)	Yes
TWGRUPRF_DISPLAY_TYPE	VARCHAR2(10)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGRUPRF	Unique	TWGRUPRF_NAME
PK_TWGRUPRF	Unique	TWGRUPRF_GROUP
PK_TWGRUPRF	Unique	TWGRUPRF_KEY
PK_TWGRUPRF	Unique	TWGRUPRF_PREF_USER
PK_TWGRUPRF	Unique	TWGRUPRF_SUB_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PREF_REC	Oracle Package Type	S10B80.WTAILOR.TWBCCOMN	Rely On
PREF_REC	Oracle Package Type	S10B80.BANINST1.TWBCCOMN	Rely On
P_CHANNEL_CLEANUP	Oracle Package Procedure	S10B80.WTAILOR.TWBCMAIN	Use (delete)
P_UPDATE_PREF	Oracle Package Procedure	S10B80.WTAILOR.TWBCCOMN	Use (Insert,update,select)Rely On
P_UPDATE_PREF	Oracle Package Procedure	S10B80.BANINST1.TWBCCOMN	Rely On
P_UPDATE_PREF	Oracle Package Procedure	S10B80.BANINST1.TWBCCOMN	Use (Insert,update,select)Rely On
P_DISPCHANNELPREF	Oracle Package Procedure	S10B80.WTAILOR.TWBKCPRF	Use (select)Rely On
P_MODIFYCHANNEL	Oracle Package Procedure	S10B80.WTAILOR.TWBKCHNL	Use (select)
P_UPDATECHANNELPREF	Oracle Package Procedure	S10B80.WTAILOR.TWBKCPRF	Use (Insert,update,delete,select)Rely On
P_VIEWUPDATECHANNELPREF	Oracle Package Procedure	S10B80.WTAILOR.TWBKCPRF	Use (select)Rely On
F_DEL_PREF_XML	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Use (delete,select)
F_DEL_PREF_XML	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Use (delete,select)
F_GET_PREF	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Use (select)Rely On
F_GET_PREF	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
F_GET_PREF	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Use (select)
F_GET_PREF_USER	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Use (select)Rely On
F_GET_PREF_USER	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
F_GET_PREF_USER	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Use (select)
F_GET_PREF_XML	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Rely On
F_GET_PREF_XML	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
F_MAIN_XML	Oracle Package Function	S10B80.WTAILOR.TWBCMAIN	Rely On
F_SET_PREF_XML	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Use (select)Rely On
F_SET_PREF_XML	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
F_SET_PREF_XML	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Use (select)
TWGRUPRF	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRUPRF	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRUPRF

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:18:000	04/02/2008 21:18:26:000

Columns Comments for TWGRUPRF_NAME (# 1)

Source Code Comments

The name of the Source Info as defined during the channel publishing process.

Columns Comments for TWGRUPRF_GROUP (# 2)

Source Code Comments

The group to which this preference belongs.

Columns Comments for TWGRUPRF_KEY (# 3)

Source Code Comments

The key that will be used to identify the preference within the group.

Columns Comments for TWGRUPRF_PREF_USER (# 4)

Source Code Comments

For delivered preferences, this is BASELINE. If a user customizes the preference, their Banner ID will be stored here instead. You must have WebTailor Administrator privileges to customize Baseline preferences.

Columns Comments for TWGRUPRF_SUB_ID (# 5)

Source Code Comments

Subscriber ID for the channel is stored here.

Columns Comments for TWGRUPRF_EDIT_IND (# 6)

Source Code Comments

Indicates if the preference can be edited by the end users.

Columns Comments for TWGRUPRF_USER_ID (# 7)

Source Code Comments

The Banner ID of the person who created or last updated the record.

Columns Comments for TWGRUPRF_ACTIVITY_DATE (# 8)

Source Code Comments

The date the record was created or last updated.

Columns Comments for TWGRUPRF_DESC (# 9)

Source Code Comments

Description of the preference.

Columns Comments for TWGRUPRF_VALUE (# 10)

Source Code Comments

Value of the preference.

Columns Comments for TWGRUPRF_SORT_ORDER (# 11)

Source Code Comments

Order in which the preference should be displayed to the end users.

Columns Comments for TWGRUPRF_DISPLAY_TYPE (# 12)

Source Code Comments

HTML control used to display this preference,

Table TWGRVERS

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
TWGRVERS_RELEASE		VARCHAR2(10)	No
TWGRVERS_STAGE_DATE		DATE	No

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRVERS

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:11:000	04/02/2008 21:18:25:000

Source Code Comments

WebTailor Version Tracking Table

Columns Comments for TWGRVERS_RELEASE (# 1)

Source Code Comments

RELEASE: Current release for this product.

Columns Comments for TWGRVERS_STAGE_DATE (# 2)

Source Code Comments

STAGE DATE: Date that installation occurred.

Table TWGRWMRL

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGRWMRL_NAME	VARCHAR2(120)	No	*
TWGRWMRL_ROLE	VARCHAR2(30)	No	*
TWGRWMRL_ACTIVITY_DATE	DATE	No
TWGRWMRL_SOURCE_IND	VARCHAR2(1)	No	*

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGRWMRL	Unique	TWGRWMRL_NAME
PK_TWGRWMRL	Unique	TWGRWMRL_ROLE
PK_TWGRWMRL	Unique	TWGRWMRL_SOURCE_IND

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRWMRL_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
GETWMRLC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWMNU	Use (select)
GETWMRLC	Oracle Package Cursor	S10B80.WTAILOR.TWBKLIBS	Use (select)Rely On
P_COPYTOLOCALPGWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Use (Insert,select)
P_MODIFYPGWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Rely On
P_SAVEWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Use (delete)
P_WEB_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.CMPRWMNU	Use (select)Rely On
F_VALIDROLE	Oracle Package Function	S10B80.WTAILOR.TWBKSLIB	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRWMRL	SQL Index	S10B80.WTAILOR	Rely On
TW_TWGRWMRL_AUDIT	SQL Trigger	S10B80.WTAILOR	Fire (Insert,update,delete,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRWMRL

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:39:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Menu Roles table

Columns Comments for TWGRWMRL_NAME (# 1)

Source Code Comments

Name of procedure or menu from TWGBWMNU.

Columns Comments for TWGRWMRL_ROLE (# 2)

Source Code Comments

User role associated with this menu or procedure.

Columns Comments for TWGRWMRL_ACTIVITY_DATE (# 3)

Source Code Comments

Last date modified.

Columns Comments for TWGRWMRL_SOURCE_IND (# 4)

Source Code Comments

Source Indicator: This field indicates if the row is (B)aseline or (L)ocal. The source_ind column has a default value of B.

Table TWGRWPRM

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWGRWPRM_PIDM	NUMBER(8,0)	No	*
TWGRWPRM_PARAM_NAME	VARCHAR2(10)	No	*
TWGRWPRM_PARAM_VALUE	VARCHAR2(30)	Yes
TWGRWPRM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWGRWPRM	Unique	TWGRWPRM_PIDM
PK_TWGRWPRM	Unique	TWGRWPRM_PARAM_NAME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWGRWPRM_TAB_TYPE	Oracle Package Type	S10B80.WTAILOR.TWBKTABS	Rely On
P_ADDRTELE_KEY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_AUTHENTICATE_BANNER	Oracle Package Procedure	S10B80.WTAILOR.TWBKLOGN	Use (delete)
P_AUTHENTICATE_LDAP	Oracle Package Procedure	S10B80.WTAILOR.TWBKLOGN	Use (delete)
P_DELETE_PARAMS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Use (delete)
P_DISP_SELECTED_CATEGORY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_GET_POSN_SUFF	Oracle Package Procedure	S10B80.BANINST1.BWPKEPDT	Rely On
P_PROCSECURITYPIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (delete)
P_SELECTAPPROVERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_SELECTAPPROVERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_SELECTJOBBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_SELECTNJSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_SELECTNJSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_SELECTSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_SELECTSUPERUSERACTION	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_VALLOGIN	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (delete)
ADDR1_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
ADDR1_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
ADDR1_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
ADDR2_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
ADDR2_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
ADDR2_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
APPNO_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
ATERM_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
CAMPDESG1_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
CAMPDESG1_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
CASHIER_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
CCNUM_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
CCNUM_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
CCNUM_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
CCNUM_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
CCTYPE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
CCTYPE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
CCTYPE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
CCTYPE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
CITY_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
CITY_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
CITY_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
CNTRY_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
CNTRY_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
CNTRY_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
COMMENTTEXT01_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT01_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT02_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT02_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT03_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT03_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT04_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT04_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT05_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT05_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT06_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT06_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT07_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT07_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT08_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT08_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT09_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT09_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
COMMENTTEXT10_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
COMMENTTEXT10_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
CURR_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
CURR_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
CURR_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
EMAIL_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
EMAIL_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
EMAIL_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
EXPDATE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
EXPDATE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
EXPDATE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
EXPMON_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
EXPMON_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
EXPMON_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
EXPMON_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
EXPYEAR_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
EXPYEAR_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
EXPYEAR_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
EXPYEAR_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
FIXED_AMT_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
FIXED_AMT_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
GIFT_CODE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
LIKE_NAME	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
MASK_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
MASK_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
MASK_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
NAME_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
NAME_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
NAME_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
ORDERID_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
ORDERID_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
PARM_TITLE	Oracle Package Variable	S10B80.BANINST1.BWPKEPDT	Rely On
PARM_VALUE	Oracle Package Variable	S10B80.BANINST1.BWPKEPDT	Rely On
PHONE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
PHONE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
PHONE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
PLEDGENO_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
PLEDGENO_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
PMTTYPE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
PMTTYPE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
PMTTYPE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
PRICE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
PRICE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
PRICE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
PROC_PAY_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
PROC_PAY_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
SPLITIND_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
STATE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
STATE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
STATE_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
STOREID_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
STOREID_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
STOREID_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKGIFT	Rely On
WAIV_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
WAPP_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
ZIP_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKCPMT	Rely On
ZIP_LABEL	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
ZIP_LABEL	Oracle Package Variable	S10B80.BANINST1.BWSKAPMT	Rely On
F_GET_JOBS_COUNT	Oracle Package Function	S10B80.BANINST1.BWPKEPUT	Use (select)
F_GET_PARAM	Oracle Package Function	S10B80.BANINST1.BWPKEPCR	Use (select)
TWGRWPRM_ROW_BY_NAME_VALUE_C	Oracle Package Cursor	S10B80.WTAILOR.TWBKSELS	Use (select)Rely On
TWGRWPRM_ROW_BY_PIDM_NAME_C	Oracle Package Cursor	S10B80.WTAILOR.TWBKSELS	Use (select)Rely On
TWGRWPRM_ROW_PIDM_LIKE_NAME_C	Oracle Package Cursor	S10B80.WTAILOR.TWBKSELS	Use (select)Rely On
P_ALLCRSECHK	Oracle Package Procedure	S10B80.BANINST1.BWCKREGS	Use (delete)
P_APPROVEREXTRACT	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_APPROVEREXTRACT	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_APPROVERSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_APPROVERSUMMARY	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_BUTTONSDRIVER	Oracle Package Procedure	S10B80.BANINST1.BWPKTAPP	Use (delete)
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CCPAYMENTSUBMITTED	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CCPAYMENTSUBMITTED	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CCPAYMENTSUBMITTED	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CCPAYMENTVERIFICATION	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CCPAYMENTVERIFICATION	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CCPAYMENTVERIFICATION	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CC_PAYMENT_STATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_CC_PAYMENT_SUBMITTED	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_CC_PAYMENT_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_CHOOSEJOB	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_COLLECT_CREDIT_CARD_INFO	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
P_COMMENTS_ADMIN_BODY	Oracle Package Procedure	S10B80.BANINST1.BWPKFMSC	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CREDIT_CARD_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_DELETEJOBSSEQTAB	Oracle Package Procedure	S10B80.BANINST1.BWPKTAPP	Use (delete)
P_DELETE_MULTI_PARAM	Oracle Package Procedure	S10B80.BANINST1.BWPKOLIB	Use (delete)
P_DELETE_PARAM	Oracle Package Procedure	S10B80.BANINST1.BWPKOLIB	Use (delete)
P_DELETE_TWGRWPRM	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODS	Use (delete)Rely On
P_DELETE_TWGRWPRM_PIDM_NAME	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODS	Use (delete)Rely On
P_DEL_TWGRWPRM_BY_PIDM_NAME	Oracle Package Procedure	S10B80.WTAILOR.TWBKFUNC	Use (delete)Rely On
P_DEL_TWGRWPRM_BY_VALUE	Oracle Package Procedure	S10B80.WTAILOR.TWBKFUNC	Use (delete)Rely On
P_DEL_TWGRWPRM_CC_VAL	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_DEL_TWGRWPRM_CC_VALUES	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_DEL_TWGRWPRM_PIDM_LIKE_NAME	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODS	Use (delete)Rely On
P_DISPAPPROVERSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Use (delete)
P_DISPCHGCRSEOPT	Oracle Package Procedure	S10B80.BANINST1.BWCKSAMS	Use (delete)
P_DISPEPAFMENU	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Use (delete)
P_DISPIDSELECT	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (delete)
P_DISPORIGINATORSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Use (delete)
P_DISPPERSONADDRESSES	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISPPERSONADDRESSESPHONES	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISPPERSONPHONES	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKGIFT	Rely On
P_FACADDDROPCRSE	Oracle Package Procedure	S10B80.BANINST1.BWLKFRAD	Rely On
P_FACCHANGECRSEOPT	Oracle Package Procedure	S10B80.BANINST1.BWLKFRAD	Rely On
P_FACCRSESEARCH	Oracle Package Procedure	S10B80.BANINST1.BWLKFFCS	Rely On
P_FACDISPTEST	Oracle Package Procedure	S10B80.BANINST1.BWLKTEST	Rely On
P_FACRESETPIN	Oracle Package Procedure	S10B80.BANINST1.BWLKOIDS	Use (delete)
P_FAC_ACTIVE_REGS	Oracle Package Procedure	S10B80.BANINST1.BWLKSREG	Rely On
P_FAC_REG_HIST	Oracle Package Procedure	S10B80.BANINST1.BWLKHREG	Rely On
P_GENMENU	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_GETNEXTJOBSSEQTAB	Oracle Package Procedure	S10B80.BANINST1.BWPKTAPP	Use (select)
P_GETPREVJOBSSEQTAB	Oracle Package Procedure	S10B80.BANINST1.BWPKTAPP	Use (select)
P_GET_SUB_CODE	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_GET_SUB_CODE	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_GET_SUB_CODE_1	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_GET_TWGRWPRM_ROWS	Oracle Package Procedure	S10B80.WTAILOR.TWBKFUNC	Rely On
P_INSERTJOBSSEQTAB	Oracle Package Procedure	S10B80.BANINST1.BWPKTAPP	Use (Insert,select)
P_INSERT_TWGRWPRM	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODS	Use (Insert)Rely On
P_LOGOUT	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (delete)
P_PRINT_EMP_ERRORS	Oracle Package Procedure	S10B80.BANINST1.BWPKFMSC	Rely On
P_PRINT_JOBS_SELECTION	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_PROCDELETEAPPR	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_PROCDELETEAPPR	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_PROCINDEX	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_PROCSELECTLEAVEREPORTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_PROCSELECTLEAVEREPORTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_PROCSELECTLEAVEREQUESTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_PROCSELECTLEAVEREQUESTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_PROCSELECTTIMESHEETROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_PROCSELECTTIMESHEETROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_REGSFEES	Oracle Package Procedure	S10B80.BANINST1.BWCKREGS	Rely On
P_REGSRESULT	Oracle Package Procedure	S10B80.BANINST1.BWCKSAMS	Use (delete)
P_SELECTADDRTELEBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_SELECTAPPROVERSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Use (delete)
P_SELECTLEAVEREPORT	Oracle Package Procedure	S10B80.BANINST1.BWPKTEIS	Use (delete)
P_SELECTLEAVEREPORTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_SELECTLEAVEREPORTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_SELECTLEAVEREQUEST	Oracle Package Procedure	S10B80.BANINST1.BWPKTEIS	Use (delete)
P_SELECTLEAVEREQUESTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_SELECTLEAVEREQUESTROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_SELECTORIGINATORSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKEPSM	Use (delete)
P_SELECTTIMESHEET	Oracle Package Procedure	S10B80.BANINST1.BWPKTEIS	Use (delete)
P_SELECTTIMESHEETDRIVER	Oracle Package Procedure	S10B80.BANINST1.BWPKTEIS	Use (delete)
P_SELECTTIMESHEETROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKTAIS	Use (delete)
P_SELECTTIMESHEETROLL	Oracle Package Procedure	S10B80.BANINST1.BWPKLRED	Use (delete)
P_SETPARAM	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (Insert,update)Rely On
P_STORE_TWGRWPRM_ROW	Oracle Package Procedure	S10B80.WTAILOR.TWBKFUNC	Rely On
P_UPDATE_TWGRWPRM	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODS	Use (update)Rely On
P_VALIDATE_JOB	Oracle Package Procedure	S10B80.BANINST1.BWPKEPCR	Rely On
P_VR_ACCT_REVIEW_BALANCE	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_ADD_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_ADM_APPT_OPER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_MATERIALS_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_ORIENTATION_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ADM_REQUEST_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_ALL_REQ_SPEAK_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_APPLY_CC_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_ASSESS_FEES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_AUTODROP_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_AW_MULTI_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_AW_SINGLE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_BIL_INFO_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BIL_OPTIONS_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BUILD_BAD_CC_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_EXPIR_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_PAYMENT_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_ST_ACCOUNT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BYPASS_TERM_CHECKS	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CHANGE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHANGE_PIN_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHECK_CLAS_AVAIL	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CHECK_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_CHECK_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_CHECK_OPEN_SECTIONS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CHECK_OPEN_SECTIONS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CONFIRM_NEEDED_CHECK	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_NEEDED_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONFIRM_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CONTINUE_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_CREDIT_HOURS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_CRN_LIST	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CRN_LIST_MULTI_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_CRN_LIST_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_DAY_TIME_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_DROP_CLASS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_DROP_CLASS_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_END_CALL	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_END_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_FIN_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_MATERIALS_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_PROGRAM_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_FIN_REQUEST_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_GET_AIDY_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_APPL_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_BILLING_DEADLN_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_DAY_TIME	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_GET_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_GET_FIN_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_GET_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRLAP	Rely On
P_VR_GET_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GET_OFFER_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_PROGRESS_DATA	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GET_TERM_DATES	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_GRADE_MODE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_GRDE_INFO_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GRDE_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_GRDE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_HOLD_OPER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_HOLD_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_INVALID_TERM	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_LIKE_TO_REG_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_LIST_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_LIST_CLASSES	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_LIST_CURRENT_CLASSES	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_LIST_GRADES	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_LIST_MORE_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_MAIN_MENU_RETURN	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MENU_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_MORE_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_MULTI_TERMS	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_NOAPP_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_NO_HOLD_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
P_VR_PMPT_ST_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_ADMINDROPS	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_PROCESS_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_BAD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_EXPDATE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_EXPDATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_CC_NUMBER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_CC_TYPE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_DETAIL_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_DIFF_AMOUNT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXPIR_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXP_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MISSING_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MORE_REQ	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MULTI_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MULT_TERMS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_PROCESS_NEW_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_OFFER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_PROCESS_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_PROCESS_REG_ERRORS	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_PROCESS_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_PROCESS_REVIEW_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_SINGLE_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_TOTAL_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCES_NONSTU_DET_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROC_ST_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROMPT_CC_NUMBER	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_DIFF_AMT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_EXP_DATE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_MISSING_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_MORE_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_REBUILD_CURRENT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_REG_APPL_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_APPL_MENU_OPT_CONT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_REG_CLASS_MENU_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_DATA_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_REG_INFO_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_REG_TERM_DATES	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_REG_TERM_ELIGIBLE	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_RESULT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_REVIEW_CHRGS_AND_PYMNTS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_INSTL_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_MORE_CHPY	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_MORE_INSTL	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_BALANCE	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_AND_SPK_ACCT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_NONSTU_CHRG_AND_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_SCHED_DAY_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_SINGLE_TERM	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_SINGLE_TERM	Oracle Package Procedure	S10B80.BANINST1.VRHKGRDS	Rely On
P_VR_SPEAK_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
P_VR_START_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_TERM_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
P_VR_VALIDATE_ALT_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_BIRTH_DATE	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_ID	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VALIDATE_PIN	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
P_VR_VERIFY_CREDIT_CARD	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_VERIFY_DROP	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_VERIFY_START_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFOLR	Rely On
P_VR_WAITLIST_OPT	Oracle Package Procedure	S10B80.BANINST1.VRSKFREG	Rely On
P_VR_WITHDRAW_FROM_TERM	Oracle Package Procedure	S10B80.BANINST1.VRSKFORG	Rely On
F_BUILD_PARAM_NAME	Oracle Package Function	S10B80.WTAILOR.TWBKFUNC	Rely On
F_CPAUTHENTICATE	Oracle Package Function	S10B80.WTAILOR.TWBKAUTH	Use (delete)
F_GETPARAM	Oracle Package Function	S10B80.WTAILOR.TWBCCOMN	Use (select)Rely On
F_GETPARAM	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
F_GETPARAM	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Rely On
F_GETPARAM	Oracle Package Function	S10B80.BANINST1.TWBCCOMN	Use (select)Rely On
F_GET_MULTI_PARAM	Oracle Package Function	S10B80.BANINST1.BWPKOLIB	Use (select)
F_GET_PARAM_VALUE	Oracle Package Function	S10B80.WTAILOR.TWBKSELS	Rely On
F_GET_PIDM_FROM_TWGRWPRM	Oracle Package Function	S10B80.WTAILOR.TWBKSELS	Rely On
F_LOAD_AND_STORE_PARAM_VALUE	Oracle Package Function	S10B80.WTAILOR.TWBKFUNC	Rely On
TWGRWPRM	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGRWPRM	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWGRWPRM

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:03:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor User Parameters table

Columns Comments for TWGRWPRM_PIDM (# 1)

Source Code Comments

User PIDM.

Columns Comments for TWGRWPRM_PARAM_NAME (# 2)

Source Code Comments

Parameter name.

Columns Comments for TWGRWPRM_PARAM_VALUE (# 3)

Source Code Comments

Parameter value.

Columns Comments for TWGRWPRM_ACTIVITY_DATE (# 4)

Source Code Comments

Last date modified.

Table TWTVMODU

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWTVMODU_CODE	VARCHAR2(3)	No	*
TWTVMODU_DESC	VARCHAR2(120)	No
TWTVMODU_GLOBAL_MENU	VARCHAR2(120)	Yes
TWTVMODU_HEADER_CAPS_ON	VARCHAR2(1)	Yes
TWTVMODU_DISPLAY_EXIT_IND	VARCHAR2(1)	No
TWTVMODU_CURR_RELEASE_NO	VARCHAR2(30)	Yes
TWTVMODU_ACTIVITY_DATE	DATE	No
TWTVMODU_CSS_URL	VARCHAR2(255)	Yes
TWTVMODU_EXIT_IMAGE	VARCHAR2(120)	Yes
TWTVMODU_HELP_IMAGE	VARCHAR2(120)	Yes
TWTVMODU_MENU_IMAGE	VARCHAR2(120)	Yes
TWTVMODU_BACK_IMAGE	VARCHAR2(120)	Yes
TWTVMODU_HELP_URL	VARCHAR2(255)	Yes
TWTVMODU_HELP_CSS	VARCHAR2(255)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWTVMODU	Unique	TWTVMODU_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TWTVMODU_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
GETALLMODULESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMODU	Use (select)
GETMODULEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWMNU	Use (select)
GETMODULEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKMODU	Use (select)
GETMODULEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKCHNL	Use (select)
F_BOTTOMLINKSEXIST	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Use (select)
F_GET_MODULE	Oracle Package Function	S10B80.WTAILOR.TWBKFRMT	Rely On
GETMODULEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKLIBS	Use (select)Rely On
P_INFO_TEXT_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.VIEWINFO	Use (select)Rely On
P_INFO_TEXT_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.CMPRINFO	Use (select)Rely On
P_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.VIEWMENU	Use (select)Rely On
P_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.CMPRMENU	Use (select)Rely On
P_MODIFYCHANNEL	Oracle Package Procedure	S10B80.WTAILOR.TWBKCHNL	Rely On
P_MODIFYPGMODULE	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODU	Rely On
P_MODIFYPGRETURNLOC	Oracle Package Procedure	S10B80.WTAILOR.TWBKRETC	Use (select)Rely On
P_MODIFYPGWEBMAIN	Oracle Package Procedure	S10B80.WTAILOR.TWBKWMNU	Rely On
P_PRINTMENU	Oracle Package Procedure	S10B80.WTAILOR.TWBKFRMT	Rely On
P_SAVEMODULE	Oracle Package Procedure	S10B80.WTAILOR.TWBKMODU	Use (Insert,update,delete)Rely On
P_START	Oracle Package Procedure	S10B80.WTAILOR.VIEWINFO	Use (select)
P_START	Oracle Package Procedure	S10B80.WTAILOR.VIEWWMNU	Use (select)
P_START	Oracle Package Procedure	S10B80.WTAILOR.VIEWMENU	Use (select)
P_START	Oracle Package Procedure	S10B80.WTAILOR.CMPRINFO	Use (select)
P_START	Oracle Package Procedure	S10B80.WTAILOR.CMPRWMNU	Use (select)
P_START	Oracle Package Procedure	S10B80.WTAILOR.CMPRMENU	Use (select)
P_WEB_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.VIEWWMNU	Use (select)Rely On
P_WEB_MENU_DISPLAY	Oracle Package Procedure	S10B80.WTAILOR.CMPRWMNU	Use (select)Rely On
F_VALIDUSER	Oracle Package Function	S10B80.WTAILOR.TWBKWBIS	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWTVMODU	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWTVMODU

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:13:000	04/02/2008 21:18:26:000

Source Code Comments

Web Tailor Module validation table

Columns Comments for TWTVMODU_CODE (# 1)

Source Code Comments

Module code - one exists for each web product.

Columns Comments for TWTVMODU_DESC (# 2)

Source Code Comments

Description of the module.

Columns Comments for TWTVMODU_GLOBAL_MENU (# 3)

Source Code Comments

Menu (TWGBWMNU) to be displayed at the bottom of every page assoc. w/this module.

Columns Comments for TWTVMODU_HEADER_CAPS_ON (# 4)

Source Code Comments

"Y" if Header Text in this module is printed with twgkfrmt.P_HeaderCaps.

Columns Comments for TWTVMODU_DISPLAY_EXIT_IND (# 5)

Source Code Comments

"Y" if Exit/Logout button is to be printed on pages within this module.

Columns Comments for TWTVMODU_CURR_RELEASE_NO (# 6)

Source Code Comments

Current release number for this module. Will override setting in twgkwbis, but not value passed to P_CloseDoc.

Columns Comments for TWTVMODU_ACTIVITY_DATE (# 7)

Source Code Comments

Date last modified.

Columns Comments for TWTVMODU_CSS_URL (# 8)

Source Code Comments

CSS URL: This field indicates the physical address of the Module Level cascading style sheet.

Columns Comments for TWTVMODU_EXIT_IMAGE (# 9)

Source Code Comments

Exit Image: This field indicates the name of an image (twgbimag) to be used as the Module Level Exit Image.

Columns Comments for TWTVMODU_HELP_IMAGE (# 10)

Source Code Comments

Help Image: This field indicates the name of an image (twgbimag) to be used as the Module Level Help Image.

Columns Comments for TWTVMODU_MENU_IMAGE (# 11)

Source Code Comments

Menu Image: This field indicates the name of an image (twgbimag) to be used as the Module Level Menu Image.

Columns Comments for TWTVMODU_BACK_IMAGE (# 12)

Source Code Comments

Back Image: This field indicates the name of an image (twgbimag) to be used as the Module Level Back Link Image.

Columns Comments for TWTVMODU_HELP_URL (# 13)

Source Code Comments

TWTVMODU_HELP_URL:This field indicates the URL of the module level static html page.

Columns Comments for TWTVMODU_HELP_CSS (# 14)

Source Code Comments

TWTVMODU_HELP_CSS:The module level location of CSS and this will control presentation of help.

Table TWTVROLE

Server Name S10B80
Database Name WTAILOR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
TWTVROLE_CODE	VARCHAR2(30)	No	*
TWTVROLE_DESC	VARCHAR2(60)	No
TWTVROLE_ACTIVITY_DATE	DATE	No
TWTVROLE_USER_DEFINED_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_TWTVROLE	Unique	TWTVROLE_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GETROLEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWMNU	Use (select)
GETROLEC	Oracle Package Cursor	S10B80.WTAILOR.TWBKCHNL	Use (select)
GETROLESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKWMNU	Use (select)
GETROLESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKCHNL	Use (select)
GETROLESC	Oracle Package Cursor	S10B80.WTAILOR.TWBKUROL	Use (select)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWTVROLE	SQL Index	S10B80.WTAILOR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.WTAILOR.TWTVROLE

Object Dates

Creation Date	Analysis Date
04/02/2008 21:07:09:000	04/02/2008 21:18:25:000

Source Code Comments

Web Tailor User Role validation table

Columns Comments for TWTVROLE_CODE (# 1)

Source Code Comments

Role code.

Columns Comments for TWTVROLE_DESC (# 2)

Source Code Comments

Description of the user role.

Columns Comments for TWTVROLE_ACTIVITY_DATE (# 3)

Source Code Comments

Date last modified.

Columns Comments for TWTVROLE_USER_DEFINED_IND (# 4)

Source Code Comments

Y if the role is defined on TWGRROLE, N if role is data-driven from GOVROLE

Link between TWGRCMAP and TWGRCHNL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between TWGRCMAP and TWGRCHNL (FK1_TWGRCMAP_INV_TWGRCHNL_KEY)	WTAILOR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
TWGRCMAP	TWGRCMAP_NAME	TWGRCHNL_NAME	TWGRCHNL	(1,1)-(0,n)

Link between TWGRINFO and TWGBWMNU

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between TWGRINFO and TWGBWMNU (FK1_TWGRINFO_INV_TWGBWMNU_KEY)	WTAILOR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
TWGRINFO	TWGRINFO_NAME	TWGBWMNU_NAME	TWGBWMNU	(1,1)-(0,n)
TWGRINFO	TWGRINFO_SOURCE_IND	TWGBWMNU_SOURCE_IND	TWGBWMNU	(1,1)-(0,n)

Link between TWGRRETC and TWGBRETC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between TWGRRETC and TWGBRETC (FK1_TWGRRETC_INV_TWGBRETC_KEY)	WTAILOR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
TWGRRETC	TWGRRETC_RETURN_CDE	TWGBRETC_RETURN_CDE	TWGBRETC	(1,1)-(0,n)

Link between TWGRMENU and TWGBWMNU

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between TWGRMENU and TWGBWMNU (FK1_TWGRMENU_INV_TWGBWMNU_KEY)	WTAILOR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
TWGRMENU	TWGRMENU_NAME	TWGBWMNU_NAME	TWGBWMNU	(1,1)-(0,n)
TWGRMENU	TWGRMENU_SOURCE_IND	TWGBWMNU_SOURCE_IND	TWGBWMNU	(1,1)-(0,n)

Link between TWGRFRRL and TWGBFRAM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between TWGRFRRL and TWGBFRAM (FK1_TWGRFRRL_INV_TWGBFRAM_KEY)	WTAILOR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
TWGRFRRL	TWGRFRRL_NAME	TWGBFRAM_NAME	TWGBFRAM	(1,1)-(0,n)

Link between TWGRTLBR and TWGBTLBR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between TWGRTLBR and TWGBTLBR (FK1_TWGRTLBR_INV_TWGBTLBR_KEY)	WTAILOR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
TWGRTLBR	TWGRTLBR_NAME	TWGBTLBR_NAME	TWGBTLBR	(1,1)-(0,n)

Link between TWGBWMNU and TWGBIMAG

Join Information

Objects list
scope-procedure : S10B80.BANINST1.BWSKALOG.P_DISPADMSMNUNON scope-procedure : S10B80.BANINST1.BWAKALOG.P_DISPADVMNUNON

Link List

Link Type	Link	Project
Join	Link Between TWGBWMNU and TWGBIMAG	WTAILOR

List of Real links

Link type	Between	And
Join	TWGBWMNU	TWGBIMAG