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 363: from JTF_TASK_ASSIGNMENTS

359:
360: CURSOR c_task(b_task_assignment_id NUMBER)
361: IS
362: select task_id,resource_id
363: from JTF_TASK_ASSIGNMENTS
364: where TASK_ASSIGNMENT_ID=b_task_assignment_id;
365:
366:
367:

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 440: JTF_TASK_ASSIGNMENTS_IUHK.update_task_assignment_pre

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

Line 459: FROM JTF_TASK_ASSIGNMENTS

455: l_return_status VARCHAR2(2000);
456:
457: CURSOR l_task_ass_pre_csr (b_task_assignment_id NUMBER) IS
458: SELECT RESOURCE_ID, assignment_status_id, task_id
459: FROM JTF_TASK_ASSIGNMENTS
460: WHERE TASK_ASSIGNMENT_ID = b_task_assignment_id;
461:
462: CURSOR l_get_user_id(p_resource_id IN NUMBER)
463: IS

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 538: FROM JTF_TASK_ASSIGNMENTS

534:
535: CURSOR l_task_ass_post_csr (b_task_assignment_id NUMBER)
536: IS
537: SELECT RESOURCE_ID, assignment_status_id, task_id
538: FROM JTF_TASK_ASSIGNMENTS
539: WHERE TASK_ASSIGNMENT_ID = b_task_assignment_id;
540:
541: l_task_ass_post_upd_rec l_task_ass_post_csr%ROWTYPE;
542: l_null_task_ass_post_upd_rec l_task_ass_post_csr%ROWTYPE;

Line 579: from JTF_TASK_ASSIGNMENTS

575:
576: CURSOR c_task(b_task_assignment_id NUMBER)
577: IS
578: select task_id
579: from JTF_TASK_ASSIGNMENTS
580: where TASK_ASSIGNMENT_ID=b_task_assignment_id;
581:
582:
583: CURSOR c_resource_id(b_user_id NUMBER) IS

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 808: Invoked by JTF_TASK_ASSIGNMENTS_IUHK.delete_task_assignment_post

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

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

Line 937: FROM JTF_TASK_ASSIGNMENTS tas, JTF_RS_RESOURCE_EXTNS rs

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

Line 971: FROM JTF_TASK_ASSIGNMENTS

967:
968: CURSOR c_task_assignments(b_task_id NUMBER)
969: IS
970: SELECT TASK_ASSIGNMENT_ID,resource_id
971: FROM JTF_TASK_ASSIGNMENTS
972: WHERE TASK_ID=b_task_id;
973:
974: CURSOR c_resource_id(b_user_id NUMBER) IS
975: SELECT RESOURCE_ID

Line 1517: FROM jtf_task_assignments jta,

1513: AND jt.source_object_type_code = 'SR'
1514: AND EXISTS(SELECT 1 FROM ASG_USER WHERE USER_ID=jt.created_by AND NVL(MULTI_PLATFORM,'N')='N')
1515: UNION ALL
1516: SELECT 1
1517: FROM jtf_task_assignments jta,
1518: jtf_tasks_b jt
1519: WHERE jt.source_object_id = p_incident_id
1520: AND jt.source_object_type_code = 'SR'
1521: AND jta.task_id = jt.task_id

Line 1918: jtf_task_assignments jta,

1914:
1915: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1916: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1917: FROM csf_debrief_headers dhdr,
1918: jtf_task_assignments jta,
1919: jtf_rs_resource_extns jtrs
1920: WHERE dhdr.debrief_header_id = p_debrief_header_id
1921: AND jta.task_assignment_id = dhdr.task_assignment_id
1922: AND jtrs.resource_id = jta.resource_id

Line 2531: jtf_task_assignments ta,

2527: SELECT ta.resource_id,
2528: jtrs.user_id
2529: FROM csp_requirement_headers hdr,
2530: jtf_tasks_b jt,
2531: jtf_task_assignments ta,
2532: jtf_rs_resource_extns jtrs
2533: WHERE hdr.requirement_header_id = p_req_header_id
2534: AND jt.task_id = hdr.task_id
2535: AND ta.task_id = jt.task_id

Line 2679: jtf_task_assignments ta,

2675: jtrs.user_id
2676: FROM csp_requirement_headers hdr,
2677: csp_requirement_lines line,
2678: jtf_tasks_b jt,
2679: jtf_task_assignments ta,
2680: jtf_rs_resource_extns jtrs
2681: WHERE hdr.requirement_header_id = line.requirement_header_id
2682: AND line.requirement_line_id = p_req_line_id
2683: AND jt.task_id = hdr.task_id

Line 3738: /FS creates dummy task in jtf_task_assignments_all that needs to be skipped/

3734: WHERE TASK_ASSIGNMENT_ID=b_task_assignment_id;
3735:
3736: BEGIN
3737:
3738: /*FS creates dummy task in jtf_task_assignments_all that needs to be skipped*/
3739: IF l_entity='CSM_TASK_ASSIGNMENTS' AND l_mode = 'NEW' THEN
3740: open c_access(to_number(l_pk_value));
3741: fetch c_access into l_e;
3742: close c_access;