[Home] [Help]
29: FROM cs_qm_user_folders
30: WHERE folder_name = l_folder_name
31: AND user_id = l_user_id;
32:
33: SELECT CS_QM_USER_FOLDERS_S.NextVal
34: INTO next_sequence
35: FROM dual;
36:
37: IF (record_exist > 0) THEN
168: next_sequence NUMBER;
169:
170: BEGIN
171:
172: SELECT CS_QM_USER_FOLDERS_s.NextVal
173: INTO next_sequence
174: FROM dual;
175:
176: INSERT INTO cs_qm_user_folders