1274: v_other_detail VARCHAR2(350);
1275: CURSOR c_get_nxt_seq IS
1276: --SELECT IGS_PR_S_SCRATCH_PAD_S.nextval
1277: SELECT IGS_PR_RU_APPL_SEQ_NUM_S.nextval 1278: FROM DUAL; 1279: v_ssp_sequence_number IGS_PR_S_SCRATCH_PAD.sequence_number%TYPE;
1280: BEGIN
1281: -- this module inserts and entry into the
1282: -- system scratch pad table