DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_RECURRING_PERIODS

Line 1615: RETURN HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE

1611: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1612: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1613: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
1614: )
1615: RETURN HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE
1616: IS
1617:
1618: cursor csr_get_app_rec_period(
1619: p_time_recipient_id number,

Line 1630: l_recurring_period_id HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE;

1626: and hapc.approval_period_set_id = haps.approval_period_set_id
1627: and hapc.time_recipient_id = p_time_recipient_id;
1628:
1629: l_app_periods HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE;
1630: l_recurring_period_id HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE;
1631: l_day_number NUMBER;
1632: l_day_count NUMBER;
1633: l_pref_found BOOLEAN;
1634: l_day_check DATE;

Line 1756: from hxc_recurring_periods hrp

1752: cursor csr_get_rec_period_info(p_recurring_period_id number) is
1753: select hrp.start_date,
1754: hrp.period_type,
1755: hrp.duration_in_days
1756: from hxc_recurring_periods hrp
1757: where hrp.recurring_period_id = p_recurring_period_id;
1758:
1759: BEGIN
1760: