APPS.JTF_LOC_AREAS_PVT_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure create_loc_area(p_api_version NUMBER

Line 31: , p7_a1 DATE := fnd_api.g_miss_date

27: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
28: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29: , x_loc_area_id OUT NOCOPY /* file.sql.39 change */ NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724

Line 33: , p7_a3 DATE := fnd_api.g_miss_date

29: , x_loc_area_id OUT NOCOPY /* file.sql.39 change */ NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724

Line 40: , p7_a10 DATE := fnd_api.g_miss_date

36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724

Line 42: , p7_a12 DATE := fnd_api.g_miss_date

38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 43: , p7_a13 DATE := fnd_api.g_miss_date

39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 NUMBER := 0-1962.0724

Line 44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 NUMBER := 0-1962.0724
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 NUMBER := 0-1962.0724
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: )

Line 48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 NUMBER := 0-1962.0724
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: )
51: as
52: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 NUMBER := 0-1962.0724
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: )
51: as
52: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
53: ddindx binary_integer; indx binary_integer;

Line 117: , p7_a1 DATE := fnd_api.g_miss_date

113: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
114: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115: , p_remove_flag VARCHAR2
116: , p7_a0 NUMBER := 0-1962.0724
117: , p7_a1 DATE := fnd_api.g_miss_date
118: , p7_a2 NUMBER := 0-1962.0724
119: , p7_a3 DATE := fnd_api.g_miss_date
120: , p7_a4 NUMBER := 0-1962.0724
121: , p7_a5 NUMBER := 0-1962.0724

Line 119: , p7_a3 DATE := fnd_api.g_miss_date

115: , p_remove_flag VARCHAR2
116: , p7_a0 NUMBER := 0-1962.0724
117: , p7_a1 DATE := fnd_api.g_miss_date
118: , p7_a2 NUMBER := 0-1962.0724
119: , p7_a3 DATE := fnd_api.g_miss_date
120: , p7_a4 NUMBER := 0-1962.0724
121: , p7_a5 NUMBER := 0-1962.0724
122: , p7_a6 NUMBER := 0-1962.0724
123: , p7_a7 NUMBER := 0-1962.0724

Line 126: , p7_a10 DATE := fnd_api.g_miss_date

122: , p7_a6 NUMBER := 0-1962.0724
123: , p7_a7 NUMBER := 0-1962.0724
124: , p7_a8 NUMBER := 0-1962.0724
125: , p7_a9 NUMBER := 0-1962.0724
126: , p7_a10 DATE := fnd_api.g_miss_date
127: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a12 DATE := fnd_api.g_miss_date
129: , p7_a13 DATE := fnd_api.g_miss_date
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 127: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

123: , p7_a7 NUMBER := 0-1962.0724
124: , p7_a8 NUMBER := 0-1962.0724
125: , p7_a9 NUMBER := 0-1962.0724
126: , p7_a10 DATE := fnd_api.g_miss_date
127: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a12 DATE := fnd_api.g_miss_date
129: , p7_a13 DATE := fnd_api.g_miss_date
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 NUMBER := 0-1962.0724

Line 128: , p7_a12 DATE := fnd_api.g_miss_date

124: , p7_a8 NUMBER := 0-1962.0724
125: , p7_a9 NUMBER := 0-1962.0724
126: , p7_a10 DATE := fnd_api.g_miss_date
127: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a12 DATE := fnd_api.g_miss_date
129: , p7_a13 DATE := fnd_api.g_miss_date
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 NUMBER := 0-1962.0724
132: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 129: , p7_a13 DATE := fnd_api.g_miss_date

125: , p7_a9 NUMBER := 0-1962.0724
126: , p7_a10 DATE := fnd_api.g_miss_date
127: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a12 DATE := fnd_api.g_miss_date
129: , p7_a13 DATE := fnd_api.g_miss_date
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 NUMBER := 0-1962.0724
132: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a17 NUMBER := 0-1962.0724

Line 130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

126: , p7_a10 DATE := fnd_api.g_miss_date
127: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a12 DATE := fnd_api.g_miss_date
129: , p7_a13 DATE := fnd_api.g_miss_date
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 NUMBER := 0-1962.0724
132: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a17 NUMBER := 0-1962.0724
134: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 132: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

128: , p7_a12 DATE := fnd_api.g_miss_date
129: , p7_a13 DATE := fnd_api.g_miss_date
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 NUMBER := 0-1962.0724
132: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a17 NUMBER := 0-1962.0724
134: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
136: )

Line 134: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 NUMBER := 0-1962.0724
132: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a17 NUMBER := 0-1962.0724
134: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
136: )
137: as
138: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 135: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

131: , p7_a15 NUMBER := 0-1962.0724
132: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a17 NUMBER := 0-1962.0724
134: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
136: )
137: as
138: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
139: ddindx binary_integer; indx binary_integer;

Line 201: , p6_a1 DATE := fnd_api.g_miss_date

197: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
198: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
199: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
200: , p6_a0 NUMBER := 0-1962.0724
201: , p6_a1 DATE := fnd_api.g_miss_date
202: , p6_a2 NUMBER := 0-1962.0724
203: , p6_a3 DATE := fnd_api.g_miss_date
204: , p6_a4 NUMBER := 0-1962.0724
205: , p6_a5 NUMBER := 0-1962.0724

Line 203: , p6_a3 DATE := fnd_api.g_miss_date

199: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
200: , p6_a0 NUMBER := 0-1962.0724
201: , p6_a1 DATE := fnd_api.g_miss_date
202: , p6_a2 NUMBER := 0-1962.0724
203: , p6_a3 DATE := fnd_api.g_miss_date
204: , p6_a4 NUMBER := 0-1962.0724
205: , p6_a5 NUMBER := 0-1962.0724
206: , p6_a6 NUMBER := 0-1962.0724
207: , p6_a7 NUMBER := 0-1962.0724

Line 210: , p6_a10 DATE := fnd_api.g_miss_date

206: , p6_a6 NUMBER := 0-1962.0724
207: , p6_a7 NUMBER := 0-1962.0724
208: , p6_a8 NUMBER := 0-1962.0724
209: , p6_a9 NUMBER := 0-1962.0724
210: , p6_a10 DATE := fnd_api.g_miss_date
211: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a12 DATE := fnd_api.g_miss_date
213: , p6_a13 DATE := fnd_api.g_miss_date
214: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

Line 211: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

207: , p6_a7 NUMBER := 0-1962.0724
208: , p6_a8 NUMBER := 0-1962.0724
209: , p6_a9 NUMBER := 0-1962.0724
210: , p6_a10 DATE := fnd_api.g_miss_date
211: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a12 DATE := fnd_api.g_miss_date
213: , p6_a13 DATE := fnd_api.g_miss_date
214: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a15 NUMBER := 0-1962.0724

Line 212: , p6_a12 DATE := fnd_api.g_miss_date

208: , p6_a8 NUMBER := 0-1962.0724
209: , p6_a9 NUMBER := 0-1962.0724
210: , p6_a10 DATE := fnd_api.g_miss_date
211: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a12 DATE := fnd_api.g_miss_date
213: , p6_a13 DATE := fnd_api.g_miss_date
214: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a15 NUMBER := 0-1962.0724
216: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

Line 213: , p6_a13 DATE := fnd_api.g_miss_date

209: , p6_a9 NUMBER := 0-1962.0724
210: , p6_a10 DATE := fnd_api.g_miss_date
211: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a12 DATE := fnd_api.g_miss_date
213: , p6_a13 DATE := fnd_api.g_miss_date
214: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a15 NUMBER := 0-1962.0724
216: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a17 NUMBER := 0-1962.0724

Line 214: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

210: , p6_a10 DATE := fnd_api.g_miss_date
211: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a12 DATE := fnd_api.g_miss_date
213: , p6_a13 DATE := fnd_api.g_miss_date
214: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a15 NUMBER := 0-1962.0724
216: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a17 NUMBER := 0-1962.0724
218: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

Line 216: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

212: , p6_a12 DATE := fnd_api.g_miss_date
213: , p6_a13 DATE := fnd_api.g_miss_date
214: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a15 NUMBER := 0-1962.0724
216: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a17 NUMBER := 0-1962.0724
218: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
220: )

Line 218: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

214: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a15 NUMBER := 0-1962.0724
216: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a17 NUMBER := 0-1962.0724
218: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
220: )
221: as
222: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 219: , p6_a19 VARCHAR2 := fnd_api.g_miss_char

215: , p6_a15 NUMBER := 0-1962.0724
216: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a17 NUMBER := 0-1962.0724
218: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
220: )
221: as
222: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
223: ddindx binary_integer; indx binary_integer;

Line 275: , p2_a1 DATE := fnd_api.g_miss_date

271:
272: procedure check_items(p_validation_mode VARCHAR2
273: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
274: , p2_a0 NUMBER := 0-1962.0724
275: , p2_a1 DATE := fnd_api.g_miss_date
276: , p2_a2 NUMBER := 0-1962.0724
277: , p2_a3 DATE := fnd_api.g_miss_date
278: , p2_a4 NUMBER := 0-1962.0724
279: , p2_a5 NUMBER := 0-1962.0724

Line 277: , p2_a3 DATE := fnd_api.g_miss_date

273: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
274: , p2_a0 NUMBER := 0-1962.0724
275: , p2_a1 DATE := fnd_api.g_miss_date
276: , p2_a2 NUMBER := 0-1962.0724
277: , p2_a3 DATE := fnd_api.g_miss_date
278: , p2_a4 NUMBER := 0-1962.0724
279: , p2_a5 NUMBER := 0-1962.0724
280: , p2_a6 NUMBER := 0-1962.0724
281: , p2_a7 NUMBER := 0-1962.0724

Line 284: , p2_a10 DATE := fnd_api.g_miss_date

280: , p2_a6 NUMBER := 0-1962.0724
281: , p2_a7 NUMBER := 0-1962.0724
282: , p2_a8 NUMBER := 0-1962.0724
283: , p2_a9 NUMBER := 0-1962.0724
284: , p2_a10 DATE := fnd_api.g_miss_date
285: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a12 DATE := fnd_api.g_miss_date
287: , p2_a13 DATE := fnd_api.g_miss_date
288: , p2_a14 VARCHAR2 := fnd_api.g_miss_char

Line 285: , p2_a11 VARCHAR2 := fnd_api.g_miss_char

281: , p2_a7 NUMBER := 0-1962.0724
282: , p2_a8 NUMBER := 0-1962.0724
283: , p2_a9 NUMBER := 0-1962.0724
284: , p2_a10 DATE := fnd_api.g_miss_date
285: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a12 DATE := fnd_api.g_miss_date
287: , p2_a13 DATE := fnd_api.g_miss_date
288: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a15 NUMBER := 0-1962.0724

Line 286: , p2_a12 DATE := fnd_api.g_miss_date

282: , p2_a8 NUMBER := 0-1962.0724
283: , p2_a9 NUMBER := 0-1962.0724
284: , p2_a10 DATE := fnd_api.g_miss_date
285: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a12 DATE := fnd_api.g_miss_date
287: , p2_a13 DATE := fnd_api.g_miss_date
288: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a15 NUMBER := 0-1962.0724
290: , p2_a16 VARCHAR2 := fnd_api.g_miss_char

Line 287: , p2_a13 DATE := fnd_api.g_miss_date

283: , p2_a9 NUMBER := 0-1962.0724
284: , p2_a10 DATE := fnd_api.g_miss_date
285: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a12 DATE := fnd_api.g_miss_date
287: , p2_a13 DATE := fnd_api.g_miss_date
288: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a15 NUMBER := 0-1962.0724
290: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a17 NUMBER := 0-1962.0724

Line 288: , p2_a14 VARCHAR2 := fnd_api.g_miss_char

284: , p2_a10 DATE := fnd_api.g_miss_date
285: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a12 DATE := fnd_api.g_miss_date
287: , p2_a13 DATE := fnd_api.g_miss_date
288: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a15 NUMBER := 0-1962.0724
290: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a17 NUMBER := 0-1962.0724
292: , p2_a18 VARCHAR2 := fnd_api.g_miss_char

Line 290: , p2_a16 VARCHAR2 := fnd_api.g_miss_char

286: , p2_a12 DATE := fnd_api.g_miss_date
287: , p2_a13 DATE := fnd_api.g_miss_date
288: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a15 NUMBER := 0-1962.0724
290: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a17 NUMBER := 0-1962.0724
292: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
294: )

Line 292: , p2_a18 VARCHAR2 := fnd_api.g_miss_char

288: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a15 NUMBER := 0-1962.0724
290: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a17 NUMBER := 0-1962.0724
292: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
294: )
295: as
296: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 293: , p2_a19 VARCHAR2 := fnd_api.g_miss_char

289: , p2_a15 NUMBER := 0-1962.0724
290: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a17 NUMBER := 0-1962.0724
292: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
294: )
295: as
296: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
297: ddindx binary_integer; indx binary_integer;

Line 337: , p1_a1 DATE := fnd_api.g_miss_date

333:
334: procedure check_loc_area_req_items(p_validation_mode VARCHAR2
335: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
336: , p1_a0 NUMBER := 0-1962.0724
337: , p1_a1 DATE := fnd_api.g_miss_date
338: , p1_a2 NUMBER := 0-1962.0724
339: , p1_a3 DATE := fnd_api.g_miss_date
340: , p1_a4 NUMBER := 0-1962.0724
341: , p1_a5 NUMBER := 0-1962.0724

Line 339: , p1_a3 DATE := fnd_api.g_miss_date

335: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
336: , p1_a0 NUMBER := 0-1962.0724
337: , p1_a1 DATE := fnd_api.g_miss_date
338: , p1_a2 NUMBER := 0-1962.0724
339: , p1_a3 DATE := fnd_api.g_miss_date
340: , p1_a4 NUMBER := 0-1962.0724
341: , p1_a5 NUMBER := 0-1962.0724
342: , p1_a6 NUMBER := 0-1962.0724
343: , p1_a7 NUMBER := 0-1962.0724

Line 346: , p1_a10 DATE := fnd_api.g_miss_date

342: , p1_a6 NUMBER := 0-1962.0724
343: , p1_a7 NUMBER := 0-1962.0724
344: , p1_a8 NUMBER := 0-1962.0724
345: , p1_a9 NUMBER := 0-1962.0724
346: , p1_a10 DATE := fnd_api.g_miss_date
347: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
348: , p1_a12 DATE := fnd_api.g_miss_date
349: , p1_a13 DATE := fnd_api.g_miss_date
350: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 347: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

343: , p1_a7 NUMBER := 0-1962.0724
344: , p1_a8 NUMBER := 0-1962.0724
345: , p1_a9 NUMBER := 0-1962.0724
346: , p1_a10 DATE := fnd_api.g_miss_date
347: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
348: , p1_a12 DATE := fnd_api.g_miss_date
349: , p1_a13 DATE := fnd_api.g_miss_date
350: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
351: , p1_a15 NUMBER := 0-1962.0724

Line 348: , p1_a12 DATE := fnd_api.g_miss_date

344: , p1_a8 NUMBER := 0-1962.0724
345: , p1_a9 NUMBER := 0-1962.0724
346: , p1_a10 DATE := fnd_api.g_miss_date
347: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
348: , p1_a12 DATE := fnd_api.g_miss_date
349: , p1_a13 DATE := fnd_api.g_miss_date
350: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
351: , p1_a15 NUMBER := 0-1962.0724
352: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 349: , p1_a13 DATE := fnd_api.g_miss_date

345: , p1_a9 NUMBER := 0-1962.0724
346: , p1_a10 DATE := fnd_api.g_miss_date
347: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
348: , p1_a12 DATE := fnd_api.g_miss_date
349: , p1_a13 DATE := fnd_api.g_miss_date
350: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
351: , p1_a15 NUMBER := 0-1962.0724
352: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p1_a17 NUMBER := 0-1962.0724

Line 350: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

346: , p1_a10 DATE := fnd_api.g_miss_date
347: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
348: , p1_a12 DATE := fnd_api.g_miss_date
349: , p1_a13 DATE := fnd_api.g_miss_date
350: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
351: , p1_a15 NUMBER := 0-1962.0724
352: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p1_a17 NUMBER := 0-1962.0724
354: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 352: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

348: , p1_a12 DATE := fnd_api.g_miss_date
349: , p1_a13 DATE := fnd_api.g_miss_date
350: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
351: , p1_a15 NUMBER := 0-1962.0724
352: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p1_a17 NUMBER := 0-1962.0724
354: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
356: )

Line 354: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

350: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
351: , p1_a15 NUMBER := 0-1962.0724
352: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p1_a17 NUMBER := 0-1962.0724
354: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
356: )
357: as
358: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 355: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

351: , p1_a15 NUMBER := 0-1962.0724
352: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p1_a17 NUMBER := 0-1962.0724
354: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
356: )
357: as
358: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
359: ddindx binary_integer; indx binary_integer;

Line 399: , p1_a1 DATE := fnd_api.g_miss_date

395:
396: procedure check_loc_area_uk_items(p_validation_mode VARCHAR2
397: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
398: , p1_a0 NUMBER := 0-1962.0724
399: , p1_a1 DATE := fnd_api.g_miss_date
400: , p1_a2 NUMBER := 0-1962.0724
401: , p1_a3 DATE := fnd_api.g_miss_date
402: , p1_a4 NUMBER := 0-1962.0724
403: , p1_a5 NUMBER := 0-1962.0724

Line 401: , p1_a3 DATE := fnd_api.g_miss_date

397: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
398: , p1_a0 NUMBER := 0-1962.0724
399: , p1_a1 DATE := fnd_api.g_miss_date
400: , p1_a2 NUMBER := 0-1962.0724
401: , p1_a3 DATE := fnd_api.g_miss_date
402: , p1_a4 NUMBER := 0-1962.0724
403: , p1_a5 NUMBER := 0-1962.0724
404: , p1_a6 NUMBER := 0-1962.0724
405: , p1_a7 NUMBER := 0-1962.0724

Line 408: , p1_a10 DATE := fnd_api.g_miss_date

404: , p1_a6 NUMBER := 0-1962.0724
405: , p1_a7 NUMBER := 0-1962.0724
406: , p1_a8 NUMBER := 0-1962.0724
407: , p1_a9 NUMBER := 0-1962.0724
408: , p1_a10 DATE := fnd_api.g_miss_date
409: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a12 DATE := fnd_api.g_miss_date
411: , p1_a13 DATE := fnd_api.g_miss_date
412: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 409: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

405: , p1_a7 NUMBER := 0-1962.0724
406: , p1_a8 NUMBER := 0-1962.0724
407: , p1_a9 NUMBER := 0-1962.0724
408: , p1_a10 DATE := fnd_api.g_miss_date
409: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a12 DATE := fnd_api.g_miss_date
411: , p1_a13 DATE := fnd_api.g_miss_date
412: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a15 NUMBER := 0-1962.0724

Line 410: , p1_a12 DATE := fnd_api.g_miss_date

406: , p1_a8 NUMBER := 0-1962.0724
407: , p1_a9 NUMBER := 0-1962.0724
408: , p1_a10 DATE := fnd_api.g_miss_date
409: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a12 DATE := fnd_api.g_miss_date
411: , p1_a13 DATE := fnd_api.g_miss_date
412: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a15 NUMBER := 0-1962.0724
414: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 411: , p1_a13 DATE := fnd_api.g_miss_date

407: , p1_a9 NUMBER := 0-1962.0724
408: , p1_a10 DATE := fnd_api.g_miss_date
409: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a12 DATE := fnd_api.g_miss_date
411: , p1_a13 DATE := fnd_api.g_miss_date
412: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a15 NUMBER := 0-1962.0724
414: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
415: , p1_a17 NUMBER := 0-1962.0724

Line 412: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

408: , p1_a10 DATE := fnd_api.g_miss_date
409: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a12 DATE := fnd_api.g_miss_date
411: , p1_a13 DATE := fnd_api.g_miss_date
412: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a15 NUMBER := 0-1962.0724
414: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
415: , p1_a17 NUMBER := 0-1962.0724
416: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 414: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

410: , p1_a12 DATE := fnd_api.g_miss_date
411: , p1_a13 DATE := fnd_api.g_miss_date
412: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a15 NUMBER := 0-1962.0724
414: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
415: , p1_a17 NUMBER := 0-1962.0724
416: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
418: )

Line 416: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

412: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a15 NUMBER := 0-1962.0724
414: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
415: , p1_a17 NUMBER := 0-1962.0724
416: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
418: )
419: as
420: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 417: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

413: , p1_a15 NUMBER := 0-1962.0724
414: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
415: , p1_a17 NUMBER := 0-1962.0724
416: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
418: )
419: as
420: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
421: ddindx binary_integer; indx binary_integer;

Line 460: , p0_a1 DATE := fnd_api.g_miss_date

456: end;
457:
458: procedure check_loc_area_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
459: , p0_a0 NUMBER := 0-1962.0724
460: , p0_a1 DATE := fnd_api.g_miss_date
461: , p0_a2 NUMBER := 0-1962.0724
462: , p0_a3 DATE := fnd_api.g_miss_date
463: , p0_a4 NUMBER := 0-1962.0724
464: , p0_a5 NUMBER := 0-1962.0724

Line 462: , p0_a3 DATE := fnd_api.g_miss_date

458: procedure check_loc_area_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
459: , p0_a0 NUMBER := 0-1962.0724
460: , p0_a1 DATE := fnd_api.g_miss_date
461: , p0_a2 NUMBER := 0-1962.0724
462: , p0_a3 DATE := fnd_api.g_miss_date
463: , p0_a4 NUMBER := 0-1962.0724
464: , p0_a5 NUMBER := 0-1962.0724
465: , p0_a6 NUMBER := 0-1962.0724
466: , p0_a7 NUMBER := 0-1962.0724

Line 469: , p0_a10 DATE := fnd_api.g_miss_date

465: , p0_a6 NUMBER := 0-1962.0724
466: , p0_a7 NUMBER := 0-1962.0724
467: , p0_a8 NUMBER := 0-1962.0724
468: , p0_a9 NUMBER := 0-1962.0724
469: , p0_a10 DATE := fnd_api.g_miss_date
470: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a12 DATE := fnd_api.g_miss_date
472: , p0_a13 DATE := fnd_api.g_miss_date
473: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 470: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

466: , p0_a7 NUMBER := 0-1962.0724
467: , p0_a8 NUMBER := 0-1962.0724
468: , p0_a9 NUMBER := 0-1962.0724
469: , p0_a10 DATE := fnd_api.g_miss_date
470: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a12 DATE := fnd_api.g_miss_date
472: , p0_a13 DATE := fnd_api.g_miss_date
473: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a15 NUMBER := 0-1962.0724

Line 471: , p0_a12 DATE := fnd_api.g_miss_date

