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_SR_EVENT_PKG dependencies on JTF_TASKS_B

Line 146: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

142: IS
143: l_sqlerrno VARCHAR2(20);
144: l_sqlerrmsg VARCHAR2(4000);
145: l_error_msg VARCHAR2(4000);
146: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
147:
148: CURSOR l_jtf_tasks_csr(p_task_id jtf_tasks_b.task_id%TYPE)
149: IS
150: SELECT tsk.source_object_type_code

Line 148: CURSOR l_jtf_tasks_csr(p_task_id jtf_tasks_b.task_id%TYPE)

144: l_sqlerrmsg VARCHAR2(4000);
145: l_error_msg VARCHAR2(4000);
146: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
147:
148: CURSOR l_jtf_tasks_csr(p_task_id jtf_tasks_b.task_id%TYPE)
149: IS
150: SELECT tsk.source_object_type_code
151: FROM jtf_tasks_b tsk, jtf_task_types_b ttype
152: WHERE tsk.task_id = p_task_id

Line 151: FROM jtf_tasks_b tsk, jtf_task_types_b ttype

147:
148: CURSOR l_jtf_tasks_csr(p_task_id jtf_tasks_b.task_id%TYPE)
149: IS
150: SELECT tsk.source_object_type_code
151: FROM jtf_tasks_b tsk, jtf_task_types_b ttype
152: WHERE tsk.task_id = p_task_id
153: AND tsk.task_type_id = ttype.task_type_id
154: AND (ttype.RULE = 'DISPATCH' OR ttype.private_flag = 'Y')
155: AND tsk.SCHEDULED_START_DATE IS NOT NULL

Line 203: CURSOR l_jtf_task_status_csr(p_task_id jtf_tasks_b.task_id%TYPE)

199: l_sqlerrmsg VARCHAR2(4000);
200: l_error_msg VARCHAR2(4000);
201: l_dummy NUMBER;
202:
203: CURSOR l_jtf_task_status_csr(p_task_id jtf_tasks_b.task_id%TYPE)
204: IS
205: SELECT 1
206: FROM jtf_tasks_b jt,
207: jtf_task_statuses_b jts

Line 206: FROM jtf_tasks_b jt,

202:
203: CURSOR l_jtf_task_status_csr(p_task_id jtf_tasks_b.task_id%TYPE)
204: IS
205: SELECT 1
206: FROM jtf_tasks_b jt,
207: jtf_task_statuses_b jts
208: WHERE jt.task_id = p_task_id
209: AND jt.task_status_id = jts.task_status_id
210: AND (jt.source_object_type_code = 'TASK' OR jt.source_object_type_code IS NULL

Line 256: jtf_tasks_b jt,

252: CURSOR l_jtf_task_assg_status_csr(p_task_assg_id NUMBER)
253: IS
254: SELECT 1
255: FROM jtf_task_assignments jta,
256: jtf_tasks_b jt,
257: jtf_task_statuses_b jts
258: WHERE jta.task_assignment_id = p_task_assg_id
259: AND jt.task_id = jta.task_id
260: AND jta.assignment_status_id = jts.task_status_id

Line 842: JTF_TASKS_B tsk,

838: CURSOR c_sr_owner_group (b_task_id NUMBER) IS
839: SELECT inc.owner_group_id,
840: inc.created_by
841: FROM CS_INCIDENTS_ALL_B inc,
842: JTF_TASKS_B tsk,
843: JTF_TASK_TYPES_B ttype
844: WHERE tsk.TASK_ID=b_task_id
845: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
846: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 912: FROM JTF_TASKS_B

908:
909: CURSOR l_addr_id_csr (p_incident_id IN NUMBER)
910: IS
911: SELECT NVL(LOCATION_ID,ADDRESS_ID)--R12Assest
912: FROM JTF_TASKS_B
913: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
914: AND SOURCE_OBJECT_ID = p_incident_id;
915:
916: l_sr_rec l_sr_csr%ROWTYPE;

Line 921: FROM JTF_TASKS_B tsk,

917:
918: CURSOR c_tasks(b_incident_id NUMBER)
919: IS
920: SELECT TASK_ID
921: FROM JTF_TASKS_B tsk,
922: JTF_TASK_TYPES_B ttype
923: WHERE tsk.SOURCE_OBJECT_TYPE_CODE='SR'
924: AND tsk.SOURCE_OBJECT_ID=b_incident_id
925: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID

Line 1160: FROM JTF_TASKS_B tsk,

1156:
1157: CURSOR c_tasks(b_incident_id NUMBER)
1158: IS
1159: SELECT tsk.TASK_ID
1160: FROM JTF_TASKS_B tsk,
1161: JTF_TASK_TYPES_B ttype
1162: WHERE tsk.SOURCE_OBJECT_TYPE_CODE='SR'
1163: AND tsk.SOURCE_OBJECT_ID=b_incident_id
1164: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID

Line 1387: FROM JTF_TASKS_B

1383:
1384: CURSOR l_addr_id_csr (p_incident_id IN NUMBER)
1385: IS
1386: SELECT NVL(LOCATION_ID,ADDRESS_ID)--R12Assest
1387: FROM JTF_TASKS_B
1388: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1389: AND SOURCE_OBJECT_ID = p_incident_id;
1390:
1391: l_sr_rec l_sr_csr%ROWTYPE;

Line 1562: CURSOR l_is_sr_open_csr(c_task_id jtf_tasks_b.task_id%TYPE)

1558: l_sqlerrmsg VARCHAR2(4000);
1559: l_error_msg VARCHAR2(4000);
1560: l_incident_id cs_incidents_all_b.incident_id%TYPE;
1561:
1562: CURSOR l_is_sr_open_csr(c_task_id jtf_tasks_b.task_id%TYPE)
1563: IS
1564: SELECT inc.incident_id
1565: FROM cs_incidents_all_b inc,
1566: cs_incident_statuses_b ists,

Line 1567: jtf_tasks_b tsk

1563: IS
1564: SELECT inc.incident_id
1565: FROM cs_incidents_all_b inc,
1566: cs_incident_statuses_b ists,
1567: jtf_tasks_b tsk
1568: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
1569: AND ists.CLOSE_FLAG = 'Y'
1570: AND tsk.task_id = c_task_id
1571: AND tsk.source_object_id = inc.incident_id;