[Home] [Help]
PACKAGE: APPS.OKC_TERMS_MULTIREC_GRP_W
Source
1 package okc_terms_multirec_grp_w AUTHID CURRENT_USER as
2 /* $Header: OKCWMULS.pls 120.3 2011/12/09 13:58:18 serukull ship $ */
3 procedure rosetta_table_copy_in_p5(t out nocopy okc_terms_multirec_grp.art_var_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_2000
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 );
12 procedure rosetta_table_copy_out_p5(t okc_terms_multirec_grp.art_var_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13 , a1 out nocopy JTF_VARCHAR2_TABLE_100
14 , a2 out nocopy JTF_VARCHAR2_TABLE_100
15 , a3 out nocopy JTF_VARCHAR2_TABLE_100
16 , a4 out nocopy JTF_VARCHAR2_TABLE_100
17 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
18 , a6 out nocopy JTF_NUMBER_TABLE
19 , a7 out nocopy JTF_NUMBER_TABLE
20 );
21
22 procedure rosetta_table_copy_in_p6(t out nocopy okc_terms_multirec_grp.kart_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_VARCHAR2_TABLE_2000
26 , a4 JTF_VARCHAR2_TABLE_100
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_NUMBER_TABLE
29 );
30 procedure rosetta_table_copy_out_p6(t okc_terms_multirec_grp.kart_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31 , a1 out nocopy JTF_NUMBER_TABLE
32 , a2 out nocopy JTF_NUMBER_TABLE
33 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
34 , a4 out nocopy JTF_VARCHAR2_TABLE_100
35 , a5 out nocopy JTF_NUMBER_TABLE
36 , a6 out nocopy JTF_NUMBER_TABLE
37 );
38
39 procedure rosetta_table_copy_in_p7(t out nocopy okc_terms_multirec_grp.structure_tbl_type, a0 JTF_VARCHAR2_TABLE_100
40 , a1 JTF_NUMBER_TABLE
41 , a2 JTF_NUMBER_TABLE
42 , a3 JTF_NUMBER_TABLE
43 , a4 JTF_VARCHAR2_TABLE_100
44 , a5 JTF_VARCHAR2_TABLE_100
45 , a6 JTF_NUMBER_TABLE
46 );
47 procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
48 , a1 out nocopy JTF_NUMBER_TABLE
49 , a2 out nocopy JTF_NUMBER_TABLE
50 , a3 out nocopy JTF_NUMBER_TABLE
51 , a4 out nocopy JTF_VARCHAR2_TABLE_100
52 , a5 out nocopy JTF_VARCHAR2_TABLE_100
53 , a6 out nocopy JTF_NUMBER_TABLE
54 );
55
56 procedure rosetta_table_copy_in_p8(t out nocopy okc_terms_multirec_grp.article_id_tbl_type, a0 JTF_NUMBER_TABLE);
57 procedure rosetta_table_copy_out_p8(t okc_terms_multirec_grp.article_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
58
59 procedure rosetta_table_copy_in_p9(t out nocopy okc_terms_multirec_grp.article_tbl_type, a0 JTF_NUMBER_TABLE
60 , a1 JTF_NUMBER_TABLE
61 , a2 JTF_NUMBER_TABLE
62 );
63 procedure rosetta_table_copy_out_p9(t okc_terms_multirec_grp.article_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64 , a1 out nocopy JTF_NUMBER_TABLE
65 , a2 out nocopy JTF_NUMBER_TABLE
66 );
67
68 procedure rosetta_table_copy_in_p10(t out nocopy okc_terms_multirec_grp.organize_tbl_type, a0 JTF_VARCHAR2_TABLE_100
69 , a1 JTF_NUMBER_TABLE
70 );
71 procedure rosetta_table_copy_out_p10(t okc_terms_multirec_grp.organize_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
72 , a1 out nocopy JTF_NUMBER_TABLE
73 );
74
75 procedure rosetta_table_copy_in_p11(t out nocopy okc_terms_multirec_grp.merge_review_tbl_type, a0 JTF_VARCHAR2_TABLE_100
76 , a1 JTF_NUMBER_TABLE, a2 JTF_NUMBER_TABLE
77 );
78
79
80 procedure create_article(p_api_version NUMBER
81 , p_init_msg_list VARCHAR2
82 , p_mode VARCHAR2
83 , p_validation_level NUMBER
84 , p_validate_commit VARCHAR2
85 , p_validation_string VARCHAR2
86 , p_commit VARCHAR2
87 , p_ref_type VARCHAR2
88 , p_ref_id NUMBER
89 , p_doc_type VARCHAR2
90 , p_doc_id NUMBER
91 , p11_a0 JTF_NUMBER_TABLE
92 , p11_a1 JTF_NUMBER_TABLE
93 , p11_a2 JTF_NUMBER_TABLE
94 , p11_a3 JTF_VARCHAR2_TABLE_2000
95 , p11_a4 JTF_VARCHAR2_TABLE_100
96 , p11_a5 JTF_NUMBER_TABLE
97 , p11_a6 JTF_NUMBER_TABLE
98 , p12_a0 out nocopy JTF_NUMBER_TABLE
99 , p12_a1 out nocopy JTF_NUMBER_TABLE
100 , p12_a2 out nocopy JTF_NUMBER_TABLE
101 , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
102 , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
103 , p12_a5 out nocopy JTF_NUMBER_TABLE
104 , p12_a6 out nocopy JTF_NUMBER_TABLE
105 , x_return_status out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , x_msg_data out nocopy VARCHAR2
108 );
109 procedure update_article_variable(p_api_version NUMBER
110 , p_init_msg_list VARCHAR2
111 , p_validation_level NUMBER
112 , p_validate_commit VARCHAR2
113 , p_validation_string VARCHAR2
114 , p_commit VARCHAR2
115 , p6_a0 JTF_NUMBER_TABLE
116 , p6_a1 JTF_VARCHAR2_TABLE_100
117 , p6_a2 JTF_VARCHAR2_TABLE_100
118 , p6_a3 JTF_VARCHAR2_TABLE_100
119 , p6_a4 JTF_VARCHAR2_TABLE_100
120 , p6_a5 JTF_VARCHAR2_TABLE_2000
121 , p6_a6 JTF_NUMBER_TABLE
122 , p6_a7 JTF_NUMBER_TABLE
123 , p_mode VARCHAR2
124 , x_return_status out nocopy VARCHAR2
125 , x_msg_count out nocopy NUMBER
126 , x_msg_data out nocopy VARCHAR2
127 , p_lock_terms_yn IN VARCHAR2 := 'N'
128
129 );
130 procedure update_structure(p_api_version NUMBER
131 , p_init_msg_list VARCHAR2
132 , p_validation_level NUMBER
133 , p_validate_commit VARCHAR2
134 , p_validation_string VARCHAR2
135 , p_commit VARCHAR2
136 , p6_a0 JTF_VARCHAR2_TABLE_100
137 , p6_a1 JTF_NUMBER_TABLE
138 , p6_a2 JTF_NUMBER_TABLE
139 , p6_a3 JTF_NUMBER_TABLE
140 , p6_a4 JTF_VARCHAR2_TABLE_100
141 , p6_a5 JTF_VARCHAR2_TABLE_100
142 , p6_a6 JTF_NUMBER_TABLE
143 , x_return_status out nocopy VARCHAR2
144 , x_msg_count out nocopy NUMBER
145 , x_msg_data out nocopy VARCHAR2
146 );
147 procedure sync_doc_with_expert(p_api_version NUMBER
148 , p_init_msg_list VARCHAR2
149 , p_validate_commit VARCHAR2
150 , p_validation_string VARCHAR2
151 , p_commit VARCHAR2
152 , p_doc_type VARCHAR2
153 , p_doc_id NUMBER
154 , p_article_id_tbl JTF_NUMBER_TABLE
155 , p_mode VARCHAR2
156 , x_articles_dropped out nocopy NUMBER
157 , x_return_status out nocopy VARCHAR2
158 , x_msg_count out nocopy NUMBER
159 , x_msg_data out nocopy VARCHAR2
160 , p_lock_terms_yn IN VARCHAR2 := 'N'
161 );
162 procedure refresh_articles(p_api_version NUMBER
163 , p_init_msg_list VARCHAR2
164 , p_validate_commit VARCHAR2
165 , p_validation_string VARCHAR2
166 , p_commit VARCHAR2
167 , p_mode VARCHAR2
168 , p_doc_type VARCHAR2
169 , p_doc_id NUMBER
170 , p8_a0 JTF_NUMBER_TABLE
171 , p8_a1 JTF_NUMBER_TABLE
172 , p8_a2 JTF_NUMBER_TABLE
173 , x_return_status out nocopy VARCHAR2
174 , x_msg_count out nocopy NUMBER
175 , x_msg_data out nocopy VARCHAR2
176 , p_lock_terms_yn IN VARCHAR2 := 'N'
177
178 );
179 procedure organize_layout(p_api_version NUMBER
180 , p_init_msg_list VARCHAR2
181 , p_validation_level NUMBER
182 , p_validate_commit VARCHAR2
183 , p_validation_string VARCHAR2
184 , p_commit VARCHAR2
185 , p6_a0 JTF_VARCHAR2_TABLE_100
186 , p6_a1 JTF_NUMBER_TABLE
187 , p_ref_point VARCHAR2
188 , p_doc_type VARCHAR2
189 , p_doc_id NUMBER
190 , p_to_object_type VARCHAR2
191 , p_to_object_id NUMBER
192 , x_return_status out nocopy VARCHAR2
193 , x_msg_count out nocopy NUMBER
194 , x_msg_data out nocopy VARCHAR2
195 );
196
197
198 procedure merge_review_clauses(p_api_version NUMBER
199 , p_init_msg_list VARCHAR2
200 , p_validation_level NUMBER
201 , p_validate_commit VARCHAR2
202 , p_validation_string VARCHAR2
203 , p_commit VARCHAR2
204 , p6_a0 JTF_VARCHAR2_TABLE_100
205 , p6_a1 JTF_NUMBER_TABLE
206 , p6_a2 JTF_NUMBER_TABLE
207 , p_doc_type VARCHAR2
208 , p_doc_id NUMBER
209 , x_return_status out nocopy VARCHAR2
210 , x_msg_count out nocopy NUMBER
211 , x_msg_data out nocopy VARCHAR2
212 );
213 end okc_terms_multirec_grp_w;