index

Package sb_stvgadr

This package provides the Common Business interface for the Graduation Application Display Rule Validation Table API (sb_stvgadr).


Program units
f_code_exists  
f_get_description  

Cursors
stvgadr_c  


stvgadr_c

CURSOR stvgadr_c(
    p_code  stvgadr.stvgadr_code%TYPE)
 RETURN stvgadr%ROWTYPE;

Returns the record from the validation table.


f_code_exists

Function f_code_exists(p_code stvgadr.stvgadr_code%TYPE) RETURN VARCHAR2

Determines if the code exists in the table

Parameters
p_code   Display rule code for the graduation application.

Returns
Y if found, otherwise N


f_get_description

Function f_get_description(p_code stvgadr.stvgadr_code%TYPE)
  RETURN VARCHAR2

Returns description for the code

Parameters
p_code   Display rule code for the graduation application.

Returns
Description