index

Package BANINST1.fb_ftvuoms

Common Business interface for unit of measure (FB_FTVUOMS).

Program units
f_code_exists   Determines if the code exists in the table
f_get_description   Returns description for the code

Cursors
ftvuoms_c   Returns the record from the validation table.

ftvuoms_c 

CURSOR ftvuoms_c(
    p_code        ftvuoms.ftvuoms_code%TYPE)
 RETURN ftvuoms%ROWTYPE;

Returns the record from the validation table.

f_code_exists 

Function f_code_exists(p_code     ftvuoms.ftvuoms_code%TYPE,
                       p_eff_date ftvuoms.ftvuoms_eff_date%TYPE,
                       p_rowid    VARCHAR2 DEFAULT NULL) RETURN VARCHAR2

Determines if the code exists in the table

Parameters
p_code   User specified code which designates the unit of measure, i.e. 'EA' for Each.

Returns
Y,T or I if found and valid for eff/term date, terminated or not validfor eff date respectively, otherwise N

f_get_description 

Function f_get_description(p_code     ftvuoms.ftvuoms_code%TYPE,
                           p_eff_date ftvuoms.ftvuoms_eff_date%TYPE)
  RETURN VARCHAR2

Returns description for the code

Parameters
p_code   User specified code which designates the unit of measure, i.e. 'EA' for Each.

Returns
Description