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_TIMECARDS

Line 476: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;

472: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
473: l_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
474: l_appr_last_name per_people_f.last_name%TYPE DEFAULT NULL;
475: l_appr_first_name per_people_f.first_name%TYPE DEFAULT NULL;
476: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;
477: l_date_worked DATE DEFAULT NULL;
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;

Line 488: l_auto_gen_flag hxt_timecards.auto_gen_flag%TYPE

484: l_time_period_id per_time_periods.time_period_id%TYPE
485: DEFAULT NULL;
486: l_start_date DATE DEFAULT NULL;
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;

Line 495: l_timecard_source_code hxt_timecards.auto_gen_flag%TYPE

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
498: DEFAULT NULL;
499: l_ffv_cost_center_id hxt_sum_hours_worked.ffv_cost_center_id%TYPE

Line 573: FROM hxt_timecards_f tim,

569: -- Bug 9790410
570: -- To find out if the timecard being edited is Archived.
571: CURSOR get_archived_status(p_id IN NUMBER)
572: IS SELECT 1
573: FROM hxt_timecards_f tim,
574: hxc_data_sets hds
575: WHERE tim.id = p_id
576: AND tim.data_set_id = hds.data_set_id
577: AND hds.status IN ('OFF_LINE','RESTORE_IN_PROGRESS','ARCHIVE_IN_PROGRESS');

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 3026: FROM hxt_timecards tim, --SIR290

3022: c_tim_end_date DATE
3023: )
3024: IS
3025: SELECT tim.for_person_id, tbh.status, ptp.start_date --SIR286
3026: FROM hxt_timecards tim, --SIR290
3027: hxt_batch_states tbh,
3028: per_time_periods ptp --SIR286
3029: WHERE tim.ID = c_tim_id
3030: AND tbh.batch_id = tim.batch_id

Line 3041: FROM hxt_timecards_f tim, --SIR290

3037: c_tim_start_date DATE
3038: )
3039: IS
3040: SELECT tim.for_person_id, tbh.status, ptp.start_date --SIR286
3041: FROM hxt_timecards_f tim, --SIR290
3042: hxt_batch_states tbh,
3043: per_time_periods ptp --SIR286
3044: WHERE tim.ID = c_tim_id
3045: AND tbh.batch_id = tim.batch_id

Line 3377: Check the HXT_TIMECARDS table to see if a timecard

3373: END get_time_period;
3374:
3375: /***************************************************
3376: check_for_timecard()
3377: Check the HXT_TIMECARDS table to see if a timecard
3378: already exists for the person punching the clock
3379: ****************************************************/
3380: FUNCTION check_for_timecard (
3381: i_person_id IN NUMBER,

Line 3398: FROM hxt_timecards_f

3394: END IF;
3395:
3396: SELECT ID, auto_gen_flag, batch_id
3397: INTO o_timecard_id, o_auto_gen_flag, g_batch_err_id
3398: FROM hxt_timecards_f
3399: WHERE for_person_id = i_person_id AND time_period_id = i_time_period_id;
3400:
3401: IF g_debug
3402: THEN

Line 3488: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;

3484: l_batch_creation_error EXCEPTION;
3485: l_batch_location_error EXCEPTION;
3486: l_tim_id_creation_error EXCEPTION;
3487: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3488: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;
3489: l_object_version_number NUMBER DEFAULT NULL;
3490: l_rowid ROWID;
3491: BEGIN
3492: /* Obtain a batch id for the new timecard */

Line 3562: /* Insert new timecard info to hxt_timecards */

3558: RAISE l_tim_id_creation_error;
3559: END IF;
3560:
3561: --
3562: /* Insert new timecard info to hxt_timecards */
3563: /* INSERT into hxt_timecards_f
3564: ( id,
3565: for_person_id,
3566: payroll_id,

Line 3563: /* INSERT into hxt_timecards_f

3559: END IF;
3560:
3561: --
3562: /* Insert new timecard info to hxt_timecards */
3563: /* INSERT into hxt_timecards_f
3564: ( id,
3565: for_person_id,
3566: payroll_id,
3567: time_period_id,

Line 3601: hxt_dml.insert_hxt_timecards

3597: THEN
3598: hr_utility.TRACE ('BEFORE DML create timecard');
3599: END IF;
3600:
3601: hxt_dml.insert_hxt_timecards
3602: (p_rowid => l_rowid,
3603: p_id => l_timecard_id,
3604: p_for_person_id => i_person_id,
3605: p_time_period_id => i_time_period_id,

Line 3865: FROM hxt_timecards ht,

3861: p_batch_reference pay_batch_headers.batch_reference%TYPE
3862: )
3863: IS
3864: SELECT COUNT (ht.ID) num_tcs, MAX (ht.batch_id) batch_id
3865: FROM hxt_timecards ht,
3866: hxt_batch_states hbs,
3867: pay_batch_headers pbh
3868: WHERE ht.time_period_id = p_time_period_id
3869: AND hbs.batch_id = ht.batch_id