DBA Data[Home] [Help]

APPS.EDR_FILES_PUB dependencies on EDR_FILES_B_S

Line 121: SELECT edr_files_b_s.nextval

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

Line 332: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;

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: