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.

[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on HXT_SUM_HOURS_WORKED

Line 167: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,

163: i_timecard_id IN NUMBER,
164: i_wage_code IN VARCHAR2,
165: i_task_id IN NUMBER,
166: i_location_id IN NUMBER,
167: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
168: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
169: i_earn_reason_code IN VARCHAR2,
170: i_comment IN VARCHAR2,
171: i_rate_multiple IN NUMBER,

Line 168: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,

164: i_wage_code IN VARCHAR2,
165: i_task_id IN NUMBER,
166: i_location_id IN NUMBER,
167: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
168: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
169: i_earn_reason_code IN VARCHAR2,
170: i_comment IN VARCHAR2,
171: i_rate_multiple IN NUMBER,
172: i_hourly_rate IN NUMBER,

Line 219: p_egp_id OUT NOCOPY hxt_sum_hours_worked.earn_pol_id%TYPE -- 5903580 NUMBER earning policy

215: -- ,p_retcode OUT NOCOPY NUMBER
216: -- ,p_hours OUT NOCOPY NUMBER
217: ,
218: p_shift_hours OUT NOCOPY NUMBER,
219: p_egp_id OUT NOCOPY hxt_sum_hours_worked.earn_pol_id%TYPE -- 5903580 NUMBER earning policy
220: ,
221: p_hdp_id OUT NOCOPY NUMBER -- hrs deduction policy
222: -- ,p_hdy_id OUT NOCOPY NUMBER -- holiday day ID
223: ,

Line 272: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,

268: i_start_date IN DATE,
269: i_wage_code VARCHAR2,
270: i_task_id IN NUMBER,
271: i_location_id IN NUMBER,
272: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
273: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
274: i_earn_reason_code IN VARCHAR2,
275: i_cost_center_id IN NUMBER,
276: i_comment IN VARCHAR2,

Line 273: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,

269: i_wage_code VARCHAR2,
270: i_task_id IN NUMBER,
271: i_location_id IN NUMBER,
272: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
273: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
274: i_earn_reason_code IN VARCHAR2,
275: i_cost_center_id IN NUMBER,
276: i_comment IN VARCHAR2,
277: i_rate_multiple IN NUMBER,

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 479: l_project_id hxt_sum_hours_worked.project_id%TYPE

475: l_element_type_id pay_element_types_f.element_type_id%TYPE
476: DEFAULT NULL;
477: l_task_id hxt_tasks_v.task_id%TYPE DEFAULT NULL;
478: l_location_id hr_locations.location_id%TYPE DEFAULT NULL;
479: l_project_id hxt_sum_hours_worked.project_id%TYPE
480: DEFAULT NULL;
481: l_time_period_id per_time_periods.time_period_id%TYPE
482: DEFAULT NULL;
483: l_start_date DATE DEFAULT NULL;

Line 488: l_hours hxt_sum_hours_worked.hours%TYPE

484: l_end_date DATE DEFAULT NULL;
485: l_auto_gen_flag hxt_timecards.auto_gen_flag%TYPE
486: DEFAULT NULL;
487: l_timecard_exists BOOLEAN DEFAULT TRUE;
488: l_hours hxt_sum_hours_worked.hours%TYPE
489: DEFAULT NULL;
490: l_sep_chk_flg hxt_sum_hours_worked.separate_check_flag%TYPE
491: DEFAULT NULL;
492: l_timecard_source_code hxt_timecards.auto_gen_flag%TYPE

Line 490: l_sep_chk_flg hxt_sum_hours_worked.separate_check_flag%TYPE

486: DEFAULT NULL;
487: l_timecard_exists BOOLEAN DEFAULT TRUE;
488: l_hours hxt_sum_hours_worked.hours%TYPE
489: DEFAULT NULL;
490: l_sep_chk_flg hxt_sum_hours_worked.separate_check_flag%TYPE
491: DEFAULT NULL;
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

Line 494: l_earn_pol_id hxt_sum_hours_worked.earn_pol_id%TYPE

490: l_sep_chk_flg hxt_sum_hours_worked.separate_check_flag%TYPE
491: DEFAULT NULL;
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;

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 498: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE 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;
501: l_person_id_sys_err EXCEPTION;
502: l_appr_id_data_err EXCEPTION;

Line 1864: -- Insert hours to the hxt_sum_hours_worked table and

1860: -- i.e., If it is not a deleted record then create it.
1861: -- If it is a deleted record then we should skip this call to
1862: -- record_hours_worked
1863:
1864: -- Insert hours to the hxt_sum_hours_worked table and
1865: -- call generate details
1866: IF g_debug
1867: THEN
1868: hr_utility.TRACE ('BEFORE record_hours worked');

Line 2920: Fetch all hxt_sum_hours_worked records for the timecard

2916: END;
2917:
2918: /**********************************************************
2919: re_explode_timecard()
2920: Fetch all hxt_sum_hours_worked records for the timecard
2921: indicated. Call record_time for each record to re-explode.
2922: ***********************************************************/
2923: PROCEDURE re_explode_timecard (
2924: timecard_id IN NUMBER,

Line 2966: FROM hxt_sum_hours_worked

2962: actual_time_in, actual_time_out, prev_wage_code, project_id,
2963: earn_pol_id, time_building_block_id,
2964: time_building_block_ovn, state_name, county_name, city_name,
2965: zip_code
2966: FROM hxt_sum_hours_worked
2967: WHERE tim_id = c_tim_id
2968: ORDER BY date_worked, element_type_id, time_in, seqno, ID;
2969:
2970: l_retcode NUMBER;

Line 2975: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;

2971: l_batch_status VARCHAR2 (30);
2972: l_timecard_rec get_timecard_rec%ROWTYPE;
2973: l_otm_error VARCHAR2 (120) DEFAULT NULL;
2974: l_oracle_error VARCHAR2 (512) DEFAULT NULL;
2975: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
2976: l_tim_not_found_err EXCEPTION;
2977: l_rec_hours_data_err EXCEPTION;
2978: l_rec_hours_sys_err EXCEPTION;
2979: l_delete_details_err EXCEPTION;

Line 3760: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,

3756: i_timecard_id IN NUMBER,
3757: i_wage_code IN VARCHAR2,
3758: i_task_id IN NUMBER,
3759: i_location_id IN NUMBER,
3760: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
3761: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
3762: i_earn_reason_code IN VARCHAR2,
3763: i_comment IN VARCHAR2,
3764: i_rate_multiple IN NUMBER,

Line 3761: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,

3757: i_wage_code IN VARCHAR2,
3758: i_task_id IN NUMBER,
3759: i_location_id IN NUMBER,
3760: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
3761: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
3762: i_earn_reason_code IN VARCHAR2,
3763: i_comment IN VARCHAR2,
3764: i_rate_multiple IN NUMBER,
3765: i_hourly_rate IN NUMBER,

Line 3798: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;

3794: l_hol_rec g_hol_cur%ROWTYPE;
3795: l_retcode NUMBER DEFAULT 0;
3796: l_otm_error VARCHAR2 (120) DEFAULT NULL;
3797: l_oracle_error VARCHAR2 (512) DEFAULT NULL;
3798: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
3799: l_hours_worked_error EXCEPTION;
3800: --BEGIN SIR344
3801: l_time_in DATE := NULL;
3802: l_time_out DATE := NULL;

Line 4126: p_egp_id OUT NOCOPY hxt_sum_hours_worked.earn_pol_id%TYPE -- 5903580 NUMBER earning policy

4122: -- ,p_retcode OUT NOCOPY NUMBER
4123: -- ,p_hours OUT NOCOPY NUMBER
4124: ,
4125: p_shift_hours OUT NOCOPY NUMBER,
4126: p_egp_id OUT NOCOPY hxt_sum_hours_worked.earn_pol_id%TYPE -- 5903580 NUMBER earning policy
4127: ,
4128: p_hdp_id OUT NOCOPY NUMBER -- hrs deduction policy
4129: -- ,p_hdy_id OUT NOCOPY NUMBER -- holiday day ID
4130: ,

Line 4354: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,

4350: i_start_date IN DATE,
4351: i_wage_code VARCHAR2,
4352: i_task_id IN NUMBER,
4353: i_location_id IN NUMBER,
4354: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
4355: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
4356: -- SIR286
4357: i_earn_reason_code IN VARCHAR2,
4358: i_cost_center_id IN NUMBER,

Line 4355: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,

4351: i_wage_code VARCHAR2,
4352: i_task_id IN NUMBER,
4353: i_location_id IN NUMBER,
4354: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
4355: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
4356: -- SIR286
4357: i_earn_reason_code IN VARCHAR2,
4358: i_cost_center_id IN NUMBER,
4359: i_comment IN VARCHAR2,

Line 4391: FROM hxt_sum_hours_worked

4387: IS
4388: SELECT fcl_earn_reason_code, ffv_cost_center_id, rate_multiple,
4389: hourly_rate, separate_check_flag, seqno, creation_date
4390: -- group_id
4391: FROM hxt_sum_hours_worked
4392: WHERE ID = p_id
4393: AND g_sysdate BETWEEN effective_start_date AND effective_end_date;
4394:
4395: -- Begin AM 007a

Line 4399: FROM hxt_sum_hours_worked

4395: -- Begin AM 007a
4396: CURSOR allow_summary_correction (c_sum_id NUMBER)
4397: IS
4398: SELECT 'Y'
4399: FROM hxt_sum_hours_worked
4400: WHERE ID = c_sum_id AND effective_start_date = TRUNC (g_sess_date);
4401:
4402: -- END AM 007a
4403:

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 4845: hxt_dml.insert_hxt_sum_hours_worked

4841: hr_general.end_of_time);
4842: */
4843:
4844: /* Call dml to insert hours */
4845: hxt_dml.insert_hxt_sum_hours_worked
4846: (p_rowid => l_rowid,
4847: p_id => l_hours_worked_id,
4848: p_tim_id => i_timecard_id,
4849: p_date_worked => i_date_worked,

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 4963: FROM hxt_sum_hours_worked

4959: prev_wage_code = i_wage_code,
4960: project_id = i_project_id,
4961: earn_pol_id = i_earn_pol_id
4962: WHERE ROWID = (SELECT ROWID
4963: FROM hxt_sum_hours_worked
4964: WHERE id = i_time_summary_id); */
4965:
4966: /* Call DML to do the update */
4967: SELECT ROWID, tim_id, seqno, created_by,

Line 4973: FROM hxt_sum_hours_worked

4969: job_id, object_version_number
4970: INTO l_rowid, l_time_id, l_sequence_number, l_created_by,
4971: l_creation_date, l_actual_time_in, l_actual_time_out,
4972: l_job_id, l_object_version_number
4973: FROM hxt_sum_hours_worked
4974: WHERE ID = i_time_summary_id;
4975:
4976: IF g_debug
4977: THEN

Line 4981: hxt_dml.update_hxt_sum_hours_worked

4977: THEN
4978: hr_utility.set_location (l_proc, 220);
4979: END IF;
4980:
4981: hxt_dml.update_hxt_sum_hours_worked
4982: (p_rowid => l_rowid,
4983: p_id => i_time_summary_id,
4984: p_tim_id => l_time_id,
4985: p_date_worked => i_date_worked,

Line 5034: FROM hxt_sum_hours_worked

5030: END IF;
5031:
5032: SELECT ROWID
5033: INTO v_row_id
5034: FROM hxt_sum_hours_worked
5035: WHERE ID = i_time_summary_id;
5036:
5037: --
5038: /*

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 5115: hxt_dml.insert_hxt_sum_hours_worked

5111: THEN
5112: hr_utility.set_location (l_proc, 240);
5113: END IF;
5114:
5115: hxt_dml.insert_hxt_sum_hours_worked
5116: (p_rowid => l_rowid,
5117: p_id => l_hours_worked_id,
5118: p_tim_id => l_time_id,
5119: p_date_worked => i_date_worked,

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 5835: FROM hxt_sum_hours_worked

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;
5837:
5838: l_tim_id csr_tim_id%ROWTYPE;
5839: BEGIN

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

Line 6845: FROM hxt_sum_hours_worked --C421

6841: -- Define cursor - OK for out-time to be same as another in-time
6842: CURSOR c
6843: IS
6844: SELECT 'E'
6845: FROM hxt_sum_hours_worked --C421
6846: WHERE (p_time_in < time_out AND p_time_out > time_in)
6847: --C421 AND parent_id = 0
6848: AND date_worked = p_date
6849: AND ID <> NVL (p_id, 0)