index

Package gb_gtvotyp

Standard functions and procedures for Rule table to specify the legal combinations of system and option types

Program units
f_code_exists   Determines if the code exists in the table
f_get_description   Returns description for the code

Cursors
gtvotyp_c   Returns the record from the validation table.

gtvotyp_c 

CURSOR gtvotyp_c(
    p_syst_code  gtvotyp.gtvotyp_syst_code%TYPE,
    p_code  gtvotyp.gtvotyp_code%TYPE)
 RETURN gtvotyp%ROWTYPE;

Returns the record from the validation table.

f_code_exists 

FUNCTION f_code_exists(p_syst_code gtvotyp.gtvotyp_syst_code%TYPE,
                       p_code      gtvotyp.gtvotyp_code%TYPE)
  RETURN VARCHAR2

Determines if the code exists in the table

Parameters
p_syst_code   systems that are using the general tables (e.g. "Proxy", "event management").
p_code   Option type within the system.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_syst_code gtvotyp.gtvotyp_syst_code%TYPE,
                           p_code      gtvotyp.gtvotyp_code%TYPE)
  RETURN VARCHAR2

Returns description for the code

Parameters
p_syst_code   systems that are using the general tables (e.g. "Proxy", "event management").
p_code   Option type within the system.

Returns
Description