DBA Data[Home] [Help]

APPS.CS_AUTOGEN_TASK_PVT dependencies on FND_PROFILE

Line 20: l_profile := fnd_profile.value('CS_SR_TSK_DEF_PLN_END_DT');

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:

Line 21: l_profile_respond_by := To_number(fnd_profile.value('CS_SR_TASK_RESPOND_BY'));

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

Line 163: FND_PROFILE.Get('CS_SR_ENABLE_TASK_STATE_RESTRICTIONS',l_prof_val);

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

Line 283: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_TASK_OWNER', l_owner_id);

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 ;

Line 284: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE', l_owner_type);

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;

Line 352: l_profile_respond_by := to_number(fnd_profile.value('CS_SR_TASK_RESPOND_BY'));

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);

Line 785: l_category_set_id := fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET');

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: /*