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

Line 170: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,

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

Line 171: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,

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

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

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

Line 275: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,

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

Line 276: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,

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

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

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

Line 491: l_hours hxt_sum_hours_worked.hours%TYPE

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

Line 493: l_sep_chk_flg hxt_sum_hours_worked.separate_check_flag%TYPE

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

Line 497: l_earn_pol_id hxt_sum_hours_worked.earn_pol_id%TYPE

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

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

Line 700: -- The table is being referred in the views hxt_timecards, hxt_sum_hours_worked,

696:
697: -- Bug 7359347
698: -- We made some extensive code changes for this issue primarily
699: -- to avoid contention with the FND_SESSIONS table.
700: -- The table is being referred in the views hxt_timecards, hxt_sum_hours_worked,
701: -- and hxt_det_hours_worked and each has two occurances of FND_SESSIONS.
702: -- With this patch we introduced global variables to hold the value of session_id
703: -- and session date and are using them in the ocde as input values to cursors so
704: -- that FND_SESSIONS is not required. Here are the global variables we

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

1920: -- i.e., If it is not a deleted record then create it.
1921: -- If it is a deleted record then we should skip this call to
1922: -- record_hours_worked
1923:
1924: -- Insert hours to the hxt_sum_hours_worked table and
1925: -- call generate details
1926: IF g_debug
1927: THEN
1928: hr_utility.TRACE ('BEFORE record_hours worked');

Line 3002: Fetch all hxt_sum_hours_worked records for the timecard

2998: END;
2999:
3000: /**********************************************************
3001: re_explode_timecard()
3002: Fetch all hxt_sum_hours_worked records for the timecard
3003: indicated. Call record_time for each record to re-explode.
3004: ***********************************************************/
3005: PROCEDURE re_explode_timecard (
3006: timecard_id IN NUMBER,

Line 3072: FROM hxt_sum_hours_worked

3068: actual_time_in, actual_time_out, prev_wage_code, project_id,
3069: earn_pol_id, time_building_block_id,
3070: time_building_block_ovn, state_name, county_name, city_name,
3071: zip_code
3072: FROM hxt_sum_hours_worked
3073: WHERE tim_id = c_tim_id
3074: ORDER BY date_worked, element_type_id, time_in, seqno, ID;
3075: */
3076:

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 3106: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;

3102: l_batch_status VARCHAR2 (30);
3103: l_timecard_rec get_timecard_rec%ROWTYPE;
3104: l_otm_error VARCHAR2 (120) DEFAULT NULL;
3105: l_oracle_error VARCHAR2 (512) DEFAULT NULL;
3106: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
3107: l_tim_not_found_err EXCEPTION;
3108: l_rec_hours_data_err EXCEPTION;
3109: l_rec_hours_sys_err EXCEPTION;
3110: l_delete_details_err EXCEPTION;

Line 3956: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,

3952: i_timecard_id IN NUMBER,
3953: i_wage_code IN VARCHAR2,
3954: i_task_id IN NUMBER,
3955: i_location_id IN NUMBER,
3956: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
3957: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
3958: i_earn_reason_code IN VARCHAR2,
3959: i_comment IN VARCHAR2,
3960: i_rate_multiple IN NUMBER,

Line 3957: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,

3953: i_wage_code IN VARCHAR2,
3954: i_task_id IN NUMBER,
3955: i_location_id IN NUMBER,
3956: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
3957: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
3958: i_earn_reason_code IN VARCHAR2,
3959: i_comment IN VARCHAR2,
3960: i_rate_multiple IN NUMBER,
3961: i_hourly_rate IN NUMBER,

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

3990: l_hol_rec g_hol_cur%ROWTYPE;
3991: l_retcode NUMBER DEFAULT 0;
3992: l_otm_error VARCHAR2 (120) DEFAULT NULL;
3993: l_oracle_error VARCHAR2 (512) DEFAULT NULL;
3994: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;
3995: l_hours_worked_error EXCEPTION;
3996: --BEGIN SIR344
3997: l_time_in DATE := NULL;
3998: l_time_out DATE := NULL;

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

4319: -- ,p_retcode OUT NOCOPY NUMBER
4320: -- ,p_hours OUT NOCOPY NUMBER
4321: ,
4322: p_shift_hours OUT NOCOPY NUMBER,
4323: p_egp_id OUT NOCOPY hxt_sum_hours_worked.earn_pol_id%TYPE -- 5903580 NUMBER earning policy
4324: ,
4325: p_hdp_id OUT NOCOPY NUMBER -- hrs deduction policy
4326: -- ,p_hdy_id OUT NOCOPY NUMBER -- holiday day ID
4327: ,

Line 4551: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,

4547: i_start_date IN DATE,
4548: i_wage_code VARCHAR2,
4549: i_task_id IN NUMBER,
4550: i_location_id IN NUMBER,
4551: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
4552: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
4553: -- SIR286
4554: i_earn_reason_code IN VARCHAR2,
4555: i_cost_center_id IN NUMBER,

Line 4552: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,

4548: i_wage_code VARCHAR2,
4549: i_task_id IN NUMBER,
4550: i_location_id IN NUMBER,
4551: i_project_id IN hxt_sum_hours_worked.project_id%TYPE,
4552: i_earn_pol_id IN hxt_sum_hours_worked.earn_pol_id%TYPE,
4553: -- SIR286
4554: i_earn_reason_code IN VARCHAR2,
4555: i_cost_center_id IN NUMBER,
4556: i_comment IN VARCHAR2,

Line 4592: FROM hxt_sum_hours_worked

4588: IS
4589: SELECT fcl_earn_reason_code, ffv_cost_center_id, rate_multiple,
4590: hourly_rate, separate_check_flag, seqno, creation_date
4591: -- group_id
4592: FROM hxt_sum_hours_worked
4593: WHERE ID = p_id
4594: AND g_sysdate BETWEEN effective_start_date AND effective_end_date;
4595:
4596: -- Begin AM 007a

Line 4600: FROM hxt_sum_hours_worked

4596: -- Begin AM 007a
4597: CURSOR allow_summary_correction (c_sum_id NUMBER)
4598: IS
4599: SELECT 'Y'
4600: FROM hxt_sum_hours_worked
4601: WHERE ID = c_sum_id AND effective_start_date = TRUNC (g_sess_date);
4602: */
4603:
4604: CURSOR upd_det_cur (p_id NUMBER)

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

5064: hr_general.end_of_time);
5065: */
5066:
5067: /* Call dml to insert hours */
5068: hxt_dml.insert_hxt_sum_hours_worked
5069: (p_rowid => l_rowid,
5070: p_id => l_hours_worked_id,
5071: p_tim_id => i_timecard_id,
5072: p_date_worked => i_date_worked,

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

5182: prev_wage_code = i_wage_code,
5183: project_id = i_project_id,
5184: earn_pol_id = i_earn_pol_id
5185: WHERE ROWID = (SELECT ROWID
5186: FROM hxt_sum_hours_worked
5187: WHERE id = i_time_summary_id); */
5188:
5189: /* Call DML to do the update */
5190: -- Bug 7359347

Line 5200: FROM hxt_sum_hours_worked

5196: job_id, object_version_number
5197: INTO l_rowid, l_time_id, l_sequence_number, l_created_by,
5198: l_creation_date, l_actual_time_in, l_actual_time_out,
5199: l_job_id, l_object_version_number
5200: FROM hxt_sum_hours_worked
5201: WHERE ID = i_time_summary_id;
5202:
5203: */
5204:

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 5222: hxt_dml.update_hxt_sum_hours_worked

5218: THEN
5219: hr_utility.set_location (l_proc, 220);
5220: END IF;
5221:
5222: hxt_dml.update_hxt_sum_hours_worked
5223: (p_rowid => l_rowid,
5224: p_id => i_time_summary_id,
5225: p_tim_id => l_time_id,
5226: p_date_worked => i_date_worked,

Line 5278: FROM hxt_sum_hours_worked

5274: -- Picking up rowid, so querying on the base table instead of the view.
5275: /*
5276: SELECT ROWID
5277: INTO v_row_id
5278: FROM hxt_sum_hours_worked
5279: WHERE ID = i_time_summary_id;
5280: */
5281:
5282: SELECT ROWID

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

5364: THEN
5365: hr_utility.set_location (l_proc, 240);
5366: END IF;
5367:
5368: hxt_dml.insert_hxt_sum_hours_worked
5369: (p_rowid => l_rowid,
5370: p_id => l_hours_worked_id,
5371: p_tim_id => l_time_id,
5372: p_date_worked => i_date_worked,

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 7230: FROM hxt_sum_hours_worked --C421

7226: /*
7227: CURSOR c
7228: IS
7229: SELECT 'E'
7230: FROM hxt_sum_hours_worked --C421
7231: WHERE (p_time_in < time_out AND p_time_out > time_in)
7232: --C421 AND parent_id = 0
7233: AND date_worked = p_date
7234: AND ID <> NVL (p_id, 0)

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