[Home] [Help]
318: /* Find the next date that would be 'Day 01' w.r.t. the p_wp_dets record */
319: l_dt_on_day1 := p_wp_dets.effective_start_date + l_diff_days;
320:
321: --hr_utility.trace('get_days_dets:l_dt_on_day1:'||
322: --fnd_date.date_to_canonical(l_dt_on_day1));
323:
324:
325: /* Find difference between calculation start_date and date on 'Day 01' */
326: l_diff_temp := p_calc_stdt - l_dt_on_day1;
765: hr_utility.set_location('Using only Asg WP', 40);
766:
767: l_calc_endt := LEAST(p_date_end, r_wp_dets.effective_end_date);
768:
769: hr_utility.trace(fnd_date.date_to_canonical(l_calc_stdt));
770: calculate_time_worked_wp
771: (p_date_start => l_calc_stdt
772: ,p_date_end => l_calc_endt
773: ,p_wp_dets => r_wp_dets
798: l_calc_stdt)),2,'0');
799:
800: hr_utility.set_location('Start Day :'||r_def_wp_dets.start_day, 60);
801:
802: hr_utility.trace(fnd_date.date_to_canonical(l_calc_stdt));
803: calculate_time_worked_wp
804: (p_date_start => l_calc_stdt
805: ,p_date_end => l_calc_endt
806: ,p_wp_dets => r_def_wp_dets
1135:
1136: BEGIN /*is_working_day*/
1137:
1138: hr_utility.trace('Entered Is Working Day?'||
1139: fnd_date.date_to_canonical(p_date));
1140: hr_utility.trace('p_assignment_id:'||
1141: fnd_number.number_to_canonical(p_assignment_id));
1142: hr_utility.trace('p_override_wp:'||p_override_wp);
1143:
1159:
1160: hr_utility.trace('p_assignment_id:'||
1161: fnd_number.number_to_canonical(p_assignment_id));
1162: hr_utility.trace('Leaving Is Working Day?'||
1163: fnd_date.date_to_canonical(p_date));
1164:
1165:
1166:
1167: RETURN l_is_working_day;
1928: debug('Cache Reload Check');
1929: debug('g_last_business_group_id:'||g_last_business_group_id);
1930: debug('g_last_used_work_pattern:'||g_last_used_work_pattern);
1931: debug('l_work_pattern_to_use:'||l_work_pattern_to_use);
1932: debug('p_date_start:'||fnd_date.date_to_canonical(p_date_start));
1933: debug('g_last_max_effective_start_dt:'||
1934: fnd_date.date_to_canonical(g_last_max_effective_start_dt));
1935: debug('g_last_min_effective_end_dt:'||
1936: fnd_date.date_to_canonical(g_last_min_effective_end_dt));
1930: debug('g_last_used_work_pattern:'||g_last_used_work_pattern);
1931: debug('l_work_pattern_to_use:'||l_work_pattern_to_use);
1932: debug('p_date_start:'||fnd_date.date_to_canonical(p_date_start));
1933: debug('g_last_max_effective_start_dt:'||
1934: fnd_date.date_to_canonical(g_last_max_effective_start_dt));
1935: debug('g_last_min_effective_end_dt:'||
1936: fnd_date.date_to_canonical(g_last_min_effective_end_dt));
1937: END IF;
1938:
1932: debug('p_date_start:'||fnd_date.date_to_canonical(p_date_start));
1933: debug('g_last_max_effective_start_dt:'||
1934: fnd_date.date_to_canonical(g_last_max_effective_start_dt));
1935: debug('g_last_min_effective_end_dt:'||
1936: fnd_date.date_to_canonical(g_last_min_effective_end_dt));
1937: END IF;
1938:
1939: --2. Cache if not allready (and if not effective as if date_start)
1940:
2191: IF g_debug THEN
2192: debug('p_work_pattern_used:'||l_work_pattern_to_use);
2193: debug('p_asg_work_pattern_start_day_n:'||l_asg_work_pattern_start_day_n);
2194: debug('p_asg_work_pattern_start_date:'||
2195: fnd_date.date_to_canonical(l_asg_work_pattern_start_date));
2196: debug('p_date_start_day_index:'||l_date_start_day_index);
2197: debug_exit(l_proc_name);
2198: END IF;
2199:
2335: l_date_after_n_working_days := p_date_start + l_total_calendar_days;
2336:
2337: IF g_debug THEN
2338: debug('l_date_after_n_working_days:'||
2339: fnd_date.date_to_canonical(l_date_after_n_working_days));
2340: debug_exit(l_proc_name);
2341: END IF; -- IF g_debug THEN
2342:
2343: RETURN l_date_after_n_working_days;