[Home] [Help]
PACKAGE: APPS.CSI_CZ_INT_W
Source
1 package csi_cz_int_w AUTHID CURRENT_USER as
2 /* $Header: csigczws.pls 120.9 2008/01/15 03:32:53 devijay ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy csi_cz_int.config_query_table, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 );
6 procedure rosetta_table_copy_out_p1(t csi_cz_int.config_query_table, a0 out nocopy JTF_NUMBER_TABLE
7 , a1 out nocopy JTF_NUMBER_TABLE
8 );
9
10 procedure rosetta_table_copy_in_p3(t out nocopy csi_cz_int.config_pair_table, a0 JTF_NUMBER_TABLE
11 , a1 JTF_NUMBER_TABLE
12 , a2 JTF_NUMBER_TABLE
13 , a3 JTF_NUMBER_TABLE
14 , a4 JTF_NUMBER_TABLE
15 , a5 JTF_NUMBER_TABLE
16 , a6 JTF_NUMBER_TABLE
17 , a7 JTF_NUMBER_TABLE
18 , a8 JTF_NUMBER_TABLE
19 , a9 JTF_NUMBER_TABLE
20 , a10 JTF_VARCHAR2_TABLE_100
21 , a11 JTF_VARCHAR2_TABLE_100
22 , a12 JTF_VARCHAR2_TABLE_100
23 , a13 JTF_VARCHAR2_TABLE_100
24 , a14 JTF_NUMBER_TABLE
25 , a15 JTF_NUMBER_TABLE
26 );
27 procedure rosetta_table_copy_out_p3(t csi_cz_int.config_pair_table, a0 out nocopy JTF_NUMBER_TABLE
28 , a1 out nocopy JTF_NUMBER_TABLE
29 , a2 out nocopy JTF_NUMBER_TABLE
30 , a3 out nocopy JTF_NUMBER_TABLE
31 , a4 out nocopy JTF_NUMBER_TABLE
32 , a5 out nocopy JTF_NUMBER_TABLE
33 , a6 out nocopy JTF_NUMBER_TABLE
34 , a7 out nocopy JTF_NUMBER_TABLE
35 , a8 out nocopy JTF_NUMBER_TABLE
36 , a9 out nocopy JTF_NUMBER_TABLE
37 , a10 out nocopy JTF_VARCHAR2_TABLE_100
38 , a11 out nocopy JTF_VARCHAR2_TABLE_100
39 , a12 out nocopy JTF_VARCHAR2_TABLE_100
40 , a13 out nocopy JTF_VARCHAR2_TABLE_100
41 , a14 out nocopy JTF_NUMBER_TABLE
42 , a15 out nocopy JTF_NUMBER_TABLE
43 );
44
45 procedure rosetta_table_copy_in_p5(t out nocopy csi_cz_int.config_model_tbl_type, a0 JTF_NUMBER_TABLE
46 , a1 JTF_NUMBER_TABLE
47 , a2 JTF_NUMBER_TABLE
48 , a3 JTF_NUMBER_TABLE
49 , a4 JTF_NUMBER_TABLE
50 );
51 procedure rosetta_table_copy_out_p5(t csi_cz_int.config_model_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52 , a1 out nocopy JTF_NUMBER_TABLE
53 , a2 out nocopy JTF_NUMBER_TABLE
54 , a3 out nocopy JTF_NUMBER_TABLE
55 , a4 out nocopy JTF_NUMBER_TABLE
56 );
57
58 procedure rosetta_table_copy_in_p7(t out nocopy csi_cz_int.config_tbl, a0 JTF_NUMBER_TABLE
59 , a1 JTF_VARCHAR2_TABLE_100
60 , a2 JTF_VARCHAR2_TABLE_100
61 , a3 JTF_VARCHAR2_TABLE_100
62 , a4 JTF_VARCHAR2_TABLE_100
63 , a5 JTF_NUMBER_TABLE
64 , a6 JTF_NUMBER_TABLE
65 , a7 JTF_NUMBER_TABLE
66 , a8 JTF_NUMBER_TABLE
67 , a9 JTF_NUMBER_TABLE
68 , a10 JTF_NUMBER_TABLE
69 );
70 procedure rosetta_table_copy_out_p7(t csi_cz_int.config_tbl, a0 out nocopy JTF_NUMBER_TABLE
71 , a1 out nocopy JTF_VARCHAR2_TABLE_100
72 , a2 out nocopy JTF_VARCHAR2_TABLE_100
73 , a3 out nocopy JTF_VARCHAR2_TABLE_100
74 , a4 out nocopy JTF_VARCHAR2_TABLE_100
75 , a5 out nocopy JTF_NUMBER_TABLE
76 , a6 out nocopy JTF_NUMBER_TABLE
77 , a7 out nocopy JTF_NUMBER_TABLE
78 , a8 out nocopy JTF_NUMBER_TABLE
79 , a9 out nocopy JTF_NUMBER_TABLE
80 , a10 out nocopy JTF_NUMBER_TABLE
81 );
82
83 procedure get_configuration_revision(p_config_header_id NUMBER
84 , p_target_commitment_date date
85 , px_instance_level in out nocopy VARCHAR2
86 , p3_a0 out nocopy NUMBER
87 , p3_a1 out nocopy VARCHAR2
88 , p3_a2 out nocopy VARCHAR2
89 , p3_a3 out nocopy VARCHAR2
90 , p3_a4 out nocopy VARCHAR2
91 , p3_a5 out nocopy NUMBER
92 , p3_a6 out nocopy NUMBER
93 , p3_a7 out nocopy NUMBER
94 , p3_a8 out nocopy NUMBER
95 , p3_a9 out nocopy NUMBER
96 , p3_a10 out nocopy NUMBER
97 , x_return_status out nocopy VARCHAR2
98 , x_return_message out nocopy VARCHAR2
99 );
100 procedure get_connected_configurations(p0_a0 JTF_NUMBER_TABLE
101 , p0_a1 JTF_NUMBER_TABLE
102 , p_instance_level VARCHAR2
103 , p2_a0 out nocopy JTF_NUMBER_TABLE
104 , p2_a1 out nocopy JTF_NUMBER_TABLE
105 , p2_a2 out nocopy JTF_NUMBER_TABLE
106 , p2_a3 out nocopy JTF_NUMBER_TABLE
107 , p2_a4 out nocopy JTF_NUMBER_TABLE
108 , p2_a5 out nocopy JTF_NUMBER_TABLE
109 , p2_a6 out nocopy JTF_NUMBER_TABLE
110 , p2_a7 out nocopy JTF_NUMBER_TABLE
111 , p2_a8 out nocopy JTF_NUMBER_TABLE
112 , p2_a9 out nocopy JTF_NUMBER_TABLE
113 , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
114 , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100
115 , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100
116 , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
117 , p2_a14 out nocopy JTF_NUMBER_TABLE
118 , p2_a15 out nocopy JTF_NUMBER_TABLE
119 , x_return_status out nocopy VARCHAR2
120 , x_return_message out nocopy VARCHAR2
121 );
122 procedure generate_config_trees(p_api_version NUMBER
123 , p1_a0 JTF_NUMBER_TABLE
124 , p1_a1 JTF_NUMBER_TABLE
125 , p_tree_copy_mode VARCHAR2
126 , p3_a0 out nocopy JTF_NUMBER_TABLE
127 , p3_a1 out nocopy JTF_NUMBER_TABLE
128 , p3_a2 out nocopy JTF_NUMBER_TABLE
129 , p3_a3 out nocopy JTF_NUMBER_TABLE
130 , p3_a4 out nocopy JTF_NUMBER_TABLE
131 , x_return_status out nocopy VARCHAR2
132 , x_msg_count out nocopy NUMBER
133 , x_msg_data out nocopy VARCHAR2
134 );
135 procedure check_item_instance_lock(p_init_msg_list VARCHAR2
136 , x_return_status out nocopy VARCHAR2
137 , x_msg_count out nocopy NUMBER
138 , x_msg_data out nocopy VARCHAR2
139 , ddrosetta_retval_bool OUT NOCOPY NUMBER
140 , p1_a0 NUMBER := 0-1962.0724
141 , p1_a1 VARCHAR2 := fnd_api.g_miss_char
142 , p1_a2 VARCHAR2 := fnd_api.g_miss_char
143 , p1_a3 VARCHAR2 := fnd_api.g_miss_char
144 , p1_a4 VARCHAR2 := fnd_api.g_miss_char
145 , p1_a5 NUMBER := 0-1962.0724
146 , p1_a6 NUMBER := 0-1962.0724
147 , p1_a7 NUMBER := 0-1962.0724
148 , p1_a8 NUMBER := 0-1962.0724
149 , p1_a9 NUMBER := 0-1962.0724
150 , p1_a10 NUMBER := 0-1962.0724
151 );
152 procedure lock_item_instances(p_api_version NUMBER
153 , p_init_msg_list VARCHAR2
154 , p_commit VARCHAR2
155 , p_validation_level NUMBER
156 , p4_a0 in out nocopy JTF_NUMBER_TABLE
157 , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
158 , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_100
159 , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
160 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
161 , p4_a5 in out nocopy JTF_NUMBER_TABLE
162 , p4_a6 in out nocopy JTF_NUMBER_TABLE
163 , p4_a7 in out nocopy JTF_NUMBER_TABLE
164 , p4_a8 in out nocopy JTF_NUMBER_TABLE
165 , p4_a9 in out nocopy JTF_NUMBER_TABLE
166 , p4_a10 in out nocopy JTF_NUMBER_TABLE
167 , x_return_status out nocopy VARCHAR2
168 , x_msg_count out nocopy NUMBER
169 , x_msg_data out nocopy VARCHAR2
170 );
171 procedure unlock_current_node(p_api_version NUMBER
172 , p_init_msg_list VARCHAR2
173 , p_commit VARCHAR2
174 , p_validation_level NUMBER
175 , p5_a0 out nocopy JTF_NUMBER_TABLE
176 , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
177 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
178 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
179 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
180 , p5_a5 out nocopy JTF_NUMBER_TABLE
181 , p5_a6 out nocopy JTF_NUMBER_TABLE
182 , p5_a7 out nocopy JTF_NUMBER_TABLE
183 , p5_a8 out nocopy JTF_NUMBER_TABLE
184 , p5_a9 out nocopy JTF_NUMBER_TABLE
185 , p5_a10 out nocopy JTF_NUMBER_TABLE
186 , x_return_status out nocopy VARCHAR2
187 , x_msg_count out nocopy NUMBER
188 , x_msg_data out nocopy VARCHAR2
189 , p4_a0 NUMBER := 0-1962.0724
190 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
191 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
192 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
193 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
194 , p4_a5 NUMBER := 0-1962.0724
195 , p4_a6 NUMBER := 0-1962.0724
196 , p4_a7 NUMBER := 0-1962.0724
197 , p4_a8 NUMBER := 0-1962.0724
198 , p4_a9 NUMBER := 0-1962.0724
199 , p4_a10 NUMBER := 0-1962.0724
200 );
201 procedure unlock_item_instances(p_api_version NUMBER
202 , p_init_msg_list VARCHAR2
203 , p_commit VARCHAR2
204 , p_validation_level NUMBER
205 , p4_a0 JTF_NUMBER_TABLE
206 , p4_a1 JTF_VARCHAR2_TABLE_100
207 , p4_a2 JTF_VARCHAR2_TABLE_100
208 , p4_a3 JTF_VARCHAR2_TABLE_100
209 , p4_a4 JTF_VARCHAR2_TABLE_100
210 , p4_a5 JTF_NUMBER_TABLE
211 , p4_a6 JTF_NUMBER_TABLE
212 , p4_a7 JTF_NUMBER_TABLE
213 , p4_a8 JTF_NUMBER_TABLE
214 , p4_a9 JTF_NUMBER_TABLE
215 , p4_a10 JTF_NUMBER_TABLE
216 , x_return_status out nocopy VARCHAR2
217 , x_msg_count out nocopy NUMBER
218 , x_msg_data out nocopy VARCHAR2
219 );
220 end csi_cz_int_w;