DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on CSM_TASK_ASSIGNMENT_EVENT_PKG

Line 410: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>l_task_assignment_id,p_user_id=>l_user_id);

406: OPEN c_sr_grp_owner(l_task_id);
407: FETCH c_sr_grp_owner INTO l_user_id;
408: CLOSE c_sr_grp_owner;
409:
410: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>l_task_assignment_id,p_user_id=>l_user_id);
411:
412: -- to download other grp's resource if required
413: OPEN c_resource_id(l_user_id);
414: FETCH c_resource_id INTO l_owner_resource_id;

Line 427: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,

423: END IF;
424: END IF;
425: END IF;
426:
427: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
428: p_error_msg=>l_error_msg,
429: x_return_status=>l_return_status);
430:
431: EXCEPTION

Line 505: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,

501: IF NVL(g_task_ass_pre_upd_rec.resource_id, -1) <> NVL(jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id, -1)
502: THEN
503: -- do the purge for the old resource in the pre-hook if its a mobile resource
504: IF CSM_UTIL_PKG.is_palm_resource(g_task_ass_pre_upd_rec.resource_id) THEN
505: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,
506: p_error_msg=>l_error_msg,
507: x_return_status=>l_return_status);
508: END IF;
509: END IF;

Line 717: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,

713: OPEN l_check_acc_exists(l_task_assignment_id);
714: FETCH l_check_acc_exists INTO l_dummy;
715: IF l_check_acc_exists%NOTFOUND THEN
716: -- csm_wf_pkg.Task_Assignment_Post_Ins(l_return_status);
717: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
718: p_error_msg=>l_error_msg,
719: x_return_status=>l_return_status);
720: CLOSE l_check_acc_exists;
721: RETURN;

Line 747: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,

743: CSM_UTIL_PKG.LOG('Status updated to downloadable for task_assg_id:' || l_task_assignment_id ,
744: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
745:
746: -- Task_Assignment_Post_Ins( x_return_status );
747: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
748: p_error_msg=>l_error_msg,
749: x_return_status=>l_return_status);
750: RETURN;
751: END IF;

Line 789: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,

785: -- check if the new resource is a mobile resource; if it is then do a insert
786: -- the old resource is dropped in the pre-upd hook
787: IF CSM_UTIL_PKG.is_palm_resource(l_task_ass_post_upd_rec.resource_id) THEN
788: -- csm_wf_pkg.Task_Assignment_Post_Ins(l_return_status);
789: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
790: p_error_msg=>l_error_msg,
791: x_return_status=>l_return_status);
792: END IF;
793: END IF;

Line 837: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,

833: END IF;
834:
835: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
836:
837: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,
838: p_error_msg=>l_error_msg,
839: x_return_status=>l_return_status);
840: EXCEPTION
841: WHEN OTHERS THEN

Line 1025: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>assign_rec.task_assignment_id,p_user_id=>l_owner_id);

1021: csm_task_event_pkg.acc_insert(p_task_id=>l_jtf_task_id,p_user_id=>l_owner_id);
1022:
1023: for assign_rec in c_task_assignments(l_jtf_task_id)
1024: loop
1025: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>assign_rec.task_assignment_id,p_user_id=>l_owner_id);
1026:
1027: -- to download other grp's resource if required
1028: OPEN c_resource_id(l_owner_id);
1029: FETCH c_resource_id INTO l_owner_resource_id;

Line 1053: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>assign_rec.task_assignment_id,p_user_id=>l_owner_id);

1049:
1050: for assign_rec in c_task_assignments(l_jtf_task_id)
1051: loop
1052:
1053: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>assign_rec.task_assignment_id,p_user_id=>l_owner_id);
1054:
1055: /*Other grp's member Resource to be deleted from acc if assigned to him*/
1056: OPEN c_resource_id(l_owner_id);
1057: FETCH c_resource_id INTO l_owner_resource_id;

Line 1125: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_list(i),

1121: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1122:
1123: FOR i IN l_task_assignment_list.FIRST..l_task_assignment_list.LAST LOOP
1124: IF (CSM_UTIL_PKG.is_palm_resource(l_resource_list(i))) THEN
1125: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_list(i),
1126: p_error_msg=>l_error_msg,
1127: x_return_status=>l_return_status);
1128:
1129: END IF;

Line 1151: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT

1147: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1148:
1149: FOR i IN l_task_assignment_list.FIRST..l_task_assignment_list.LAST LOOP
1150: IF (CSM_UTIL_PKG.is_palm_resource(l_resource_list(i))) THEN
1151: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT
1152: (p_task_assignment_id=>l_task_assignment_list(i),
1153: p_error_msg=>l_error_msg,
1154: x_return_status=>l_return_status);
1155: END IF;