APPS.HXC_TC_AP_LINKS_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 49: from hxc_timecard_summary

45: cursor c_timecard_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
46: select resource_id
47: ,start_time
48: ,stop_time
49: from hxc_timecard_summary
50: where timecard_id = p_id;
51:
52: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type
53: ,p_start_time in hxc_time_building_blocks.start_time%type

Line 62: l_resource_id hxc_timecard_summary.resource_id%type;

58: where resource_id = p_resource_id
59: and start_time <= p_stop_time
60: and stop_time >= p_start_time;
61:
62: l_resource_id hxc_timecard_summary.resource_id%type;
63: l_start_time hxc_timecard_summary.start_time%type;
64: l_stop_time hxc_timecard_summary.stop_time%type;
65:
66: begin

Line 63: l_start_time hxc_timecard_summary.start_time%type;

59: and start_time <= p_stop_time
60: and stop_time >= p_start_time;
61:
62: l_resource_id hxc_timecard_summary.resource_id%type;
63: l_start_time hxc_timecard_summary.start_time%type;
64: l_stop_time hxc_timecard_summary.stop_time%type;
65:
66: begin
67:

Line 64: l_stop_time hxc_timecard_summary.stop_time%type;

60: and stop_time >= p_start_time;
61:
62: l_resource_id hxc_timecard_summary.resource_id%type;
63: l_start_time hxc_timecard_summary.start_time%type;
64: l_stop_time hxc_timecard_summary.stop_time%type;
65:
66: begin
67:
68: --

Line 125: from hxc_timecard_summary

121: ,p_start_time in hxc_time_building_blocks.start_time%type
122: ,p_stop_time in hxc_time_building_blocks.stop_time%type
123: ) is
124: select timecard_id
125: from hxc_timecard_summary
126: where resource_id = p_resource_id
127: and start_time <= p_stop_time
128: and stop_time >= p_start_time;
129:

Line 130: l_resource_id hxc_timecard_summary.resource_id%type;

126: where resource_id = p_resource_id
127: and start_time <= p_stop_time
128: and stop_time >= p_start_time;
129:
130: l_resource_id hxc_timecard_summary.resource_id%type;
131: l_start_time hxc_timecard_summary.start_time%type;
132: l_stop_time hxc_timecard_summary.stop_time%type;
133:
134: begin

Line 131: l_start_time hxc_timecard_summary.start_time%type;

127: and start_time <= p_stop_time
128: and stop_time >= p_start_time;
129:
130: l_resource_id hxc_timecard_summary.resource_id%type;
131: l_start_time hxc_timecard_summary.start_time%type;
132: l_stop_time hxc_timecard_summary.stop_time%type;
133:
134: begin
135: --

Line 132: l_stop_time hxc_timecard_summary.stop_time%type;

128: and stop_time >= p_start_time;
129:
130: l_resource_id hxc_timecard_summary.resource_id%type;
131: l_start_time hxc_timecard_summary.start_time%type;
132: l_stop_time hxc_timecard_summary.stop_time%type;
133:
134: begin
135: --
136: -- 1. Remove the existing application period links