159:
160: /* Cursors */
161: CURSOR c_get_category IS
162: SELECT category_id
163: FROM fnd_document_categories
164: WHERE name = p_category;
165: LocalCatRecord c_get_category%ROWTYPE;
166:
167: CURSOR c_get_exists IS
177: LocalSeqRecord c_get_seq_num%ROWTYPE;
178:
179: CURSOR c_get_event IS
180: SELECT a.file_name, b.name
181: FROM edr_files_b a, fnd_document_categories b
182: WHERE a.category_id = b.category_id
183: AND a.file_id = l_file_id;
184: LocalEventRecord c_get_event%ROWTYPE;
185: