117: AND category_id = LocalCatRecord.category_id;
118: LocalExistsRecord c_get_exists%ROWTYPE;
119:
120: CURSOR c_get_seq_num IS
121: SELECT edr_files_b_s.nextval
122: FROM dual;
123: LocalSeqRecord c_get_seq_num%ROWTYPE;
124:
125: CURSOR c_get_event IS
328: --Set up the display name for the attachment
329: l_file_name := l_file_name ||'_v_'||p_version_label||l_extension;
330:
331: --Get the next sequence number for file_id
332: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;
333:
334: --Call private package to insert data into the tables
335: --the whole idea is that instead of inserting one row in edr_files_b/tl tables
336: -- we would have to insert a row in: