APPS.HRI_TIME_C dependencies on HRI_TIME_RPT_STRUCT

Line 2732: truncate_table('HRI_TIME_RPT_STRUCT');

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');
2733: truncate_table('HRI_TIME_CAL_RPT_STRUCT');
2734: truncate_table('HRI_TIME_STRUCTURES');
2735: truncate_table('HRI_TIME_ROLLING_OFFSETS');
2736: else

Line 3123: truncate_table('HRI_TIME_RPT_STRUCT');

3119: truncate_table('HRI_TIME_ENT_YEAR');
3120: truncate_table('HRI_TIME_CAL_PERIOD');
3121: truncate_table('HRI_TIME_CAL_QTR');
3122: truncate_table('HRI_TIME_CAL_YEAR');
3123: truncate_table('HRI_TIME_RPT_STRUCT');
3124: truncate_table('HRI_TIME_CAL_RPT_STRUCT');
3125:
3126: if g_debug_flag = 'Y' then
3127: HRI_util.put_line(' ');

Line 3350: --* We should do a full refresh for HRI_TIME_RPT_STRUCT

3346: l_ptd_to_date date;
3347: l_period_start_date date;
3348: l_row number;
3349:
3350: --* We should do a full refresh for HRI_TIME_RPT_STRUCT
3351: -- Bug 5624487
3352: cursor c1 is
3353: select report_date, ent_period_start_date, ent_qtr_start_date,
3354: ent_year_start_date, week_start_date

Line 3361: truncate_table('HRI_TIME_RPT_STRUCT');

3357: --*this would be incorrect: where report_date between l_from_date and l_to_date
3358:
3359: begin
3360:
3361: truncate_table('HRI_TIME_RPT_STRUCT');
3362:
3363: l_row := 0;
3364: --l_from_date := trunc(nvl(p_from_date,trunc(add_months(sysdate,-24),'YYYY')));
3365: --l_to_date := trunc(nvl(p_to_date,trunc(sysdate,'YYYY')));

Line 3368: insert into HRI_TIME_RPT_STRUCT

3364: --l_from_date := trunc(nvl(p_from_date,trunc(add_months(sysdate,-24),'YYYY')));
3365: --l_to_date := trunc(nvl(p_to_date,trunc(sysdate,'YYYY')));
3366:
3367: FOR c1_rec IN c1 LOOP
3368: insert into HRI_TIME_RPT_STRUCT
3369: (calendar_id,
3370: calendar_type,
3371: report_date,
3372: time_id,

Line 3401: insert into HRI_TIME_RPT_STRUCT

3397:
3398: While l_day >= least(l_week_start_date,l_period_start_date) LOOP
3399: if l_day >= l_period_start_date then
3400: if l_day >= l_week_start_date then
3401: insert into HRI_TIME_RPT_STRUCT
3402: (calendar_id,
3403: calendar_type,
3404: report_date,
3405: time_id,

Line 3434: insert into HRI_TIME_RPT_STRUCT

3430: where start_date >= l_period_start_date
3431: and start_date < l_week_start_date;
3432:
3433: if l_day < l_ptd_to_date then
3434: insert into HRI_TIME_RPT_STRUCT
3435: (calendar_id,
3436: calendar_type,
3437: report_date,
3438: time_id,

Line 3465: insert into HRI_TIME_RPT_STRUCT

3461: end if;
3462: end if;
3463: else
3464: if l_day >= l_week_start_date then
3465: insert into HRI_TIME_RPT_STRUCT
3466: (calendar_id,
3467: calendar_type,
3468: report_date,
3469: time_id,

Line 3501: insert into HRI_TIME_RPT_STRUCT

3497: END LOOP;
3498:
3499: commit;
3500:
3501: insert into HRI_TIME_RPT_STRUCT
3502: (calendar_id,
3503: calendar_type,
3504: report_date,
3505: time_id,

Line 3548: insert into HRI_TIME_RPT_STRUCT

3544: l_row := l_row + sql%rowcount;
3545:
3546: commit;
3547:
3548: insert into HRI_TIME_RPT_STRUCT
3549: (calendar_id,
3550: calendar_type,
3551: report_date,
3552: time_id,

Line 3598: insert into HRI_TIME_RPT_STRUCT

3594: l_row := l_row + sql%rowcount;
3595:
3596: commit;
3597:
3598: insert into HRI_TIME_RPT_STRUCT
3599: (calendar_id,
3600: calendar_type,
3601: report_date,
3602: time_id,

Line 3649: insert into HRI_TIME_RPT_STRUCT

3645: l_row := l_row + sql%rowcount;
3646:
3647: commit;
3648:
3649: insert into HRI_TIME_RPT_STRUCT
3650: (calendar_id,
3651: calendar_type,
3652: report_date,
3653: time_id,

Line 3681: insert into HRI_TIME_RPT_STRUCT

3677:
3678: commit;
3679:
3680: -- All prior years (report_type: 1024), for ITD
3681: insert into HRI_TIME_RPT_STRUCT
3682: (calendar_id,
3683: calendar_type,
3684: report_date,
3685: time_id,

Line 3719: gather_table_stats('HRI_TIME_RPT_STRUCT');

3715: if g_debug_flag = 'Y' then
3716: HRI_util.put_line('LOAD_TIME_RPT_STRUCT :'||to_char(l_row)||' records has been populated to the Reporting Structure table');
3717: end if;
3718:
3719: gather_table_stats('HRI_TIME_RPT_STRUCT');
3720:
3721: if g_debug_flag = 'Y' then
3722: HRI_util.put_line('LOAD_TIME_RPT_STRUCT :'||'Gathered statistics for the Reporting Structure table');
3723: end if;