2205: END validate_unique;
2206:
2207: FUNCTION used_in_contracts
2208: (
2209: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2210: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
2211: )
2212: RETURN VARCHAR2 IS
2213: /*
2206:
2207: FUNCTION used_in_contracts
2208: (
2209: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2210: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
2211: )
2212: RETURN VARCHAR2 IS
2213: /*
2214: This function is used in view okc_kol_std_art_lib_v
2255:
2256:
2257: FUNCTION latest_release
2258: (
2259: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE
2260: )
2261: RETURN VARCHAR2 IS
2262:
2263:
2290: END latest_release;
2291:
2292: FUNCTION latest_release
2293: (
2294: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2295: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
2296: )
2297: RETURN VARCHAR2 IS
2298: /*
2291:
2292: FUNCTION latest_release
2293: (
2294: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2295: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
2296: )
2297: RETURN VARCHAR2 IS
2298: /*
2299: This function is used in view okc_kol_std_art_latest_rel_v
2314: END latest_release;
2315:
2316: FUNCTION latest_or_future_release
2317: (
2318: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2319: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE,
2320: p_date_active IN okc_std_art_versions_b.date_active%TYPE
2321: )
2322: RETURN VARCHAR2 IS
2315:
2316: FUNCTION latest_or_future_release
2317: (
2318: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2319: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE,
2320: p_date_active IN okc_std_art_versions_b.date_active%TYPE
2321: )
2322: RETURN VARCHAR2 IS
2323: /*
2353: -- Bug 3188215 KOL: BACKWARD COMPATIBILITY CHANGES
2354: -- Introduced the new api fundtion.
2355: FUNCTION art_used_in_contracts
2356: (
2357: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2358: p_article_version_number IN okc_article_versions.article_version_number%TYPE
2359: )
2360: RETURN VARCHAR2 IS
2361: /*
2368: l_count NUMBER;
2369:
2370: CURSOR csr_cnt_k IS
2371: SELECT COUNT(*)
2372: FROM okc_article_versions a, okc_k_articles_b b
2373: WHERE b.sav_sae_id = p_sav_sae_id
2374: AND b.sav_sae_id = a.article_id
2375: AND ( a.article_version_number = p_article_version_number OR
2376: a.sav_release = to_char(p_article_version_number) );
2392: -- Bug 3188215 KOL: BACKWARD COMPATIBILITY CHANGES
2393: -- Introduced the new api fundtion.
2394: FUNCTION latest_art_release
2395: (
2396: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE
2397: )
2398: RETURN VARCHAR2 IS
2399:
2400:
2429: -- Bug 3188215 KOL: BACKWARD COMPATIBILITY CHANGES
2430: -- Introduced the new api fundtion.
2431: FUNCTION latest_art_release
2432: (
2433: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2434: p_article_version_number IN okc_article_versions.article_version_number%TYPE
2435: )
2436: RETURN VARCHAR2 IS
2437: /*
2456: -- Bug 3188215 KOL: BACKWARD COMPATIBILITY CHANGES
2457: -- Introduced the new api fundtion.
2458: FUNCTION latest_or_future_art_release
2459: (
2460: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
2461: p_article_version_number IN okc_article_versions.article_version_number%TYPE,
2462: p_date_active IN okc_article_versions.start_date%TYPE
2463: )
2464: RETURN VARCHAR2 IS