|
Package BANINST1.fb_ftvityp Common Business interface for income type (FB_FTVITYP). |
| Program units |
| f_code_exists | Checks to see if a record exists for a given income type. |
| f_get_description | Retrieves the income type description. |
| Cursors |
| ftvityp_c | Selects the income type record. |
ftvityp_c
CURSOR ftvityp_c( p_seq_code ftvityp.ftvityp_seq_code%TYPE) RETURN ftvityp%ROWTYPE;
Selects the income type record.
| Parameters |
| p_seq_code |
The income type sequence number. NUMBER(2) Required. |
| Returns |
|
income type record. |
f_code_exists
Function f_code_exists(p_seq_code ftvityp.ftvityp_seq_code%TYPE) RETURN VARCHAR2
Checks to see if a record exists for a given income type.
| Parameters |
| p_seq_code |
The income type sequence number. NUMBER(2) Required. |
| Returns |
|
Y if found, otherwise N. |
f_get_description
Function f_get_description(p_seq_code ftvityp.ftvityp_seq_code%TYPE) RETURN VARCHAR2
Retrieves the income type description.
| Parameters |
| p_seq_code |
The income type sequence number. NUMBER(2) Required. |
| Returns |
|
income type description if found, otherwise NULL. |