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 175: p_batch_id IN hxt_timecards_f.batch_id%TYPE

171: end if;
172: END set_error_level;
173:
174: PROCEDURE delete_prev_val_errors (
175: p_batch_id IN hxt_timecards_f.batch_id%TYPE
176: )
177: AS
178: l_proc VARCHAR2 (72) ;
179: BEGIN

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

192: || l_proc, 20);
193: end if;
194: END delete_prev_val_errors;
195:
196: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE)
197: AS
198: l_proc VARCHAR2 (72) ;
199: BEGIN
200: g_debug :=hr_utility.debug_enabled;

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

258: end if;
259: RETURN l_error_exist;
260: END errors_exist;
261:
262: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
263: RETURN per_time_periods.end_date%TYPE
264: AS
265: l_proc VARCHAR2 (72) ;
266:

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

263: RETURN per_time_periods.end_date%TYPE
264: AS
265: l_proc VARCHAR2 (72) ;
266:
267: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)
268: IS
269: SELECT ptp.end_date
270: FROM per_time_periods ptp, hxt_timecards_x htx
271: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;

Line 396: p_person_id IN hxt_timecards.for_person_id%TYPE,

392: END record_error;
393:
394: PROCEDURE person_validation (
395: p_batch_id IN NUMBER,
396: p_person_id IN hxt_timecards.for_person_id%TYPE,
397: p_period_id IN hxt_timecards.time_period_id%TYPE,
398: p_tim_id IN hxt_timecards.id%TYPE
399: )
400: AS

Line 436: p_person_id IN hxt_timecards.for_person_id%TYPE,

432:
433: PROCEDURE excess_pto (
434: p_batch_id IN NUMBER,
435: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,
436: p_person_id IN hxt_timecards.for_person_id%TYPE,
437: p_period_id IN hxt_timecards.time_period_id%TYPE,
438: p_tim_id IN hxt_timecards.id%TYPE
439: )
440: IS

Line 714: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,

710: END day_is_holiday;
711:
712: FUNCTION timecard_approved (
713: p_tim_id IN hxt_holiday_calendars.id%TYPE,
714: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
715: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
716: )
717: RETURN BOOLEAN
718: IS

Line 715: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

711:
712: FUNCTION timecard_approved (
713: p_tim_id IN hxt_holiday_calendars.id%TYPE,
714: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
715: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
716: )
717: RETURN BOOLEAN
718: IS
719: l_proc VARCHAR2 (72) ;

Line 760: p_person_id IN hxt_timecards.for_person_id%TYPE,

756: END timecard_approved;
757:
758: PROCEDURE tcard_approved (
759: p_batch_id IN NUMBER,
760: p_person_id IN hxt_timecards.for_person_id%TYPE,
761: p_period_id IN hxt_timecards.time_period_id%TYPE,
762: p_tim_id IN hxt_timecards.id%TYPE,
763: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
764: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

Line 763: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,

759: p_batch_id IN NUMBER,
760: p_person_id IN hxt_timecards.for_person_id%TYPE,
761: p_period_id IN hxt_timecards.time_period_id%TYPE,
762: p_tim_id IN hxt_timecards.id%TYPE,
763: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
764: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
765: )
766: IS
767: l_proc VARCHAR2 (72) ;

Line 764: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

760: p_person_id IN hxt_timecards.for_person_id%TYPE,
761: p_period_id IN hxt_timecards.time_period_id%TYPE,
762: p_tim_id IN hxt_timecards.id%TYPE,
763: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
764: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
765: )
766: IS
767: l_proc VARCHAR2 (72) ;
768: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

Line 950: p_person_id IN hxt_timecards.for_person_id%TYPE,

946: END assignment_is_active;
947:
948: PROCEDURE inactive_emp_tcard (
949: p_batch_id IN NUMBER,
950: p_person_id IN hxt_timecards.for_person_id%TYPE,
951: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
952: p_period_id IN hxt_timecards.time_period_id%TYPE,
953: p_tim_id IN hxt_timecards.id%TYPE,
954: p_day IN DATE

Line 1119: p_person_id IN hxt_timecards.for_person_id%TYPE,

1115: END sum_unexploded_hours;
1116:
1117: PROCEDURE holiday_mismatch (
1118: p_batch_id IN NUMBER,
1119: p_person_id IN hxt_timecards.for_person_id%TYPE,
1120: p_period_id IN hxt_timecards.time_period_id%TYPE,
1121: p_tim_id IN hxt_timecards.id%TYPE,
1122: p_day IN DATE,
1123: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 1171: p_person_id IN hxt_timecards.for_person_id%TYPE,

1167: END holiday_mismatch;
1168:
1169: PROCEDURE holiday_valid (
1170: p_batch_id IN NUMBER,
1171: p_person_id IN hxt_timecards.for_person_id%TYPE,
1172: p_period_id IN hxt_timecards.time_period_id%TYPE,
1173: p_tim_id IN hxt_timecards.id%TYPE,
1174: p_day IN DATE,
1175: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 1496: p_person_id IN hxt_timecards.for_person_id%TYPE,

1492: END sum_valid_det_hours;
1493:
1494: PROCEDURE day_over_24 (
1495: p_batch_id IN NUMBER,
1496: p_person_id IN hxt_timecards.for_person_id%TYPE,
1497: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1498: p_period_id IN hxt_timecards.time_period_id%TYPE,
1499: p_tim_id IN hxt_timecards.id%TYPE,
1500: p_day IN DATE,

Line 1539: p_person_id IN hxt_timecards.for_person_id%TYPE,

1535: END day_over_24;
1536:
1537: PROCEDURE holiday_as_reg (
1538: p_batch_id IN NUMBER,
1539: p_person_id IN hxt_timecards.for_person_id%TYPE,
1540: p_period_id IN hxt_timecards.time_period_id%TYPE,
1541: p_tim_id IN hxt_timecards.id%TYPE,
1542: p_day IN DATE,
1543: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 1580: p_person_id IN hxt_timecards.for_person_id%TYPE,

1576: END holiday_as_reg;
1577:
1578: PROCEDURE perform_holiday_validations (
1579: p_batch_id IN NUMBER,
1580: p_person_id IN hxt_timecards.for_person_id%TYPE,
1581: p_period_id IN hxt_timecards.time_period_id%TYPE,
1582: p_tim_id IN hxt_timecards.id%TYPE,
1583: p_day IN DATE,
1584: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 1639: p_person_id IN hxt_timecards.for_person_id%TYPE,

1635: END perform_holiday_validations;
1636:
1637: PROCEDURE perform_day_validations (
1638: p_batch_id IN NUMBER,
1639: p_person_id IN hxt_timecards.for_person_id%TYPE,
1640: p_period_id IN hxt_timecards.time_period_id%TYPE,
1641: p_tim_id IN hxt_timecards.id%TYPE
1642: )
1643: AS

Line 1750: p_person_id IN hxt_timecards.for_person_id%TYPE,

1746:
1747: PROCEDURE validate_tc (
1748: p_batch_id IN NUMBER,
1749: p_tim_id IN hxt_timecards.id%TYPE,
1750: p_person_id IN hxt_timecards.for_person_id%TYPE,
1751: p_period_id IN hxt_timecards.time_period_id%TYPE,
1752: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,
1753: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,
1754: p_error_level IN OUT NOCOPY NUMBER

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

1834: l_sql_error VARCHAR2 (80);
1835: l_id NUMBER;
1836: l_cnt BINARY_INTEGER;
1837:
1838: CURSOR csr_tcs_in_batch (p_batch_id hxt_timecards_f.batch_id%TYPE)
1839: IS
1840: SELECT tim.id tim_id, tim.for_person_id, tim.time_period_id,
1841: tim.approv_person_id, tim.auto_gen_flag,
1842: tim.approved_timestamp , tim.created_by,