eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_AP_DETAIL_LINKS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 5: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;

1: package body hxc_ap_detail_links_pkg as
2: /* $Header: hxcadtsum.pkb 120.2 2005/09/23 08:03:11 sechandr noship $ */
3:
4: g_debug BOOLEAN:= hr_utility.debug_enabled;
5: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type

Line 8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type

4: g_debug BOOLEAN:= hr_utility.debug_enabled;
5: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
10: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
11:
12: begin

Line 9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type

5: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
10: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
11:
12: begin
13:

Line 10: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is

6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
10: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
11:
12: begin
13:
14: --

Line 38: procedure delete_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type

34: );
35:
36: end insert_summary_row;
37:
38: procedure delete_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
39: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
40: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
41:
42: begin

Line 39: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type

35:
36: end insert_summary_row;
37:
38: procedure delete_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
39: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
40: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
41:
42: begin
43:

Line 40: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is

36: end insert_summary_row;
37:
38: procedure delete_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
39: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
40: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
41:
42: begin
43:
44: delete from hxc_ap_detail_links

Line 51: procedure delete_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is

47: and time_building_block_ovn = p_time_building_block_ovn;
48:
49: end delete_summary_row;
50:
51: procedure delete_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
52:
53: begin
54:
55: delete from hxc_ap_detail_links where application_period_id = p_application_period_id;

Line 207: procedure create_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is

203: END delete_ap_detail_links;
204:
205:
206:
207: procedure create_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
208:
209: cursor c_app_period_info
210: (p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
211: select resource_id

Line 210: (p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is

206:
207: procedure create_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
208:
209: cursor c_app_period_info
210: (p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
211: select resource_id
212: ,start_time
213: ,stop_time
214: from hxc_app_period_summary

Line 218: (p_rid in hxc_time_building_blocks.resource_id%type

214: from hxc_app_period_summary
215: where application_period_id = p_application_period_id;
216:
217: cursor c_detail_info
218: (p_rid in hxc_time_building_blocks.resource_id%type
219: ,p_start_time in hxc_time_building_blocks.start_time%type
220: ,p_stop_time in hxc_time_building_blocks.stop_time%type
221: ) is
222: select details.time_building_block_id

Line 219: ,p_start_time in hxc_time_building_blocks.start_time%type

215: where application_period_id = p_application_period_id;
216:
217: cursor c_detail_info
218: (p_rid in hxc_time_building_blocks.resource_id%type
219: ,p_start_time in hxc_time_building_blocks.start_time%type
220: ,p_stop_time in hxc_time_building_blocks.stop_time%type
221: ) is
222: select details.time_building_block_id
223: ,details.object_version_number

Line 220: ,p_stop_time in hxc_time_building_blocks.stop_time%type

216:
217: cursor c_detail_info
218: (p_rid in hxc_time_building_blocks.resource_id%type
219: ,p_start_time in hxc_time_building_blocks.start_time%type
220: ,p_stop_time in hxc_time_building_blocks.stop_time%type
221: ) is
222: select details.time_building_block_id
223: ,details.object_version_number
224: from hxc_time_building_blocks details, hxc_time_building_blocks days

Line 224: from hxc_time_building_blocks details, hxc_time_building_blocks days

220: ,p_stop_time in hxc_time_building_blocks.stop_time%type
221: ) is
222: select details.time_building_block_id
223: ,details.object_version_number
224: from hxc_time_building_blocks details, hxc_time_building_blocks days
225: where days.resource_id = p_rid
226: and trunc(days.stop_time) >= trunc(p_start_time)
227: and trunc(days.start_time) <= trunc(p_stop_time)
228: and days.scope = 'DAY'

Line 235: l_resource_id hxc_time_building_blocks.resource_id%type;

231: and details.parent_building_block_ovn = days.object_version_number
232: and details.date_to = hr_general.end_of_time
233: and details.scope = 'DETAIL';
234:
235: l_resource_id hxc_time_building_blocks.resource_id%type;
236: l_start_time hxc_time_building_blocks.start_time%type;
237: l_stop_time hxc_time_building_blocks.stop_time%type;
238:
239:

Line 236: l_start_time hxc_time_building_blocks.start_time%type;

232: and details.date_to = hr_general.end_of_time
233: and details.scope = 'DETAIL';
234:
235: l_resource_id hxc_time_building_blocks.resource_id%type;
236: l_start_time hxc_time_building_blocks.start_time%type;
237: l_stop_time hxc_time_building_blocks.stop_time%type;
238:
239:
240: begin

Line 237: l_stop_time hxc_time_building_blocks.stop_time%type;

233: and details.scope = 'DETAIL';
234:
235: l_resource_id hxc_time_building_blocks.resource_id%type;
236: l_start_time hxc_time_building_blocks.start_time%type;
237: l_stop_time hxc_time_building_blocks.stop_time%type;
238:
239:
240: begin
241: