APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on DUAL

Line 3264: * The individual category names should be separated by

3260: * latest version of all solutions in a particular category.
3261: * Parameters:
3262: * p_category_name - This should be the full textual path
3263: * of the category for which solutions will be exported.
3264: * The individual category names should be separated by
3265: * a '>'. Example: 'Home>Desktop>Monitor'
3266: * p_sol_status - One of 2 mode values: ALL or PUB. This
3267: * determines whether only published solutions are exported
3268: * or the latest version of all non-obsoleted solutions

Line 3448: Select nvl(fnd_profile.value('CS_KB_USAGE_TIME_SPAN'), 365) from dual;

3444: p_commit IN VARCHAR2 := FND_API.G_FALSE)
3445: IS
3446: -- Default time usage to 1 year if the profile is not set.
3447: CURSOR Get_Time_Usage_Csr IS
3448: Select nvl(fnd_profile.value('CS_KB_USAGE_TIME_SPAN'), 365) from dual;
3449:
3450: -- Bug 32170161, replace sum with avg.
3451: CURSOR Get_Avg_Score_Csr(p_time_usge_span NUMBER) IS
3452: select avg(usage_score)/p_time_usge_span

Line 3469: select fnd_profile.value('CS_KB_USAGE_LIMIT_FACTOR') from dual;

3465: where status = 'PUB'
3466: and last_update_date > (sysdate - p_time_usage_span);
3467:
3468: CURSOR Get_Coefficient_Csr IS
3469: select fnd_profile.value('CS_KB_USAGE_LIMIT_FACTOR') from dual;
3470:
3471: -- (4740480)
3472: CURSOR Get_Set_Count(p_time_usage_span NUMBER) IS
3473: SELECT count(set_id)

Line 3923: * The individual category names should be separated by

3919: *
3920: * Parameters:
3921: * p_category_name - This should be the full textual path
3922: * of the category for which solutions will be exported.
3923: * The individual category names should be separated by
3924: * the delimiter. Example: 'Home Desktop Monitor'
3925: * p_sol_status - One of 2 mode values: ALL or PUB. This
3926: * determines whether only published solutions are exported
3927: * or the latest version of all non-obsoleted solutions