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_HOLIDAY_CALENDARS

Line 540: RETURN hxt_holiday_calendars.id%TYPE

536: FUNCTION holiday_calendar_id (
537: p_person_id IN per_people_f.person_id%TYPE,
538: p_effective_date IN DATE
539: )
540: RETURN hxt_holiday_calendars.id%TYPE
541: IS
542: l_proc VARCHAR2 (72) ;
543: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
544: BEGIN

Line 543: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;

539: )
540: RETURN hxt_holiday_calendars.id%TYPE
541: IS
542: l_proc VARCHAR2 (72) ;
543: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
544: BEGIN
545: g_debug :=hr_utility.debug_enabled;
546: if g_debug then
547: l_proc := g_package

Line 576: RETURN hxt_holiday_calendars.id%TYPE

572: FUNCTION holiday_calendar_id (
573: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
574: p_effective_date IN DATE
575: )
576: RETURN hxt_holiday_calendars.id%TYPE
577: IS
578: l_proc VARCHAR2 (72) ;
579:
580: CURSOR csr_holiday_calendar_id (

Line 586: FROM hxt_holiday_calendars hhc,

582: p_effective_date DATE
583: )
584: IS
585: SELECT hhc.id
586: FROM hxt_holiday_calendars hhc,
587: hxt_earning_policies hep,
588: hxt_add_assign_info_f haaif
589: WHERE p_effective_date BETWEEN hhc.effective_start_date
590: AND hhc.effective_end_date

Line 599: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;

595: AND p_effective_date BETWEEN haaif.effective_start_date
596: AND haaif.effective_end_date
597: AND haaif.assignment_id = p_assignment_id;
598:
599: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
600: BEGIN
601: g_debug :=hr_utility.debug_enabled;
602: if g_debug then
603: l_proc := g_package

Line 623: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)

619: end if;
620: RETURN l_holiday_calendar_id;
621: END holiday_calendar_id;
622:
623: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
624: RETURN hxt_holiday_calendars.element_type_id%TYPE
625: IS
626: l_proc VARCHAR2 (72);
627:

Line 624: RETURN hxt_holiday_calendars.element_type_id%TYPE

620: RETURN l_holiday_calendar_id;
621: END holiday_calendar_id;
622:
623: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
624: RETURN hxt_holiday_calendars.element_type_id%TYPE
625: IS
626: l_proc VARCHAR2 (72);
627:
628: CURSOR csr_holiday_element_id (

Line 629: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

625: IS
626: l_proc VARCHAR2 (72);
627:
628: CURSOR csr_holiday_element_id (
629: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
630: )
631: IS
632: SELECT hhc.element_type_id
633: FROM hxt_holiday_calendars hhc

Line 633: FROM hxt_holiday_calendars hhc

629: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
630: )
631: IS
632: SELECT hhc.element_type_id
633: FROM hxt_holiday_calendars hhc
634: WHERE hhc.id = p_hol_cal_id;
635:
636: l_holiday_element_id hxt_holiday_calendars.element_type_id%TYPE;
637: BEGIN

Line 636: l_holiday_element_id hxt_holiday_calendars.element_type_id%TYPE;

632: SELECT hhc.element_type_id
633: FROM hxt_holiday_calendars hhc
634: WHERE hhc.id = p_hol_cal_id;
635:
636: l_holiday_element_id hxt_holiday_calendars.element_type_id%TYPE;
637: BEGIN
638: g_debug :=hr_utility.debug_enabled;
639: if g_debug then
640: l_proc := g_package

Line 660: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

656: RETURN l_holiday_element_id;
657: END holiday_element_id;
658:
659: FUNCTION day_is_holiday (
660: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
661: p_day IN DATE
662: )
663: RETURN BOOLEAN
664: IS

Line 668: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

664: IS
665: l_proc VARCHAR2 (72);
666:
667: CURSOR csr_holiday_today (
668: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
669: p_day DATE
670: )
671: IS
672: SELECT 1

Line 673: FROM hxt_holiday_calendars hhc, hxt_holiday_days hhd

669: p_day DATE
670: )
671: IS
672: SELECT 1
673: FROM hxt_holiday_calendars hhc, hxt_holiday_days hhd
674: WHERE hhc.id = p_hol_cal_id
675: AND hhc.id = hhd.hcl_id
676: AND hhd.holiday_date = p_day
677: AND hhd.hours >= 0;

Line 713: p_tim_id IN hxt_holiday_calendars.id%TYPE,

709: RETURN l_holiday_today;
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

Line 988: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

984: END inactive_emp_tcard;
985:
986: PROCEDURE get_holiday_info (
987: p_day IN DATE,
988: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
989: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
990: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
991: )
992: IS

Line 990: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE

986: PROCEDURE get_holiday_info (
987: p_day IN DATE,
988: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
989: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
990: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
991: )
992: IS
993: l_proc VARCHAR2 (72) := g_package
994: || 'get_holiday_info';

Line 997: p_hol_cal_id hxt_holiday_calendars.id%TYPE,

993: l_proc VARCHAR2 (72) := g_package
994: || 'get_holiday_info';
995:
996: CURSOR csr_holiday_info (
997: p_hol_cal_id hxt_holiday_calendars.id%TYPE,
998: p_day DATE
999: )
1000: IS
1001: SELECT hhd.hours, hhc.element_type_id

Line 1002: FROM hxt_holiday_days hhd, hxt_holiday_calendars hhc

998: p_day DATE
999: )
1000: IS
1001: SELECT hhd.hours, hhc.element_type_id
1002: FROM hxt_holiday_days hhd, hxt_holiday_calendars hhc
1003: WHERE hhd.holiday_date = p_day
1004: AND hhc.id = p_hol_cal_id
1005: AND hhd.hcl_id = hhc.id;
1006: BEGIN

Line 1040: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE

1036: p_person_id IN per_people_f.person_id%TYPE,
1037: p_day IN DATE,
1038: p_effective_date IN DATE,
1039: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1040: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
1041: )
1042: IS
1043: l_proc VARCHAR2 (72) ;
1044: BEGIN

Line 1124: p_hol_cal_id IN hxt_holiday_calendars.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,
1124: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1125: )
1126: IS
1127: l_proc VARCHAR2 (72) ;
1128: l_hol_hours hxt_holiday_days.hours%TYPE;

Line 1129: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;

1125: )
1126: IS
1127: l_proc VARCHAR2 (72) ;
1128: l_hol_hours hxt_holiday_days.hours%TYPE;
1129: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1130: BEGIN
1131: g_debug :=hr_utility.debug_enabled;
1132: if g_debug then
1133: l_proc := g_package

Line 1176: p_hol_cal_id IN hxt_holiday_calendars.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,
1176: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1177: )
1178: IS
1179: l_proc VARCHAR2 (72) ;
1180: BEGIN

Line 1360: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

1356: p_element_id IN pay_element_types_f.element_type_id%TYPE,
1357: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
1358: p_day IN DATE,
1359: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1360: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1361: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1362: DEFAULT NULL,
1363: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1364: DEFAULT NULL,

Line 1432: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

1428: FUNCTION sum_valid_det_hours (
1429: p_tim_id IN hxt_timecards.id%TYPE,
1430: p_day IN DATE,
1431: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1432: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1433: )
1434: RETURN NUMBER
1435: IS
1436: l_proc VARCHAR2 (72) ;

Line 1501: p_hol_cal_id IN hxt_holiday_calendars.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,
1501: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1502: )
1503: IS
1504: l_proc VARCHAR2 (72) ;
1505: l_hol_hours hxt_holiday_days.hours%TYPE;

Line 1506: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;

1502: )
1503: IS
1504: l_proc VARCHAR2 (72) ;
1505: l_hol_hours hxt_holiday_days.hours%TYPE;
1506: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1507: BEGIN
1508: g_debug :=hr_utility.debug_enabled;
1509: if g_debug then
1510: l_proc := g_package

Line 1544: p_hol_cal_id IN hxt_holiday_calendars.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,
1544: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1545: )
1546: IS
1547: l_proc VARCHAR2 (72) ;
1548: BEGIN

Line 1585: p_hol_cal_id OUT NOCOPY hxt_holiday_calendars.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,
1585: p_hol_cal_id OUT NOCOPY hxt_holiday_calendars.id%TYPE
1586: )
1587: AS
1588: l_proc VARCHAR2 (72);
1589:

Line 1590: l_hol_cal_id hxt_holiday_calendars.id%TYPE;

1586: )
1587: AS
1588: l_proc VARCHAR2 (72);
1589:
1590: l_hol_cal_id hxt_holiday_calendars.id%TYPE;
1591: BEGIN
1592:
1593: if g_debug then
1594: l_proc := g_package

Line 1666: l_hol_cal_id hxt_holiday_calendars.id%TYPE;

1662: and p1.primary_flag = 'Y'
1663: and tim.id = p_tim_id;
1664:
1665:
1666: l_hol_cal_id hxt_holiday_calendars.id%TYPE;
1667: l_no_mid_period_change varchar2(1);
1668:
1669: BEGIN
1670: