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

Source


1 package jtf_loc_areas_pvt_w AUTHID CURRENT_USER as
2   /* $Header: jtfwloas.pls 120.2 2005/08/18 22:55:57 stopiwal ship $ */
3   procedure create_loc_area(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 /* file.sql.39 change */  VARCHAR2
8     , x_msg_count OUT NOCOPY /* file.sql.39 change */  NUMBER
9     , x_msg_data OUT NOCOPY /* file.sql.39 change */  VARCHAR2
10     , x_loc_area_id OUT NOCOPY /* file.sql.39 change */  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  NUMBER := 0-1962.0724
19     , p7_a8  NUMBER := 0-1962.0724
20     , p7_a9  NUMBER := 0-1962.0724
21     , p7_a10  DATE := fnd_api.g_miss_date
22     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
23     , p7_a12  DATE := fnd_api.g_miss_date
24     , p7_a13  DATE := fnd_api.g_miss_date
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  NUMBER := 0-1962.0724
29     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
30     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
31   );
32   procedure update_loc_area(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 /* file.sql.39 change */  VARCHAR2
37     , x_msg_count OUT NOCOPY /* file.sql.39 change */  NUMBER
38     , x_msg_data OUT NOCOPY /* file.sql.39 change */  VARCHAR2
39     , p_remove_flag  VARCHAR2
40     , p7_a0  NUMBER := 0-1962.0724
41     , p7_a1  DATE := fnd_api.g_miss_date
42     , p7_a2  NUMBER := 0-1962.0724
43     , p7_a3  DATE := fnd_api.g_miss_date
44     , p7_a4  NUMBER := 0-1962.0724
45     , p7_a5  NUMBER := 0-1962.0724
46     , p7_a6  NUMBER := 0-1962.0724
47     , p7_a7  NUMBER := 0-1962.0724
48     , p7_a8  NUMBER := 0-1962.0724
49     , p7_a9  NUMBER := 0-1962.0724
50     , p7_a10  DATE := fnd_api.g_miss_date
51     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
52     , p7_a12  DATE := fnd_api.g_miss_date
53     , p7_a13  DATE := fnd_api.g_miss_date
54     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
55     , p7_a15  NUMBER := 0-1962.0724
56     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
57     , p7_a17  NUMBER := 0-1962.0724
58     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
59     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
60   );
61   procedure validate_loc_area(p_api_version  NUMBER
62     , p_init_msg_list  VARCHAR2
63     , p_validation_level  NUMBER
64     , x_return_status OUT NOCOPY /* file.sql.39 change */  VARCHAR2
65     , x_msg_count OUT NOCOPY /* file.sql.39 change */  NUMBER
66     , x_msg_data OUT NOCOPY /* file.sql.39 change */  VARCHAR2
67     , p6_a0  NUMBER := 0-1962.0724
68     , p6_a1  DATE := fnd_api.g_miss_date
69     , p6_a2  NUMBER := 0-1962.0724
70     , p6_a3  DATE := fnd_api.g_miss_date
71     , p6_a4  NUMBER := 0-1962.0724
72     , p6_a5  NUMBER := 0-1962.0724
73     , p6_a6  NUMBER := 0-1962.0724
74     , p6_a7  NUMBER := 0-1962.0724
75     , p6_a8  NUMBER := 0-1962.0724
76     , p6_a9  NUMBER := 0-1962.0724
77     , p6_a10  DATE := fnd_api.g_miss_date
78     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
79     , p6_a12  DATE := fnd_api.g_miss_date
80     , p6_a13  DATE := fnd_api.g_miss_date
81     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
82     , p6_a15  NUMBER := 0-1962.0724
83     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
84     , p6_a17  NUMBER := 0-1962.0724
85     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
86     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
87   );
88   procedure check_items(p_validation_mode  VARCHAR2
89     , x_return_status OUT NOCOPY /* file.sql.39 change */  VARCHAR2
90     , p2_a0  NUMBER := 0-1962.0724
91     , p2_a1  DATE := fnd_api.g_miss_date
92     , p2_a2  NUMBER := 0-1962.0724
93     , p2_a3  DATE := fnd_api.g_miss_date
94     , p2_a4  NUMBER := 0-1962.0724
95     , p2_a5  NUMBER := 0-1962.0724
96     , p2_a6  NUMBER := 0-1962.0724
97     , p2_a7  NUMBER := 0-1962.0724
98     , p2_a8  NUMBER := 0-1962.0724
99     , p2_a9  NUMBER := 0-1962.0724
100     , p2_a10  DATE := fnd_api.g_miss_date
101     , p2_a11  VARCHAR2 := fnd_api.g_miss_char
102     , p2_a12  DATE := fnd_api.g_miss_date
103     , p2_a13  DATE := fnd_api.g_miss_date
104     , p2_a14  VARCHAR2 := fnd_api.g_miss_char
105     , p2_a15  NUMBER := 0-1962.0724
106     , p2_a16  VARCHAR2 := fnd_api.g_miss_char
107     , p2_a17  NUMBER := 0-1962.0724
108     , p2_a18  VARCHAR2 := fnd_api.g_miss_char
109     , p2_a19  VARCHAR2 := fnd_api.g_miss_char
110   );
111   procedure check_loc_area_req_items(p_validation_mode  VARCHAR2
112     , x_return_status OUT NOCOPY /* file.sql.39 change */  VARCHAR2
113     , p1_a0  NUMBER := 0-1962.0724
114     , p1_a1  DATE := fnd_api.g_miss_date
115     , p1_a2  NUMBER := 0-1962.0724
116     , p1_a3  DATE := fnd_api.g_miss_date
117     , p1_a4  NUMBER := 0-1962.0724
118     , p1_a5  NUMBER := 0-1962.0724
119     , p1_a6  NUMBER := 0-1962.0724
120     , p1_a7  NUMBER := 0-1962.0724
121     , p1_a8  NUMBER := 0-1962.0724
122     , p1_a9  NUMBER := 0-1962.0724
123     , p1_a10  DATE := fnd_api.g_miss_date
124     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
125     , p1_a12  DATE := fnd_api.g_miss_date
126     , p1_a13  DATE := fnd_api.g_miss_date
127     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
128     , p1_a15  NUMBER := 0-1962.0724
129     , p1_a16  VARCHAR2 := fnd_api.g_miss_char
130     , p1_a17  NUMBER := 0-1962.0724
131     , p1_a18  VARCHAR2 := fnd_api.g_miss_char
132     , p1_a19  VARCHAR2 := fnd_api.g_miss_char
133   );
134   procedure check_loc_area_uk_items(p_validation_mode  VARCHAR2
135     , x_return_status OUT NOCOPY /* file.sql.39 change */  VARCHAR2
136     , p1_a0  NUMBER := 0-1962.0724
137     , p1_a1  DATE := fnd_api.g_miss_date
138     , p1_a2  NUMBER := 0-1962.0724
139     , p1_a3  DATE := fnd_api.g_miss_date
140     , p1_a4  NUMBER := 0-1962.0724
141     , p1_a5  NUMBER := 0-1962.0724
142     , p1_a6  NUMBER := 0-1962.0724
143     , p1_a7  NUMBER := 0-1962.0724
144     , p1_a8  NUMBER := 0-1962.0724
145     , p1_a9  NUMBER := 0-1962.0724
146     , p1_a10  DATE := fnd_api.g_miss_date
147     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
148     , p1_a12  DATE := fnd_api.g_miss_date
149     , p1_a13  DATE := fnd_api.g_miss_date
150     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
151     , p1_a15  NUMBER := 0-1962.0724
152     , p1_a16  VARCHAR2 := fnd_api.g_miss_char
153     , p1_a17  NUMBER := 0-1962.0724
154     , p1_a18  VARCHAR2 := fnd_api.g_miss_char
155     , p1_a19  VARCHAR2 := fnd_api.g_miss_char
156   );
157   procedure check_loc_area_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */  VARCHAR2
158     , p0_a0  NUMBER := 0-1962.0724
159     , p0_a1  DATE := fnd_api.g_miss_date
160     , p0_a2  NUMBER := 0-1962.0724
161     , p0_a3  DATE := fnd_api.g_miss_date
162     , p0_a4  NUMBER := 0-1962.0724
163     , p0_a5  NUMBER := 0-1962.0724
164     , p0_a6  NUMBER := 0-1962.0724
165     , p0_a7  NUMBER := 0-1962.0724
166     , p0_a8  NUMBER := 0-1962.0724
167     , p0_a9  NUMBER := 0-1962.0724
168     , p0_a10  DATE := fnd_api.g_miss_date
169     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
170     , p0_a12  DATE := fnd_api.g_miss_date
171     , p0_a13  DATE := fnd_api.g_miss_date
172     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
173     , p0_a15  NUMBER := 0-1962.0724
174     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
175     , p0_a17  NUMBER := 0-1962.0724
176     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
177     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
178   );
179   procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */  VARCHAR2
180     , p0_a0  NUMBER := 0-1962.0724
181     , p0_a1  DATE := fnd_api.g_miss_date
182     , p0_a2  NUMBER := 0-1962.0724
183     , p0_a3  DATE := fnd_api.g_miss_date
184     , p0_a4  NUMBER := 0-1962.0724
185     , p0_a5  NUMBER := 0-1962.0724
186     , p0_a6  NUMBER := 0-1962.0724
187     , p0_a7  NUMBER := 0-1962.0724
188     , p0_a8  NUMBER := 0-1962.0724
189     , p0_a9  NUMBER := 0-1962.0724
190     , p0_a10  DATE := fnd_api.g_miss_date
191     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
192     , p0_a12  DATE := fnd_api.g_miss_date
193     , p0_a13  DATE := fnd_api.g_miss_date
194     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
195     , p0_a15  NUMBER := 0-1962.0724
196     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
197     , p0_a17  NUMBER := 0-1962.0724
198     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
199     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
200     , p1_a0  NUMBER := 0-1962.0724
201     , p1_a1  DATE := fnd_api.g_miss_date
202     , p1_a2  NUMBER := 0-1962.0724
203     , p1_a3  DATE := fnd_api.g_miss_date
204     , p1_a4  NUMBER := 0-1962.0724
205     , p1_a5  NUMBER := 0-1962.0724
206     , p1_a6  NUMBER := 0-1962.0724
207     , p1_a7  NUMBER := 0-1962.0724
208     , p1_a8  NUMBER := 0-1962.0724
209     , p1_a9  NUMBER := 0-1962.0724
210     , p1_a10  DATE := fnd_api.g_miss_date
211     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
212     , p1_a12  DATE := fnd_api.g_miss_date
213     , p1_a13  DATE := fnd_api.g_miss_date
214     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
215     , p1_a15  NUMBER := 0-1962.0724
216     , p1_a16  VARCHAR2 := fnd_api.g_miss_char
217     , p1_a17  NUMBER := 0-1962.0724
218     , p1_a18  VARCHAR2 := fnd_api.g_miss_char
219     , p1_a19  VARCHAR2 := fnd_api.g_miss_char
220   );
221   procedure complete_loc_area_rec(p1_a0 OUT NOCOPY /* file.sql.39 change */  NUMBER
222     , p1_a1 OUT NOCOPY /* file.sql.39 change */  DATE
223     , p1_a2 OUT NOCOPY /* file.sql.39 change */  NUMBER
224     , p1_a3 OUT NOCOPY /* file.sql.39 change */  DATE
225     , p1_a4 OUT NOCOPY /* file.sql.39 change */  NUMBER
226     , p1_a5 OUT NOCOPY /* file.sql.39 change */  NUMBER
227     , p1_a6 OUT NOCOPY /* file.sql.39 change */  NUMBER
228     , p1_a7 OUT NOCOPY /* file.sql.39 change */  NUMBER
229     , p1_a8 OUT NOCOPY /* file.sql.39 change */  NUMBER
230     , p1_a9 OUT NOCOPY /* file.sql.39 change */  NUMBER
231     , p1_a10 OUT NOCOPY /* file.sql.39 change */  DATE
232     , p1_a11 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
233     , p1_a12 OUT NOCOPY /* file.sql.39 change */  DATE
234     , p1_a13 OUT NOCOPY /* file.sql.39 change */  DATE
235     , p1_a14 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
236     , p1_a15 OUT NOCOPY /* file.sql.39 change */  NUMBER
237     , p1_a16 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
238     , p1_a17 OUT NOCOPY /* file.sql.39 change */  NUMBER
239     , p1_a18 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
240     , p1_a19 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
241     , p0_a0  NUMBER := 0-1962.0724
242     , p0_a1  DATE := fnd_api.g_miss_date
243     , p0_a2  NUMBER := 0-1962.0724
244     , p0_a3  DATE := fnd_api.g_miss_date
245     , p0_a4  NUMBER := 0-1962.0724
246     , p0_a5  NUMBER := 0-1962.0724
247     , p0_a6  NUMBER := 0-1962.0724
248     , p0_a7  NUMBER := 0-1962.0724
249     , p0_a8  NUMBER := 0-1962.0724
250     , p0_a9  NUMBER := 0-1962.0724
251     , p0_a10  DATE := fnd_api.g_miss_date
252     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
253     , p0_a12  DATE := fnd_api.g_miss_date
254     , p0_a13  DATE := fnd_api.g_miss_date
255     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
256     , p0_a15  NUMBER := 0-1962.0724
257     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
258     , p0_a17  NUMBER := 0-1962.0724
259     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
260     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
261   );
262   procedure init_rec(p0_a0 OUT NOCOPY /* file.sql.39 change */  NUMBER
263     , p0_a1 OUT NOCOPY /* file.sql.39 change */  DATE
264     , p0_a2 OUT NOCOPY /* file.sql.39 change */  NUMBER
265     , p0_a3 OUT NOCOPY /* file.sql.39 change */  DATE
266     , p0_a4 OUT NOCOPY /* file.sql.39 change */  NUMBER
267     , p0_a5 OUT NOCOPY /* file.sql.39 change */  NUMBER
268     , p0_a6 OUT NOCOPY /* file.sql.39 change */  NUMBER
269     , p0_a7 OUT NOCOPY /* file.sql.39 change */  NUMBER
270     , p0_a8 OUT NOCOPY /* file.sql.39 change */  NUMBER
271     , p0_a9 OUT NOCOPY /* file.sql.39 change */  NUMBER
272     , p0_a10 OUT NOCOPY /* file.sql.39 change */  DATE
273     , p0_a11 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
274     , p0_a12 OUT NOCOPY /* file.sql.39 change */  DATE
275     , p0_a13 OUT NOCOPY /* file.sql.39 change */  DATE
276     , p0_a14 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
277     , p0_a15 OUT NOCOPY /* file.sql.39 change */  NUMBER
278     , p0_a16 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
279     , p0_a17 OUT NOCOPY /* file.sql.39 change */  NUMBER
280     , p0_a18 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
281     , p0_a19 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
282   );
283 end jtf_loc_areas_pvt_w;