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_BATCH_VAL dependencies on HXT_TIMECARDS_F

Line 181: p_batch_id IN hxt_timecards_f.batch_id%TYPE

177: end if;
178: END set_error_level;
179:
180: PROCEDURE delete_prev_val_errors (
181: p_batch_id IN hxt_timecards_f.batch_id%TYPE
182: )
183: AS
184: l_proc VARCHAR2 (72) ;
185: BEGIN

Line 202: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE)

198: || l_proc, 20);
199: end if;
200: END delete_prev_val_errors;
201:
202: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE)
203: AS
204: l_proc VARCHAR2 (72) ;
205: BEGIN
206: g_debug :=hr_utility.debug_enabled;

Line 268: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)

264: end if;
265: RETURN l_error_exist;
266: END errors_exist;
267:
268: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
269: RETURN per_time_periods.end_date%TYPE
270: AS
271: l_proc VARCHAR2 (72) ;
272:

Line 273: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)

269: RETURN per_time_periods.end_date%TYPE
270: AS
271: l_proc VARCHAR2 (72) ;
272:
273: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)
274: IS
275: SELECT ptp.end_date
276: FROM per_time_periods ptp, hxt_timecards_x htx
277: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;

Line 402: p_person_id IN hxt_timecards.for_person_id%TYPE,

398: END record_error;
399:
400: PROCEDURE person_validation (
401: p_batch_id IN NUMBER,
402: p_person_id IN hxt_timecards.for_person_id%TYPE,
403: p_period_id IN hxt_timecards.time_period_id%TYPE,
404: p_tim_id IN hxt_timecards.id%TYPE
405: )
406: AS

Line 470: p_person_id IN hxt_timecards.for_person_id%TYPE,

466:
467: PROCEDURE excess_pto (
468: p_batch_id IN NUMBER,
469: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,
470: p_person_id IN hxt_timecards.for_person_id%TYPE,
471: p_period_id IN hxt_timecards.time_period_id%TYPE,
472: p_tim_id IN hxt_timecards.id%TYPE
473: )
474: IS

Line 776: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,

772: END day_is_holiday;
773:
774: FUNCTION timecard_approved (
775: p_tim_id IN hxt_holiday_calendars.id%TYPE,
776: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
777: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
778: )
779: RETURN BOOLEAN
780: IS

Line 777: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

773:
774: FUNCTION timecard_approved (
775: p_tim_id IN hxt_holiday_calendars.id%TYPE,
776: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
777: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
778: )
779: RETURN BOOLEAN
780: IS
781: l_proc VARCHAR2 (72) ;

Line 822: p_person_id IN hxt_timecards.for_person_id%TYPE,

818: END timecard_approved;
819:
820: PROCEDURE tcard_approved (
821: p_batch_id IN NUMBER,
822: p_person_id IN hxt_timecards.for_person_id%TYPE,
823: p_period_id IN hxt_timecards.time_period_id%TYPE,
824: p_tim_id IN hxt_timecards.id%TYPE,
825: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
826: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

Line 825: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,

821: p_batch_id IN NUMBER,
822: p_person_id IN hxt_timecards.for_person_id%TYPE,
823: p_period_id IN hxt_timecards.time_period_id%TYPE,
824: p_tim_id IN hxt_timecards.id%TYPE,
825: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
826: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
827: )
828: IS
829: l_proc VARCHAR2 (72) ;

Line 826: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

822: p_person_id IN hxt_timecards.for_person_id%TYPE,
823: p_period_id IN hxt_timecards.time_period_id%TYPE,
824: p_tim_id IN hxt_timecards.id%TYPE,
825: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
826: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
827: )
828: IS
829: l_proc VARCHAR2 (72) ;
830: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

Line 1041: p_person_id IN hxt_timecards.for_person_id%TYPE,

