Package gb_gtvscod

Standard functions and procedures for Edi Standard Code Validation Table.
This table contains the standard EDI codes based on element id and standards organization. Data in this table is used to create cross references to various user defined codes that need to be sent in EDI transactions/messages.

Program units

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

Cursors

gtvscod_c

CURSOR gtvscod_c(
    p_element_id  gtvscod.gtvscod_element_id%TYPE,
    p_code  gtvscod.gtvscod_code%TYPE,
    p_standard_ind  gtvscod.gtvscod_standard_ind%TYPE)
 RETURN gtvscod%ROWTYPE;

f_code_exists

FUNCTION f_code_exists(p_element_id   gtvscod.gtvscod_element_id%TYPE,
                       p_code         gtvscod.gtvscod_code%TYPE,
                       p_standard_ind gtvscod.gtvscod_standard_ind%TYPE)
  RETURN VARCHAR2

Determine if the code exists in the table

Parameters

	p_element_id	The numeric identifier associated with the element as defined by the EDI Standards being used.
	p_code	The EDI Standard code value associated with the Standard being used.
	p_standard_ind	A one character code indicating which EDI Standards Organization the code comes from.

Returns

Y if found, otherwise N

f_get_description

FUNCTION f_get_description(p_element_id   gtvscod.gtvscod_element_id%TYPE,
                           p_code         gtvscod.gtvscod_code%TYPE,
                           p_standard_ind gtvscod.gtvscod_standard_ind%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters

	p_element_id	The numeric identifier associated with the element as defined by the EDI Standards being used.
	p_code	The EDI Standard code value associated with the Standard being used.
	p_standard_ind	A one character code indicating which EDI Standards Organization the code comes from.

Returns

Description