1 PACKAGE OKC_TERMS_MULTIREC_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGMULS.pls 120.4 2011/12/09 13:36:27 serukull ship $ */
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 p_lock_terms_yn IN VARCHAR2 := 'N'
90 );
91
92 PROCEDURE update_structure(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 ,
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_validation_string IN VARCHAR2,
98 p_commit IN VARCHAR2 := FND_API.G_FALSE,
99 p_structure_tbl IN structure_tbl_type,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE sync_doc_with_expert(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 ,
108 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
109 p_validation_string IN VARCHAR2,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_doc_type IN VARCHAR2,
112 p_doc_id IN NUMBER,
113 p_article_id_tbl IN article_id_tbl_type,
114 p_mode IN VARCHAR2 := 'NORMAL',
115 x_articles_dropped OUT NOCOPY NUMBER,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_lock_terms_yn IN VARCHAR2 := 'N'
120 );
121
122 PROCEDURE refresh_articles(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 ,
125 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_validation_string IN VARCHAR2,
127 p_commit IN VARCHAR2 := FND_API.G_FALSE,
128 p_mode IN VARCHAR2 :='NORMAL',
129 p_doc_type IN VARCHAR2,
130 p_doc_id IN NUMBER,
131 p_article_tbl IN article_tbl_type,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_lock_terms_yn IN VARCHAR2 := 'N'
136 );
137
138 PROCEDURE organize_layout(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 ,
141 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
143 p_validation_string IN VARCHAR2,
144 p_commit IN VARCHAR2 := FND_API.G_FALSE,
145 p_organize_tbl IN ORGANIZE_TBL_TYPE,
146 p_ref_point IN VARCHAR2 := 'A', -- Possible values
147 -- 'A'=After,'B'=Before,'S' = Subsection
148 p_doc_type IN VARCHAR2,
149 p_doc_id IN NUMBER,
150 p_to_object_type IN VARCHAR2,
151 p_to_object_id IN NUMBER,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2
155 );
156
157 PROCEDURE merge_review_clauses(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 ,
160 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
162 p_validation_string IN VARCHAR2,
163 p_commit IN VARCHAR2 := FND_API.G_FALSE,
164 p_merge_review_tbl IN MERGE_REVIEW_TBL_TYPE,
165 p_doc_type IN VARCHAR2,
166 p_doc_id IN NUMBER,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2
170 );
171
172 PROCEDURE sort_clauses(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 ,
175 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
177 p_validation_string IN VARCHAR2,
178 p_commit IN VARCHAR2 := FND_API.G_FALSE,
179 p_doc_type IN VARCHAR2,
180 p_doc_id IN NUMBER,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2
184 );
185
186 END OKC_TERMS_MULTIREC_GRP;
[Home] [Help]