index

Package gb_gtvcmsc

Standard functions and procedures for Common Matching Source Code Table

Program units
f_code_exists   Determine if the code exists in the table
f_get_description   Return description for the code
f_get_long_desc   Return long description for the code
f_is_code_deleteable   Return Y if source code can be deleted from table, otherwise return N
f_code_exists_in_table   Return name of table in which the source code exists

Cursors
gtvcmsc_c  

gtvcmsc_c 

CURSOR gtvcmsc_c(
    p_code  gtvcmsc.gtvcmsc_code%TYPE)
 RETURN gtvcmsc%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code gtvcmsc.gtvcmsc_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   Code to identify the source of data to by used by Common Matching process.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code gtvcmsc.gtvcmsc_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   Code to identify the source of data to by used by Common Matching process.

Returns
Description

f_get_long_desc 

FUNCTION f_get_long_desc(p_code gtvcmsc.gtvcmsc_code%TYPE) RETURN VARCHAR2

Return long description for the code

Parameters
p_code   Code to identify the source of data to by used by Common Matching process.

Returns
Description

f_is_code_deleteable 

FUNCTION f_is_code_deleteable(p_code gtvcmsc.gtvcmsc_code%TYPE)
  RETURN VARCHAR2

Return Y if source code can be deleted from table, otherwise return N

Parameters
p_code   Source code to be edited for delete.

Returns
Y or N

f_code_exists_in_table 

FUNCTION f_code_exists_in_table(p_code gtvcmsc.gtvcmsc_code%TYPE)
  RETURN VARCHAR2

Return name of table in which the source code exists

Parameters
p_code   Source code to be checked

Returns
table name