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 CS_INCIDENTS_ALL_B

Line 39: l_incident_id cs_incidents_all_b.incident_id%TYPE;

35: l_sqlerrno VARCHAR2(20);
36: l_sqlerrmsg VARCHAR2(4000);
37: l_error_msg VARCHAR2(4000);
38: l_return_status VARCHAR2(2000);
39: l_incident_id cs_incidents_all_b.incident_id%TYPE;
40: l_dummy number;
41: l_last_run_date date;
42:
43:

Line 50: cs_incidents_all_b inc,

46: SELECT acc.incident_id,
47: acc.user_id,
48: acc.counter
49: FROM csm_incidents_all_acc acc,
50: cs_incidents_all_b inc,
51: cs_incident_statuses_b ists
52: WHERE inc.incident_id = acc.incident_id
53: AND decode(CSM_UTIL_PKG.get_group_owner(inc.owner_group_id),
54: -1,

Line 305: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,

301: l_return_status VARCHAR2(2000);
302: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
303: l_party_id hz_parties.party_id%TYPE;
304:
305: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,
306: p_sr_contact_point_id NUMBER)
307: IS
308: SELECT sr_contact_point_id,
309: contact_point_id,

Line 572: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,

568: l_return_status VARCHAR2(2000);
569: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
570: l_party_id hz_parties.party_id%TYPE;
571:
572: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,
573: p_sr_contact_point_id NUMBER)
574: IS
575: SELECT sr_contact_point_id,
576: contact_point_id,

Line 830: FROM CS_INCIDENTS_ALL_B inc,

826: IS
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'

Line 862: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)

858: l_owner_id NUMBER;
859: l_owner_resource_id NUMBER;
860:
861: --Change for Asset
862: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)
863: IS
864: SELECT csi.incident_id,
865: csi.customer_id,
866: csi.install_site_id,

Line 882: FROM cs_incidents_all_b csi

878: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
879: ) location_id ,
880: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,
881: csi.owner_group_id
882: FROM cs_incidents_all_b csi
883: WHERE csi.incident_id = p_incident_id
884: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION');
885: --not required as counter is important
886: /*AND NOT EXISTS

Line 1103: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,b_user_id NUMBER)

1099: l_owner_id NUMBER;
1100: l_owner_resource_id NUMBER;
1101:
1102: --12.1XB6
1103: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,b_user_id NUMBER)
1104: IS
1105: SELECT csi.incident_id,
1106: csi.customer_id,
1107: csi.install_site_id,

Line 1123: FROM cs_incidents_all_b csi

1119: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
1120: ) location_id ,
1121: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,
1122: csi.owner_group_id
1123: FROM cs_incidents_all_b csi
1124: WHERE csi.incident_id = p_incident_id
1125: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION')
1126: AND EXISTS
1127: (SELECT 1

Line 1337: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)

1333: l_error_msg VARCHAR2(4000);
1334: l_return_status VARCHAR2(2000);
1335: l_organization_id NUMBER;
1336:
1337: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)
1338: IS
1339: SELECT csi.incident_id,
1340: csi.customer_id,
1341: csi.install_site_id,

Line 1357: FROM cs_incidents_all_b csi

1353: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
1354: ) location_id ,
1355: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,
1356: csi.owner_group_id
1357: FROM cs_incidents_all_b csi
1358: WHERE csi.incident_id = p_incident_id
1359: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION');
1360:
1361:

Line 1371: CURSOR l_csm_task_assg_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)

1367: AND SOURCE_OBJECT_ID = p_incident_id;
1368:
1369: l_sr_rec l_sr_csr%ROWTYPE;
1370:
1371: CURSOR l_csm_task_assg_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)
1372: IS
1373: SELECT acc.access_id, acc.user_id
1374: FROM csm_incidents_all_acc acc
1375: WHERE acc.incident_id = p_incident_id;

Line 1538: l_incident_id cs_incidents_all_b.incident_id%TYPE;

1534: IS
1535: l_sqlerrno VARCHAR2(20);
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

Line 1543: FROM cs_incidents_all_b inc,

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,
1545: jtf_tasks_b tsk
1546: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
1547: AND ists.CLOSE_FLAG = 'Y'