index

Package gb_gtvproc

Standard functions and procedures for Process Name Validation Table

Program units
f_code_exists   Determine if the code exists in the table
f_get_description   Return description for the code

Cursors
gtvproc_c  

gtvproc_c 

CURSOR gtvproc_c(
    p_code  gtvproc.gtvproc_code%TYPE)
 RETURN gtvproc%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code gtvproc.gtvproc_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   Process Name Code used by SCT Banner Processes, for example WEBCCADMFEES identifying the process that accepts payment of Admissions fees via credit card.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code gtvproc.gtvproc_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   Process Name Code used by SCT Banner Processes, for example WEBCCADMFEES identifying the process that accepts payment of Admissions fees via credit card.

Returns
Description