362: h1_divider varchar2(100) := '****************************************';
363: h2_divider varchar2(100) := '===================';
364: h3_divider varchar2(100) := '-------------------';
365:
366: p_territory_id as_territories.territory_id%type ;
367: p_territory_type_id as_territories.territory_type_id%type ;
368:
369: -- cursor of result territory searches with resource and qualifier restrictions
370: CURSOR cur_terr is
363: h2_divider varchar2(100) := '===================';
364: h3_divider varchar2(100) := '-------------------';
365:
366: p_territory_id as_territories.territory_id%type ;
367: p_territory_type_id as_territories.territory_type_id%type ;
368:
369: -- cursor of result territory searches with resource and qualifier restrictions
370: CURSOR cur_terr is
371: select terr_id, wf_notification.substitutespecialchars(name) name, rank from jtf_terr_all