Package gb_gpbprxy

Standard functions and procedures for Proxy base table

Program units

f_code_exists	Determines if the code exists in the table
f_get_description	Returns description for the code

Cursors

gpbprxy_c

Returns the record from the validation table.

gpbprxy_c

CURSOR gpbprxy_c(
    p_proxy_idm  gpbprxy.gpbprxy_proxy_idm%TYPE)
 RETURN gpbprxy%ROWTYPE;

Returns the record from the validation table.

f_code_exists

FUNCTION f_code_exists(p_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE)
  RETURN VARCHAR2

Determines if the code exists in the table

Parameters

p_proxy_idm

The proxy ID master is a negative sequential number unique to a proxy created when a person adds a new proxy with a unique email address (doesn"t already exist in GPBPRXY). A negative sequence is used so that it is impossible to conflict with an existing PIDM or AIDM. See WEB4PROXY_SEQ. If a subsequent person cross-references an existing proxy email address then the existing PROXY_IDM is reused.

Returns

Y if found, otherwise N

f_get_description

FUNCTION f_get_description(p_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE)
  RETURN VARCHAR2

Returns description for the code

Parameters

p_proxy_idm

Returns

Description