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.AMS_LISTSOURCETYPE_PVT_W

Source


1 package ams_listsourcetype_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswlsts.pls 115.11 2002/11/22 08:57:45 jieli ship $ */
3   procedure create_listsourcetype(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , x_return_status OUT NOCOPY  VARCHAR2
8     , x_msg_count OUT NOCOPY  NUMBER
9     , x_msg_data OUT NOCOPY  VARCHAR2
10     , x_list_source_type_id OUT NOCOPY  NUMBER
11     , p7_a0  NUMBER := 0-1962.0724
12     , p7_a1  DATE := fnd_api.g_miss_date
13     , p7_a2  NUMBER := 0-1962.0724
14     , p7_a3  DATE := fnd_api.g_miss_date
15     , p7_a4  NUMBER := 0-1962.0724
16     , p7_a5  NUMBER := 0-1962.0724
17     , p7_a6  NUMBER := 0-1962.0724
18     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
19     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
20     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
21     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
22     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
23     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
24     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
25     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
26     , p7_a15  NUMBER := 0-1962.0724
27     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
28     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
29     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
30     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
31   );
32   procedure update_listsourcetype(p_api_version  NUMBER
33     , p_init_msg_list  VARCHAR2
34     , p_commit  VARCHAR2
35     , p_validation_level  NUMBER
36     , x_return_status OUT NOCOPY  VARCHAR2
37     , x_msg_count OUT NOCOPY  NUMBER
38     , x_msg_data OUT NOCOPY  VARCHAR2
39     , p7_a0  NUMBER := 0-1962.0724
40     , p7_a1  DATE := fnd_api.g_miss_date
41     , p7_a2  NUMBER := 0-1962.0724
42     , p7_a3  DATE := fnd_api.g_miss_date
43     , p7_a4  NUMBER := 0-1962.0724
44     , p7_a5  NUMBER := 0-1962.0724
45     , p7_a6  NUMBER := 0-1962.0724
46     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
47     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
48     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
49     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
50     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
51     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
52     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
53     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
54     , p7_a15  NUMBER := 0-1962.0724
55     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
56     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
57     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
58     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
59   );
60   procedure validate_listsourcetype(p_api_version  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     , p7_a0  NUMBER := 0-1962.0724
68     , p7_a1  DATE := fnd_api.g_miss_date
69     , p7_a2  NUMBER := 0-1962.0724
70     , p7_a3  DATE := fnd_api.g_miss_date
71     , p7_a4  NUMBER := 0-1962.0724
72     , p7_a5  NUMBER := 0-1962.0724
73     , p7_a6  NUMBER := 0-1962.0724
74     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
75     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
76     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
77     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
78     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
79     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
80     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
81     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
82     , p7_a15  NUMBER := 0-1962.0724
83     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
84     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
85     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
86     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
87   );
88   procedure check_listsourcetype_items(p_validation_mode  VARCHAR2
89     , x_return_status OUT NOCOPY  VARCHAR2
90     , p0_a0  NUMBER := 0-1962.0724
91     , p0_a1  DATE := fnd_api.g_miss_date
92     , p0_a2  NUMBER := 0-1962.0724
93     , p0_a3  DATE := fnd_api.g_miss_date
94     , p0_a4  NUMBER := 0-1962.0724
95     , p0_a5  NUMBER := 0-1962.0724
96     , p0_a6  NUMBER := 0-1962.0724
97     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
98     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
99     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
100     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
101     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
102     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
103     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
104     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
105     , p0_a15  NUMBER := 0-1962.0724
106     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
107     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
108     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
109     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
110   );
111   procedure check_listsourcetype_record(x_return_status OUT NOCOPY  VARCHAR2
112     , p0_a0  NUMBER := 0-1962.0724
113     , p0_a1  DATE := fnd_api.g_miss_date
114     , p0_a2  NUMBER := 0-1962.0724
115     , p0_a3  DATE := fnd_api.g_miss_date
116     , p0_a4  NUMBER := 0-1962.0724
117     , p0_a5  NUMBER := 0-1962.0724
118     , p0_a6  NUMBER := 0-1962.0724
119     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
120     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
121     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
122     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
123     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
124     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
125     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
126     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
127     , p0_a15  NUMBER := 0-1962.0724
128     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
129     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
130     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
131     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
132     , p1_a0  NUMBER := 0-1962.0724
133     , p1_a1  DATE := fnd_api.g_miss_date
134     , p1_a2  NUMBER := 0-1962.0724
135     , p1_a3  DATE := fnd_api.g_miss_date
136     , p1_a4  NUMBER := 0-1962.0724
137     , p1_a5  NUMBER := 0-1962.0724
138     , p1_a6  NUMBER := 0-1962.0724
139     , p1_a7  VARCHAR2 := fnd_api.g_miss_char
140     , p1_a8  VARCHAR2 := fnd_api.g_miss_char
141     , p1_a9  VARCHAR2 := fnd_api.g_miss_char
142     , p1_a10  VARCHAR2 := fnd_api.g_miss_char
143     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
144     , p1_a12  VARCHAR2 := fnd_api.g_miss_char
145     , p1_a13  VARCHAR2 := fnd_api.g_miss_char
146     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
147     , p1_a15  NUMBER := 0-1962.0724
148     , p1_a16  VARCHAR2 := fnd_api.g_miss_char
149     , p1_a17  VARCHAR2 := fnd_api.g_miss_char
150     , p1_a18  VARCHAR2 := fnd_api.g_miss_char
151     , p1_a19  VARCHAR2 := fnd_api.g_miss_char
152   );
153   procedure init_listsourcetype_rec(p0_a0 OUT NOCOPY  NUMBER
154     , p0_a1 OUT NOCOPY  DATE
155     , p0_a2 OUT NOCOPY  NUMBER
156     , p0_a3 OUT NOCOPY  DATE
157     , p0_a4 OUT NOCOPY  NUMBER
158     , p0_a5 OUT NOCOPY  NUMBER
159     , p0_a6 OUT NOCOPY  NUMBER
160     , p0_a7 OUT NOCOPY  VARCHAR2
161     , p0_a8 OUT NOCOPY  VARCHAR2
162     , p0_a9 OUT NOCOPY  VARCHAR2
163     , p0_a10 OUT NOCOPY  VARCHAR2
164     , p0_a11 OUT NOCOPY  VARCHAR2
165     , p0_a12 OUT NOCOPY  VARCHAR2
166     , p0_a13 OUT NOCOPY  VARCHAR2
167     , p0_a14 OUT NOCOPY  VARCHAR2
168     , p0_a15 OUT NOCOPY  NUMBER
169     , p0_a16 OUT NOCOPY  VARCHAR2
170     , p0_a17 OUT NOCOPY  VARCHAR2
171     , p0_a18 OUT NOCOPY  VARCHAR2
172     , p0_a19 OUT NOCOPY  VARCHAR2
173   );
174   procedure complete_listsourcetype_rec(p1_a0 OUT NOCOPY  NUMBER
175     , p1_a1 OUT NOCOPY  DATE
176     , p1_a2 OUT NOCOPY  NUMBER
177     , p1_a3 OUT NOCOPY  DATE
178     , p1_a4 OUT NOCOPY  NUMBER
179     , p1_a5 OUT NOCOPY  NUMBER
180     , p1_a6 OUT NOCOPY  NUMBER
181     , p1_a7 OUT NOCOPY  VARCHAR2
182     , p1_a8 OUT NOCOPY  VARCHAR2
183     , p1_a9 OUT NOCOPY  VARCHAR2
184     , p1_a10 OUT NOCOPY  VARCHAR2
185     , p1_a11 OUT NOCOPY  VARCHAR2
186     , p1_a12 OUT NOCOPY  VARCHAR2
187     , p1_a13 OUT NOCOPY  VARCHAR2
188     , p1_a14 OUT NOCOPY  VARCHAR2
189     , p1_a15 OUT NOCOPY  NUMBER
190     , p1_a16 OUT NOCOPY  VARCHAR2
191     , p1_a17 OUT NOCOPY  VARCHAR2
192     , p1_a18 OUT NOCOPY  VARCHAR2
193     , p1_a19 OUT NOCOPY  VARCHAR2
194     , p0_a0  NUMBER := 0-1962.0724
195     , p0_a1  DATE := fnd_api.g_miss_date
196     , p0_a2  NUMBER := 0-1962.0724
197     , p0_a3  DATE := fnd_api.g_miss_date
198     , p0_a4  NUMBER := 0-1962.0724
199     , p0_a5  NUMBER := 0-1962.0724
200     , p0_a6  NUMBER := 0-1962.0724
201     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
202     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
203     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
204     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
205     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
206     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
207     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
208     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
209     , p0_a15  NUMBER := 0-1962.0724
210     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
211     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
212     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
213     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
214   );
215 end ams_listsourcetype_pvt_w;