APPS.OKC_STD_ARTICLE_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 2358: p_article_version_number IN okc_article_versions.article_version_number%TYPE

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: /*
2362: This function is used in view okc_kol_std_art_lib_v

Line 2372: FROM okc_article_versions a, okc_k_articles_b b

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

Line 2401: l_latest_release okc_article_versions.sav_release%TYPE := ' ';

2397: )
2398: RETURN VARCHAR2 IS
2399:
2400:
2401: l_latest_release okc_article_versions.sav_release%TYPE := ' ';
2402:
2403: /*
2404: We check the latest release based on the following
2405: 1. date_active/start_date

Line 2414: FROM okc_article_versions

2410: */
2411:
2412: CURSOR csr_latest_release IS
2413: SELECT NVL(sav_release, to_char(article_version_number))
2414: FROM okc_article_versions
2415: WHERE article_id = p_sav_sae_id
2416: AND start_date <= sysdate
2417: ORDER BY start_date DESC, creation_date DESC ;
2418:

Line 2434: p_article_version_number IN okc_article_versions.article_version_number%TYPE

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: /*
2438: This function is used in view okc_kol_std_art_latest_rel_v

Line 2443: l_latest_release okc_article_versions.sav_release%TYPE := ' ';

2439: This function returns 'Y' if
2440: The current article version is latest release
2441: */
2442:
2443: l_latest_release okc_article_versions.sav_release%TYPE := ' ';
2444:
2445: BEGIN
2446: l_latest_release := latest_art_release(p_sav_sae_id);
2447:

Line 2461: p_article_version_number IN okc_article_versions.article_version_number%TYPE,

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

Line 2462: p_date_active IN okc_article_versions.start_date%TYPE

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
2465: /*
2466: This function is used in view okc_kol_std_art_lib_v

Line 2475: l_latest_release okc_article_versions.sav_release%TYPE := ' ';

2471: 1. It is NOT used in any contracts
2472: 2. It is the latest release OR future dated release.
2473: */
2474:
2475: l_latest_release okc_article_versions.sav_release%TYPE := ' ';
2476:
2477: BEGIN
2478:
2479: -- check if future release