DBA Data[Home] [Help]

PACKAGE: APPS.IBU_ORDER_CAPTURE_W

Source


1 package ibu_order_capture_w AUTHID CURRENT_USER as
2   /* $Header: iburords.pls 115.5.1159.1 2003/05/23 22:22:29 appldev noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy ibu_order_capture.header_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_VARCHAR2_TABLE_300
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_300
12     , a9 JTF_DATE_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_VARCHAR2_TABLE_100
16     );
17   procedure rosetta_table_copy_out_p1(t ibu_order_capture.header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18     , a1 out nocopy JTF_NUMBER_TABLE
19     , a2 out nocopy JTF_VARCHAR2_TABLE_300
20     , a3 out nocopy JTF_NUMBER_TABLE
21     , a4 out nocopy JTF_NUMBER_TABLE
22     , a5 out nocopy JTF_NUMBER_TABLE
23     , a6 out nocopy JTF_NUMBER_TABLE
24     , a7 out nocopy JTF_NUMBER_TABLE
25     , a8 out nocopy JTF_VARCHAR2_TABLE_300
26     , a9 out nocopy JTF_DATE_TABLE
27     , a10 out nocopy JTF_NUMBER_TABLE
28     , a11 out nocopy JTF_NUMBER_TABLE
29     , a12 out nocopy JTF_VARCHAR2_TABLE_100
30     );
31 
32   procedure rosetta_table_copy_in_p4(t out nocopy ibu_order_capture.line_tbl_type, a0 JTF_NUMBER_TABLE
33     , a1 JTF_VARCHAR2_TABLE_100
34     , a2 JTF_NUMBER_TABLE
35     , a3 JTF_VARCHAR2_TABLE_100
36     , a4 JTF_NUMBER_TABLE
37     , a5 JTF_NUMBER_TABLE
38     , a6 JTF_NUMBER_TABLE
39     , a7 JTF_NUMBER_TABLE
40     , a8 JTF_NUMBER_TABLE
41     , a9 JTF_NUMBER_TABLE
42     , a10 JTF_VARCHAR2_TABLE_100
43     , a11 JTF_NUMBER_TABLE
44     , a12 JTF_VARCHAR2_TABLE_100
45     , a13 JTF_NUMBER_TABLE
46     , a14 JTF_NUMBER_TABLE
47     );
48   procedure rosetta_table_copy_out_p4(t ibu_order_capture.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49     , a1 out nocopy JTF_VARCHAR2_TABLE_100
50     , a2 out nocopy JTF_NUMBER_TABLE
51     , a3 out nocopy JTF_VARCHAR2_TABLE_100
52     , a4 out nocopy JTF_NUMBER_TABLE
53     , a5 out nocopy JTF_NUMBER_TABLE
54     , a6 out nocopy JTF_NUMBER_TABLE
55     , a7 out nocopy JTF_NUMBER_TABLE
56     , a8 out nocopy JTF_NUMBER_TABLE
57     , a9 out nocopy JTF_NUMBER_TABLE
58     , a10 out nocopy JTF_VARCHAR2_TABLE_100
59     , a11 out nocopy JTF_NUMBER_TABLE
60     , a12 out nocopy JTF_VARCHAR2_TABLE_100
61     , a13 out nocopy JTF_NUMBER_TABLE
62     , a14 out nocopy JTF_NUMBER_TABLE
63     );
64 
65   procedure rosetta_table_copy_in_p6(t out nocopy ibu_order_capture.line_dtl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
66     , a1 JTF_NUMBER_TABLE
67     , a2 JTF_VARCHAR2_TABLE_100
68     , a3 JTF_NUMBER_TABLE
69     , a4 JTF_NUMBER_TABLE
70     , a5 JTF_VARCHAR2_TABLE_300
71     , a6 JTF_VARCHAR2_TABLE_300
72     , a7 JTF_VARCHAR2_TABLE_300
73     , a8 JTF_VARCHAR2_TABLE_300
74     , a9 JTF_VARCHAR2_TABLE_100
75     );
76   procedure rosetta_table_copy_out_p6(t ibu_order_capture.line_dtl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
77     , a1 out nocopy JTF_NUMBER_TABLE
78     , a2 out nocopy JTF_VARCHAR2_TABLE_100
79     , a3 out nocopy JTF_NUMBER_TABLE
80     , a4 out nocopy JTF_NUMBER_TABLE
81     , a5 out nocopy JTF_VARCHAR2_TABLE_300
82     , a6 out nocopy JTF_VARCHAR2_TABLE_300
83     , a7 out nocopy JTF_VARCHAR2_TABLE_300
84     , a8 out nocopy JTF_VARCHAR2_TABLE_300
85     , a9 out nocopy JTF_VARCHAR2_TABLE_100
86     );
87 
88   procedure rosetta_table_copy_in_p8(t out nocopy ibu_order_capture.line_shipment_tbl_type, a0 JTF_VARCHAR2_TABLE_100
89     , a1 JTF_NUMBER_TABLE
90     , a2 JTF_DATE_TABLE
91     , a3 JTF_DATE_TABLE
92     , a4 JTF_NUMBER_TABLE
93     , a5 JTF_NUMBER_TABLE
94     , a6 JTF_VARCHAR2_TABLE_100
95     , a7 JTF_NUMBER_TABLE
96     );
97   procedure rosetta_table_copy_out_p8(t ibu_order_capture.line_shipment_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
98     , a1 out nocopy JTF_NUMBER_TABLE
99     , a2 out nocopy JTF_DATE_TABLE
100     , a3 out nocopy JTF_DATE_TABLE
101     , a4 out nocopy JTF_NUMBER_TABLE
102     , a5 out nocopy JTF_NUMBER_TABLE
103     , a6 out nocopy JTF_VARCHAR2_TABLE_100
104     , a7 out nocopy JTF_NUMBER_TABLE
105     );
106 
107   procedure rosetta_table_copy_in_p11(t out nocopy ibu_order_capture.return_line_tbl_type, a0 JTF_NUMBER_TABLE
108     , a1 JTF_NUMBER_TABLE
109     , a2 JTF_VARCHAR2_TABLE_200
110     );
111   procedure rosetta_table_copy_out_p11(t ibu_order_capture.return_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
112     , a1 out nocopy JTF_NUMBER_TABLE
113     , a2 out nocopy JTF_VARCHAR2_TABLE_200
114     );
115 
116   procedure create_return(p_api_version_number  NUMBER
117     , p_init_msg_list  VARCHAR2
118     , p_commit  VARCHAR
119     , p_header_id  NUMBER
120     , p6_a0 JTF_NUMBER_TABLE
121     , p6_a1 JTF_VARCHAR2_TABLE_100
122     , p6_a2 JTF_NUMBER_TABLE
123     , p6_a3 JTF_VARCHAR2_TABLE_100
124     , p6_a4 JTF_NUMBER_TABLE
125     , p6_a5 JTF_NUMBER_TABLE
126     , p6_a6 JTF_NUMBER_TABLE
127     , p6_a7 JTF_NUMBER_TABLE
128     , p6_a8 JTF_NUMBER_TABLE
129     , p6_a9 JTF_NUMBER_TABLE
130     , p6_a10 JTF_VARCHAR2_TABLE_100
131     , p6_a11 JTF_NUMBER_TABLE
132     , p6_a12 JTF_VARCHAR2_TABLE_100
133     , p6_a13 JTF_NUMBER_TABLE
134     , p6_a14 JTF_NUMBER_TABLE
135     , p7_a0 JTF_VARCHAR2_TABLE_100
136     , p7_a1 JTF_NUMBER_TABLE
137     , p7_a2 JTF_VARCHAR2_TABLE_100
138     , p7_a3 JTF_NUMBER_TABLE
139     , p7_a4 JTF_NUMBER_TABLE
140     , p7_a5 JTF_VARCHAR2_TABLE_300
141     , p7_a6 JTF_VARCHAR2_TABLE_300
142     , p7_a7 JTF_VARCHAR2_TABLE_300
143     , p7_a8 JTF_VARCHAR2_TABLE_300
144     , p7_a9 JTF_VARCHAR2_TABLE_100
145     , p8_a0 JTF_VARCHAR2_TABLE_100
146     , p8_a1 JTF_NUMBER_TABLE
147     , p8_a2 JTF_DATE_TABLE
148     , p8_a3 JTF_DATE_TABLE
149     , p8_a4 JTF_NUMBER_TABLE
150     , p8_a5 JTF_NUMBER_TABLE
151     , p8_a6 JTF_VARCHAR2_TABLE_100
152     , p8_a7 JTF_NUMBER_TABLE
153     , x_msg_count out nocopy  NUMBER
154     , x_msg_data out nocopy  VARCHAR2
155     , x_return_status out nocopy  VARCHAR2
156     , p12_a0 out nocopy  NUMBER
157     , p12_a1 out nocopy  NUMBER
158     , p12_a2 out nocopy  VARCHAR2
159     , p13_a0 out nocopy JTF_NUMBER_TABLE
160     , p13_a1 out nocopy JTF_NUMBER_TABLE
161     , p13_a2 out nocopy JTF_VARCHAR2_TABLE_200
162     , p4_a0  NUMBER := 0-1962.0724
163     , p4_a1  NUMBER := 0-1962.0724
164     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
165     , p4_a3  NUMBER := 0-1962.0724
166     , p4_a4  NUMBER := 0-1962.0724
167     , p4_a5  NUMBER := 0-1962.0724
168     , p4_a6  NUMBER := 0-1962.0724
169     , p4_a7  NUMBER := 0-1962.0724
170     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
171     , p4_a9  DATE := fnd_api.g_miss_date
172     , p4_a10  NUMBER := 0-1962.0724
173     , p4_a11  NUMBER := 0-1962.0724
174     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
175     , p5_a0  DATE := fnd_api.g_miss_date
176     , p5_a1  DATE := fnd_api.g_miss_date
177     , p5_a2  NUMBER := 0-1962.0724
178     , p5_a3  NUMBER := 0-1962.0724
179     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
180     , p5_a5  NUMBER := 0-1962.0724
181   );
182 end ibu_order_capture_w;