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

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 586: FROM hxt_sum_hours_worked hshw, hxt_timecards ht

582: IS
583: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
584: IS
585: SELECT hshw.tim_id, ht.time_period_id
586: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
587: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
588:
589: CURSOR get_debug
590: IS

Line 623: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;

619: l_effective_date DATE;
620: l_assignment_id NUMBER (9);
621: l_payroll_id NUMBER (9);
622: l_bg_id NUMBER (9);
623: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
624: l_otm_error VARCHAR2 (240) DEFAULT NULL;
625: l_oracle_error VARCHAR2 (512) DEFAULT NULL;
626: l_time_summary_id NUMBER;
627: l_time_sum_start_date DATE;

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 1872: FROM hxt_sum_hours_worked hshw, hxt_timecards ht

1868:
1869: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
1870: IS
1871: SELECT hshw.tim_id, ht.time_period_id
1872: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
1873: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
1874:
1875: CURSOR get_debug
1876: IS

Line 1916: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;

1912: l_effective_date DATE;
1913: l_assignment_id NUMBER (9);
1914: l_payroll_id NUMBER (9);
1915: l_bg_id NUMBER (9);
1916: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
1917: l_otm_error VARCHAR2 (240) DEFAULT NULL;
1918: l_oracle_error VARCHAR2 (512) DEFAULT NULL;
1919: l_time_summary_id NUMBER;
1920: l_time_sum_start_date DATE;

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