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

Line 43: FROM hxt_det_hours_worked

39:
40:
41: CURSOR retro_pay_trans IS
42: SELECT 'R', retro_batch_id
43: FROM hxt_det_hours_worked
44: WHERE tim_id = p_tim_id
45: AND pay_status = 'R';
46:
47: CURSOR complete_pay_trans IS

Line 49: FROM hxt_det_hours_worked_f

45: AND pay_status = 'R';
46:
47: CURSOR complete_pay_trans IS
48: SELECT 'R'
49: FROM hxt_det_hours_worked_f
50: WHERE tim_id = p_tim_id
51: AND pay_status = 'C';
52:
53: CURSOR retro_pa_trans IS

Line 55: FROM hxt_det_hours_worked_f

51: AND pay_status = 'C';
52:
53: CURSOR retro_pa_trans IS
54: SELECT 'R'
55: FROM hxt_det_hours_worked_f
56: WHERE tim_id = p_tim_id
57: AND pa_status = 'R';
58:
59: CURSOR complete_pa_trans IS

Line 61: FROM hxt_det_hours_worked_f

57: AND pa_status = 'R';
58:
59: CURSOR complete_pa_trans IS
60: SELECT 'R'
61: FROM hxt_det_hours_worked_f
62: WHERE tim_id = p_tim_id
63: AND pa_status = 'C';
64:
65: CURSOR check_for_details IS

Line 73: FROM hxt_det_hours_worked_f det

69: WHERE tim.id = p_tim_id
70: AND tbs.batch_id = tim.batch_id
71: AND tbs.status = 'VT'
72: AND NOT EXISTS (SELECT '1'
73: FROM hxt_det_hours_worked_f det
74: WHERE det.tim_id = tim.id
75: AND NVL(det.hours,0) > 0);
76:
77:

Line 347: -- which need to be inserted into hxt_det_hours_worked table.

343: -- Modifications
344: -- 2/15/96 Changed line_status field write to always be null as children
345: -- hours worked records do not need their parents' status. AVS
346: -- 4/23/97 Added the get_ovt_rates_cur to fetch premium types and amounts
347: -- which need to be inserted into hxt_det_hours_worked table.
348: -- Fixed under Oracle Bugs #465434 & #464850.
349: -- 1/07/98 SIR69 Cursor get_ovt_rates_cur now handles all premiums and
350: -- not just overtime. Was ignoring earn types of OTH etc.
351: -- 1/22/98 SIR092 Hours are not written to premium types of FIXED.

Line 353: v_amount hxt_det_hours_worked.amount%type := null; --SIR029

349: -- 1/07/98 SIR69 Cursor get_ovt_rates_cur now handles all premiums and
350: -- not just overtime. Was ignoring earn types of OTH etc.
351: -- 1/22/98 SIR092 Hours are not written to premium types of FIXED.
352: --
353: v_amount hxt_det_hours_worked.amount%type := null; --SIR029
354: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
355: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
356:
357: CURSOR next_id_cur IS

Line 355: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;

351: -- 1/22/98 SIR092 Hours are not written to premium types of FIXED.
352: --
353: v_amount hxt_det_hours_worked.amount%type := null; --SIR029
354: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
355: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
356:
357: CURSOR next_id_cur IS
358: SELECT hxt_seqno.nextval next_id
359: FROM dual;

Line 392: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092

388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
389: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
390: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
391:
392: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
393: -- *********************************
394: -- ORACLE END Bugs #465434 & #464850
395: -- *********************************
396:

Line 545: /* INSERT INTO hxt_det_hours_worked_f(id,

541: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);
542: end if;
543: END IF;
544:
545: /* INSERT INTO hxt_det_hours_worked_f(id,
546: parent_id,
547: tim_id,
548: date_worked,
549: assignment_id,

Line 617: /* Call dml to insert hours into hxt_det_hours_worked_f */

613: --g_group_id
614: ); */
615:
616:
617: /* Call dml to insert hours into hxt_det_hours_worked_f */
618: if g_debug then
619: hr_utility.set_location('hxt_time_pay.INSERT_HRS',140);
620: end if;
621:

Line 622: hxt_dml.insert_HXT_DET_HOURS_WORKED(

618: if g_debug then
619: hr_utility.set_location('hxt_time_pay.INSERT_HRS',140);
620: end if;
621:
622: hxt_dml.insert_HXT_DET_HOURS_WORKED(
623: p_rowid => l_rowid,
624: p_id => p_id,
625: p_parent_id => g_id,
626: p_tim_id => g_tim_id,

Line 774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092

770: -- Premium override multiple
771: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
772: -- Premium override rate ORA131
773:
774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;
776: l_time_out hxt_det_hours_worked_f.time_out%TYPE ;
777: l_seqno NUMBER; -- Line seqno
778: l_error_code NUMBER DEFAULT 0; -- Default to no error

Line 775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;

771: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
772: -- Premium override rate ORA131
773:
774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;
776: l_time_out hxt_det_hours_worked_f.time_out%TYPE ;
777: l_seqno NUMBER; -- Line seqno
778: l_error_code NUMBER DEFAULT 0; -- Default to no error
779: l_location VARCHAR2(120); -- Current Path for locating source

Line 776: l_time_out hxt_det_hours_worked_f.time_out%TYPE ;

772: -- Premium override rate ORA131
773:
774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;
776: l_time_out hxt_det_hours_worked_f.time_out%TYPE ;
777: l_seqno NUMBER; -- Line seqno
778: l_error_code NUMBER DEFAULT 0; -- Default to no error
779: l_location VARCHAR2(120); -- Current Path for locating source
780: -- of errors

Line 787: l_ffv_cost_center_id hxt_det_hours_worked_f.ffv_cost_center_id%TYPE;

783: l_min_detail_seqno NUMBER;
784: l_max_detail_seqno NUMBER;
785:
786: l_costable_type pay_element_links_f.costable_type%TYPE;
787: l_ffv_cost_center_id hxt_det_hours_worked_f.ffv_cost_center_id%TYPE;
788:
789: l_rowid ROWID;
790: l_object_version_number NUMBER DEFAULT NULL;
791: l_id NUMBER;

Line 900: FROM hxt_det_hours_worked

896: -- Get the minimum sequence number of the current detail row
897: --
898: CURSOR get_min_detail_seqno IS
899: SELECT seqno
900: FROM hxt_det_hours_worked
901: WHERE id = p_BASE_ID;
902: --
903: -- Get the maximum sequence number of the current detail row
904: --

Line 909: ,hxt_det_hours_worked hrw

905: CURSOR get_max_detail_seqno IS
906: SELECT nvl(min(hrw.seqno),9999)
907: FROM hxt_pay_element_types_f_ddf_v eltv
908: ,pay_element_types_f elt
909: ,hxt_det_hours_worked hrw
910: WHERE hrw.tim_id = g_TIM_ID
911: AND hrw.date_worked = g_DATE_WORKED
912: AND hrw.parent_id = g_ID
913: AND hrw.seqno > l_min_detail_seqno

Line 950: hxt_det_hours_worked hrw -- C421

946: FROM hxt_pay_element_types_f_ddf_v eltv,
947: pay_element_types_f elt,
948: pay_element_types_f_tl eltt,
949: hxt_prem_interact_rules pir,
950: hxt_det_hours_worked hrw -- C421
951: WHERE hrw.tim_id = g_TIM_ID
952: AND hrw.date_worked = g_DATE_WORKED
953: AND hrw.parent_id = g_ID -- same parent as base record
954: AND pir.elt_prior_prem_id = hrw.element_type_id

Line 1146: -- logic gets called to insert the data into hxt_det_hours_worked

1142:
1143: -- i.e.,IF the shift differential override is applicable to the time_in and
1144: -- time_outs ,then p_sdf_id has been set to g_sdovr_id n hxt_time_summary.
1145: -- gen_details ,so that the cursor cur_elig_prem returns a row and the
1146: -- logic gets called to insert the data into hxt_det_hours_worked
1147:
1148: if g_debug then
1149: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.3);
1150: end if;

Line 1449: UPDATE hxt_det_hours_worked_f hrw

1445:
1446: if g_debug then
1447: hr_utility.set_location('hxt_time_pay.Gen_Premiums',340);
1448: end if;
1449: UPDATE hxt_det_hours_worked_f hrw
1450: SET rate_multiple = l_mult
1451: WHERE hrw.rowid = hrw_rowid;
1452: EXCEPTION
1453: WHEN OTHERS THEN

Line 1482: UPDATE hxt_det_hours_worked_f hrw

1478:
1479: if g_debug then
1480: hr_utility.set_location('hxt_time_pay.Gen_Premiums',380);
1481: end if;
1482: UPDATE hxt_det_hours_worked_f hrw
1483: SET hourly_rate = l_rate
1484: WHERE hrw.rowid = hrw_rowid;
1485: EXCEPTION
1486: WHEN OTHERS THEN

Line 1558: /* INSERT into hxt_det_hours_worked_f

1554: hr_utility.set_location('hxt_time_pay.Gen_Premiums',450);
1555: end if;
1556:
1557:
1558: /* INSERT into hxt_det_hours_worked_f
1559: (ID,PARENT_ID,TIM_ID,
1560: DATE_WORKED,ASSIGNMENT_ID,
1561: HOURS,TIME_IN,TIME_OUT,
1562: ELEMENT_TYPE_ID,FCL_EARN_REASON_CODE,

Line 1635: hxt_dml.insert_HXT_DET_HOURS_WORKED(

1631: hr_utility.trace('l_hourly_rate :'||l_hourly_rate);
1632: hr_utility.trace('l_amount :'||l_amount);
1633: hr_utility.set_location('hxt_time_pay.Gen_Premiums',460);
1634: end if;
1635: hxt_dml.insert_HXT_DET_HOURS_WORKED(
1636: p_rowid => l_rowid,
1637: p_id => l_id,
1638: p_parent_id => g_id,
1639: p_tim_id => g_tim_id,

Line 1757: FROM hxt_det_hours_worked --C421

1753: -- Calls insert hours and gen premiums with times, hours, etc
1754:
1755: CURSOR next_seq_cur IS
1756: SELECT nvl(max(seqno),0) next_seq
1757: FROM hxt_det_hours_worked --C421
1758: WHERE parent_id = g_id
1759: AND tim_id = g_tim_id
1760: AND date_worked = g_date_worked;
1761: