PACKAGE: APPS.OKC_CA_UTIL_PVT

Source

1 package okc_ca_util_pvt as
2 /* $Header: OKCCAUTLS.pls 120.4 2006/04/17 16:05:30 muteshev noship $ */
3 
4    procedure include_articles(   p_search_id in number,
5                                  p_alternates in varchar2,
6                                  p_adoptions in varchar2,
7                                  p_all_versions in varchar2,
8                                  p_non_standard in varchar2
9                                  );
10    procedure remove_results(  p_search_id in number);
11    procedure remove_included( p_search_id in number);
12    function article_title(  p_article_version_id in number)
13       return okc_articles_all.article_title%type;
14    function display_name(  p_article_version_id in number)
15       return okc_articles_all.article_title%type;
16    function article_version_number(  p_article_version_id in number)
17       return okc_article_versions.article_version_number%type;
18    function article_id(  p_article_version_id in number)
19       return okc_article_versions.article_id%type;
20    function org_id(  p_article_version_id in number)
21       return okc_articles_all.org_id%type;
22    function latest_article_version_id( p_article_version_id in number,
23                                        p_org_id in number)
24       return okc_article_versions.article_version_id%type;
25    function doc_type(   p_code in varchar2)
26       return okc_bus_doc_types_tl.name%type;
27    function neg_supplier(  p_auction_header_id in number)
28       return hz_parties.party_name%type;
29 
30    function bsa_subtype(  p_order_number in number)
31       return oe_transaction_types_tl.name%type;
32    function so_subtype(  p_order_number in number)
33       return oe_transaction_types_tl.name%type;
34 
35    function article_number(  p_article_id in number)
36       return okc_articles_all.article_number%type;
37 
38 end;