index

Package BANINST1.fb_ftvbuyr

Common Business interface for buyer information (FB_FTVBUYR).

Program units
f_code_exists   Checks to see if a buyer record exists.
f_get_description   Retrieves the buyer name.
f_get_code   Retrieves the buyer code.

Cursors
ftvbuyr_c   Selects the buyer record.

ftvbuyr_c 

CURSOR ftvbuyr_c(
   p_code      ftvbuyr.ftvbuyr_code%TYPE,
   p_eff_date  ftvbuyr.ftvbuyr_eff_date%TYPE)
RETURN ftvbuyr%ROWTYPE;

Selects the buyer record.

Parameters
p_code   The buyer code. VARCHAR2(4) Required.
p_eff_date   The effective date of the buyer code. Date  Required.

Returns
buyer record.

f_code_exists 

Function f_code_exists(p_code     ftvbuyr.ftvbuyr_code%TYPE,
                       p_eff_date ftvbuyr.ftvbuyr_eff_date%TYPE DEFAULT SYSDATE)
  RETURN VARCHAR2

Checks to see if a buyer record exists.

Parameters
p_code   The buyer code. VARCHAR2(4) Required.
p_eff_date   The effective date of the buyer code. Date.

Returns
Y if found, otherwise N.

f_get_description 

Function f_get_description(p_code     ftvbuyr.ftvbuyr_code%TYPE,
                           p_eff_date ftvbuyr.ftvbuyr_eff_date%TYPE DEFAULT SYSDATE)
  RETURN VARCHAR2

Retrieves the buyer name.

Parameters
p_code   The buyer code. VARCHAR2(4) Required.
p_eff_date   The effective date of the buyer code. Date.

Returns
buyer name if found, otherwise NULL.

f_get_code 

Function f_get_code(p_name     ftvbuyr.ftvbuyr_name%TYPE,
                    p_eff_date ftvbuyr.ftvbuyr_eff_date%TYPE DEFAULT SYSDATE)
  RETURN VARCHAR2

Retrieves the buyer code.

Parameters
p_name   The buyer name. VARCHAR2(35) Required.
p_eff_date   The effective date of the buyer code. Date.

Returns
buyer code if found, otherwise NULL.