[Home] [Help]
1984: , glp.start_date
1985: , glp.end_date
1986: from
1987: gl_periods glp
1988: , fii_time_cal_name cal_name
1989: where glp.adjustment_period_flag = 'N'
1990: and glp.period_set_name = cal_name.period_set_name
1991: and glp.period_type = cal_name.period_type
1992: minus
2023: , glp.start_date
2024: , glp.end_date
2025: from
2026: gl_periods glp
2027: , fii_time_cal_name cal_name
2028: where glp.adjustment_period_flag = 'N'
2029: and glp.period_set_name = cal_name.period_set_name
2030: and glp.period_type = cal_name.period_type
2031: )
2097: sysdate,
2098: g_user_id,
2099: g_user_id,
2100: g_login_id
2101: from gl_periods glp, fii_time_cal_name cal_name
2102: where glp.adjustment_period_flag='N'
2103: and glp.period_set_name=cal_name.period_set_name
2104: and glp.period_type=cal_name.period_type;
2105:
2149: , min(gl2.start_date)
2150: , max(gl2.end_date)
2151: from
2152: gl_periods glp
2153: , fii_time_cal_name cal_name
2154: , (select period_set_name
2155: , period_type
2156: , period_year
2157: , quarter_num
2212: , min(gl2.start_date)
2213: , max(gl2.end_date)
2214: from
2215: gl_periods glp
2216: , fii_time_cal_name cal_name
2217: , (select period_set_name
2218: , period_type
2219: , period_year
2220: , quarter_num
2296: sysdate,
2297: g_user_id,
2298: g_user_id,
2299: g_login_id
2300: from gl_periods glp, fii_time_cal_name cal_name,
2301: (select period_set_name, period_type, period_year, quarter_num, min(start_date) start_date, max(end_date) end_date
2302: from gl_periods
2303: where adjustment_period_flag='N'
2304: group by period_set_name, period_type, period_year, quarter_num) gl2
2360: , min(gl2.start_date)
2361: , max(gl2.end_date)
2362: from
2363: gl_periods glp
2364: , fii_time_cal_name cal_name
2365: , (select period_set_name
2366: , period_type
2367: , period_year
2368: , min(start_date) start_date
2414: , min(gl2.start_date)
2415: , max(gl2.end_date)
2416: from
2417: gl_periods glp
2418: , fii_time_cal_name cal_name
2419: , (select period_set_name
2420: , period_type
2421: , period_year
2422: , min(start_date) start_date
2490: sysdate,
2491: g_user_id,
2492: g_user_id,
2493: g_login_id
2494: from gl_periods glp, fii_time_cal_name cal_name,
2495: (select period_set_name, period_type, period_year, min(start_date) start_date, max(end_date) end_date
2496: from gl_periods
2497: where adjustment_period_flag='N'
2498: group by period_set_name, period_type, period_year) gl2
2724: truncate_table('FII_TIME_YEAR445');
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');
3240: FROM ( SELECT DISTINCT glp.period_set_name , glp.period_type
3241: FROM gl_periods glp
3242: MINUS
3243: SELECT DISTINCT cal.period_set_name, cal.period_type
3244: FROM fii_time_cal_name cal
3245: ) inline_view,
3246: gl_periods gp
3247: WHERE inline_view.period_set_name = gp.period_set_name
3248: and inline_view.period_type = gp.period_type
3258: l_name_row := 0;
3259:
3260: select nvl(max(calendar_id),0)
3261: into l_max_cal_name
3262: from fii_time_cal_name;
3263:
3264: if g_schema is null then
3265: IF(FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, g_schema)) THEN
3266: NULL;
3271: -- Populate Calendar Name Level
3272: -- ----------------------
3273: FOR new_cal_rec IN new_cal LOOP
3274:
3275: insert into fii_time_cal_name
3276: (calendar_id,
3277: period_set_name,
3278: period_type,
3279: name,
3305: end if;
3306:
3307: if l_name_row > 0 then
3308:
3309: gather_table_stats('FII_TIME_CAL_NAME');
3310:
3311: if g_debug_flag = 'Y' then
3312: fii_util.put_line('LOAD_CAL_NAME : '||'Gathered statistics for Calendar Name Level');
3313: end if;