The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 29-Jan-2002 arpatel/chanik Added a cursor to find date_selected |
| 30-Jan-2002 arpatel/chanik Added p_event in get_list_xxxx() |
| 01-Feb-2002 arpatel/chanik Removed object_type_code clause from |
| get_list_appt cursor |
| 04-Feb-2002 akaran/sachoudh Added function get_event_type() |
| 05-Feb-2002 arpatel Added nvl for flags |
| 12-Feb-2002 cjang Added group calendar functionality |
| 20-Feb-2002 cjang The followings are not synced |
| 1) Change from Task to Appt |
| 2) Change from Appt to Task |
| Removed event_type and object |
| from cursor c_task |
| 22-Feb-2002 cjang Refactoring |
| 27-Feb-2002 cjang Added a function to check the update |
| privilege |
| 27-Feb-2002 arpatel Changed update_data to handle updates |
| of descriptions for repeating apmts |
| 27-Feb-2002 cjang Added separate loop for repeating task |
| 28-Feb-2002 cjang Integrate with invitee function |
| 01-Mar-2002 cjang Refactoring and Bug Fix |
| 06-Mar-2002 cjang Modularize UPDATE_DATA() |
| GET_ALL_DATA() |
| 11-Mar-2002 cjang Modified delete_data |
| 11-Mar-2002 sanjeev Changed methods for exclusions |
| 24-Apr-2002 cjang When jta_sync_task_common.get_all_nonrepeat_tasks
| is called, pass p_record_index with NVL(x_data.count,0)
| 26-Apr-2002 cjang Commented out debug statements |
| 30-Apr-2002 cjang Added if condition to check if subject |
| is null. |
| We're not accepting NULL task name |
| 23-May-2002 cjang Modified delete_data() |
| to fix bug 2382927 |
| 28-May-2002 cjang Modified create_ids() |
| Fix Bug# 2387015 |
| to avoid using contacts sequence number|
| 04-Jun-2002 cjang Modified delete_data() |
| to fix bug 2382927 |
| For the invalid syncid, new sync anchor|
| must be assigned |
+======================================================================*/
-------------------------------
-- Private Method
-------------------------------
PROCEDURE get_all_data (
p_request_type IN VARCHAR2,
p_syncanchor IN DATE,
p_get_data IN BOOLEAN,
x_totalnew OUT NOCOPY NUMBER,
x_totalmodified OUT NOCOPY NUMBER,
x_totaldeleted OUT NOCOPY NUMBER,
x_data OUT NOCOPY jta_sync_task.task_tbl,
x_exclusion_data OUT NOCOPY Jta_Sync_Task.exclusion_tbl
)
IS
-- Added a group calendar feature
-- Used to store the list of group resource ids for the current resource
l_resources jta_sync_task_common.resource_list_tbl;
x_totaldeleted := 0;
jta_sync_task_common.get_all_deleted_tasks(
p_request_type => p_request_type,
p_syncanchor => l_syncanchor,
p_recordindex => nvl(x_data.count,0) + 1,
p_resource_id => l_resources(j).resource_id,
p_resource_type => l_resources(j).resource_type,
p_source_object_type => l_source_object_type,
p_get_data => p_get_data,
--p_new_syncanchor => l_new_syncanchor,
x_totaldeleted => x_totaldeleted,
x_data => x_data
);
x_totaldeleted OUT NOCOPY NUMBER
)
IS
l_syncanchor DATE;
x_totaldeleted := 0;
x_totaldeleted => x_totaldeleted,
x_data => l_data,
x_exclusion_data => l_exclusion_data
);
x_total := x_totalnew + x_totalmodified + x_totaldeleted;
l_totaldeleted NUMBER;
x_totaldeleted => l_totaldeleted,
x_data => l_data,
x_exclusion_data => x_exclusion_data
);
SELECT jta_sync_task_mapping_s.nextval
INTO x_results (i).syncid
FROM DUAL;
PROCEDURE update_data (p_tasks IN OUT NOCOPY jta_sync_task.task_tbl
,p_exclusions IN jta_sync_task.exclusion_tbl)
IS
l_resource_id NUMBER;
jta_sync_task_common.update_existing_data( p_task_rec => p_tasks(i)
, p_exclusion_tbl => p_exclusions
, p_resource_id => l_resource_id
, p_resource_type => l_resource_type);
END update_data;
PROCEDURE delete_data (
p_tasks IN OUT NOCOPY jta_sync_task.task_tbl
)
IS
l_task_id NUMBER;
l_delete_flag VARCHAR2(1);
jta_sync_task_common.check_delete_data(
p_task_id => l_task_id,
p_resource_id => l_resource_id,
p_objectcode => l_source_object_type_code,
x_status_id => l_status_id,
x_delete_flag => l_delete_flag);
IF l_delete_flag = 'D'
THEN
jta_sync_task_common.delete_task_data(p_task_rec => p_tasks(i));
ELSIF l_delete_flag = 'U'
THEN
jta_sync_task_common.reject_task_data(p_task_rec => p_tasks(i));
ELSE -- l_delete_flag = 'X'
p_tasks (i).syncanchor := jta_sync_task_common.convert_server_to_gmt (SYSDATE);
END IF; -- l_delete_flag
END delete_data;