DBA Data[Home] [Help]

APPS.CS_AUTOGEN_TASK_PVT dependencies on OKC_TIME_UTIL_PUB

Line 32: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);

28: ElsIf l_profile_respond_by is not null Then
29: select sysdate + l_profile_respond_by into l_planned_end_date from dual;
30:
31: Elsif p_planned_effort is not null and p_uom_code is not null then
32: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);
33: End If;
34:
35: Elsif l_profile = 'RESL_EFFORT' Then
36:

Line 43: l_planned_end_date := okc_time_util_pub.get_enddate(p_resolve_by,p_uom_code,l_planned_effort);

39:
40: Elsif p_resolve_by is not null and p_resolve_by >= Sysdate then
41: IF p_planned_effort is not null and p_uom_code is not null then
42: l_planned_effort := p_planned_effort * (-1);
43: l_planned_end_date := okc_time_util_pub.get_enddate(p_resolve_by,p_uom_code,l_planned_effort);
44:
45: End IF;
46: Elsif l_profile_respond_by is not null Then
47: select sysdate + l_profile_respond_by into l_planned_end_date from dual;

Line 50: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);

46: Elsif l_profile_respond_by is not null Then
47: select sysdate + l_profile_respond_by into l_planned_end_date from dual;
48:
49: Elsif p_planned_effort is not null and p_uom_code is not null then
50: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);
51:
52: End if;
53: Elsif l_profile = 'RESL_BY' then
54: If p_resolve_by is not null and p_resolve_by >= Sysdate then

Line 61: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);

57: elsif l_profile_respond_by is not null Then
58: select sysdate + l_profile_respond_by into l_planned_end_date from dual;
59:
60: Elsif p_planned_effort is not null and p_uom_code is not null then
61: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);
62: End if;
63: End if;
64:
65: If l_planned_end_date < sysdate or l_planned_end_date is null then