19: new_year_flag VARCHAR2(1);
20: new_entered_year VARCHAR2(30);
21: BEGIN
22: -- do we already have this year in GL_DATE_PERIOD_MAP? 23: SELECT '1' INTO dummy FROM sys.dual 24: WHERE EXISTS
25: (SELECT 'Existing Year'
26: FROM gl_date_period_map
27: WHERE