DBA Data[Home] [Help]

APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 1193: FROM hxc_timecard_summary

1189: SELECT timecard_id,
1190: timecard_ovn
1191: INTO l_timecard_id,
1192: l_timecard_ovn
1193: FROM hxc_timecard_summary
1194: WHERE resource_id = p_resource_id
1195: AND start_time = p_tc_start
1196: AND stop_time = TRUNC(p_tc_stop) + 1 - (1/86400) ;
1197:

Line 1202: hr_utility.trace('ABS: call to hxc_timecard_summary_pkg.update_transferred_to');

1198:
1199: IF g_debug THEN
1200: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);
1201: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);
1202: hr_utility.trace('ABS: call to hxc_timecard_summary_pkg.update_transferred_to');
1203: END IF;
1204:
1205: hxc_timecard_summary_pkg.update_transferred_to(l_timecard_id,
1206: l_timecard_ovn,

Line 1205: hxc_timecard_summary_pkg.update_transferred_to(l_timecard_id,

1201: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);
1202: hr_utility.trace('ABS: call to hxc_timecard_summary_pkg.update_transferred_to');
1203: END IF;
1204:
1205: hxc_timecard_summary_pkg.update_transferred_to(l_timecard_id,
1206: l_timecard_ovn,
1207: g_retrieval_process_id);
1208: END IF; -- IF p_tc_status <> 'DELETED' THEN
1209: