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_GEN dependencies on HXT_TIMECARDS

Line 86: hxt_timecards tim,

82: egp.fcl_earn_type egp_type, egp.egt_id, egp.hcl_id, egp.pep_id,
83: egp.pip_id, ptp.ROWID ptp_rowid, egp.effective_start_date,
84: egp.effective_end_date
85: FROM per_time_periods ptp,
86: hxt_timecards tim,
87: per_people_f ppl,
88: hxt_earning_policies egp,
89: hxt_per_aei_ddf_v aeiv,
90: per_assignment_status_types ast,

Line 175: hxt_timecards_f tim,

171: egp.fcl_earn_type egp_type, egp.egt_id, egp.hcl_id, egp.pep_id,
172: egp.pip_id, ptp.ROWID ptp_rowid, egp.effective_start_date,
173: egp.effective_end_date
174: FROM per_time_periods ptp,
175: hxt_timecards_f tim,
176: per_people_f ppl,
177: hxt_earning_policies egp,
178: hxt_per_aei_ddf_v aeiv,
179: per_assignment_status_types ast,

Line 250: l_batch_id hxt_timecards.batch_id%TYPE;

246: a_reference_number IN VARCHAR2
247: )
248: IS --SPR C167 BY BC
249: -- Declare local variables
250: l_batch_id hxt_timecards.batch_id%TYPE;
251: l_pre_bat_id hxt_timecards.batch_id%TYPE DEFAULT 0; --SPR C362 by BC
252: l_person_id hxt_timecards.for_person_id%TYPE; -- null to see new person in first loop
253: l_tim_id hxt_timecards.id%TYPE; -- to hold tim_id for same person
254: l_request_id NUMBER := fnd_profile.VALUE ('CONC_REQUEST_ID');

Line 251: l_pre_bat_id hxt_timecards.batch_id%TYPE DEFAULT 0; --SPR C362 by BC

247: )
248: IS --SPR C167 BY BC
249: -- Declare local variables
250: l_batch_id hxt_timecards.batch_id%TYPE;
251: l_pre_bat_id hxt_timecards.batch_id%TYPE DEFAULT 0; --SPR C362 by BC
252: l_person_id hxt_timecards.for_person_id%TYPE; -- null to see new person in first loop
253: l_tim_id hxt_timecards.id%TYPE; -- to hold tim_id for same person
254: l_request_id NUMBER := fnd_profile.VALUE ('CONC_REQUEST_ID');
255: l_tim_cntr NUMBER := g_batch_size; -- set to create batch in first loop

Line 252: l_person_id hxt_timecards.for_person_id%TYPE; -- null to see new person in first loop

248: IS --SPR C167 BY BC
249: -- Declare local variables
250: l_batch_id hxt_timecards.batch_id%TYPE;
251: l_pre_bat_id hxt_timecards.batch_id%TYPE DEFAULT 0; --SPR C362 by BC
252: l_person_id hxt_timecards.for_person_id%TYPE; -- null to see new person in first loop
253: l_tim_id hxt_timecards.id%TYPE; -- to hold tim_id for same person
254: l_request_id NUMBER := fnd_profile.VALUE ('CONC_REQUEST_ID');
255: l_tim_cntr NUMBER := g_batch_size; -- set to create batch in first loop
256: l_retcode NUMBER;

Line 253: l_tim_id hxt_timecards.id%TYPE; -- to hold tim_id for same person

249: -- Declare local variables
250: l_batch_id hxt_timecards.batch_id%TYPE;
251: l_pre_bat_id hxt_timecards.batch_id%TYPE DEFAULT 0; --SPR C362 by BC
252: l_person_id hxt_timecards.for_person_id%TYPE; -- null to see new person in first loop
253: l_tim_id hxt_timecards.id%TYPE; -- to hold tim_id for same person
254: l_request_id NUMBER := fnd_profile.VALUE ('CONC_REQUEST_ID');
255: l_tim_cntr NUMBER := g_batch_size; -- set to create batch in first loop
256: l_retcode NUMBER;
257: l_errors EXCEPTION;

Line 917: g_sub_loc := 'INSERT into hxt_timecards';

913: -- Get next sequence number
914: g_sub_loc := 'Get_hxt_Seqno';
915: l_tim_id := get_hxt_seqno;
916: -- Insert timecard
917: g_sub_loc := 'INSERT into hxt_timecards';
918:
919: INSERT INTO hxt_timecards_f
920: (id, for_person_id, payroll_id,
921: time_period_id, batch_id, auto_gen_flag, created_by,

Line 919: INSERT INTO hxt_timecards_f

915: l_tim_id := get_hxt_seqno;
916: -- Insert timecard
917: g_sub_loc := 'INSERT into hxt_timecards';
918:
919: INSERT INTO hxt_timecards_f
920: (id, for_person_id, payroll_id,
921: time_period_id, batch_id, auto_gen_flag, created_by,
922: creation_date, last_updated_by, last_update_date,
923: last_update_login, effective_start_date,

Line 1369: SELECT id FROM hxt_timecards_f tim

1365: -- that won't be autogen'ed again. Hours worked and error records will
1366: -- cascade-delete.
1367:
1368: CURSOR c_get_tim_id IS
1369: SELECT id FROM hxt_timecards_f tim
1370: WHERE tim.auto_gen_flag = 'A'
1371: AND tim.time_period_id = g_time_period_id
1372: AND exists -- added 2772781
1373: (

Line 1396: g_sub_loc := 'DELETE from hxt_timecards';

1392: AND ptp.time_period_id = tim.time_period_id);
1393:
1394: BEGIN
1395: -- Delete obsolete timecards
1396: g_sub_loc := 'DELETE from hxt_timecards';
1397: FOR l_record IN c_get_tim_id
1398: LOOP
1399: DELETE FROM hxt_det_hours_worked_f
1400: WHERE tim_id = l_record.id;

Line 1405: DELETE FROM hxt_timecards_f

1401:
1402: DELETE FROM hxt_sum_hours_worked_f
1403: WHERE tim_id = l_record.id;
1404:
1405: DELETE FROM hxt_timecards_f
1406: WHERE id = l_record.id;
1407: END LOOP;
1408:
1409: COMMIT;

Line 1453: FROM hxt_timecards_f tim

1449: --BEGIN SIR435
1450: CURSOR cur_tim_exists
1451: IS
1452: SELECT auto_gen_flag, for_person_id
1453: FROM hxt_timecards_f tim
1454: WHERE tim.auto_gen_flag <> 'A'
1455: AND tim.for_person_id = a_person_id
1456: AND tim.time_period_id = a_time_period_id
1457: AND tim.payroll_id = a_payroll_id