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_GE_NOTIF_RULES_PVT_W

Source


1 package pv_ge_notif_rules_pvt_w AUTHID CURRENT_USER as
2   /* $Header: pvxwgnrs.pls 115.2 2002/11/21 08:55:17 anubhavk ship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy pv_ge_notif_rules_pvt.ge_notif_rules_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_NUMBER_TABLE
19     , a16 JTF_DATE_TABLE
20     , a17 JTF_NUMBER_TABLE
21     , a18 JTF_DATE_TABLE
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_VARCHAR2_TABLE_4000
24     , a21 JTF_VARCHAR2_TABLE_4000
25     , a22 JTF_VARCHAR2_TABLE_4000
26     );
27   procedure rosetta_table_copy_out_p2(t pv_ge_notif_rules_pvt.ge_notif_rules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
28     , a1 out nocopy JTF_NUMBER_TABLE
29     , a2 out nocopy JTF_VARCHAR2_TABLE_100
30     , a3 out nocopy JTF_NUMBER_TABLE
31     , a4 out nocopy JTF_VARCHAR2_TABLE_100
32     , a5 out nocopy JTF_VARCHAR2_TABLE_100
33     , a6 out nocopy JTF_VARCHAR2_TABLE_100
34     , a7 out nocopy JTF_VARCHAR2_TABLE_100
35     , a8 out nocopy JTF_NUMBER_TABLE
36     , a9 out nocopy JTF_VARCHAR2_TABLE_100
37     , a10 out nocopy JTF_NUMBER_TABLE
38     , a11 out nocopy JTF_VARCHAR2_TABLE_100
39     , a12 out nocopy JTF_NUMBER_TABLE
40     , a13 out nocopy JTF_VARCHAR2_TABLE_100
41     , a14 out nocopy JTF_NUMBER_TABLE
42     , a15 out nocopy JTF_NUMBER_TABLE
43     , a16 out nocopy JTF_DATE_TABLE
44     , a17 out nocopy JTF_NUMBER_TABLE
45     , a18 out nocopy JTF_DATE_TABLE
46     , a19 out nocopy JTF_NUMBER_TABLE
47     , a20 out nocopy JTF_VARCHAR2_TABLE_4000
48     , a21 out nocopy JTF_VARCHAR2_TABLE_4000
49     , a22 out nocopy JTF_VARCHAR2_TABLE_4000
50     );
51 
52   procedure create_ge_notif_rules(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_notif_rule_id out nocopy  NUMBER
60     , p7_a0  NUMBER := 0-1962.0724
61     , p7_a1  NUMBER := 0-1962.0724
62     , p7_a2  VARCHAR2 := fnd_api.g_miss_char
63     , p7_a3  NUMBER := 0-1962.0724
64     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
65     , p7_a5  VARCHAR2 := fnd_api.g_miss_char
66     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
67     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
68     , p7_a8  NUMBER := 0-1962.0724
69     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
70     , p7_a10  NUMBER := 0-1962.0724
71     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
72     , p7_a12  NUMBER := 0-1962.0724
73     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a14  NUMBER := 0-1962.0724
75     , p7_a15  NUMBER := 0-1962.0724
76     , p7_a16  DATE := fnd_api.g_miss_date
77     , p7_a17  NUMBER := 0-1962.0724
78     , p7_a18  DATE := fnd_api.g_miss_date
79     , p7_a19  NUMBER := 0-1962.0724
80     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
81     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
82     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
83   );
84   procedure update_ge_notif_rules(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     , p7_a0  NUMBER := 0-1962.0724
92     , p7_a1  NUMBER := 0-1962.0724
93     , p7_a2  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a3  NUMBER := 0-1962.0724
95     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
96     , p7_a5  VARCHAR2 := fnd_api.g_miss_char
97     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
98     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
99     , p7_a8  NUMBER := 0-1962.0724
100     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
101     , p7_a10  NUMBER := 0-1962.0724
102     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
103     , p7_a12  NUMBER := 0-1962.0724
104     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
105     , p7_a14  NUMBER := 0-1962.0724
106     , p7_a15  NUMBER := 0-1962.0724
107     , p7_a16  DATE := fnd_api.g_miss_date
108     , p7_a17  NUMBER := 0-1962.0724
109     , p7_a18  DATE := fnd_api.g_miss_date
110     , p7_a19  NUMBER := 0-1962.0724
111     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
112     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
113     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
114   );
115   procedure validate_ge_notif_rules(p_api_version_number  NUMBER
116     , p_init_msg_list  VARCHAR2
117     , p_validation_level  NUMBER
118     , p_validation_mode  VARCHAR2
119     , x_return_status out nocopy  VARCHAR2
120     , x_msg_count out nocopy  NUMBER
121     , x_msg_data out nocopy  VARCHAR2
122     , p3_a0  NUMBER := 0-1962.0724
123     , p3_a1  NUMBER := 0-1962.0724
124     , p3_a2  VARCHAR2 := fnd_api.g_miss_char
125     , p3_a3  NUMBER := 0-1962.0724
126     , p3_a4  VARCHAR2 := fnd_api.g_miss_char
127     , p3_a5  VARCHAR2 := fnd_api.g_miss_char
128     , p3_a6  VARCHAR2 := fnd_api.g_miss_char
129     , p3_a7  VARCHAR2 := fnd_api.g_miss_char
130     , p3_a8  NUMBER := 0-1962.0724
131     , p3_a9  VARCHAR2 := fnd_api.g_miss_char
132     , p3_a10  NUMBER := 0-1962.0724
133     , p3_a11  VARCHAR2 := fnd_api.g_miss_char
134     , p3_a12  NUMBER := 0-1962.0724
135     , p3_a13  VARCHAR2 := fnd_api.g_miss_char
136     , p3_a14  NUMBER := 0-1962.0724
137     , p3_a15  NUMBER := 0-1962.0724
138     , p3_a16  DATE := fnd_api.g_miss_date
139     , p3_a17  NUMBER := 0-1962.0724
140     , p3_a18  DATE := fnd_api.g_miss_date
141     , p3_a19  NUMBER := 0-1962.0724
142     , p3_a20  VARCHAR2 := fnd_api.g_miss_char
143     , p3_a21  VARCHAR2 := fnd_api.g_miss_char
144     , p3_a22  VARCHAR2 := fnd_api.g_miss_char
145   );
146   procedure check_ge_notif_rules_items(p_validation_mode  VARCHAR2
147     , x_return_status out nocopy  VARCHAR2
148     , p0_a0  NUMBER := 0-1962.0724
149     , p0_a1  NUMBER := 0-1962.0724
150     , p0_a2  VARCHAR2 := fnd_api.g_miss_char
151     , p0_a3  NUMBER := 0-1962.0724
152     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
153     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
154     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
155     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
156     , p0_a8  NUMBER := 0-1962.0724
157     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
158     , p0_a10  NUMBER := 0-1962.0724
159     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
160     , p0_a12  NUMBER := 0-1962.0724
161     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
162     , p0_a14  NUMBER := 0-1962.0724
163     , p0_a15  NUMBER := 0-1962.0724
164     , p0_a16  DATE := fnd_api.g_miss_date
165     , p0_a17  NUMBER := 0-1962.0724
166     , p0_a18  DATE := fnd_api.g_miss_date
167     , p0_a19  NUMBER := 0-1962.0724
168     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
169     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
170     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
171   );
172   procedure validate_ge_notif_rules_rec(p_api_version_number  NUMBER
173     , p_init_msg_list  VARCHAR2
174     , x_return_status out nocopy  VARCHAR2
175     , x_msg_count out nocopy  NUMBER
176     , x_msg_data out nocopy  VARCHAR2
177     , p5_a0  NUMBER := 0-1962.0724
178     , p5_a1  NUMBER := 0-1962.0724
179     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
180     , p5_a3  NUMBER := 0-1962.0724
181     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
182     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
183     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
184     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
185     , p5_a8  NUMBER := 0-1962.0724
186     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
187     , p5_a10  NUMBER := 0-1962.0724
188     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
189     , p5_a12  NUMBER := 0-1962.0724
190     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
191     , p5_a14  NUMBER := 0-1962.0724
192     , p5_a15  NUMBER := 0-1962.0724
193     , p5_a16  DATE := fnd_api.g_miss_date
194     , p5_a17  NUMBER := 0-1962.0724
195     , p5_a18  DATE := fnd_api.g_miss_date
196     , p5_a19  NUMBER := 0-1962.0724
197     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
198     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
199     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
200   );
201 end pv_ge_notif_rules_pvt_w;