DBA Data[Home] [Help]

APPS.OKC_STD_ARTICLE_PVT dependencies on OKC_K_ARTICLES_B

Line 614: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

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:

Line 615: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%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:
619: FUNCTION empclob RETURN CLOB;

Line 623: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE

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

Line 629: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

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:

Line 630: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE

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

Line 636: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

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 ;

Line 637: p_sav_sav_release IN okc_k_articles_b.sav_sav_release%TYPE,

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:

Line 646: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

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:

Line 656: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE

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:

Line 665: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

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:

Line 674: p_sav_sae_id IN okc_k_articles_b.sav_sae_id%TYPE,

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 ;