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 204: -- into table 'hxt_det_hours_worked_f' without calling the explosion code.

200:
201: /* Bug: 4489952 changes starts here */
202:
203: -- procedure to insert the non-explosion timecard entries directly
204: -- into table 'hxt_det_hours_worked_f' without calling the explosion code.
205: PROCEDURE insert_non_explodable_hrs
206: IS
207: l_object_version_number HXT_DET_HOURS_WORKED_F.OBJECT_VERSION_NUMBER%TYPE;
208: l_rowid ROWID;

Line 207: l_object_version_number HXT_DET_HOURS_WORKED_F.OBJECT_VERSION_NUMBER%TYPE;

203: -- procedure to insert the non-explosion timecard entries directly
204: -- into table 'hxt_det_hours_worked_f' without calling the explosion code.
205: PROCEDURE insert_non_explodable_hrs
206: IS
207: l_object_version_number HXT_DET_HOURS_WORKED_F.OBJECT_VERSION_NUMBER%TYPE;
208: l_rowid ROWID;
209: l_id NUMBER;
210: l_pay_status VARCHAR2(1);
211: l_pa_status VARCHAR2(1);

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

214: l_sqlerrm VARCHAR2(200);
215: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
216: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
217: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
218: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
219: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
220: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
221: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
222: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

Line 220: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;

216: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
217: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
218: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
219: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
220: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
221: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
222: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
223: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
224:

Line 318: HXT_DML.INSERT_HXT_DET_HOURS_WORKED (

314: IF g_debug then
315: hr_utility.set_location('hxt_time_summary.insert_non_explodable_hrs',20);
316: END IF;
317:
318: HXT_DML.INSERT_HXT_DET_HOURS_WORKED (
319: p_rowid => l_rowid,
320: p_id => l_id,
321: p_parent_id => g_id,
322: p_tim_id => g_tim_id,

Line 1040: FROM hxt_det_hours_worked_f

1036: ,p_error_code IN OUT NOCOPY NUMBER) IS
1037: --Begins by deleting details for current summary record
1038: CURSOR completed_time_card IS
1039: SELECT 'Y'
1040: FROM hxt_det_hours_worked_f
1041: WHERE tim_id=g_tim_id
1042: AND pay_status = 'C';
1043:
1044: l_completed_time_card VARCHAR2(1) := 'N';

Line 1061: DELETE from hxt_det_hours_worked_f

1057: IF nvl(g_DT_UPDATE_MODE, 'CORRECTION') = 'CORRECTION' THEN
1058: if g_debug then
1059: hr_utility.set_location('hxt_time_summary.Delete_Details',20);
1060: end if;
1061: DELETE from hxt_det_hours_worked_f
1062: WHERE parent_id = g_id;
1063:
1064: DELETE from hxt_errors_f where --SPR C153
1065: hrw_id = g_id; --SPR C153

Line 1074: UPDATE hxt_det_hours_worked_f

1070: -- Delete details for this entry and all others that follow
1071: -- on this day for this person that are non-absence or are in
1072: -- the person's include group
1073:
1074: UPDATE hxt_det_hours_worked_f
1075: SET effective_end_date = g_effective_start_date - 1
1076: WHERE rowid in (
1077: SELECT rowid
1078: FROM hxt_det_hours_worked

Line 1078: FROM hxt_det_hours_worked

1074: UPDATE hxt_det_hours_worked_f
1075: SET effective_end_date = g_effective_start_date - 1
1076: WHERE rowid in (
1077: SELECT rowid
1078: FROM hxt_det_hours_worked
1079: WHERE parent_id = g_id);
1080: UPDATE hxt_errors_f
1081: SET effective_end_date = g_effective_start_date - 1
1082: WHERE rowid in (

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

2770: end if;
2771: -- IF the shift differential override is applicable to the time_in and
2772: -- time_outs ,then set p_sdf_id to g_sdovr_id so that the cursor
2773: -- cur_elig_prem in hxt_time_pay.gen_premiums returns a row and the
2774: -- logic gets called to insert the data into hxt_det_hours_worked
2775: sd_rule_earning := g_sdovr_id;
2776: END IF;
2777: if g_debug then
2778: hr_utility.set_location('hxt_time_summary.gen_details',77);