DBA Data[Home] [Help]

APPS.OKC_STD_ARTICLE_PUB dependencies on OKC_K_ARTICLES_B

Line 3641: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

3637: -- modified the function to call the new api function
3638: -- art_used_in_contracts
3639: FUNCTION used_in_contracts
3640: (
3641: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
3642: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
3643: )
3644: RETURN VARCHAR2 IS
3645:

Line 3642: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE

3638: -- art_used_in_contracts
3639: FUNCTION used_in_contracts
3640: (
3641: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
3642: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
3643: )
3644: RETURN VARCHAR2 IS
3645:
3646: BEGIN

Line 3662: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE

3658: END empclob;
3659:
3660: FUNCTION latest_release
3661: (
3662: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE
3663: )
3664: RETURN VARCHAR2 IS
3665:
3666: BEGIN

Line 3677: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

3673: -- modified the function to call the new api function
3674: -- latest_art_release
3675: FUNCTION latest_release
3676: (
3677: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
3678: p_article_version_number IN okc_article_versions.article_version_number%TYPE
3679: )
3680: RETURN VARCHAR2 IS
3681:

Line 3693: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

3689: -- modified the function to call the new api function
3690: -- latest_or_future_art_release
3691: FUNCTION latest_or_future_release
3692: (
3693: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
3694: p_article_version_number IN okc_article_versions.article_version_number%TYPE,
3695: p_date_active IN okc_article_versions.start_date%TYPE
3696: )
3697: RETURN VARCHAR2 IS