APPS.CS_SR_MASS_UPDATE_PKG dependencies on FND_PROFILE

Line 65: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_FORMS'), 'N')

61: x_param_msg_data := JTF_VARCHAR2_TABLE_4000();
62:
63: CS_SERVICEREQUEST_PVT.INITIALIZE_REC(p_sr_record => l_sr_rec);
64:
65: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_FORMS'), 'N')
66: Into l_cs_auto_assignment From dual;
67:
68: if(l_cs_auto_assignment = 'Y') then
69: if (p_owner_group_id is not NULL and p_owner_id is not NULL) then

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

113: l_sr_rec.resolution_code := p_resolution_code;
114: end if;
115: select fnd_global.resp_id into l_responsibility_id from dual;
116:
117: l_temp_close_value := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
118: if (l_temp_close_value = 'CS_SR_VALIDATE_AND_CLOSE') then
119: l_auto_close_child_entities := 'Y';
120: l_validate_sr_closure := 'Y';
121: end if;