ACS3 Data Model

     1: function ad_partner_get_cookie (v_group_id integer)
     2: return varchar
     3: IS
     4:   v_partner_cookie  ad_partner.partner_cookie%TYPE;
     5: BEGIN
     6:   select partner_cookie into v_partner_cookie
     7:     from ad_partner_group_map, ad_partner
     8:    where ad_partner_group_map.partner_id = ad_partner.partner_id
     9:      and ad_partner_group_map.group_id = v_group_id;
    10: 
    11:   return v_partner_cookie;
    12: 
    13: END;