480: FUNCTION get_splacement_id RETURN NUMBER
481: IS
482: -------------------------------------------------------------------
483: -- rvangala 28-OCT-2003 Created
484: -- Gets splacement_id from igs_en_splacements_s sequence
485:
486:
487: ---------------------------------------------------------------------
488: Cursor cur_s1 IS Select IGS_EN_Splacements_S.nextVal from dual;
484: -- Gets splacement_id from igs_en_splacements_s sequence
485:
486:
487: ---------------------------------------------------------------------
488: Cursor cur_s1 IS Select IGS_EN_Splacements_S.nextVal from dual;
489: l_splacement_id NUMBER(15);
490: BEGIN
491: OPEN cur_s1;
492: FETCH cur_s1 INTO l_splacement_id;