APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_TIMECARD

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:

Line 1224: hxc_timecard_message_helper.addErrorToCollection

1220: IF g_debug THEN
1221: hr_utility.TRACE ('ABS:EXCEPTION IN POST_ABSENCES - Retrieval Rules not set');
1222: END IF;
1223:
1224: hxc_timecard_message_helper.addErrorToCollection
1225: (p_messages
1226: ,'HXC_GNUTL_NO_RET_RULE_FOR_RET'
1227: ,hxc_timecard.c_error
1228: ,null

Line 1227: ,hxc_timecard.c_error

1223:
1224: hxc_timecard_message_helper.addErrorToCollection
1225: (p_messages
1226: ,'HXC_GNUTL_NO_RET_RULE_FOR_RET'
1227: ,hxc_timecard.c_error
1228: ,null
1229: ,'EMP&'||nvl(l_emp_name, 'unknown')
1230: ,'HXC'
1231: ,null

Line 1265: hxc_timecard_message_helper.addErrorToCollection

1261: AND trunc(day_stop) <= trunc(g_tc_stop);
1262:
1263: END IF;
1264:
1265: hxc_timecard_message_helper.addErrorToCollection
1266: (p_messages
1267: ,nvl(g_error_message, 'HXC_ABS_RET_FAILED')
1268: ,hxc_timecard.c_error
1269: ,null

Line 1268: ,hxc_timecard.c_error

1264:
1265: hxc_timecard_message_helper.addErrorToCollection
1266: (p_messages
1267: ,nvl(g_error_message, 'HXC_ABS_RET_FAILED')
1268: ,hxc_timecard.c_error
1269: ,null
1270: ,'EMP_NAME&'||nvl(l_emp_name, 'unknown')
1271: ,'HXC'
1272: ,null