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.CSM_WF_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 373: from JTF_TASK_ASSIGNMENTS

369:
370: CURSOR c_task(b_task_assignment_id NUMBER)
371: IS
372: select task_id,resource_id
373: from JTF_TASK_ASSIGNMENTS
374: where TASK_ASSIGNMENT_ID=b_task_assignment_id;
375:
376:
377:

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

394: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
395: RETURN;
396: END IF;
397:
398: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
399:
400: --12.1
401: open c_task(l_task_assignment_id);
402: fetch c_task into l_task_id,l_assignee_id;

Line 444: JTF_TASK_ASSIGNMENTS_IUHK.update_task_assignment_pre

440:
441: /*-----------------------------------------------------------------
442: Description:
443: Start the TASK_ASSIGNMENT_UPD process. Called by
444: JTF_TASK_ASSIGNMENTS_IUHK.update_task_assignment_pre
445: We retrieve the old record by selecting from db with task_assignment_id
446: Then, we compare the old resource id and new resource id for whether the resource has changed.
447: Parameter(s):
448: x_return_status

Line 463: FROM JTF_TASK_ASSIGNMENTS

459: l_return_status VARCHAR2(2000);
460:
461: CURSOR l_task_ass_pre_csr (b_task_assignment_id NUMBER) IS
462: SELECT RESOURCE_ID, assignment_status_id, task_id
463: FROM JTF_TASK_ASSIGNMENTS
464: WHERE TASK_ASSIGNMENT_ID = b_task_assignment_id;
465:
466: CURSOR l_get_user_id(p_resource_id IN NUMBER)
467: IS

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

475: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
476: RETURN;
477: END IF;
478:
479: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
480:
481: -- initialize the rec
482: g_task_ass_pre_upd_rec := g_null_task_ass_pre_upd_typ;
483:

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

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

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

497: RETURN;
498: END IF;
499:
500: -- And check if resource id has changed
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,

Line 542: FROM JTF_TASK_ASSIGNMENTS

538:
539: CURSOR l_task_ass_post_csr (b_task_assignment_id NUMBER)
540: IS
541: SELECT RESOURCE_ID, assignment_status_id, task_id
542: FROM JTF_TASK_ASSIGNMENTS
543: WHERE TASK_ASSIGNMENT_ID = b_task_assignment_id;
544:
545: l_task_ass_post_upd_rec l_task_ass_post_csr%ROWTYPE;
546: l_null_task_ass_post_upd_rec l_task_ass_post_csr%ROWTYPE;

Line 589: from JTF_TASK_ASSIGNMENTS

585:
586: CURSOR c_task(b_task_assignment_id NUMBER)
587: IS
588: select task_id
589: from JTF_TASK_ASSIGNMENTS
590: where TASK_ASSIGNMENT_ID=b_task_assignment_id;
591:
592:
593: CURSOR c_resource_id(b_user_id NUMBER) IS

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

616: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
617: RETURN;
618: END IF;
619:
620: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
621:
622: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.Task_Assignment_Post_Upd for task_assg_id:' || l_task_assignment_id ,
623: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
624:

Line 811: Invoked by JTF_TASK_ASSIGNMENTS_IUHK.delete_task_assignment_post

807:
808: /*--------------------------------------------------------
809: Description:
810: Start the workflow process TASK_ASSIGNMENT_PURGE.
811: Invoked by JTF_TASK_ASSIGNMENTS_IUHK.delete_task_assignment_post
812: and by concurrent program to purge closed task assignments
813: older than specified in profile: CSF_M_HISTORY.
814: Parameter(s):
815: x_return_status

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

831: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
832: RETURN;
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);

Line 939: FROM JTF_TASK_ASSIGNMENTS tas, JTF_RS_RESOURCE_EXTNS rs

935: l_sqlerrmsg VARCHAR2(4000);
936:
937: CURSOR c_task_ass_csr (b_task_id NUMBER) IS
938: SELECT rs.RESOURCE_ID, rs.USER_ID, tas.TASK_ASSIGNMENT_ID
939: FROM JTF_TASK_ASSIGNMENTS tas, JTF_RS_RESOURCE_EXTNS rs
940: WHERE TASK_ID = b_task_id
941: AND tas.RESOURCE_ID = rs.RESOURCE_ID;
942:
943: CURSOR l_task_post_upd_csr(b_task_id NUMBER)

Line 979: FROM JTF_TASK_ASSIGNMENTS

975:
976: CURSOR c_task_assignments(b_task_id NUMBER)
977: IS
978: SELECT TASK_ASSIGNMENT_ID,resource_id
979: FROM JTF_TASK_ASSIGNMENTS
980: WHERE TASK_ID=b_task_id;
981:
982: CURSOR c_resource_id(b_user_id NUMBER) IS
983: SELECT RESOURCE_ID

Line 1503: FROM jtf_task_assignments jta,

1499: OR
1500: au.USER_ID=csa.created_by
1501: OR
1502: EXISTS(SELECT 1
1503: FROM jtf_task_assignments jta,
1504: jtf_tasks_b jt
1505: WHERE jt.source_object_id = csa.incident_id
1506: AND jt.source_object_type_code = 'SR'
1507: AND jta.task_id = jt.task_id

Line 1902: jtf_task_assignments jta,

1898:
1899: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1900: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1901: FROM csf_debrief_headers dhdr,
1902: jtf_task_assignments jta,
1903: jtf_rs_resource_extns jtrs
1904: WHERE dhdr.debrief_header_id = p_debrief_header_id
1905: AND jta.task_assignment_id = dhdr.task_assignment_id
1906: AND jtrs.resource_id = jta.resource_id

Line 2539: jtf_task_assignments ta,

2535: SELECT ta.resource_id,
2536: jtrs.user_id
2537: FROM csp_requirement_headers hdr,
2538: jtf_tasks_b jt,
2539: jtf_task_assignments ta,
2540: jtf_rs_resource_extns jtrs
2541: WHERE hdr.requirement_header_id = p_req_header_id
2542: AND jt.task_id = hdr.task_id
2543: AND ta.task_id = jt.task_id

Line 2687: jtf_task_assignments ta,

2683: jtrs.user_id
2684: FROM csp_requirement_headers hdr,
2685: csp_requirement_lines line,
2686: jtf_tasks_b jt,
2687: jtf_task_assignments ta,
2688: jtf_rs_resource_extns jtrs
2689: WHERE hdr.requirement_header_id = line.requirement_header_id
2690: AND line.requirement_line_id = p_req_line_id
2691: AND jt.task_id = hdr.task_id