APPS.HXC_TIMEKEEPER_ERRORS dependencies on HXC_ERRORS

Line 61: from hxc_errors tke

57: , bb.resource_id
58: FROM
59: hxc_time_building_blocks bb
60: WHERE EXISTS ( select 'x'
61: from hxc_errors tke
62: where tke.time_building_block_id = bb.time_building_block_id
63: and tke.time_building_block_ovn = bb.object_version_number)
64: START WITH bb.time_building_block_id = p_timecard_id
65: AND bb.object_version_number = p_timecard_ovn

Line 87: hxc_errors tke

83: , tke.MESSAGE_FIELD
84: , tke.MESSAGE_TOKENS
85: , tke.APPLICATION_SHORT_NAME
86: FROM
87: hxc_errors tke
88: WHERE
89: tke.time_building_block_id = p_tbb_id AND
90: tke.time_building_block_ovn = p_ovn_id AND
91: (tke.date_to=hr_general.end_of_time OR tke.date_to is NULL);

Line 226: from hxc_errors

222: cursor c_error_id
223: (p_tbb_id in number,
224: p_tbb_ovn in number) is
225: select *
226: from hxc_errors
227: where time_building_block_id = p_tbb_id
228: and time_building_block_ovn = p_tbb_ovn
229: and (date_to=hr_general.end_of_time OR date_to is NULL);
230:

Line 268: delete from hxc_errors

264: LOOP
265:
266: BEGIN
267:
268: delete from hxc_errors
269: where time_building_Block_id = p_messages(l_ind).time_building_block_id
270: and message_name = p_messages(l_ind).message_name
271: and NVL(message_tokens,'ZzZ') = NVL(p_messages(l_ind).message_tokens,'ZzZ');
272: