38:
39: BEGIN
40: select GL_CONSOLIDATION_HISTORY_S.NEXTVAL
41: into next_val
42: from dual;
43:
44: END Get_New_Id;
45:
46:
195: X_Target_DB_Name VARCHAR2
196: ) IS
197: CURSOR C(Run_Id NUMBER) IS SELECT rowid FROM GL_CONSOLIDATION_HISTORY
198: WHERE consolidation_run_id = Run_Id;
199: CURSOR C2 IS SELECT gl_consolidation_history_s.nextval FROM sys.dual;
200: TempRowid VARCHAR2(60);
201: TempRunId NUMBER;
202: BEGIN
203: X_To_Period_Name := X_Standard_To_Period_Name;