APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENT_TYPES_B

Line 62: cs_incident_types_b

58: , x_autolaunch_workflow_flag
59: , x_abort_workflow_close_flag
60: , x_workflow
61: FROM
62: cs_incident_types_b
63: WHERE incident_type_id = p_incident_type_id;
64:
65: EXCEPTION
66: WHEN no_data_found THEN

Line 5310: FROM cs_incident_types_b

5306: an update on the SR's workflow_process_id and not call the SR Update API.
5307:
5308: IF (FND_API.To_Boolean(p_called_by_workflow) = TRUE) THEN
5309: SELECT workflow INTO l_workflow_process_name
5310: FROM cs_incident_types_b
5311: WHERE incident_type_id = l_service_request_rec.type_id
5312: AND incident_subtype = G_SR_SUBTYPE
5313: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
5314: AND TRUNC(NVL(end_date_active, SYSDATE));

Line 6525: FROM cs_sr_status_transitions cst,cs_incident_types_b cit

6521: IF l_task_template_id IS NULL THEN
6522: BEGIN
6523: --Get task template id
6524: select task_template_id into l_task_template_id
6525: FROM cs_sr_status_transitions cst,cs_incident_types_b cit
6526: WHERE cit.incident_type_id = l_service_request_rec.type_id
6527: AND cst.status_group_id=cit.status_group_id
6528: AND from_incident_status_id = l_old_servicerequest_rec.incident_status_id --refers to old status_id
6529: AND to_incident_status_id = l_service_request_rec.status_id; -- refers to new status_id

Line 7230: -- 07/15/05 smisra Bug 4489746 modified sql statement for cs_incident_types_b

7226: -- if this status has intermediated status id as NOT NULL then
7227: -- called update_servicerequest procedure. This is needed
7228: -- for ERES processing and avoiding duplicate coding in this
7229: -- procedure.
7230: -- 07/15/05 smisra Bug 4489746 modified sql statement for cs_incident_types_b
7231: -- and removed condition on start and end active dates so that
7232: -- API does not give error for those types that become end
7233: -- dated
7234: -- Passed UPDATE_OLD to validate_type call because we need to

Line 7744: FROM cs_sr_status_transitions cst,cs_incident_types_b cit

7740: IF l_task_template_id IS NULL THEN
7741: BEGIN
7742: --Get task template id
7743: select task_template_id into l_task_template_id
7744: FROM cs_sr_status_transitions cst,cs_incident_types_b cit
7745: WHERE cit.incident_type_id = l_servicerequest_rec.incident_type_id
7746: AND cst.status_group_id=cit.status_group_id
7747: AND from_incident_status_id = l_servicerequest_rec.incident_status_id --refers to old status_id
7748: AND to_incident_status_id = p_status_id; -- refers to new status_id

Line 7846: FROM cs_incident_types_b

7842: workflow
7843: INTO l_autolaunch_workflow_flag,
7844: l_abort_workflow_close_flag,
7845: l_workflow_process_name
7846: FROM cs_incident_types_b
7847: WHERE incident_type_id = l_ServiceRequest_rec.incident_type_id
7848: AND incident_subtype = G_SR_SUBTYPE
7849: ;
7850:

Line 13057: FROM cs_incident_types_b

13053: -- Verify the type ID against the database.
13054: -- Done here cause, these flags need to get their values
13055: SELECT autolaunch_workflow_flag, abort_workflow_close_flag, workflow
13056: INTO x_autolaunch_wkf_flag, x_abort_wkf_close_flag, x_wkf_process_name
13057: FROM cs_incident_types_b
13058: WHERE incident_type_id = l_service_request_rec.type_id
13059: AND incident_subtype = G_SR_SUBTYPE
13060: ;
13061: