index

Package gb_gtvcurr

Standard functions and procedures for Currency conversion validation table.

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

Cursors
gtvcurr_c  

gtvcurr_c 

CURSOR gtvcurr_c(
    p_curr_code  gtvcurr.gtvcurr_curr_code%TYPE,
    p_rate_eff_date  gtvcurr.gtvcurr_rate_eff_date%TYPE)

 RETURN gtvcurr%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_curr_code     gtvcurr.gtvcurr_curr_code%TYPE,
                       p_rate_eff_date gtvcurr.gtvcurr_rate_eff_date%TYPE)
  RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_curr_code   A code which uniquely identifies a type of currency.
p_rate_eff_date   The effective date of this particular record.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_curr_code     gtvcurr.gtvcurr_curr_code%TYPE,
                           p_rate_eff_date gtvcurr.gtvcurr_rate_eff_date%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_curr_code   A code which uniquely identifies a type of currency.
p_rate_eff_date   The effective date of this particular record.

Returns
Description