log_FileHandle

log_FileHandle          UTL_FILE.FILE_TYPE;

lis_FileHandle

lis_FileHandle          UTL_FILE.FILE_TYPE;

upload_FileHandle

upload_FileHandle       UTL_FILE.FILE_TYPE;

gp_process_start_time

gp_process_start_time   DATE;

gp_system_code

gp_system_code          VARCHAR2(30);

gp_source_id

gp_source_id            VARCHAR2(1000);

gp_report_type

gp_report_type          VARCHAR2(1);

gp_match_update

gp_match_update         VARCHAR2(1);

gp_com_mtch_rule

gp_com_mtch_rule        VARCHAR2(30);

gp_one_up_number

gp_one_up_number        VARCHAR2(15);

gp_upload_file

gp_upload_file          VARCHAR2(30);

gp_upload_skip

gp_upload_skip          INTEGER;

gp_upload_process

gp_upload_process       INTEGER;

gp_upload_column

gp_upload_column        INTEGER;

gp_xref_code

gp_xref_code            VARCHAR2(3);

Advancement Parms

gp_donor_code

gp_donor_code           VARCHAR2(4);

gp_pref_clas

gp_pref_clas            VARCHAR2(4);

gp_coll_code_pref

gp_coll_code_pref       VARCHAR2(2);

gp_atyp_code_pref

gp_atyp_code_pref       VARCHAR2(2);

gp_atyp_code_geor

gp_atyp_code_geor       VARCHAR2(2);

gp_verbosity

gp_verbosity            NUMBER := 3;

How much detail do you want to see in the debug file.

gtvsdax_rec

gtvsdax_rec             gtvsdax%ROWTYPE;

0 will not create a debug file 1 will show a minimal amount of detail 2 will show more detail 3 will show the maximum amount of detail

gp_gtvsdax_value

gp_gtvsdax_value        gtvsdax.gtvsdax_external_code%TYPE;

proxy_rec

proxy_rec               geniden%ROWTYPE;

p_gen_proxyaccess_com_match

PROCEDURE p_gen_proxyaccess_com_match(p_one_up_number IN NUMBER)

f_Ins_Upd_Person

FUNCTION f_ins_upd_person(ps_gidm   IN NUMBER,
                          ps_pidm   IN NUMBER,
                          ps_system IN VARCHAR2 DEFAULT NULL)
  RETURN VARCHAR2

F_GetOption

FUNCTION f_getoption(p_otyp gtvotyp.gtvotyp_code%TYPE,
                     p_retp gtvretp.gtvretp_code%TYPE DEFAULT NULL,
                     p_syst gtvsyst.gtvsyst_code%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Return option value from relationship level if provided and found Honor start/end date on relationship level options Otherwise return global value

p_Logging

PROCEDURE p_logging(p_text      IN VARCHAR2,
                    p_verbosity IN NUMBER)

f_process_person

FUNCTION f_process_person(p_gidm IN genbpsh.genbpsh_gidm%TYPE,
                          p_syst IN genbpsh.genbpsh_syst_code%TYPE,
                          p_retp IN genbpsh.genbpsh_retp_code%TYPE,
                          p_dtyp IN genbpsh.genbpsh_dtyp_code%TYPE,
                          p_pidm IN geniden.geniden_pidm%TYPE)
  RETURN VARCHAR2

This is the function that will be executed when a load process associated with PERSON is called

f_process_proxy

FUNCTION f_process_proxy(p_gidm IN genbpsh.genbpsh_gidm%TYPE,
                         p_syst IN genbpsh.genbpsh_syst_code%TYPE,
                         p_retp IN genbpsh.genbpsh_retp_code%TYPE,
                         p_dtyp IN genbpsh.genbpsh_dtyp_code%TYPE,
                         p_pidm IN geniden.geniden_pidm%TYPE)
  RETURN VARCHAR2

This is the function that will be executed when a load process associated with PROXY is called

f_process_advancement

FUNCTION f_process_advancement(p_gidm IN genbpsh.genbpsh_gidm%TYPE,
                               p_syst IN genbpsh.genbpsh_syst_code%TYPE,
                               p_retp IN genbpsh.genbpsh_retp_code%TYPE,
                               p_dtyp IN genbpsh.genbpsh_dtyp_code%TYPE,
                               p_pidm IN geniden.geniden_pidm%TYPE)
  RETURN VARCHAR2

This is the function that will be executed when a load process associated with ADVANCEMENT is called