1 PACKAGE OKC_K_NON_STD_ART_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGNSAS.pls 120.3 2011/12/09 13:37:04 serukull ship $ */
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 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
24 p_article_text_in_word IN BLOB DEFAULT NULL,
25
26 -- K Article Attributes
27 p_ref_type IN VARCHAR2 := 'SECTION', -- 'ARTICLE' or 'SECTION'
28 p_ref_id IN NUMBER, -- Id of okc_sections_b or okc_articles_b depending upon ref type
29 p_doc_type IN VARCHAR2,
30 p_doc_id IN NUMBER,
31 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.
32
33 p_amendment_description IN VARCHAR2 := NULL,
34 p_print_text_yn IN VARCHAR2 := NULL,
35 x_cat_id OUT NOCOPY NUMBER,
36 x_article_version_id OUT NOCOPY NUMBER,
37 p_lock_terms_yn IN VARCHAR2 := 'N'
38 );
39
40 Procedure update_non_std_article(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 ,
43 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
44 p_validation_string IN VARCHAR2,
45 p_commit IN VARCHAR2 := FND_API.G_FALSE,
46 p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_article_title IN VARCHAR2,
51 p_article_type IN VARCHAR2 := NULL,
52
53 -- Article Version Attributes
54 p_article_text IN CLOB,
55 p_provision_yn IN VARCHAR2,
56 p_display_name IN VARCHAR2,
57 p_article_description IN VARCHAR2,
58 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
59 p_article_text_in_word IN BLOB DEFAULT NULL,
60
61 -- K Article Attributes
62 p_doc_type IN VARCHAR2,
63 p_doc_id IN NUMBER,
64 p_cat_id IN NUMBER,
65 p_amendment_description IN VARCHAR2 := NULL,
66 p_print_text_yn IN VARCHAR2 := NULL,
67 x_cat_id OUT NOCOPY NUMBER,
68 x_article_version_id OUT NOCOPY NUMBER,
69 p_lock_terms_yn IN VARCHAR2 := 'N'
70 ) ;
71
72 Procedure revert_to_standard(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 ,
75 p_validate_commit IN VARCHAR2,
76 p_validation_string IN VARCHAR2,
77 p_commit IN VARCHAR2,
78 p_mode IN VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_doc_type IN VARCHAR2,
83 p_doc_id IN NUMBER,
84 p_k_art_id IN NUMBER,
85 x_cat_id OUT NOCOPY NUMBER,
86 x_article_version_id OUT NOCOPY NUMBER,
87 p_lock_terms_yn IN VARCHAR2 := 'N'
88 );
89
90 END OKC_K_NON_STD_ART_GRP;