[Home] [Help]
85: -----------------------------------------------------------------------
86: -- PRIVATE PROCEDURE INSERT_ROW
87: -- Given the report_date, time_id, period_type_id and record_type_id
88: -- passed in as parameter, this procedure will insert a row with
89: -- these values into FII_TIME_STRUCTURES
90: -----------------------------------------------------------------------
91: PROCEDURE INSERT_ROW(p_report_date DATE,
92: p_time_id NUMBER,
93: p_period_type_id NUMBER,
94: p_record_type_id NUMBER,
95: p_xtd_flag VARCHAR2 ) IS
96: BEGIN
97:
98: INSERT INTO FII_TIME_STRUCTURES
99: ( report_date,
100: time_id,
101: period_type_id,
102: record_type_id,
280: NULL;
281: END IF;
282: end if;
283:
284: truncate_table('FII_TIME_STRUCTURES');
285:
286: -- Find out the max report_date defined in the calendar
287: OPEN calendar_max_day;
288: FETCH calendar_max_day INTO l_max_day;
1187:
1188: END IF;
1189:
1190: ----------------------------------------------------------------------
1191: -- Inserting rows into FII_TIME_STRUCTURES for Rolling and XTD calendar
1192: ----------------------------------------------------------------------
1193: IF l_ent_year_id IS NOT NULL THEN
1194: insert_row(l_current_day, l_ent_year_id, l_nested_ent_year,
1195: l_year_sum, INCLUDES_XTD(l_year_sum,l_rolling_week));
1282:
1283: END IF;
1284:
1285: ----------------------------------------------------------------------
1286: -- Inserting rows into FII_TIME_STRUCTURES for Current periods
1287: ----------------------------------------------------------------------
1288: IF l_ent_year_id IS NOT NULL THEN
1289: insert_row(d.report_date, l_ent_year_id, l_nested_ent_year, l_year_sum, 'Y');
1290: l_row_cnt := l_row_cnt+1;
1338: fii_util.put_line(TO_CHAR(l_row_cnt)||' records has been populated to the Reporting Structure table for XTD and Rolling Periods');
1339: END IF;
1340:
1341: fnd_stats.gather_table_stats(ownname => g_schema
1342: , tabname => 'FII_TIME_STRUCTURES'
1343: );
1344:
1345: if g_debug_flag = 'Y' then
1346: fii_util.put_line('Gathered statistics for Reporting Structure table for XTD and Rolling Periods');