[Home] [Help]
PACKAGE: APPS.OKC_TERMS_MULTIREC_GRP_W
Source
1 package okc_terms_multirec_grp_w as
2 /* $Header: OKCWMULS.pls 120.2 2005/09/14 02:34:33 vnanjang noship $ */
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 );
128 procedure update_structure(p_api_version NUMBER
129 , p_init_msg_list VARCHAR2
130 , p_validation_level NUMBER
131 , p_validate_commit VARCHAR2
132 , p_validation_string VARCHAR2
133 , p_commit VARCHAR2
134 , p6_a0 JTF_VARCHAR2_TABLE_100
135 , p6_a1 JTF_NUMBER_TABLE
136 , p6_a2 JTF_NUMBER_TABLE
137 , p6_a3 JTF_NUMBER_TABLE
138 , p6_a4 JTF_VARCHAR2_TABLE_100
139 , p6_a5 JTF_VARCHAR2_TABLE_100
140 , p6_a6 JTF_NUMBER_TABLE
141 , x_return_status out nocopy VARCHAR2
142 , x_msg_count out nocopy NUMBER
143 , x_msg_data out nocopy VARCHAR2
144 );
145 procedure sync_doc_with_expert(p_api_version NUMBER
146 , p_init_msg_list VARCHAR2
147 , p_validate_commit VARCHAR2
148 , p_validation_string VARCHAR2
149 , p_commit VARCHAR2
150 , p_doc_type VARCHAR2
151 , p_doc_id NUMBER
152 , p_article_id_tbl JTF_NUMBER_TABLE
153 , p_mode VARCHAR2
154 , x_articles_dropped out nocopy NUMBER
155 , x_return_status out nocopy VARCHAR2
156 , x_msg_count out nocopy NUMBER
157 , x_msg_data out nocopy VARCHAR2
158 );
159 procedure refresh_articles(p_api_version NUMBER
160 , p_init_msg_list VARCHAR2
161 , p_validate_commit VARCHAR2
162 , p_validation_string VARCHAR2
163 , p_commit VARCHAR2
164 , p_mode VARCHAR2
165 , p_doc_type VARCHAR2
166 , p_doc_id NUMBER
167 , p8_a0 JTF_NUMBER_TABLE
168 , p8_a1 JTF_NUMBER_TABLE
169 , p8_a2 JTF_NUMBER_TABLE
170 , x_return_status out nocopy VARCHAR2
171 , x_msg_count out nocopy NUMBER
172 , x_msg_data out nocopy VARCHAR2
173 );
174 procedure organize_layout(p_api_version NUMBER
175 , p_init_msg_list VARCHAR2
176 , p_validation_level NUMBER
177 , p_validate_commit VARCHAR2
178 , p_validation_string VARCHAR2
179 , p_commit VARCHAR2
180 , p6_a0 JTF_VARCHAR2_TABLE_100
181 , p6_a1 JTF_NUMBER_TABLE
182 , p_ref_point VARCHAR2
183 , p_doc_type VARCHAR2
184 , p_doc_id NUMBER
185 , p_to_object_type VARCHAR2
186 , p_to_object_id NUMBER
187 , x_return_status out nocopy VARCHAR2
188 , x_msg_count out nocopy NUMBER
189 , x_msg_data out nocopy VARCHAR2
190 );
191
192
193 procedure merge_review_clauses(p_api_version NUMBER
194 , p_init_msg_list VARCHAR2
195 , p_validation_level NUMBER
196 , p_validate_commit VARCHAR2
197 , p_validation_string VARCHAR2
198 , p_commit VARCHAR2
199 , p6_a0 JTF_VARCHAR2_TABLE_100
200 , p6_a1 JTF_NUMBER_TABLE
201 , p6_a2 JTF_NUMBER_TABLE
202 , p_doc_type VARCHAR2
203 , p_doc_id NUMBER
204 , x_return_status out nocopy VARCHAR2
205 , x_msg_count out nocopy NUMBER
206 , x_msg_data out nocopy VARCHAR2
207 );
208 end okc_terms_multirec_grp_w;