1 PACKAGE OKC_K_NON_STD_ART_GRP AS
2 /* $Header: OKCGNSAS.pls 120.1 2005/08/11 10:22:10 vnanjang noship $ */
3
4 Procedure create_non_std_article(
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 ,
7 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_string IN VARCHAR2,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 p_article_title IN VARCHAR2,
15 p_article_type IN VARCHAR2 := NULL,
16
17 -- Article Version Attributes
18 p_article_text IN CLOB,
19 p_provision_yn IN VARCHAR2,
20 p_std_article_version_id IN NUMBER,
21 p_display_name IN VARCHAR2,
22 p_article_description IN VARCHAR2,
23
24 -- K Article Attributes
25 p_ref_type IN VARCHAR2 := 'SECTION', -- 'ARTICLE' or 'SECTION'
26 p_ref_id IN NUMBER, -- Id of okc_sections_b or okc_articles_b depending upon ref type
27 p_doc_type IN VARCHAR2,
28 p_doc_id IN NUMBER,
29 p_cat_id IN NUMBER := NULL, -- Should be passed when exsisitng std is modified to make non-std.If it is passed then ref_type and ref_id doesnt need to be passed.
30
31 p_amendment_description IN VARCHAR2 := NULL,
32 p_print_text_yn IN VARCHAR2 := NULL,
33 x_cat_id OUT NOCOPY NUMBER,
34 x_article_version_id OUT NOCOPY NUMBER
35 );
36
37 Procedure update_non_std_article(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 ,
40 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_string IN VARCHAR2,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_article_title IN VARCHAR2,
48 p_article_type IN VARCHAR2 := NULL,
49
50 -- Article Version Attributes
51 p_article_text IN CLOB,
52 p_provision_yn IN VARCHAR2,
53 p_display_name IN VARCHAR2,
54 p_article_description IN VARCHAR2,
55
56 -- K Article Attributes
57 p_doc_type IN VARCHAR2,
58 p_doc_id IN NUMBER,
59 p_cat_id IN NUMBER,
60 p_amendment_description IN VARCHAR2 := NULL,
61 p_print_text_yn IN VARCHAR2 := NULL,
62 x_cat_id OUT NOCOPY NUMBER,
63 x_article_version_id OUT NOCOPY NUMBER
64 ) ;
65
66 Procedure revert_to_standard(
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 ,
69 p_validate_commit IN VARCHAR2,
70 p_validation_string IN VARCHAR2,
71 p_commit IN VARCHAR2,
72 p_mode IN VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_doc_type IN VARCHAR2,
77 p_doc_id IN NUMBER,
78 p_k_art_id IN NUMBER,
79 x_cat_id OUT NOCOPY NUMBER,
80 x_article_version_id OUT NOCOPY NUMBER
81 );
82
83 END OKC_K_NON_STD_ART_GRP;