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 224: l_task_id JTF_TASKS_B.TASK_ID%TYPE;

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

Line 228: FROM JTF_TASKS_B jt,

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

Line 240: JTF_TASKS_B tsk

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

Line 302: l_task_id JTF_TASKS_B.TASK_ID%TYPE;

298: l_sqlerrmsg VARCHAR2(4000);
299: l_error_msg VARCHAR2(4000);
300: l_return_status VARCHAR2(2000);
301:
302: l_task_id JTF_TASKS_B.TASK_ID%TYPE;
303:
304: BEGIN
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:

Line 347: JTF_TASKS_B tsk

343: CURSOR c_sr_grp_owner(b_task_id number) IS
344: SELECT USER_ID
345: FROM ASG_USER usr,
346: CS_INCIDENTS_ALL_B inc,
347: JTF_TASKS_B tsk
348: WHERE tsk.TASK_ID=b_task_id
349: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
350: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
351: AND (

Line 563: JTF_TASKS_B tsk

559: CURSOR c_sr_grp_owner(b_task_id number) IS
560: SELECT USER_ID
561: FROM ASG_USER usr,
562: CS_INCIDENTS_ALL_B inc,
563: JTF_TASKS_B tsk
564: WHERE tsk.TASK_ID=b_task_id
565: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
566: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
567: AND (

Line 883: FROM JTF_TASKS_B

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

Line 946: FROM JTF_TASKS_B

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

Line 954: JTF_TASKS_B tsk

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

Line 1280: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;

1276: l_sqlerrno VARCHAR2(20);
1277: l_sqlerrmsg VARCHAR2(4000);
1278: l_error_msg VARCHAR2(4000);
1279: l_return_status VARCHAR2(2000);
1280: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;
1281:
1282: --R12 Asset
1283: CURSOR l_sr_pre_upd_csr (p_incident_id IN number)
1284: IS

Line 1302: FROM JTF_TASKS_B

1298:
1299: CURSOR l_addr_id_csr (b_incident_id IN NUMBER)
1300: IS
1301: SELECT ADDRESS_ID
1302: FROM JTF_TASKS_B
1303: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1304: AND SOURCE_OBJECT_ID = b_incident_id;
1305:
1306: --R12 Asset

Line 1310: FROM JTF_TASKS_B

1306: --R12 Asset
1307: CURSOR l_location_id_csr (b_incident_id IN NUMBER)
1308: IS
1309: SELECT ADDRESS_ID,LOCATION_ID
1310: FROM JTF_TASKS_B
1311: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1312: AND SOURCE_OBJECT_ID = b_incident_id;
1313:
1314: -- get all the contacts for the SR; this is used in sr_post_upd

Line 1437: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;

1433: l_error_msg VARCHAR2(4000);
1434: l_return_status VARCHAR2(2000);
1435: l_incident_location_id cs_incidents_all_b.incident_location_id%TYPE;
1436: l_is_incident_location_updated char(1);
1437: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;
1438: l_is_owner_changed char(1);
1439: l_old_owner NUMBER;
1440: l_current_owner NUMBER;
1441:

Line 1462: FROM JTF_TASKS_B

1458:
1459: CURSOR l_addr_id_csr (b_incident_id IN NUMBER)
1460: IS
1461: SELECT ADDRESS_ID
1462: FROM JTF_TASKS_B
1463: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1464: AND SOURCE_OBJECT_ID = b_incident_id;
1465:
1466: CURSOR l_location_id_csr (b_incident_id IN NUMBER)

Line 1469: FROM JTF_TASKS_B

1465:
1466: CURSOR l_location_id_csr (b_incident_id IN NUMBER)
1467: IS
1468: SELECT ADDRESS_ID,LOCATION_ID
1469: FROM JTF_TASKS_B
1470: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1471: AND SOURCE_OBJECT_ID = b_incident_id;
1472:
1473: -- get all the post_upd contacts for the SR;

Line 1504: jtf_tasks_b jt

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
1508: AND au.resource_id = jta.resource_id)

Line 1511: FROM jtf_tasks_b jt

1507: AND jta.task_id = jt.task_id
1508: AND au.resource_id = jta.resource_id)
1509: OR
1510: EXISTS(SELECT 1
1511: FROM jtf_tasks_b jt
1512: WHERE jt.source_object_id = csa.incident_id
1513: AND jt.source_object_type_code = 'SR'
1514: AND jt.CREATED_BY=au.USER_ID);
1515:

Line 2538: jtf_tasks_b jt,

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

Line 2686: jtf_tasks_b jt,

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