DBA Data[Home] [Help]

PACKAGE: APPS.AHL_PRD_DISPOSITION_PVT_W

Source


1 package ahl_prd_disposition_pvt_w as
2   /* $Header: AHLWDISS.pls 120.1.12010000.2 2008/12/09 01:45:39 jaramana 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_VARCHAR2_TABLE_100
51     , a48 JTF_VARCHAR2_TABLE_200
52     , a49 JTF_VARCHAR2_TABLE_200
53     , a50 JTF_VARCHAR2_TABLE_200
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     );
67   procedure rosetta_table_copy_out_p6(t ahl_prd_disposition_pvt.disposition_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68     , a1 out nocopy JTF_VARCHAR2_TABLE_100
69     , a2 out nocopy JTF_NUMBER_TABLE
70     , a3 out nocopy JTF_DATE_TABLE
71     , a4 out nocopy JTF_NUMBER_TABLE
72     , a5 out nocopy JTF_DATE_TABLE
73     , a6 out nocopy JTF_NUMBER_TABLE
74     , a7 out nocopy JTF_NUMBER_TABLE
75     , a8 out nocopy JTF_NUMBER_TABLE
76     , a9 out nocopy JTF_NUMBER_TABLE
77     , a10 out nocopy JTF_NUMBER_TABLE
78     , a11 out nocopy JTF_NUMBER_TABLE
79     , a12 out nocopy JTF_NUMBER_TABLE
80     , a13 out nocopy JTF_NUMBER_TABLE
81     , a14 out nocopy JTF_NUMBER_TABLE
82     , a15 out nocopy JTF_NUMBER_TABLE
83     , a16 out nocopy JTF_NUMBER_TABLE
84     , a17 out nocopy JTF_NUMBER_TABLE
85     , a18 out nocopy JTF_NUMBER_TABLE
86     , a19 out nocopy JTF_NUMBER_TABLE
87     , a20 out nocopy JTF_VARCHAR2_TABLE_100
88     , a21 out nocopy JTF_VARCHAR2_TABLE_100
89     , a22 out nocopy JTF_VARCHAR2_TABLE_100
90     , a23 out nocopy JTF_VARCHAR2_TABLE_100
91     , a24 out nocopy JTF_VARCHAR2_TABLE_100
92     , a25 out nocopy JTF_VARCHAR2_TABLE_100
93     , a26 out nocopy JTF_NUMBER_TABLE
94     , a27 out nocopy JTF_VARCHAR2_TABLE_100
95     , a28 out nocopy JTF_VARCHAR2_TABLE_2000
96     , a29 out nocopy JTF_NUMBER_TABLE
97     , a30 out nocopy JTF_VARCHAR2_TABLE_100
98     , a31 out nocopy JTF_VARCHAR2_TABLE_300
99     , a32 out nocopy JTF_NUMBER_TABLE
100     , a33 out nocopy JTF_VARCHAR2_TABLE_100
101     , a34 out nocopy JTF_VARCHAR2_TABLE_200
102     , a35 out nocopy JTF_VARCHAR2_TABLE_200
103     , a36 out nocopy JTF_VARCHAR2_TABLE_200
104     , a37 out nocopy JTF_VARCHAR2_TABLE_100
105     , a38 out nocopy JTF_VARCHAR2_TABLE_100
106     , a39 out nocopy JTF_VARCHAR2_TABLE_100
107     , a40 out nocopy JTF_VARCHAR2_TABLE_100
108     , a41 out nocopy JTF_VARCHAR2_TABLE_100
109     , a42 out nocopy JTF_VARCHAR2_TABLE_100
110     , a43 out nocopy JTF_NUMBER_TABLE
111     , a44 out nocopy JTF_VARCHAR2_TABLE_100
112     , a45 out nocopy JTF_VARCHAR2_TABLE_100
113     , a46 out nocopy JTF_NUMBER_TABLE
114     , a47 out nocopy JTF_VARCHAR2_TABLE_100
115     , a48 out nocopy JTF_VARCHAR2_TABLE_200
116     , a49 out nocopy JTF_VARCHAR2_TABLE_200
117     , a50 out nocopy JTF_VARCHAR2_TABLE_200
118     , a51 out nocopy JTF_VARCHAR2_TABLE_200
119     , a52 out nocopy JTF_VARCHAR2_TABLE_200
120     , a53 out nocopy JTF_VARCHAR2_TABLE_200
121     , a54 out nocopy JTF_VARCHAR2_TABLE_200
122     , a55 out nocopy JTF_VARCHAR2_TABLE_200
123     , a56 out nocopy JTF_VARCHAR2_TABLE_200
124     , a57 out nocopy JTF_VARCHAR2_TABLE_200
125     , a58 out nocopy JTF_VARCHAR2_TABLE_200
126     , a59 out nocopy JTF_VARCHAR2_TABLE_200
127     , a60 out nocopy JTF_VARCHAR2_TABLE_200
128     , a61 out nocopy JTF_VARCHAR2_TABLE_200
129     , a62 out nocopy JTF_VARCHAR2_TABLE_200
130     );
131 
132   procedure process_disposition(p_api_version  NUMBER
133     , p_init_msg_list  VARCHAR2
134     , p_commit  VARCHAR2
135     , p_validation_level  NUMBER
136     , p_module_type  VARCHAR2
137     , p5_a0 in out nocopy  NUMBER
138     , p5_a1 in out nocopy  VARCHAR2
139     , p5_a2 in out nocopy  NUMBER
140     , p5_a3 in out nocopy  DATE
141     , p5_a4 in out nocopy  NUMBER
142     , p5_a5 in out nocopy  DATE
143     , p5_a6 in out nocopy  NUMBER
144     , p5_a7 in out nocopy  NUMBER
145     , p5_a8 in out nocopy  NUMBER
146     , p5_a9 in out nocopy  NUMBER
147     , p5_a10 in out nocopy  NUMBER
148     , p5_a11 in out nocopy  NUMBER
149     , p5_a12 in out nocopy  NUMBER
150     , p5_a13 in out nocopy  NUMBER
151     , p5_a14 in out nocopy  NUMBER
152     , p5_a15 in out nocopy  NUMBER
153     , p5_a16 in out nocopy  NUMBER
154     , p5_a17 in out nocopy  NUMBER
155     , p5_a18 in out nocopy  NUMBER
156     , p5_a19 in out nocopy  NUMBER
157     , p5_a20 in out nocopy  VARCHAR
158     , p5_a21 in out nocopy  VARCHAR2
159     , p5_a22 in out nocopy  VARCHAR2
160     , p5_a23 in out nocopy  VARCHAR2
161     , p5_a24 in out nocopy  VARCHAR2
162     , p5_a25 in out nocopy  VARCHAR2
163     , p5_a26 in out nocopy  NUMBER
164     , p5_a27 in out nocopy  VARCHAR2
165     , p5_a28 in out nocopy  VARCHAR2
166     , p5_a29 in out nocopy  NUMBER
167     , p5_a30 in out nocopy  VARCHAR
168     , p5_a31 in out nocopy  VARCHAR
169     , p5_a32 in out nocopy  NUMBER
170     , p5_a33 in out nocopy  VARCHAR2
171     , p5_a34 in out nocopy  VARCHAR
172     , p5_a35 in out nocopy  VARCHAR
173     , p5_a36 in out nocopy  VARCHAR
174     , p5_a37 in out nocopy  VARCHAR
175     , p5_a38 in out nocopy  VARCHAR
176     , p5_a39 in out nocopy  VARCHAR
177     , p5_a40 in out nocopy  VARCHAR
178     , p5_a41 in out nocopy  VARCHAR2
179     , p5_a42 in out nocopy  VARCHAR2
180     , p5_a43 in out nocopy  NUMBER
181     , p5_a44 in out nocopy  VARCHAR2
182     , p5_a45 in out nocopy  VARCHAR2
183     , p5_a46 in out nocopy  NUMBER
184     , p5_a47 in out nocopy  VARCHAR2
185     , p5_a48 in out nocopy  VARCHAR2
186     , p5_a49 in out nocopy  VARCHAR2
187     , p5_a50 in out nocopy  VARCHAR2
188     , p5_a51 in out nocopy  VARCHAR2
189     , p5_a52 in out nocopy  VARCHAR2
190     , p5_a53 in out nocopy  VARCHAR2
191     , p5_a54 in out nocopy  VARCHAR2
192     , p5_a55 in out nocopy  VARCHAR2
193     , p5_a56 in out nocopy  VARCHAR2
194     , p5_a57 in out nocopy  VARCHAR2
195     , p5_a58 in out nocopy  VARCHAR2
196     , p5_a59 in out nocopy  VARCHAR2
197     , p5_a60 in out nocopy  VARCHAR2
198     , p5_a61 in out nocopy  VARCHAR2
199     , p5_a62 in out nocopy  VARCHAR2
200     , p6_a0 JTF_NUMBER_TABLE
201     , p6_a1 JTF_VARCHAR2_TABLE_100
202     , p6_a2 JTF_NUMBER_TABLE
203     , p6_a3 JTF_NUMBER_TABLE
204     , p6_a4 JTF_NUMBER_TABLE
205     , p6_a5 JTF_NUMBER_TABLE
206     , p6_a6 JTF_VARCHAR2_TABLE_100
207     , p6_a7 JTF_NUMBER_TABLE
208     , p6_a8 JTF_VARCHAR2_TABLE_100
209     , p6_a9 JTF_NUMBER_TABLE
210     , x_return_status out nocopy  VARCHAR2
211     , x_msg_count out nocopy  NUMBER
212     , x_msg_data out nocopy  VARCHAR2
213   );
214 end ahl_prd_disposition_pvt_w;