467: , p0_a8 NUMBER := 0-1962.0724
468: , p0_a9 NUMBER := 0-1962.0724
469: , p0_a10 DATE := fnd_api.g_miss_date
470: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a12 DATE := fnd_api.g_miss_date
472: , p0_a13 DATE := fnd_api.g_miss_date
473: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a15 NUMBER := 0-1962.0724
475: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 472: , p0_a13 DATE := fnd_api.g_miss_date

468: , p0_a9 NUMBER := 0-1962.0724
469: , p0_a10 DATE := fnd_api.g_miss_date
470: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a12 DATE := fnd_api.g_miss_date
472: , p0_a13 DATE := fnd_api.g_miss_date
473: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a15 NUMBER := 0-1962.0724
475: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a17 NUMBER := 0-1962.0724

Line 473: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

469: , p0_a10 DATE := fnd_api.g_miss_date
470: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a12 DATE := fnd_api.g_miss_date
472: , p0_a13 DATE := fnd_api.g_miss_date
473: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a15 NUMBER := 0-1962.0724
475: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a17 NUMBER := 0-1962.0724
477: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 475: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

471: , p0_a12 DATE := fnd_api.g_miss_date
472: , p0_a13 DATE := fnd_api.g_miss_date
473: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a15 NUMBER := 0-1962.0724
475: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a17 NUMBER := 0-1962.0724
477: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
479: )

Line 477: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

473: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a15 NUMBER := 0-1962.0724
475: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a17 NUMBER := 0-1962.0724
477: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
479: )
480: as
481: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 478: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

474: , p0_a15 NUMBER := 0-1962.0724
475: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a17 NUMBER := 0-1962.0724
477: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
479: )
480: as
481: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
482: ddindx binary_integer; indx binary_integer;

Line 518: , p0_a1 DATE := fnd_api.g_miss_date

514: end;
515:
516: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
517: , p0_a0 NUMBER := 0-1962.0724
518: , p0_a1 DATE := fnd_api.g_miss_date
519: , p0_a2 NUMBER := 0-1962.0724
520: , p0_a3 DATE := fnd_api.g_miss_date
521: , p0_a4 NUMBER := 0-1962.0724
522: , p0_a5 NUMBER := 0-1962.0724

Line 520: , p0_a3 DATE := fnd_api.g_miss_date

516: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
517: , p0_a0 NUMBER := 0-1962.0724
518: , p0_a1 DATE := fnd_api.g_miss_date
519: , p0_a2 NUMBER := 0-1962.0724
520: , p0_a3 DATE := fnd_api.g_miss_date
521: , p0_a4 NUMBER := 0-1962.0724
522: , p0_a5 NUMBER := 0-1962.0724
523: , p0_a6 NUMBER := 0-1962.0724
524: , p0_a7 NUMBER := 0-1962.0724

Line 527: , p0_a10 DATE := fnd_api.g_miss_date

523: , p0_a6 NUMBER := 0-1962.0724
524: , p0_a7 NUMBER := 0-1962.0724
525: , p0_a8 NUMBER := 0-1962.0724
526: , p0_a9 NUMBER := 0-1962.0724
527: , p0_a10 DATE := fnd_api.g_miss_date
528: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a12 DATE := fnd_api.g_miss_date
530: , p0_a13 DATE := fnd_api.g_miss_date
531: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 528: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

524: , p0_a7 NUMBER := 0-1962.0724
525: , p0_a8 NUMBER := 0-1962.0724
526: , p0_a9 NUMBER := 0-1962.0724
527: , p0_a10 DATE := fnd_api.g_miss_date
528: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a12 DATE := fnd_api.g_miss_date
530: , p0_a13 DATE := fnd_api.g_miss_date
531: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a15 NUMBER := 0-1962.0724

Line 529: , p0_a12 DATE := fnd_api.g_miss_date

525: , p0_a8 NUMBER := 0-1962.0724
526: , p0_a9 NUMBER := 0-1962.0724
527: , p0_a10 DATE := fnd_api.g_miss_date
528: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a12 DATE := fnd_api.g_miss_date
530: , p0_a13 DATE := fnd_api.g_miss_date
531: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a15 NUMBER := 0-1962.0724
533: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 530: , p0_a13 DATE := fnd_api.g_miss_date

526: , p0_a9 NUMBER := 0-1962.0724
527: , p0_a10 DATE := fnd_api.g_miss_date
528: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a12 DATE := fnd_api.g_miss_date
530: , p0_a13 DATE := fnd_api.g_miss_date
531: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a15 NUMBER := 0-1962.0724
533: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a17 NUMBER := 0-1962.0724

Line 531: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

527: , p0_a10 DATE := fnd_api.g_miss_date
528: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a12 DATE := fnd_api.g_miss_date
530: , p0_a13 DATE := fnd_api.g_miss_date
531: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a15 NUMBER := 0-1962.0724
533: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a17 NUMBER := 0-1962.0724
535: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 533: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

529: , p0_a12 DATE := fnd_api.g_miss_date
530: , p0_a13 DATE := fnd_api.g_miss_date
531: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a15 NUMBER := 0-1962.0724
533: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a17 NUMBER := 0-1962.0724
535: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
537: , p1_a0 NUMBER := 0-1962.0724

Line 535: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

531: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a15 NUMBER := 0-1962.0724
533: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a17 NUMBER := 0-1962.0724
535: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
537: , p1_a0 NUMBER := 0-1962.0724
538: , p1_a1 DATE := fnd_api.g_miss_date
539: , p1_a2 NUMBER := 0-1962.0724

Line 536: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

532: , p0_a15 NUMBER := 0-1962.0724
533: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a17 NUMBER := 0-1962.0724
535: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
537: , p1_a0 NUMBER := 0-1962.0724
538: , p1_a1 DATE := fnd_api.g_miss_date
539: , p1_a2 NUMBER := 0-1962.0724
540: , p1_a3 DATE := fnd_api.g_miss_date

Line 538: , p1_a1 DATE := fnd_api.g_miss_date

534: , p0_a17 NUMBER := 0-1962.0724
535: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
537: , p1_a0 NUMBER := 0-1962.0724
538: , p1_a1 DATE := fnd_api.g_miss_date
539: , p1_a2 NUMBER := 0-1962.0724
540: , p1_a3 DATE := fnd_api.g_miss_date
541: , p1_a4 NUMBER := 0-1962.0724
542: , p1_a5 NUMBER := 0-1962.0724

Line 540: , p1_a3 DATE := fnd_api.g_miss_date

536: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
537: , p1_a0 NUMBER := 0-1962.0724
538: , p1_a1 DATE := fnd_api.g_miss_date
539: , p1_a2 NUMBER := 0-1962.0724
540: , p1_a3 DATE := fnd_api.g_miss_date
541: , p1_a4 NUMBER := 0-1962.0724
542: , p1_a5 NUMBER := 0-1962.0724
543: , p1_a6 NUMBER := 0-1962.0724
544: , p1_a7 NUMBER := 0-1962.0724

Line 547: , p1_a10 DATE := fnd_api.g_miss_date

543: , p1_a6 NUMBER := 0-1962.0724
544: , p1_a7 NUMBER := 0-1962.0724
545: , p1_a8 NUMBER := 0-1962.0724
546: , p1_a9 NUMBER := 0-1962.0724
547: , p1_a10 DATE := fnd_api.g_miss_date
548: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
549: , p1_a12 DATE := fnd_api.g_miss_date
550: , p1_a13 DATE := fnd_api.g_miss_date
551: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 548: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

544: , p1_a7 NUMBER := 0-1962.0724
545: , p1_a8 NUMBER := 0-1962.0724
546: , p1_a9 NUMBER := 0-1962.0724
547: , p1_a10 DATE := fnd_api.g_miss_date
548: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
549: , p1_a12 DATE := fnd_api.g_miss_date
550: , p1_a13 DATE := fnd_api.g_miss_date
551: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
552: , p1_a15 NUMBER := 0-1962.0724

Line 549: , p1_a12 DATE := fnd_api.g_miss_date

545: , p1_a8 NUMBER := 0-1962.0724
546: , p1_a9 NUMBER := 0-1962.0724
547: , p1_a10 DATE := fnd_api.g_miss_date
548: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
549: , p1_a12 DATE := fnd_api.g_miss_date
550: , p1_a13 DATE := fnd_api.g_miss_date
551: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
552: , p1_a15 NUMBER := 0-1962.0724
553: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 550: , p1_a13 DATE := fnd_api.g_miss_date

546: , p1_a9 NUMBER := 0-1962.0724
547: , p1_a10 DATE := fnd_api.g_miss_date
548: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
549: , p1_a12 DATE := fnd_api.g_miss_date
550: , p1_a13 DATE := fnd_api.g_miss_date
551: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
552: , p1_a15 NUMBER := 0-1962.0724
553: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
554: , p1_a17 NUMBER := 0-1962.0724

Line 551: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

547: , p1_a10 DATE := fnd_api.g_miss_date
548: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
549: , p1_a12 DATE := fnd_api.g_miss_date
550: , p1_a13 DATE := fnd_api.g_miss_date
551: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
552: , p1_a15 NUMBER := 0-1962.0724
553: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
554: , p1_a17 NUMBER := 0-1962.0724
555: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 553: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

549: , p1_a12 DATE := fnd_api.g_miss_date
550: , p1_a13 DATE := fnd_api.g_miss_date
551: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
552: , p1_a15 NUMBER := 0-1962.0724
553: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
554: , p1_a17 NUMBER := 0-1962.0724
555: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
556: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
557: )

Line 555: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

551: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
552: , p1_a15 NUMBER := 0-1962.0724
553: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
554: , p1_a17 NUMBER := 0-1962.0724
555: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
556: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
557: )
558: as
559: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 556: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

552: , p1_a15 NUMBER := 0-1962.0724
553: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
554: , p1_a17 NUMBER := 0-1962.0724
555: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
556: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
557: )
558: as
559: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
560: ddp_complete_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 639: , p0_a1 DATE := fnd_api.g_miss_date

635: , p1_a17 OUT NOCOPY /* file.sql.39 change */ NUMBER
636: , p1_a18 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
637: , p1_a19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
638: , p0_a0 NUMBER := 0-1962.0724
639: , p0_a1 DATE := fnd_api.g_miss_date
640: , p0_a2 NUMBER := 0-1962.0724
641: , p0_a3 DATE := fnd_api.g_miss_date
642: , p0_a4 NUMBER := 0-1962.0724
643: , p0_a5 NUMBER := 0-1962.0724

Line 641: , p0_a3 DATE := fnd_api.g_miss_date

637: , p1_a19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
638: , p0_a0 NUMBER := 0-1962.0724
639: , p0_a1 DATE := fnd_api.g_miss_date
640: , p0_a2 NUMBER := 0-1962.0724
641: , p0_a3 DATE := fnd_api.g_miss_date
642: , p0_a4 NUMBER := 0-1962.0724
643: , p0_a5 NUMBER := 0-1962.0724
644: , p0_a6 NUMBER := 0-1962.0724
645: , p0_a7 NUMBER := 0-1962.0724

Line 648: , p0_a10 DATE := fnd_api.g_miss_date

644: , p0_a6 NUMBER := 0-1962.0724
645: , p0_a7 NUMBER := 0-1962.0724
646: , p0_a8 NUMBER := 0-1962.0724
647: , p0_a9 NUMBER := 0-1962.0724
648: , p0_a10 DATE := fnd_api.g_miss_date
649: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a12 DATE := fnd_api.g_miss_date
651: , p0_a13 DATE := fnd_api.g_miss_date
652: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 649: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

645: , p0_a7 NUMBER := 0-1962.0724
646: , p0_a8 NUMBER := 0-1962.0724
647: , p0_a9 NUMBER := 0-1962.0724
648: , p0_a10 DATE := fnd_api.g_miss_date
649: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a12 DATE := fnd_api.g_miss_date
651: , p0_a13 DATE := fnd_api.g_miss_date
652: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a15 NUMBER := 0-1962.0724

Line 650: , p0_a12 DATE := fnd_api.g_miss_date

646: , p0_a8 NUMBER := 0-1962.0724
647: , p0_a9 NUMBER := 0-1962.0724
648: , p0_a10 DATE := fnd_api.g_miss_date
649: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a12 DATE := fnd_api.g_miss_date
651: , p0_a13 DATE := fnd_api.g_miss_date
652: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a15 NUMBER := 0-1962.0724
654: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 651: , p0_a13 DATE := fnd_api.g_miss_date

647: , p0_a9 NUMBER := 0-1962.0724
648: , p0_a10 DATE := fnd_api.g_miss_date
649: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a12 DATE := fnd_api.g_miss_date
651: , p0_a13 DATE := fnd_api.g_miss_date
652: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a15 NUMBER := 0-1962.0724
654: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a17 NUMBER := 0-1962.0724

Line 652: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

648: , p0_a10 DATE := fnd_api.g_miss_date
649: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a12 DATE := fnd_api.g_miss_date
651: , p0_a13 DATE := fnd_api.g_miss_date
652: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a15 NUMBER := 0-1962.0724
654: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a17 NUMBER := 0-1962.0724
656: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 654: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

650: , p0_a12 DATE := fnd_api.g_miss_date
651: , p0_a13 DATE := fnd_api.g_miss_date
652: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a15 NUMBER := 0-1962.0724
654: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a17 NUMBER := 0-1962.0724
656: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
658: )

Line 656: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

652: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a15 NUMBER := 0-1962.0724
654: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a17 NUMBER := 0-1962.0724
656: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
658: )
659: as
660: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

Line 657: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

653: , p0_a15 NUMBER := 0-1962.0724
654: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a17 NUMBER := 0-1962.0724
656: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
658: )
659: as
660: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
661: ddx_complete_rec jtf_loc_areas_pvt.loc_area_rec_type;