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_ENTITY_ATTRIBUTE_PVT_W

Source


1 package pv_entity_attribute_pvt_w as
2   /* $Header: pvxweats.pls 120.2 2005/07/05 14:45 appldev ship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy pv_entity_attribute_pvt.pv_entity_attr_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_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_2000
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_VARCHAR2_TABLE_2000
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_VARCHAR2_TABLE_100
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_2000
21     , a18 JTF_NUMBER_TABLE
22     , a19 JTF_VARCHAR2_TABLE_100
23     , a20 JTF_VARCHAR2_TABLE_2000
24     , a21 JTF_DATE_TABLE
25     , a22 JTF_VARCHAR2_TABLE_100
26     );
27   procedure rosetta_table_copy_out_p2(t pv_entity_attribute_pvt.pv_entity_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
28     , a1 out nocopy JTF_DATE_TABLE
29     , a2 out nocopy JTF_NUMBER_TABLE
30     , a3 out nocopy JTF_DATE_TABLE
31     , a4 out nocopy JTF_NUMBER_TABLE
32     , a5 out nocopy JTF_NUMBER_TABLE
33     , a6 out nocopy JTF_NUMBER_TABLE
34     , a7 out nocopy JTF_NUMBER_TABLE
35     , a8 out nocopy JTF_VARCHAR2_TABLE_100
36     , a9 out nocopy JTF_VARCHAR2_TABLE_100
37     , a10 out nocopy JTF_VARCHAR2_TABLE_2000
38     , a11 out nocopy JTF_VARCHAR2_TABLE_100
39     , a12 out nocopy JTF_VARCHAR2_TABLE_2000
40     , a13 out nocopy JTF_VARCHAR2_TABLE_100
41     , a14 out nocopy JTF_VARCHAR2_TABLE_100
42     , a15 out nocopy JTF_VARCHAR2_TABLE_100
43     , a16 out nocopy JTF_VARCHAR2_TABLE_100
44     , a17 out nocopy JTF_VARCHAR2_TABLE_2000
45     , a18 out nocopy JTF_NUMBER_TABLE
46     , a19 out nocopy JTF_VARCHAR2_TABLE_100
47     , a20 out nocopy JTF_VARCHAR2_TABLE_2000
48     , a21 out nocopy JTF_DATE_TABLE
49     , a22 out nocopy JTF_VARCHAR2_TABLE_100
50     );
51 
52   procedure create_entity_attr(p_api_version_number  NUMBER
53     , p_init_msg_list  VARCHAR2
54     , p_commit  VARCHAR2
55     , p_validation_level  NUMBER
56     , x_return_status out nocopy  VARCHAR2
57     , x_msg_count out nocopy  NUMBER
58     , x_msg_data out nocopy  VARCHAR2
59     , x_entity_attr_id out nocopy  NUMBER
60     , p7_a0  NUMBER := 0-1962.0724
61     , p7_a1  DATE := fnd_api.g_miss_date
62     , p7_a2  NUMBER := 0-1962.0724
63     , p7_a3  DATE := fnd_api.g_miss_date
64     , p7_a4  NUMBER := 0-1962.0724
65     , p7_a5  NUMBER := 0-1962.0724
66     , p7_a6  NUMBER := 0-1962.0724
67     , p7_a7  NUMBER := 0-1962.0724
68     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
69     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
70     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
71     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
72     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
73     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
75     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
76     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
77     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
78     , p7_a18  NUMBER := 0-1962.0724
79     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
80     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
81     , p7_a21  DATE := fnd_api.g_miss_date
82     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
83   );
84   procedure update_entity_attr(p_api_version_number  NUMBER
85     , p_init_msg_list  VARCHAR2
86     , p_commit  VARCHAR2
87     , p_validation_level  NUMBER
88     , x_return_status out nocopy  VARCHAR2
89     , x_msg_count out nocopy  NUMBER
90     , x_msg_data out nocopy  VARCHAR2
91     , x_object_version_number out nocopy  NUMBER
92     , p7_a0  NUMBER := 0-1962.0724
93     , p7_a1  DATE := fnd_api.g_miss_date
94     , p7_a2  NUMBER := 0-1962.0724
95     , p7_a3  DATE := fnd_api.g_miss_date
96     , p7_a4  NUMBER := 0-1962.0724
97     , p7_a5  NUMBER := 0-1962.0724
98     , p7_a6  NUMBER := 0-1962.0724
99     , p7_a7  NUMBER := 0-1962.0724
100     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
101     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
102     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
103     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
104     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
105     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
106     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
107     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
108     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
109     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
110     , p7_a18  NUMBER := 0-1962.0724
111     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
112     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
113     , p7_a21  DATE := fnd_api.g_miss_date
114     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
115   );
116   procedure validate_entity_attr(p_api_version_number  NUMBER
117     , p_init_msg_list  VARCHAR2
118     , p_validation_level  NUMBER
119     , p_validation_mode  VARCHAR2
120     , x_return_status out nocopy  VARCHAR2
121     , x_msg_count out nocopy  NUMBER
122     , x_msg_data out nocopy  VARCHAR2
123     , p4_a0  NUMBER := 0-1962.0724
124     , p4_a1  DATE := fnd_api.g_miss_date
125     , p4_a2  NUMBER := 0-1962.0724
126     , p4_a3  DATE := fnd_api.g_miss_date
127     , p4_a4  NUMBER := 0-1962.0724
128     , p4_a5  NUMBER := 0-1962.0724
129     , p4_a6  NUMBER := 0-1962.0724
130     , p4_a7  NUMBER := 0-1962.0724
131     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
132     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
133     , p4_a10  VARCHAR2 := fnd_api.g_miss_char
134     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
135     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
136     , p4_a13  VARCHAR2 := fnd_api.g_miss_char
137     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
138     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
139     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
140     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
141     , p4_a18  NUMBER := 0-1962.0724
142     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
143     , p4_a20  VARCHAR2 := fnd_api.g_miss_char
144     , p4_a21  DATE := fnd_api.g_miss_date
145     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
146   );
147   procedure check_entity_attr_items(p_validation_mode  VARCHAR2
148     , x_return_status out nocopy  VARCHAR2
149     , p0_a0  NUMBER := 0-1962.0724
150     , p0_a1  DATE := fnd_api.g_miss_date
151     , p0_a2  NUMBER := 0-1962.0724
152     , p0_a3  DATE := fnd_api.g_miss_date
153     , p0_a4  NUMBER := 0-1962.0724
154     , p0_a5  NUMBER := 0-1962.0724
155     , p0_a6  NUMBER := 0-1962.0724
156     , p0_a7  NUMBER := 0-1962.0724
157     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
158     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
159     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
160     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
161     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
162     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
163     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
164     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
165     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
166     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
167     , p0_a18  NUMBER := 0-1962.0724
168     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
169     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
170     , p0_a21  DATE := fnd_api.g_miss_date
171     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
172   );
173   procedure validate_entity_attr_rec(p_api_version_number  NUMBER
174     , p_init_msg_list  VARCHAR2
175     , x_return_status out nocopy  VARCHAR2
176     , x_msg_count out nocopy  NUMBER
177     , x_msg_data out nocopy  VARCHAR2
178     , p_validation_mode  VARCHAR2
179     , p5_a0  NUMBER := 0-1962.0724
180     , p5_a1  DATE := fnd_api.g_miss_date
181     , p5_a2  NUMBER := 0-1962.0724
182     , p5_a3  DATE := fnd_api.g_miss_date
183     , p5_a4  NUMBER := 0-1962.0724
184     , p5_a5  NUMBER := 0-1962.0724
185     , p5_a6  NUMBER := 0-1962.0724
186     , p5_a7  NUMBER := 0-1962.0724
187     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
188     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
189     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
190     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
191     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
192     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
193     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
194     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
195     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
196     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
197     , p5_a18  NUMBER := 0-1962.0724
198     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
199     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
200     , p5_a21  DATE := fnd_api.g_miss_date
201     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
202   );
203 end pv_entity_attribute_pvt_w;