index

Package BANINST1.fb_ftvdisc

Common Business interface for discount (FB_FTVDISC).

Program units
f_code_exists   Determines if the code exists in the table.
f_code_exists_eff   Determines if the code exists in the table.
f_code_exists_eff_message   Determines if the code exists in the table and returns the appropriate message.
f_get_row   Determines if the code exists in the table and then returns the entire record.
f_get_description   Returns current description for the code

Cursors
ftvdisc_c   Returns the cursor for the entire record from the validation table.

ftvdisc_c 

CURSOR ftvdisc_c(
   p_code  ftvdisc.ftvdisc_code%TYPE,
   p_eff_date  ftvdisc.ftvdisc_eff_date%TYPE DEFAULT NULL)
RETURN ftvdisc%ROWTYPE;

Returns the cursor for the entire record from the validation table.

f_code_exists 

Function f_code_exists(p_code     ftvdisc.ftvdisc_code%TYPE,
                       p_eff_date ftvdisc.ftvdisc_eff_date%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Determines if the code exists in the table.
Returns Y if the code exists in the discount table, N if it does not.
If the date parameter is not valued, then the function just checks for existence.
If the date parameter is valued, the function returns a Y only if the discount code is valid and effective as of the date.

Parameters
p_disc_code   User specified code which defines the discount code. Required.
p_eff_date   The date for which this code has to be validated.

Returns
Y if found, N if not found.

f_code_exists_eff 

Function f_code_exists_eff(p_code     ftvdisc.ftvdisc_code%TYPE,
                           p_eff_date ftvdisc.ftvdisc_eff_date%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Determines if the code exists in the table.
If the date parameter is not valued, then the function checks for existence.
If the date parameter is valued, then the function validates if the code is valid as of that date or else it will return the appropriate error.

Parameters
p_disc_code   User specified code which defines the discount code. Required.
p_eff_date   The date for which this code has to be validated.

Returns
Y - If code is effective and valid. F - If code is effective in the future. T - If code has been terminated. I - If code has other miscellaneous issues. N - If not found.

f_code_exists_eff_message 

Function f_code_exists_eff_message(p_code     ftvdisc.ftvdisc_code%TYPE,
                                   p_eff_date ftvdisc.ftvdisc_eff_date%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Determines if the code exists in the table and returns the appropriate message.
If the date parameter is not valued, then the function checks for existence.
If the date parameter is valued, then the function validates if the code is valid as of that date or else it will return the appropriate error.

Parameters
p_disc_code   User specified code which defines the discount code. Required.
p_eff_date   The date for which this code has to be validated.

Returns
The appropriate error message is code is not valid or returns NULL value if code is valid and effective.

f_get_row 

Function f_get_row(p_code     ftvdisc.ftvdisc_code%TYPE,
                   p_eff_date ftvdisc.ftvdisc_eff_date%TYPE DEFAULT NULL)
  RETURN ftvdisc%ROWTYPE

Determines if the code exists in the table and then returns the entire record.

Parameters
p_disc_code   User specified code which defines the discount code.
p_eff_date   The effective date for this particular record.

Returns
Entire record from the validation table if code is found.

f_get_description 

Function f_get_description(p_code     ftvdisc.ftvdisc_code%TYPE,
                           p_eff_date ftvdisc.ftvdisc_eff_date%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Returns current description for the code

Parameters
p_disc_code   User specified code which defines the discount code.
p_eff_date   The effective date for this particular record.

Returns
The Description for the discount code. VARCHAR2