Package sb_stvtrns

This package provides the Common Business interface for the Name Source Validation Table API (sb_stvtrns).
This package houses cursors and functions to retrieve validation table data from the transcript name source.

Program units

f_code_exists

f_get_description

Cursors

stvtrns_c

CURSOR stvtrns_c(
    p_code  stvtrns.stvtrns_code%TYPE)
 RETURN stvtrns%ROWTYPE;

Returns the record from the STVTRNS validation table.

f_code_exists

Function f_code_exists(
    p_code  stvtrns.stvtrns_code%TYPE) RETURN VARCHAR2

Determines if the code exists in the table.

Parameters

p_code

Source of the name that is to be printed on the transcript.

Returns

Y if found, otherwise N.

f_get_description

Function f_get_description(
    p_code  stvtrns.stvtrns_code%TYPE) RETURN VARCHAR2

Returns the description of the code.

Parameters

p_code

Source of the name from that is to be printed on the transcript.

Returns

Description