GENDER_O



Type GENDER_O

gender_o.tps
by Don Bales on 12/15/2006
Type GENDER's attributes and methods.



Attributes



gender_o.tps
by Don Bales on 12/15/2006
Type GENDER's attributes and methods.

id number,
code varchar2(30),
description varchar2(80),
active_date date,
inactive_date date,



Method Summary
gender_o
A constructor for creating a new instance of type GENDER_O with NULL
gender_o
A constructor for creating a new instance of type GENDER_O for insert
get_code_descr
Gets the code and decription values for the specified id
get_code_id_descr
Verifies that the passed code value is an exact or like match on the
get_code_id_descr
Verifies that the passed code value is currently an exact or like match
get_id
Returns a new primary key id value for a row
get_id
Returns the id for the specified code value
help,
Test-based help for this package
test,
Test units for this package
to_varchar2
A MAP function for sorting at the object level



Method Detail

gender_o

CONSTRUCTOR FUNCTION gender_o(
self in out gender_o)
return self as result,


A constructor for creating a new instance of type GENDER_O with NULL
values.


gender_o

CONSTRUCTOR FUNCTION gender_o(
self in out gender_o,
aiv_code varchar2,
aiv_description varchar2)
return self as result,


A constructor for creating a new instance of type GENDER_O for insert.


get_code_descr

STATIC PROCEDURE get_code_descr(
ain_id in number,
aov_code out varchar2,
aov_description out varchar2),


Gets the code and decription values for the specified id.


get_code_id_descr

STATIC PROCEDURE get_code_id_descr(
aiov_code in out varchar2,
aon_id out number,
aov_description out varchar2,
aid_on in date),


Verifies that the passed code value is an exact or like match on the
date specified.


get_code_id_descr

STATIC PROCEDURE get_code_id_descr(
aiov_code in out varchar2,
aon_id out number,
aov_description out varchar2),


Verifies that the passed code value is currently an exact or like match.


get_id

MEMBER FUNCTION get_id
return number,


Returns a new primary key id value for a row.


get_id

STATIC FUNCTION get_id(
aiv_code in varchar2)
return number,


Returns the id for the specified code value.


help,

STATIC PROCEDURE help,


Test-based help for this package. "set serveroutput on" in SQL*Plus.


test,

STATIC PROCEDURE test,


Test units for this package.


to_varchar2

MAP MEMBER FUNCTION to_varchar2
return varchar2
)


A MAP function for sorting at the object level.