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 580: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,

576: l_return_status VARCHAR2(2000);
577: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
578: l_party_id hz_parties.party_id%TYPE;
579:
580: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,
581: p_sr_contact_point_id NUMBER)
582: IS
583: SELECT sr_contact_point_id,
584: contact_point_id,

Line 841: FROM CS_INCIDENTS_ALL_B inc,

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

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

873: l_owner_id NUMBER;
874: l_owner_resource_id NUMBER;
875:
876: --Change for Asset
877: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)
878: IS
879: SELECT csi.incident_id,
880: csi.customer_id,
881: csi.install_site_id,

Line 898: FROM cs_incidents_all_b csi

894: ) location_id ,
895: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,
896: csi.owner_group_id,
897: csi.org_id
898: FROM cs_incidents_all_b csi
899: WHERE csi.incident_id = p_incident_id
900: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION');
901: --not required as counter is important
902: /*AND NOT EXISTS

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

1122: l_owner_id NUMBER;
1123: l_owner_resource_id NUMBER;
1124:
1125: --12.1XB6
1126: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,b_user_id NUMBER)
1127: IS
1128: SELECT csi.incident_id,
1129: csi.customer_id,
1130: csi.install_site_id,

Line 1146: FROM cs_incidents_all_b csi

1142: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
1143: ) location_id ,
1144: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,
1145: csi.owner_group_id
1146: FROM cs_incidents_all_b csi
1147: WHERE csi.incident_id = p_incident_id
1148: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION')
1149: AND EXISTS
1150: (SELECT 1

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

1355: l_error_msg VARCHAR2(4000);
1356: l_return_status VARCHAR2(2000);
1357: l_organization_id NUMBER;
1358:
1359: CURSOR l_sr_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)
1360: IS
1361: SELECT csi.incident_id,
1362: csi.customer_id,
1363: csi.install_site_id,

Line 1379: FROM cs_incidents_all_b csi

1375: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
1376: ) location_id ,
1377: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,
1378: csi.owner_group_id
1379: FROM cs_incidents_all_b csi
1380: WHERE csi.incident_id = p_incident_id
1381: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION');
1382:
1383:

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

1389: AND SOURCE_OBJECT_ID = p_incident_id;
1390:
1391: l_sr_rec l_sr_csr%ROWTYPE;
1392:
1393: CURSOR l_csm_task_assg_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)
1394: IS
1395: SELECT acc.access_id, acc.user_id
1396: FROM csm_incidents_all_acc acc
1397: WHERE acc.incident_id = p_incident_id;

Line 1560: l_incident_id cs_incidents_all_b.incident_id%TYPE;

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

Line 1565: FROM cs_incidents_all_b inc,

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,
1567: jtf_tasks_b tsk
1568: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
1569: AND ists.CLOSE_FLAG = 'Y'

Line 1626: SELECT INCIDENT_ID FROM CS_INCIDENTS_ALL_B

1622: AND INSTANCE_ID = c_INSTANCE_ID;
1623:
1624: CURSOR c_get_sr_id (c_incident_number VARCHAR2)
1625: IS
1626: SELECT INCIDENT_ID FROM CS_INCIDENTS_ALL_B
1627: WHERE INCIDENT_NUMBER =c_incident_number;
1628:
1629: CURSOR c_get_invoice(c_incident_id NUMBER)
1630: IS