eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_SYNC_TASK dependencies on CAC_SYNC_TASK_COMMON

Line 42: l_resources cac_sync_task_common.resource_list_tbl;

38: )
39: IS
40: -- Added a group calendar feature
41: -- Used to store the list of group resource ids for the current resource
42: l_resources cac_sync_task_common.resource_list_tbl;
43: i NUMBER := 0;
44: l_operation VARCHAR2(240);
45: l_syncanchor DATE ;
46: l_source_object_type VARCHAR2(60) := RTRIM(p_request_type,'S');

Line 111: cac_sync_task_common.get_resource_details (g_login_resource_id, l_resource_type);

107: x_totalnew := 0;
108: x_totalmodified := 0;
109: x_totaldeleted := 0;
110:
111: cac_sync_task_common.get_resource_details (g_login_resource_id, l_resource_type);
112:
113: l_syncanchor := p_syncanchor;
114: --JTA_SYNC_DEBUG_PKG.DEBUG('l_syncanchor = '||to_char(l_syncanchor,'DD-MON-YYYY HH24:MI:SS'));
115:

Line 119: cac_sync_task_common.get_group_resource (

115:
116: -----------------------------------------------------
117: -- Get group ids including current resource id
118: -----------------------------------------------------
119: cac_sync_task_common.get_group_resource (
120: p_request_type => p_request_type,
121: p_resource_id => g_login_resource_id,
122: p_resource_type => l_resource_type,
123: x_resources => l_resources

Line 141: cac_sync_task_common.get_all_nonrepeat_tasks(

137: -------------------------------------------------
138:
139:
140:
141: cac_sync_task_common.get_all_nonrepeat_tasks(
142: p_request_type => p_request_type,
143: p_syncanchor => l_syncanchor,
144: p_recordindex => NVL(x_data.count,0),
145: p_resource_id => g_login_resource_id,

Line 163: cac_sync_task_common.get_all_repeat_tasks(

159: -- Process repeating tasks
160: -------------------------------------------------
161: IF l_source_object_type = 'APPOINTMENT'
162: THEN
163: cac_sync_task_common.get_all_repeat_tasks(
164: p_request_type => p_request_type,
165: p_syncanchor => l_syncanchor,
166: p_recordindex => nvl(x_data.count,0) + 1,
167: p_resource_id => g_login_resource_id,

Line 188: cac_sync_task_common.get_all_deleted_tasks(

184: ----------------------------------
185:
186: if (trim(p_sync_type) <>'SS') then
187:
188: cac_sync_task_common.get_all_deleted_tasks(
189: p_request_type => p_request_type,
190: p_syncanchor => l_syncanchor,
191: p_recordindex => nvl(x_data.count,0) + 1,
192: p_resource_id => g_login_resource_id,

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

436: -- Fix Bug# 2387015 to avoid using contacts sequence number
437: SELECT jta_sync_task_mapping_s.nextval
438: INTO x_results (i).syncid
439: FROM DUAL;
440: x_results (i).resultid := cac_sync_task_common.g_sync_success; --success, no message will be displayed to user
441: END LOOP;
442: END create_ids;
443:
444: PROCEDURE update_data (p_tasks IN OUT NOCOPY cac_sync_task.task_tbl

Line 454: cac_sync_task_common.get_resource_details (l_resource_id, l_resource_type);

450: l_old_sync_id NUMBER;
451: l_principal_id NUMBER;
452: l_new_task_id NUMBER;
453: BEGIN
454: cac_sync_task_common.get_resource_details (l_resource_id, l_resource_type);
455:
456: g_login_resource_id := l_resource_id;
457:
458:

Line 520: l_is_this_new_task := cac_sync_task_common.is_this_new_task(p_tasks(i).syncid);

516:
517:
518: FOR i IN 1 .. NVL (p_tasks.LAST, 0)
519: LOOP
520: l_is_this_new_task := cac_sync_task_common.is_this_new_task(p_tasks(i).syncid);
521:
522: IF p_tasks(i).subject IS NOT NULL AND
523: ( ( l_is_this_new_task AND p_tasks(i).subject <> FND_API.G_MISS_CHAR) OR
524: (NOT l_is_this_new_task)

Line 530: cac_sync_task_common.create_new_data( p_task_rec => p_tasks(i)

526: THEN
527:
528: IF l_is_this_new_task
529: THEN -- This is a new task
530: cac_sync_task_common.create_new_data( p_task_rec => p_tasks(i)
531: , p_exclusion_tbl => p_exclusions
532: , p_resource_id => l_resource_id
533: , p_resource_type => l_resource_type);
534:

Line 539: if (cac_sync_task_common.is_recur_rule_same(p_task_rec=>p_tasks(i))) then

535:
536:
537: ELSE -- This is an existing task
538:
539: if (cac_sync_task_common.is_recur_rule_same(p_task_rec=>p_tasks(i))) then
540:
541: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
542:
543: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'recurrence rule is same so calling update_existing_data');

Line 546: cac_sync_task_common.update_existing_data( p_task_rec => p_tasks(i)

542:
543: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'recurrence rule is same so calling update_existing_data');
544: end if;
545:
546: cac_sync_task_common.update_existing_data( p_task_rec => p_tasks(i)
547: , p_exclusion_tbl => p_exclusions
548: , p_resource_id => l_resource_id
549: , p_resource_type => l_resource_type);
550:

Line 566: cac_sync_task_common.delete_task_data (p_task_rec=>p_tasks(i));

562:
563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'calling delete_task and then create task inside update_data');
564: end if;
565:
566: cac_sync_task_common.delete_task_data (p_task_rec=>p_tasks(i));
567:
568:
569:
570:

Line 571: cac_sync_task_common.create_new_data( p_task_rec => p_tasks(i)

567:
568:
569:
570:
571: cac_sync_task_common.create_new_data( p_task_rec => p_tasks(i)
572: , p_exclusion_tbl => p_exclusions
573: , p_resource_id => l_resource_id
574: , p_resource_type => l_resource_type);
575:

Line 578: l_new_task_id := cac_sync_task_common.get_task_id (p_sync_id => p_tasks(i).syncid);

574: , p_resource_type => l_resource_type);
575:
576:
577: --update sync mapping table with old sync_id.
578: l_new_task_id := cac_sync_task_common.get_task_id (p_sync_id => p_tasks(i).syncid);
579:
580: if (l_new_task_id is not null) then
581:
582: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 607: end if;--for if (cac_sync_task_common.is_recur_rule_same(p_task_rec=>p_tasks(i)) then

603:
604:
605: end if;-- for if (l_new_task_id is not null) then
606:
607: end if;--for if (cac_sync_task_common.is_recur_rule_same(p_task_rec=>p_tasks(i)) then
608:
609: END IF;-- for IF l_is_this_new_task
610: ELSE
611: cac_sync_common.put_messages_to_result (

Line 636: cac_sync_task_common.get_resource_details (l_resource_id, l_resource_type);

632: l_status_id NUMBER;
633: l_sync_id NUMBER;
634: l_source_object_type_code VARCHAR2(60);
635: BEGIN
636: cac_sync_task_common.get_resource_details (l_resource_id, l_resource_type);
637: g_login_resource_id := l_resource_id;
638:
639:
640:

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

642:
643:
644: FOR i IN 1 .. NVL (p_tasks.LAST, 0)
645: LOOP
646: IF cac_sync_task_common.validate_syncid(p_syncid => p_tasks(i).syncid) -- Fix Bug 2382927
647: THEN
648: fnd_msg_pub.initialize;
649:
650: l_sync_id := p_tasks (i).syncid;

Line 651: l_task_id := cac_sync_task_common.get_task_id (p_sync_id => l_sync_id);

647: THEN
648: fnd_msg_pub.initialize;
649:
650: l_sync_id := p_tasks (i).syncid;
651: l_task_id := cac_sync_task_common.get_task_id (p_sync_id => l_sync_id);
652: l_source_object_type_code := cac_sync_task_common.get_source_object_type(p_task_id => l_task_id);
653:
654:
655:

Line 652: l_source_object_type_code := cac_sync_task_common.get_source_object_type(p_task_id => l_task_id);

648: fnd_msg_pub.initialize;
649:
650: l_sync_id := p_tasks (i).syncid;
651: l_task_id := cac_sync_task_common.get_task_id (p_sync_id => l_sync_id);
652: l_source_object_type_code := cac_sync_task_common.get_source_object_type(p_task_id => l_task_id);
653:
654:
655:
656: cac_sync_task_common.check_delete_data(

Line 656: cac_sync_task_common.check_delete_data(

652: l_source_object_type_code := cac_sync_task_common.get_source_object_type(p_task_id => l_task_id);
653:
654:
655:
656: cac_sync_task_common.check_delete_data(
657: p_task_id => l_task_id,
658: p_resource_id => l_resource_id,
659: p_objectcode => l_source_object_type_code,
660: x_status_id => l_status_id,

Line 667: cac_sync_task_common.delete_task_data(p_task_rec => p_tasks(i));

663: IF l_delete_flag = 'D'
664: THEN
665:
666:
667: cac_sync_task_common.delete_task_data(p_task_rec => p_tasks(i));
668:
669: ELSIF l_delete_flag = 'U'
670:
671: THEN

Line 673: cac_sync_task_common.reject_task_data(p_task_rec => p_tasks(i));

669: ELSIF l_delete_flag = 'U'
670:
671: THEN
672:
673: cac_sync_task_common.reject_task_data(p_task_rec => p_tasks(i));
674:
675: ELSE -- l_delete_flag = 'X'
676:
677:

Line 678: p_tasks (i).syncanchor := cac_sync_task_common.convert_server_to_gmt (SYSDATE);

674:
675: ELSE -- l_delete_flag = 'X'
676:
677:
678: p_tasks (i).syncanchor := cac_sync_task_common.convert_server_to_gmt (SYSDATE);
679: cac_sync_common.put_messages_to_result (p_tasks (i),
680: p_status => cac_sync_task_common.g_sync_success,
681: p_user_message => 'JTA_SYNC_SUCCESS');
682:

Line 680: p_status => cac_sync_task_common.g_sync_success,

676:
677:
678: p_tasks (i).syncanchor := cac_sync_task_common.convert_server_to_gmt (SYSDATE);
679: cac_sync_common.put_messages_to_result (p_tasks (i),
680: p_status => cac_sync_task_common.g_sync_success,
681: p_user_message => 'JTA_SYNC_SUCCESS');
682:
683: END IF; -- l_delete_flag
684: --------------------------------------------------------------

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

687: -- the record is ignored and returned as success.
688: --------------------------------------------------------------
689: ELSE -- Cannot found sync id in mapping table
690:
691: p_tasks (i).syncanchor := cac_sync_task_common.convert_server_to_gmt (SYSDATE); -- Newly added on 04-Jun-2002 to fix bug 2382927
692: cac_sync_common.put_messages_to_result (
693: p_tasks(i),
694: p_status => cac_sync_task_common.g_sync_success,
695: p_user_message => 'JTA_SYNC_SUCCESS'

Line 694: p_status => cac_sync_task_common.g_sync_success,

690:
691: p_tasks (i).syncanchor := cac_sync_task_common.convert_server_to_gmt (SYSDATE); -- Newly added on 04-Jun-2002 to fix bug 2382927
692: cac_sync_common.put_messages_to_result (
693: p_tasks(i),
694: p_status => cac_sync_task_common.g_sync_success,
695: p_user_message => 'JTA_SYNC_SUCCESS'
696: );
697: END IF; -- cac_sync_task_common.validate_syncid(p_syncid => p_tasks(i).syncid)
698: END LOOP; -- FOR i IN 1 .. NVL (p_tasks.LAST, 0)

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

693: p_tasks(i),
694: p_status => cac_sync_task_common.g_sync_success,
695: p_user_message => 'JTA_SYNC_SUCCESS'
696: );
697: END IF; -- cac_sync_task_common.validate_syncid(p_syncid => p_tasks(i).syncid)
698: END LOOP; -- FOR i IN 1 .. NVL (p_tasks.LAST, 0)
699: commit;
700:
701: END delete_data;