DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on JTF_TASK_ASSIGNMENTS_PUB

Line 383: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

379: l_assignee_user_id NUMBER;
380:
381: BEGIN
382:
383: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
384:
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386:
387: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 475: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

471: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
472: RETURN;
473: END IF;
474:
475: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
476:
477: -- initialize the rec
478: g_task_ass_pre_upd_rec := g_null_task_ass_pre_upd_typ;
479:

Line 492: ( NOT CSM_UTIL_PKG.is_palm_resource(jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id))) THEN

488: CLOSE l_task_ass_pre_csr;
489:
490: -- if old_resource_id and new resource_id are not mobile users then return
491: IF (( NOT CSM_UTIL_PKG.is_palm_resource(g_task_ass_pre_upd_rec.resource_id)) AND
492: ( NOT CSM_UTIL_PKG.is_palm_resource(jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id))) THEN
493: RETURN;
494: END IF;
495:
496: -- And check if resource id has changed

Line 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)

493: RETURN;
494: END IF;
495:
496: -- And check if resource id has changed
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,

Line 605: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

601: l_assignee_user_id NUMBER;
602:
603: BEGIN
604:
605: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
606:
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608:
609: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 827: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

823: l_return_status VARCHAR2(2000);
824:
825: BEGIN
826:
827: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
828:
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830:
831: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN