1522: ' CALENDAR_NAME, DESCRIPTION, ENABLED_FLAG,'||
1523: ' CALENDAR_DISPLAY_CODE,'||
1524: ' PERSONAL_FLAG,'||
1525: ' READ_ONLY_FLAG'||
1526: ' FROM FEM_CALENDARS_VL@'||p_source_db_link||' A'||
1527: ' WHERE NOT EXISTS (SELECT 1'||
1528: ' FROM FEM_CALENDARS_VL'||
1529: ' WHERE CALENDAR_DISPLAY_CODE = A.CALENDAR_DISPLAY_CODE)';
1530:
1524: ' PERSONAL_FLAG,'||
1525: ' READ_ONLY_FLAG'||
1526: ' FROM FEM_CALENDARS_VL@'||p_source_db_link||' A'||
1527: ' WHERE NOT EXISTS (SELECT 1'||
1528: ' FROM FEM_CALENDARS_VL'||
1529: ' WHERE CALENDAR_DISPLAY_CODE = A.CALENDAR_DISPLAY_CODE)';
1530:
1531: TYPE INSERT_CAL_CURSOR_TYPE IS REF CURSOR;
1532:
1567: BEGIN
1568:
1569: SELECT CALENDAR_NAME
1570: INTO l_dup_cal_name
1571: FROM FEM_CALENDARS_VL
1572: WHERE CALENDAR_NAME = l_cal_name(i);
1573:
1574: EXCEPTION
1575: WHEN NO_DATA_FOUND THEN