DBA Data[Home] [Help]

APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_CAL_MAP_CACHE

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

1883: -----------------------------------------------------------------------------
1884: -------------------------< build_cal_map_cache >-----------------------------
1885: -----------------------------------------------------------------------------
1886: --
1887: -- This procedure builds transient data into table PER_CAL_MAP_CACHE for
1888: -- use by the calendar mapping user interface.
1889: --
1890: PROCEDURE build_cal_map_cache (p_person_id IN NUMBER
1891: ,p_assignment_id IN NUMBER

Line 1916: DELETE FROM per_cal_map_cache;

1912: );
1913:
1914: hr_utility.set_location(l_proc, 20);
1915:
1916: DELETE FROM per_cal_map_cache;
1917:
1918: hr_utility.set_location(l_proc, 30);
1919:
1920: IF l_cal_event_varray.COUNT > 0 THEN

Line 1925: INSERT INTO per_cal_map_cache

1921: hr_utility.set_location(l_proc, 35);
1922:
1923: FOR idx IN l_cal_event_varray.FIRST..l_cal_event_varray.LAST LOOP
1924: l_cal_event_obj := l_cal_event_varray(idx);
1925: INSERT INTO per_cal_map_cache
1926: (person_id
1927: ,assignment_id
1928: ,event_name
1929: ,event_type