APPS.CSM_TASKS_PKG dependencies on CS_INCIDENTS_ALL_B

Line 75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;

71: l_task_priority jtf_tasks_b.task_priority_id%TYPE;
72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;
73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;
74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;
75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;
76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;
77: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE := null;
78: l_owner_id JTF_tasks_b.owner_id%type :=null;
79: l_owner_type JTF_tasks_b.owner_type_code%type :=null;

Line 76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;

72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;
73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;
74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;
75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;
76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;
77: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE := null;
78: l_owner_id JTF_tasks_b.owner_id%type :=null;
79: l_owner_type JTF_tasks_b.owner_type_code%type :=null;
80: l_is_private NUMBER;

Line 127: FROM CS_INCIDENTS_ALL_B

123: SELECT INCIDENT_NUMBER, INCIDENT_LOCATION_ID,
124: CUSTOMER_ID,INCIDENT_LOCATION_TYPE
125: INTO l_task_source_object_name , l_incident_location_id,
126: l_customer_id,l_incident_location_type
127: FROM CS_INCIDENTS_ALL_B
128: WHERE INCIDENT_ID = p_record.source_object_id;
129:
130: -- Note: location_type is HZ_LOCATION in CS_INCIDENTS_ALL_B and
131: -- HZ_LOCATIONS in CSI_ITEM_INSTANCES

Line 130: -- Note: location_type is HZ_LOCATION in CS_INCIDENTS_ALL_B and

126: l_customer_id,l_incident_location_type
127: FROM CS_INCIDENTS_ALL_B
128: WHERE INCIDENT_ID = p_record.source_object_id;
129:
130: -- Note: location_type is HZ_LOCATION in CS_INCIDENTS_ALL_B and
131: -- HZ_LOCATIONS in CSI_ITEM_INSTANCES
132: IF l_incident_location_type = 'HZ_LOCATION' THEN
133: l_location_id := l_incident_location_id;
134: ELSE