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_SUMMARY dependencies on HXT_DET_HOURS_WORKED

Line 360: DELETE FROM hxt_det_hours_worked_f

356: hr_utility.trace('All the duplicate details can be deleted ');
357: END IF;
358:
359: -- Delete from Details table.
360: DELETE FROM hxt_det_hours_worked_f
361: WHERE (tim_id,
362: id,
363: parent_id) IN
364: ( SELECT dup.tim_id,

Line 577: FROM hxt_det_hours_worked_f det,

573:
574: CURSOR get_holiday_overtime
575: IS
576: SELECT NVL(SUM(det.hours),0)
577: FROM hxt_det_hours_worked_f det,
578: hxt_sum_hours_worked_f sum,
579: hxt_earning_rules er,
580: hxt_pay_element_types_f_ddf_v elem
581: WHERE det.tim_id = g_hol_tim_id

Line 607: FROM hxt_det_hours_worked det,

603: det.time_in,
604: det.time_out,
605: det.element_type_id,
606: 0 del_y_n
607: FROM hxt_det_hours_worked det,
608: hxt_add_elem_info_f elem
609: WHERE det.parent_id = p_id
610: AND det.element_type_id = elem.element_type_id
611: AND elem.earning_category = 'SDF'

Line 665: hxt_det_hours_worked_f DET

661:
662: l_sql VARCHAR2(32000) :=
663: 'SELECT NVL(sum(sum.hours),0)
664: FROM hxt_sum_hours_worked_f SUM,
665: hxt_det_hours_worked_f DET
666: WHERE sum.tim_id = :tim_id
667: AND sum.id = det.parent_id
668: AND sum.element_type_id IS NULL
669: AND sum.date_worked = FND_date.CANONICAL_TO_DATE(:date_worked)

Line 829: hxt_det_hours_worked_f det

825: det.tim_id,
826: det.parent_id
827: BULK COLLECT INTO l_det_tab
828: FROM hxt_sum_hours_worked_f sum,
829: hxt_det_hours_worked_f det
830: WHERE sum.element_type_id IS NULL
831: AND sum.id = det.parent_id
832: AND SYSDATE BETWEEN sum.effective_start_date
833: AND sum.effective_end_date

Line 1222: UPDATE hxt_det_hours_worked_f

1218: END LOOP;
1219:
1220:
1221: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
1222: UPDATE hxt_det_hours_worked_f
1223: SET time_in = l_time_in_tab(i),
1224: time_out = l_time_out_tab(i),
1225: hours = (l_time_out_tab(i) - l_time_in_tab(i))*24
1226: WHERE id = l_id_tab(i)

Line 1230: DELETE FROM hxt_det_hours_worked_f

1226: WHERE id = l_id_tab(i)
1227: AND l_del_tab(i) = 2;
1228:
1229: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
1230: DELETE FROM hxt_det_hours_worked_f
1231: WHERE id = l_id_tab(i)
1232: AND l_del_tab(i) = 1;
1233:
1234:

Line 1372: -- into table 'hxt_det_hours_worked_f' without calling the explosion code.

1368:
1369: /* Bug: 4489952 changes starts here */
1370:
1371: -- procedure to insert the non-explosion timecard entries directly
1372: -- into table 'hxt_det_hours_worked_f' without calling the explosion code.
1373: PROCEDURE insert_non_explodable_hrs
1374: IS
1375: l_object_version_number HXT_DET_HOURS_WORKED_F.OBJECT_VERSION_NUMBER%TYPE;
1376: l_rowid ROWID;

Line 1375: l_object_version_number HXT_DET_HOURS_WORKED_F.OBJECT_VERSION_NUMBER%TYPE;

1371: -- procedure to insert the non-explosion timecard entries directly
1372: -- into table 'hxt_det_hours_worked_f' without calling the explosion code.
1373: PROCEDURE insert_non_explodable_hrs
1374: IS
1375: l_object_version_number HXT_DET_HOURS_WORKED_F.OBJECT_VERSION_NUMBER%TYPE;
1376: l_rowid ROWID;
1377: l_id NUMBER;
1378: l_pay_status VARCHAR2(1);
1379: l_pa_status VARCHAR2(1);

Line 1386: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092

1382: l_sqlerrm VARCHAR2(200);
1383: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1384: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1385: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1386: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
1387: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
1388: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
1389: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
1390: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

Line 1388: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;

1384: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1385: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1386: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
1387: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
1388: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
1389: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
1390: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1391: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
1392:

Line 1486: HXT_DML.INSERT_HXT_DET_HOURS_WORKED (

1482: IF g_debug then
1483: hr_utility.set_location('hxt_time_summary.insert_non_explodable_hrs',20);
1484: END IF;
1485:
1486: HXT_DML.INSERT_HXT_DET_HOURS_WORKED (
1487: p_rowid => l_rowid,
1488: p_id => l_id,
1489: p_parent_id => g_id,
1490: p_tim_id => g_tim_id,

Line 2317: FROM hxt_det_hours_worked_f

2313: ,p_error_code IN OUT NOCOPY NUMBER) IS
2314: --Begins by deleting details for current summary record
2315: CURSOR completed_time_card IS
2316: SELECT 'Y'
2317: FROM hxt_det_hours_worked_f
2318: WHERE tim_id=g_tim_id
2319: AND pay_status = 'C';
2320:
2321: l_completed_time_card VARCHAR2(1) := 'N';

Line 2338: DELETE from hxt_det_hours_worked_f

2334: IF nvl(g_DT_UPDATE_MODE, 'CORRECTION') = 'CORRECTION' THEN
2335: if g_debug then
2336: hr_utility.set_location('hxt_time_summary.Delete_Details',20);
2337: end if;
2338: DELETE from hxt_det_hours_worked_f
2339: WHERE parent_id = g_id;
2340:
2341: DELETE from hxt_errors_f where --SPR C153
2342: hrw_id = g_id; --SPR C153

Line 2353: -- Changed the reference to hxt_det_hours_worked to hxt_det_hours_worked_f

2349: -- the person's include group
2350:
2351:
2352: -- Bug 7359347
2353: -- Changed the reference to hxt_det_hours_worked to hxt_det_hours_worked_f
2354: /*
2355: UPDATE hxt_det_hours_worked_f
2356: SET effective_end_date = g_effective_start_date - 1
2357: WHERE rowid in (

Line 2355: UPDATE hxt_det_hours_worked_f

2351:
2352: -- Bug 7359347
2353: -- Changed the reference to hxt_det_hours_worked to hxt_det_hours_worked_f
2354: /*
2355: UPDATE hxt_det_hours_worked_f
2356: SET effective_end_date = g_effective_start_date - 1
2357: WHERE rowid in (
2358: SELECT rowid
2359: FROM hxt_det_hours_worked

Line 2359: FROM hxt_det_hours_worked

2355: UPDATE hxt_det_hours_worked_f
2356: SET effective_end_date = g_effective_start_date - 1
2357: WHERE rowid in (
2358: SELECT rowid
2359: FROM hxt_det_hours_worked
2360: WHERE parent_id = g_id);
2361: */
2362:
2363: UPDATE hxt_det_hours_worked_f

Line 2363: UPDATE hxt_det_hours_worked_f

2359: FROM hxt_det_hours_worked
2360: WHERE parent_id = g_id);
2361: */
2362:
2363: UPDATE hxt_det_hours_worked_f
2364: SET effective_end_date = g_effective_start_date - 1
2365: WHERE parent_id = g_id
2366: AND g_sum_session_date BETWEEN effective_start_date
2367: AND effective_end_date ;

Line 4105: -- logic gets called to insert the data into hxt_det_hours_worked

4101: end if;
4102: -- IF the shift differential override is applicable to the time_in and
4103: -- time_outs ,then set p_sdf_id to g_sdovr_id so that the cursor
4104: -- cur_elig_prem in hxt_time_pay.gen_premiums returns a row and the
4105: -- logic gets called to insert the data into hxt_det_hours_worked
4106: sd_rule_earning := g_sdovr_id;
4107: END IF;
4108: if g_debug then
4109: hr_utility.set_location('hxt_time_summary.gen_details',77);