[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
1129:
1130: BEGIN /*is_working_day*/
1131:
1132: hr_utility.trace('Entered Is Working Day?'||
1133: fnd_date.date_to_canonical(p_date));
1134: hr_utility.trace('p_assignment_id:'||
1135: fnd_number.number_to_canonical(p_assignment_id));
1136: hr_utility.trace('p_override_wp:'||p_override_wp);
1137:
1153:
1154: hr_utility.trace('p_assignment_id:'||
1155: fnd_number.number_to_canonical(p_assignment_id));
1156: hr_utility.trace('Leaving Is Working Day?'||
1157: fnd_date.date_to_canonical(p_date));
1158:
1159:
1160:
1161: RETURN l_is_working_day;
1919: debug('Cache Reload Check');
1920: debug('g_last_business_group_id:'||g_last_business_group_id);
1921: debug('g_last_used_work_pattern:'||g_last_used_work_pattern);
1922: debug('l_work_pattern_to_use:'||l_work_pattern_to_use);
1923: debug('p_date_start:'||fnd_date.date_to_canonical(p_date_start));
1924: debug('g_last_max_effective_start_dt:'||
1925: fnd_date.date_to_canonical(g_last_max_effective_start_dt));
1926: debug('g_last_min_effective_end_dt:'||
1927: fnd_date.date_to_canonical(g_last_min_effective_end_dt));
1921: debug('g_last_used_work_pattern:'||g_last_used_work_pattern);
1922: debug('l_work_pattern_to_use:'||l_work_pattern_to_use);
1923: debug('p_date_start:'||fnd_date.date_to_canonical(p_date_start));
1924: debug('g_last_max_effective_start_dt:'||
1925: fnd_date.date_to_canonical(g_last_max_effective_start_dt));
1926: debug('g_last_min_effective_end_dt:'||
1927: fnd_date.date_to_canonical(g_last_min_effective_end_dt));
1928: END IF;
1929:
1923: debug('p_date_start:'||fnd_date.date_to_canonical(p_date_start));
1924: debug('g_last_max_effective_start_dt:'||
1925: fnd_date.date_to_canonical(g_last_max_effective_start_dt));
1926: debug('g_last_min_effective_end_dt:'||
1927: fnd_date.date_to_canonical(g_last_min_effective_end_dt));
1928: END IF;
1929:
1930: --2. Cache if not allready (and if not effective as if date_start)
1931:
2179: IF g_debug THEN
2180: debug('p_work_pattern_used:'||l_work_pattern_to_use);
2181: debug('p_asg_work_pattern_start_day_n:'||l_asg_work_pattern_start_day_n);
2182: debug('p_asg_work_pattern_start_date:'||
2183: fnd_date.date_to_canonical(l_asg_work_pattern_start_date));
2184: debug('p_date_start_day_index:'||l_date_start_day_index);
2185: debug_exit(l_proc_name);
2186: END IF;
2187:
2323: l_date_after_n_working_days := p_date_start + l_total_calendar_days;
2324:
2325: IF g_debug THEN
2326: debug('l_date_after_n_working_days:'||
2327: fnd_date.date_to_canonical(l_date_after_n_working_days));
2328: debug_exit(l_proc_name);
2329: END IF; -- IF g_debug THEN
2330:
2331: RETURN l_date_after_n_working_days;