[Home] [Help]
3250: * latest version of all solutions in a particular category.
3251: * Parameters:
3252: * p_category_name - This should be the full textual path
3253: * of the category for which solutions will be exported.
3254: * The individual category names should be separated by
3255: * a '>'. Example: 'Home>Desktop>Monitor'
3256: * p_sol_status - One of 2 mode values: ALL or PUB. This
3257: * determines whether only published solutions are exported
3258: * or the latest version of all non-obsoleted solutions
3434: p_commit IN VARCHAR2 := FND_API.G_FALSE)
3435: IS
3436: -- Default time usage to 1 year if the profile is not set.
3437: CURSOR Get_Time_Usage_Csr IS
3438: Select nvl(fnd_profile.value('CS_KB_USAGE_TIME_SPAN'), 365) from dual;
3439:
3440: -- Bug 32170161, replace sum with avg.
3441: CURSOR Get_Avg_Score_Csr(p_time_usge_span NUMBER) IS
3442: select avg(usage_score)/p_time_usge_span
3455: where status = 'PUB'
3456: and last_update_date > (sysdate - p_time_usage_span);
3457:
3458: CURSOR Get_Coefficient_Csr IS
3459: select fnd_profile.value('CS_KB_USAGE_LIMIT_FACTOR') from dual;
3460:
3461: -- (4740480)
3462: CURSOR Get_Set_Count(p_time_usage_span NUMBER) IS
3463: SELECT count(set_id)
3909: *
3910: * Parameters:
3911: * p_category_name - This should be the full textual path
3912: * of the category for which solutions will be exported.
3913: * The individual category names should be separated by
3914: * the delimiter. Example: 'Home
3915: * p_sol_status - One of 2 mode values: ALL or PUB. This
3916: * determines whether only published solutions are exported
3917: * or the latest version of all non-obsoleted solutions