eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBU_REQ_PKG dependencies on FND_PROFILE

Line 216: -- l_notes_table(1).note_type := FND_PROFILE.VALUE('IBU_SR_UPDATE_NOTE_TYPE');

212: end if; -- end p_contact_point_id is not null
213: -- DONE
214: if (p_problem_description is NOT NULL ) THEN
215: l_notes_table(1).note_type := p_note_type;
216: -- l_notes_table(1).note_type := FND_PROFILE.VALUE('IBU_SR_UPDATE_NOTE_TYPE');
217: -- l_notes_table(1).note := p_problem_description;
218: check_string_length_bites(
219: p_string => p_problem_description,
220: p_targetlen => 2000,

Line 256: l_temp_close_value := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');

252: select fnd_global.resp_id into l_responsibility_id from dual;
253:
254:
255: -- added for 11.5.10
256: l_temp_close_value := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
257: if (l_temp_close_value = 'CS_SR_VALIDATE_AND_CLOSE') then
258: l_auto_close_child_entities := 'Y';
259: l_validate_sr_closure := 'Y';
260: end if;

Line 268: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')

264: l_validate_sr_closure := 'N';
265: end if;
266:
267: -- added in 11510 for auto-assignment.
268: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
269: Into l_cs_auto_assignment From dual;
270:
271: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
272: p_api_version => 4.0,

Line 328: p_category_id NUMBER := nvl(FND_PROFILE.VALUE('IBU_A_SR_DEFAULT_ATTACHMENT_CATEGORY'), 1);

324: p_name IN VARCHAR2,
325: p_desc IN VARCHAR2)
326: is
327: seq_num NUMBER := 10;
328: p_category_id NUMBER := nvl(FND_PROFILE.VALUE('IBU_A_SR_DEFAULT_ATTACHMENT_CATEGORY'), 1);
329: -- mkcyee 01/27/2004 - we obtain the function name from the profile
330: -- to secure attachments
331: l_function_name FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := nvl(FND_PROFILE.value('IBU_SR_ATTACH_SECURITY_FUNC'), 'CSXSRISR');
332:

Line 331: l_function_name FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := nvl(FND_PROFILE.value('IBU_SR_ATTACH_SECURITY_FUNC'), 'CSXSRISR');

327: seq_num NUMBER := 10;
328: p_category_id NUMBER := nvl(FND_PROFILE.VALUE('IBU_A_SR_DEFAULT_ATTACHMENT_CATEGORY'), 1);
329: -- mkcyee 01/27/2004 - we obtain the function name from the profile
330: -- to secure attachments
331: l_function_name FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := nvl(FND_PROFILE.value('IBU_SR_ATTACH_SECURITY_FUNC'), 'CSXSRISR');
332:
333: begin
334: select NVL(max(seq_num),0) + 10
335: into seq_num

Line 574: l_sr_rec.category_set_id := FND_PROFILE.VALUE('CS_SR_DEFAULT_CATEGORY_SET');

570: l_sr_rec.category_id := null;
571: l_sr_rec.category_set_id := null;
572: else
573: l_sr_rec.category_id := p_inv_category_id;
574: l_sr_rec.category_set_id := FND_PROFILE.VALUE('CS_SR_DEFAULT_CATEGORY_SET');
575: end if;
576:
577: --l_sr_rec.resource_type := 'RS_EMPLOYEE';
578:

Line 652: l_sr_rec.customer_id := fnd_profile.value('IBU_EMP_SR_ORG');

648:
649: if (p_employee_id > 0) THEN
650: l_sr_rec.employee_id := p_employee_id;
651: /* Follwoing is added for handling employee logging SRs 03/07/03, klou */
652: l_sr_rec.customer_id := fnd_profile.value('IBU_EMP_SR_ORG');
653: l_sr_rec.caller_type := 'ORGANIZATION';
654: else
655: IF (p_product > 0) THEN
656: l_sr_rec.customer_product_id := p_product;

Line 827: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')

823: * to fully leverage TeleService Auto-Assignment feature in 11.5.7.1
824: * 11-APR-2002 KLOU, (ASSG)
825: */
826:
827: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
828: Into l_cs_atuo_assignment From dual;
829:
830: If l_cs_atuo_assignment = 'N' Then
831: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')

Line 831: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')

827: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
828: Into l_cs_atuo_assignment From dual;
829:
830: If l_cs_atuo_assignment = 'N' Then
831: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')
832: Into l_ibu_assignment From dual;
833:
834: If l_ibu_assignment = 'Y' Then
835:

Line 839: /* Select fnd_profile.value('CS_SR_DEFAULT_GROUP_TYPE')

835:
836: -- Start of Fix to Bug 6621657
837: -- Profile CS_SR_DEFAULT_GROUP_TYPE is obsoleted in 12.0.2 and 12.0.3.
838:
839: /* Select fnd_profile.value('CS_SR_DEFAULT_GROUP_TYPE')
840: * Into l_sr_rec.group_type From dual;
841: */
842:
843: l_sr_rec.group_type := 'RS_GROUP';

Line 847: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')

843: l_sr_rec.group_type := 'RS_GROUP';
844:
845: --End of Fix to Bug 6621657
846:
847: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')
848: Into l_sr_rec.owner_group_id From dual;
849:
850: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
851: Into l_sr_rec.owner_id From dual;

Line 850: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')

846:
847: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')
848: Into l_sr_rec.owner_group_id From dual;
849:
850: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
851: Into l_sr_rec.owner_id From dual;
852:
853: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')
854: into l_sr_rec.resource_type from dual;

Line 853: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')

849:
850: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
851: Into l_sr_rec.owner_id From dual;
852:
853: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')
854: into l_sr_rec.resource_type from dual;
855:
856: End If;
857: End If;

Line 1091: l_default_coverage_temp_id := fnd_profile.value('CS_SR_DEFAULT_COVERAGE');

1087: select fnd_global.resp_id, fnd_global.resp_appl_id, fnd_global.user_id, fnd_global.login_id
1088: into l_responsibility_id, l_resp_appl_id, l_user_id, l_login_id
1089: from dual;
1090: -- added for 11.5.10
1091: l_default_coverage_temp_id := fnd_profile.value('CS_SR_DEFAULT_COVERAGE');
1092:
1093: CS_ServiceRequest_PVT.Create_ServiceRequest(
1094: p_api_version => 4.0,
1095: p_init_msg_list => fnd_api.g_true,

Line 1448: l_status_id := fnd_profile.value('INC_DEFAULT_INCIDENT_STATUS');

1444:
1445: end if;
1446:
1447: if(l_group_id is null or l_group_id <= 0) then
1448: l_status_id := fnd_profile.value('INC_DEFAULT_INCIDENT_STATUS');
1449: end if;
1450: x_status_id := l_status_id;
1451:
1452: end get_default_status;