gobapid_rec

TYPE gobapid_rec IS RECORD(
  r_udcid          gobumap.gobumap_udc_id%TYPE,
  r_pidm           gobumap.gobumap_pidm%TYPE,
  r_sourced_id     gobsrid.gobsrid_sourced_id%TYPE,
  r_spriden_id     spriden.spriden_id%TYPE,
  r_oracle_user_id gobeacc.gobeacc_username%TYPE);

gobapid_ref

TYPE gobapid_ref IS REF CURSOR RETURN gobapid_rec;

f_get_apid_map

FUNCTION f_get_apid_map(p_udcid gobumap.gobumap_udc_id%TYPE)
  RETURN gobapid_ref

f_get_apid_list

FUNCTION f_get_apid_list RETURN gobapid_ref