302: l_debug_loc := l_debug_loc || ' -> '|| 'is_date_type_valid';
303: RAISE invalid_date_type;
304: END IF;
305: --
306: -- Insert records into fun_seq_rules
307: --
308: l_debug_loc := l_debug_loc || '->' || 'insert into fun_seq_rules';
309: --
310: INSERT INTO fun_seq_rules (
304: END IF;
305: --
306: -- Insert records into fun_seq_rules
307: --
308: l_debug_loc := l_debug_loc || '->' || 'insert into fun_seq_rules';
309: --
310: INSERT INTO fun_seq_rules (
311: application_id,
312: table_name,
306: -- Insert records into fun_seq_rules
307: --
308: l_debug_loc := l_debug_loc || '->' || 'insert into fun_seq_rules';
309: --
310: INSERT INTO fun_seq_rules (
311: application_id,
312: table_name,
313: context_type,
314: event_code,
362: --
363: -- Delete Sequence Rules
364: --
365: DELETE
366: FROM fun_seq_rules sr
367: WHERE sr.application_id = p_application_id
368: AND sr.table_name = p_table_name;
369:
370: --
434: RAISE invalid_date_type;
435: END IF;
436:
437: DELETE
438: FROM fun_seq_rules sr
439: WHERE sr.application_id = p_application_id
440: AND sr.table_name = p_table_name
441: AND sr.context_type = p_context_type
442: AND sr.event_code = p_event_code