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_UTIL dependencies on HXT_DET_HOURS_WORKED

Line 738: hxt_det_hours_worked_f hdh,

734: --
735: cursor csr_retro_end IS
736: select ptp.end_date
737: from per_time_periods ptp,
738: hxt_det_hours_worked_f hdh,
739: hxt_timecards_f htf
740: where hdh.retro_batch_id = p_batch_id
741: and hdh.tim_id = htf.id
742: and htf.time_period_id = ptp.time_period_id;

Line 929: from hxt_det_hours_worked det,

925:
926: /*
927: cursor existing_batch is
928: select retro_batch_id, assignment_id
929: from hxt_det_hours_worked det,
930: hxt_batch_states tbs
931: where det.tim_id = p_tim_id
932: and tbs.batch_id=det.retro_batch_id
933: and tbs.status in ('H','VE')

Line 939: from hxt_det_hours_worked det,

935: */
936:
937: cursor existing_batch is
938: select retro_batch_id, assignment_id, pbh.batch_reference
939: from hxt_det_hours_worked det,
940: hxt_batch_states tbs,
941: pay_batch_headers pbh
942: where det.tim_id = p_tim_id
943: and tbs.batch_id = det.retro_batch_id

Line 1849: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f

1845:
1846: cursor get_max_retro_batch is
1847: select max(batch_id) from pay_batch_headers pbh
1848: where pbh.batch_status='T'
1849: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
1850: where tim_id=p_tim_id);
1851:
1852:
1853: cursor chk_retro_batch_status is

Line 1856: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f

1852:
1853: cursor chk_retro_batch_status is
1854: select batch_id from pay_batch_headers pbh
1855: where pbh.batch_status='T'
1856: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
1857: where tim_id=p_tim_id);
1858:
1859:
1860: cursor chk_original_batch_status is

Line 1872: FROM hxt_det_hours_worked_f det,

1868: p_accrual_plan_id NUMBER,
1869: p_bus_group_id NUMBER,
1870: p_batch_id number) is
1871: SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
1872: FROM hxt_det_hours_worked_f det,
1873: pay_net_calculation_rules_v ncr
1874: WHERE det.tim_id = p_tim_id
1875: AND det.assignment_id = p_assignment_id
1876: AND ncr.business_group_id = p_bus_group_id

Line 1886: FROM hxt_det_hours_worked_f det,

1882: p_assignment_id NUMBER,
1883: p_accrual_plan_id NUMBER,
1884: p_bus_group_id NUMBER) is
1885: SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
1886: FROM hxt_det_hours_worked_f det,
1887: pay_net_calculation_rules_v ncr
1888: WHERE det.tim_id = p_tim_id
1889: AND det.assignment_id = p_assignment_id
1890: AND ncr.business_group_id = p_bus_group_id

Line 2344: FROM hxt_det_hours_worked_f hdhw

2340: FROM hxt_timecards_f HTF
2341: WHERE HTF.batch_id = pbh.batch_id)
2342: UNION
2343: (SELECT hdhw.retro_batch_id
2344: FROM hxt_det_hours_worked_f hdhw
2345: WHERE hdhw.retro_batch_id = pbh.batch_id));
2346: l_dummy VARCHAR2 (1);
2347: BEGIN
2348: g_debug :=hr_utility.debug_enabled;

Line 2404: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,

2400:
2401: -- Commented for the Bug 5651731
2402: /*
2403: FUNCTION is_valid_time_entry (
2404: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2405: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2406: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
2407: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
2408: )

Line 2405: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,

2401: -- Commented for the Bug 5651731
2402: /*
2403: FUNCTION is_valid_time_entry (
2404: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2405: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2406: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
2407: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
2408: )
2409: RETURN BOOLEAN AS

Line 2406: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,

2402: /*
2403: FUNCTION is_valid_time_entry (
2404: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2405: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2406: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
2407: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
2408: )
2409: RETURN BOOLEAN AS
2410:

Line 2407: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE

2403: FUNCTION is_valid_time_entry (
2404: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2405: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2406: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
2407: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
2408: )
2409: RETURN BOOLEAN AS
2410:
2411: l_proc VARCHAR2 (30) ;

Line 2463: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_in,

2459: */
2460:
2461: -- Added the foll for bug 5651731
2462: FUNCTION is_valid_time_entry (
2463: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_in,
2464: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.time_in
2465: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_out,
2466: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE -- :hrw.time_in
2467: )

Line 2464: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.time_in

2460:
2461: -- Added the foll for bug 5651731
2462: FUNCTION is_valid_time_entry (
2463: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_in,
2464: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.time_in
2465: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_out,
2466: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE -- :hrw.time_in
2467: )
2468: RETURN BOOLEAN AS

Line 2465: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_out,

2461: -- Added the foll for bug 5651731
2462: FUNCTION is_valid_time_entry (
2463: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_in,
2464: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.time_in
2465: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_out,
2466: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE -- :hrw.time_in
2467: )
2468: RETURN BOOLEAN AS
2469:

Line 2466: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE -- :hrw.time_in

2462: FUNCTION is_valid_time_entry (
2463: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_in,
2464: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.time_in
2465: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE, -- :hrw.actual_time_out,
2466: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE -- :hrw.time_in
2467: )
2468: RETURN BOOLEAN AS
2469:
2470: l_proc VARCHAR2 (30) ;