Model Letter Generation

Model Label : Banner General Letter Generation
Path : Default Folder/B70/General/Letter_Generation

List of Objects

Object Name	Object Type	Layer Name
GLBAPPL	TABLE	Default
GLBOBJT	TABLE	Default
GLBSLCT	TABLE	Default
GLBVRBL	TABLE	Default
GLRAPPL	TABLE	Default
GLRCALC	TABLE	Default
GLRCMPL	TABLE	Default
GLRCOLR	TABLE	Default
GLROBJT	TABLE	Default
GLRORDR	TABLE	Default
GLRVFRM	TABLE	Default
GLRVRBL	TABLE	Default
GTVLETR	TABLE	Default
GTVPARA	TABLE	Default
GTVSYSI	TABLE	Default
GUBLETR	TABLE	Default
GUBPARA	TABLE	Default
GUBPPRF	TABLE	Default
GURMAIL	TABLE	Default

Comments

Model View

Table GLBAPPL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GLBAPPL_APPLICATION	GLBAPPL_APPLICATION	VARCHAR2(30)	No	*
GLBAPPL_DESC	GLBAPPL_DESC	VARCHAR2(30)	No
GLBAPPL_SYSI_CODE	GLBAPPL_SYSI_CODE	VARCHAR2(2)	No		*
GLBAPPL_ACTIVITY_DATE	GLBAPPL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLBAPPL_SYSI_CODE	GTVSYSI_CODE	GTVSYSI

Index

Index Name	Index Type	Column Name
PK_GLBAPPL	Unique	GLBAPPL_APPLICATION

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
C03-A	Cobol Paragraph	[F:\banner\cobol].GLBDATA.A01-INIT-EXIT-ORACLE	Use(select )
C03-CONT	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use(select )
DQY-PROMPT-FOR-APPL	Cobol Paragraph	[F:\banner\cobol].ROBBGRP.DQY-ABORT-SECT	Use(select )
system_ind_sel	C/C++ Function	[F:\BANNER\C\GLRLETR.PC]	Use(select )
test_application	C/C++ Function	[F:\BANNER\C\SFRNOWD.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RERIS01.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RERIS02.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RERIS03.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RPRDSPT.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RPRTIVC.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\SFRWDRL.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RPRTIVI.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RPRTIVR.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RPRDDUP.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RERIS05.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\RERIS04.PC]	Use(select )
GLBAPPL	SYNONYM	S4B70.PUBLIC	Rely on ()
GLBSLCT	TABLE	S4B70."GENERAL"	Refer( No Action )
GLBVRBL	TABLE	S4B70."GENERAL"	Refer( No Action )
GLRAPPL	TABLE	S4B70."GENERAL"	Refer( No Action )
GLRCMPL	TABLE	S4B70."GENERAL"	Refer( No Action )
GUBPPRF	TABLE	S4B70."GENERAL"	Refer( No Action )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.APACMAS.AMRCONT_PSEL_BLOCK.POPSEL_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GLIEXTR.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GUAPPRF.GUBPPRF.GUBPPRF_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.RORPOST.RORPOST.RORPOST_APPL_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GLISLCT.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GLIVRBL.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.APACMAS.AMRCONT_PSEL_BLOCK.POPSEL_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GLAEXTR.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GLIEXTR.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.RORPOST.RORPOST.RORPOST_APPL_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.APIBRWS.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GLAEXTR.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GLISLCT.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GUAPPRF.GUBPPRF.GUBPPRF_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.APIBRWS.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GLIVRBL.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.ASASIGN.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GUASRVY.GUBSRVY.GUBSRVY_EXTR_APPLICATION	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GUASRVY.GUBSRVY.GUBSRVY_EXTR_APPLICATION	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.ASASIGN.KEY_BLOCK.KEYBLCK_APPLICATION	Use(select )
GLBAPPL_LOV	Forms Record Group	BANNER7_FORMS.GLIVRBL	Use(select )
GLBAPPL_LOV	Forms Record Group	BANNER7_FORMS_10G.GLIVRBL	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.ASASIGN	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GLAEXTR	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GLIEXTR	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.ASASIGN	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.RORPOST	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.RORPOST	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GUAPPRF	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GORRSQL	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GLRSLCT	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GLAEXTR	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GORRSQL	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GLRSLCT	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GLRAPPL	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GUAPPRF	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GLRVRBL	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS_10G.GLISLCT	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GLRAPPL	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GLIEXTR	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GLISLCT	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GLRVRBL	Use(select )
GLBAPPL_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
P_GET_GLBLSEL_PARMS	Forms Procedure	BANNER7_FORMS.GJAPCTL	Rely on ()
P_GET_GLBLSEL_PARMS	Forms Procedure	BANNER7_FORMS_10G.GJAPCTL	Rely on ()
SELECT_GLBAPPL_1	Forms Function	BANNER7_FORMS.GLRVRBL	Use(select )
SELECT_GLBAPPL_1	Forms Function	BANNER7_FORMS_10G.GLRVRBL	Use(select )
SELECT_GLBAPPL_2	Forms Function	BANNER7_FORMS.GLRSLCT	Use(select )
SELECT_GLBAPPL_2	Forms Function	BANNER7_FORMS_10G.GLRSLCT	Use(select )
P_PIN_CHANGED_NOTIFICATION	Package procedure	S4B70.BANINST1.GB_THIRD_PARTY_ACCESS	Rely on ()
P_PIN_CHANGED_NOTIFICATION	Package procedure	S4B70.BANINST1.GB_THIRD_PARTY_ACCESS	Use(select )
F_GLBAPPL_EQUAL	Package function	S4B70.BANINST1.GOKPVAL	Use(select )
P_PA_GLBAPPL_EQUAL	Package procedure	S4B70.BANINST1.ROKPVAL	Use(select )
P_PIN_CHANGED_NOTIFICATION	Package procedure	S4B70.BANINST1.GOKMAIL	Rely on ()
P_PIN_CHANGED_NOTIFICATION	Package procedure	S4B70.BANINST1.GOKMAIL	Use(select )
P_VALIDATE_GLBDATA	Package procedure	S4B70.BANINST1.GOKPVAL	Rely on ()
P_VALIDATE_GLBLSEL	Package procedure	S4B70.BANINST1.GOKPVAL	Rely on ()
F_GLBAPPL_EQUAL	Package function	S4B70.BANINST1.TOKPVAL	Use(select )
F_GLBAPPL_EQUAL	Package function	S4B70.BANINST1.AOKPVAL	Use(select )
GLBAPPL	Forms DataBlock	BANNER7_FORMS.GLRAPPL	Rely on () Use(insert,update,delete,select )
GLBAPPL	Forms DataBlock	BANNER7_FORMS.GLIAPPL	Rely on () Use(delete,select )
GLBAPPL	Forms DataBlock	BANNER7_FORMS_10G.GLRAPPL	Rely on () Use(insert,update,delete,select )
GLBAPPL	Forms DataBlock	BANNER7_FORMS_10G.GLIAPPL	Rely on () Use(delete,select )

Called objects (non escalated)

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

Comments

Source Code Comments

Letter Generation Application Table

Columns Comments for GLBAPPL_APPLICATION (1)

Source Code Comments

APPLICATION: Application code which uniquely identifies this record.

Columns Comments for GLBAPPL_DESC (2)

Source Code Comments

DESCRIPTION: Description of this application.

Columns Comments for GLBAPPL_SYSI_CODE (3)

Source Code Comments

SYSTEM INDICATOR: System indicator which identifies which system this application is associated.

Columns Comments for GLBAPPL_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: Date that record was created or last updated.

