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_COLLECTION dependencies on HXT_SUM_HOURS_WORKED_F

Line 385: FUNCTION delete_summary_record (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)

381: END IF;
382: END;
383:
384: -- p_mode IN VARCHAR2 default 'INSERT');
385: FUNCTION delete_summary_record (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
386: RETURN NUMBER;
387:
388: /*-------------------------------------------------------------------------
389: ||

Line 499: l_ffv_cost_center_id hxt_sum_hours_worked.ffv_cost_center_id%TYPE

495: l_timecard_source_code hxt_timecards.auto_gen_flag%TYPE
496: DEFAULT NULL;
497: l_earn_pol_id hxt_sum_hours_worked.earn_pol_id%TYPE
498: DEFAULT NULL;
499: l_ffv_cost_center_id hxt_sum_hours_worked.ffv_cost_center_id%TYPE
500: DEFAULT NULL;
501: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
502: l_batch_status VARCHAR2 (30);
503: l_person_id_data_err EXCEPTION;

Line 3094: FROM hxt_sum_hours_worked_f

3090: actual_time_in, actual_time_out, prev_wage_code, project_id,
3091: earn_pol_id, time_building_block_id,
3092: time_building_block_ovn, state_name, county_name, city_name,
3093: zip_code
3094: FROM hxt_sum_hours_worked_f
3095: WHERE tim_id = c_tim_id
3096: AND c_tim_end_date BETWEEN effective_start_date
3097: AND effective_end_date
3098: ORDER BY date_worked, element_type_id, time_in, seqno, ID;

Line 4609: FROM hxt_sum_hours_worked_f

4605: IS
4606: SELECT fcl_earn_reason_code, ffv_cost_center_id, rate_multiple,
4607: hourly_rate, separate_check_flag, seqno, creation_date
4608: -- group_id
4609: FROM hxt_sum_hours_worked_f
4610: WHERE ID = p_id
4611: AND g_sysdate BETWEEN effective_start_date AND effective_end_date;
4612:
4613: -- Begin AM 007a

Line 4617: FROM hxt_sum_hours_worked_f

4613: -- Begin AM 007a
4614: CURSOR allow_summary_correction (c_sum_id NUMBER)
4615: IS
4616: SELECT 'Y'
4617: FROM hxt_sum_hours_worked_f
4618: WHERE ID = c_sum_id AND effective_start_date = TRUNC (g_sess_date);
4619:
4620:
4621: -- END AM 007a

Line 5001: INSERT INTO hxt_sum_hours_worked_f

4997: -- INTO l_group_id
4998: -- FROM dual;
4999: --
5000: /*
5001: INSERT INTO hxt_sum_hours_worked_f
5002: ( id,
5003: tim_id,
5004: date_worked,
5005: seqno,

Line 5161: /* UPDATE hxt_sum_hours_worked_f

5157: THEN
5158: hr_utility.set_location (l_proc, 210);
5159: END IF;
5160:
5161: /* UPDATE hxt_sum_hours_worked_f
5162: SET effective_start_date = i_tim_sum_eff_start_date,
5163: effective_end_date = i_tim_sum_eff_end_date,
5164: date_worked = i_date_worked,
5165: assignment_id = i_assignment_id,

Line 5211: FROM hxt_sum_hours_worked_f

5207: job_id, object_version_number
5208: INTO l_rowid, l_time_id, l_sequence_number, l_created_by,
5209: l_creation_date, l_actual_time_in, l_actual_time_out,
5210: l_job_id, l_object_version_number
5211: FROM hxt_sum_hours_worked_f
5212: WHERE ID = i_time_summary_id
5213: AND g_sess_date BETWEEN effective_start_date
5214: AND effective_end_date ;
5215:

Line 5284: FROM hxt_sum_hours_worked_f

5280: */
5281:
5282: SELECT ROWID
5283: INTO v_row_id
5284: FROM hxt_sum_hours_worked_f
5285: WHERE ID = i_time_summary_id
5286: AND g_sess_date BETWEEN effective_start_date
5287: AND effective_end_date ;
5288:

Line 5292: INSERT INTO hxt_sum_hours_worked_f

5288:
5289:
5290: --
5291: /*
5292: INSERT INTO hxt_sum_hours_worked_f
5293: ( id,
5294: tim_id,
5295: date_worked,
5296: seqno,

Line 5355: FROM HXT_SUM_HOURS_WORKED_F TSM

5351: i_hourly_rate, -- SIR290 tsm.hourly_rate,
5352: i_amount, -- SIR290 tsm.amount,
5353: trunc(g_sess_date),
5354: hr_general.end_of_time
5355: FROM HXT_SUM_HOURS_WORKED_F TSM
5356: WHERE ROWID = v_row_id;
5357: */
5358: SELECT tsm.ID, tsm.tim_id, tsm.seqno
5359: INTO l_hours_worked_id, l_time_id, l_sequence_number

Line 5360: FROM hxt_sum_hours_worked_f tsm

5356: WHERE ROWID = v_row_id;
5357: */
5358: SELECT tsm.ID, tsm.tim_id, tsm.seqno
5359: INTO l_hours_worked_id, l_time_id, l_sequence_number
5360: FROM hxt_sum_hours_worked_f tsm
5361: WHERE ROWID = v_row_id;
5362:
5363: IF g_debug
5364: THEN

Line 5420: UPDATE hxt_sum_hours_worked_f

5416: hr_utility.set_location (l_proc, 250);
5417: END IF;
5418:
5419: --
5420: UPDATE hxt_sum_hours_worked_f
5421: SET effective_end_date = TRUNC (g_sess_date - 1)
5422: WHERE ROWID = v_row_id;
5423:
5424: --

Line 6128: Deletes hxt_sum_hours_worked_f row indicated by i_tim_sum_id.

6124: END cost_allocation_entry;
6125:
6126: /**************************************************************
6127: delete_summary_record()
6128: Deletes hxt_sum_hours_worked_f row indicated by i_tim_sum_id.
6129: ***************************************************************/
6130: FUNCTION delete_summary_record (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
6131: RETURN NUMBER
6132: IS

Line 6130: FUNCTION delete_summary_record (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)

6126: /**************************************************************
6127: delete_summary_record()
6128: Deletes hxt_sum_hours_worked_f row indicated by i_tim_sum_id.
6129: ***************************************************************/
6130: FUNCTION delete_summary_record (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
6131: RETURN NUMBER
6132: IS
6133: l_proc VARCHAR2 (72);
6134: c_success CONSTANT NUMBER := 0;

Line 6144: FUNCTION tim_id (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)

6140: l_dt_update_mode VARCHAR2 (20);
6141: l_return_code NUMBER;
6142: l_error_message VARCHAR2 (300);
6143:
6144: FUNCTION tim_id (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
6145: RETURN hxt_sum_hours_worked_f.tim_id%TYPE
6146: AS
6147: l_proc VARCHAR2 (72);
6148:

Line 6145: RETURN hxt_sum_hours_worked_f.tim_id%TYPE

6141: l_return_code NUMBER;
6142: l_error_message VARCHAR2 (300);
6143:
6144: FUNCTION tim_id (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
6145: RETURN hxt_sum_hours_worked_f.tim_id%TYPE
6146: AS
6147: l_proc VARCHAR2 (72);
6148:
6149: -- Bug 7359347

Line 6152: CURSOR csr_tim_id (p_sum_id hxt_sum_hours_worked_f.ID%TYPE,

6148:
6149: -- Bug 7359347
6150: -- Added a new date parameter to the existing cursor
6151: -- so that the view is replaced with the base table.
6152: CURSOR csr_tim_id (p_sum_id hxt_sum_hours_worked_f.ID%TYPE,
6153: p_date DATE)
6154: IS
6155: SELECT tim_id
6156: FROM hxt_sum_hours_worked_f

Line 6156: FROM hxt_sum_hours_worked_f

6152: CURSOR csr_tim_id (p_sum_id hxt_sum_hours_worked_f.ID%TYPE,
6153: p_date DATE)
6154: IS
6155: SELECT tim_id
6156: FROM hxt_sum_hours_worked_f
6157: WHERE ID = p_sum_id
6158: AND g_sess_date BETWEEN effective_start_date
6159: AND effective_end_date;
6160:

Line 6190: PROCEDURE remove_tc_details (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)

6186:
6187: RETURN l_tim_id.tim_id;
6188: END tim_id;
6189:
6190: PROCEDURE remove_tc_details (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
6191: AS
6192: l_proc VARCHAR2 (72);
6193: BEGIN
6194: IF g_debug

Line 6203: DELETE FROM hxt_sum_hours_worked_f

6199:
6200: DELETE FROM hxt_det_hours_worked_f
6201: WHERE parent_id = p_sum_id;
6202:
6203: DELETE FROM hxt_sum_hours_worked_f
6204: WHERE ID = p_sum_id;
6205:
6206: IF g_debug
6207: THEN

Line 7240: FROM hxt_sum_hours_worked_f --C421

7236: */
7237: CURSOR c(session_date DATE)
7238: IS
7239: SELECT 'E'
7240: FROM hxt_sum_hours_worked_f --C421
7241: WHERE (p_time_in < time_out AND p_time_out > time_in)
7242: --C421 AND parent_id = 0
7243: AND date_worked = p_date
7244: AND session_date BETWEEN effective_start_date