APPS.CS_ASSIGN_RESOURCE_PKG dependencies on FND_PROFILE

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

203: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: -- Set group_type as RS_GROUP always, if default_group_type profile is null
206: IF (l_sr_rec.group_type IS NULL) THEN
207: FND_PROFILE.Get('CS_SR_DEFAULT_GROUP_TYPE', l_default_group_type);
208: IF (l_default_group_type IS NULL) THEN
209: l_default_group_type := 'RS_GROUP';
210: END IF;
211: ELSE

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

240: x_msg_count => x_msg_count,
241: x_msg_data => x_msg_data
242: );
243: IF (l_grp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
244: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
245: x_owner_group_id := l_group_id;
246: x_territory_id := l_territory_id;
247: RETURN;
248: ELSE

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

336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
338: l_group_id := p_service_request_rec.owner_group_id ;
339:
340: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
341: RETURN;
342: ELSE
343: CS_ASSIGN_RESOURCE_PKG.Assign_Owner
344: ( p_init_msg_list => p_init_msg_list,

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

557: IF (p_group_type IS NOT NULL) THEN
558: l_resource_type := p_group_type;
559:
560: l_incident_id := p_incident_id;
561: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_AUTO_ASSIGN') = 'YES') THEN
562: SELECT business_process_id INTO l_business_process_id
563: FROM cs_incident_types
564: WHERE incident_type_id = l_sr_rec.type_id;
565: END IF;

Line 735: IF (FND_PROFILE.VALUE('CS_SR_CONTRACT_GROUP')= 'Y') THEN --Added By Nic

731: -- contract_preferred_resource flag to 'Y'.
732:
733: l_cust_prod_id := l_sr_rec.customer_product_id;
734: IF (l_contract_service_id IS NOT NULL) THEN
735: IF (FND_PROFILE.VALUE('CS_SR_CONTRACT_GROUP')= 'Y') THEN --Added By Nic
736: l_contract_res_flag := 'Y';
737: ELSE
738: l_contract_res_flag := 'N';
739: END IF;

Line 746: IF (FND_PROFILE.VALUE('CS_SR_TERRITORY_GROUP') = 'Y') THEN -- Added by nic

742: l_ib_resource_flag := 'Y';
743: ELSE
744: l_ib_resource_flag := 'N';
745: END IF;
746: IF (FND_PROFILE.VALUE('CS_SR_TERRITORY_GROUP') = 'Y') THEN -- Added by nic
747: l_territory_flag :='Y';
748: ELSE
749: l_territory_flag :='N';
750: END IF;

Line 752: FND_PROFILE.Get('CS_SR_CHK_RES_CAL_AVL', l_cs_sr_chk_res_cal_avl); --gasankar Calendar check feature added

748: ELSE
749: l_territory_flag :='N';
750: END IF;
751:
752: FND_PROFILE.Get('CS_SR_CHK_RES_CAL_AVL', l_cs_sr_chk_res_cal_avl); --gasankar Calendar check feature added
753:
754: If nvl(l_cs_sr_chk_res_cal_avl, 'N') <> 'N' Then
755: l_start_date := sysdate ;
756: l_end_date := sysdate ;

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

984: --IF ((l_incident_id IS NOT NULL) AND (p_group_id IS NOT NULL )) THEN
985: IF p_group_id IS NOT NULL THEN
986: l_group_id := p_group_id ;
987:
988: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_AUTO_ASSIGN') = 'YES') THEN
989: SELECT business_process_id INTO l_business_process_id
990: FROM cs_incident_types
991: WHERE incident_type_id = l_sr_rec.type_id;
992: END IF;

Line 1143: IF (FND_PROFILE.VALUE('CS_SR_CONTRACT_INDIVIDUAL')= 'Y') THEN --Added By Nic

1139: -- to 'Y'.If contract line id is not null, then set
1140: -- contract_preferred_resource flag to 'Y'.
1141: l_cust_prod_id := l_sr_rec.customer_product_id;
1142: IF (l_contract_service_id IS NOT NULL) THEN
1143: IF (FND_PROFILE.VALUE('CS_SR_CONTRACT_INDIVIDUAL')= 'Y') THEN --Added By Nic
1144: l_contract_res_flag := 'Y';
1145: ELSE
1146: l_contract_res_flag := 'N';
1147: END IF;

Line 1150: IF (FND_PROFILE.VALUE ('CS_SR_IB_INDIVIDUAL') ='Y' ) THEN -- Added by Nic

1146: l_contract_res_flag := 'N';
1147: END IF;
1148: END IF;
1149: IF (l_cust_prod_id IS NOT NULL) THEN
1150: IF (FND_PROFILE.VALUE ('CS_SR_IB_INDIVIDUAL') ='Y' ) THEN -- Added by Nic
1151: l_ib_resource_flag := 'Y';
1152: ELSE
1153: l_ib_resource_flag := 'N';
1154: END IF;

Line 1156: IF (FND_PROFILE.VALUE('CS_SR_TERRITORY_INDIVIDUAL') = 'Y') THEN -- Added by nic

1152: ELSE
1153: l_ib_resource_flag := 'N';
1154: END IF;
1155: END IF;
1156: IF (FND_PROFILE.VALUE('CS_SR_TERRITORY_INDIVIDUAL') = 'Y') THEN -- Added by nic
1157: l_territory_flag :='Y';
1158: ELSE
1159: l_territory_flag :='N';
1160: END IF;

Line 1162: FND_PROFILE.Get('CS_SR_CHK_RES_CAL_AVL', l_cs_sr_chk_res_cal_avl); --gasankar Calendar check feature added

1158: ELSE
1159: l_territory_flag :='N';
1160: END IF;
1161:
1162: FND_PROFILE.Get('CS_SR_CHK_RES_CAL_AVL', l_cs_sr_chk_res_cal_avl); --gasankar Calendar check feature added
1163:
1164: If nvl(l_cs_sr_chk_res_cal_avl, 'N') <> 'N' Then
1165: l_start_date := sysdate ;
1166: l_end_date := sysdate ;