APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_TIME_BUILDING_BLOCKS

Line 1598: l_approval_style_id hxc_time_building_blocks.approval_style_id%type;

1594:
1595: l_attribute_array hxc_attribute_table_type;
1596: l_block_array hxc_block_table_type;
1597:
1598: l_approval_style_id hxc_time_building_blocks.approval_style_id%type;
1599: l_lock_rowid VARCHAR2(100) := '0';
1600: l_timecard_exists varchar2(1) := 'N';
1601:
1602: BEGIN

Line 1739: l_person_id hxc_time_building_blocks.resource_id%type;

1735: l_app_attribute_index BINARY_INTEGER;
1736: l_attribute_array hxc_attribute_table_type;
1737: l_block_array hxc_block_table_type;
1738:
1739: l_person_id hxc_time_building_blocks.resource_id%type;
1740: l_approval_style_id hxc_time_building_blocks.approval_style_id%type;
1741:
1742: l_start_date DATE;
1743: l_end_date DATE;

Line 1740: l_approval_style_id hxc_time_building_blocks.approval_style_id%type;

1736: l_attribute_array hxc_attribute_table_type;
1737: l_block_array hxc_block_table_type;
1738:
1739: l_person_id hxc_time_building_blocks.resource_id%type;
1740: l_approval_style_id hxc_time_building_blocks.approval_style_id%type;
1741:
1742: l_start_date DATE;
1743: l_end_date DATE;
1744:

Line 2276: PROCEDURE update_co_absences_ovn(p_old_bb_id IN hxc_time_building_blocks.time_building_block_id%type,

2272:
2273: END update_co_absences;
2274:
2275:
2276: PROCEDURE update_co_absences_ovn(p_old_bb_id IN hxc_time_building_blocks.time_building_block_id%type,
2277: p_new_ovn IN NUMBER,
2278: p_start_time IN DATE,
2279: p_stop_time IN DATE,
2280: p_element_id IN NUMBER )

Line 2729: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

2725:
2726: l_abs_days NUMBER;
2727: l_abs_hours NUMBER;
2728:
2729: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
2730: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
2731:
2732: -- OTL-ABS START
2733: