1 PACKAGE OKC_TERMS_MULTIREC_GRP AS
2 /* $Header: OKCGMULS.pls 120.2 2005/09/13 22:20:34 vnanjang noship $ */
3
4 TYPE art_var_rec_type IS RECORD (
5 cat_id OKC_K_ART_VARIABLES.cat_id%type,
6 variable_code OKC_K_ART_VARIABLES.variable_code%type,
7 variable_type OKC_K_ART_VARIABLES.variable_type%type,
8 external_yn OKC_K_ART_VARIABLES.external_yn%type,
9 variable_value_id OKC_K_ART_VARIABLES.variable_value_id%type,
10 variable_value OKC_K_ART_VARIABLES.variable_value%type,
11 attribute_value_set_id OKC_K_ART_VARIABLES.attribute_value_set_id%type,
12 object_version_number OKC_K_ART_VARIABLES.object_version_number%type
13 );
14
15 TYPE kart_rec_type IS RECORD (
16 id OKC_K_ARTICLES_B.id%type,
17 sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%type,
18 article_version_id OKC_K_ARTICLES_B.article_version_id%type,
19 amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,
20 print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE,
21 ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE,
22 ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE
23 );
24
25 TYPE organize_rec_type IS RECORD (
26 object_type VARCHAR(30),
27 id NUMBER
28 );
29
30 TYPE structure_rec_type IS RECORD (
31 type VARCHAR(30),
32 id NUMBER,
33 scn_id NUMBER,
34 display_sequence NUMBER,
35 label VARCHAR2(15),
36 mandatory_yn VARCHAR2(1),
37 object_version_number OKC_K_ARTICLES_B.object_version_number%type
38 );
39 TYPE article_rec_type IS RECORD (
40 cat_id OKC_K_ARTICLES_B.cat_id%type,
41 article_version_id OKC_K_ARTICLES_B.article_version_id%type,
42 ovn OKC_K_ARTICLES_B.object_version_number%type
43 );
44
45 TYPE merge_review_rec_type IS RECORD (
46 object_type VARCHAR(30),
47 review_upld_terms_id NUMBER,
48 object_version_number NUMBER
49 );
50 TYPE art_var_tbl_type IS TABLE OF art_var_rec_type INDEX BY BINARY_INTEGER;
51 TYPE kart_tbl_type IS TABLE OF kart_rec_type INDEX BY BINARY_INTEGER;
52 TYPE structure_tbl_type IS TABLE OF structure_rec_type INDEX BY BINARY_INTEGER;
53 TYPE article_id_tbl_type IS TABLE OF OKC_ARTICLES_ALL.article_id%type INDEX BY BINARY_INTEGER;
54 TYPE article_tbl_type IS TABLE OF article_rec_type INDEX BY BINARY_INTEGER;
55 TYPE organize_tbl_type IS TABLE OF organize_rec_type INDEX BY BINARY_INTEGER;
56 TYPE merge_review_tbl_type IS TABLE OF merge_review_rec_type INDEX BY BINARY_INTEGER;
57
58 PROCEDURE create_article(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 ,
61 p_mode IN VARCHAR2 := 'NORMAL',
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_validation_string IN VARCHAR2,
65 p_commit IN VARCHAR2 := FND_API.G_FALSE,
66 p_ref_type IN VARCHAR2 := 'SECTION', -- 'ARTICLE' or 'SECTION'
67 p_ref_id IN NUMBER, --Id of okc_sections_b or okc_articles_b depending upon ref type
68 p_doc_type IN VARCHAR2,
69 p_doc_id IN NUMBER,
70 p_kart_tbl IN kart_tbl_type,
71 x_kart_tbl OUT NOCOPY kart_tbl_type,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE update_article_variable(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 ,
80 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_string IN VARCHAR2,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE,
84 p_art_var_tbl IN art_var_tbl_type,
85 p_mode IN VARCHAR2 := 'NORMAL',
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE update_structure(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 ,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
96 p_validation_string IN VARCHAR2,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_structure_tbl IN structure_tbl_type,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104 PROCEDURE sync_doc_with_expert(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 ,
107 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_validation_string IN VARCHAR2,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110 p_doc_type IN VARCHAR2,
111 p_doc_id IN NUMBER,
112 p_article_id_tbl IN article_id_tbl_type,
113 p_mode IN VARCHAR2 := 'NORMAL',
114 x_articles_dropped OUT NOCOPY NUMBER,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2
118 );
119
120 PROCEDURE refresh_articles(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 ,
123 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_string IN VARCHAR2,
125 p_commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_mode IN VARCHAR2 :='NORMAL',
127 p_doc_type IN VARCHAR2,
128 p_doc_id IN NUMBER,
129 p_article_tbl IN article_tbl_type,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE organize_layout(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 ,
138 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
140 p_validation_string IN VARCHAR2,
141 p_commit IN VARCHAR2 := FND_API.G_FALSE,
142 p_organize_tbl IN ORGANIZE_TBL_TYPE,
143 p_ref_point IN VARCHAR2 := 'A', -- Possible values
144 -- 'A'=After,'B'=Before,'S' = Subsection
145 p_doc_type IN VARCHAR2,
146 p_doc_id IN NUMBER,
147 p_to_object_type IN VARCHAR2,
148 p_to_object_id IN NUMBER,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154 PROCEDURE merge_review_clauses(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 ,
157 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
159 p_validation_string IN VARCHAR2,
160 p_commit IN VARCHAR2 := FND_API.G_FALSE,
161 p_merge_review_tbl IN MERGE_REVIEW_TBL_TYPE,
162 p_doc_type IN VARCHAR2,
163 p_doc_id IN NUMBER,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2
167 );
168 END OKC_TERMS_MULTIREC_GRP;