8: BEGIN
9:
10: --
11: -- Update AOL dictionary tables for renamed sequences
12: -- FND_SEQUENCES
13: --
14: IF (length(p_new_seqname) > 30 OR
15: length(p_old_seqname) > 30) THEN
16: raise_application_error(-20001,
17: 'Invalid sequence names : '||p_old_seqname||
18: '->'||p_new_seqname);
19: END IF;
20:
21: update fnd_sequences
22: set sequence_name = p_new_seqname
23: where sequence_name = p_old_seqname
24: and application_id = p_appl_id;
25: