DBA Data[Home] [Help]

APPS.HXT_TRAN_PA dependencies on FND_DATE

Line 120: || fnd_date.date_to_chardate(l_timecard_rec.end_date)); --DEBUG ONLY

116: || TO_CHAR(l_timecard_rec.batch_id)); --DEBUG ONLY
117: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = '
118: || TO_CHAR(l_timecard_rec.time_period_id)); --DEBUG ONLY
119: HXT_UTIL.DEBUG('l_timecard_rec.end_date = '
120: || fnd_date.date_to_chardate(l_timecard_rec.end_date)); --DEBUG ONLY
121:
122: -- Clean up existing transfer to PA errors for this payroll/period
123: DELETE
124: FROM hxt_errors_f errf

Line 424: hr_utility.trace('l_non_rec.effective_start_date = '||fnd_date.date_to_chardate(l_non_rec.effective_start_date));

420: g_sum_hours_err_id := l_non_rec.sum_id;
421:
422: if g_debug then
423: hr_utility.trace('l_non_rec.sum_id = ' || TO_CHAR(l_non_rec.sum_id));
424: hr_utility.trace('l_non_rec.effective_start_date = '||fnd_date.date_to_chardate(l_non_rec.effective_start_date));
425: hr_utility.trace('l_non_rec.effective_end_date = '||fnd_date.date_to_chardate(l_non_rec.effective_end_date));
426: end if;
427: -- Calculate an houly rate for the salary basis
428: IF l_non_rec.pay_basis = 'ANNUAL' THEN

Line 425: hr_utility.trace('l_non_rec.effective_end_date = '||fnd_date.date_to_chardate(l_non_rec.effective_end_date));

421:
422: if g_debug then
423: hr_utility.trace('l_non_rec.sum_id = ' || TO_CHAR(l_non_rec.sum_id));
424: hr_utility.trace('l_non_rec.effective_start_date = '||fnd_date.date_to_chardate(l_non_rec.effective_start_date));
425: hr_utility.trace('l_non_rec.effective_end_date = '||fnd_date.date_to_chardate(l_non_rec.effective_end_date));
426: end if;
427: -- Calculate an houly rate for the salary basis
428: IF l_non_rec.pay_basis = 'ANNUAL' THEN
429: if g_debug then