WORKPLACE_TYPE_TS



Package WORKPLACE_TYPE_TS

workplace_type_ts.pks
by Don Bales on 12/15/2006
Table WORKPLACE_TYPE_T's methods.



Method Summary
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 date specified
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



Method Detail

get_code_descr

PROCEDURE get_code_descr(
ain_id in WORKPLACE_TYPE_T.id%TYPE,
aov_code out WORKPLACE_TYPE_T.code%TYPE,
aov_description out WORKPLACE_TYPE_T.description%TYPE)


Gets the code and decription values for the specified id.


get_code_id_descr

PROCEDURE get_code_id_descr(
aiov_code in out WORKPLACE_TYPE_T.code%TYPE,
aon_id out WORKPLACE_TYPE_T.id%TYPE,
aov_description out WORKPLACE_TYPE_T.description%TYPE,
aid_on in WORKPLACE_TYPE_T.active_date%TYPE)


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


get_code_id_descr

PROCEDURE get_code_id_descr(
aiov_code in out WORKPLACE_TYPE_T.code%TYPE,
aon_id out WORKPLACE_TYPE_T.id%TYPE,
aov_description out WORKPLACE_TYPE_T.description%TYPE)


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


get_id

FUNCTION get_id
return WORKPLACE_TYPE_T.id%TYPE


Returns a new primary key id value for a row.


get_id

FUNCTION get_id(
aiv_code in WORKPLACE_TYPE_T.code%TYPE)
return WORKPLACE_TYPE_T.id%TYPE


Returns the id for the specified code value.


help

PROCEDURE help


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


test

PROCEDURE test


Test units for this package.