Model WebTailor

Model Label : Web Tailor
Path : Default Folder/B70/Web General/WebTailor

List of Objects

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

Comments

Model View

Table TWGBFRAM

Schema Name WTAILOR
Label TWGBFRAM
Server name S4B70
Creation Date 07/21/2003 16:48:23:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
TWGBFRAM_NAME	TWGBFRAM_NAME	VARCHAR2(120)	No	*
TWGBFRAM_DESC	TWGBFRAM_DESC	VARCHAR2(120)	No
TWGBFRAM_NAVBAR_NAME	TWGBFRAM_NAVBAR_NAME	VARCHAR2(120)	Yes
TWGBFRAM_STARTPAGE	TWGBFRAM_STARTPAGE	VARCHAR2(120)	No
TWGBFRAM_START_MENU_IND	TWGBFRAM_START_MENU_IND	VARCHAR2(1)	No
TWGBFRAM_TITLE	TWGBFRAM_TITLE	VARCHAR2(120)	No
TWGBFRAM_COMMENT	TWGBFRAM_COMMENT	VARCHAR2(120)	Yes
TWGBFRAM_INSECURE_ALLOWED_IND	TWGBFRAM_INSECURE_ALLOWED_IND	VARCHAR2(1)	No
TWGBFRAM_MODULE	TWGBFRAM_MODULE	VARCHAR2(3)	No
TWGBFRAM_ACTIVITY_DATE	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
TWGBFRAM	SYNONYM	S4B70.PUBLIC	Rely on ()
TWGRFRRL	TABLE	S4B70.WTAILOR	Refer( No Action )
GETALLFRAMESETSC	Package cursor	S4B70.BANINST1.BWAKWRUL	Use(select )
F_FRAMESETNAME	Package function	S4B70.WTAILOR.TWBKWBIS	Rely on () Use(select )
P_CREATETOOLBAR	Package procedure	S4B70.WTAILOR.TWBKTLBR	Use(select )
F_VALIDLINK	Package function	S4B70.WTAILOR.TWBKWBIS	Rely on ()
F_VALIDROLE	Package function	S4B70.WTAILOR.TWBKSLIB	Rely on ()

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBFRAM	INDEX	S4B70.WTAILOR	Rely on ()

Comments

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

Schema Name WTAILOR
Label TWGBGLUI
Server name S4B70
Creation Date 09/23/2004 18:00:00:000

Table Columns information

Column Name	Label	Column Type	Allow NULL
TWGBGLUI_SYSTEM_NAME	TWGBGLUI_SYSTEM_NAME	VARCHAR2(120)	Yes
TWGBGLUI_BODY_BG_COLOR	TWGBGLUI_BODY_BG_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_BODY_BG_IMAGE	TWGBGLUI_BODY_BG_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_HELP_IMAGE	TWGBGLUI_HELP_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_MAIN_MENU_NAME	TWGBGLUI_MAIN_MENU_NAME	VARCHAR2(120)	Yes
TWGBGLUI_HEADER_IMAGE	TWGBGLUI_HEADER_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_HEADER_COLOR	TWGBGLUI_HEADER_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_HEADER_COLOR	TWGBGLUI_TABLE_HEADER_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_DEFAULT_COLOR	TWGBGLUI_TABLE_DEFAULT_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_LABEL_COLOR	TWGBGLUI_TABLE_LABEL_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_HILITE_COLOR	TWGBGLUI_TABLE_HILITE_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_SEP_COLOR	TWGBGLUI_TABLE_SEP_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_TABLE_DEAD_COLOR	TWGBGLUI_TABLE_DEAD_COLOR	VARCHAR2(6)	Yes
TWGBGLUI_FONT_FACE	TWGBGLUI_FONT_FACE	VARCHAR2(255)	Yes
TWGBGLUI_ACTIVITY_DATE	TWGBGLUI_ACTIVITY_DATE	DATE	Yes
TWGBGLUI_SUBMENU_IMAGE	TWGBGLUI_SUBMENU_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_APP_PAGE_IMAGE	TWGBGLUI_APP_PAGE_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_CSS_URL	TWGBGLUI_CSS_URL	VARCHAR2(255)	Yes
TWGBGLUI_HELP_URL	TWGBGLUI_HELP_URL	VARCHAR2(255)	Yes
TWGBGLUI_SCT_HOMEPAGE	TWGBGLUI_SCT_HOMEPAGE	VARCHAR2(255)	Yes
TWGBGLUI_ERROR_IMAGE	TWGBGLUI_ERROR_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_WARNING_IMAGE	TWGBGLUI_WARNING_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_EXIT_IMAGE	TWGBGLUI_EXIT_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_MENU_IMAGE	TWGBGLUI_MENU_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_BACK_IMAGE	TWGBGLUI_BACK_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_REQUIRED_IMAGE	TWGBGLUI_REQUIRED_IMAGE	VARCHAR2(120)	Yes
TWGBGLUI_HELP_CSS	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	SYNONYM	S4B70.PUBLIC	Rely on ()
TWGBGLUI_REC	Package variable	S4B70.WTAILOR.TWBKLIBS	Rely on ()
P_GENERATEFORM	Package procedure	S4B70.BANINST1.BWSKWPRO	Rely on ()
P_GENERATEFORM	Package procedure	S4B70.BANINST1.BWSKWPRO	Use(select )
GETRULESC	Package cursor	S4B70.WTAILOR.TWBKGLUI	Use(select )
P_MODIFYPGGLOBALUI	Package procedure	S4B70.WTAILOR.TWBKGLUI	Rely on ()
P_SAVEGLOBALUI	Package procedure	S4B70.WTAILOR.TWBKGLUI	Rely on () Use(insert,update )
TWBKLIBS	PACKAGE	S4B70.WTAILOR	Use(select )

Comments

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

Schema Name WTAILOR
Label TWGBIMAG
Server name S4B70
Creation Date 07/21/2003 16:48:23:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
TWGBIMAG_NAME	TWGBIMAG_NAME	VARCHAR2(120)	No	*
TWGBIMAG_IMAGE_URL	TWGBIMAG_IMAGE_URL	VARCHAR2(120)	No
TWGBIMAG_IMAGE_WIDTH	TWGBIMAG_IMAGE_WIDTH	NUMBER(0,0)	Yes
TWGBIMAG_IMAGE_HEIGHT	TWGBIMAG_IMAGE_HEIGHT	NUMBER(0,0)	Yes
TWGBIMAG_IMAGE_ON_URL	TWGBIMAG_IMAGE_ON_URL	VARCHAR2(120)	Yes
TWGBIMAG_ALT	TWGBIMAG_ALT	VARCHAR2(120)	Yes
TWGBIMAG_STATUS_BAR	TWGBIMAG_STATUS_BAR	VARCHAR2(120)	Yes
TWGBIMAG_COMMENT	TWGBIMAG_COMMENT	VARCHAR2(255)	Yes
TWGBIMAG_ALIGN	TWGBIMAG_ALIGN	VARCHAR2(30)	Yes
TWGBIMAG_BORDER	TWGBIMAG_BORDER	VARCHAR2(10)	Yes
TWGBIMAG_VSPACE	TWGBIMAG_VSPACE	VARCHAR2(10)	Yes
TWGBIMAG_HSPACE	TWGBIMAG_HSPACE	VARCHAR2(10)	Yes
TWGBIMAG_DESC	TWGBIMAG_DESC	VARCHAR2(120)	Yes
TWGBIMAG_ACTIVITY_DATE	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
open_html_doc	C/C++ Function	[F:\BANNER\C\HWGAWBIS.PC]	Use(select )
print_info	C/C++ Function	[F:\BANNER\C\HWGAWBIS.PC]	Use(select )
TWGBIMAG	SYNONYM	S4B70.PUBLIC	Rely on ()
GETALLIMAGESC	Package cursor	S4B70.WTAILOR.TWBKCHNL	Use(select )
GETALLIMAGESC	Package cursor	S4B70.WTAILOR.TWBKMENU	Use(select )
GETALLIMAGESC	Package cursor	S4B70.WTAILOR.TWBKMODU	Use(select )
GETALLIMAGESC	Package cursor	S4B70.WTAILOR.TWBKWRUL	Use(select )
GETALLIMAGESC	Package cursor	S4B70.WTAILOR.TWBKWINF	Use(select )
GETALLIMAGESC	Package cursor	S4B70.WTAILOR.TWBKWMNU	Use(select )
GETALLIMAGESC	Package cursor	S4B70.WTAILOR.TWBKGLUI	Use(select )
GETALLIMAGESC	Package cursor	S4B70.WTAILOR.TWBKIMAG	Use(select )
GETIMAGEC	Package cursor	S4B70.WTAILOR.TWBKWBIS	Use(select )
GETIMAGEC	Package cursor	S4B70.WTAILOR.TWBKIMAG	Use(select )
GETIMAGEC	Package cursor	S4B70.WTAILOR.TWBKFRMT	Use(select )
IMAGE_REC	Package variable	S4B70.WTAILOR.TWBKWBIS	Rely on ()
P_DISPADMSMNUNON	Package procedure	S4B70.BANINST1.BWSKALOG	Use(select )
P_DISPADVMNUNON	Package procedure	S4B70.BANINST1.BWAKALOG	Use(select )
P_JSCRIPTPREVIEWIMAGEOPEN	Package procedure	S4B70.WTAILOR.TWBKJSCR	Use(select )
P_MODIFYPGIMAGE	Package procedure	S4B70.WTAILOR.TWBKIMAG	Rely on ()
P_SAVEIMAGE	Package procedure	S4B70.WTAILOR.TWBKIMAG	Rely on () Use(insert,update,delete )
F_IMAGELINK	Package function	S4B70.WTAILOR.TWBKFRMT	Rely on ()
F_PRINTIMAGE	Package function	S4B70.WTAILOR.TWBKFRMT	Rely on ()

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBIMAG	INDEX	S4B70.WTAILOR	Rely on ()

Comments

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 TWGBOVRR

Schema Name WTAILOR
Label TWGBOVRR
Server name S4B70
Creation Date 10/27/2003 12:35:01:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
TWGBOVRR_CONDITION	TWGBOVRR_CONDITION	VARCHAR2(120)	No	*
TWGBOVRR_REPLACE_VALUE	TWGBOVRR_REPLACE_VALUE	VARCHAR2(120)	No
TWGBOVRR_ACTIVITY_DATE	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
TWGBOVRR	SYNONYM	S4B70.PUBLIC	Rely on ()
GETOVERRIDEC	Package cursor	S4B70.WTAILOR.TWBKOVRR	Use(select )
OVERRIDE_REC	Package variable	S4B70.WTAILOR.TWBKOVRR	Rely on ()
F_GETOVERRIDE	Package function	S4B70.WTAILOR.TWBKSLIB	Use(select )
P_DISPALLOVERRIDES	Package procedure	S4B70.WTAILOR.TWBKOVRR	Use(select )
P_FORWARDFROMBANNER	Package procedure	S4B70.WTAILOR.TWBKINTE	Use(select )
P_MODIFYPGOVERRIDE	Package procedure	S4B70.WTAILOR.TWBKOVRR	Rely on ()
P_SAVEOVERRIDE	Package procedure	S4B70.WTAILOR.TWBKOVRR	Use(insert,update,delete )
P_SECURITYERRORPAGE	Package procedure	S4B70.WTAILOR.TWBKWBIS	Use(select )
F_VALIDUSER	Package function	S4B70.WTAILOR.TWBKWBIS	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBOVRR	INDEX	S4B70.WTAILOR	Rely on ()

Comments

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

Schema Name WTAILOR
Label TWGBPARM
Server name S4B70
Creation Date 10/27/2003 12:35:01:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
TWGBPARM_PARAM_NAME	TWGBPARM_PARAM_NAME	VARCHAR2(30)	No	*
TWGBPARM_PARAM_VALUE	TWGBPARM_PARAM_VALUE	VARCHAR2(255)	No
TWGBPARM_ACTIVITY_DATE	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
TWGBPARM	SYNONYM	S4B70.PUBLIC	Rely on ()
GETPARAMC	Package cursor	S4B70.WTAILOR.TWBKPARM	Use(select )
CC_USE_ADDR_CODE	Package variable	S4B70.BANINST1.BWAKCPMT	Rely on ()
CC_USE_ADDR_CODE	Package variable	S4B70.BANINST1.BWAKNGFT	Rely on ()
PARAM_REC	Package variable	S4B70.WTAILOR.TWBKPARM	Rely on ()
F_FETCHPARAM	Package function	S4B70.WTAILOR.TWBKSRCH	Rely on () Use(select )
F_GETBASEURL	Package function	S4B70.BANINST1.BWGKIPAY	Use(select )
F_GETBASEURL	Package function	S4B70.BANINST1.BWGKTPAY	Use(select )
F_GET_MAINPIDM	Package function	S4B70.WTAILOR.TWBKLOGN	Rely on ()
F_SELECTNULLDISPVALUE	Package function	S4B70.WTAILOR.TWBKWBIS	Rely on () Use(select )
P_CCPAYMENTVERIFICATION	Package procedure	S4B70.BANINST1.BWSKAPMT	Rely on ()
P_CCPAYMENTVERIFICATION	Package procedure	S4B70.BANINST1.BWCKCPMT	Rely on ()
P_CC_PAYMENT_VALIDATION	Package procedure	S4B70.BANINST1.BWSKWCCP	Rely on ()
P_CREDITCARDPAYMENT	Package procedure	S4B70.BANINST1.BWSKAPMT	Rely on ()
P_CREDITCARDPAYMENT	Package procedure	S4B70.BANINST1.BWCKCPMT	Rely on ()
P_CREDIT_CARD_PAYMENT	Package procedure	S4B70.BANINST1.BWSKWCCP	Rely on ()
P_DISPALLPARAMS	Package procedure	S4B70.WTAILOR.TWBKPARM	Use(select )
P_FORWARDFROMBANNER	Package procedure	S4B70.WTAILOR.TWBKINTE	Use(select )
P_FORWARDTOOTHER	Package procedure	S4B70.WTAILOR.TWBKINTE	Use(select )
P_MODIFYPGPARAM	Package procedure	S4B70.WTAILOR.TWBKPARM	Rely on ()
P_RETURNTOBANNER	Package procedure	S4B70.WTAILOR.TWBKINTE	Use(select )
P_SAVEPARAM	Package procedure	S4B70.WTAILOR.TWBKPARM	Use(insert,update,delete )
F_FETCHWTPARAM	Package function	S4B70.WTAILOR.TWBKWBIS	Rely on () Use(select )
F_FORMSELECTOPTION	Package function	S4B70.WTAILOR.TWBKWBIS	Rely on ()
F_GETBASEURL	Package function	S4B70.BANINST1.BWGKEPAY	Use(select )
F_PINLENGTH	Package function	S4B70.WTAILOR.TWBKGLIB	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBPARM	INDEX	S4B70.WTAILOR	Rely on ()

Comments

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

Schema Name WTAILOR
Label TWGBRETC
Server name S4B70
Creation Date 07/21/2003 16:48:24:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
TWGBRETC_RETURN_CDE	TWGBRETC_RETURN_CDE	VARCHAR2(1)	No	*
TWGBRETC_RETURN_LOCATION	TWGBRETC_RETURN_LOCATION	VARCHAR2(120)	No
TWGBRETC_FRAMESET_IND	TWGBRETC_FRAMESET_IND	VARCHAR2(1)	No
TWGBRETC_MENU_IND	TWGBRETC_MENU_IND	VARCHAR2(1)	No
TWGBRETC_OVR_STARTPAGE	TWGBRETC_OVR_STARTPAGE	VARCHAR2(120)	Yes
TWGBRETC_DESC	TWGBRETC_DESC	VARCHAR2(120)	No
TWGBRETC_LOGIN_FORWARD_IND	TWGBRETC_LOGIN_FORWARD_IND	VARCHAR2(1)	No
TWGBRETC_ACTIVITY_DATE	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
TWGBRETC	SYNONYM	S4B70.PUBLIC	Rely on ()
TWGRRETC	TABLE	S4B70.WTAILOR	Refer( No Action )
GETALLRETURNLOCSC	Package cursor	S4B70.WTAILOR.TWBKRETC	Use(select )
GETRETURNLOCC	Package cursor	S4B70.WTAILOR.TWBKRETC	Use(select )
P_FIRSTMENU	Package procedure	S4B70.WTAILOR.TWBKWBIS	Use(select )
P_MODIFYPGRETURNLOC	Package procedure	S4B70.WTAILOR.TWBKRETC	Rely on ()
P_SAVERETURNLOC	Package procedure	S4B70.WTAILOR.TWBKRETC	Rely on () Use(insert,update,delete )
F_VALIDUSER	Package function	S4B70.WTAILOR.TWBKWBIS	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBRETC	INDEX	S4B70.WTAILOR	Rely on ()

