Model Electronic Approvals

Model Label : Banner HR Electronic Approvals Module
Path : Default Folder/B70/payroll/Electronic Approvals

List of Objects

Object Name	Object Type	Layer Name
NOBTRAN	TABLE	Main Objects
NORROUT	TABLE	Default
NORTERN	TABLE	Default
NORTLBD	TABLE	Default
NORTRAN	TABLE	Default
NTVACAT	TABLE	Default
SPRIDEN	TABLE	Default

Comments

Model View

Table NOBTRAN

Schema Name POSNCTL
Label NOBTRAN
Server name S4B70
Creation Date 09/29/2003 12:11:57:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
NOBTRAN_TRANSACTION_NO	NOBTRAN_TRANSACTION_NO	NUMBER(15,0)	No	*
NOBTRAN_PIDM	NOBTRAN_PIDM	NUMBER(8,0)	Yes
NOBTRAN_EFFECTIVE_DATE	NOBTRAN_EFFECTIVE_DATE	DATE	Yes
NOBTRAN_ACAT_CODE	NOBTRAN_ACAT_CODE	VARCHAR2(6)	No		*
NOBTRAN_TRANS_STATUS_IND	NOBTRAN_TRANS_STATUS_IND	VARCHAR2(1)	No
NOBTRAN_SUBMITTOR_USER_ID	NOBTRAN_SUBMITTOR_USER_ID	VARCHAR2(30)	Yes
NOBTRAN_CREATED_DATE	NOBTRAN_CREATED_DATE	DATE	No
NOBTRAN_ORIGINATOR_USER_ID	NOBTRAN_ORIGINATOR_USER_ID	VARCHAR2(30)	No		*
NOBTRAN_SUBMISSION_DATE	NOBTRAN_SUBMISSION_DATE	DATE	Yes
NOBTRAN_APPLY_IND	NOBTRAN_APPLY_IND	VARCHAR2(1)	No
NOBTRAN_APPLY_DATE	NOBTRAN_APPLY_DATE	DATE	Yes
NOBTRAN_APPLY_USER_ID	NOBTRAN_APPLY_USER_ID	VARCHAR2(30)	Yes
NOBTRAN_ACTIVITY_DATE	NOBTRAN_ACTIVITY_DATE	DATE	No
NOBTRAN_COMMENTS	NOBTRAN_COMMENTS	LONG	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
NOBTRAN_ACAT_CODE	NTVACAT_CODE	NTVACAT
NOBTRAN_ORIGINATOR_USER_ID	GOBEACC_USERNAME	GOBEACC

Index

Index Name	Index Type	Column Name
NOBTRAN_KEY2_INDEX		NOBTRAN_APPLY_IND
NOBTRAN_KEY2_INDEX		NOBTRAN_APPLY_USER_ID
NOBTRAN_KEY3_INDEX		NOBTRAN_TRANS_STATUS_IND
NOBTRAN_KEY3_INDEX		NOBTRAN_SUBMISSION_DATE
NOBTRAN_KEY_INDEX		NOBTRAN_PIDM
PK_NOBTRAN	Unique	NOBTRAN_TRANSACTION_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
count_noreaer	C/C++ Function	[F:\BANNER\C\NOPEAMA.PC]	Use(select )
declare_cursors	C/C++ Function	[F:\BANNER\C\NOPEAMA.PC]	Use(select )
delete_noreaer	C/C++ Function	[F:\BANNER\C\NOPEAMA.PC]	Use(select )
get_empl_info	C/C++ Function	[F:\BANNER\C\NOPEAMA.PC]	Use(select )
sel_nobtran	C/C++ Function	[F:\BANNER\C\NORAPTR.PC]	Use(select )
sel_pending	C/C++ Function	[F:\BANNER\C\NBPMASS.PC]	Use(select )
update_records	C/C++ Function	[F:\BANNER\C\NOPEAMA.PC]	Use(update )
NOBTRAN	SYNONYM	S4B70.PUBLIC	Rely on ()
NORTLBD	TABLE	S4B70.POSNCTL	Refer( No Action )
SPRIDEN	TABLE	S4B70.SATURN	Join
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PEAFACT.PERSABB.PERSABB_TRANS_NO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.NOIEMSG.KEY_BLOCK.TRANS_NO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF.KEY_BLOCK.TRANS_NO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PEAFACT.PERSABB.PERSABB_TRANS_NO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.NOAEPAF.KEY_BLOCK.TRANS_NO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.NOIEMSG.KEY_BLOCK.TRANS_NO	Use(select )
POST-TEXT-ITEM	Forms Trigger	BANNER7_FORMS.NOIEMSG.KEY_BLOCK.TRANS_NO	Use(select )
POST-TEXT-ITEM	Forms Trigger	BANNER7_FORMS_10G.NOIEMSG.KEY_BLOCK.TRANS_NO	Use(select )
CANCEL_BTRAN_STATUS	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(update )
CANCEL_BTRAN_STATUS	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(update )
CANCEL_TRANS_BTRAN	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(update )
CANCEL_TRANS_BTRAN	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(update )
CHECK_TRANS	Forms Trigger	BANNER7_FORMS.NOIEMSG	Use(select )
CHECK_TRANS	Forms Trigger	BANNER7_FORMS_10G.NOIEMSG	Use(select )
DEL_BTRAN	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(delete )
DEL_BTRAN	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(delete )
ENABLE_BTNS	Forms Trigger	BANNER7_FORMS.NOIEMSG	Use(select )
ENABLE_BTNS	Forms Trigger	BANNER7_FORMS_10G.NOIEMSG	Use(select )
FIND_NEXT_TRANS	Forms Trigger	BANNER7_FORMS.NOIEMSG	Use(select )
FIND_NEXT_TRANS	Forms Trigger	BANNER7_FORMS_10G.NOIEMSG	Use(select )
FIND_PREV_TRANS	Forms Trigger	BANNER7_FORMS.NOIEMSG	Use(select )
FIND_PREV_TRANS	Forms Trigger	BANNER7_FORMS_10G.NOIEMSG	Use(select )
GET_DEFAULTS_FOR_TRANS_NO	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_DEFAULTS_FOR_TRANS_NO	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_NEW_TRANS_STATUS_IND	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_NEW_TRANS_STATUS_IND	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_TRANS_STATUS_IND	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_TRANS_STATUS_IND	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
INSERT_INTO_NOBTRAN	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(insert )
INSERT_INTO_NOBTRAN	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(insert )
UPDATE_NOBTRAN_APPLIER	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(update )
UPDATE_NOBTRAN_APPLIER	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(update )
UPDATE_NOBTRAN_SUBMITTOR	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(update )
UPDATE_NOBTRAN_SUBMITTOR	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(update )
UPDATE_TS_TO_PENDING	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(update )
UPDATE_TS_TO_PENDING	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(update )
NOBTRAN_RG	Forms Record Group	BANNER7_FORMS.NOIESUM	Use(select )
NOBTRAN_RG	Forms Record Group	BANNER7_FORMS_10G.NOIESUM	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS.NOAAPSM.NOBTRAN	Use(update )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS_10G.NOAAPSM.NOBTRAN	Use(update )
CHECK_IF_ORIGINATOR	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_IF_ORIGINATOR	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_TRANSACTION_UPDATE	Forms Procedure	BANNER7_FORMS.PEAEMPL	Use(update )
CHECK_TRANSACTION_UPDATE	Forms Procedure	BANNER7_FORMS.NBAJOBS	Use(update )
CHECK_TRANSACTION_UPDATE	Forms Procedure	BANNER7_FORMS_10G.NBAJOBS	Use(update )
CHECK_TRANSACTION_UPDATE	Forms Procedure	BANNER7_FORMS_10G.PEAEMPL	Use(update )
GET_EXISTING_TRANS_NO	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
GET_EXISTING_TRANS_NO	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_TRANSACTIONS	Forms Procedure	BANNER7_FORMS.PEAEMPL	Use(select )
GET_TRANSACTIONS	Forms Procedure	BANNER7_FORMS.NBAJOBS	Use(select )
GET_TRANSACTIONS	Forms Procedure	BANNER7_FORMS_10G.PEAEMPL	Use(select )
GET_TRANSACTIONS	Forms Procedure	BANNER7_FORMS_10G.NBAJOBS	Use(select )
N$_EA_APPROVALS_MSG	Forms Procedure	BANNER7_FORMS.NOQMENU	Use(select )
N$_EA_APPROVALS_MSG	Forms Procedure	BANNER7_FORMS.POQMENU	Use(select )
N$_EA_APPROVALS_MSG	Forms Procedure	BANNER7_FORMS_10G.POQMENU	Use(select )
N$_EA_APPROVALS_MSG	Forms Procedure	BANNER7_FORMS_10G.NOQMENU	Use(select )
N$_EA_APPROVALS_MSG_HR	Forms Procedure	BANNER7_FORMS.NOQMENU	Use(select )
N$_EA_APPROVALS_MSG_HR	Forms Procedure	BANNER7_FORMS_10G.POQMENU	Use(select )
N$_EA_APPROVALS_MSG_HR	Forms Procedure	BANNER7_FORMS.POQMENU	Use(select )
N$_EA_APPROVALS_MSG_HR	Forms Procedure	BANNER7_FORMS_10G.NOQMENU	Use(select )
POPULATE_HOLD_NORROUT_RECORDS	Forms Procedure	BANNER7_FORMS.NOAAPSM	Use(select )
POPULATE_HOLD_NORROUT_RECORDS	Forms Procedure	BANNER7_FORMS_10G.NOAAPSM	Use(select )
SELECT_COMMENTS	Forms Procedure	BANNER7_FORMS.NOAAPSM	Use(select )
SELECT_COMMENTS	Forms Procedure	BANNER7_FORMS_10G.NOAAPSM	Use(select )
UPDATE_APPLY_USER_ID	Forms Procedure	BANNER7_FORMS.NOAAPSM	Use(update )
UPDATE_APPLY_USER_ID	Forms Procedure	BANNER7_FORMS_10G.NOAAPSM	Use(update )
UPDATE_NOBTRAN_APPLY_STATUS	Forms Procedure	BANNER7_FORMS.PEAEMPL	Use(update )
UPDATE_NOBTRAN_APPLY_STATUS	Forms Procedure	BANNER7_FORMS_10G.PEAEMPL	Use(update )
UPDATE_NOBTRAN_APPLY_STATUS	Forms Procedure	BANNER7_FORMS_10G.NBAJOBS	Use(update )
UPDATE_NOBTRAN_APPLY_STATUS	Forms Procedure	BANNER7_FORMS.NBAJOBS	Use(update )
UPDATE_NORROUT_QUEUE_STATUS	Forms Procedure	BANNER7_FORMS.NOAAPSM	Use(select )
UPDATE_NORROUT_QUEUE_STATUS	Forms Procedure	BANNER7_FORMS_10G.NOAAPSM	Use(select )
N$_EA_EDIT_APPROVER_ACTION	Forms Procedure	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_EDIT_APPROVER_ACTION	Forms Procedure	BANNER7_FORMS_10G.NOQLPLS	Use(select )
N$_EA_SEND_MESSAGE_ORIGINATOR	Forms Procedure	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_SEND_MESSAGE_ORIGINATOR	Forms Procedure	BANNER7_FORMS_10G.NOQLPLS	Use(select )
F_GET_ACAT_SEQ_NO	FUNCTION	S4B70.BANINST1	Use(select )
CHECK_STATUS_IND	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_STATUS_IND	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_TRANS_ID	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
GET_TRANS_ID	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
IS_ORIGINATOR	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
IS_ORIGINATOR	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
JUST_WARNING_MSG_EXIST	Forms Function	BANNER7_FORMS.NOIEMSG	Use(select )
JUST_WARNING_MSG_EXIST	Forms Function	BANNER7_FORMS_10G.NOIEMSG	Use(select )
ORIGINATOR_IN_NOBTRAN	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
ORIGINATOR_IN_NOBTRAN	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
SELECT_ACAT_WAITING	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
SELECT_ACAT_WAITING	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
SELECT_NOBTRAN_FOUND	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
SELECT_NOBTRAN_FOUND	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
SELECT_NOBTRAN_PENDING	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
SELECT_NOBTRAN_PENDING	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
SUBMITTED_ALREADY	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
SUBMITTED_ALREADY	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
N$_EA_EDIT_ORIGINATOR	Forms Function	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_EDIT_ORIGINATOR	Forms Function	BANNER7_FORMS_10G.NOQLPLS	Use(select )
N$_EA_ORIGINATOR_WITHOUT_TRANS	Forms Function	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_ORIGINATOR_WITHOUT_TRANS	Forms Function	BANNER7_FORMS_10G.NOQLPLS	Use(select )
PK_VAR_PIDM	Package variable	S4B70.BANINST1.NOKEDIT	Rely on ()
P_DELETE_TRANSACTION	Package procedure	S4B70.BANINST1.PEK1PAY	Use(delete )
P_INSERT_NOBTRAN	Package procedure	S4B70.BANINST1.PEK1PAY	Use(insert )
P_UPDATE_EA_RECORDS	Package procedure	S4B70.BANINST1.PEK1PAY	Use(update )
TRANS_IND_CURSOR	Package cursor	S4B70.BANINST1.NOKEPAF	Use(select )
P_DELETE_TRANSACTION	Package procedure	S4B70.BANINST1.NOKEPAF	Use(delete )
P_EA_SEND_MESSAGE_ORIGINATOR	Package procedure	S4B70.BANINST1.NOKEPAF	Use(select )
P_GET_EPAF	Package procedure	S4B70.BANINST1.BWPCBREF	Rely on ()
P_GET_EPAF	Package procedure	S4B70.BANINST1.BWPCBREF	Use(select )
P_GET_PAF_POSN_INFO	Package procedure	S4B70.BANINST1.POKWLIB	Rely on ()
P_GET_PAF_POSN_INFO	Package procedure	S4B70.BANINST1.POKWLIB	Use(select )
P_INSERT_NOBTRAN	Package procedure	S4B70.BANINST1.NOKEPAF	Use(insert )
P_NOBTRANPAFCHANGE	Package procedure	S4B70.BANINST1.NOKWEVN	Rely on ()
P_PROCESS_NBRJLBD_RECS	Package procedure	S4B70.BANINST1.NOKMUPD	Rely on ()
P_UPDATE_EA_RECORDS	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
P_UPDATE_NOBTRAN_STATUS	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
P_VOID_EPAF	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
F_EA_EDIT_ORIGINATOR	Package function	S4B70.BANINST1.NOKEPAF	Use(select )
F_GET_EPAF_DEFAULT	Package function	S4B70.BANINST1.BWPCXCHN	Rely on ()
F_GET_NOBTRAN_COMMENTS	Package function	S4B70.BANINST1.NOKP2LB	Use(select )
F_GET_NOBTRAN_STATUS	Package function	S4B70.BANINST1.NOKMISC	Use(select )
F_GET_NORROUT_ACTION	Package function	S4B70.BANINST1.BWNCBREF	Rely on ()
F_GET_NORROUT_ACTION	Package function	S4B70.BANINST1.BWPCBREF	Use(select )
F_GET_NORROUT_ACTION	Package function	S4B70.BANINST1.BWPCBREF	Rely on ()
F_GET_NORROUT_LEVEL	Package function	S4B70.BANINST1.BWPCBREF	Use(select )
F_GET_NORROUT_LEVEL	Package function	S4B70.BANINST1.BWPCBREF	Rely on ()
F_GET_NORROUT_QUEUE_STATUS	Package function	S4B70.BANINST1.BWPCBREF	Use(select )
F_GET_NORROUT_QUEUE_STATUS	Package function	S4B70.BANINST1.BWPCBREF	Rely on ()
F_GET_NORTRAN_POSN	Package function	S4B70.BANINST1.BWPCBREF	Rely on ()
F_GET_NORTRAN_SUFF	Package function	S4B70.BANINST1.BWPCBREF	Rely on ()
F_GET_TRANS_EFF_DATE	Package function	S4B70.BANINST1.NOKEPAF	Use(select )
NOBTRAN	Forms DataBlock	BANNER7_FORMS.NOAAPSM	Rely on () Use(insert,update,delete,select )
NOBTRAN	Forms DataBlock	BANNER7_FORMS.NOAEPAF	Rely on () Use(insert,update,delete,select )
NOBTRAN	Forms DataBlock	BANNER7_FORMS_10G.NOAAPSM	Rely on () Use(insert,update,delete,select )
NOBTRAN	Forms DataBlock	BANNER7_FORMS_10G.NOAEPAF	Rely on () Use(insert,update,delete,select )
NOIESUM	Forms DataBlock	BANNER7_FORMS.NOIESUM	Rely on () Use(insert,update,delete,select )
NOIESUM	Forms DataBlock	BANNER7_FORMS_10G.NOIESUM	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
NOBTRAN_KEY2_INDEX	INDEX	S4B70.POSNCTL	Rely on ()
NOBTRAN_KEY3_INDEX	INDEX	S4B70.POSNCTL	Rely on ()
NOBTRAN_KEY_INDEX	INDEX	S4B70.POSNCTL	Rely on ()
PK_NOBTRAN	INDEX	S4B70.POSNCTL	Rely on ()
NT_WFAIR_PAFCHANGE_INSERT	TRIGGER	S4B70.POSNCTL	Fire(insert after each row )
NT_WFAUR_PAFCHANGE_UPDATE	TRIGGER	S4B70.POSNCTL	Fire(update after each row )
GOBEACC	TABLE	S4B70."GENERAL"	Join
NTVACAT	TABLE	S4B70.POSNCTL	Refer( No Action )

