DBA Data[Home] [Help]

APPS.FUN_SEQ_BATCH dependencies on FUN_SEQ_VERSIONS

Line 374: l_current_value fun_seq_versions.current_value%TYPE;

370:
371: l_seq_ver_id_tbl seq_ver_id_tbl_type;
372: l_assign_id_tbl assign_id_tbl_type;
373:
374: l_current_value fun_seq_versions.current_value%TYPE;
375: l_sequenced_date DATE;
376: l_error_code VARCHAR2(30);
377:
378: l_module CONSTANT VARCHAR2(100) DEFAULT

Line 447: UPDATE fun_seq_versions

443: THEN
444: --
445: -- Update the current_value
446: --
447: UPDATE fun_seq_versions
448: SET current_value = l_current_value
449: WHERE seq_version_id = l_seq_ver_id_tbl(i);
450: END IF; -- Update the Last Used Number or Not
451: END IF; -- Call Generate Sequence Number or Not