index

Package gb_gtvdadd

Standard functions and procedures for Add-In code Validation Table


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

Cursors
gtvdadd_c  


gtvdadd_c

CURSOR gtvdadd_c(
    p_code  gtvdadd.gtvdadd_code%TYPE)
 RETURN gtvdadd%ROWTYPE;

f_code_exists

FUNCTION f_code_exists(p_code gtvdadd.gtvdadd_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   The unique Add-In Code for the Visual Basic Add-Ins.

Returns
Y if found, otherwise N


f_get_description

FUNCTION f_get_description(p_code gtvdadd.gtvdadd_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   The unique Add-In Code for the Visual Basic Add-Ins.

Returns
Description