Comments

Source Code Comments

Transaction Approvals Base Table

Columns Comments for NOBTRAN_TRANSACTION_NO (1)

Source Code Comments

TRANSACTION NUMBER: A number that is system generated for approval transactions.

Columns Comments for NOBTRAN_PIDM (2)

Source Code Comments

PIDM: Internal Id number.

Columns Comments for NOBTRAN_EFFECTIVE_DATE (3)

Source Code Comments

EFFECTIVE DATE: The Date that the approval transaction record becomes effective.

Columns Comments for NOBTRAN_ACAT_CODE (4)

Source Code Comments

APPROVAL CATEGORY CODE: This code represents the purpose of the personnel action.

Columns Comments for NOBTRAN_TRANS_STATUS_IND (5)

Source Code Comments

TRANSACTION STATUS INDICATOR: The status of the approval transaction.

Columns Comments for NOBTRAN_SUBMITTOR_USER_ID (6)

Source Code Comments

SUBMITTOR USER ID: The user id of the submittor of the approval transaction.

Columns Comments for NOBTRAN_CREATED_DATE (7)

Source Code Comments

CREATED DATE: The date the approval transaction is created.

Columns Comments for NOBTRAN_ORIGINATOR_USER_ID (8)

Source Code Comments

ORIGINATOR USER ID: The user id of the person who creates the transaction.

