DBA Data[Home] [Help]

PACKAGE: APPS.AHL_PRD_DISPOSITION_PVT_W

Source


1 package ahl_prd_disposition_pvt_w AUTHID CURRENT_USER as
2   /* $Header: AHLWDISS.pls 120.3.12020000.2 2012/12/13 05:19:18 shnatu ship $ */
3   procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_disposition_pvt.disposition_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_DATE_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_NUMBER_TABLE
19     , a16 JTF_NUMBER_TABLE
20     , a17 JTF_NUMBER_TABLE
21     , a18 JTF_NUMBER_TABLE
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_VARCHAR2_TABLE_100
24     , a21 JTF_VARCHAR2_TABLE_100
25     , a22 JTF_VARCHAR2_TABLE_100
26     , a23 JTF_VARCHAR2_TABLE_100
27     , a24 JTF_VARCHAR2_TABLE_100
28     , a25 JTF_VARCHAR2_TABLE_100
29     , a26 JTF_NUMBER_TABLE
30     , a27 JTF_VARCHAR2_TABLE_100
31     , a28 JTF_VARCHAR2_TABLE_2000
32     , a29 JTF_NUMBER_TABLE
33     , a30 JTF_VARCHAR2_TABLE_100
34     , a31 JTF_VARCHAR2_TABLE_300
35     , a32 JTF_NUMBER_TABLE
36     , a33 JTF_VARCHAR2_TABLE_100
37     , a34 JTF_VARCHAR2_TABLE_200
38     , a35 JTF_VARCHAR2_TABLE_200
39     , a36 JTF_VARCHAR2_TABLE_200
40     , a37 JTF_VARCHAR2_TABLE_100
41     , a38 JTF_VARCHAR2_TABLE_100
42     , a39 JTF_VARCHAR2_TABLE_100
43     , a40 JTF_VARCHAR2_TABLE_100
44     , a41 JTF_VARCHAR2_TABLE_100
45     , a42 JTF_VARCHAR2_TABLE_100
46     , a43 JTF_NUMBER_TABLE
47     , a44 JTF_VARCHAR2_TABLE_100
48     , a45 JTF_VARCHAR2_TABLE_100
49     , a46 JTF_NUMBER_TABLE
50     , a47 JTF_NUMBER_TABLE
51     , a48 JTF_VARCHAR2_TABLE_100
52     , a49 JTF_VARCHAR2_TABLE_100
53     , a50 JTF_VARCHAR2_TABLE_100
54     , a51 JTF_VARCHAR2_TABLE_200
55     , a52 JTF_VARCHAR2_TABLE_200
56     , a53 JTF_VARCHAR2_TABLE_200
57     , a54 JTF_VARCHAR2_TABLE_200
58     , a55 JTF_VARCHAR2_TABLE_200
59     , a56 JTF_VARCHAR2_TABLE_200
60     , a57 JTF_VARCHAR2_TABLE_200
61     , a58 JTF_VARCHAR2_TABLE_200
62     , a59 JTF_VARCHAR2_TABLE_200
63     , a60 JTF_VARCHAR2_TABLE_200
64     , a61 JTF_VARCHAR2_TABLE_200
65     , a62 JTF_VARCHAR2_TABLE_200
66     , a63 JTF_VARCHAR2_TABLE_200
67     , a64 JTF_VARCHAR2_TABLE_200
68     , a65 JTF_VARCHAR2_TABLE_200
69     );
70   procedure rosetta_table_copy_out_p6(t ahl_prd_disposition_pvt.disposition_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71     , a1 out nocopy JTF_VARCHAR2_TABLE_100
72     , a2 out nocopy JTF_NUMBER_TABLE
73     , a3 out nocopy JTF_DATE_TABLE
74     , a4 out nocopy JTF_NUMBER_TABLE
75     , a5 out nocopy JTF_DATE_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     , a11 out nocopy JTF_NUMBER_TABLE
82     , a12 out nocopy JTF_NUMBER_TABLE
83     , a13 out nocopy JTF_NUMBER_TABLE
84     , a14 out nocopy JTF_NUMBER_TABLE
85     , a15 out nocopy JTF_NUMBER_TABLE
86     , a16 out nocopy JTF_NUMBER_TABLE
87     , a17 out nocopy JTF_NUMBER_TABLE
88     , a18 out nocopy JTF_NUMBER_TABLE
89     , a19 out nocopy JTF_NUMBER_TABLE
90     , a20 out nocopy JTF_VARCHAR2_TABLE_100
91     , a21 out nocopy JTF_VARCHAR2_TABLE_100
92     , a22 out nocopy JTF_VARCHAR2_TABLE_100
93     , a23 out nocopy JTF_VARCHAR2_TABLE_100
94     , a24 out nocopy JTF_VARCHAR2_TABLE_100
95     , a25 out nocopy JTF_VARCHAR2_TABLE_100
96     , a26 out nocopy JTF_NUMBER_TABLE
97     , a27 out nocopy JTF_VARCHAR2_TABLE_100
98     , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99     , a29 out nocopy JTF_NUMBER_TABLE
100     , a30 out nocopy JTF_VARCHAR2_TABLE_100
101     , a31 out nocopy JTF_VARCHAR2_TABLE_300
102     , a32 out nocopy JTF_NUMBER_TABLE
103     , a33 out nocopy JTF_VARCHAR2_TABLE_100
104     , a34 out nocopy JTF_VARCHAR2_TABLE_200
105     , a35 out nocopy JTF_VARCHAR2_TABLE_200
106     , a36 out nocopy JTF_VARCHAR2_TABLE_200
107     , a37 out nocopy JTF_VARCHAR2_TABLE_100
108     , a38 out nocopy JTF_VARCHAR2_TABLE_100
109     , a39 out nocopy JTF_VARCHAR2_TABLE_100
110     , a40 out nocopy JTF_VARCHAR2_TABLE_100
111     , a41 out nocopy JTF_VARCHAR2_TABLE_100
112     , a42 out nocopy JTF_VARCHAR2_TABLE_100
113     , a43 out nocopy JTF_NUMBER_TABLE
114     , a44 out nocopy JTF_VARCHAR2_TABLE_100
115     , a45 out nocopy JTF_VARCHAR2_TABLE_100
116     , a46 out nocopy JTF_NUMBER_TABLE
117     , a47 out nocopy JTF_NUMBER_TABLE
118     , a48 out nocopy JTF_VARCHAR2_TABLE_100
119     , a49 out nocopy JTF_VARCHAR2_TABLE_100
120     , a50 out nocopy JTF_VARCHAR2_TABLE_100
121     , a51 out nocopy JTF_VARCHAR2_TABLE_200
122     , a52 out nocopy JTF_VARCHAR2_TABLE_200
123     , a53 out nocopy JTF_VARCHAR2_TABLE_200
124     , a54 out nocopy JTF_VARCHAR2_TABLE_200
125     , a55 out nocopy JTF_VARCHAR2_TABLE_200
126     , a56 out nocopy JTF_VARCHAR2_TABLE_200
127     , a57 out nocopy JTF_VARCHAR2_TABLE_200
128     , a58 out nocopy JTF_VARCHAR2_TABLE_200
129     , a59 out nocopy JTF_VARCHAR2_TABLE_200
130     , a60 out nocopy JTF_VARCHAR2_TABLE_200
131     , a61 out nocopy JTF_VARCHAR2_TABLE_200
132     , a62 out nocopy JTF_VARCHAR2_TABLE_200
133     , a63 out nocopy JTF_VARCHAR2_TABLE_200
134     , a64 out nocopy JTF_VARCHAR2_TABLE_200
135     , a65 out nocopy JTF_VARCHAR2_TABLE_200
136     );
137 
138   procedure process_disposition(p_api_version  NUMBER
139     , p_init_msg_list  VARCHAR2
140     , p_commit  VARCHAR2
141     , p_validation_level  NUMBER
142     , p_module_type  VARCHAR2
143     , p5_a0 in out nocopy  NUMBER
144     , p5_a1 in out nocopy  VARCHAR2
145     , p5_a2 in out nocopy  NUMBER
146     , p5_a3 in out nocopy  DATE
147     , p5_a4 in out nocopy  NUMBER
148     , p5_a5 in out nocopy  DATE
149     , p5_a6 in out nocopy  NUMBER
150     , p5_a7 in out nocopy  NUMBER
151     , p5_a8 in out nocopy  NUMBER
152     , p5_a9 in out nocopy  NUMBER
153     , p5_a10 in out nocopy  NUMBER
154     , p5_a11 in out nocopy  NUMBER
155     , p5_a12 in out nocopy  NUMBER
156     , p5_a13 in out nocopy  NUMBER
157     , p5_a14 in out nocopy  NUMBER
158     , p5_a15 in out nocopy  NUMBER
159     , p5_a16 in out nocopy  NUMBER
160     , p5_a17 in out nocopy  NUMBER
161     , p5_a18 in out nocopy  NUMBER
162     , p5_a19 in out nocopy  NUMBER
163     , p5_a20 in out nocopy  VARCHAR
164     , p5_a21 in out nocopy  VARCHAR2
165     , p5_a22 in out nocopy  VARCHAR2
166     , p5_a23 in out nocopy  VARCHAR2
167     , p5_a24 in out nocopy  VARCHAR2
168     , p5_a25 in out nocopy  VARCHAR2
169     , p5_a26 in out nocopy  NUMBER
170     , p5_a27 in out nocopy  VARCHAR2
171     , p5_a28 in out nocopy  VARCHAR2
172     , p5_a29 in out nocopy  NUMBER
173     , p5_a30 in out nocopy  VARCHAR
174     , p5_a31 in out nocopy  VARCHAR
175     , p5_a32 in out nocopy  NUMBER
176     , p5_a33 in out nocopy  VARCHAR2
177     , p5_a34 in out nocopy  VARCHAR
178     , p5_a35 in out nocopy  VARCHAR
179     , p5_a36 in out nocopy  VARCHAR
180     , p5_a37 in out nocopy  VARCHAR
181     , p5_a38 in out nocopy  VARCHAR
182     , p5_a39 in out nocopy  VARCHAR
183     , p5_a40 in out nocopy  VARCHAR
184     , p5_a41 in out nocopy  VARCHAR2
185     , p5_a42 in out nocopy  VARCHAR2
186     , p5_a43 in out nocopy  NUMBER
187     , p5_a44 in out nocopy  VARCHAR2
188     , p5_a45 in out nocopy  VARCHAR2
189     , p5_a46 in out nocopy  NUMBER
190     , p5_a47 in out nocopy  NUMBER
191     , p5_a48 in out nocopy  VARCHAR2
192     , p5_a49 in out nocopy  VARCHAR2
193     , p5_a50 in out nocopy  VARCHAR2
194     , p5_a51 in out nocopy  VARCHAR2
195     , p5_a52 in out nocopy  VARCHAR2
196     , p5_a53 in out nocopy  VARCHAR2
197     , p5_a54 in out nocopy  VARCHAR2
198     , p5_a55 in out nocopy  VARCHAR2
199     , p5_a56 in out nocopy  VARCHAR2
200     , p5_a57 in out nocopy  VARCHAR2
201     , p5_a58 in out nocopy  VARCHAR2
202     , p5_a59 in out nocopy  VARCHAR2
203     , p5_a60 in out nocopy  VARCHAR2
204     , p5_a61 in out nocopy  VARCHAR2
205     , p5_a62 in out nocopy  VARCHAR2
206     , p5_a63 in out nocopy  VARCHAR2
207     , p5_a64 in out nocopy  VARCHAR2
208     , p5_a65 in out nocopy  VARCHAR2
209     , p6_a0 JTF_NUMBER_TABLE
210     , p6_a1 JTF_VARCHAR2_TABLE_100
211     , p6_a2 JTF_NUMBER_TABLE
212     , p6_a3 JTF_NUMBER_TABLE
213     , p6_a4 JTF_NUMBER_TABLE
214     , p6_a5 JTF_NUMBER_TABLE
215     , p6_a6 JTF_VARCHAR2_TABLE_100
216     , p6_a7 JTF_NUMBER_TABLE
217     , p6_a8 JTF_VARCHAR2_TABLE_100
218     , p6_a9 JTF_NUMBER_TABLE
219     , x_return_status out nocopy  VARCHAR2
220     , x_msg_count out nocopy  NUMBER
221     , x_msg_data out nocopy  VARCHAR2
222   );
223 end ahl_prd_disposition_pvt_w;