DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENT_TYPES

Line 57: cs_incident_types_b

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

Line 4889: FROM cs_incident_types_b

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));

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

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

Line 6900: --Get the abort workflow on close flag from cs_incident_types

6896: -- Unless this API itself was called from a workflow process.
6897: -- ------------------------------------------------------------------
6898: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
6899:
6900: --Get the abort workflow on close flag from cs_incident_types
6901:
6902: BEGIN
6903: -- Initialize the return status.
6904: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6914: FROM cs_incident_types_b

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:

Line 10692: -- cs_incident_types. Validate type will take care of

10688: -- removed the code that sets obsolete col group_owner and
10689: -- owner (_tl table columns)
10690: -- 07/15/05 smisra Bug 4489746
10691: -- removed start and end active dates from query on
10692: -- cs_incident_types. Validate type will take care of
10693: -- date effectivity check.
10694: -- 07/15/05 smisra Bug 4398562
10695: -- moved the code that sets group_type and
10696: -- change_group_type_flag after call to SR auto assignment

Line 12015: FROM cs_incident_types_b

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:

Line 13996: -- cs_incident_types. Validate type will take care of

13992: -- update program code is not ERES then raise error. Such SRs
13993: -- can be update only by ERES program.
13994: -- 07/15/05 smisra Bug 4489746
13995: -- removed start and end active dates from query on
13996: -- cs_incident_types. Validate type will take care of
13997: -- date effectivity check.
13998: -- 07/20/05 smisra replaced individual vars from get_status_details call with
13999: -- structure l_sr_related_data members
14000: --

Line 14886: --CS_INCIDENT_TYPES.

14882:
14883: --This part of the code should just check whether the status can be
14884: --updated.Also Aborting the workflow code is based on close flag from
14885: --CS_INCIDENTS_STATUSES and abort_workflow on close flag from
14886: --CS_INCIDENT_TYPES.
14887:
14888: -- This functionality is based on the change in the SR status
14889: -- Check if we need to abort the workflow process if the service
14890: -- request is being closed. First we check if the

Line 14949: FROM cs_incident_types

14945: -- end dates will cause no dat found. old value of type id even if it is end dated
14946: -- should not cause any error.
14947: SELECT autolaunch_workflow_flag, abort_workflow_close_flag, workflow
14948: INTO x_autolaunch_wkf_flag, x_abort_wkf_close_flag, x_wkf_process_name
14949: FROM cs_incident_types
14950: WHERE incident_type_id = l_type_id_temp
14951: AND incident_subtype = G_SR_SUBTYPE
14952: ;
14953: