APPS.HRI_TIME_C dependencies on HRI_TIME_WEEK

Line 1097: -- delete from HRI_TIME_WEEK where start_date <= l_to_date and end_date >= l_from_date;

1093: l_year_num := to_char(l_week-g_week_offset,'iyyy');
1094: l_week_row := 0;
1095:
1096: -- Bug 5624487
1097: -- delete from HRI_TIME_WEEK where start_date <= l_to_date and end_date >= l_from_date;
1098: delete from HRI_TIME_WEEK
1099: where start_date <= l_to_date and end_date >= l_from_date
1100: or end_date >= g_unassigned_day;
1101:

Line 1098: delete from HRI_TIME_WEEK

1094: l_week_row := 0;
1095:
1096: -- Bug 5624487
1097: -- delete from HRI_TIME_WEEK where start_date <= l_to_date and end_date >= l_from_date;
1098: delete from HRI_TIME_WEEK
1099: where start_date <= l_to_date and end_date >= l_from_date
1100: or end_date >= g_unassigned_day;
1101:
1102: -- ----------------------

Line 1111: insert into HRI_time_week

1107: -- while l_week <= l_to_date loop
1108: while l_week <= l_to_date or l_week_end = g_unassigned_day loop
1109:
1110: -- Bug 5624487
1111: insert into HRI_time_week
1112: (week_id,
1113: period445_id,
1114: sequence,
1115: name,

Line 2722: truncate_table('HRI_TIME_WEEK');

2718: truncate_table('HRI_TIME_DAY');
2719: truncate_table('HRI_TIME_MONTH');
2720: truncate_table('HRI_TIME_QTR');
2721: truncate_table('HRI_TIME_YEAR');
2722: truncate_table('HRI_TIME_WEEK');
2723: truncate_table('HRI_TIME_P445');
2724: truncate_table('HRI_TIME_YEAR445');
2725: truncate_table('HRI_TIME_ENT_PERIOD');
2726: truncate_table('HRI_TIME_ENT_QTR');

Line 3114: truncate_table('HRI_TIME_WEEK');

3110: end if;
3111:
3112: else
3113:
3114: truncate_table('HRI_TIME_WEEK');
3115: truncate_table('HRI_TIME_P445');
3116: truncate_table('HRI_TIME_YEAR445');
3117: truncate_table('HRI_TIME_ENT_PERIOD');
3118: truncate_table('HRI_TIME_ENT_QTR');

Line 3429: select nvl(min(start_date),l_week_start_date) into l_ptd_to_date from HRI_TIME_WEEK

3425:
3426: l_row := l_row + sql%rowcount;
3427:
3428: else
3429: select nvl(min(start_date),l_week_start_date) into l_ptd_to_date from HRI_TIME_WEEK
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

Line 3525: from HRI_TIME_WEEK

3521: sysdate,
3522: g_user_id,
3523: g_user_id,
3524: g_login_id
3525: from HRI_TIME_WEEK
3526: where start_date >= c1_rec.ent_period_start_date
3527: and end_date < c1_rec.week_start_date
3528: union all
3529: select

Line 3541: from HRI_TIME_WEEK

3537: sysdate,
3538: g_user_id,
3539: g_user_id,
3540: g_login_id
3541: from HRI_TIME_WEEK
3542: where c1_rec.report_date between start_date and end_date;
3543:
3544: l_row := l_row + sql%rowcount;
3545:

Line 3852: FROM HRI_time_week

3848:
3849: IF l_No_Week_Info ='N' THEN
3850: SELECT NVL(MIN(start_date),l_Week_Start_Date)
3851: INTO l_Earliest_Week
3852: FROM HRI_time_week
3853: WHERE start_date >= cur_Fiscal_Days.period_start_date
3854: AND start_date < l_Week_Start_Date;
3855:
3856: WHILE l_Day >= cur_Fiscal_Days.period_start_date LOOP

Line 3944: FROM HRI_TIME_WEEK

3940: , SYSDATE
3941: , g_user_id
3942: , g_user_id
3943: , g_login_id
3944: FROM HRI_TIME_WEEK
3945: WHERE start_date >= cur_Fiscal_Days.period_start_date
3946: AND end_date < l_Week_Start_Date;
3947:
3948: l_Row := l_Row + SQL%ROWCOUNT;