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_SELF_SERVICE_TIMECARD dependencies on HXC_TIMECARD_SUMMARY

Line 4671: from hxc_timecard_summary

4667: (p_resource_id in number,
4668: p_start_time in date,
4669: p_stop_time in date) is
4670: select timecard_id
4671: from hxc_timecard_summary
4672: where resource_id = p_resource_id
4673: and trunc(start_time) = trunc(p_start_time)
4674: and trunc(stop_time) = trunc(p_stop_time);
4675:

Line 4695: l_timecard_id hxc_timecard_summary.timecard_id%type;

4691: l_lock_rowid ROWID;
4692: l_temp_block HXC_BLOCK_TYPE;
4693: l_row_data hxc_trans_display_key_utils.translation_row_used;
4694: l_missing_rows boolean;
4695: l_timecard_id hxc_timecard_summary.timecard_id%type;
4696: l_temp_attributes hxc_attribute_table_type;
4697: i number;
4698:
4699: l_proc VARCHAR2(50);

Line 5111: FROM hxc_tc_ap_links tal, hxc_timecard_summary ts

5107: IS
5108: SELECT tal.application_period_id,
5109: ts.start_time,
5110: ts.stop_time
5111: FROM hxc_tc_ap_links tal, hxc_timecard_summary ts
5112: WHERE ts.timecard_id = p_timecard_id
5113: and ts.timecard_id = tal.timecard_id;
5114:
5115: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 5116: l_start_time hxc_timecard_summary.start_time%type;

5112: WHERE ts.timecard_id = p_timecard_id
5113: and ts.timecard_id = tal.timecard_id;
5114:
5115: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
5116: l_start_time hxc_timecard_summary.start_time%type;
5117: l_stop_time hxc_timecard_summary.stop_time%type;
5118: l_block_array HXC_BLOCK_TABLE_TYPE;
5119: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5120: l_message_string VARCHAR(2000) := NULL;

Line 5117: l_stop_time hxc_timecard_summary.stop_time%type;

5113: and ts.timecard_id = tal.timecard_id;
5114:
5115: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
5116: l_start_time hxc_timecard_summary.start_time%type;
5117: l_stop_time hxc_timecard_summary.stop_time%type;
5118: l_block_array HXC_BLOCK_TABLE_TYPE;
5119: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5120: l_message_string VARCHAR(2000) := NULL;
5121: l_count NUMBER;

Line 5383: FUNCTION get_timecard_transferred_to(f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE,

5379:
5380: END check_blocks_from_template;
5381:
5382:
5383: FUNCTION get_timecard_transferred_to(f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE,
5384: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2
5385: is
5386:
5387: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,

Line 5384: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2

5380: END check_blocks_from_template;
5381:
5382:
5383: FUNCTION get_timecard_transferred_to(f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE,
5384: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2
5385: is
5386:
5387: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,
5388: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS

Line 5387: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,

5383: FUNCTION get_timecard_transferred_to(f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE,
5384: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2
5385: is
5386:
5387: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,
5388: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS
5389: SELECT /*+ ordered */
5390: lat.time_building_block_id,
5391: lat.object_version_number

Line 5388: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS

5384: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2
5385: is
5386:
5387: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,
5388: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS
5389: SELECT /*+ ordered */
5390: lat.time_building_block_id,
5391: lat.object_version_number
5392: FROM hxc_timecard_summary sum,

Line 5392: FROM hxc_timecard_summary sum,

5388: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS
5389: SELECT /*+ ordered */
5390: lat.time_building_block_id,
5391: lat.object_version_number
5392: FROM hxc_timecard_summary sum,
5393: hxc_time_building_blocks day,
5394: hxc_time_building_blocks det,
5395: hxc_latest_details lat
5396: WHERE sum.timecard_id = l_timecard_id

Line 5422: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;

5418:
5419:
5420: --------------------------------------------------------------------------
5421:
5422: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;
5423: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;
5424: l_resource_id hxc_timecard_summary.resource_id%TYPE;
5425: l_start_time hxc_timecard_summary.start_time%TYPE;
5426:

Line 5423: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;

5419:
5420: --------------------------------------------------------------------------
5421:
5422: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;
5423: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;
5424: l_resource_id hxc_timecard_summary.resource_id%TYPE;
5425: l_start_time hxc_timecard_summary.start_time%TYPE;
5426:
5427:

Line 5424: l_resource_id hxc_timecard_summary.resource_id%TYPE;

5420: --------------------------------------------------------------------------
5421:
5422: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;
5423: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;
5424: l_resource_id hxc_timecard_summary.resource_id%TYPE;
5425: l_start_time hxc_timecard_summary.start_time%TYPE;
5426:
5427:
5428: TYPE building_blocks_tab IS TABLE OF NUMBER;

Line 5425: l_start_time hxc_timecard_summary.start_time%TYPE;

5421:
5422: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;
5423: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;
5424: l_resource_id hxc_timecard_summary.resource_id%TYPE;
5425: l_start_time hxc_timecard_summary.start_time%TYPE;
5426:
5427:
5428: TYPE building_blocks_tab IS TABLE OF NUMBER;
5429: