APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on HZ_LOCATIONS

Line 519: hz_locations lc

515: asg_user au,
516: asg_user_pub_resps aupr,
517: jtf_tasks_b jt,
518: cs_incidents_all_b csi,
519: hz_locations lc
520: WHERE jta.task_assignment_id = p_taskassgid
521: AND jta.assignee_role = 'ASSIGNEE'
522: AND au.resource_id = jta.resource_id
523: AND au.user_name = aupr.user_name

Line 637: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_taskassgdetails_rec.location_id,

633: END IF;
634:
635: IF l_taskassgdetails_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
636: --insert location for the task
637: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_taskassgdetails_rec.location_id,
638: p_user_id => l_taskassgdetails_rec.user_id);
639: ELSE
640: -- spawn party site ins
641: IF l_taskassgdetails_rec.party_site_id IS NOT NULL THEN

Line 823: hz_locations lc

819: csi.incident_location_type
820: FROM JTF_TASK_ASSIGNMENTS jta,
821: jtf_tasks_b jt,
822: cs_incidents_all_b csi,
823: hz_locations lc
824: WHERE jta.task_assignment_id = p_taskassgid
825: AND jt.task_id = jta.task_id
826: AND jt.source_object_type_code = 'SR'
827: AND jt.source_object_id = csi.incident_id

Line 864: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_taskassgdetails_rec.location_id,

860: p_user_id=>p_user_id,
861: p_flowtype=>l_flowtype);
862: IF l_taskassgdetails_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
863: --insert location for the sr
864: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_taskassgdetails_rec.location_id,
865: p_user_id => p_user_id);
866: ELSE
867: -- spawn party site ins
868: IF l_taskassgdetails_rec.party_site_id IS NOT NULL THEN

Line 1007: hz_locations lc

1003: asg_user au,
1004: asg_user_pub_resps aupr,
1005: jtf_tasks_b jt,
1006: cs_incidents_all_b csi,
1007: hz_locations lc
1008: WHERE acc.task_assignment_id = p_task_assignment_id
1009: AND acc.task_assignment_id = jta.task_assignment_id
1010: AND acc.user_id = au.user_id
1011: AND au.user_name = aupr.user_name

Line 1126: CSM_HZ_LOCATIONS_EVENT_PKG.delete_location(p_location_id => l_task_assg_purge_rec.location_id,

1122: END IF;
1123:
1124: IF l_task_assg_purge_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1125: --delete location for the sr
1126: CSM_HZ_LOCATIONS_EVENT_PKG.delete_location(p_location_id => l_task_assg_purge_rec.location_id,
1127: p_user_id => l_task_assg_purge_rec.user_id);
1128: ELSE
1129: -- spawn party site del
1130: --Bug 5220635

Line 1564: hz_locations lc

1560: csi.incident_location_type
1561: FROM JTF_TASK_ASSIGNMENTS jta,
1562: jtf_tasks_b jt,
1563: cs_incidents_all_b csi,
1564: hz_locations lc
1565: WHERE jta.task_assignment_id = p_task_assignment_id
1566: AND jt.task_id = jta.task_id
1567: AND jt.source_object_type_code = 'SR'
1568: AND jt.source_object_id = csi.incident_id

Line 1606: csm_hz_locations_event_pkg.delete_location(p_location_id => l_TaskAssgHistPurge_rec.location_id,

1602: p_user_id=>p_user_id,
1603: p_flowtype=>l_flowtype);
1604: IF l_TaskAssgHistPurge_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1605: --insert location for the sr
1606: csm_hz_locations_event_pkg.delete_location(p_location_id => l_TaskAssgHistPurge_rec.location_id,
1607: p_user_id => p_user_id);
1608: ELSE
1609:
1610: -- spawn party site del