16: l_planned_effort Number;
17: l_planned_end_date Date;
18: BEGIN
19:
20: l_profile := fnd_profile.value('CS_SR_TSK_DEF_PLN_END_DT');
21: l_profile_respond_by := To_number(fnd_profile.value('CS_SR_TASK_RESPOND_BY'));
22:
23: if nvl(l_profile,'RESP_BY') = 'RESP_BY' Then
24:
17: l_planned_end_date Date;
18: BEGIN
19:
20: l_profile := fnd_profile.value('CS_SR_TSK_DEF_PLN_END_DT');
21: l_profile_respond_by := To_number(fnd_profile.value('CS_SR_TASK_RESPOND_BY'));
22:
23: if nvl(l_profile,'RESP_BY') = 'RESP_BY' Then
24:
25: If p_respond_by is not null and p_respond_by >= Sysdate Then
159: -- Simplex
160: -- Get the value for the profile option 'Service : Apply State Restriction on Tasks'
161: -- to decide the enabling/disabling of task state restrictions
162:
163: FND_PROFILE.Get('CS_SR_ENABLE_TASK_STATE_RESTRICTIONS',l_prof_val);
164:
165: -- end Simplex
166:
167: -- Loop through the Task Template table
279:
280: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
281: -- 12.1.3 Task enh proj
282: IF l_owner_id is null or l_owner_type is null Then
283: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_TASK_OWNER', l_owner_id);
284: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE', l_owner_type);
285:
286: l_task_template_tbl(i).owner_type_code := l_owner_type ;
287: l_task_template_tbl(i).owner_id := l_owner_id ;
280: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
281: -- 12.1.3 Task enh proj
282: IF l_owner_id is null or l_owner_type is null Then
283: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_TASK_OWNER', l_owner_id);
284: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE', l_owner_type);
285:
286: l_task_template_tbl(i).owner_type_code := l_owner_type ;
287: l_task_template_tbl(i).owner_id := l_owner_id ;
288: End If;
348: /* l_task_template_tbl(i).planned_start_date := sysdate ;
349:
350: IF p_service_request_rec.obligation_date IS NULL THEN
351: -- Bug 7281019, Calculate the planned end date from the profile when respond by date is null
352: l_profile_respond_by := to_number(fnd_profile.value('CS_SR_TASK_RESPOND_BY'));
353: l_task_template_tbl(i).planned_end_date := sysdate + nvl(l_profile_respond_by,0);
354: --l_task_template_tbl(i).planned_end_date := sysdate ; -- NULL;
355: ELSIF (p_service_request_rec.obligation_date > sysdate) THEN
356: l_task_template_tbl(i).planned_end_date := sysdate +(p_service_request_rec.obligation_date -sysdate);
781:
782: If l_all_attrs_passed = TRUE Then
783:
784: -- Get the category set from the relevant site-level profile
785: l_category_set_id := fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET');
786:
787: for l_category_rec in c_category(l_category_set_id)
788: loop
789: /*