Table GLBOBJT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GLBOBJT_OBJECT	GLBOBJT_OBJECT	VARCHAR2(30)	No	*
GLBOBJT_DESC	GLBOBJT_DESC	VARCHAR2(30)	No
GLBOBJT_ACTIVITY_DATE	GLBOBJT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GLBOBJT	Unique	GLBOBJT_OBJECT

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLBOBJT	SYNONYM	S4B70.PUBLIC	Rely on ()
GLROBJT	TABLE	S4B70."GENERAL"	Refer( No Action )
INCLUDE_OBJECT	Forms Trigger	BANNER7_FORMS.GLRVRBL	Use(select )
INCLUDE_OBJECT	Forms Trigger	BANNER7_FORMS.GLRAPPL	Use(select )
INCLUDE_OBJECT	Forms Trigger	BANNER7_FORMS.GLROBJT	Use(select )
INCLUDE_OBJECT	Forms Trigger	BANNER7_FORMS_10G.GLRVRBL	Use(select )
INCLUDE_OBJECT	Forms Trigger	BANNER7_FORMS_10G.GLRSLCT	Use(select )
INCLUDE_OBJECT	Forms Trigger	BANNER7_FORMS_10G.GLROBJT	Use(select )
INCLUDE_OBJECT	Forms Trigger	BANNER7_FORMS_10G.GLRAPPL	Use(select )
INCLUDE_OBJECT	Forms Trigger	BANNER7_FORMS.GLRSLCT	Use(select )
GLBOBJT	Forms DataBlock	BANNER7_FORMS.GLIOBJT	Rely on () Use(insert,update,delete,select )
GLBOBJT	Forms DataBlock	BANNER7_FORMS_10G.GLROBJT	Rely on () Use(insert,update,delete,select )
GLBOBJT	Forms DataBlock	BANNER7_FORMS_10G.GLIOBJT	Rely on () Use(insert,update,delete,select )
GLBOBJT	Forms DataBlock	BANNER7_FORMS.GLROBJT	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

Source Code Comments

Letter Generation Object Base Table

Columns Comments for GLBOBJT_OBJECT (1)

Source Code Comments

OBJECT: Object code which uniquely identifies this record.

Columns Comments for GLBOBJT_DESC (2)

Source Code Comments

DESCRIPTION: Description of this object.

Columns Comments for GLBOBJT_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date that record was created or last updated.

Table GLBSLCT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GLBSLCT_APPLICATION	GLBSLCT_APPLICATION	VARCHAR2(30)	No	*	*
GLBSLCT_SELECTION	GLBSLCT_SELECTION	VARCHAR2(30)	No	*
GLBSLCT_CREATOR_ID	GLBSLCT_CREATOR_ID	VARCHAR2(30)	No	*
GLBSLCT_DESC	GLBSLCT_DESC	VARCHAR2(30)	No
GLBSLCT_LOCK_IND	GLBSLCT_LOCK_IND	VARCHAR2(1)	No
GLBSLCT_ACTIVITY_DATE	GLBSLCT_ACTIVITY_DATE	DATE	No
GLBSLCT_TYPE_IND	GLBSLCT_TYPE_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLBSLCT_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL

Index

Index Name	Index Type	Column Name
PK_GLBSLCT	Unique	GLBSLCT_APPLICATION
PK_GLBSLCT	Unique	GLBSLCT_SELECTION
PK_GLBSLCT	Unique	GLBSLCT_CREATOR_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
pdp1042.pc	C/C++ File	N/A	Use(select )
insert_glbslct_record	C/C++ Function	[F:\BANNER\C\SURLOAD.PC]	Use(insert )
main	C/C++ Function	[F:\BANNER\C\RCRTP01.PC]	Use(select )
main	C/C++ Function	[F:\BANNER\C\RCRTP02.PC]	Use(select )
main	C/C++ Function	[F:\BANNER\C\RCRTP03.PC]	Use(select )
main	C/C++ Function	[F:\BANNER\C\RCRTP04.PC]	Use(select )
main	C/C++ Function	[F:\BANNER\C\RCRTP00.PC]	Use(select )
AAA3	Cobol Paragraph	[F:\banner\cobol].REBCD03.AAA-SECT	Use(select )
AAA3	Cobol Paragraph	[F:\banner\cobol].REBCD05.AAA-SECT	Use(select )
AAA3	Cobol Paragraph	[F:\banner\cobol].REBCD04.AAA-SECT	Use(select )
AAA3	Cobol Paragraph	[F:\banner\cobol].REBCD00.AAA-SECT	Use(select )
AAA3	Cobol Paragraph	[F:\banner\cobol].REBCD01.AAA-SECT	Use(select )
AAA3	Cobol Paragraph	[F:\banner\cobol].REBCD02.AAA-SECT	Use(select )
BAA4	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.BAA-START-UP	Use(select )
C06C-FETCH-PARM2	Cobol Paragraph	[F:\banner\cobol].GLBDATA.A01-INIT-EXIT-ORACLE	Use()
C07-FINISH	Cobol Paragraph	[F:\banner\cobol].GLBDATA.A01-INIT-EXIT-ORACLE	Use(update )
C09-INSERT-GLBSLCT	Cobol Paragraph	[F:\banner\cobol].GLBDATA.A01-INIT-EXIT-ORACLE	Use()
C09-PROCESS-GLBSLCT	Cobol Paragraph	[F:\banner\cobol].GLBDATA.A01-INIT-EXIT-ORACLE	Use(insert,select )
C09-UPDATE-GLBSLCT	Cobol Paragraph	[F:\banner\cobol].GLBDATA.A01-INIT-EXIT-ORACLE	Use(update )
D01-GET-ALL-TABLES	Cobol Paragraph	[F:\banner\cobol].GLOLETT.A00-INIT-EXIT-ORACLE	Use()
Q01-GET-QUERY	Cobol Paragraph	[F:\banner\cobol].GLBDATA.A01-INIT-EXIT-ORACLE	Use(select )
delglbextr	C/C++ Function	[F:\BANNER\C\SURLOAD.PC]	Use(delete )
popsel_exists	C/C++ Function	[F:\BANNER\C\TGRUNAP.PC]	Use(select )
sel_parm_validate_pop_sel	C/C++ Function	[F:\BANNER\C\PHPRETO.PC]	Use(select )
sel_pop_sel_valid	C/C++ Function	[F:\BANNER\C\NBPMASS.PC]	Use(select )
sel_pop_sel_valid	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
sel_valid_query_id	C/C++ Function	[F:\BANNER\C\RORCALC.PC]	Use(select )
sel_validate_pop_sel	C/C++ Function	[F:\BANNER\C\PXRW2US.PC]	Use(select )
val_pop_sel	C/C++ Function	[F:\BANNER\C\RHRFATR.PC]	Use(select )
val_pop_sel	C/C++ Function	[F:\BANNER\C\RPRLNEX.PC]	Use(select )
val_pop_sel	C/C++ Function	[F:\BANNER\C\RPRHDRL.PC]	Use(select )
val_pop_sel	C/C++ Function	[F:\BANNER\C\RPRVABN.PC]	Use(select )
val_pop_sel	C/C++ Function	[F:\BANNER\C\RERIS00.PC]	Use(select )
val_pop_sel	C/C++ Function	[F:\BANNER\C\RBRABUD.PC]	Use(select )
validate_par_pop_sel	C/C++ Function	[F:\BANNER\C\PDPBDMC.PC]	Use(select )
GLBSLCT	SYNONYM	S4B70.PUBLIC	Rely on ()
GLBEXTR	TABLE	S4B70."GENERAL"	Refer( No Action )
GLRSFRM	TABLE	S4B70."GENERAL"	Refer( No Action )
GLRSLCT	TABLE	S4B70."GENERAL"	Refer( No Action )
GLVSLCT	VIEW	S4B70.BANINST1	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.ASASIGN	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.APIBRWS	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.APIBRWS	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.ASASIGN	Use(select )
CHECK_SLCT	Forms Trigger	BANNER7_FORMS.APACMAS	Use(select )
CHECK_SLCT	Forms Trigger	BANNER7_FORMS.APIBRWS	Use(select )
CHECK_SLCT	Forms Trigger	BANNER7_FORMS_10G.APIBRWS	Use(select )
CHECK_SLCT	Forms Trigger	BANNER7_FORMS_10G.APACMAS	Use(select )
CHECK_SLCT	Forms Trigger	BANNER7_FORMS_10G.ASASIGN	Use(select )
CHECK_SLCT	Forms Trigger	BANNER7_FORMS.ASASIGN	Use(select )
GET_SLCT_DESC	Forms Trigger	BANNER7_FORMS.GLIEXTR	Use(select )
GET_SLCT_DESC	Forms Trigger	BANNER7_FORMS_10G.GLAEXTR	Use(select )
GET_SLCT_DESC	Forms Trigger	BANNER7_FORMS_10G.GLIEXTR	Use(select )
GET_SLCT_DESC	Forms Trigger	BANNER7_FORMS.GLAEXTR	Use(select )
VALIDATE_SELECTION_ID	Forms Trigger	BANNER7_FORMS.GLRSLCT	Use(select )
VALIDATE_SELECTION_ID	Forms Trigger	BANNER7_FORMS_10G.GLRSLCT	Use(select )
CHECK_SELECTION_ID	Forms Trigger	BANNER7_FORMS.RORPOST.RORPOST	Use(select )
CHECK_SELECTION_ID	Forms Trigger	BANNER7_FORMS_10G.RORPOST.RORPOST	Use(select )
KEY-CREREC	Forms Trigger	BANNER7_FORMS.GLRSLCT.XCOPYBLK	Use(select )
KEY-CREREC	Forms Trigger	BANNER7_FORMS_10G.GLRSLCT.XCOPYBLK	Use(select )
POST-BLOCK	Forms Trigger	BANNER7_FORMS.GLRSLCT.KEY_BLOCK	Use(select )
POST-BLOCK	Forms Trigger	BANNER7_FORMS_10G.GLRSLCT.KEY_BLOCK	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.GLISLCT.GLVSLCT	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.GLISLCT.GLVSLCT	Use(select )
GLBSLCT_REC	Package variable	S4B70.BANINST1.BWDKPSRC	Rely on ()
GLBSLCT_REC	Package variable	S4B70.BANINST1.BWDKPSRC	Rely on ()
CHECK_GLBSLCT_C	Package cursor	S4B70.BANINST1.ROKSAPR	Use(select )
GLBSLCTVIEWC	Package cursor	S4B70.BANINST1.BWDKPSRC	Rely on () Use(select )
F_GLBSLCT_EQUAL	Package function	S4B70.BANINST1.GOKPVAL	Use(select )
P_PR_RORGRDE_VALIDATION	Package procedure	S4B70.BANINST1.ROKPVAL	Use(select )
P_PR_RORREGS_VALIDATION	Package procedure	S4B70.BANINST1.ROKPVAL	Use(select )
P_VALIDATE_GLBDATA	Package procedure	S4B70.BANINST1.GOKPVAL	Rely on ()
P_VALIDATE_GLBDATA	Package procedure	S4B70.BANINST1.GOKPVAL	Use(select )
P_VALID_POPULATION_SELECTION	Package procedure	S4B70.BANINST1.ROKPVAL	Use(select )
P_VALID_POP_SEL_3	Package procedure	S4B70.BANINST1.ROKPVAL	Use(select )
P_VALID_POP_SEL_4	Package procedure	S4B70.BANINST1.ROKPVAL	Use(select )
F_GLBSLCT_EQUAL	Package function	S4B70.BANINST1.AOKPVAL	Use(select )
GLBSLCT	Forms DataBlock	BANNER7_FORMS.GLRSLCT	Rely on () Use(insert,update,delete,select )
GLBSLCT	Forms DataBlock	BANNER7_FORMS_10G.GLRSLCT	Rely on () Use(insert,update,delete,select )
GLBSLCT_CPY	Forms DataBlock	BANNER7_FORMS.GLRSLCT	Rely on () Use(insert,update,delete,select )
GLBSLCT_CPY	Forms DataBlock	BANNER7_FORMS_10G.GLRSLCT	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

Source Code Comments

Population Selection Base Table

Columns Comments for GLBSLCT_APPLICATION (1)

Source Code Comments

APPLICATION: Application code which with the selectino code uniquely identifies this record.

Columns Comments for GLBSLCT_SELECTION (2)

Source Code Comments

SELECTION: Selection code which with the application code uniquely identifies this record.

Columns Comments for GLBSLCT_CREATOR_ID (3)

Source Code Comments

CREATOR ID: The user id of the person who created this population selection.

Columns Comments for GLBSLCT_DESC (4)

Source Code Comments

DESCRIPTION: Description of this population selection.

Columns Comments for GLBSLCT_LOCK_IND (5)

Source Code Comments

LOCK INDICATOR: Indicator which indicates that this population selection is locked and cannot be executedby any other user.

Columns Comments for GLBSLCT_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: Date that record was created or last updated.

Columns Comments for GLBSLCT_TYPE_IND (7)

Source Code Comments

SELECTION TYPE: Values are (M)anual PIDM joins required on form - GLOLETT will not add them, or blank.

Table GLBVRBL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GLBVRBL_APPLICATION	GLBVRBL_APPLICATION	VARCHAR2(30)	No	*	*
GLBVRBL_VARIABLE	GLBVRBL_VARIABLE	VARCHAR2(30)	No	*
GLBVRBL_DESC	GLBVRBL_DESC	VARCHAR2(30)	No
GLBVRBL_ACTIVITY_DATE	GLBVRBL_ACTIVITY_DATE	DATE	No
GLBVRBL_TYPE_IND	GLBVRBL_TYPE_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLBVRBL_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL

Index

Index Name	Index Type	Column Name
PK_GLBVRBL	Unique	GLBVRBL_APPLICATION
PK_GLBVRBL	Unique	GLBVRBL_VARIABLE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
D01-GET-ALL-TABLES	Cobol Paragraph	[F:\banner\cobol].GLOLETT.A00-INIT-EXIT-ORACLE	Use()
D03B-BUILD-GLBVRBL-2	Cobol Paragraph	[F:\banner\cobol].GLOLETT.A00-INIT-EXIT-ORACLE	Use()
D04-PROCESS-LIST	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use()
E01-GENERATE-QUERY-COND	Cobol Paragraph	[F:\banner\cobol].GLOLETT.A00-INIT-EXIT-ORACLE	Use(select )
E06G-FETCH-PARM2	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use(select )
E07-GENERATE-VARIABLE	Cobol Paragraph	[F:\banner\cobol].GLOLETT.A00-INIT-EXIT-ORACLE	Use(select )
Y06C-NOADDRID-FETCH	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use()
chk_sign_or_chkl	C/C++ Function	[F:\BANNER\C\GLRLETR.PC]	Use(select )
GLBVRBL	SYNONYM	S4B70.PUBLIC	Rely on ()
GLRCALC	TABLE	S4B70."GENERAL"	Refer( No Action )
GLRCOLR	TABLE	S4B70."GENERAL"	Refer( No Action )
GLRORDR	TABLE	S4B70."GENERAL"	Refer( No Action )
GLRVFRM	TABLE	S4B70."GENERAL"	Refer( No Action )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GLRVRBL.GLRVRBL.GLRVRBL_VALUE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GLRSLCT.GLRSLCT.GLRSLCT_VALUE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GUAPARA.GUBPARA.GUBPARA_TEXT_VAR	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GLRSLCT.GLRSLCT.GLRSLCT_VALUE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GLRVRBL.GLRVRBL.GLRVRBL_VALUE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GUAPARA.GUBPARA.GUBPARA_TEXT_VAR	Use(select )
VALIDATE_VARIABLE_NAME	Forms Trigger	BANNER7_FORMS.GLRVRBL	Use(select )
VALIDATE_VARIABLE_NAME	Forms Trigger	BANNER7_FORMS_10G.GLRVRBL	Use(select )
POST-BLOCK	Forms Trigger	BANNER7_FORMS.GLRVRBL.KEY_BLOCK	Use(select )
POST-BLOCK	Forms Trigger	BANNER7_FORMS_10G.GLRVRBL.KEY_BLOCK	Use(select )
SELECT_GLBVRBL_2	Forms Function	BANNER7_FORMS.GLRVRBL	Use(select )
SELECT_GLBVRBL_2	Forms Function	BANNER7_FORMS_10G.GLRVRBL	Use(select )
GLBVRBL	Forms DataBlock	BANNER7_FORMS.GLRVRBL	Rely on () Use(insert,update,delete,select )
GLBVRBL	Forms DataBlock	BANNER7_FORMS.GLIVRBL	Rely on () Use(insert,update,delete,select )
GLBVRBL	Forms DataBlock	BANNER7_FORMS_10G.GLIVRBL	Rely on () Use(insert,update,delete,select )
GLBVRBL	Forms DataBlock	BANNER7_FORMS_10G.GLRVRBL	Rely on () Use(insert,update,delete,select )
GLBVRBL_CPY	Forms DataBlock	BANNER7_FORMS.GLRVRBL	Rely on () Use(insert,update,delete,select )
GLBVRBL_CPY	Forms DataBlock	BANNER7_FORMS_10G.GLRVRBL	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

Source Code Comments

Letter Generation Variable Base Table

Columns Comments for GLBVRBL_APPLICATION (1)

Source Code Comments

APPLICATION: Application code which with the variable uniquely identifies this record.

Columns Comments for GLBVRBL_VARIABLE (2)

Source Code Comments

VARIABLE: Variable code which with the application uniquely identifies this record.

Columns Comments for GLBVRBL_DESC (3)

Source Code Comments

DESCRIPTION: Description of this variable.

Columns Comments for GLBVRBL_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: Date that record was created or last updated.

Columns Comments for GLBVRBL_TYPE_IND (5)

Source Code Comments

VARIABLE TYPE: Values are (C)hecklist, (S)ignature, (M)anual PIDM joins required on form - GLOLETT will not add them, (F)irst variable to be processed by GLBLSEL, or blank.

Table GLRAPPL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GLRAPPL_APPLICATION	GLRAPPL_APPLICATION	VARCHAR2(30)	No	*	*
GLRAPPL_KEY_NO	GLRAPPL_KEY_NO	NUMBER(4,0)	No	*
GLRAPPL_LINE_NO	GLRAPPL_LINE_NO	NUMBER(4,0)	No
GLRAPPL_ACTIVITY_DATE	GLRAPPL_ACTIVITY_DATE	DATE	No
GLRAPPL_DATA_ELEMENT	GLRAPPL_DATA_ELEMENT	VARCHAR2(35)	No
GLRAPPL_OPERATOR	GLRAPPL_OPERATOR	VARCHAR2(11)	No
GLRAPPL_VALUE	GLRAPPL_VALUE	VARCHAR2(80)	Yes
GLRAPPL_OPEN_PAREN	GLRAPPL_OPEN_PAREN	VARCHAR2(3)	Yes
GLRAPPL_CLOSE_PAREN	GLRAPPL_CLOSE_PAREN	VARCHAR2(3)	Yes
GLRAPPL_SEPARATOR	GLRAPPL_SEPARATOR	VARCHAR2(3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRAPPL_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL

Index

Index Name	Index Type	Column Name
PK_GLRAPPL	Unique	GLRAPPL_APPLICATION
PK_GLRAPPL	Unique	GLRAPPL_KEY_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
C03A-GET-APPL-PARMS	Cobol Paragraph	[F:\banner\cobol].GLBDATA.A01-INIT-EXIT-ORACLE	Use(select )
Y09-SLCT	Cobol Paragraph	[F:\banner\cobol].GLOLETT.A00-INIT-EXIT-ORACLE	Use(select )
Y09B-FETCH-GOOD-REC	Cobol Paragraph	[F:\banner\cobol].GLOLETT.A00-INIT-EXIT-ORACLE	Use()
GLRAPPL	SYNONYM	S4B70.PUBLIC	Rely on ()
GET_KEY	Forms Trigger	BANNER7_FORMS.GLRAPPL	Use(select )
GET_KEY	Forms Trigger	BANNER7_FORMS_10G.GLRAPPL	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.GLRAPPL.GLBAPPL	Use(delete )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.GLRAPPL.GLBAPPL	Use(delete )
LOAD_GLBDATA_COL_INFO	Forms Procedure	BANNER7_FORMS.GJAPCTL	Rely on () Use(select )
LOAD_GLBDATA_COL_INFO	Forms Procedure	BANNER7_FORMS_10G.GJAPCTL	Rely on () Use(select )
GLRAPPL	Forms DataBlock	BANNER7_FORMS.GLRAPPL	Rely on () Use(insert,update,delete,select )
GLRAPPL	Forms DataBlock	BANNER7_FORMS_10G.GLRAPPL	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

Source Code Comments

Letter Generation Application Rules Table

Columns Comments for GLRAPPL_APPLICATION (1)

Source Code Comments

APPLICATION: The application code that uniquely identifies this Selection Identifier.

Columns Comments for GLRAPPL_KEY_NO (2)

Source Code Comments

SEQUENCE NUMBER: The internal number that uniquely identifies this line of the Selection Identifier.

Columns Comments for GLRAPPL_LINE_NO (3)

Source Code Comments

LINE NUMBER: The internal line number for ordering of the records.

Columns Comments for GLRAPPL_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for GLRAPPL_DATA_ELEMENT (5)

Source Code Comments

DATA ELEMENT: The name of the database column that is referenced in this Selection condition.

Columns Comments for GLRAPPL_OPERATOR (6)

Source Code Comments

OPERATOR: The SQL operator used to link the Data Element and the Value. Valid values are =, >=, <=, >, <, IN, NOT IN, LIKE, NOT LIKE, BETWEEN, NOT BETWEEN, IS NULL, IS NOT NULL, ANY, and ALL.

Columns Comments for GLRAPPL_VALUE (7)

Source Code Comments

VALUE: The value that is compared to the Data Element based on the Operator. Note that when the Operator contains IS NULL or IS NOT NULL, a value is not allowed. The value must conform to standard SQL character and date formats.

Columns Comments for GLRAPPL_OPEN_PAREN (8)

Source Code Comments

OPEN PARENTHESIS: This field may contain an open parenthesis "(" if nested conditions are used within this Selection Identifier. Note that the count of open parens must equal the count of close parens in the Selection Identifier.

Columns Comments for GLRAPPL_CLOSE_PAREN (9)

Source Code Comments

CLOSE PARENTHESIS: This field may contain a close parenthesis ")" if nested conditions are used within this Selection Identifier. Note that the count of close parens must equal the count of open parens in the Selection Identifier.

Columns Comments for GLRAPPL_SEPARATOR (10)

Source Code Comments

SEPARATOR: The separator between multiple lines in a Selection Identifier. Valid values are AND and OR. Note that all lines in a Selection Identifier, except for the last, must contain a Separator.

Table GLRCALC

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GLRCALC_APPLICATION	GLRCALC_APPLICATION	VARCHAR2(30)	No	*	*
GLRCALC_LETR_CODE	GLRCALC_LETR_CODE	VARCHAR2(15)	No	*	*
GLRCALC_VARIABLE	GLRCALC_VARIABLE	VARCHAR2(30)	No	*	*
GLRCALC_PIDM	GLRCALC_PIDM	NUMBER(8,0)	No	*
GLRCALC_ROWNUM	GLRCALC_ROWNUM	NUMBER(8,0)	No	*
GLRCALC_ACTIVITY_DATE	GLRCALC_ACTIVITY_DATE	DATE	No
GLRCALC_AMT01	GLRCALC_AMT01	NUMBER(11,2)	Yes
GLRCALC_AMT02	GLRCALC_AMT02	NUMBER(11,2)