1037: END assignment_is_active;
1038:
1039: PROCEDURE inactive_emp_tcard (
1040: p_batch_id IN NUMBER,
1041: p_person_id IN hxt_timecards.for_person_id%TYPE,
1042: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1043: p_period_id IN hxt_timecards.time_period_id%TYPE,
1044: p_tim_id IN hxt_timecards.id%TYPE,
1045: p_day IN DATE

Line 1240: p_person_id IN hxt_timecards.for_person_id%TYPE,

1236: END sum_unexploded_hours;
1237:
1238: PROCEDURE holiday_mismatch (
1239: p_batch_id IN NUMBER,
1240: p_person_id IN hxt_timecards.for_person_id%TYPE,
1241: p_period_id IN hxt_timecards.time_period_id%TYPE,
1242: p_tim_id IN hxt_timecards.id%TYPE,
1243: p_day IN DATE,
1244: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 1322: p_person_id IN hxt_timecards.for_person_id%TYPE,

1318: END holiday_mismatch;
1319:
1320: PROCEDURE holiday_valid (
1321: p_batch_id IN NUMBER,
1322: p_person_id IN hxt_timecards.for_person_id%TYPE,
1323: p_period_id IN hxt_timecards.time_period_id%TYPE,
1324: p_tim_id IN hxt_timecards.id%TYPE,
1325: p_day IN DATE,
1326: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 1676: p_person_id IN hxt_timecards.for_person_id%TYPE,

1672: END sum_valid_det_hours;
1673:
1674: PROCEDURE day_over_24 (
1675: p_batch_id IN NUMBER,
1676: p_person_id IN hxt_timecards.for_person_id%TYPE,
1677: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1678: p_period_id IN hxt_timecards.time_period_id%TYPE,
1679: p_tim_id IN hxt_timecards.id%TYPE,
1680: p_day IN DATE,

Line 1746: p_person_id IN hxt_timecards.for_person_id%TYPE,

1742: END day_over_24;
1743:
1744: PROCEDURE holiday_as_reg (
1745: p_batch_id IN NUMBER,
1746: p_person_id IN hxt_timecards.for_person_id%TYPE,
1747: p_period_id IN hxt_timecards.time_period_id%TYPE,
1748: p_tim_id IN hxt_timecards.id%TYPE,
1749: p_day IN DATE,
1750: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 1815: p_person_id IN hxt_timecards.for_person_id%TYPE,

1811: END holiday_as_reg;
1812:
1813: PROCEDURE perform_holiday_validations (
1814: p_batch_id IN NUMBER,
1815: p_person_id IN hxt_timecards.for_person_id%TYPE,
1816: p_period_id IN hxt_timecards.time_period_id%TYPE,
1817: p_tim_id IN hxt_timecards.id%TYPE,
1818: p_day IN DATE,
1819: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 1874: p_person_id IN hxt_timecards.for_person_id%TYPE,

1870: END perform_holiday_validations;
1871:
1872: PROCEDURE perform_day_validations (
1873: p_batch_id IN NUMBER,
1874: p_person_id IN hxt_timecards.for_person_id%TYPE,
1875: p_period_id IN hxt_timecards.time_period_id%TYPE,
1876: p_tim_id IN hxt_timecards.id%TYPE
1877: )
1878: AS

Line 1985: p_person_id IN hxt_timecards.for_person_id%TYPE,

1981:
1982: PROCEDURE validate_tc (
1983: p_batch_id IN NUMBER,
1984: p_tim_id IN hxt_timecards.id%TYPE,
1985: p_person_id IN hxt_timecards.for_person_id%TYPE,
1986: p_period_id IN hxt_timecards.time_period_id%TYPE,
1987: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,
1988: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,
1989: p_error_level IN OUT NOCOPY NUMBER

Line 2073: CURSOR csr_tcs_in_batch (p_batch_id hxt_timecards_f.batch_id%TYPE)

2069: l_sql_error VARCHAR2 (80);
2070: l_id NUMBER;
2071: l_cnt BINARY_INTEGER;
2072:
2073: CURSOR csr_tcs_in_batch (p_batch_id hxt_timecards_f.batch_id%TYPE)
2074: IS
2075: SELECT tim.id tim_id, tim.for_person_id, tim.time_period_id,
2076: tim.approv_person_id, tim.auto_gen_flag,
2077: tim.approved_timestamp , tim.created_by,