APPS.CSM_SR_EVENT_PKG dependencies on HZ_LOCATIONS

Line 893: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))

889: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
890: 'HZ_PARTY_SITE',
891: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
892: 'HZ_LOCATION',
893: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
894: ) location_id ,
895: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,
896: csi.owner_group_id,
897: csi.org_id

Line 1000: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_sr_rec.incident_location_id,

996: p_user_id=>l_owner_id,
997: p_flowtype=>NULL);
998: IF l_sr_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
999: --insert location for the sr
1000: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_sr_rec.incident_location_id,
1001: p_user_id => l_owner_id);
1002: ELSE
1003: -- get party site
1004: IF l_sr_rec.incident_location_id IS NOT NULL THEN

Line 1142: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))

1138: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
1139: 'HZ_PARTY_SITE',
1140: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
1141: 'HZ_LOCATION',
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

Line 1234: csm_hz_locations_event_pkg.delete_location(p_location_id => l_sr_rec.incident_location_id,

1230: p_user_id=>l_owner_id,
1231: p_flowtype=>NULL);
1232: IF l_sr_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1233: --insert location for the sr
1234: csm_hz_locations_event_pkg.delete_location(p_location_id => l_sr_rec.incident_location_id,
1235: p_user_id => l_owner_id);
1236: ELSE
1237: -- spawn party site del
1238: IF l_sr_rec.incident_location_id IS NOT NULL THEN

Line 1375: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))

1371: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
1372: 'HZ_PARTY_SITE',
1373: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
1374: 'HZ_LOCATION',
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

Line 1427: csm_hz_locations_event_pkg.delete_location(p_location_id => l_sr_rec.incident_location_id,

1423: IF l_sr_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1424: --Delete old location
1425: IF p_old_incident_location_id IS NOT NULL THEN
1426:
1427: csm_hz_locations_event_pkg.delete_location(p_location_id => l_sr_rec.incident_location_id,
1428: p_user_id => r_csm_task_assg_rec.user_id);
1429: END IF;
1430:
1431: IF l_sr_rec.incident_location_id IS NOT NULL THEN

Line 1433: csm_hz_locations_event_pkg.insert_location(p_location_id => l_sr_rec.incident_location_id,

1429: END IF;
1430:
1431: IF l_sr_rec.incident_location_id IS NOT NULL THEN
1432: -- insert new location
1433: csm_hz_locations_event_pkg.insert_location(p_location_id => l_sr_rec.incident_location_id,
1434: p_user_id => r_csm_task_assg_rec.user_id);
1435: END IF;
1436:
1437: ELSE