[Home] [Help]
PACKAGE: APPS.AHL_PRD_DISP_UTIL_PVT_W
Source
1 package ahl_prd_disp_util_pvt_w as
2 /* $Header: AHLWDIUS.pls 120.1 2008/01/29 14:17:24 sathapli ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_VARCHAR2_TABLE_100
5 );
6 procedure rosetta_table_copy_out_p1(t ahl_prd_disp_util_pvt.disp_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7 , a1 out nocopy JTF_VARCHAR2_TABLE_100
8 );
9
10 procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_disp_util_pvt.disp_list_tbl_type, a0 JTF_NUMBER_TABLE
11 , a1 JTF_NUMBER_TABLE
12 , a2 JTF_NUMBER_TABLE
13 , a3 JTF_VARCHAR2_TABLE_100
14 , a4 JTF_NUMBER_TABLE
15 , a5 JTF_VARCHAR2_TABLE_100
16 , a6 JTF_VARCHAR2_TABLE_100
17 , a7 JTF_VARCHAR2_TABLE_100
18 , a8 JTF_VARCHAR2_TABLE_100
19 , a9 JTF_VARCHAR2_TABLE_100
20 , a10 JTF_VARCHAR2_TABLE_100
21 , a11 JTF_VARCHAR2_TABLE_100
22 , a12 JTF_NUMBER_TABLE
23 , a13 JTF_VARCHAR2_TABLE_100
24 , a14 JTF_NUMBER_TABLE
25 , a15 JTF_VARCHAR2_TABLE_200
26 , a16 JTF_NUMBER_TABLE
27 , a17 JTF_VARCHAR2_TABLE_100
28 , a18 JTF_VARCHAR2_TABLE_100
29 , a19 JTF_VARCHAR2_TABLE_100
30 , a20 JTF_NUMBER_TABLE
31 , a21 JTF_VARCHAR2_TABLE_100
32 , a22 JTF_NUMBER_TABLE
33 , a23 JTF_VARCHAR2_TABLE_100
34 , a24 JTF_NUMBER_TABLE
35 , a25 JTF_VARCHAR2_TABLE_100
36 , a26 JTF_VARCHAR2_TABLE_100
37 , a27 JTF_VARCHAR2_TABLE_100
38 , a28 JTF_NUMBER_TABLE
39 , a29 JTF_VARCHAR2_TABLE_100
40 );
41 procedure rosetta_table_copy_out_p4(t ahl_prd_disp_util_pvt.disp_list_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42 , a1 out nocopy JTF_NUMBER_TABLE
43 , a2 out nocopy JTF_NUMBER_TABLE
44 , a3 out nocopy JTF_VARCHAR2_TABLE_100
45 , a4 out nocopy JTF_NUMBER_TABLE
46 , a5 out nocopy JTF_VARCHAR2_TABLE_100
47 , a6 out nocopy JTF_VARCHAR2_TABLE_100
48 , a7 out nocopy JTF_VARCHAR2_TABLE_100
49 , a8 out nocopy JTF_VARCHAR2_TABLE_100
50 , a9 out nocopy JTF_VARCHAR2_TABLE_100
51 , a10 out nocopy JTF_VARCHAR2_TABLE_100
52 , a11 out nocopy JTF_VARCHAR2_TABLE_100
53 , a12 out nocopy JTF_NUMBER_TABLE
54 , a13 out nocopy JTF_VARCHAR2_TABLE_100
55 , a14 out nocopy JTF_NUMBER_TABLE
56 , a15 out nocopy JTF_VARCHAR2_TABLE_200
57 , a16 out nocopy JTF_NUMBER_TABLE
58 , a17 out nocopy JTF_VARCHAR2_TABLE_100
59 , a18 out nocopy JTF_VARCHAR2_TABLE_100
60 , a19 out nocopy JTF_VARCHAR2_TABLE_100
61 , a20 out nocopy JTF_NUMBER_TABLE
62 , a21 out nocopy JTF_VARCHAR2_TABLE_100
63 , a22 out nocopy JTF_NUMBER_TABLE
64 , a23 out nocopy JTF_VARCHAR2_TABLE_100
65 , a24 out nocopy JTF_NUMBER_TABLE
66 , a25 out nocopy JTF_VARCHAR2_TABLE_100
67 , a26 out nocopy JTF_VARCHAR2_TABLE_100
68 , a27 out nocopy JTF_VARCHAR2_TABLE_100
69 , a28 out nocopy JTF_NUMBER_TABLE
70 , a29 out nocopy JTF_VARCHAR2_TABLE_100
71 );
72
73 procedure get_disposition_list(p_api_version NUMBER
74 , p_init_msg_list VARCHAR2
75 , p_validation_level NUMBER
76 , x_return_status out nocopy VARCHAR2
77 , x_msg_count out nocopy NUMBER
78 , x_msg_data out nocopy VARCHAR2
79 , p_workorder_id NUMBER
80 , p_start_row NUMBER
81 , p_rows_per_page NUMBER
82 , p9_a0 NUMBER
83 , p9_a1 VARCHAR2
84 , p9_a2 NUMBER
85 , p9_a3 VARCHAR2
86 , p9_a4 NUMBER
87 , p9_a5 VARCHAR2
88 , p9_a6 NUMBER
89 , p9_a7 VARCHAR2
90 , p9_a8 VARCHAR2
91 , p9_a9 VARCHAR2
92 , p9_a10 VARCHAR2
93 , p9_a11 VARCHAR2
94 , p9_a12 VARCHAR2
95 , p9_a13 VARCHAR2
96 , p9_a14 VARCHAR2
97 , p9_a15 VARCHAR2
98 , x_results_count out nocopy NUMBER
99 , p11_a0 out nocopy JTF_NUMBER_TABLE
100 , p11_a1 out nocopy JTF_NUMBER_TABLE
101 , p11_a2 out nocopy JTF_NUMBER_TABLE
102 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
103 , p11_a4 out nocopy JTF_NUMBER_TABLE
104 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
105 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
106 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
107 , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
108 , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
109 , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
110 , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
111 , p11_a12 out nocopy JTF_NUMBER_TABLE
112 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
113 , p11_a14 out nocopy JTF_NUMBER_TABLE
114 , p11_a15 out nocopy JTF_VARCHAR2_TABLE_200
115 , p11_a16 out nocopy JTF_NUMBER_TABLE
116 , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
117 , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
118 , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
119 , p11_a20 out nocopy JTF_NUMBER_TABLE
120 , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100
121 , p11_a22 out nocopy JTF_NUMBER_TABLE
122 , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
123 , p11_a24 out nocopy JTF_NUMBER_TABLE
124 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
125 , p11_a26 out nocopy JTF_VARCHAR2_TABLE_100
126 , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100
127 , p11_a28 out nocopy JTF_NUMBER_TABLE
128 , p11_a29 out nocopy JTF_VARCHAR2_TABLE_100
129 );
130 procedure get_part_change_disposition(p_api_version NUMBER
131 , p_init_msg_list VARCHAR2
132 , p_commit VARCHAR2
133 , p_validation_level NUMBER
134 , x_return_status out nocopy VARCHAR2
135 , x_msg_count out nocopy NUMBER
136 , x_msg_data out nocopy VARCHAR2
137 , p_workorder_id NUMBER
138 , p_parent_instance_id NUMBER
139 , p_relationship_id NUMBER
140 , p_instance_id NUMBER
141 , p11_a0 out nocopy NUMBER
142 , p11_a1 out nocopy VARCHAR2
143 , p11_a2 out nocopy NUMBER
144 , p11_a3 out nocopy DATE
145 , p11_a4 out nocopy NUMBER
146 , p11_a5 out nocopy DATE
147 , p11_a6 out nocopy NUMBER
148 , p11_a7 out nocopy NUMBER
149 , p11_a8 out nocopy NUMBER
150 , p11_a9 out nocopy NUMBER
151 , p11_a10 out nocopy NUMBER
152 , p11_a11 out nocopy NUMBER
153 , p11_a12 out nocopy NUMBER
154 , p11_a13 out nocopy NUMBER
155 , p11_a14 out nocopy NUMBER
156 , p11_a15 out nocopy NUMBER
157 , p11_a16 out nocopy NUMBER
158 , p11_a17 out nocopy NUMBER
159 , p11_a18 out nocopy NUMBER
160 , p11_a19 out nocopy NUMBER
161 , p11_a20 out nocopy VARCHAR
162 , p11_a21 out nocopy VARCHAR2
163 , p11_a22 out nocopy VARCHAR2
164 , p11_a23 out nocopy VARCHAR2
165 , p11_a24 out nocopy VARCHAR2
166 , p11_a25 out nocopy VARCHAR2
167 , p11_a26 out nocopy NUMBER
168 , p11_a27 out nocopy VARCHAR2
169 , p11_a28 out nocopy VARCHAR2
170 , p11_a29 out nocopy NUMBER
171 , p11_a30 out nocopy VARCHAR
172 , p11_a31 out nocopy VARCHAR
173 , p11_a32 out nocopy NUMBER
174 , p11_a33 out nocopy VARCHAR2
175 , p11_a34 out nocopy VARCHAR
176 , p11_a35 out nocopy VARCHAR
177 , p11_a36 out nocopy VARCHAR
178 , p11_a37 out nocopy VARCHAR
179 , p11_a38 out nocopy VARCHAR
180 , p11_a39 out nocopy VARCHAR
181 , p11_a40 out nocopy VARCHAR
182 , p11_a41 out nocopy VARCHAR2
183 , p11_a42 out nocopy VARCHAR2
184 , p11_a43 out nocopy NUMBER
185 , p11_a44 out nocopy NUMBER
186 , p11_a45 out nocopy VARCHAR2
187 , p11_a46 out nocopy VARCHAR2
188 , p11_a47 out nocopy VARCHAR2
189 , p11_a48 out nocopy VARCHAR2
190 , p11_a49 out nocopy VARCHAR2
191 , p11_a50 out nocopy VARCHAR2
192 , p11_a51 out nocopy VARCHAR2
193 , p11_a52 out nocopy VARCHAR2
194 , p11_a53 out nocopy VARCHAR2
195 , p11_a54 out nocopy VARCHAR2
196 , p11_a55 out nocopy VARCHAR2
197 , p11_a56 out nocopy VARCHAR2
198 , p11_a57 out nocopy VARCHAR2
199 , p11_a58 out nocopy VARCHAR2
200 , p11_a59 out nocopy VARCHAR2
201 , p11_a60 out nocopy VARCHAR2
202 , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
203 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
204 , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
205 , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
206 );
207 procedure get_available_disp_types(p_api_version NUMBER
208 , p_init_msg_list VARCHAR2
209 , p_commit VARCHAR2
210 , p_validation_level NUMBER
211 , x_return_status out nocopy VARCHAR2
212 , x_msg_count out nocopy NUMBER
213 , x_msg_data out nocopy VARCHAR2
214 , p_disposition_id NUMBER
215 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
216 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
217 , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
218 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
219 );
220 end ahl_prd_disp_util_pvt_w;