APPS.HXC_TCD_XML_PKG dependencies on HR_UTILITY

Line 230: hr_utility.trace(' ANUTHI Getting timecard start date for person id ' || p_person_id);

226: AND trunc(effective_start_date) <= trunc(p_period_start_date)
227: AND trunc(effective_end_date) >= trunc(p_period_end_date));
228: BEGIN
229:
230: hr_utility.trace(' ANUTHI Getting timecard start date for person id ' || p_person_id);
231:
232: IF p_period_start_date IS NOT NULL THEN
233: l_period_start_date := p_period_start_date;
234: g_tc_start_date := p_period_start_date;

Line 258: hr_utility.trace(' ANUTHI l_tc_start_date 1 ' || l_tc_start_date);

254: EXECUTE IMMEDIATE l_sql INTO l_tc_start_date USING
255: p_person_id, l_period_start_date, l_period_end_date,
256: l_period_start_date, l_period_end_date, l_period_start_date, l_period_end_date;
257:
258: hr_utility.trace(' ANUTHI l_tc_start_date 1 ' || l_tc_start_date);
259:
260: IF l_tc_start_date < l_period_start_date
261: THEN
262: l_tc_start_date := l_period_start_date;

Line 312: hr_utility.trace(' ANUTHI g_tc_start_date ' || g_tc_start_date);

308: END IF;
309: END IF;
310: g_tc_start_date := l_tc_start_date;
311:
312: hr_utility.trace(' ANUTHI g_tc_start_date ' || g_tc_start_date);
313:
314: return l_tc_start_date;
315:
316: END get_timecard_start_date;

Line 336: hr_utility.trace(' Getting timecard end date for person id ' || p_person_id);

332: BEGIN
333:
334: l_pref_table.DELETE;
335:
336: hr_utility.trace(' Getting timecard end date for person id ' || p_person_id);
337:
338: IF p_period_end_date IS NOT NULL THEN
339: l_period_end_date := p_period_end_date;
340: END IF;

Line 349: hr_utility.trace(' l_pref_table.count ' || l_pref_table.count);

345: ,p_start_evaluation_date => g_tc_start_date
346: ,p_end_evaluation_date => l_period_end_date
347: ,p_sorted_pref_table => l_pref_table );
348:
349: hr_utility.trace(' l_pref_table.count ' || l_pref_table.count);
350:
351: l_index := l_pref_table.FIRST;
352: l_prev_rec_period := '';
353: l_pref_end_date := l_pref_table(l_index).end_date;

Line 359: hr_utility.trace(' l_pref_table.start_date ' || l_pref_table(l_index).start_date);

355: LOOP
356: l_start_date := l_pref_table(l_index).start_date;
357: l_end_date := l_pref_table(l_index).end_date;
358:
359: hr_utility.trace(' l_pref_table.start_date ' || l_pref_table(l_index).start_date);
360: hr_utility.trace(' l_pref_table.end_date ' || l_pref_table(l_index).end_date);
361:
362: l_rec_period := l_pref_table(l_index).attribute1;
363:

Line 360: hr_utility.trace(' l_pref_table.end_date ' || l_pref_table(l_index).end_date);

356: l_start_date := l_pref_table(l_index).start_date;
357: l_end_date := l_pref_table(l_index).end_date;
358:
359: hr_utility.trace(' l_pref_table.start_date ' || l_pref_table(l_index).start_date);
360: hr_utility.trace(' l_pref_table.end_date ' || l_pref_table(l_index).end_date);
361:
362: l_rec_period := l_pref_table(l_index).attribute1;
363:
364: hr_utility.trace(' l_rec_period ' || l_rec_period);

Line 364: hr_utility.trace(' l_rec_period ' || l_rec_period);

360: hr_utility.trace(' l_pref_table.end_date ' || l_pref_table(l_index).end_date);
361:
362: l_rec_period := l_pref_table(l_index).attribute1;
363:
364: hr_utility.trace(' l_rec_period ' || l_rec_period);
365: hr_utility.trace(' l_prev_rec_period ' || l_prev_rec_period);
366:
367: IF(l_rec_period = l_prev_rec_period) THEN
368: l_pref_end_date := l_end_date;

Line 365: hr_utility.trace(' l_prev_rec_period ' || l_prev_rec_period);

361:
362: l_rec_period := l_pref_table(l_index).attribute1;
363:
364: hr_utility.trace(' l_rec_period ' || l_rec_period);
365: hr_utility.trace(' l_prev_rec_period ' || l_prev_rec_period);
366:
367: IF(l_rec_period = l_prev_rec_period) THEN
368: l_pref_end_date := l_end_date;
369: END IF;

Line 393: hr_utility.trace(' l_tc_end_date final ' || l_tc_end_date);

389: END IF;
390:
391: END IF;
392:
393: hr_utility.trace(' l_tc_end_date final ' || l_tc_end_date);
394:
395: return l_tc_end_date;
396: END get_timecard_end_date;
397:

Line 426: hr_utility.trace(' In populate_temp_table ');

422: l_tcd_rpt t_tcd_rpt;
423:
424: BEGIN
425:
426: hr_utility.trace(' In populate_temp_table ');
427:
428: l_sql := 'SELECT temp.*, ppt.user_person_type PERSON_TYPE, hasv.application_set_name APPLICATION
429: FROM
430: (SELECT distinct person_id,

Line 812: hr_utility.trace(' l_directsSQL ' || l_directsSQL);

808: END IF;
809:
810: l_directsSQL := l_directsSQL || ' ORDER BY 1 ';
811:
812: hr_utility.trace(' l_directsSQL ' || l_directsSQL);
813:
814:
815: -- Bug 8205132
816: -- New query, and less bind variables.