DBA Data[Home] [Help]

APPS.GMA_STANDARD dependencies on EDR_FILES_B_S

Line 175: SELECT edr_files_b_s.nextval

171: AND category_id = LocalCatRecord.category_id;
172: LocalExistsRecord c_get_exists%ROWTYPE;
173:
174: CURSOR c_get_seq_num IS
175: SELECT edr_files_b_s.nextval
176: FROM dual;
177: LocalSeqRecord c_get_seq_num%ROWTYPE;
178:
179: CURSOR c_get_event IS

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

390: l_file_name := l_file_name ||'_v_'||p_version_label||l_extension;
391:
392: /* Get the next sequence number for file_id */
393: /* Fixed SKARIMIS */
394: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;
395:
396: /* Call private package to insert data into the tables */
397: --cj the whole idea is that instead of inserting one row in edr_files_b/tl tables
398: -- we would have to insert a row in: