[Home] [Help]
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_PVT';
5: G_INITIALIZED CONSTANT VARCHAR2(1) := 'R';
6: G_SR_SUBTYPE CONSTANT VARCHAR2(5) := 'INC';
7: G_API_REVISION CONSTANT NUMBER := 1.0;
8: G_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_B';
9: G_TL_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_TL';
10:
11: --siahmed added for 12.1.2 project where
12: --to prevent multiple query to check weather we are updating onetime address or not
403: l_contract_defaulted VARCHAR2(1);
404: l_msg_count NUMBER;
405: l_msg_data VARCHAR2(2000);
406: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
407: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
408: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
409: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
411: l_territory_id NUMBER;
404: l_msg_count NUMBER;
405: l_msg_data VARCHAR2(2000);
406: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
407: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
408: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
409: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
411: l_territory_id NUMBER;
412: l_orig_group_type_null varchar2(1) := 'N';
405: l_msg_data VARCHAR2(2000);
406: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
407: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
408: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
409: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
411: l_territory_id NUMBER;
412: l_orig_group_type_null varchar2(1) := 'N';
413: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;
406: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
407: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
408: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
409: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
411: l_territory_id NUMBER;
412: l_orig_group_type_null varchar2(1) := 'N';
413: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;
414: l_owner_name jtf_rs_resource_extns_tl.resource_name % TYPE;
409: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
411: l_territory_id NUMBER;
412: l_orig_group_type_null varchar2(1) := 'N';
413: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;
414: l_owner_name jtf_rs_resource_extns_tl.resource_name % TYPE;
415: --siahmed 12.1.2 project
416: l_request_date DATE;
417: -- end of addition by siahmed
855: -- update incidents table only if timezone is found
856: --
857: IF (l_timezone_id IS NOT NULL)
858: THEN
859: UPDATE CS_INCIDENTS_ALL_B
860: SET time_zone_id = l_timezone_id
861: WHERE incident_id = p_incident_id;
862: END IF;
863:
1177: -- cs_srcontact_pkg.create_update to insert or update
1178: -- service request contact points
1179: -- 05/09/05 smisra Added defaulting of org_id before call to
1180: -- creat_sr_validation.
1181: -- modified insert to cs_incidents_all_b and passed values for
1182: -- columns org_id and maint_organization_id
1183: -- 05/27/05 smisra Bug 4227769
1184: -- Removed owner and group_owner columns from insert into
1185: -- cs_incidents_all_tl table.
1561: ( 'API_NAME'
1562: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1563: );
1564: FND_MSG_PUB.ADD_DETAIL
1565: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
1566: );
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;
1569:
1620: ( 'API_NAME'
1621: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1622: );
1623: FND_MSG_PUB.ADD_DETAIL
1624: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
1625: );
1626: RAISE FND_API.G_EXC_ERROR;
1627: END IF;
1628: ELSE -- maintenance flag is 'Y'
2142:
2143: x_sr_create_out_rec.individual_owner := l_service_request_rec.owner_id;
2144: x_sr_create_out_rec.individual_type := l_service_request_rec.resource_type;
2145: x_sr_create_out_rec.group_owner := l_service_request_rec.owner_group_id;
2146: -- March 23 2000, customer_number is not to be stored in cs_incidents_all_b
2147: -- If passed to teh api, it is used to retrieve the id from customer table
2148: -- l_service_request_rec.customer_number, /*CUSTOMER_NUMBER*/
2149:
2150:
2179: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');
2180: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');
2181: FND_MSG_PUB.ADD;
2182: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2183: --so that the new party_site_id gets stamped in the cs_incidents_all_b table
2184: l_service_request_rec.incident_location_id := l_incident_location_id;
2185: l_service_request_rec.incident_location_type := 'HZ_PARTY_SITE';
2186:
2187:
2317:
2318: --
2319: -- Insert into _B table
2320: --
2321: INSERT INTO cs_incidents_all_b
2322: ( incident_id,
2323: last_update_date,
2324: last_updated_by,
2325: creation_date,
2804:
2805:
2806: -- This record creation should not take place if caller_type is CALLER_EMP
2807: -- For Caller type Employee, should not create any contacts
2808: /* updating value of the primary_contact_id in the cs_incidents_all_b table
2809: after we insert record in cs_hz_sr_contact_points, so that
2810: sr_contact_point_id can be inserted as primary_contact_id by shijain
2811: for enh. 2690787
2812:
2813: l_primary_contact:= get_primary_contact(l_request_id);
2814:
2815: IF l_primary_contact is not null THEN
2816:
2817: UPDATE cs_incidents_all_b
2818: SET primary_contact_id = l_primary_contact
2819: WHERE incident_id = l_request_id;
2820:
2821: END IF;
4217:
4218: BEGIN
4219:
4220: SELECT object_version_number INTO l_dummy
4221: FROM cs_incidents_all_b
4222: WHERE incident_id = p_request_id;
4223:
4224: EXCEPTION
4225: WHEN NO_DATA_FOUND THEN
4347: ( 'API_NAME'
4348: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4349: );
4350: FND_MSG_PUB.ADD_DETAIL
4351: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
4352: );
4353: RAISE FND_API.G_EXC_ERROR;
4354: END IF;
4355: --
4499: ( 'API_NAME'
4500: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4501: );
4502: FND_MSG_PUB.ADD_DETAIL
4503: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
4504: );
4505: RAISE FND_API.G_EXC_ERROR;
4506: END IF;
4507: ELSE -- maintenance flag is 'Y'
4644: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4645: );
4646: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);
4647: FND_MSG_PUB.ADD_DETAIL
4648: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
4649: );
4650: RAISE FND_API.G_EXC_ERROR;
4651: END IF; -- l_pending approval flag is Y
4652: ELSE -- status_id <> G_MISS and not equal to old value
4670: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4671: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4672: FND_MSG_PUB.Add_Detail
4673: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4674: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4675: );
4676: IF l_old_servicerequest_rec.incident_status_id = l_service_request_rec.status_id
4677: THEN
4678: CS_ServiceRequest_UTIL.Add_Same_Val_Update_Msg
5324: --Update Sr then, if object version is incremented to 3 , then
5325: --cannot update any other attributes displayed on the Sr form, since
5326: --SR form had already locked the record with object version as 2.
5327:
5328: UPDATE cs_incidents_all_b
5329: SET workflow_process_id = p_workflow_process_id
5330: WHERE ROWID = l_old_ServiceRequest_rec.ROW_ID ;
5331:
5332: ELSE
5609: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');
5610: FND_MSG_PUB.ADD;
5611:
5612: ELSIF (l_return_status_onetime = FND_API.G_RET_STS_SUCCESS) THEN
5613: --so that the new party_site_id gets stamped in the cs_incidents_all_b table
5614: l_service_request_rec.incident_location_id := l_incident_location_id;
5615: l_service_request_rec.incident_location_type := 'HZ_PARTY_SITE';
5616: --stamp the out rec type with the incident location_id
5617: x_sr_update_out_rec.incident_location_id := l_incident_location_id;
5805: ----------------------------------------------------
5806:
5807:
5808: ---Update for all cases.
5809: UPDATE cs_incidents_all_b
5810: SET incident_status_id = l_service_request_rec.status_id,
5811: incident_type_id = l_service_request_rec.type_id,
5812: incident_urgency_id = l_service_request_rec.urgency_id,
5813: incident_severity_id = l_service_request_rec.severity_id,
6069: -- Added these assignments here as these values are not available in Update_SR_Validation
6070:
6071: /* These are not correct. if old value is null then else condition will get executed and
6072: wrong value will go to new value col in audit rec
6073: These are already set before update to cs_incidents_all_b table
6074: smisra: 29th nov 2004
6075: l_audit_vals_rec.OLD_CONTRACT_ID := l_old_ServiceRequest_rec.CONTRACT_ID;
6076: IF (l_contra_id <> FND_API.G_MISS_NUM) AND
6077: (l_contra_id <> l_old_ServiceRequest_rec.CONTRACT_ID) THEN
6659: -- 2. incident responded date
6660: -- 3. incident resolved date
6661: -- 4. Close date
6662: l_service_request_rec.status_id := l_sr_related_data.target_status_id;
6663: UPDATE cs_incidents_all_b
6664: SET incident_status_id = l_service_request_rec.status_id
6665: , inc_responded_by_date = l_service_request_rec.inc_responded_by_date
6666: , incident_resolved_date = l_service_request_rec.incident_resolved_date
6667: , status_flag = l_service_request_rec.status_flag
7614: FND_MSG_PUB.ADD;
7615: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
7617: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
7618: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
7619: RAISE FND_API.G_EXC_ERROR;
7620: END IF; -- l_pending approval flag is Y
7621: END IF; -- if after get_status_details call
7622:
7643: , 'CS_SERVICEREQUEST_PVT.update_status'
7644: );
7645: FND_MESSAGE.set_token('STATUS_ID',p_status_id);
7646: FND_MSG_PUB.ADD_DETAIL
7647: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
7648: );
7649: RAISE FND_API.G_EXC_ERROR;
7650: END IF; -- l_pending approval flag is Y
7651: */
8030: l_status_flag:= get_status_flag ( p_status_id);
8031:
8032: -- Update CS_INCIDENTS table
8033: -- for the bug 3027154 - wrong date in the SR Log
8034: UPDATE cs_incidents_all_b
8035: SET incident_status_id = p_status_id,
8036: close_date = l_closed_date,
8037: inc_responded_by_date = l_inc_responded_by_date,
8038: incident_resolved_date= l_incident_resolved_date,
8343: l_sr_related_data RELATED_DATA_TYPE;
8344: l_owner_group_id jtf_rs_groups_b.group_id % TYPE;
8345: l_workflow_process_id NUMBER;
8346: l_contacts contacts_table;
8347: l_resource_type cs_incidents_all_b.resource_type % TYPE;
8348: l_support_site_id cs_incidents_all_b.site_id % TYPE;
8349:
8350: BEGIN
8351:
8344: l_owner_group_id jtf_rs_groups_b.group_id % TYPE;
8345: l_workflow_process_id NUMBER;
8346: l_contacts contacts_table;
8347: l_resource_type cs_incidents_all_b.resource_type % TYPE;
8348: l_support_site_id cs_incidents_all_b.site_id % TYPE;
8349:
8350: BEGIN
8351:
8352: -- ---------------------------------------
8594: THEN
8595: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
8596: FND_MESSAGE.set_token('API_NAME', l_api_name_full);
8597: FND_MSG_PUB.add_detail
8598: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'
8599: );
8600: RAISE FND_API.G_EXC_ERROR;
8601: END IF;
8602:
8749: -- Update the owner and insert the audit record
8750: -- ----------------------------------------------
8751: -- Update CS_INCIDENTS table
8752:
8753: UPDATE cs_incidents_all_b
8754: SET incident_owner_id = p_owner_id,
8755: owner_group_id = l_owner_group_id,
8756: resource_type = l_resource_type,
8757: last_updated_by = p_last_updated_by,
10115: l_busi_proc_id NUMBER;
10116: lx_return_status VARCHAR2(3);
10117: l_old_type_id NUMBER;
10118:
10119: l_maint_organization_id cs_incidents_all_b.maint_organization_id % TYPE;
10120: l_inv_org_master_org_flag VARCHAR2(1);
10121: l_serial_controlled_flag VARCHAR2(3);
10122:
10123: BEGIN
11893: l_ship_to_site_id NUMBER;
11894: l_bill_to_site_use_id NUMBER;
11895: l_ship_to_site_use_id NUMBER;
11896: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
11897: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
11898: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
11899: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
11900: l_territory_id number;
11901: l_orig_group_type_null varchar2(1) := 'N';
11894: l_bill_to_site_use_id NUMBER;
11895: l_ship_to_site_use_id NUMBER;
11896: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
11897: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
11898: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
11899: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
11900: l_territory_id number;
11901: l_orig_group_type_null varchar2(1) := 'N';
11902: l_responded_flag cs_incident_statuses_b.responded_flag % type;
11895: l_ship_to_site_use_id NUMBER;
11896: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
11897: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
11898: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
11899: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
11900: l_territory_id number;
11901: l_orig_group_type_null varchar2(1) := 'N';
11902: l_responded_flag cs_incident_statuses_b.responded_flag % type;
11903: l_resolved_flag cs_incident_statuses_b.resolved_flag % type;
12336: l_test NUMBER;
12337: BEGIN
12338: SELECT incident_id
12339: INTO l_test
12340: FROM cs_incidents_all_b
12341: WHERE incident_id = p_request_id;
12342:
12343: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
12344: ( p_token_an => l_api_name_full,
12365: l_test VARCHAR2(250);
12366: BEGIN
12367: SELECT incident_number
12368: INTO l_test
12369: FROM cs_incidents_all_b
12370: WHERE incident_number = p_request_number;
12371:
12372: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
12373: ( p_token_an => l_api_name_full,
14902: IF l_request_id IS NULL THEN
14903: LOOP
14904: SELECT cs_incidents_s.NEXTVAL INTO x_req_id FROM dual;
14905: BEGIN
14906: SELECT incident_id INTO l_temp_id FROM cs_incidents_all_b
14907: WHERE incident_id = x_req_id;
14908: EXCEPTION
14909: WHEN NO_DATA_FOUND THEN
14910: EXIT;
14919: IF l_request_number IS NULL THEN
14920: LOOP
14921: SELECT cs_incidents_number_s.NEXTVAL INTO x_req_num FROM dual;
14922: BEGIN
14923: SELECT incident_number INTO l_temp_num FROM cs_incidents_all_b
14924: WHERE incident_number = x_req_num;
14925: EXCEPTION
14926: WHEN NO_DATA_FOUND THEN
14927: EXIT;
15505: B.sla_duration_1,
15506: B.sla_duration_2,
15507: --15995804. Add price_list_header_id
15508: B.price_list_header_id
15509: FROM cs_incidents_all_b b, cs_incidents_all_tl tl
15510: WHERE b.incident_id = p_request_id
15511: AND b.incident_id = tl.incident_id
15512: AND tl.LANGUAGE = DECODE(l_service_request_rec.LANGUAGE,
15513: FND_API.G_MISS_CHAR, USERENV('LANG'),
15569: l_ship_to_site_use_id NUMBER;
15570:
15571: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
15572: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
15573: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
15574: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
15575: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
15576: l_territory_id number;
15577: l_call_asgn_resource varchar2(1) := 'n';
15570:
15571: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
15572: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
15573: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
15574: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
15575: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
15576: l_territory_id number;
15577: l_call_asgn_resource varchar2(1) := 'n';
15578:
15571: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
15572: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
15573: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
15574: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
15575: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
15576: l_territory_id number;
15577: l_call_asgn_resource varchar2(1) := 'n';
15578:
15579: -- For bug 3333340
15580: p_passed_value VARCHAR2(3);
15581: l_update_desc_flex_int varchar2(1) := FND_API.G_FALSE;
15582: l_update_desc_flex_ext varchar2(1) := FND_API.G_FALSE;
15583: l_ff_name varchar2(30);
15584: l_dummy0 cs_incidents_all_b.product_revision % type;
15585: l_dummy1 cs_incidents_all_b.component_version % type;
15586: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
15587:
15588: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
15581: l_update_desc_flex_int varchar2(1) := FND_API.G_FALSE;
15582: l_update_desc_flex_ext varchar2(1) := FND_API.G_FALSE;
15583: l_ff_name varchar2(30);
15584: l_dummy0 cs_incidents_all_b.product_revision % type;
15585: l_dummy1 cs_incidents_all_b.component_version % type;
15586: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
15587:
15588: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
15589: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
15582: l_update_desc_flex_ext varchar2(1) := FND_API.G_FALSE;
15583: l_ff_name varchar2(30);
15584: l_dummy0 cs_incidents_all_b.product_revision % type;
15585: l_dummy1 cs_incidents_all_b.component_version % type;
15586: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
15587:
15588: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
15589: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
15590: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
15677: handle_missing_value(l_service_request_rec.request_attribute_14,l_old_servicerequest_rec.incident_attribute_14);
15678: handle_missing_value(l_service_request_rec.request_attribute_15,l_old_servicerequest_rec.incident_attribute_15);
15679: else
15680: -- incident context is changed. so set all g_miss_char to null except global data segments
15681: l_ff_name := 'CS_INCIDENTS_ALL_B';
15682: set_attribute_value(l_service_request_rec.request_attribute_1,l_old_servicerequest_rec.incident_attribute_1,
15683: l_ff_name,'INCIDENT_ATTRIBUTE_1');
15684:
15685: set_attribute_value(l_service_request_rec.request_attribute_2,l_old_servicerequest_rec.incident_attribute_2,
15729: p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
15730: Cs_Servicerequest_Util.Validate_Desc_Flex(
15731: p_api_name => l_api_name_full,
15732: p_application_short_name => 'CS',
15733: p_desc_flex_name => 'CS_INCIDENTS_ALL_B',
15734: p_desc_segment1 => l_service_request_rec.request_attribute_1,
15735: p_desc_segment2 => l_service_request_rec.request_attribute_2,
15736: p_desc_segment3 => l_service_request_rec.request_attribute_3,
15737: p_desc_segment4 => l_service_request_rec.request_attribute_4,
15829: handle_missing_value(l_service_request_rec.external_attribute_15,l_old_servicerequest_rec.external_attribute_15);
15830: else
15831:
15832: -- context is changed. so set all g_miss_char to null except global data segments
15833: l_ff_name := 'CS_INCIDENTS_ALL_B_EXT';
15834: set_attribute_value(l_service_request_rec.external_attribute_1,l_old_servicerequest_rec.external_attribute_1,
15835: l_ff_name,'EXTERNAL_ATTRIBUTE_1');
15836:
15837: set_attribute_value(l_service_request_rec.external_attribute_2,l_old_servicerequest_rec.external_attribute_2,
15881: p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
15882: Cs_ServiceRequest_Util.Validate_external_Desc_Flex
15883: ( p_api_name => l_api_name_full,
15884: p_application_short_name => 'CS',
15885: p_ext_desc_flex_name => 'CS_INCIDENTS_ALL_B_EXT',
15886: p_ext_desc_segment1 => l_service_request_rec.external_attribute_1,
15887: p_ext_desc_segment2 => l_service_request_rec.external_attribute_2,
15888: p_ext_desc_segment3 => l_service_request_rec.external_attribute_3,
15889: p_ext_desc_segment4 => l_service_request_rec.external_attribute_4,
16220: THEN
16221: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');
16222: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16223: FND_MSG_PUB.ADD_DETAIL
16224: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
16225: );
16226: RAISE FND_API.G_EXC_ERROR;
16227: END IF;
16228: -- if new status has pending approval flag then it means ERES update is in
16248: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
16249: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16250: FND_MSG_PUB.ADD_DETAIL
16251: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
16252: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'
16253: );
16254: --END IF;
16255: END IF;
16256: l_service_request_rec.owner_id := l_old_ServiceRequest_rec.incident_owner_id;
20572: BEGIN
20573: DELETE FROM CS_INCIDENTS_ALL_TL T
20574: WHERE NOT EXISTS
20575: (SELECT NULL
20576: FROM CS_INCIDENTS_ALL_B B
20577: WHERE B.INCIDENT_ID = T.INCIDENT_ID
20578: );
20579:
20580: UPDATE CS_INCIDENTS_ALL_TL T SET (
20711: )
20712: IS
20713: CURSOR C IS
20714: SELECT OBJECT_VERSION_NUMBER
20715: FROM CS_INCIDENTS_ALL_B
20716: WHERE INCIDENT_ID = X_INCIDENT_ID
20717: FOR UPDATE OF INCIDENT_ID NOWAIT;
20718:
20719: RECINFO C%ROWTYPE;
20768: CURSOR c_imp_old_csr IS
20769: SELECT importance_level
20770: FROM cs_incident_severities_b
20771: WHERE incident_severity_id =( SELECT incident_severity_id
20772: FROM CS_INCIDENTS_ALL_B
20773: WHERE incident_id = p_incident_id);
20774: l_old_imp_level NUMBER;
20775: BEGIN
20776: OPEN c_imp_old_csr;
20782: FUNCTION Get_Owner_id(p_incident_id IN NUMBER)
20783: RETURN NUMBER IS
20784: CURSOR c_owner_id IS
20785: SELECT incident_owner_id
20786: FROM cs_incidents_all_b
20787: WHERE incident_id = p_incident_id;
20788: l_owner_id NUMBER;
20789: BEGIN
20790: OPEN c_owner_id;
20828: RETURN(l_uwq_message);
20829: END Get_Message;
20830:
20831: /* Added for enh.2655115, procedure to get the value of status_flag for
20832: inserting into cs_incidents_all_b table. If the closed flag is Y then
20833: the status is closed, else its open.created by shijain dated nov 27th 2002*/
20834:
20835: FUNCTION GET_STATUS_FLAG( p_incident_status_id IN NUMBER)
20836: RETURN VARCHAR2 IS
20858:
20859:
20860:
20861: /* Added for enh.2690787, procedure to get the value of primary_contact_id for
20862: inserting into cs_incidents_all_b table based on the incident_id and the
20863: primary flag from the cs_hz_sr_contact_points table by shijain
20864:
20865: FUNCTION GET_PRIMARY_CONTACT( p_incident_id IN NUMBER)
20866: RETURN NUMBER IS