DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK dependencies on JTA_SYNC_TASK_COMMON

Line 48: | 24-Apr-2002 cjang When jta_sync_task_common.get_all_nonrepeat_tasks

44: | 06-Mar-2002 cjang Modularize UPDATE_DATA() |
45: | GET_ALL_DATA() |
46: | 11-Mar-2002 cjang Modified delete_data |
47: | 11-Mar-2002 sanjeev Changed methods for exclusions |
48: | 24-Apr-2002 cjang When jta_sync_task_common.get_all_nonrepeat_tasks
49: | is called, pass p_record_index with NVL(x_data.count,0)
50: | 26-Apr-2002 cjang Commented out debug statements |
51: | 30-Apr-2002 cjang Added if condition to check if subject |
52: | is null. |

Line 81: l_resources jta_sync_task_common.resource_list_tbl;

77: )
78: IS
79: -- Added a group calendar feature
80: -- Used to store the list of group resource ids for the current resource
81: l_resources jta_sync_task_common.resource_list_tbl;
82: i NUMBER := 0;
83: l_operation VARCHAR2(240);
84: l_syncanchor DATE ;
85: l_source_object_type VARCHAR2(60) := RTRIM(p_request_type,'S');

Line 96: jta_sync_task_common.get_resource_details (g_login_resource_id, l_resource_type);

92: x_totalnew := 0;
93: x_totalmodified := 0;
94: x_totaldeleted := 0;
95:
96: jta_sync_task_common.get_resource_details (g_login_resource_id, l_resource_type);
97:
98: l_syncanchor := jta_sync_task_common.convert_gmt_to_server (p_syncanchor);
99: --JTA_SYNC_DEBUG_PKG.DEBUG('l_syncanchor = '||to_char(l_syncanchor,'DD-MON-YYYY HH24:MI:SS'));
100:

Line 98: l_syncanchor := jta_sync_task_common.convert_gmt_to_server (p_syncanchor);

94: x_totaldeleted := 0;
95:
96: jta_sync_task_common.get_resource_details (g_login_resource_id, l_resource_type);
97:
98: l_syncanchor := jta_sync_task_common.convert_gmt_to_server (p_syncanchor);
99: --JTA_SYNC_DEBUG_PKG.DEBUG('l_syncanchor = '||to_char(l_syncanchor,'DD-MON-YYYY HH24:MI:SS'));
100:
101: -----------------------------------------------------
102: -- Get group ids including current resource id

Line 104: jta_sync_task_common.get_group_resource (

100:
101: -----------------------------------------------------
102: -- Get group ids including current resource id
103: -----------------------------------------------------
104: jta_sync_task_common.get_group_resource (
105: p_request_type => p_request_type,
106: p_resource_id => g_login_resource_id,
107: p_resource_type => l_resource_type,
108: x_resources => l_resources

Line 121: jta_sync_task_common.get_all_nonrepeat_tasks(

117: LOOP
118: -------------------------------------------------
119: -- Process non repeat tasks
120: -------------------------------------------------
121: jta_sync_task_common.get_all_nonrepeat_tasks(
122: p_request_type => p_request_type,
123: p_syncanchor => l_syncanchor,
124: p_recordindex => NVL(x_data.count,0),
125: p_resource_id => l_resources(j).resource_id,

Line 141: jta_sync_task_common.get_all_repeat_tasks(

137: -- Process repeating tasks
138: -------------------------------------------------
139: IF l_source_object_type = 'APPOINTMENT'
140: THEN
141: jta_sync_task_common.get_all_repeat_tasks(
142: p_request_type => p_request_type,
143: p_syncanchor => l_syncanchor,
144: p_recordindex => nvl(x_data.count,0) + 1,
145: p_resource_id => l_resources(j).resource_id,

Line 161: jta_sync_task_common.get_all_deleted_tasks(

157:
158: ----------------------------------
159: -- processing all deleted records
160: ----------------------------------
161: jta_sync_task_common.get_all_deleted_tasks(
162: p_request_type => p_request_type,
163: p_syncanchor => l_syncanchor,
164: p_recordindex => nvl(x_data.count,0) + 1,
165: p_resource_id => l_resources(j).resource_id,

Line 252: x_results (i).resultid := jta_sync_task_common.g_sync_success; --success, no message will be displayed to user

248: -- Fix Bug# 2387015 to avoid using contacts sequence number
249: SELECT jta_sync_task_mapping_s.nextval
250: INTO x_results (i).syncid
251: FROM DUAL;
252: x_results (i).resultid := jta_sync_task_common.g_sync_success; --success, no message will be displayed to user
253: END LOOP;
254: END create_ids;
255:
256: PROCEDURE update_data (p_tasks IN OUT NOCOPY jta_sync_task.task_tbl

Line 263: jta_sync_task_common.get_resource_details (l_resource_id, l_resource_type);

259: l_resource_id NUMBER;
260: l_resource_type VARCHAR2(100);
261: l_is_this_new_task BOOLEAN;
262: BEGIN
263: jta_sync_task_common.get_resource_details (l_resource_id, l_resource_type);
264:
265: g_login_resource_id := l_resource_id;
266:
267: FOR i IN 1 .. NVL (p_tasks.LAST, 0)

Line 269: l_is_this_new_task := jta_sync_task_common.is_this_new_task(p_tasks(i).syncid);

265: g_login_resource_id := l_resource_id;
266:
267: FOR i IN 1 .. NVL (p_tasks.LAST, 0)
268: LOOP
269: l_is_this_new_task := jta_sync_task_common.is_this_new_task(p_tasks(i).syncid);
270:
271: IF p_tasks(i).subject IS NOT NULL AND
272: ( ( l_is_this_new_task AND p_tasks(i).subject <> FND_API.G_MISS_CHAR) OR
273: (NOT l_is_this_new_task)

Line 285: jta_sync_task_common.create_new_data( p_task_rec => p_tasks(i)

281: END IF;
282:
283: IF l_is_this_new_task
284: THEN -- This is a new task
285: jta_sync_task_common.create_new_data( p_task_rec => p_tasks(i)
286: , p_exclusion_tbl => p_exclusions
287: , p_resource_id => l_resource_id
288: , p_resource_type => l_resource_type);
289: ELSE -- This is an existing task

Line 290: jta_sync_task_common.update_existing_data( p_task_rec => p_tasks(i)

286: , p_exclusion_tbl => p_exclusions
287: , p_resource_id => l_resource_id
288: , p_resource_type => l_resource_type);
289: ELSE -- This is an existing task
290: jta_sync_task_common.update_existing_data( p_task_rec => p_tasks(i)
291: , p_exclusion_tbl => p_exclusions
292: , p_resource_id => l_resource_id
293: , p_resource_type => l_resource_type);
294: END IF;

Line 319: jta_sync_task_common.get_resource_details (l_resource_id, l_resource_type);

315: l_status_id NUMBER;
316: l_sync_id NUMBER;
317: l_source_object_type_code VARCHAR2(60);
318: BEGIN
319: jta_sync_task_common.get_resource_details (l_resource_id, l_resource_type);
320: g_login_resource_id := l_resource_id;
321:
322: FOR i IN 1 .. NVL (p_tasks.LAST, 0)
323: LOOP

Line 324: IF jta_sync_task_common.validate_syncid(p_syncid => p_tasks(i).syncid) -- Fix Bug 2382927

320: g_login_resource_id := l_resource_id;
321:
322: FOR i IN 1 .. NVL (p_tasks.LAST, 0)
323: LOOP
324: IF jta_sync_task_common.validate_syncid(p_syncid => p_tasks(i).syncid) -- Fix Bug 2382927
325: THEN
326: fnd_msg_pub.initialize;
327:
328: l_sync_id := p_tasks (i).syncid;

Line 329: l_task_id := jta_sync_task_common.get_task_id (p_sync_id => l_sync_id);

325: THEN
326: fnd_msg_pub.initialize;
327:
328: l_sync_id := p_tasks (i).syncid;
329: l_task_id := jta_sync_task_common.get_task_id (p_sync_id => l_sync_id);
330: l_source_object_type_code := jta_sync_task_common.get_source_object_type(p_task_id => l_task_id);
331:
332: jta_sync_task_common.check_delete_data(
333: p_task_id => l_task_id,

Line 330: l_source_object_type_code := jta_sync_task_common.get_source_object_type(p_task_id => l_task_id);

326: fnd_msg_pub.initialize;
327:
328: l_sync_id := p_tasks (i).syncid;
329: l_task_id := jta_sync_task_common.get_task_id (p_sync_id => l_sync_id);
330: l_source_object_type_code := jta_sync_task_common.get_source_object_type(p_task_id => l_task_id);
331:
332: jta_sync_task_common.check_delete_data(
333: p_task_id => l_task_id,
334: p_resource_id => l_resource_id,

Line 332: jta_sync_task_common.check_delete_data(

328: l_sync_id := p_tasks (i).syncid;
329: l_task_id := jta_sync_task_common.get_task_id (p_sync_id => l_sync_id);
330: l_source_object_type_code := jta_sync_task_common.get_source_object_type(p_task_id => l_task_id);
331:
332: jta_sync_task_common.check_delete_data(
333: p_task_id => l_task_id,
334: p_resource_id => l_resource_id,
335: p_objectcode => l_source_object_type_code,
336: x_status_id => l_status_id,

Line 342: jta_sync_task_common.delete_task_data(p_task_rec => p_tasks(i));

338:
339: IF l_delete_flag = 'D'
340: THEN
341:
342: jta_sync_task_common.delete_task_data(p_task_rec => p_tasks(i));
343:
344: ELSIF l_delete_flag = 'U'
345:
346: THEN

Line 347: jta_sync_task_common.reject_task_data(p_task_rec => p_tasks(i));

343:
344: ELSIF l_delete_flag = 'U'
345:
346: THEN
347: jta_sync_task_common.reject_task_data(p_task_rec => p_tasks(i));
348:
349: ELSE -- l_delete_flag = 'X'
350:
351: p_tasks (i).syncanchor := jta_sync_task_common.convert_server_to_gmt (SYSDATE);

Line 351: p_tasks (i).syncanchor := jta_sync_task_common.convert_server_to_gmt (SYSDATE);

347: jta_sync_task_common.reject_task_data(p_task_rec => p_tasks(i));
348:
349: ELSE -- l_delete_flag = 'X'
350:
351: p_tasks (i).syncanchor := jta_sync_task_common.convert_server_to_gmt (SYSDATE);
352: jta_sync_common.put_messages_to_result (p_tasks (i),
353: p_status => jta_sync_task_common.g_sync_success,
354: p_user_message => 'JTA_SYNC_SUCCESS');
355:

Line 353: p_status => jta_sync_task_common.g_sync_success,

349: ELSE -- l_delete_flag = 'X'
350:
351: p_tasks (i).syncanchor := jta_sync_task_common.convert_server_to_gmt (SYSDATE);
352: jta_sync_common.put_messages_to_result (p_tasks (i),
353: p_status => jta_sync_task_common.g_sync_success,
354: p_user_message => 'JTA_SYNC_SUCCESS');
355:
356: END IF; -- l_delete_flag
357: --------------------------------------------------------------

Line 363: p_tasks (i).syncanchor := jta_sync_task_common.convert_server_to_gmt (SYSDATE); -- Newly added on 04-Jun-2002 to fix bug 2382927

359: -- When Intellisync sends a sync id which has not been synced,
360: -- the record is ignored and returned as success.
361: --------------------------------------------------------------
362: ELSE -- Cannot found sync id in mapping table
363: p_tasks (i).syncanchor := jta_sync_task_common.convert_server_to_gmt (SYSDATE); -- Newly added on 04-Jun-2002 to fix bug 2382927
364: jta_sync_common.put_messages_to_result (
365: p_tasks(i),
366: p_status => jta_sync_task_common.g_sync_success,
367: p_user_message => 'JTA_SYNC_SUCCESS'

Line 366: p_status => jta_sync_task_common.g_sync_success,

362: ELSE -- Cannot found sync id in mapping table
363: p_tasks (i).syncanchor := jta_sync_task_common.convert_server_to_gmt (SYSDATE); -- Newly added on 04-Jun-2002 to fix bug 2382927
364: jta_sync_common.put_messages_to_result (
365: p_tasks(i),
366: p_status => jta_sync_task_common.g_sync_success,
367: p_user_message => 'JTA_SYNC_SUCCESS'
368: );
369: END IF; -- jta_sync_task_common.validate_syncid(p_syncid => p_tasks(i).syncid)
370: END LOOP; -- FOR i IN 1 .. NVL (p_tasks.LAST, 0)

Line 369: END IF; -- jta_sync_task_common.validate_syncid(p_syncid => p_tasks(i).syncid)

365: p_tasks(i),
366: p_status => jta_sync_task_common.g_sync_success,
367: p_user_message => 'JTA_SYNC_SUCCESS'
368: );
369: END IF; -- jta_sync_task_common.validate_syncid(p_syncid => p_tasks(i).syncid)
370: END LOOP; -- FOR i IN 1 .. NVL (p_tasks.LAST, 0)
371:
372: END delete_data;
373: