Package gb_gtvcelg

Standard functions and procedures for Certification of Eligibility Table

Program units

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

Cursors

CURSOR gtvcelg_c(
    p_code  gtvcelg.gtvcelg_code%TYPE)
 RETURN gtvcelg%ROWTYPE;

f_code_exists

FUNCTION f_code_exists(p_code gtvcelg.gtvcelg_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters

p_code

This field indicates Certification of Eligibility Validation code.

Returns

Y if found, otherwise N

f_get_description

FUNCTION f_get_description(p_code gtvcelg.gtvcelg_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters

p_code

This field indicates Certification of Eligibility Validation code.

Returns

Description