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_TIMEKEEPER dependencies on HXC_TIME_BUILDING_BLOCKS

Line 101: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

97: End remove_blank_attribute_rows;
98:
99: --Procedure Added as part of Bug 13524669 --
100: Procedure end_date_app_period
101: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
102: ) is
103:
104: TYPE numtab IS TABLE OF NUMBER;
105: app_period_tab numtab;

Line 136: hr_utility.trace('End dating application period in hxc_time_building_blocks and deleting from hxc_app_period_summary'||app_period_tab(i));

132:
133: if (app_period_tab.COUNT > 0) then
134: for i in app_period_tab.first..app_period_tab.last
135: loop
136: hr_utility.trace('End dating application period in hxc_time_building_blocks and deleting from hxc_app_period_summary'||app_period_tab(i));
137: update hxc_time_building_blocks
138: set date_to = sysdate
139: where time_building_block_id = app_period_tab(i)
140: and date_to = hr_general.end_of_time;

Line 137: update hxc_time_building_blocks

133: if (app_period_tab.COUNT > 0) then
134: for i in app_period_tab.first..app_period_tab.last
135: loop
136: hr_utility.trace('End dating application period in hxc_time_building_blocks and deleting from hxc_app_period_summary'||app_period_tab(i));
137: update hxc_time_building_blocks
138: set date_to = sysdate
139: where time_building_block_id = app_period_tab(i)
140: and date_to = hr_general.end_of_time;
141:

Line 156: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

152: Procedure save_timecard
153: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
154: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
155: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
156: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
157: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
158: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
159: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
160: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL

Line 157: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type

153: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
154: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
155: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
156: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
157: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
158: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
159: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
160: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
161: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL

Line 158: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL

154: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
155: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
156: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
157: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
158: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
159: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
160: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
161: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
162: ) is

Line 1316: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

1312: Procedure submit_timecard
1313: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
1314: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
1315: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
1316: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
1317: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
1318: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
1319: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
1320: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL

Line 1317: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type

1313: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
1314: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
1315: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
1316: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
1317: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
1318: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
1319: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
1320: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
1321: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL

Line 1318: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL

1314: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
1315: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
1316: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
1317: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
1318: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
1319: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
1320: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
1321: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
1322: ) IS

Line 2495: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type

2491: -- Delete Timecard Procedure
2492: -- This procedure....
2493: ----------------------------------------------------------------------------
2494: Procedure delete_timecard
2495: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
2496: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
2497: ) is
2498:
2499: /*

Line 2515: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

2511: where timecard_id = p_timecard_id;
2512:
2513: /*
2514: cursor c_timecard_ovn
2515: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
2516: select tbb.object_version_number
2517: from hxc_time_building_blocks tbb
2518: where tbb.time_building_block_id = p_timecard_id
2519: and tbb.date_to = hr_general.end_of_time;

Line 2517: from hxc_time_building_blocks tbb

2513: /*
2514: cursor c_timecard_ovn
2515: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
2516: select tbb.object_version_number
2517: from hxc_time_building_blocks tbb
2518: where tbb.time_building_block_id = p_timecard_id
2519: and tbb.date_to = hr_general.end_of_time;
2520: */
2521:

Line 2522: CURSOR csr_chk_transfer (p_timecard_id hxc_time_building_blocks.time_building_block_id%type) IS

2518: where tbb.time_building_block_id = p_timecard_id
2519: and tbb.date_to = hr_general.end_of_time;
2520: */
2521:
2522: CURSOR csr_chk_transfer (p_timecard_id hxc_time_building_blocks.time_building_block_id%type) IS
2523: SELECT 1
2524: FROM dual
2525: WHERE EXISTS (
2526: SELECT 1

Line 2547: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;

2543: l_timecard_props hxc_timecard_prop_table_type;
2544:
2545: l_dummy boolean := true;
2546:
2547: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
2548: l_timecard_index number;
2549:
2550: l_status_error BOOLEAN := FALSE;
2551: