2096:
2097: begin
2098:
2099: if p_record.threshold_dtl_id is null then
2100: select jai_rgm_thresholds_s.nextval
2101: into p_threshold_dtl_id
2102: from dual;
2103: end if;
2104: /** Threshold detail record does not exists */
2162: is
2163: begin
2164:
2165: if p_record.threshold_id is null then
2166: select jai_rgm_thresholds_s.nextval
2167: into p_threshold_id
2168: from dual;
2169: end if;
2170: