APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on HZ_LOCATIONS

Line 512: hz_locations lc

508: asg_user au,
509: asg_user_pub_resps aupr,
510: jtf_tasks_b jt,
511: cs_incidents_all_b csi,
512: hz_locations lc
513: WHERE jta.task_assignment_id = p_taskassgid
514: AND jta.assignee_role = 'ASSIGNEE'
515: AND au.resource_id = jta.resource_id
516: AND au.user_name = aupr.user_name

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

614: END IF;
615:
616: IF l_taskassgdetails_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
617: --insert location for the task
618: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_taskassgdetails_rec.location_id,
619: p_user_id => l_taskassgdetails_rec.user_id);
620: ELSE
621: -- spawn party site ins
622: IF l_taskassgdetails_rec.party_site_id IS NOT NULL THEN

Line 781: hz_locations lc

777: csi.incident_location_type
778: FROM JTF_TASK_ASSIGNMENTS jta,
779: jtf_tasks_b jt,
780: cs_incidents_all_b csi,
781: hz_locations lc
782: WHERE jta.task_assignment_id = p_taskassgid
783: AND jt.task_id = jta.task_id
784: AND jt.source_object_type_code = 'SR'
785: AND jt.source_object_id = csi.incident_id

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

818: p_user_id=>p_user_id,
819: p_flowtype=>l_flowtype);
820: IF l_taskassgdetails_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
821: --insert location for the sr
822: CSM_HZ_LOCATIONS_EVENT_PKG.insert_location(p_location_id => l_taskassgdetails_rec.location_id,
823: p_user_id => p_user_id);
824: ELSE
825: -- spawn party site ins
826: IF l_taskassgdetails_rec.party_site_id IS NOT NULL THEN

Line 961: hz_locations lc

957: asg_user au,
958: asg_user_pub_resps aupr,
959: jtf_tasks_b jt,
960: cs_incidents_all_b csi,
961: hz_locations lc
962: WHERE acc.task_assignment_id = p_task_assignment_id
963: AND acc.task_assignment_id = jta.task_assignment_id
964: AND acc.user_id = au.user_id
965: AND au.user_name = aupr.user_name

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

1054: END IF;
1055:
1056: IF l_task_assg_purge_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1057: --delete location for the sr
1058: CSM_HZ_LOCATIONS_EVENT_PKG.delete_location(p_location_id => l_task_assg_purge_rec.location_id,
1059: p_user_id => l_task_assg_purge_rec.user_id);
1060: ELSE
1061: -- spawn party site del
1062: --Bug 5220635

Line 1492: hz_locations lc

1488: csi.incident_location_type
1489: FROM JTF_TASK_ASSIGNMENTS jta,
1490: jtf_tasks_b jt,
1491: cs_incidents_all_b csi,
1492: hz_locations lc
1493: WHERE jta.task_assignment_id = p_task_assignment_id
1494: AND jt.task_id = jta.task_id
1495: AND jt.source_object_type_code = 'SR'
1496: AND jt.source_object_id = csi.incident_id

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

1530: p_user_id=>p_user_id,
1531: p_flowtype=>l_flowtype);
1532: IF l_TaskAssgHistPurge_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1533: --insert location for the sr
1534: csm_hz_locations_event_pkg.delete_location(p_location_id => l_TaskAssgHistPurge_rec.location_id,
1535: p_user_id => p_user_id);
1536: ELSE
1537:
1538: -- spawn party site del