[Home] [Help]
1984: , glp.start_date
1985: , glp.end_date
1986: from
1987: gl_periods glp
1988: , HRI_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: , HRI_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, HRI_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: , HRI_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: , HRI_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, HRI_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: , HRI_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: , HRI_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, HRI_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('HRI_TIME_YEAR445');
2725: truncate_table('HRI_TIME_ENT_PERIOD');
2726: truncate_table('HRI_TIME_ENT_QTR');
2727: truncate_table('HRI_TIME_ENT_YEAR');
2728: truncate_table('HRI_TIME_CAL_NAME');
2729: truncate_table('HRI_TIME_CAL_PERIOD');
2730: truncate_table('HRI_TIME_CAL_QTR');
2731: truncate_table('HRI_TIME_CAL_YEAR');
2732: truncate_table('HRI_TIME_RPT_STRUCT');
3241: FROM ( SELECT DISTINCT glp.period_set_name , glp.period_type
3242: FROM gl_periods glp
3243: MINUS
3244: SELECT DISTINCT cal.period_set_name, cal.period_type
3245: FROM HRI_time_cal_name cal
3246: ) inline_view,
3247: gl_periods gp
3248: WHERE inline_view.period_set_name = gp.period_set_name
3249: and inline_view.period_type = gp.period_type
3259: l_name_row := 0;
3260:
3261: select nvl(max(calendar_id),0)
3262: into l_max_cal_name
3263: from HRI_time_cal_name;
3264:
3265: if g_schema is null then
3266: IF(FND_INSTALLATION.GET_APP_INFO('HRI', l_status, l_industry, g_schema)) THEN
3267: NULL;
3272: -- Populate Calendar Name Level
3273: -- ----------------------
3274: FOR new_cal_rec IN new_cal LOOP
3275:
3276: insert into HRI_time_cal_name
3277: (calendar_id,
3278: period_set_name,
3279: period_type,
3280: name,
3306: end if;
3307:
3308: if l_name_row > 0 then
3309:
3310: gather_table_stats('HRI_TIME_CAL_NAME');
3311:
3312: if g_debug_flag = 'Y' then
3313: HRI_util.put_line('LOAD_CAL_NAME : '||'Gathered statistics for Calendar Name Level');
3314: end if;