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 382: FUNCTION delete_summary_record (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)

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

Line 496: l_ffv_cost_center_id hxt_sum_hours_worked.ffv_cost_center_id%TYPE

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

Line 4778: INSERT INTO hxt_sum_hours_worked_f

4774: -- INTO l_group_id
4775: -- FROM dual;
4776: --
4777: /*
4778: INSERT INTO hxt_sum_hours_worked_f
4779: ( id,
4780: tim_id,
4781: date_worked,
4782: seqno,

Line 4938: /* UPDATE hxt_sum_hours_worked_f

4934: THEN
4935: hr_utility.set_location (l_proc, 210);
4936: END IF;
4937:
4938: /* UPDATE hxt_sum_hours_worked_f
4939: SET effective_start_date = i_tim_sum_eff_start_date,
4940: effective_end_date = i_tim_sum_eff_end_date,
4941: date_worked = i_date_worked,
4942: assignment_id = i_assignment_id,

Line 5039: INSERT INTO hxt_sum_hours_worked_f

5035: WHERE ID = i_time_summary_id;
5036:
5037: --
5038: /*
5039: INSERT INTO hxt_sum_hours_worked_f
5040: ( id,
5041: tim_id,
5042: date_worked,
5043: seqno,

Line 5102: FROM HXT_SUM_HOURS_WORKED_F TSM

5098: i_hourly_rate, -- SIR290 tsm.hourly_rate,
5099: i_amount, -- SIR290 tsm.amount,
5100: trunc(g_sess_date),
5101: hr_general.end_of_time
5102: FROM HXT_SUM_HOURS_WORKED_F TSM
5103: WHERE ROWID = v_row_id;
5104: */
5105: SELECT tsm.ID, tsm.tim_id, tsm.seqno
5106: INTO l_hours_worked_id, l_time_id, l_sequence_number

Line 5107: FROM hxt_sum_hours_worked_f tsm

5103: WHERE ROWID = v_row_id;
5104: */
5105: SELECT tsm.ID, tsm.tim_id, tsm.seqno
5106: INTO l_hours_worked_id, l_time_id, l_sequence_number
5107: FROM hxt_sum_hours_worked_f tsm
5108: WHERE ROWID = v_row_id;
5109:
5110: IF g_debug
5111: THEN

Line 5167: UPDATE hxt_sum_hours_worked_f

5163: hr_utility.set_location (l_proc, 250);
5164: END IF;
5165:
5166: --
5167: UPDATE hxt_sum_hours_worked_f
5168: SET effective_end_date = TRUNC (g_sess_date - 1)
5169: WHERE ROWID = v_row_id;
5170:
5171: --

Line 5813: Deletes hxt_sum_hours_worked_f row indicated by i_tim_sum_id.

5809: END cost_allocation_entry;
5810:
5811: /**************************************************************
5812: delete_summary_record()
5813: Deletes hxt_sum_hours_worked_f row indicated by i_tim_sum_id.
5814: ***************************************************************/
5815: FUNCTION delete_summary_record (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
5816: RETURN NUMBER
5817: IS

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

5811: /**************************************************************
5812: delete_summary_record()
5813: Deletes hxt_sum_hours_worked_f row indicated by i_tim_sum_id.
5814: ***************************************************************/
5815: FUNCTION delete_summary_record (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
5816: RETURN NUMBER
5817: IS
5818: l_proc VARCHAR2 (72);
5819: c_success CONSTANT NUMBER := 0;

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

5823: l_dt_update_mode VARCHAR2 (20);
5824: l_return_code NUMBER;
5825: l_error_message VARCHAR2 (300);
5826:
5827: FUNCTION tim_id (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
5828: RETURN hxt_sum_hours_worked_f.tim_id%TYPE
5829: AS
5830: l_proc VARCHAR2 (72);
5831:

Line 5828: RETURN hxt_sum_hours_worked_f.tim_id%TYPE

5824: l_return_code NUMBER;
5825: l_error_message VARCHAR2 (300);
5826:
5827: FUNCTION tim_id (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
5828: RETURN hxt_sum_hours_worked_f.tim_id%TYPE
5829: AS
5830: l_proc VARCHAR2 (72);
5831:
5832: CURSOR csr_tim_id (p_sum_id hxt_sum_hours_worked_f.ID%TYPE)

Line 5832: CURSOR csr_tim_id (p_sum_id hxt_sum_hours_worked_f.ID%TYPE)

5828: RETURN hxt_sum_hours_worked_f.tim_id%TYPE
5829: AS
5830: l_proc VARCHAR2 (72);
5831:
5832: CURSOR csr_tim_id (p_sum_id hxt_sum_hours_worked_f.ID%TYPE)
5833: IS
5834: SELECT tim_id
5835: FROM hxt_sum_hours_worked
5836: WHERE ID = p_sum_id;

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

5861:
5862: RETURN l_tim_id.tim_id;
5863: END tim_id;
5864:
5865: PROCEDURE remove_tc_details (p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE)
5866: AS
5867: l_proc VARCHAR2 (72);
5868: BEGIN
5869: IF g_debug

Line 5878: DELETE FROM hxt_sum_hours_worked_f

5874:
5875: DELETE FROM hxt_det_hours_worked_f
5876: WHERE parent_id = p_sum_id;
5877:
5878: DELETE FROM hxt_sum_hours_worked_f
5879: WHERE ID = p_sum_id;
5880:
5881: IF g_debug
5882: THEN