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 462: DELETE FROM hxt_sum_hours_worked_f

458:
459: --
460: -- Delete the summary row itself.
461: --
462: DELETE FROM hxt_sum_hours_worked_f
463: WHERE ID = l_time_summary_id;
464:
465: IF g_debug
466: THEN

Line 575: FROM hxt_sum_hours_worked hshw, hxt_timecards ht

571: IS
572: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
573: IS
574: SELECT hshw.tim_id, ht.time_period_id
575: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
576: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
577:
578: CURSOR get_debug
579: IS

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

608: l_effective_date DATE;
609: l_assignment_id NUMBER (9);
610: l_payroll_id NUMBER (9);
611: l_bg_id NUMBER (9);
612: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
613: l_otm_error VARCHAR2 (240) DEFAULT NULL;
614: l_oracle_error VARCHAR2 (512) DEFAULT NULL;
615: l_time_summary_id NUMBER;
616: l_time_sum_start_date DATE;

Line 650: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;

646: e_error EXCEPTION;
647: l_proc VARCHAR2 (100);
648: l_delete VARCHAR2 (1);
649: l_tim_sum BINARY_INTEGER;
650: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
651: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
652: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
653: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
654: l_tim_id NUMBER;

Line 651: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;

647: l_proc VARCHAR2 (100);
648: l_delete VARCHAR2 (1);
649: l_tim_sum BINARY_INTEGER;
650: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
651: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
652: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
653: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
654: l_tim_id NUMBER;
655: BEGIN

Line 652: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;

648: l_delete VARCHAR2 (1);
649: l_tim_sum BINARY_INTEGER;
650: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
651: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
652: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
653: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
654: l_tim_id NUMBER;
655: BEGIN
656: g_debug := hr_utility.debug_enabled;

Line 653: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

649: l_tim_sum BINARY_INTEGER;
650: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
651: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
652: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
653: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
654: l_tim_id NUMBER;
655: BEGIN
656: g_debug := hr_utility.debug_enabled;
657:

Line 1832: FROM hxt_sum_hours_worked hshw, hxt_timecards ht

1828:
1829: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
1830: IS
1831: SELECT hshw.tim_id, ht.time_period_id
1832: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
1833: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
1834:
1835: CURSOR get_debug
1836: IS

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

1872: l_effective_date DATE;
1873: l_assignment_id NUMBER (9);
1874: l_payroll_id NUMBER (9);
1875: l_bg_id NUMBER (9);
1876: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
1877: l_otm_error VARCHAR2 (240) DEFAULT NULL;
1878: l_oracle_error VARCHAR2 (512) DEFAULT NULL;
1879: l_time_summary_id NUMBER;
1880: l_time_sum_start_date DATE;

Line 1919: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;

1915: l_hrstype_entered VARCHAR2 (1) := 'N';
1916: l_tim_sum BINARY_INTEGER;
1917: -- Bug 3012684
1918: l_error_flag VARCHAR2 (1) := 'N';
1919: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1920: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1921: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1922: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1923: l_time_building_blocks hxc_self_service_time_deposit.timecard_info

Line 1920: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;

1916: l_tim_sum BINARY_INTEGER;
1917: -- Bug 3012684
1918: l_error_flag VARCHAR2 (1) := 'N';
1919: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1920: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1921: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1922: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1923: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1924: := p_time_building_blocks;

Line 1921: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;

1917: -- Bug 3012684
1918: l_error_flag VARCHAR2 (1) := 'N';
1919: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1920: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1921: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1922: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1923: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1924: := p_time_building_blocks;
1925: l_time_attributes hxc_self_service_time_deposit.app_attributes_info

Line 1922: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;

1918: l_error_flag VARCHAR2 (1) := 'N';
1919: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1920: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1921: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1922: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1923: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1924: := p_time_building_blocks;
1925: l_time_attributes hxc_self_service_time_deposit.app_attributes_info
1926: := p_time_attributes;