Comments

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

Schema Name WTAILOR
Label TWGBTLBR
Server name S4B70
Creation Date 07/21/2003 16:48:24:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
TWGBTLBR_NAME	TWGBTLBR_NAME	VARCHAR2(120)	No	*
TWGBTLBR_DESC	TWGBTLBR_DESC	VARCHAR2(120)	No
TWGBTLBR_WIDTH	TWGBTLBR_WIDTH	VARCHAR2(10)	Yes
TWGBTLBR_MARGINWIDTH	TWGBTLBR_MARGINWIDTH	NUMBER(8,0)	Yes
TWGBTLBR_MARGINHEIGHT	TWGBTLBR_MARGINHEIGHT	NUMBER(8,0)	Yes
TWGBTLBR_SCROLLING	TWGBTLBR_SCROLLING	VARCHAR2(10)	Yes
TWGBTLBR_ALIGN	TWGBTLBR_ALIGN	VARCHAR2(30)	Yes
TWGBTLBR_BGCOLOR	TWGBTLBR_BGCOLOR	VARCHAR2(6)	Yes
TWGBTLBR_BG_IMAGE	TWGBTLBR_BG_IMAGE	VARCHAR2(120)	Yes
TWGBTLBR_COLORBAR_WIDTH	TWGBTLBR_COLORBAR_WIDTH	VARCHAR2(10)	Yes
TWGBTLBR_COLORBAR_BGCOLOR	TWGBTLBR_COLORBAR_BGCOLOR	VARCHAR2(120)	Yes
TWGBTLBR_COLORBAR_BG_IMAGE	TWGBTLBR_COLORBAR_BG_IMAGE	VARCHAR2(120)	Yes
TWGBTLBR_TEXT_COLOR	TWGBTLBR_TEXT_COLOR	VARCHAR2(6)	Yes
TWGBTLBR_LINK_COLOR	TWGBTLBR_LINK_COLOR	VARCHAR2(6)	Yes
TWGBTLBR_ALINK_COLOR	TWGBTLBR_ALINK_COLOR	VARCHAR2(6)	Yes
TWGBTLBR_VLINK_COLOR	TWGBTLBR_VLINK_COLOR	VARCHAR2(6)	Yes
TWGBTLBR_URL	TWGBTLBR_URL	VARCHAR2(120)	Yes
TWGBTLBR_URL_DB_IND	TWGBTLBR_URL_DB_IND	VARCHAR2(1)	Yes
TWGBTLBR_ACTIVITY_DATE	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
TWGBTLBR	SYNONYM	S4B70.PUBLIC	Rely on ()
TWGRTLBR	TABLE	S4B70.WTAILOR	Refer( No Action )
GETTOOLBARC	Package cursor	S4B70.WTAILOR.TWBKTLBR	Rely on () Use(select )
P_CREATECOLORBAR	Package procedure	S4B70.WTAILOR.TWBKTLBR	Rely on ()
P_CREATETOOLBAR	Package procedure	S4B70.WTAILOR.TWBKTLBR	Rely on ()

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_TWGBTLBR	INDEX	S4B70.WTAILOR	Rely on ()

Comments

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

Schema Name WTAILOR
Label TWGBWMNU
Server name S4B70
Creation Date 12/03/2004 16:45:13:000

Table Columns information

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