398: CLOSE c_sr_grp_owner;
399:
400: IF NOT CSM_UTIL_PKG.IS_HTML5_USER(l_user_id) THEN
401:
402: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>l_task_assignment_id,p_user_id=>l_user_id);
403:
404: -- to download other grp's resource if required
405: OPEN c_resource_id(l_user_id);
406: FETCH c_resource_id INTO l_owner_resource_id;
416: END IF;
417: END IF;
418: END IF;
419:
420: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
421: p_error_msg=>l_error_msg,
422: x_return_status=>l_return_status);
423:
424: --Notify user of Task Assignment Insert with Start Sync Event
497: IF NVL(g_task_ass_pre_upd_rec.resource_id, -1) <> NVL(jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id, -1)
498: THEN
499: -- do the purge for the old resource in the pre-hook if its a mobile resource
500: IF CSM_UTIL_PKG.is_palm_resource(g_task_ass_pre_upd_rec.resource_id) THEN
501: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,
502: p_error_msg=>l_error_msg,
503: x_return_status=>l_return_status);
504: END IF;
505: END IF;
702: OPEN l_check_acc_exists(l_task_assignment_id);
703: FETCH l_check_acc_exists INTO l_dummy;
704: IF l_check_acc_exists%NOTFOUND THEN
705: -- csm_wf_pkg.Task_Assignment_Post_Ins(l_return_status);
706: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
707: p_error_msg=>l_error_msg,
708: x_return_status=>l_return_status);
709: --call Start Sync event - Notify Client
710: RAISE_START_AUTO_SYNC_EVENT('CSM_TASK_ASSIGNMENTS',to_char(l_task_assignment_id),'NEW');
736: CSM_UTIL_PKG.LOG('Status updated to downloadable for task_assg_id:' || l_task_assignment_id ,
737: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
738:
739: -- Task_Assignment_Post_Ins( x_return_status );
740: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
741: p_error_msg=>l_error_msg,
742: x_return_status=>l_return_status);
743: RAISE_START_AUTO_SYNC_EVENT('CSM_TASK_ASSIGNMENTS',to_char(l_task_assignment_id),'NEW');
744: RETURN;
781: -- check if the new resource is a mobile resource; if it is then do a insert
782: -- the old resource is dropped in the pre-upd hook
783: IF CSM_UTIL_PKG.is_palm_resource(l_task_ass_post_upd_rec.resource_id) THEN
784: -- csm_wf_pkg.Task_Assignment_Post_Ins(l_return_status);
785: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
786: p_error_msg=>l_error_msg,
787: x_return_status=>l_return_status);
788: RAISE_START_AUTO_SYNC_EVENT('CSM_TASK_ASSIGNMENTS',to_char(l_task_assignment_id),'NEW');
789: END IF;
831: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
832: RETURN;
833: END IF;
834:
835: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,
836: p_error_msg=>l_error_msg,
837: x_return_status=>l_return_status);
838: EXCEPTION
839: WHEN OTHERS THEN
1015: csm_task_event_pkg.acc_insert(p_task_id=>l_jtf_task_id,p_user_id=>l_owner_id);
1016:
1017: for assign_rec in c_task_assignments(l_jtf_task_id)
1018: loop
1019: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>assign_rec.task_assignment_id,p_user_id=>l_owner_id);
1020:
1021: -- to download other grp's resource if required
1022: OPEN c_resource_id(l_owner_id);
1023: FETCH c_resource_id INTO l_owner_resource_id;
1045:
1046: for assign_rec in c_task_assignments(l_jtf_task_id)
1047: loop
1048:
1049: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>assign_rec.task_assignment_id,p_user_id=>l_owner_id);
1050:
1051: /*Other grp's member Resource to be deleted from acc if assigned to him*/
1052: OPEN c_resource_id(l_owner_id);
1053: FETCH c_resource_id INTO l_owner_resource_id;
1118: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1119:
1120: FOR i IN l_task_assignment_list.FIRST..l_task_assignment_list.LAST LOOP
1121: IF (CSM_UTIL_PKG.is_palm_resource(l_resource_list(i))) THEN
1122: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_list(i),
1123: p_error_msg=>l_error_msg,
1124: x_return_status=>l_return_status);
1125: /*call Start Sync event - NOTIFY CLIENT*/
1126: RAISE_START_AUTO_SYNC_EVENT('CSM_TASK_ASSIGNMENTS',to_char(l_task_assignment_list(i)),'NEW');
1146: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1147:
1148: FOR i IN l_task_assignment_list.FIRST..l_task_assignment_list.LAST LOOP
1149: IF (CSM_UTIL_PKG.is_palm_resource(l_resource_list(i))) THEN
1150: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT
1151: (p_task_assignment_id=>l_task_assignment_list(i),
1152: p_error_msg=>l_error_msg,
1153: x_return_status=>l_return_status);
1154: END IF;