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.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXT_SUM_HOURS_WORKED_F

Line 30: FROM hxt_sum_hours_worked_f

26:
27: CURSOR c_get_sum_id (day_bb_id NUMBER)
28: IS
29: SELECT ID, tim_id
30: FROM hxt_sum_hours_worked_f
31: WHERE time_building_block_id = day_bb_id;
32:
33: -- Cursor to get those rows(from HXC tables) that have been deleted in OTL
34: -- but this delete not yet been reflected in the OTLR tables because of the

Line 473: DELETE FROM hxt_sum_hours_worked_f

469:
470: --
471: -- Delete the summary row itself.
472: --
473: DELETE FROM hxt_sum_hours_worked_f
474: WHERE ID = l_time_summary_id;
475:
476: IF g_debug
477: THEN

Line 661: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;

657: e_error EXCEPTION;
658: l_proc VARCHAR2 (100);
659: l_delete VARCHAR2 (1);
660: l_tim_sum BINARY_INTEGER;
661: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
662: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
663: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
664: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
665: l_tim_id NUMBER;

Line 662: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;

658: l_proc VARCHAR2 (100);
659: l_delete VARCHAR2 (1);
660: l_tim_sum BINARY_INTEGER;
661: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
662: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
663: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
664: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
665: l_tim_id NUMBER;
666: BEGIN

Line 663: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;

659: l_delete VARCHAR2 (1);
660: l_tim_sum BINARY_INTEGER;
661: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
662: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
663: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
664: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
665: l_tim_id NUMBER;
666: BEGIN
667: g_debug := hr_utility.debug_enabled;

Line 664: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

660: l_tim_sum BINARY_INTEGER;
661: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
662: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
663: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
664: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
665: l_tim_id NUMBER;
666: BEGIN
667: g_debug := hr_utility.debug_enabled;
668:

Line 1959: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;

1955: l_hrstype_entered VARCHAR2 (1) := 'N';
1956: l_tim_sum BINARY_INTEGER;
1957: -- Bug 3012684
1958: l_error_flag VARCHAR2 (1) := 'N';
1959: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1960: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1961: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1962: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1963: l_time_building_blocks hxc_self_service_time_deposit.timecard_info

Line 1960: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;

1956: l_tim_sum BINARY_INTEGER;
1957: -- Bug 3012684
1958: l_error_flag VARCHAR2 (1) := 'N';
1959: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1960: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1961: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1962: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1963: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1964: := p_time_building_blocks;

Line 1961: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;

1957: -- Bug 3012684
1958: l_error_flag VARCHAR2 (1) := 'N';
1959: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1960: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1961: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1962: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1963: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1964: := p_time_building_blocks;
1965: l_time_attributes hxc_self_service_time_deposit.app_attributes_info

Line 1962: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

1958: l_error_flag VARCHAR2 (1) := 'N';
1959: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1960: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1961: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1962: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1963: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1964: := p_time_building_blocks;
1965: l_time_attributes hxc_self_service_time_deposit.app_attributes_info
1966: := p_time_attributes;

Line 3891: FROM hxt_sum_hours_worked_f sum,

3887:
3888: CURSOR get_sum_id( p_bb_id IN NUMBER)
3889: IS SELECT tim_id,
3890: id
3891: FROM hxt_sum_hours_worked_f sum,
3892: fnd_sessions fnd
3893: WHERE time_building_block_id = p_bb_id
3894: AND fnd.effective_date BETWEEN sum.effective_start_date
3895: AND sum.effective_end_date