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

Line 633: l_time_in hxt_det_hours_worked.time_in%TYPE; --C421

629: -- Purpose
630: -- Generate hours worked records FOR employees who have a work plan.
631: l_location VARCHAR2 (100);
632: l_days NUMBER;
633: l_time_in hxt_det_hours_worked.time_in%TYPE; --C421
634: l_time_out hxt_det_hours_worked.time_out%TYPE; --C421
635: l_standard_start NUMBER;
636: l_standard_stop NUMBER;
637: l_early_start NUMBER;

Line 634: l_time_out hxt_det_hours_worked.time_out%TYPE; --C421

630: -- Generate hours worked records FOR employees who have a work plan.
631: l_location VARCHAR2 (100);
632: l_days NUMBER;
633: l_time_in hxt_det_hours_worked.time_in%TYPE; --C421
634: l_time_out hxt_det_hours_worked.time_out%TYPE; --C421
635: l_standard_start NUMBER;
636: l_standard_stop NUMBER;
637: l_early_start NUMBER;
638: l_late_stop NUMBER;

Line 959: l_hrw_id hxt_det_hours_worked.id%TYPE;

955: IS
956: -- , a_group_id IN NUMBER) IS
957: -- PUBLIC procedure to create hour worked record - returns incremented seqno.
958: -- Calls HXT_TIME_SUMMARY.Generate_Details
959: l_hrw_id hxt_det_hours_worked.id%TYPE;
960: l_elt_id hxt_det_hours_worked.element_type_id%TYPE;
961: l_seqno hxt_det_hours_worked.seqno%TYPE; --C421
962: l_hours hxt_det_hours_worked.hours%TYPE DEFAULT NULL;
963: l_time_out hxt_det_hours_worked.time_out%TYPE := a_time_out;

Line 960: l_elt_id hxt_det_hours_worked.element_type_id%TYPE;

956: -- , a_group_id IN NUMBER) IS
957: -- PUBLIC procedure to create hour worked record - returns incremented seqno.
958: -- Calls HXT_TIME_SUMMARY.Generate_Details
959: l_hrw_id hxt_det_hours_worked.id%TYPE;
960: l_elt_id hxt_det_hours_worked.element_type_id%TYPE;
961: l_seqno hxt_det_hours_worked.seqno%TYPE; --C421
962: l_hours hxt_det_hours_worked.hours%TYPE DEFAULT NULL;
963: l_time_out hxt_det_hours_worked.time_out%TYPE := a_time_out;
964: l_hol_yn VARCHAR2 (1);

Line 961: l_seqno hxt_det_hours_worked.seqno%TYPE; --C421

957: -- PUBLIC procedure to create hour worked record - returns incremented seqno.
958: -- Calls HXT_TIME_SUMMARY.Generate_Details
959: l_hrw_id hxt_det_hours_worked.id%TYPE;
960: l_elt_id hxt_det_hours_worked.element_type_id%TYPE;
961: l_seqno hxt_det_hours_worked.seqno%TYPE; --C421
962: l_hours hxt_det_hours_worked.hours%TYPE DEFAULT NULL;
963: l_time_out hxt_det_hours_worked.time_out%TYPE := a_time_out;
964: l_hol_yn VARCHAR2 (1);
965: l_retcode NUMBER;

Line 962: l_hours hxt_det_hours_worked.hours%TYPE DEFAULT NULL;

958: -- Calls HXT_TIME_SUMMARY.Generate_Details
959: l_hrw_id hxt_det_hours_worked.id%TYPE;
960: l_elt_id hxt_det_hours_worked.element_type_id%TYPE;
961: l_seqno hxt_det_hours_worked.seqno%TYPE; --C421
962: l_hours hxt_det_hours_worked.hours%TYPE DEFAULT NULL;
963: l_time_out hxt_det_hours_worked.time_out%TYPE := a_time_out;
964: l_hol_yn VARCHAR2 (1);
965: l_retcode NUMBER;
966: l_seq_exceptn EXCEPTION;

Line 963: l_time_out hxt_det_hours_worked.time_out%TYPE := a_time_out;

959: l_hrw_id hxt_det_hours_worked.id%TYPE;
960: l_elt_id hxt_det_hours_worked.element_type_id%TYPE;
961: l_seqno hxt_det_hours_worked.seqno%TYPE; --C421
962: l_hours hxt_det_hours_worked.hours%TYPE DEFAULT NULL;
963: l_time_out hxt_det_hours_worked.time_out%TYPE := a_time_out;
964: l_hol_yn VARCHAR2 (1);
965: l_retcode NUMBER;
966: l_seq_exceptn EXCEPTION;
967: l_time_in hxt_det_hours_worked.time_in%TYPE := a_time_in;

Line 967: l_time_in hxt_det_hours_worked.time_in%TYPE := a_time_in;

963: l_time_out hxt_det_hours_worked.time_out%TYPE := a_time_out;
964: l_hol_yn VARCHAR2 (1);
965: l_retcode NUMBER;
966: l_seq_exceptn EXCEPTION;
967: l_time_in hxt_det_hours_worked.time_in%TYPE := a_time_in;
968: l_rowid ROWID;
969: v_count NUMBER;
970: -- l_group_id NUMBER;
971: BEGIN

Line 1399: DELETE FROM hxt_det_hours_worked_f

1395: -- Delete obsolete timecards
1396: g_sub_loc := 'DELETE from hxt_timecards';
1397: FOR l_record IN c_get_tim_id
1398: LOOP
1399: DELETE FROM hxt_det_hours_worked_f
1400: WHERE tim_id = l_record.id;
1401:
1402: DELETE FROM hxt_sum_hours_worked_f
1403: WHERE tim_id = l_record.id;

Line 1514: g_sub_loc := 'DELETE from hxt_det_hours_worked';

1510: BEGIN
1511: -- Delete existing hour-worked entries
1512: fnd_message.set_name ('HXT', 'HXT_39276_AG_ERR_DEL_HRS_WKED');
1513: g_autogen_error := '';
1514: g_sub_loc := 'DELETE from hxt_det_hours_worked';
1515:
1516: -- Bug 7359347
1517: -- Set session date.
1518: IF g_gen_session_date IS NULL

Line 1523: DELETE FROM hxt_det_hours_worked_f --C421

1519: THEN
1520: g_gen_session_date := hxt_tim_col_util.return_session_date;
1521: END IF;
1522:
1523: DELETE FROM hxt_det_hours_worked_f --C421
1524: WHERE tim_id = a_tim_id;
1525:
1526: --SIR012 DELETE from hxt_sum_hours_worked
1527: -- Bug 7359347