WORKER_TS



Package WORKER_TS

worker_ts.pks
Copyright by Don Bales on 12/15/2006
Table WORKER_T's methods.



Global Constants and Variables



Keep track of the number of inserts and updates

n_inserted number := 0;
n_updated number := 0;



Method Summary
get_age
Calculate age based on the specified birth data and day
get_age
Calcualte age based on the specified birth date and today
get_age
Returns the age of the specified worker on the specified day
get_age
Returns the age of the specified worker as of today
get_birth_date
Returns the specified worker's birth date
get_external_id
Returns the next available external ID value from its sequence
get_id
Returns the next available primar key ID value from its sequence
get_id
Returns the primary key ID value for the specified external ID value
get_formatted_name
Returns a name properly formatted for the current locale
get_formatted_name
Returns a name for the specified worker properly formatted for the current locale
get_row
Returns a matching worker row
get_unformatted_name
Returns an unformmated name
is_duplicate
gender already exists in the database
help
Text-based help for this package
set_row
Insert or update the specified row into the database
test
This package's test units



Method Detail

get_age

FUNCTION get_age(
aid_birth_date in WORKER_T.birth_date%TYPE,
aid_on in date)
return number


Calculate age based on the specified birth data and day


get_age

FUNCTION get_age(
aid_birth_date in WORKER_T.birth_date%TYPE)
return number


Calcualte age based on the specified birth date and today


get_age

FUNCTION get_age(
ain_id in WORKER_T.id%TYPE,
aid_on in date)
return number


Returns the age of the specified worker on the specified day


get_age

FUNCTION get_age(
ain_id in WORKER_T.id%TYPE)
return number


Returns the age of the specified worker as of today


get_birth_date

FUNCTION get_birth_date(
ain_id in WORKER_T.id%TYPE)
return WORKER_T.birth_date%TYPE


Returns the specified worker's birth date


get_external_id

FUNCTION get_external_id
return WORKER_T.external_id%TYPE


Returns the next available external ID value from its sequence


get_id

FUNCTION get_id
return WORKER_T.id%TYPE


Returns the next available primar key ID value from its sequence


get_id

FUNCTION get_id(
aiv_external_id in WORKER_T.external_id%TYPE)
return WORKER_T.id%TYPE


Returns the primary key ID value for the specified external ID value


get_formatted_name

FUNCTION get_formatted_name(
aiv_first_name in WORKER_T.first_name%TYPE,
aiv_middle_name in WORKER_T.middle_name%TYPE,
aiv_last_name in WORKER_T.last_name%TYPE)
return WORKER_T.name%TYPE


Returns a name properly formatted for the current locale


get_formatted_name

FUNCTION get_formatted_name(
ain_id in WORKER_T.id%TYPE)
return WORKER_T.name%TYPE


Returns a name for the specified worker properly formatted for the current locale


get_row

FUNCTION get_row(
air_worker in WORKER_T%ROWTYPE)
return WORKER_T%ROWTYPE


Returns a matching worker row


get_unformatted_name

FUNCTION get_unformatted_name(
aiv_first_name in WORKER_T.first_name%TYPE,
aiv_middle_name in WORKER_T.middle_name%TYPE,
aiv_last_name in WORKER_T.last_name%TYPE)
return WORKER_T.name%TYPE


Returns an unformmated name


is_duplicate

FUNCTION is_duplicate(
aiv_name in WORKER_T.name%TYPE,
aid_birth_date in WORKER_T.birth_date%TYPE,
ain_gender_id in WORKER_T.gender_id%TYPE)
return boolean


gender already exists in the database


help

PROCEDURE help


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


set_row

PROCEDURE set_row(
aior_worker in out WORKER_T%ROWTYPE)


Insert or update the specified row into the database


test

PROCEDURE test


This package's test units