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

Line 2733: hxc_timecard_message_helper.initializeErrors;

2729:
2730: IF g_debug THEN
2731: hr_utility.trace ('p_template_procedure='||p_template_procedure);
2732: END IF;
2733: hxc_timecard_message_helper.initializeErrors;
2734:
2735: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2736: ||p_template_procedure ||fnd_global.newline
2737: ||'(p_resource_id => :1' ||fnd_global.newline

Line 2758: hxc_timecard_message_helper.addErrorToCollection

2754:
2755: EXCEPTION
2756: when others then
2757:
2758: hxc_timecard_message_helper.addErrorToCollection
2759: (p_messages
2760: ,'HXC_INVALID_DYNAMIC_TEMPL'
2761: ,hxc_timecard.c_error
2762: ,null

Line 2761: ,hxc_timecard.c_error

2757:
2758: hxc_timecard_message_helper.addErrorToCollection
2759: (p_messages
2760: ,'HXC_INVALID_DYNAMIC_TEMPL'
2761: ,hxc_timecard.c_error
2762: ,null
2763: ,null
2764: ,hxc_timecard.c_hxc
2765: ,null

Line 2764: ,hxc_timecard.c_hxc

2760: ,'HXC_INVALID_DYNAMIC_TEMPL'
2761: ,hxc_timecard.c_error
2762: ,null
2763: ,null
2764: ,hxc_timecard.c_hxc
2765: ,null
2766: ,null
2767: ,null
2768: ,null

Line 3125: if(p_block_array(l_block_array_idx).scope = hxc_timecard.c_detail_scope) then

3121: l_block_array_idx := p_block_array.first;
3122: l_found := false;
3123: Loop
3124: Exit when ((l_found) or (not p_block_array.exists(l_block_array_idx)));
3125: if(p_block_array(l_block_array_idx).scope = hxc_timecard.c_detail_scope) then
3126: l_found := true;
3127: if((p_block_array(l_block_array_idx).translation_display_key is null)
3128: OR
3129: (p_block_array(l_block_array_idx).translation_display_key ='')) then

Line 3176: l_blocks(l_block_index).new := hxc_timecard.c_yes;

3172: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
3173: l_blocks(l_block_index).RESOURCE_ID := p_resource_id;
3174: l_blocks(l_block_index).RESOURCE_TYPE := p_resource_type;
3175: l_blocks(l_block_index).OBJECT_VERSION_NUMBER := 1;
3176: l_blocks(l_block_index).new := hxc_timecard.c_yes;
3177:
3178: if((l_blocks(l_block_index).translation_display_key is null)
3179: OR
3180: (l_blocks(l_block_index).translation_display_key = '')) then

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 5365: hxc_timecard_message_helper.addErrorToCollection

5361: l_attribute_count := l_temp_attributes.count;
5362:
5363: IF l_block_count < 0
5364: THEN
5365: hxc_timecard_message_helper.addErrorToCollection
5366: (p_messages
5367: ,'HXC_INVALID_DYNAMIC_TEMPL1'
5368: ,hxc_timecard.c_error
5369: ,null

Line 5368: ,hxc_timecard.c_error

5364: THEN
5365: hxc_timecard_message_helper.addErrorToCollection
5366: (p_messages
5367: ,'HXC_INVALID_DYNAMIC_TEMPL1'
5368: ,hxc_timecard.c_error
5369: ,null
5370: ,null
5371: ,hxc_timecard.c_hxc
5372: ,null

Line 5371: ,hxc_timecard.c_hxc

5367: ,'HXC_INVALID_DYNAMIC_TEMPL1'
5368: ,hxc_timecard.c_error
5369: ,null
5370: ,null
5371: ,hxc_timecard.c_hxc
5372: ,null
5373: ,null
5374: ,null
5375: ,null

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: