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 831: JTF_TASKS_B tsk,

827: CURSOR c_sr_owner_group (b_task_id NUMBER) IS
828: SELECT inc.owner_group_id,
829: inc.created_by
830: FROM CS_INCIDENTS_ALL_B inc,
831: JTF_TASKS_B tsk,
832: JTF_TASK_TYPES_B ttype
833: WHERE tsk.TASK_ID=b_task_id
834: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
835: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 896: FROM JTF_TASKS_B

892:
893: CURSOR l_addr_id_csr (p_incident_id IN NUMBER)
894: IS
895: SELECT NVL(LOCATION_ID,ADDRESS_ID)--R12Assest
896: FROM JTF_TASKS_B
897: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
898: AND SOURCE_OBJECT_ID = p_incident_id;
899:
900: l_sr_rec l_sr_csr%ROWTYPE;

Line 905: FROM JTF_TASKS_B tsk,

901:
902: CURSOR c_tasks(b_incident_id NUMBER)
903: IS
904: SELECT TASK_ID
905: FROM JTF_TASKS_B tsk,
906: JTF_TASK_TYPES_B ttype
907: WHERE tsk.SOURCE_OBJECT_TYPE_CODE='SR'
908: AND tsk.SOURCE_OBJECT_ID=b_incident_id
909: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID

Line 1137: FROM JTF_TASKS_B tsk,

1133:
1134: CURSOR c_tasks(b_incident_id NUMBER)
1135: IS
1136: SELECT tsk.TASK_ID
1137: FROM JTF_TASKS_B tsk,
1138: JTF_TASK_TYPES_B ttype
1139: WHERE tsk.SOURCE_OBJECT_TYPE_CODE='SR'
1140: AND tsk.SOURCE_OBJECT_ID=b_incident_id
1141: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID

Line 1365: FROM JTF_TASKS_B

1361:
1362: CURSOR l_addr_id_csr (p_incident_id IN NUMBER)
1363: IS
1364: SELECT NVL(LOCATION_ID,ADDRESS_ID)--R12Assest
1365: FROM JTF_TASKS_B
1366: WHERE SOURCE_OBJECT_TYPE_CODE = 'SR'
1367: AND SOURCE_OBJECT_ID = p_incident_id;
1368:
1369: l_sr_rec l_sr_csr%ROWTYPE;

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

1536: l_sqlerrmsg VARCHAR2(4000);
1537: l_error_msg VARCHAR2(4000);
1538: l_incident_id cs_incidents_all_b.incident_id%TYPE;
1539:
1540: CURSOR l_is_sr_open_csr(c_task_id jtf_tasks_b.task_id%TYPE)
1541: IS
1542: SELECT inc.incident_id
1543: FROM cs_incidents_all_b inc,
1544: cs_incident_statuses_b ists,

Line 1545: jtf_tasks_b tsk

1541: IS
1542: SELECT inc.incident_id
1543: FROM cs_incidents_all_b inc,
1544: cs_incident_statuses_b ists,
1545: jtf_tasks_b tsk
1546: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
1547: AND ists.CLOSE_FLAG = 'Y'
1548: AND tsk.task_id = c_task_id
1549: AND tsk.source_object_id = inc.incident_id;