610: p_samv_rec IN samv_rec_type);
611:
612: FUNCTION used_in_contracts
613: (
614: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
615: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
616: )
617: RETURN VARCHAR2 ;
618:
611:
612: FUNCTION used_in_contracts
613: (
614: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
615: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
616: )
617: RETURN VARCHAR2 ;
618:
619: FUNCTION empclob RETURN CLOB;
619: FUNCTION empclob RETURN CLOB;
620:
621: FUNCTION latest_release
622: (
623: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE
624: )
625: RETURN VARCHAR2 ;
626:
627: FUNCTION latest_release
625: RETURN VARCHAR2 ;
626:
627: FUNCTION latest_release
628: (
629: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
630: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
631: )
632: RETURN VARCHAR2 ;
633:
626:
627: FUNCTION latest_release
628: (
629: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
630: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE
631: )
632: RETURN VARCHAR2 ;
633:
634: FUNCTION latest_or_future_release
632: RETURN VARCHAR2 ;
633:
634: FUNCTION latest_or_future_release
635: (
636: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
637: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE,
638: p_date_active IN okc_std_art_versions_b.date_active%TYPE
639: )
640: RETURN VARCHAR2 ;
633:
634: FUNCTION latest_or_future_release
635: (
636: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
637: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE,
638: p_date_active IN okc_std_art_versions_b.date_active%TYPE
639: )
640: RETURN VARCHAR2 ;
641:
642: -- Bug 3188215 KOL: BACKWARD COMPATIBILITY CHANGES
643: -- Function Signature for the new API function
644: FUNCTION art_used_in_contracts
645: (
646: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
647: p_article_version_number IN okc_article_versions.article_version_number%TYPE
648: )
649: RETURN VARCHAR2 ;
650:
652: -- Bug 3188215 KOL: BACKWARD COMPATIBILITY CHANGES
653: -- Function Signature for the new API function
654: FUNCTION latest_art_release
655: (
656: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE
657: )
658: RETURN VARCHAR2 ;
659:
660:
661: -- Bug 3188215 KOL: BACKWARD COMPATIBILITY CHANGES
662: -- Function Signature for the new API function
663: FUNCTION latest_art_release
664: (
665: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
666: p_article_version_number IN okc_article_versions.article_version_number%TYPE
667: )
668: RETURN VARCHAR2 ;
669:
670: -- Bug 3188215 KOL: BACKWARD COMPATIBILITY CHANGES
671: -- Function Signature for the new API function
672: FUNCTION latest_or_future_art_release
673: (
674: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,
675: p_article_version_number IN okc_article_versions.article_version_number%TYPE,
676: p_date_active IN okc_article_versions.start_date%TYPE
677: )
678: RETURN VARCHAR2 ;