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_TASKS_B

Line 105: FROM jtf_tasks_b jt

101: IS
102: CURSOR c_task_status (p_task_id in NUMBER, b_status_id NUMBER)
103: IS
104: SELECT 1
105: FROM jtf_tasks_b jt
106: WHERE jt.task_id = p_task_id
107: AND (jt.source_object_type_code = 'TASK' OR jt.source_object_type_code IS NULL)
108: UNION
109: SELECT 1

Line 153: FROM jtf_tasks_b jt

149: ) RETURN BOOLEAN
150: IS
151: CURSOR c_task_status (p_task_id IN NUMBER, b_status_id NUMBER) IS
152: SELECT 1
153: FROM jtf_tasks_b jt
154: WHERE jt.task_id = p_task_id
155: AND (jt.source_object_type_code = 'TASK' OR jt.source_object_type_code IS NULL)
156: UNION
157: SELECT 1

Line 223: l_task_id JTF_TASKS_B.TASK_ID%TYPE;

219: l_sqlerrmsg VARCHAR2(4000);
220: l_error_msg VARCHAR2(4000);
221: l_return_status VARCHAR2(2000);
222: l_user_id number;
223: l_task_id JTF_TASKS_B.TASK_ID%TYPE;
224:
225: CURSOR l_task_csr (b_task_id NUMBER) IS
226: SELECT jt.CREATED_BY, jtt.private_flag, jt.source_object_type_code -- 22 means Escalation task
227: FROM JTF_TASKS_B jt,

Line 227: FROM JTF_TASKS_B jt,

223: l_task_id JTF_TASKS_B.TASK_ID%TYPE;
224:
225: CURSOR l_task_csr (b_task_id NUMBER) IS
226: SELECT jt.CREATED_BY, jtt.private_flag, jt.source_object_type_code -- 22 means Escalation task
227: FROM JTF_TASKS_B jt,
228: jtf_task_types_b jtt
229: WHERE jt.TASK_ID = b_task_id
230: AND jtt.task_type_id = jt.task_type_id;
231:

Line 239: JTF_TASKS_B tsk

235: CURSOR c_sr_grp_owner(b_task_id number) IS
236: SELECT USER_ID
237: FROM ASG_USER usr,
238: CS_INCIDENTS_ALL_B inc,
239: JTF_TASKS_B tsk
240: WHERE tsk.TASK_ID=b_task_id
241: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
242: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
243: AND usr.GROUP_ID=inc.owner_group_id --is_mfs_grp

Line 249: JTF_TASKS_B tsk

245: UNION ALL
246: SELECT USER_ID --not mfs grp, get SR created by
247: FROM ASG_USER usr,
248: CS_INCIDENTS_ALL_B inc,
249: JTF_TASKS_B tsk
250: WHERE tsk.TASK_ID=b_task_id
251: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
252: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
253: AND usr.USER_ID=inc.created_by;

Line 298: l_task_id JTF_TASKS_B.TASK_ID%TYPE;

294: l_sqlerrmsg VARCHAR2(4000);
295: l_error_msg VARCHAR2(4000);
296: l_return_status VARCHAR2(2000);
297:
298: l_task_id JTF_TASKS_B.TASK_ID%TYPE;
299:
300: BEGIN
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:

Line 343: JTF_TASKS_B tsk

339: CURSOR c_sr_grp_owner(b_task_id number) IS
340: SELECT USER_ID
341: FROM ASG_USER usr,
342: CS_INCIDENTS_ALL_B inc,
343: JTF_TASKS_B tsk
344: WHERE tsk.TASK_ID=b_task_id
345: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
346: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
347: AND usr.GROUP_ID=inc.owner_group_id --is_mfs_grp

Line 353: JTF_TASKS_B tsk

349: UNION ALL
350: SELECT USER_ID --not mfs grp, get SR created by
351: FROM ASG_USER usr,
352: CS_INCIDENTS_ALL_B inc,
353: JTF_TASKS_B tsk
354: WHERE tsk.TASK_ID=b_task_id
355: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
356: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
357: AND usr.USER_ID=inc.created_by;

Line 559: JTF_TASKS_B tsk

555: CURSOR c_sr_grp_owner(b_task_id number) IS
556: SELECT USER_ID
557: FROM ASG_USER usr,
558: CS_INCIDENTS_ALL_B inc,
559: JTF_TASKS_B tsk
560: WHERE tsk.TASK_ID=b_task_id
561: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
562: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
563: AND usr.GROUP_ID=inc.owner_group_id --is_mfs_grp

Line 569: JTF_TASKS_B tsk

565: UNION ALL
566: SELECT USER_ID --not mfs grp, get SR created by
567: FROM ASG_USER usr,
568: CS_INCIDENTS_ALL_B inc,
569: JTF_TASKS_B tsk
570: WHERE tsk.TASK_ID=b_task_id
571: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
572: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
573: AND usr.USER_ID=inc.created_by;

Line 881: FROM JTF_TASKS_B

877:
878: CURSOR l_task_pre_upd_csr(b_task_id NUMBER)
879: IS
880: SELECT TASK_STATUS_ID, TASK_TYPE_ID, SCHEDULED_START_DATE, SCHEDULED_END_DATE, task_id
881: FROM JTF_TASKS_B
882: WHERE TASK_ID = b_task_id;
883:
884:
885: BEGIN

Line 944: FROM JTF_TASKS_B

940:
941: CURSOR l_task_post_upd_csr(b_task_id NUMBER)
942: IS
943: SELECT TASK_STATUS_ID, TASK_TYPE_ID, SCHEDULED_START_DATE, SCHEDULED_END_DATE, task_id
944: FROM JTF_TASKS_B
945: WHERE TASK_ID = b_task_id;
946:
947: --12.1XB7
948: CURSOR c_sr_grp_owner(b_task_id number) IS

Line 952: JTF_TASKS_B tsk

948: CURSOR c_sr_grp_owner(b_task_id number) IS
949: SELECT USER_ID
950: FROM ASG_USER usr,
951: CS_INCIDENTS_ALL_B inc,
952: JTF_TASKS_B tsk
953: WHERE tsk.TASK_ID=b_task_id
954: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
955: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
956: AND usr.GROUP_ID=inc.owner_group_id --is_mfs_grp

Line 962: JTF_TASKS_B tsk

958: UNION ALL
959: SELECT USER_ID --not mfs grp, get SR created by
960: FROM ASG_USER usr,
961: CS_INCIDENTS_ALL_B inc,
962: JTF_TASKS_B tsk
963: WHERE tsk.TASK_ID=b_task_id
964: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
965: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
966: AND usr.USER_ID=inc.created_by;

Line 1286: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;

1282: l_sqlerrno VARCHAR2(20);
1283: l_sqlerrmsg VARCHAR2(4000);
1284: l_error_msg VARCHAR2(4000);
1285: l_return_status VARCHAR2(2000);
1286: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;
1287:
1288: --R12 Asset
1289: CURSOR l_sr_pre_upd_csr (p_incident_id IN number)
1290: IS

Line 1308: FROM JTF_TASKS_B

1304:
1305: CURSOR l_addr_id_csr (b_incident_id IN NUMBER)
1306: IS
1307: SELECT ADDRESS_ID
1308: FROM JTF_TASKS_B
1309: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1310: AND SOURCE_OBJECT_ID = b_incident_id;
1311:
1312: --R12 Asset

Line 1316: FROM JTF_TASKS_B

1312: --R12 Asset
1313: CURSOR l_location_id_csr (b_incident_id IN NUMBER)
1314: IS
1315: SELECT ADDRESS_ID,LOCATION_ID
1316: FROM JTF_TASKS_B
1317: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1318: AND SOURCE_OBJECT_ID = b_incident_id;
1319:
1320: -- get all the contacts for the SR; this is used in sr_post_upd

Line 1443: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;

1439: l_error_msg VARCHAR2(4000);
1440: l_return_status VARCHAR2(2000);
1441: l_incident_location_id cs_incidents_all_b.incident_location_id%TYPE;
1442: l_is_incident_location_updated char(1);
1443: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;
1444: l_is_owner_changed char(1);
1445: l_old_owner NUMBER;
1446: l_current_owner NUMBER;
1447:

Line 1468: FROM JTF_TASKS_B

1464:
1465: CURSOR l_addr_id_csr (b_incident_id IN NUMBER)
1466: IS
1467: SELECT ADDRESS_ID
1468: FROM JTF_TASKS_B
1469: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1470: AND SOURCE_OBJECT_ID = b_incident_id;
1471:
1472: CURSOR l_location_id_csr (b_incident_id IN NUMBER)

Line 1475: FROM JTF_TASKS_B

1471:
1472: CURSOR l_location_id_csr (b_incident_id IN NUMBER)
1473: IS
1474: SELECT ADDRESS_ID,LOCATION_ID
1475: FROM JTF_TASKS_B
1476: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1477: AND SOURCE_OBJECT_ID = b_incident_id;
1478:
1479: -- get all the post_upd contacts for the SR;

Line 1511: FROM jtf_tasks_b jt

1507: WHERE csa.incident_id = p_incident_id
1508: AND EXISTS(SELECT 1 FROM ASG_USER WHERE USER_ID=csa.created_by AND NVL(MULTI_PLATFORM,'N')='N')
1509: UNION ALL
1510: SELECT 1
1511: FROM jtf_tasks_b jt
1512: WHERE jt.source_object_id = p_incident_id
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

Line 1518: jtf_tasks_b jt

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
1522: AND jta.resource_type_code='RS_EMPLOYEE'

Line 2530: jtf_tasks_b jt,

2526: UNION
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

Line 2678: jtf_tasks_b jt,

2674: ta.resource_id,
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