APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on FND_PROFILE

Line 150: -- l_load_balance_forms := fnd_profile.value('CS_LOAD_BALANCING_REQD_FORMS');

146: and p_incident_severity5_id IS NULL));
147:
148:
149: BEGIN
150: -- l_load_balance_forms := fnd_profile.value('CS_LOAD_BALANCING_REQD_FORMS');
151: -- l_load_balance_html := fnd_profile.value('CS_LOAD_BALANCING_REQD_HTML');
152: OPEN cs_incident_id_csr ;
153: LOOP
154: FETCH cs_incident_id_csr INTO l_sr_number,l_incident_id,

Line 151: -- l_load_balance_html := fnd_profile.value('CS_LOAD_BALANCING_REQD_HTML');

147:
148:
149: BEGIN
150: -- l_load_balance_forms := fnd_profile.value('CS_LOAD_BALANCING_REQD_FORMS');
151: -- l_load_balance_html := fnd_profile.value('CS_LOAD_BALANCING_REQD_HTML');
152: OPEN cs_incident_id_csr ;
153: LOOP
154: FETCH cs_incident_id_csr INTO l_sr_number,l_incident_id,
155: l_object_version_number,l_type_id,l_severity_id,l_inv_item_id,

Line 368: FND_PROFILE.Get('CS_SR_DEFAULT_GROUP_TYPE', l_default_group_type);

364: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: -- if default_group_type profile is null, set default to RS_GROUP for API always
367: IF (l_sr_rec.group_type IS NULL) THEN
368: FND_PROFILE.Get('CS_SR_DEFAULT_GROUP_TYPE', l_default_group_type);
369: IF (l_default_group_type IS NULL) THEN
370: l_default_group_type := 'RS_GROUP';
371: END IF;
372: ELSE

Line 406: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN

402: x_msg_count => x_msg_count,
403: x_msg_data => x_msg_data
404: );
405: IF (l_grp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
406: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
407: x_owner_group_id := l_group_id;
408: IF (l_group_id IS NOT NULL) THEN
409: l_update_grp_flag := 'Y';
410: END IF;

Line 506: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN

502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
504: l_group_id := p_service_request_rec.owner_group_id ;
505:
506: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
507: x_owner_group_id := l_group_id;
508: RETURN;
509: ELSE
510: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Owner

Line 723: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_AUTO_ASSIGN') = 'YES') THEN

719: -- group type must have a value - default is RS_GROUP, passed by caller
720: IF (l_incident_id IS NOT NULL) AND (p_group_type IS NOT NULL) THEN
721: l_resource_type := p_group_type;
722:
723: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_AUTO_ASSIGN') = 'YES') THEN
724: SELECT business_process_id INTO l_business_process_id
725: FROM cs_incident_types
726: WHERE incident_type_id = l_sr_rec.type_id;
727: END IF;

Line 1057: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_AUTO_ASSIGN') = 'YES') THEN

1053: -- if incident_id is not null proceed, otherwise exit API
1054: IF ((l_incident_id IS NOT NULL) AND (p_group_id IS NOT NULL )) THEN
1055: l_group_id := p_group_id ;
1056:
1057: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_AUTO_ASSIGN') = 'YES') THEN
1058: SELECT business_process_id INTO l_business_process_id
1059: FROM cs_incident_types
1060: WHERE incident_type_id = l_sr_rec.type_id;
1061: END IF;