index

Package GOKADVC

FILE NAME..: gokadvc0.sql RELEASE....: 8.5 OBJECT NAME: gokadvc PRODUCT....: GENERAL USAGE......: Use this package to load proxies into Advancement.
COPYRIGHT..: Copyright 2011 SunGard. All rights reserved.
 
DESCRIPTION:
 
This package loads proxies from the Proxy Access module into the Advancement tables.
 
DESCRIPTION END

Program units
f_Ins_Advancement   aprcatg.aprcatg_donr_code%TYPE,

f_Ins_Advancement 

FUNCTION f_ins_advancement(pf_person_pidm    IN spriden.spriden_pidm%TYPE,
                           pf_proxy_pidm     IN spriden.spriden_pidm%TYPE,
                           pf_first_name     IN spriden.spriden_first_name%TYPE,
                           pf_mi             IN spriden.spriden_mi%TYPE,
                           pf_last_name      IN spriden.spriden_last_name%TYPE,
                           pf_prefix         IN spbpers.spbpers_name_prefix%TYPE,
                           pf_donor_code     IN VARCHAR2, -- aprcatg.aprcatg_donr_code%TYPE,
                           pf_pref_clas      IN VARCHAR2, -- apbcons.apbcons_pref_clas%TYPE
                           pf_coll_code_pref IN VARCHAR2, -- apbcons.apbcons_coll_code_pref%TYPE
                           pf_atyp_code_pref IN VARCHAR2, -- apbcons.apbcons_atyp_code_pref%TYPE
                           pf_atyp_code_geor IN VARCHAR2, -- apbcons.apbcons_atyp_code_geor%TYPE
                           pf_relationship   IN VARCHAR2, -- aprxref.aprxref_xref_code%TYPE,
                           pf_data_origin    IN spriden.spriden_data_origin%TYPE)
  RETURN VARCHAR2

aprcatg.aprcatg_donr_code%TYPE,