eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PV_ATTRIBUTE_PVT_W

Source


1 package pv_attribute_pvt_w as
2   /* $Header: pvxwatss.pls 120.1 2005/06/16 11:30 appldev  $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy pv_attribute_pvt.attribute_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_DATE_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_VARCHAR2_TABLE_100
18     , a15 JTF_VARCHAR2_TABLE_300
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_100
21     , a18 JTF_NUMBER_TABLE
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_NUMBER_TABLE
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     );
31   procedure rosetta_table_copy_out_p3(t pv_attribute_pvt.attribute_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32     , a1 out nocopy JTF_DATE_TABLE
33     , a2 out nocopy JTF_NUMBER_TABLE
34     , a3 out nocopy JTF_DATE_TABLE
35     , a4 out nocopy JTF_NUMBER_TABLE
36     , a5 out nocopy JTF_NUMBER_TABLE
37     , a6 out nocopy JTF_NUMBER_TABLE
38     , a7 out nocopy JTF_VARCHAR2_TABLE_100
39     , a8 out nocopy JTF_VARCHAR2_TABLE_100
40     , a9 out nocopy JTF_VARCHAR2_TABLE_100
41     , a10 out nocopy JTF_VARCHAR2_TABLE_100
42     , a11 out nocopy JTF_VARCHAR2_TABLE_100
43     , a12 out nocopy JTF_VARCHAR2_TABLE_100
44     , a13 out nocopy JTF_VARCHAR2_TABLE_100
45     , a14 out nocopy JTF_VARCHAR2_TABLE_100
46     , a15 out nocopy JTF_VARCHAR2_TABLE_300
47     , a16 out nocopy JTF_VARCHAR2_TABLE_100
48     , a17 out nocopy JTF_VARCHAR2_TABLE_100
49     , a18 out nocopy JTF_NUMBER_TABLE
50     , a19 out nocopy JTF_NUMBER_TABLE
51     , a20 out nocopy JTF_NUMBER_TABLE
52     , a21 out nocopy JTF_VARCHAR2_TABLE_100
53     , a22 out nocopy JTF_VARCHAR2_TABLE_100
54     , a23 out nocopy JTF_VARCHAR2_TABLE_100
55     , a24 out nocopy JTF_VARCHAR2_TABLE_100
56     , a25 out nocopy JTF_VARCHAR2_TABLE_100
57     , a26 out nocopy JTF_NUMBER_TABLE
58     );
59 
60   procedure create_attribute(p_api_version_number  NUMBER
61     , p_init_msg_list  VARCHAR2
62     , p_commit  VARCHAR2
63     , p_validation_level  NUMBER
64     , x_return_status out nocopy  VARCHAR2
65     , x_msg_count out nocopy  NUMBER
66     , x_msg_data out nocopy  VARCHAR2
67     , x_attribute_id out nocopy  NUMBER
68     , p7_a0  NUMBER := 0-1962.0724
69     , p7_a1  DATE := fnd_api.g_miss_date
70     , p7_a2  NUMBER := 0-1962.0724
71     , p7_a3  DATE := fnd_api.g_miss_date
72     , p7_a4  NUMBER := 0-1962.0724
73     , p7_a5  NUMBER := 0-1962.0724
74     , p7_a6  NUMBER := 0-1962.0724
75     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
76     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
77     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
78     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
79     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
80     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
81     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
82     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
83     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
84     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
85     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
86     , p7_a18  NUMBER := 0-1962.0724
87     , p7_a19  NUMBER := 0-1962.0724
88     , p7_a20  NUMBER := 0-1962.0724
89     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
90     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
91     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
92     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
93     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a26  NUMBER := 0-1962.0724
95   );
96   procedure update_attribute(p_api_version_number  NUMBER
97     , p_init_msg_list  VARCHAR2
98     , p_commit  VARCHAR2
99     , p_validation_level  NUMBER
100     , x_return_status out nocopy  VARCHAR2
101     , x_msg_count out nocopy  NUMBER
102     , x_msg_data out nocopy  VARCHAR2
103     , x_object_version_number out nocopy  NUMBER
104     , p7_a0  NUMBER := 0-1962.0724
105     , p7_a1  DATE := fnd_api.g_miss_date
106     , p7_a2  NUMBER := 0-1962.0724
107     , p7_a3  DATE := fnd_api.g_miss_date
108     , p7_a4  NUMBER := 0-1962.0724
109     , p7_a5  NUMBER := 0-1962.0724
110     , p7_a6  NUMBER := 0-1962.0724
111     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
112     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
113     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
114     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
115     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
116     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
117     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
118     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
119     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
120     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
121     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
122     , p7_a18  NUMBER := 0-1962.0724
123     , p7_a19  NUMBER := 0-1962.0724
124     , p7_a20  NUMBER := 0-1962.0724
125     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
126     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
127     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
128     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
129     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
130     , p7_a26  NUMBER := 0-1962.0724
131   );
132   procedure validate_attribute(p_api_version_number  NUMBER
133     , p_init_msg_list  VARCHAR2
134     , p_validation_level  NUMBER
135     , p_validation_mode  VARCHAR2
136     , x_return_status out nocopy  VARCHAR2
137     , x_msg_count out nocopy  NUMBER
138     , x_msg_data out nocopy  VARCHAR2
139     , p4_a0  NUMBER := 0-1962.0724
140     , p4_a1  DATE := fnd_api.g_miss_date
141     , p4_a2  NUMBER := 0-1962.0724
142     , p4_a3  DATE := fnd_api.g_miss_date
143     , p4_a4  NUMBER := 0-1962.0724
144     , p4_a5  NUMBER := 0-1962.0724
145     , p4_a6  NUMBER := 0-1962.0724
146     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
147     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
148     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
149     , p4_a10  VARCHAR2 := fnd_api.g_miss_char
150     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
151     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
152     , p4_a13  VARCHAR2 := fnd_api.g_miss_char
153     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
154     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
155     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
156     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
157     , p4_a18  NUMBER := 0-1962.0724
158     , p4_a19  NUMBER := 0-1962.0724
159     , p4_a20  NUMBER := 0-1962.0724
160     , p4_a21  VARCHAR2 := fnd_api.g_miss_char
161     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
162     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
163     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
164     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
165     , p4_a26  NUMBER := 0-1962.0724
166   );
167   procedure check_attribute_items(p_validation_mode  VARCHAR2
168     , x_return_status out nocopy  VARCHAR2
169     , p0_a0  NUMBER := 0-1962.0724
170     , p0_a1  DATE := fnd_api.g_miss_date
171     , p0_a2  NUMBER := 0-1962.0724
172     , p0_a3  DATE := fnd_api.g_miss_date
173     , p0_a4  NUMBER := 0-1962.0724
174     , p0_a5  NUMBER := 0-1962.0724
175     , p0_a6  NUMBER := 0-1962.0724
176     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
177     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
178     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
179     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
180     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
181     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
182     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
183     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
184     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
185     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
186     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
187     , p0_a18  NUMBER := 0-1962.0724
188     , p0_a19  NUMBER := 0-1962.0724
189     , p0_a20  NUMBER := 0-1962.0724
190     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
191     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
192     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
193     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
194     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
195     , p0_a26  NUMBER := 0-1962.0724
196   );
197   procedure validate_attribute_rec(p_api_version_number  NUMBER
198     , p_init_msg_list  VARCHAR2
199     , x_return_status out nocopy  VARCHAR2
200     , x_msg_count out nocopy  NUMBER
201     , x_msg_data out nocopy  VARCHAR2
202     , p_validation_mode  VARCHAR2
203     , p5_a0  NUMBER := 0-1962.0724
204     , p5_a1  DATE := fnd_api.g_miss_date
205     , p5_a2  NUMBER := 0-1962.0724
206     , p5_a3  DATE := fnd_api.g_miss_date
207     , p5_a4  NUMBER := 0-1962.0724
208     , p5_a5  NUMBER := 0-1962.0724
209     , p5_a6  NUMBER := 0-1962.0724
210     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
211     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
212     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
213     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
214     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
215     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
216     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
217     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
218     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
219     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
220     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
221     , p5_a18  NUMBER := 0-1962.0724
222     , p5_a19  NUMBER := 0-1962.0724
223     , p5_a20  NUMBER := 0-1962.0724
224     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
225     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
226     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
227     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
228     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
229     , p5_a26  NUMBER := 0-1962.0724
230   );
231 end pv_attribute_pvt_w;