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_TIME_DETAIL dependencies on HXT_DET_HOURS_WORKED_F

Line 28: g_fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE;

24: g_hours NUMBER;
25: g_time_in DATE;
26: g_time_out DATE;
27: g_element_type_id NUMBER;
28: g_fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE;
29: --C421
30: g_ffv_cost_center_id NUMBER;
31: g_ffv_labor_account_id NUMBER;
32: g_tas_id NUMBER;

Line 40: g_fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE;

36: g_ffv_rate_code_id NUMBER;
37: g_rate_multiple NUMBER;
38: g_hourly_rate NUMBER;
39: g_amount NUMBER;
40: g_fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE;
41: --C421
42: g_separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE;
43: --C421
44: g_seqno NUMBER;

Line 65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;

61: --g_group_id NUMBER; -- HXT11i1
62: l_time_in DATE; -- SIR132
63: l_time_out DATE; -- SIR132
64: g_call_adjust_abs VARCHAR2 (1);
65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;
66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;
67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;
68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;
69:

Line 66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;

62: l_time_in DATE; -- SIR132
63: l_time_out DATE; -- SIR132
64: g_call_adjust_abs VARCHAR2 (1);
65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;
66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;
67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;
68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;
69:
70: CURSOR check_abs_elem

Line 67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;

63: l_time_out DATE; -- SIR132
64: g_call_adjust_abs VARCHAR2 (1);
65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;
66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;
67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;
68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;
69:
70: CURSOR check_abs_elem
71: IS

Line 68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;

64: g_call_adjust_abs VARCHAR2 (1);
65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;
66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;
67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;
68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;
69:
70: CURSOR check_abs_elem
71: IS
72: -- SELECT 'exist'

Line 99: -- or OVT row in the hxt_det_hours_worked_f table.

95: -- part of the cursor (sub select) looks for REG and OVT rows with higher
96: -- sequence numbers than the one passed in. This is an effort to sandwich
97: -- premiums between their related REG and OVT elements. Without this there is
98: -- no guarantee thata premium selected would be associated with any given REG
99: -- or OVT row in the hxt_det_hours_worked_f table.
100: CURSOR related_prem (
101: a_parent_id NUMBER,
102: a_tim_id NUMBER,
103: a_seqno NUMBER,

Line 169: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

165: AND eltv.effective_end_date;
166:
167: -- Function and Procedure declarations
168: FUNCTION contig_hours_worked (
169: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
170: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
171: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
172: )
173: RETURN hxt_det_hours_worked.hours%TYPE;

Line 171: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE

167: -- Function and Procedure declarations
168: FUNCTION contig_hours_worked (
169: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
170: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
171: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
172: )
173: RETURN hxt_det_hours_worked.hours%TYPE;
174:
175: PROCEDURE overtime_hoursoverride (

Line 176: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

172: )
173: RETURN hxt_det_hours_worked.hours%TYPE;
174:
175: PROCEDURE overtime_hoursoverride (
176: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
177: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
178: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
179: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
180: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE

Line 178: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,

174:
175: PROCEDURE overtime_hoursoverride (
176: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
177: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
178: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
179: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
180: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
181: );
182:

Line 179: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,

175: PROCEDURE overtime_hoursoverride (
176: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
177: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
178: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
179: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
180: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
181: );
182:
183: FUNCTION delete_zero_hour_details (

Line 180: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE

176: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
177: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
178: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
179: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
180: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
181: );
182:
183: FUNCTION delete_zero_hour_details (
184: a_tim_id NUMBER,

Line 196: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE

192: RETURN NUMBER;
193:
194: FUNCTION holiday_rule_found (
195: p_ep_id IN hxt_earning_policies.ID%TYPE,
196: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE
197: )
198: RETURN BOOLEAN
199: IS
200: l_holiday_rule_found BOOLEAN;

Line 991: UPDATE hxt_det_hours_worked_f

987: END IF;
988:
989: CLOSE overtime_cur;
990:
991: UPDATE hxt_det_hours_worked_f
992: SET hours = l_hours_to_adjust - l_delta
993: WHERE ROWID = l_rowid;
994:
995: OPEN daily_earn_rules_cur2 (g_ep_id);

Line 1607: UPDATE hxt_det_hours_worked_f

1603:
1604: --
1605: IF (l_ovt_hrs_cur.hours > l_hours_left)
1606: THEN
1607: UPDATE hxt_det_hours_worked_f
1608: SET hours = (hours - l_hours_left),
1609: time_out =
1610: time_in
1611: + ((l_ovt_hrs_cur.hours - l_hours_left) / 24)

Line 1614: UPDATE hxt_det_hours_worked_f

1610: time_in
1611: + ((l_ovt_hrs_cur.hours - l_hours_left) / 24)
1612: WHERE ROWID = l_ovt_hrs_cur.det_rowid;
1613: ELSE
1614: UPDATE hxt_det_hours_worked_f
1615: --SIR382 SET hours = (hours - l_hours_left),
1616: --SIR382 time_out = time_in + (l_hours_left/24)
1617: SET hours = 0,
1618: time_out = time_in

Line 1631: UPDATE hxt_det_hours_worked_f

1627: )
1628: LOOP
1629: IF (l_ovt_hrs_cur.hours > l_hours_left)
1630: THEN
1631: UPDATE hxt_det_hours_worked_f
1632: SET hours = (hours - l_hours_left),
1633: time_out =
1634: time_in
1635: + ((l_ovt_hrs_cur.hours - l_hours_left) / 24

Line 1639: UPDATE hxt_det_hours_worked_f

1635: + ((l_ovt_hrs_cur.hours - l_hours_left) / 24
1636: )
1637: WHERE ROWID = l_prem.prem_row_id;
1638: ELSE
1639: UPDATE hxt_det_hours_worked_f
1640: SET hours = 0,
1641: time_out = time_in
1642: WHERE ROWID = l_prem.prem_row_id;
1643: END IF;

Line 12071: hxt_det_hours_worked_f dhw

12067: eltv.hxt_premium_amount, eltv.hxt_earning_category,
12068: dhw.element_type_id
12069: FROM hxt_pay_element_types_f_ddf_v eltv,
12070: pay_element_types_f elt,
12071: hxt_det_hours_worked_f dhw
12072: WHERE dhw.tim_id = c_tim_id
12073: AND dhw.date_worked = c_date_worked
12074: AND elt.element_type_id = dhw.element_type_id
12075: AND dhw.date_worked BETWEEN elt.effective_start_date

Line 12086: FROM hxt_det_hours_worked_f hdw

12082: AND eltv.hxt_premium_type = 'FIXED'
12083: AND dhw.ID >
12084: (SELECT /*+ NO_UNNEST */
12085: MIN (hdw.ID)
12086: FROM hxt_det_hours_worked_f hdw
12087: WHERE hdw.tim_id = dhw.tim_id
12088: AND hdw.date_worked = c_date_worked
12089: AND hdw.element_type_id = dhw.element_type_id
12090: AND SYSDATE BETWEEN hdw.effective_start_date and hdw.effective_end_date)

Line 12705: FROM hxt_det_hours_worked_f

12701: IF a_hours_to_pay = 0 and (a_amount is null or a_amount = 0) /* Bug: 5744162 */
12702: THEN
12703: SELECT count(*)
12704: INTO l_det_count
12705: FROM hxt_det_hours_worked_f
12706: WHERE date_worked = a_date_worked
12707: AND assignment_id = a_assignment_id;
12708:
12709: IF l_det_count = 0 THEN

Line 13134: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

13130:
13131: --------------------------------------------------------------------------------
13132: --BEGIN HXT11i1
13133: FUNCTION contig_hours_worked (
13134: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
13135: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
13136: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
13137: )
13138: RETURN hxt_det_hours_worked.hours%TYPE

Line 13136: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE

13132: --BEGIN HXT11i1
13133: FUNCTION contig_hours_worked (
13134: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
13135: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
13136: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
13137: )
13138: RETURN hxt_det_hours_worked.hours%TYPE
13139: IS
13140: /* Local Variable Declaration */

Line 13145: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,

13141: l_worked_hours hxt_det_hours_worked.hours%TYPE := 0;
13142:
13143: /*Cursor Declaration */
13144: CURSOR csr_work_hrs (
13145: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
13146: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE
13147: )
13148: IS
13149: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category

Line 13146: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE

13142:
13143: /*Cursor Declaration */
13144: CURSOR csr_work_hrs (
13145: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
13146: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE
13147: )
13148: IS
13149: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category
13150: FROM hxt_det_hours_worked hrw,

Line 13229: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

13225: --
13226: -------------------------------------------------------------------------------
13227: --
13228: PROCEDURE overtime_hoursoverride (
13229: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
13230: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
13231: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
13232: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
13233: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE

Line 13231: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,

13227: --
13228: PROCEDURE overtime_hoursoverride (
13229: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
13230: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
13231: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
13232: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
13233: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
13234: )
13235: -- RETURN hxt_det_hours_worked.hours%TYPE

Line 13232: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,

13228: PROCEDURE overtime_hoursoverride (
13229: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
13230: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
13231: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
13232: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
13233: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
13234: )
13235: -- RETURN hxt_det_hours_worked.hours%TYPE
13236: IS

Line 13233: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE

13229: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
13230: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
13231: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
13232: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
13233: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
13234: )
13235: -- RETURN hxt_det_hours_worked.hours%TYPE
13236: IS
13237: /* Local Variable Declaration */

Line 13243: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,

13239: l_element_type_id hxt_det_hours_worked.element_type_id%TYPE;
13240:
13241: /*Cursor Declaration */
13242: CURSOR csr_override_hrs (
13243: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
13244: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE
13245: )
13246: IS
13247: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category

Line 13244: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE

13240:
13241: /*Cursor Declaration */
13242: CURSOR csr_override_hrs (
13243: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
13244: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE
13245: )
13246: IS
13247: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category
13248: FROM hxt_sum_hours_worked hrw,