|
Package sb_stvtprt This package provides the Common Business interface for the Transcript Verification Request Type Table API (sb_stvtprt).This package houses cursors and functions to retrieve validation table data from the transcript verification request type. |
| Program units |
| f_code_exists |
| f_get_description |
| Cursors |
| stvtprt_c |
stvtprt_c
CURSOR stvtprt_c(
p_code stvtprt.stvtprt_code%TYPE)
RETURN stvtprt%ROWTYPE;
Returns the record from the STVTPRT validation table.
f_code_exists
Function f_code_exists(
p_code stvtprt.stvtprt_code%TYPE) RETURN VARCHAR2
Determines if the code exists in the table.
| Parameters |
| p_code |
Transcript verification request type code. |
| Returns |
|
Y if found, otherwise N |
f_get_description
Function f_get_description(
p_code stvtprt.stvtprt_code%TYPE) RETURN VARCHAR2
Returns the description of the code.
| Parameters |
| p_code |
Transcript verification request type code. |
| Returns |
|
Description of the code. |