Package BANINST1.fb

Package BANINST1.fb_ftvvtyp

Common Business interface for vendor type (FB_FTVVTYP).

Program units

f_code_exists	Checks to see if a vendor type record exists.
f_get_description	Retrieves description for this vendor type code.

Constants

M_FTVVTYP_DESC

Vendor type description

Cursors

ftvvtyp_c

Selects the vendor type record.

M_FTVVTYP_DESC

M_FTVVTYP_DESC      CONSTANT VARCHAR2(12) := 'FTVVTYP_DESC';

Vendor type description

ftvvtyp_c

cursor ftvvtyp_c(
   p_code  ftvvtyp.ftvvtyp_code%TYPE,
   p_eff_date  ftvvtyp.ftvvtyp_eff_date%TYPE)
RETURN ftvvtyp%ROWTYPE;

Selects the vendor type record.

Parameters

	p_code	The vendor type code. VARCHAR2(2) Required.
	p_eff_date	The effective date of the vendor type code. Date Required.

Returns

vendor type record.

f_code_exists

Function f_code_exists(p_code     ftvvtyp.ftvvtyp_code%TYPE,
                       p_eff_date ftvvtyp.ftvvtyp_eff_date%TYPE)
  RETURN VARCHAR2

Checks to see if a vendor type record exists.

Parameters

	p_code	The vendor type code. VARCHAR2(2) Required.
	p_eff_date	The effective date of the vendor type code. Date Required.

Returns

Y if found one valid, A if found one invalid, C if found no one.

f_get_description

Function f_get_description(p_code     ftvvtyp.ftvvtyp_code%TYPE,
                           p_eff_date ftvvtyp.ftvvtyp_eff_date%TYPE default sysdate)
  RETURN VARCHAR2

Retrieves description for this vendor type code.

Parameters

	p_code	The vendor type code. VARCHAR2(2) Required.
	p_eff_date	The effective date of the vendor type code. Date.

Returns

vendor type description if found, otherwise NULL.