APPS.OKC_STD_ARTICLE_PVT dependencies on OKC_STD_ART_VERSIONS_B

Line 455: select '1' from OKC_STD_ART_VERSIONS_B where sae_id=id;

451: x_msg_data OUT NOCOPY VARCHAR2,
452: p_saev_rec IN saev_rec_type) IS
453:
454: Cursor l_ver(id number) is
455: select '1' from OKC_STD_ART_VERSIONS_B where sae_id=id;
456: Cursor l_set(id number) is
457: select '1' from OKC_STD_ART_SET_MEMS where sae_id=id;
458: Cursor l_incmpt(id number) is
459: select '1' from OKC_STD_ART_INCMPTS where sae_id=id;

Line 2264: l_latest_release okc_std_art_versions_b.sav_release%TYPE := '';

2260: )
2261: RETURN VARCHAR2 IS
2262:
2263:
2264: l_latest_release okc_std_art_versions_b.sav_release%TYPE := '';
2265:
2266: /*
2267: We check the latest release based on the following
2268: 1. date_active

Line 2277: FROM okc_std_art_versions_b

2273: */
2274:
2275: CURSOR csr_latest_release IS
2276: SELECT sav_release
2277: FROM okc_std_art_versions_b
2278: WHERE sae_id = p_sav_sae_id
2279: AND date_active <= sysdate
2280: ORDER BY date_active DESC, creation_date DESC ;
2281:

Line 2304: l_latest_release okc_std_art_versions_b.sav_release%TYPE := '';

2300: This function returns 'Y' if
2301: The current article release is latest release
2302: */
2303:
2304: l_latest_release okc_std_art_versions_b.sav_release%TYPE := '';
2305:
2306: BEGIN
2307: l_latest_release := latest_release(p_sav_sae_id);
2308:

Line 2320: p_date_active IN okc_std_art_versions_b.date_active%TYPE

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

Line 2333: l_latest_release okc_std_art_versions_b.sav_release%TYPE := '';

2329: 1. It is NOT used in any contracts
2330: 2. It is the latest release OR future dated release.
2331: */
2332:
2333: l_latest_release okc_std_art_versions_b.sav_release%TYPE := '';
2334:
2335: BEGIN
2336:
2337: -- check if future release