worker_type_o.tps by Don Bales on 12/15/2006 Type WORKER_TYPE_O's attributes and methods.
Attributes
worker_type_o.tps by Don Bales on 12/15/2006 Type WORKER_TYPE_O's attributes and methods.
id number, code varchar2(30), description varchar2(80), active_date date, inactive_date date,
Method Summary get_code_descr Gets the code and decription values for the specified work_type_id get_code_id_descr date specified get_code_id_descr Verifies the passed aiov_code value is currently an exact or like match get_id Returns a newly allocated id value 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 worker_type_o with NULL values worker_type_o for insert
Method Detail
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 work_type_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 ),
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 the passed aiov_code value is currently an exact or like match.
get_id
MEMBER FUNCTION get_id return number,
Returns a newly allocated id value.
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.
worker_type_o
CONSTRUCTOR FUNCTION worker_type_o( self in out worker_type_o) return self as result,
with NULL values.
worker_type_o
CONSTRUCTOR FUNCTION worker_type_o( self in out worker_type_o, aiv_code in varchar2, aiv_description in varchar2) return self as result )