APPS.HXT_TIME_SUMMARY dependencies on HXT_DET_HOURS_WORKED_F

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 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