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 602: RETURN hxt_holiday_calendars.id%TYPE

598: FUNCTION holiday_calendar_id (
599: p_person_id IN per_people_f.person_id%TYPE,
600: p_effective_date IN DATE
601: )
602: RETURN hxt_holiday_calendars.id%TYPE
603: IS
604: l_proc VARCHAR2 (72) ;
605: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
606: BEGIN

Line 605: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;

601: )
602: RETURN hxt_holiday_calendars.id%TYPE
603: IS
604: l_proc VARCHAR2 (72) ;
605: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
606: BEGIN
607: g_debug :=hr_utility.debug_enabled;
608: if g_debug then
609: l_proc := g_package

Line 638: RETURN hxt_holiday_calendars.id%TYPE

634: FUNCTION holiday_calendar_id (
635: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
636: p_effective_date IN DATE
637: )
638: RETURN hxt_holiday_calendars.id%TYPE
639: IS
640: l_proc VARCHAR2 (72) ;
641:
642: CURSOR csr_holiday_calendar_id (

Line 648: FROM hxt_holiday_calendars hhc,

644: p_effective_date DATE
645: )
646: IS
647: SELECT hhc.id
648: FROM hxt_holiday_calendars hhc,
649: hxt_earning_policies hep,
650: hxt_add_assign_info_f haaif
651: WHERE p_effective_date BETWEEN hhc.effective_start_date
652: AND hhc.effective_end_date

Line 661: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;

657: AND p_effective_date BETWEEN haaif.effective_start_date
658: AND haaif.effective_end_date
659: AND haaif.assignment_id = p_assignment_id;
660:
661: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
662: BEGIN
663: g_debug :=hr_utility.debug_enabled;
664: if g_debug then
665: l_proc := g_package

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

681: end if;
682: RETURN l_holiday_calendar_id;
683: END holiday_calendar_id;
684:
685: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
686: RETURN hxt_holiday_calendars.element_type_id%TYPE
687: IS
688: l_proc VARCHAR2 (72);
689:

Line 686: RETURN hxt_holiday_calendars.element_type_id%TYPE

682: RETURN l_holiday_calendar_id;
683: END holiday_calendar_id;
684:
685: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
686: RETURN hxt_holiday_calendars.element_type_id%TYPE
687: IS
688: l_proc VARCHAR2 (72);
689:
690: CURSOR csr_holiday_element_id (

Line 691: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

687: IS
688: l_proc VARCHAR2 (72);
689:
690: CURSOR csr_holiday_element_id (
691: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
692: )
693: IS
694: SELECT hhc.element_type_id
695: FROM hxt_holiday_calendars hhc

Line 695: FROM hxt_holiday_calendars hhc

691: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
692: )
693: IS
694: SELECT hhc.element_type_id
695: FROM hxt_holiday_calendars hhc
696: WHERE hhc.id = p_hol_cal_id;
697:
698: l_holiday_element_id hxt_holiday_calendars.element_type_id%TYPE;
699: BEGIN

Line 698: l_holiday_element_id hxt_holiday_calendars.element_type_id%TYPE;

694: SELECT hhc.element_type_id
695: FROM hxt_holiday_calendars hhc
696: WHERE hhc.id = p_hol_cal_id;
697:
698: l_holiday_element_id hxt_holiday_calendars.element_type_id%TYPE;
699: BEGIN
700: g_debug :=hr_utility.debug_enabled;
701: if g_debug then
702: l_proc := g_package

Line 722: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

718: RETURN l_holiday_element_id;
719: END holiday_element_id;
720:
721: FUNCTION day_is_holiday (
722: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
723: p_day IN DATE
724: )
725: RETURN BOOLEAN
726: IS

Line 730: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

726: IS
727: l_proc VARCHAR2 (72);
728:
729: CURSOR csr_holiday_today (
730: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
731: p_day DATE
732: )
733: IS
734: SELECT 1

Line 735: FROM hxt_holiday_calendars hhc, hxt_holiday_days hhd

731: p_day DATE
732: )
733: IS
734: SELECT 1
735: FROM hxt_holiday_calendars hhc, hxt_holiday_days hhd
736: WHERE hhc.id = p_hol_cal_id
737: AND hhc.id = hhd.hcl_id
738: AND hhd.holiday_date = p_day
739: AND hhd.hours >= 0;

Line 775: p_tim_id IN hxt_holiday_calendars.id%TYPE,

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

Line 1109: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

1105: END inactive_emp_tcard;
1106:
1107: PROCEDURE get_holiday_info (
1108: p_day IN DATE,
1109: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1110: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1111: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
1112: )
1113: IS

Line 1111: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE

1107: PROCEDURE get_holiday_info (
1108: p_day IN DATE,
1109: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1110: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1111: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
1112: )
1113: IS
1114: l_proc VARCHAR2 (72) := g_package
1115: || 'get_holiday_info';

Line 1118: p_hol_cal_id hxt_holiday_calendars.id%TYPE,

1114: l_proc VARCHAR2 (72) := g_package
1115: || 'get_holiday_info';
1116:
1117: CURSOR csr_holiday_info (
1118: p_hol_cal_id hxt_holiday_calendars.id%TYPE,
1119: p_day DATE
1120: )
1121: IS
1122: SELECT hhd.hours, hhc.element_type_id

Line 1123: FROM hxt_holiday_days hhd, hxt_holiday_calendars hhc

1119: p_day DATE
1120: )
1121: IS
1122: SELECT hhd.hours, hhc.element_type_id
1123: FROM hxt_holiday_days hhd, hxt_holiday_calendars hhc
1124: WHERE hhd.holiday_date = p_day
1125: AND hhc.id = p_hol_cal_id
1126: AND hhd.hcl_id = hhc.id;
1127: BEGIN

Line 1161: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE

1157: p_person_id IN per_people_f.person_id%TYPE,
1158: p_day IN DATE,
1159: p_effective_date IN DATE,
1160: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1161: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
1162: )
1163: IS
1164: l_proc VARCHAR2 (72) ;
1165: BEGIN

Line 1245: p_hol_cal_id IN hxt_holiday_calendars.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,
1245: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1246: )
1247: IS
1248: l_proc VARCHAR2 (72) ;
1249: l_hol_hours hxt_holiday_days.hours%TYPE;

Line 1250: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;

1246: )
1247: IS
1248: l_proc VARCHAR2 (72) ;
1249: l_hol_hours hxt_holiday_days.hours%TYPE;
1250: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1251: BEGIN
1252: g_debug :=hr_utility.debug_enabled;
1253: if g_debug then
1254: l_proc := g_package

Line 1327: p_hol_cal_id IN hxt_holiday_calendars.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,
1327: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1328: )
1329: IS
1330: l_proc VARCHAR2 (72) ;
1331: BEGIN

Line 1540: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

1536: p_element_id IN pay_element_types_f.element_type_id%TYPE,
1537: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
1538: p_day IN DATE,
1539: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1540: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1541: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1542: DEFAULT NULL,
1543: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1544: DEFAULT NULL,

Line 1612: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

1608: FUNCTION sum_valid_det_hours (
1609: p_tim_id IN hxt_timecards.id%TYPE,
1610: p_day IN DATE,
1611: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1612: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1613: )
1614: RETURN NUMBER
1615: IS
1616: l_proc VARCHAR2 (72) ;

Line 1681: p_hol_cal_id IN hxt_holiday_calendars.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,
1681: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1682: )
1683: IS
1684: l_proc VARCHAR2 (72) ;
1685: l_hol_hours hxt_holiday_days.hours%TYPE;

Line 1686: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;

1682: )
1683: IS
1684: l_proc VARCHAR2 (72) ;
1685: l_hol_hours hxt_holiday_days.hours%TYPE;
1686: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1687: BEGIN
1688: g_debug :=hr_utility.debug_enabled;
1689: if g_debug then
1690: l_proc := g_package

Line 1751: p_hol_cal_id IN hxt_holiday_calendars.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,
1751: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1752: )
1753: IS
1754: l_proc VARCHAR2 (72) ;
1755: BEGIN

Line 1820: p_hol_cal_id OUT NOCOPY hxt_holiday_calendars.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,
1820: p_hol_cal_id OUT NOCOPY hxt_holiday_calendars.id%TYPE
1821: )
1822: AS
1823: l_proc VARCHAR2 (72);
1824:

Line 1825: l_hol_cal_id hxt_holiday_calendars.id%TYPE;

1821: )
1822: AS
1823: l_proc VARCHAR2 (72);
1824:
1825: l_hol_cal_id hxt_holiday_calendars.id%TYPE;
1826: BEGIN
1827:
1828: if g_debug then
1829: l_proc := g_package

Line 1901: l_hol_cal_id hxt_holiday_calendars.id%TYPE;

1897: and p1.primary_flag = 'Y'
1898: and tim.id = p_tim_id;
1899:
1900:
1901: l_hol_cal_id hxt_holiday_calendars.id%TYPE;
1902: l_no_mid_period_change varchar2(1);
1903:
1904: BEGIN
1905:

Line 2228: FROM hxt_holiday_calendars

2224: RETURN g_holiday_calendar(p_hcl_id);
2225: ELSE
2226: SELECT name
2227: INTO g_holiday_calendar(p_hcl_id)
2228: FROM hxt_holiday_calendars
2229: WHERE id = p_hcl_id ;
2230: RETURN g_holiday_calendar(p_hcl_id);
2231: END IF;
2232: END holiday_calendar_name;