[Home] [Help]
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
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));
6500: IF p_auto_generate_tasks = 'Y' OR p_auto_generate_tasks = 'y' THEN
6501:
6502: --Fix for bug 12668350
6503: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'
6504: --table first If it is not defined,then look in cs_incident_types
6505: BEGIN
6506: SELECT task_template_id into l_task_template_id
6507: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype
6508: WHERE srtype.incident_type_id = l_service_request_rec.type_id
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
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
7719: IF p_auto_generate_tasks = 'Y' OR p_auto_generate_tasks = 'y' THEN
7720:
7721: --Fix for bug 12668350
7722: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'
7723: --table first If it is not defined,then look in cs_incident_types
7724: BEGIN
7725: SELECT task_template_id into l_task_template_id
7726: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype
7727: WHERE srtype.incident_type_id = l_servicerequest_rec.incident_type_id
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
7828: -- Unless this API itself was called from a workflow process.
7829: -- ------------------------------------------------------------------
7830: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
7831:
7832: --Get the abort workflow on close flag from cs_incident_types
7833:
7834: BEGIN
7835: -- Initialize the return status.
7836: l_return_status := FND_API.G_RET_STS_SUCCESS;
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:
11717: -- removed the code that sets obsolete col group_owner and
11718: -- owner (_tl table columns)
11719: -- 07/15/05 smisra Bug 4489746
11720: -- removed start and end active dates from query on
11721: -- cs_incident_types. Validate type will take care of
11722: -- date effectivity check.
11723: -- 07/15/05 smisra Bug 4398562
11724: -- moved the code that sets group_type and
11725: -- change_group_type_flag after call to SR auto assignment
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:
15187: -- update program code is not ERES then raise error. Such SRs
15188: -- can be update only by ERES program.
15189: -- 07/15/05 smisra Bug 4489746
15190: -- removed start and end active dates from query on
15191: -- cs_incident_types. Validate type will take care of
15192: -- date effectivity check.
15193: -- 07/20/05 smisra replaced individual vars from get_status_details call with
15194: -- structure l_sr_related_data members
15195: --
16092:
16093: --This part of the code should just check whether the status can be
16094: --updated.Also Aborting the workflow code is based on close flag from
16095: --CS_INCIDENTS_STATUSES and abort_workflow on close flag from
16096: --CS_INCIDENT_TYPES.
16097:
16098: -- This functionality is based on the change in the SR status
16099: -- Check if we need to abort the workflow process if the service
16100: -- request is being closed. First we check if the
16155: -- end dates will cause no dat found. old value of type id even if it is end dated
16156: -- should not cause any error.
16157: SELECT autolaunch_workflow_flag, abort_workflow_close_flag, workflow
16158: INTO x_autolaunch_wkf_flag, x_abort_wkf_close_flag, x_wkf_process_name
16159: FROM cs_incident_types
16160: WHERE incident_type_id = l_type_id_temp
16161: AND incident_subtype = G_SR_SUBTYPE
16162: ;
16163: