index

Package gb_stvmatl

Standard functions and procedures for Recruiting Material Code Validation Table

Program units
f_code_exists   Determine if the code exists in the table
f_get_description   Return description for the code

Cursors
stvmatl_c  

stvmatl_c 

CURSOR stvmatl_c(
   p_code  stvmatl.stvmatl_code%TYPE)
RETURN stvmatl%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code stvmatl.stvmatl_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   Recruiting material code referenced in the            Recruiting Module.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code stvmatl.stvmatl_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   Recruiting material code referenced in the            Recruiting Module.

Returns
Description