[Home] [Help]
53: , x_autolaunch_workflow_flag
54: , x_abort_workflow_close_flag
55: , x_workflow
56: FROM
57: cs_incident_types_b
58: WHERE incident_type_id = p_incident_type_id;
59:
60: EXCEPTION
61: WHEN no_data_found THEN
4885: an update on the SR's workflow_process_id and not call the SR Update API.
4886:
4887: IF (FND_API.To_Boolean(p_called_by_workflow) = TRUE) THEN
4888: SELECT workflow INTO l_workflow_process_name
4889: FROM cs_incident_types_b
4890: WHERE incident_type_id = l_service_request_rec.type_id
4891: AND incident_subtype = G_SR_SUBTYPE
4892: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
4893: AND TRUNC(NVL(end_date_active, SYSDATE));
6432: -- if this status has intermediated status id as NOT NULL then
6433: -- called update_servicerequest procedure. This is needed
6434: -- for ERES processing and avoiding duplicate coding in this
6435: -- procedure.
6436: -- 07/15/05 smisra Bug 4489746 modified sql statement for cs_incident_types_b
6437: -- and removed condition on start and end active dates so that
6438: -- API does not give error for those types that become end
6439: -- dated
6440: -- Passed UPDATE_OLD to validate_type call because we need to
6910: workflow
6911: INTO l_autolaunch_workflow_flag,
6912: l_abort_workflow_close_flag,
6913: l_workflow_process_name
6914: FROM cs_incident_types_b
6915: WHERE incident_type_id = l_ServiceRequest_rec.incident_type_id
6916: AND incident_subtype = G_SR_SUBTYPE
6917: ;
6918:
12011: -- Verify the type ID against the database.
12012: -- Done here cause, these flags need to get their values
12013: SELECT autolaunch_workflow_flag, abort_workflow_close_flag, workflow
12014: INTO x_autolaunch_wkf_flag, x_abort_wkf_close_flag, x_wkf_process_name
12015: FROM cs_incident_types_b
12016: WHERE incident_type_id = l_service_request_rec.type_id
12017: AND incident_subtype = G_SR_SUBTYPE
12018: ;
12019: