index

Package gb_gtvsdax

Standard functions and procedures for SDA crosswalk/conversion table

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

Cursors
gtvsdax_c  

gtvsdax_c 

CURSOR gtvsdax_c(
    p_internal_code_group  gtvsdax.gtvsdax_internal_code_group%TYPE,
    p_internal_code  gtvsdax.gtvsdax_internal_code%TYPE,
    p_external_code  gtvsdax.gtvsdax_external_code%TYPE,
    p_internal_code_seqno  gtvsdax.gtvsdax_internal_code_seqno%TYPE)
 RETURN gtvsdax%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_internal_code_group gtvsdax.gtvsdax_internal_code_group%TYPE,
                       p_internal_code       gtvsdax.gtvsdax_internal_code%TYPE,
                       p_external_code       gtvsdax.gtvsdax_external_code%TYPE,
                       p_internal_code_seqno gtvsdax.gtvsdax_internal_code_seqno%TYPE)
  RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_internal_code_group   The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too.
p_internal_code   The pre-determined SDA retrieval code.
p_external_code   Banner/Concept code for to be retrieved.
p_internal_code_seqno   The sequence number for internal codes requiring multiple values.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_internal_code_group gtvsdax.gtvsdax_internal_code_group%TYPE,
                           p_internal_code       gtvsdax.gtvsdax_internal_code%TYPE,
                           p_external_code       gtvsdax.gtvsdax_external_code%TYPE,
                           p_internal_code_seqno gtvsdax.gtvsdax_internal_code_seqno%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_internal_code_group   The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too.
p_internal_code   The pre-determined SDA retrieval code.
p_external_code   Banner/Concept code for to be retrieved.
p_internal_code_seqno   The sequence number for internal codes requiring multiple values.

Returns
Description