[Home] [Help]
533: ---------------------------< populate_geo_list >-----------------------------
534: -----------------------------------------------------------------------------
535: --
536: -- Private procedure to build mapping data for GEO Hierarchy based calendar
537: -- events. This procedure refreshes data in table PER_CAL_ENTRY_GEO_LIST.
538: --
539: PROCEDURE populate_geo_list IS
540:
541: -- Cursor to get unique list of GHVs that have calendar entry coverages
662: CLOSE c_geo_ovr;
663:
664: hr_utility.set_location(l_proc,18);
665:
666: INSERT INTO per_cal_entry_geo_list
667: (calendar_entry_id
668: ,hierarchy_node_id
669: ,ovr_cal_entry_value_id
670: ,last_update_date
1020:
1021: -- Delete previous event org list records as this execution will
1022: -- refresh the list
1023: DELETE FROM per_cal_entry_org_list;
1024: DELETE FROM per_cal_entry_geo_list;
1025:
1026: hr_utility.set_location(l_proc,20);
1027:
1028: -- Generate event list for organization hierarchy coverage.
1052:
1053: hr_utility.set_location(l_proc,60);
1054:
1055: fnd_stats.gather_table_stats(ownname => l_table_owner
1056: ,tabname => 'PER_CAL_ENTRY_GEO_LIST'
1057: ,percent => 50
1058: );
1059:
1060: hr_utility.set_location('Leaving '||l_proc,70);
1173: ENT.end_hour,
1174: ENT.start_min,
1175: ENT.end_min,
1176: GEOENT.ovr_cal_entry_value_id
1177: FROM per_cal_entry_geo_list GEOENT,
1178: per_calendar_entries ENT
1179: WHERE GEOENT.hierarchy_node_id = cp_geo_node_id
1180: AND GEOENT.calendar_entry_id = ENT.calendar_entry_id
1181: AND ENT.type = NVL(cp_event_type, ENT.type)