131: ,YEAR_FLAG
132: )
133: SELECT
134: l_min_date
135: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(l_min_date,204)
136: ,'N'
137: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(l_min_date,204)
138: ,'N'
139: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(l_min_date,204)
133: SELECT
134: l_min_date
135: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(l_min_date,204)
136: ,'N'
137: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(l_min_date,204)
138: ,'N'
139: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(l_min_date,204)
140: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_min_date,204)
141: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_min_date,204)
135: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(l_min_date,204)
136: ,'N'
137: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(l_min_date,204)
138: ,'N'
139: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(l_min_date,204)
140: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_min_date,204)
141: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_min_date,204)
142: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_NUM(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
136: ,'N'
137: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(l_min_date,204)
138: ,'N'
139: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(l_min_date,204)
140: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_min_date,204)
141: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_min_date,204)
142: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_NUM(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
137: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(l_min_date,204)
138: ,'N'
139: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(l_min_date,204)
140: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_min_date,204)
141: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_min_date,204)
142: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_NUM(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
138: ,'N'
139: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(l_min_date,204)
140: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_min_date,204)
141: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_min_date,204)
142: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_NUM(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
139: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(l_min_date,204)
140: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_min_date,204)
141: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_min_date,204)
142: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_NUM(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
140: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_min_date,204)
141: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_min_date,204)
142: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_NUM(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
141: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_min_date,204)
142: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_NUM(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
142: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_NUM(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
143: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
144: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
145: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR_NUM(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
153: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_min_date,204)
146: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
153: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_min_date,204)
154: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_min_date,204)
147: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
153: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_min_date,204)
154: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_min_date,204)
155: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_min_date,204)
148: ,BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
153: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_min_date,204)
154: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_min_date,204)
155: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_min_date,204)
156: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_min_date,204)
149: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_min_date,204)
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
153: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_min_date,204)
154: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_min_date,204)
155: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_min_date,204)
156: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_min_date,204)
157: ,'N'
150: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_min_date,204)
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
153: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_min_date,204)
154: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_min_date,204)
155: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_min_date,204)
156: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_min_date,204)
157: ,'N'
158: FROM DUAL;
151: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_min_date,204)
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
153: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_min_date,204)
154: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_min_date,204)
155: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_min_date,204)
156: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_min_date,204)
157: ,'N'
158: FROM DUAL;
159: l_min_date := l_min_date +1;
152: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_min_date,204)
153: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_min_date,204)
154: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_min_date,204)
155: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_min_date,204)
156: ,BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_min_date,204)
157: ,'N'
158: FROM DUAL;
159: l_min_date := l_min_date +1;
160: EXCEPTION