[Home] [Help]
229: end if; -- end p_contact_point_id is not null
230: -- DONE
231: if (p_problem_description is NOT NULL ) THEN
232: l_notes_table(1).note_type := p_note_type;
233: -- l_notes_table(1).note_type := FND_PROFILE.VALUE('IBU_SR_UPDATE_NOTE_TYPE');
234: -- l_notes_table(1).note := p_problem_description;
235: check_string_length_bites(
236: p_string => p_problem_description,
237: p_targetlen => 2000,
269: select fnd_global.resp_id into l_responsibility_id from dual;
270:
271:
272: -- added for 11.5.10
273: l_temp_close_value := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
274: if (l_temp_close_value = 'CS_SR_VALIDATE_AND_CLOSE') then
275: l_auto_close_child_entities := 'Y';
276: l_validate_sr_closure := 'Y';
277: end if;
281: l_validate_sr_closure := 'N';
282: end if;
283:
284: -- added in 11510 for auto-assignment.
285: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
286: Into l_cs_auto_assignment From dual;
287:
288: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
289: p_api_version => 4.0,
341: p_name IN VARCHAR2,
342: p_desc IN VARCHAR2)
343: is
344: seq_num NUMBER := 10;
345: p_category_id NUMBER := nvl(FND_PROFILE.VALUE('IBU_A_SR_DEFAULT_ATTACHMENT_CATEGORY'), 1);
346: -- mkcyee 01/27/2004 - we obtain the function name from the profile
347: -- to secure attachments
348: l_function_name FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := nvl(FND_PROFILE.value('IBU_SR_ATTACH_SECURITY_FUNC'), 'CSXSRISR');
349:
344: seq_num NUMBER := 10;
345: p_category_id NUMBER := nvl(FND_PROFILE.VALUE('IBU_A_SR_DEFAULT_ATTACHMENT_CATEGORY'), 1);
346: -- mkcyee 01/27/2004 - we obtain the function name from the profile
347: -- to secure attachments
348: l_function_name FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := nvl(FND_PROFILE.value('IBU_SR_ATTACH_SECURITY_FUNC'), 'CSXSRISR');
349:
350: begin
351: select NVL(max(seq_num),0) + 10
352: into seq_num
599: l_sr_rec.category_id := null;
600: l_sr_rec.category_set_id := null;
601: else
602: l_sr_rec.category_id := p_inv_category_id;
603: l_sr_rec.category_set_id := FND_PROFILE.VALUE('CS_SR_DEFAULT_CATEGORY_SET');
604: end if;
605:
606: -- Fixed Bug 9299378
607: BEGIN
605:
606: -- Fixed Bug 9299378
607: BEGIN
608: if p_product <> -1 then
609: cat_set_id := FND_PROFILE.VALUE('CS_SR_DEFAULT_CATEGORY_SET');
610: cat_org_id := CS_STD.Get_Item_Valdn_Orgzn_ID();
611: SELECT c.category_id into category_id
612: FROM mtl_category_set_valid_cats ic,
613: mtl_categories_kfv c,
682: -- Fix bug 9503707
683: if (p_urgency_id > 0) then
684: l_sr_rec.urgency_id := p_urgency_id;
685: else
686: l_sr_rec.urgency_id := fnd_profile.value('INC_DEFAULT_INCIDENT_URGENCY');
687: end if;
688:
689: if (p_problem_code_id <> 'NONE') then
690: l_sr_rec.problem_code := p_problem_code_id;
711:
712: if (p_employee_id > 0) THEN
713: l_sr_rec.employee_id := p_employee_id;
714: /* Follwoing is added for handling employee logging SRs 03/07/03, klou */
715: l_sr_rec.customer_id := fnd_profile.value('IBU_EMP_SR_ORG');
716: l_sr_rec.caller_type := 'ORGANIZATION';
717: else
718: IF (p_product > 0) THEN
719: l_sr_rec.customer_product_id := p_product;
886: * to fully leverage TeleService Auto-Assignment feature in 11.5.7.1
887: * 11-APR-2002 KLOU, (ASSG)
888: */
889:
890: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
891: Into l_cs_atuo_assignment From dual;
892:
893: If l_cs_atuo_assignment = 'N' Then
894: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')
890: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
891: Into l_cs_atuo_assignment From dual;
892:
893: If l_cs_atuo_assignment = 'N' Then
894: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')
895: Into l_ibu_assignment From dual;
896:
897: If l_ibu_assignment = 'Y' Then
898:
898:
899: -- Start of Fix to Bug 6621657
900: -- Profile CS_SR_DEFAULT_GROUP_TYPE is obsoleted in 12.0.2 and 12.0.3.
901:
902: /* Select fnd_profile.value('CS_SR_DEFAULT_GROUP_TYPE')
903: * Into l_sr_rec.group_type From dual;
904: */
905:
906: l_sr_rec.group_type := 'RS_GROUP';
906: l_sr_rec.group_type := 'RS_GROUP';
907:
908: --End of Fix to Bug 6621657
909:
910: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')
911: Into l_sr_rec.owner_group_id From dual;
912:
913: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
914: Into l_sr_rec.owner_id From dual;
909:
910: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')
911: Into l_sr_rec.owner_group_id From dual;
912:
913: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
914: Into l_sr_rec.owner_id From dual;
915:
916: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')
917: into l_sr_rec.resource_type from dual;
912:
913: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
914: Into l_sr_rec.owner_id From dual;
915:
916: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')
917: into l_sr_rec.resource_type from dual;
918:
919: End If;
920: End If;
1166: select fnd_global.resp_id, fnd_global.resp_appl_id, fnd_global.user_id, fnd_global.login_id
1167: into l_responsibility_id, l_resp_appl_id, l_user_id, l_login_id
1168: from dual;
1169: -- added for 11.5.10
1170: l_default_coverage_temp_id := fnd_profile.value('CS_SR_DEFAULT_COVERAGE');
1171:
1172: -- Fix 11815997
1173: l_sr_rec.publish_flag := 'Y';
1174:
1531:
1532: end if;
1533:
1534: if(l_group_id is null or l_group_id <= 0) then
1535: l_status_id := fnd_profile.value('INC_DEFAULT_INCIDENT_STATUS');
1536: end if;
1537: x_status_id := l_status_id;
1538:
1539: end get_default_status;