Columns Comments for NOBTRAN_SUBMISSION_DATE (9)

Source Code Comments

SUBMISSION DATE: The date the transaction is submitted to start the transaction through the approval queue.

Columns Comments for NOBTRAN_APPLY_IND (10)

Source Code Comments

APPLY INDICATOR: The indicator to apply transactions to the database.

Columns Comments for NOBTRAN_APPLY_DATE (11)

Source Code Comments

APPLICATION DATE: The date the transaction is applied.

Columns Comments for NOBTRAN_APPLY_USER_ID (12)

Source Code Comments

APPLY USER ID: The user id of the person who applies the transaction.

Columns Comments for NOBTRAN_ACTIVITY_DATE (13)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for NOBTRAN_COMMENTS (14)

Source Code Comments

COMMENTS: Comments with regards to the action taken on the Approvals transaction.

Table NORROUT

Schema Name POSNCTL
Label NORROUT
Server name S4B70
Creation Date 09/29/2003 12:11:57:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
NORROUT_TRANSACTION_NO	NORROUT_TRANSACTION_NO	NUMBER(15,0)	No
NORROUT_RECIPIENT_USER_ID	NORROUT_RECIPIENT_USER_ID	VARCHAR2(30)	Yes
NORROUT_ACTION_USER_ID	NORROUT_ACTION_USER_ID	VARCHAR2(30)	Yes
NORROUT_ALVL_CODE	NORROUT_ALVL_CODE	VARCHAR2(6)	No	*
NORROUT_ACTION_IND	NORROUT_ACTION_IND	VARCHAR2(1)	No
NORROUT_QUEUE_STATUS_IND	NORROUT_QUEUE_STATUS_IND	VARCHAR2(1)	No
NORROUT_STATUS_DATE_TIME	NORROUT_STATUS_DATE_TIME	DATE	No
NORROUT_ACTIVITY_DATE	NORROUT_ACTIVITY_DATE	DATE	No
NORROUT_LEVEL_NO	NORROUT_LEVEL_NO	NUMBER(5,2)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
NORROUT_ALVL_CODE	NTRALVL_CODE	NTRALVL
NORROUT_ALVL_CODE	NTRLVID_ALVL_CODE	NTRLVID

Index

Index Name	Index Type	Column Name
NORROUT_KEY2_INDEX		NORROUT_RECIPIENT_USER_ID
NORROUT_KEY2_INDEX		NORROUT_QUEUE_STATUS_IND
NORROUT_KEY_INDEX		NORROUT_TRANSACTION_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
declare_cursors	C/C++ Function	[F:\BANNER\C\NOPEAMA.PC]	Use(select )
update_records	C/C++ Function	[F:\BANNER\C\NOPEAMA.PC]	Use(update )
NORROUT	SYNONYM	S4B70.PUBLIC	Rely on ()
CANCEL_QUE_STATUS	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(update )
CANCEL_QUE_STATUS	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(update )
CHANGE_LOWER_LEVELS_TO_FYI	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
CHANGE_LOWER_LEVELS_TO_FYI	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_HIGHEST_APPLY_LEVEL_NO	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_HIGHEST_APPLY_LEVEL_NO	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_HIGHEST_APPROVED_LEVEL	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_HIGHEST_APPROVED_LEVEL	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_IF_PROXY_FOR_IN_QUEUE	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_IF_PROXY_FOR_IN_QUEUE	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
DEFAULT_FROM_NTRACAT_NO_APPLY	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(insert )
DEFAULT_FROM_NTRACAT_NO_APPLY	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(insert )
DEFAULT_FROM_NTRACAT_W_APPLY	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(insert )
DEFAULT_FROM_NTRACAT_W_APPLY	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(insert )
DEFAULT_FROM_NTRROUT_NO_APPLY	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(insert )
DEFAULT_FROM_NTRROUT_NO_APPLY	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(insert )
DEFAULT_FROM_NTRROUT_W_APPLY	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(insert )
DEFAULT_FROM_NTRROUT_W_APPLY	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(insert )
DEL_ROUT	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(delete )
DEL_ROUT	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(delete )
GET_APPLY_LEVEL_NO	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_APPLY_LEVEL_NO	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_MIN_LVL_TO_UPD_TO_PENDING	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_MIN_LVL_TO_UPD_TO_PENDING	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_NOBTRAN_ORIGINATR_LEVEL_NO	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_NOBTRAN_ORIGINATR_LEVEL_NO	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_ORIGINATORS_QUEUE_STATUS	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_ORIGINATORS_QUEUE_STATUS	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_PENDING_LEVEL_NO	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_PENDING_LEVEL_NO	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_QS_OF_USER_LOGGED_ON	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(select )
GET_QS_OF_USER_LOGGED_ON	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(select )
UPDATE_NEXT_LEVEL_TO_IN_QUEUE	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(update )
UPDATE_NEXT_LEVEL_TO_IN_QUEUE	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(update )
UPDATE_NORROUT_1ST_APPROVALS	Forms Trigger	BANNER7_FORMS.NOAEPAF	Use(update,select )
UPDATE_NORROUT_1ST_APPROVALS	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF	Use(update,select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.NOAEPAF.NORROUT	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.NOAEPAF.NORROUT	Use(select )
CHECK_IF_APPLIER	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_IF_APPLIER	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_NORROUT_APPLY	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_NORROUT_APPLY	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_ACTION_IND	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
GET_ACTION_IND	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_APPLY_ACTION_IND	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
GET_APPLY_ACTION_IND	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
GET_ORIGINATOR_LEVEL_NO	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
GET_ORIGINATOR_LEVEL_NO	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
HIGHEST_APPLY_LEVEL_NO	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
HIGHEST_APPLY_LEVEL_NO	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
N$_EA_APPROVALS_MSG	Forms Procedure	BANNER7_FORMS.NOQMENU	Use(select )
N$_EA_APPROVALS_MSG	Forms Procedure	BANNER7_FORMS_10G.POQMENU	Use(select )
N$_EA_APPROVALS_MSG	Forms Procedure	BANNER7_FORMS_10G.NOQMENU	Use(select )
N$_EA_APPROVALS_MSG	Forms Procedure	BANNER7_FORMS.POQMENU	Use(select )
N$_EA_APPROVALS_MSG_HR	Forms Procedure	BANNER7_FORMS.NOQMENU	Use(select )
N$_EA_APPROVALS_MSG_HR	Forms Procedure	BANNER7_FORMS_10G.POQMENU	Use(select )
N$_EA_APPROVALS_MSG_HR	Forms Procedure	BANNER7_FORMS_10G.NOQMENU	Use(select )
N$_EA_APPROVALS_MSG_HR	Forms Procedure	BANNER7_FORMS.POQMENU	Use(select )
POPULATE_HOLD_LEVEL_NO	Forms Procedure	BANNER7_FORMS.NOAAPSM	Use(select )
POPULATE_HOLD_LEVEL_NO	Forms Procedure	BANNER7_FORMS_10G.NOAEPAF	Use(select )
POPULATE_HOLD_LEVEL_NO	Forms Procedure	BANNER7_FORMS_10G.NOAAPSM	Use(select )
POPULATE_HOLD_LEVEL_NO	Forms Procedure	BANNER7_FORMS.NOAEPAF	Use(select )
POPULATE_HOLD_NORROUT_RECORDS	Forms Procedure	BANNER7_FORMS.NOAAPSM	Use(select )
POPULATE_HOLD_NORROUT_RECORDS	Forms Procedure	BANNER7_FORMS_10G.NOAAPSM	Use(select )
SELECT_NORROUT	Forms Procedure	BANNER7_FORMS.NOAAPSM	Use(select )
SELECT_NORROUT	Forms Procedure	BANNER7_FORMS_10G.NOAAPSM	Use(select )
UPDATE_NOBTRAN_APPLY_STATUS	Forms Procedure	BANNER7_FORMS.PEAEMPL	Use(update )
UPDATE_NOBTRAN_APPLY_STATUS	Forms Procedure	BANNER7_FORMS.NBAJOBS	Use(update )
UPDATE_NOBTRAN_APPLY_STATUS	Forms Procedure	BANNER7_FORMS_10G.PEAEMPL	Use(update )
UPDATE_NOBTRAN_APPLY_STATUS	Forms Procedure	BANNER7_FORMS_10G.NBAJOBS	Use(update )
UPDATE_NORROUT_QUEUE_STATUS	Forms Procedure	BANNER7_FORMS.NOAAPSM	Use(update )
UPDATE_NORROUT_QUEUE_STATUS	Forms Procedure	BANNER7_FORMS_10G.NOAAPSM	Use(update )
N$_EA_APPROVAL_ACTION	Forms Procedure	BANNER7_FORMS.NOQLPLS	Use(update,select )
N$_EA_APPROVAL_ACTION	Forms Procedure	BANNER7_FORMS_10G.NOQLPLS	Use(update,select )
N$_EA_SEND_MESSAGE	Forms Procedure	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_SEND_MESSAGE	Forms Procedure	BANNER7_FORMS_10G.NOQLPLS	Use(select )
APPLY_LEVEL_IS_PENDING	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
APPLY_LEVEL_IS_PENDING	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_BELOW_ORIGINATOR	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_BELOW_ORIGINATOR	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_EACH_NORROUT	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_EACH_NORROUT	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_NORROUT_APPLY_LEVEL	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_NORROUT_APPLY_LEVEL	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_NORROUT_BELOW_ORIGINATOR	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_NORROUT_BELOW_ORIGINATOR	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_NORROUT_FOR_DUPS	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_NORROUT_FOR_DUPS	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_NORROUT_LEVELS	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_NORROUT_LEVELS	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
CHECK_PENDING_USER_ID	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
CHECK_PENDING_USER_ID	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
COUNT_MANDATORY_RECS	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
COUNT_MANDATORY_RECS	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
HIGHEST_LEVEL_FOR_APPLY	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
HIGHEST_LEVEL_FOR_APPLY	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
NORROUT_USER_ID_NULL	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
NORROUT_USER_ID_NULL	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
NTRACAT_NOT_IN_QUEUE	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
NTRACAT_NOT_IN_QUEUE	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
ORIGINATOR_IN_NORROUT	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
ORIGINATOR_IN_NORROUT	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
SELECT_NORROUT_PENDING	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
SELECT_NORROUT_PENDING	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
USER_IN_QUEUE	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
USER_IN_QUEUE	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
USER_W_APPLY_PRIV	Forms Function	BANNER7_FORMS.NOAEPAF	Use(select )
USER_W_APPLY_PRIV	Forms Function	BANNER7_FORMS_10G.NOAEPAF	Use(select )
N$_EA_EDIT_SUPERUSER	Forms Function	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_EDIT_SUPERUSER	Forms Function	BANNER7_FORMS_10G.NOQLPLS	Use(select )
N$_EA_MAX_LEVEL_WITH_MANY_REC	Forms Function	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_MAX_LEVEL_WITH_MANY_REC	Forms Function	BANNER7_FORMS_10G.NOQLPLS	Use(select )
N$_EA_QUEUE_STATUS	Forms Function	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_QUEUE_STATUS	Forms Function	BANNER7_FORMS_10G.NOQLPLS	Use(select )
N$_EA_QUEUE_STAT_PENDING	Forms Function	BANNER7_FORMS.NOQLPLS	Use(select )
N$_EA_QUEUE_STAT_PENDING	Forms Function	BANNER7_FORMS_10G.NOQLPLS	Use(select )
P_ACKNOWLEDGE	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update,select )
P_APPROVE	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update,select )
P_CHECK_MAX_LEVEL_NOT_F	Package procedure	S4B70.BANINST1.NOKEPAF	Use(select )
P_DELETE_TRANSACTION	Package procedure	S4B70.BANINST1.PEK1PAY	Use(delete )
P_DISAPPROVE	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
P_INSERT_NORROUT	Package procedure	S4B70.BANINST1.PEK1PAY	Use(insert )
P_MORE_INFO	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
P_PROCESS_ORIGINATOR	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
P_RETURN	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
P_SUPERUSER	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
P_UPDATE_EA_RECORDS	Package procedure	S4B70.BANINST1.PEK1PAY	Use(update )
P_UPDATE_QUEUE_STAT	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update,select )
P_AUTO_APPROVAL_NORROUT	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update,select )
P_AUTO_INSERT_NORROUT	Package procedure	S4B70.BANINST1.NOKEPAF	Use(insert )
P_AUTO_STATUS_NOBTRAN	Package procedure	S4B70.BANINST1.NOKEPAF	Use(select )
P_DELETE_TRANSACTION	Package procedure	S4B70.BANINST1.NOKEPAF	Use(delete )
P_EA_SEND_MESSAGE	Package procedure	S4B70.BANINST1.NOKEPAF	Use(select )
P_GET_EPAF	Package procedure	S4B70.BANINST1.BWNCBREF	Rely on ()
P_GET_EPAF	Package procedure	S4B70.BANINST1.BWPCBREF	Rely on ()
P_GET_EPAF	Package procedure	S4B70.BANINST1.BWPCBREF	Use(select )
P_GET_NEXT_PAF_USERID	Package procedure	S4B70.BANINST1.NOKWLIB	Use(select )
P_INSERT_NORROUT	Package procedure	S4B70.BANINST1.NOKEPAF	Use(insert )
P_UPDATE_EA_RECORDS	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
P_VOID_EPAF	Package procedure	S4B70.BANINST1.NOKEPAF	Use(update )
F_EA_EDIT_SUPERUSER	Package function	S4B70.BANINST1.NOKEPAF	Use(select )
F_EA_MAX_LEVEL_WITH_MANY_REC	Package function	S4B70.BANINST1.NOKEPAF	Use(select )
F_EA_QUEUE_STATUS	Package function	S4B70.BANINST1.NOKEPAF	Use(select )
F_EA_QUEUE_STAT_PENDING	Package function	S4B70.BANINST1.NOKEPAF	Use(select )
F_GET_EPAF	Package function	S4B70.BANINST1.BWNCXCHN	Rely on ()
F_GET_EPAF_DEFAULT	Package function	S4B70.BANINST1.BWPCXCHN	Rely on ()
F_GET_EPAF_QUEUE_STATUS	Package function	S4B70.BANINST1.BWNCBREF