[Home] [Help]
668: --insert into tmp values('enter',p_geo_terr_name); commit;
669: -- n: geo_terr_value_id
670: if trim(p_geo_terr_value_id) is null then
671: -- new geo_terr_value_id
672: select jtf_tty_geo_terr_values_s.nextval into n from dual;
673: else n:=trim(p_geo_terr_value_id);
674: end if;
675:
676: