APPS.CSM_SR_EVENT_PKG dependencies on HZ_LOCATIONS

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

874: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
875: 'HZ_PARTY_SITE',
876: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
877: 'HZ_LOCATION',
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

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

977: p_user_id=>l_owner_id,
978: p_flowtype=>NULL);
979: IF l_sr_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
980: --insert location for the sr
981: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_sr_rec.incident_location_id,
982: p_user_id => l_owner_id);
983: ELSE
984: -- get party site
985: IF l_sr_rec.incident_location_id IS NOT NULL THEN

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

1115: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
1116: 'HZ_PARTY_SITE',
1117: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
1118: 'HZ_LOCATION',
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

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

1208: p_user_id=>l_owner_id,
1209: p_flowtype=>NULL);
1210: IF l_sr_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1211: --insert location for the sr
1212: csm_hz_locations_event_pkg.delete_location(p_location_id => l_sr_rec.incident_location_id,
1213: p_user_id => l_owner_id);
1214: ELSE
1215: -- spawn party site del
1216: IF l_sr_rec.incident_location_id IS NOT NULL THEN

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

1349: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
1350: 'HZ_PARTY_SITE',
1351: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
1352: 'HZ_LOCATION',
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

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

1401: IF l_sr_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1402: --Delete old location
1403: IF p_old_incident_location_id IS NOT NULL THEN
1404:
1405: csm_hz_locations_event_pkg.delete_location(p_location_id => l_sr_rec.incident_location_id,
1406: p_user_id => r_csm_task_assg_rec.user_id);
1407: END IF;
1408:
1409: IF l_sr_rec.incident_location_id IS NOT NULL THEN

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

1407: END IF;
1408:
1409: IF l_sr_rec.incident_location_id IS NOT NULL THEN
1410: -- insert new location
1411: csm_hz_locations_event_pkg.insert_location(p_location_id => l_sr_rec.incident_location_id,
1412: p_user_id => r_csm_task_assg_rec.user_id);
1413: END IF;
1414:
1415: ELSE