301: )
302: IS
303: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
304: SELECT instr(p_rec_item, '%', 1, 1)
305: FROM dual;
306: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
307: SELECT instr(p_rec_item, '_', 1, 1)
308: FROM dual;
309:
304: SELECT instr(p_rec_item, '%', 1, 1)
305: FROM dual;
306: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
307: SELECT instr(p_rec_item, '_', 1, 1)
308: FROM dual;
309:
310: str_csr1 NUMBER;
311: str_csr2 NUMBER;
312: i NUMBER;
2626: IF (fnd_profile.value('CSI_AUTO_GEN_SYS_NAME') = 'Y')
2627: THEN
2628: SELECT csi_systems_s.NEXTVAL
2629: INTO x_system_id
2630: FROM sys.dual;
2631: l_name := to_char(x_system_id);
2632: END IF;
2633: ELSE
2634: l_name := p_system_rec.name;