DBA Data[Home] [Help]

APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_CAL_MAP_CACHE

Line 1849: -- This procedure builds transient data into table PER_CAL_MAP_CACHE for

1845: -----------------------------------------------------------------------------
1846: -------------------------< build_cal_map_cache >-----------------------------
1847: -----------------------------------------------------------------------------
1848: --
1849: -- This procedure builds transient data into table PER_CAL_MAP_CACHE for
1850: -- use by the calendar mapping user interface.
1851: --
1852: PROCEDURE build_cal_map_cache (p_person_id IN NUMBER
1853: ,p_assignment_id IN NUMBER

Line 1878: DELETE FROM per_cal_map_cache;

1874: );
1875:
1876: hr_utility.set_location(l_proc, 20);
1877:
1878: DELETE FROM per_cal_map_cache;
1879:
1880: hr_utility.set_location(l_proc, 30);
1881:
1882: IF l_cal_event_varray.COUNT > 0 THEN

Line 1887: INSERT INTO per_cal_map_cache

1883: hr_utility.set_location(l_proc, 35);
1884:
1885: FOR idx IN l_cal_event_varray.FIRST..l_cal_event_varray.LAST LOOP
1886: l_cal_event_obj := l_cal_event_varray(idx);
1887: INSERT INTO per_cal_map_cache
1888: (person_id
1889: ,assignment_id
1890: ,event_name
1891: ,event_type