APPS.FII_TIME_C dependencies on FII_TIME_CAL_PERIOD

Line 2002: fii_time_cal_period

1998: , name
1999: , start_date
2000: , end_date
2001: from
2002: fii_time_cal_period
2003: )
2004: union all
2005: (select
2006: cal_period_id

Line 2014: fii_time_cal_period

2010: , name
2011: , start_date
2012: , end_date
2013: from
2014: fii_time_cal_period
2015: minus
2016: select
2017: to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year||glp.quarter_num||decode(length(glp.period_num),1,'0'||glp.period_num, glp.period_num))
2018: -- lpad(gl.period_num,2,'0')) bug 3370185

Line 2041: --For Bug 3543939. If there is a difference then truncate and repopulate FII_TIME_CAL_PERIOD

2037: if g_debug_flag = 'Y' then
2038: fii_util.put_line('LOAD_CAL_PERIOD : '||to_char(l_period_changed)||' Calendars have changed in GL');
2039: end if;
2040:
2041: --For Bug 3543939. If there is a difference then truncate and repopulate FII_TIME_CAL_PERIOD
2042:
2043: -- Bug 4966868: Changed not to count rows
2044: BEGIN
2045: select 1 into l_diff_rows

Line 2065: truncate_table('FII_TIME_CAL_PERIOD');

2061: return;
2062:
2063: end if;
2064:
2065: truncate_table('FII_TIME_CAL_PERIOD');
2066:
2067: -- ---------------------------------------------------------
2068: -- Variable initialization
2069: -- ---------------------------------------------------------

Line 2075: insert into fii_time_cal_period

2071:
2072: -- ----------------------
2073: -- Populate Financial Period Level
2074: -- ----------------------
2075: insert into fii_time_cal_period
2076: (cal_period_id,
2077: cal_qtr_id,
2078: calendar_id,
2079: sequence,

Line 2114: gather_table_stats('FII_TIME_CAL_PERIOD');

2110: if g_debug_flag = 'Y' then
2111: fii_util.put_line('LOAD_CAL_PERIOD : '||to_char(l_period_row)||' records has been populated to Financial Period Level');
2112: end if;
2113:
2114: gather_table_stats('FII_TIME_CAL_PERIOD');
2115:
2116: if g_debug_flag = 'Y' then
2117: fii_util.put_line('LOAD_CAL_PERIOD : '||'Gathered statistics for Financial Period Level');
2118: end if;

Line 2729: truncate_table('FII_TIME_CAL_PERIOD');

2725: truncate_table('FII_TIME_ENT_PERIOD');
2726: truncate_table('FII_TIME_ENT_QTR');
2727: truncate_table('FII_TIME_ENT_YEAR');
2728: truncate_table('FII_TIME_CAL_NAME');
2729: truncate_table('FII_TIME_CAL_PERIOD');
2730: truncate_table('FII_TIME_CAL_QTR');
2731: truncate_table('FII_TIME_CAL_YEAR');
2732: truncate_table('FII_TIME_RPT_STRUCT');
2733: truncate_table('FII_TIME_CAL_RPT_STRUCT');

Line 3120: truncate_table('FII_TIME_CAL_PERIOD');

3116: truncate_table('FII_TIME_YEAR445');
3117: truncate_table('FII_TIME_ENT_PERIOD');
3118: truncate_table('FII_TIME_ENT_QTR');
3119: truncate_table('FII_TIME_ENT_YEAR');
3120: truncate_table('FII_TIME_CAL_PERIOD');
3121: truncate_table('FII_TIME_CAL_QTR');
3122: truncate_table('FII_TIME_CAL_YEAR');
3123: truncate_table('FII_TIME_RPT_STRUCT');
3124: truncate_table('FII_TIME_CAL_RPT_STRUCT');

Line 4009: FROM FII_TIME_CAL_PERIOD

4005: , SYSDATE
4006: , g_user_id
4007: , g_user_id
4008: , g_login_id
4009: FROM FII_TIME_CAL_PERIOD
4010: WHERE start_date >= cur_Fiscal_Days.qtr_start_date
4011: AND start_date <= cur_Fiscal_Days.period_start_date
4012: AND end_date < cur_Fiscal_Days.report_date
4013: AND calendar_id = cur_Fiscal_Days.calendar_id

Line 4027: FROM FII_TIME_CAL_PERIOD

4023: , SYSDATE
4024: , g_user_id
4025: , g_user_id
4026: , g_login_id
4027: FROM FII_TIME_CAL_PERIOD
4028: WHERE start_date >= cur_Fiscal_Days.qtr_start_date
4029: AND start_date <= cur_Fiscal_Days.period_start_date
4030: AND end_date >= cur_Fiscal_Days.report_date
4031: AND calendar_id = cur_Fiscal_Days.calendar_id;