[Home] [Help]
PACKAGE: APPS.IEX_COSTS_PVT_W
Source
1 package iex_costs_pvt_w AUTHID CURRENT_USER as
2 /* $Header: iexwcoss.pls 120.1 2005/07/06 14:04:12 schekuri noship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy iex_costs_pvt.costs_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_300
7 , a4 JTF_VARCHAR2_TABLE_300
8 , a5 JTF_VARCHAR2_TABLE_300
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_DATE_TABLE
17 , a14 JTF_VARCHAR2_TABLE_300
18 , a15 JTF_VARCHAR2_TABLE_300
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_DATE_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_DATE_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_DATE_TABLE
28 , a25 JTF_VARCHAR2_TABLE_300
29 , a26 JTF_VARCHAR2_TABLE_300
30 , a27 JTF_VARCHAR2_TABLE_300
31 , a28 JTF_VARCHAR2_TABLE_300
32 , a29 JTF_VARCHAR2_TABLE_300
33 , a30 JTF_VARCHAR2_TABLE_300
34 , a31 JTF_VARCHAR2_TABLE_300
35 , a32 JTF_VARCHAR2_TABLE_300
36 , a33 JTF_VARCHAR2_TABLE_300
37 , a34 JTF_VARCHAR2_TABLE_300
38 , a35 JTF_VARCHAR2_TABLE_300
39 , a36 JTF_VARCHAR2_TABLE_300
40 , a37 JTF_VARCHAR2_TABLE_300
41 , a38 JTF_VARCHAR2_TABLE_300
42 , a39 JTF_VARCHAR2_TABLE_300
43 , a40 JTF_VARCHAR2_TABLE_300
44 , a41 JTF_NUMBER_TABLE
45 );
46 procedure rosetta_table_copy_out_p3(t iex_costs_pvt.costs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47 , a1 out nocopy JTF_NUMBER_TABLE
48 , a2 out nocopy JTF_NUMBER_TABLE
49 , a3 out nocopy JTF_VARCHAR2_TABLE_300
50 , a4 out nocopy JTF_VARCHAR2_TABLE_300
51 , a5 out nocopy JTF_VARCHAR2_TABLE_300
52 , a6 out nocopy JTF_NUMBER_TABLE
53 , a7 out nocopy JTF_VARCHAR2_TABLE_100
54 , a8 out nocopy JTF_NUMBER_TABLE
55 , a9 out nocopy JTF_DATE_TABLE
56 , a10 out nocopy JTF_NUMBER_TABLE
57 , a11 out nocopy JTF_VARCHAR2_TABLE_100
58 , a12 out nocopy JTF_NUMBER_TABLE
59 , a13 out nocopy JTF_DATE_TABLE
60 , a14 out nocopy JTF_VARCHAR2_TABLE_300
61 , a15 out nocopy JTF_VARCHAR2_TABLE_300
62 , a16 out nocopy JTF_NUMBER_TABLE
63 , a17 out nocopy JTF_NUMBER_TABLE
64 , a18 out nocopy JTF_DATE_TABLE
65 , a19 out nocopy JTF_NUMBER_TABLE
66 , a20 out nocopy JTF_DATE_TABLE
67 , a21 out nocopy JTF_NUMBER_TABLE
68 , a22 out nocopy JTF_NUMBER_TABLE
69 , a23 out nocopy JTF_NUMBER_TABLE
70 , a24 out nocopy JTF_DATE_TABLE
71 , a25 out nocopy JTF_VARCHAR2_TABLE_300
72 , a26 out nocopy JTF_VARCHAR2_TABLE_300
73 , a27 out nocopy JTF_VARCHAR2_TABLE_300
74 , a28 out nocopy JTF_VARCHAR2_TABLE_300
75 , a29 out nocopy JTF_VARCHAR2_TABLE_300
76 , a30 out nocopy JTF_VARCHAR2_TABLE_300
77 , a31 out nocopy JTF_VARCHAR2_TABLE_300
78 , a32 out nocopy JTF_VARCHAR2_TABLE_300
79 , a33 out nocopy JTF_VARCHAR2_TABLE_300
80 , a34 out nocopy JTF_VARCHAR2_TABLE_300
81 , a35 out nocopy JTF_VARCHAR2_TABLE_300
82 , a36 out nocopy JTF_VARCHAR2_TABLE_300
83 , a37 out nocopy JTF_VARCHAR2_TABLE_300
84 , a38 out nocopy JTF_VARCHAR2_TABLE_300
85 , a39 out nocopy JTF_VARCHAR2_TABLE_300
86 , a40 out nocopy JTF_VARCHAR2_TABLE_300
87 , a41 out nocopy JTF_NUMBER_TABLE
88 );
89
90 procedure create_costs(p_api_version_number NUMBER
91 , p_init_msg_list VARCHAR2
92 , p_commit VARCHAR2
93 , p_validation_level NUMBER
94 , x_cost_id out nocopy NUMBER
95 , x_return_status out nocopy VARCHAR2
96 , x_msg_count out nocopy NUMBER
97 , x_msg_data out nocopy VARCHAR2
98 , p4_a0 NUMBER := 0-1962.0724
99 , p4_a1 NUMBER := 0-1962.0724
100 , p4_a2 NUMBER := 0-1962.0724
101 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
102 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
103 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
104 , p4_a6 NUMBER := 0-1962.0724
105 , p4_a7 VARCHAR2 := fnd_api.g_miss_char
106 , p4_a8 NUMBER := 0-1962.0724
107 , p4_a9 DATE := fnd_api.g_miss_date
108 , p4_a10 NUMBER := 0-1962.0724
109 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
110 , p4_a12 NUMBER := 0-1962.0724
111 , p4_a13 DATE := fnd_api.g_miss_date
112 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
113 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
114 , p4_a16 NUMBER := 0-1962.0724
115 , p4_a17 NUMBER := 0-1962.0724
116 , p4_a18 DATE := fnd_api.g_miss_date
117 , p4_a19 NUMBER := 0-1962.0724
118 , p4_a20 DATE := fnd_api.g_miss_date
119 , p4_a21 NUMBER := 0-1962.0724
120 , p4_a22 NUMBER := 0-1962.0724
121 , p4_a23 NUMBER := 0-1962.0724
122 , p4_a24 DATE := fnd_api.g_miss_date
123 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
124 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
125 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
126 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
127 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
128 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
129 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
130 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
131 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
132 , p4_a34 VARCHAR2 := fnd_api.g_miss_char
133 , p4_a35 VARCHAR2 := fnd_api.g_miss_char
134 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
135 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
136 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
137 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
138 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
139 , p4_a41 NUMBER := 0-1962.0724
140 );
141 procedure update_costs(p_api_version_number NUMBER
142 , p_init_msg_list VARCHAR2
143 , p_commit VARCHAR2
144 , p_validation_level NUMBER
145 , x_return_status out nocopy VARCHAR2
146 , x_msg_count out nocopy NUMBER
147 , x_msg_data out nocopy VARCHAR2
148 , xo_object_version_number out nocopy NUMBER
149 , p4_a0 NUMBER := 0-1962.0724
150 , p4_a1 NUMBER := 0-1962.0724
151 , p4_a2 NUMBER := 0-1962.0724
152 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
153 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
154 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
155 , p4_a6 NUMBER := 0-1962.0724
156 , p4_a7 VARCHAR2 := fnd_api.g_miss_char
157 , p4_a8 NUMBER := 0-1962.0724
158 , p4_a9 DATE := fnd_api.g_miss_date
159 , p4_a10 NUMBER := 0-1962.0724
160 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
161 , p4_a12 NUMBER := 0-1962.0724
162 , p4_a13 DATE := fnd_api.g_miss_date
163 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
164 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
165 , p4_a16 NUMBER := 0-1962.0724
166 , p4_a17 NUMBER := 0-1962.0724
167 , p4_a18 DATE := fnd_api.g_miss_date
168 , p4_a19 NUMBER := 0-1962.0724
169 , p4_a20 DATE := fnd_api.g_miss_date
170 , p4_a21 NUMBER := 0-1962.0724
171 , p4_a22 NUMBER := 0-1962.0724
172 , p4_a23 NUMBER := 0-1962.0724
173 , p4_a24 DATE := fnd_api.g_miss_date
174 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
175 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
176 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
177 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
178 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
179 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
180 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
181 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
182 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
183 , p4_a34 VARCHAR2 := fnd_api.g_miss_char
184 , p4_a35 VARCHAR2 := fnd_api.g_miss_char
185 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
186 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
187 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
188 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
189 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
190 , p4_a41 NUMBER := 0-1962.0724
191 );
192 end iex_costs_pvt_w;