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_ENTY_ATTR_VALUE_PVT_W

Source


1 package pv_enty_attr_value_pvt_w as
2   /* $Header: pvxweavs.pls 120.1 2005/11/11 15:28 amaram noship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy pv_enty_attr_value_pvt.enty_attr_value_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_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_VARCHAR2_TABLE_2000
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_4000
20     , a17 JTF_NUMBER_TABLE
21     );
22   procedure rosetta_table_copy_out_p2(t pv_enty_attr_value_pvt.enty_attr_value_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23     , a1 out nocopy JTF_DATE_TABLE
24     , a2 out nocopy JTF_NUMBER_TABLE
25     , a3 out nocopy JTF_DATE_TABLE
26     , a4 out nocopy JTF_NUMBER_TABLE
27     , a5 out nocopy JTF_NUMBER_TABLE
28     , a6 out nocopy JTF_NUMBER_TABLE
29     , a7 out nocopy JTF_VARCHAR2_TABLE_100
30     , a8 out nocopy JTF_NUMBER_TABLE
31     , a9 out nocopy JTF_NUMBER_TABLE
32     , a10 out nocopy JTF_VARCHAR2_TABLE_2000
33     , a11 out nocopy JTF_VARCHAR2_TABLE_100
34     , a12 out nocopy JTF_VARCHAR2_TABLE_100
35     , a13 out nocopy JTF_NUMBER_TABLE
36     , a14 out nocopy JTF_NUMBER_TABLE
37     , a15 out nocopy JTF_VARCHAR2_TABLE_100
38     , a16 out nocopy JTF_VARCHAR2_TABLE_4000
39     , a17 out nocopy JTF_NUMBER_TABLE
40     );
41 
42   procedure create_attr_value(p_api_version_number  NUMBER
43     , p_init_msg_list  VARCHAR2
44     , p_commit  VARCHAR2
45     , p_validation_level  NUMBER
46     , x_return_status out nocopy  VARCHAR2
47     , x_msg_count out nocopy  NUMBER
48     , x_msg_data out nocopy  VARCHAR2
49     , x_enty_attr_val_id out nocopy  NUMBER
50     , p7_a0  NUMBER := 0-1962.0724
51     , p7_a1  DATE := fnd_api.g_miss_date
52     , p7_a2  NUMBER := 0-1962.0724
53     , p7_a3  DATE := fnd_api.g_miss_date
54     , p7_a4  NUMBER := 0-1962.0724
55     , p7_a5  NUMBER := 0-1962.0724
56     , p7_a6  NUMBER := 0-1962.0724
57     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
58     , p7_a8  NUMBER := 0-1962.0724
59     , p7_a9  NUMBER := 0-1962.0724
60     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
61     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
62     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
63     , p7_a13  NUMBER := 0-1962.0724
64     , p7_a14  NUMBER := 0-1962.0724
65     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
66     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
67     , p7_a17  NUMBER := 0-1962.0724
68   );
69   procedure update_attr_value(p_api_version_number  NUMBER
70     , p_init_msg_list  VARCHAR2
71     , p_commit  VARCHAR2
72     , p_validation_level  NUMBER
73     , x_return_status out nocopy  VARCHAR2
74     , x_msg_count out nocopy  NUMBER
75     , x_msg_data out nocopy  VARCHAR2
76     , x_object_version_number out nocopy  NUMBER
77     , p7_a0  NUMBER := 0-1962.0724
78     , p7_a1  DATE := fnd_api.g_miss_date
79     , p7_a2  NUMBER := 0-1962.0724
80     , p7_a3  DATE := fnd_api.g_miss_date
81     , p7_a4  NUMBER := 0-1962.0724
82     , p7_a5  NUMBER := 0-1962.0724
83     , p7_a6  NUMBER := 0-1962.0724
84     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
85     , p7_a8  NUMBER := 0-1962.0724
86     , p7_a9  NUMBER := 0-1962.0724
87     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
88     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
89     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
90     , p7_a13  NUMBER := 0-1962.0724
91     , p7_a14  NUMBER := 0-1962.0724
92     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
93     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a17  NUMBER := 0-1962.0724
95   );
96   procedure validate_attr_value(p_api_version_number  NUMBER
97     , p_init_msg_list  VARCHAR2
98     , p_validation_level  NUMBER
99     , p_validation_mode  VARCHAR2
100     , x_return_status out nocopy  VARCHAR2
101     , x_msg_count out nocopy  NUMBER
102     , x_msg_data out nocopy  VARCHAR2
103     , p4_a0  NUMBER := 0-1962.0724
104     , p4_a1  DATE := fnd_api.g_miss_date
105     , p4_a2  NUMBER := 0-1962.0724
106     , p4_a3  DATE := fnd_api.g_miss_date
107     , p4_a4  NUMBER := 0-1962.0724
108     , p4_a5  NUMBER := 0-1962.0724
109     , p4_a6  NUMBER := 0-1962.0724
110     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
111     , p4_a8  NUMBER := 0-1962.0724
112     , p4_a9  NUMBER := 0-1962.0724
113     , p4_a10  VARCHAR2 := fnd_api.g_miss_char
114     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
115     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
116     , p4_a13  NUMBER := 0-1962.0724
117     , p4_a14  NUMBER := 0-1962.0724
118     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
119     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
120     , p4_a17  NUMBER := 0-1962.0724
121   );
122   procedure check_attr_value_items(p_validation_mode  VARCHAR2
123     , x_return_status out nocopy  VARCHAR2
124     , p0_a0  NUMBER := 0-1962.0724
125     , p0_a1  DATE := fnd_api.g_miss_date
126     , p0_a2  NUMBER := 0-1962.0724
127     , p0_a3  DATE := fnd_api.g_miss_date
128     , p0_a4  NUMBER := 0-1962.0724
129     , p0_a5  NUMBER := 0-1962.0724
130     , p0_a6  NUMBER := 0-1962.0724
131     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
132     , p0_a8  NUMBER := 0-1962.0724
133     , p0_a9  NUMBER := 0-1962.0724
134     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
135     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
136     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
137     , p0_a13  NUMBER := 0-1962.0724
138     , p0_a14  NUMBER := 0-1962.0724
139     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
140     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
141     , p0_a17  NUMBER := 0-1962.0724
142   );
143   procedure validate_attr_val_rec(p_api_version_number  NUMBER
144     , p_init_msg_list  VARCHAR2
145     , x_return_status out nocopy  VARCHAR2
146     , x_msg_count out nocopy  NUMBER
147     , x_msg_data out nocopy  VARCHAR2
148     , p_validation_mode  VARCHAR2
149     , p5_a0  NUMBER := 0-1962.0724
150     , p5_a1  DATE := fnd_api.g_miss_date
151     , p5_a2  NUMBER := 0-1962.0724
152     , p5_a3  DATE := fnd_api.g_miss_date
153     , p5_a4  NUMBER := 0-1962.0724
154     , p5_a5  NUMBER := 0-1962.0724
155     , p5_a6  NUMBER := 0-1962.0724
156     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
157     , p5_a8  NUMBER := 0-1962.0724
158     , p5_a9  NUMBER := 0-1962.0724
159     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
160     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
161     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
162     , p5_a13  NUMBER := 0-1962.0724
163     , p5_a14  NUMBER := 0-1962.0724
164     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
165     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
166     , p5_a17  NUMBER := 0-1962.0724
167   );
168 end pv_enty_attr_value_pvt_w;