index

Package gb_gtvletr

Standard functions and procedures for Letter Process Letter Validation Table

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

Cursors
gtvletr_c  

gtvletr_c 

CURSOR gtvletr_c(
    p_code  gtvletr.gtvletr_code%TYPE)
 RETURN gtvletr%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code gtvletr.gtvletr_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   Letter code referenced in Recruiting Material and Letter Processing.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code gtvletr.gtvletr_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   Letter code referenced in Recruiting Material and Letter Processing.

Returns
Description