APPS.JTF_LOC_POSTAL_CODES_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_postal_code(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_postal_code_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_postal_code_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 VARCHAR2 := fnd_api.g_miss_char

Line 37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

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 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date

Line 40: , p7_a10 DATE := fnd_api.g_miss_date

36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: )

Line 41: , p7_a11 DATE := fnd_api.g_miss_date

37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: )
45: as

Line 42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

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 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: )
45: as
46: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: )
45: as
46: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
47: ddindx binary_integer; indx binary_integer;

Line 105: , p7_a1 DATE := fnd_api.g_miss_date

101: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
102: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103: , p_remove_flag VARCHAR2
104: , p7_a0 NUMBER := 0-1962.0724
105: , p7_a1 DATE := fnd_api.g_miss_date
106: , p7_a2 NUMBER := 0-1962.0724
107: , p7_a3 DATE := fnd_api.g_miss_date
108: , p7_a4 NUMBER := 0-1962.0724
109: , p7_a5 NUMBER := 0-1962.0724

Line 107: , p7_a3 DATE := fnd_api.g_miss_date

103: , p_remove_flag VARCHAR2
104: , p7_a0 NUMBER := 0-1962.0724
105: , p7_a1 DATE := fnd_api.g_miss_date
106: , p7_a2 NUMBER := 0-1962.0724
107: , p7_a3 DATE := fnd_api.g_miss_date
108: , p7_a4 NUMBER := 0-1962.0724
109: , p7_a5 NUMBER := 0-1962.0724
110: , p7_a6 NUMBER := 0-1962.0724
111: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 111: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

107: , p7_a3 DATE := fnd_api.g_miss_date
108: , p7_a4 NUMBER := 0-1962.0724
109: , p7_a5 NUMBER := 0-1962.0724
110: , p7_a6 NUMBER := 0-1962.0724
111: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a8 NUMBER := 0-1962.0724
113: , p7_a9 NUMBER := 0-1962.0724
114: , p7_a10 DATE := fnd_api.g_miss_date
115: , p7_a11 DATE := fnd_api.g_miss_date

Line 114: , p7_a10 DATE := fnd_api.g_miss_date

110: , p7_a6 NUMBER := 0-1962.0724
111: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a8 NUMBER := 0-1962.0724
113: , p7_a9 NUMBER := 0-1962.0724
114: , p7_a10 DATE := fnd_api.g_miss_date
115: , p7_a11 DATE := fnd_api.g_miss_date
116: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
118: )

Line 115: , p7_a11 DATE := fnd_api.g_miss_date

111: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a8 NUMBER := 0-1962.0724
113: , p7_a9 NUMBER := 0-1962.0724
114: , p7_a10 DATE := fnd_api.g_miss_date
115: , p7_a11 DATE := fnd_api.g_miss_date
116: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
118: )
119: as

Line 116: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

112: , p7_a8 NUMBER := 0-1962.0724
113: , p7_a9 NUMBER := 0-1962.0724
114: , p7_a10 DATE := fnd_api.g_miss_date
115: , p7_a11 DATE := fnd_api.g_miss_date
116: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
118: )
119: as
120: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 117: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

113: , p7_a9 NUMBER := 0-1962.0724
114: , p7_a10 DATE := fnd_api.g_miss_date
115: , p7_a11 DATE := fnd_api.g_miss_date
116: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
118: )
119: as
120: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
121: ddindx binary_integer; indx binary_integer;

Line 177: , p6_a1 DATE := fnd_api.g_miss_date

173: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
174: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
175: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176: , p6_a0 NUMBER := 0-1962.0724
177: , p6_a1 DATE := fnd_api.g_miss_date
178: , p6_a2 NUMBER := 0-1962.0724
179: , p6_a3 DATE := fnd_api.g_miss_date
180: , p6_a4 NUMBER := 0-1962.0724
181: , p6_a5 NUMBER := 0-1962.0724

Line 179: , p6_a3 DATE := fnd_api.g_miss_date

175: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176: , p6_a0 NUMBER := 0-1962.0724
177: , p6_a1 DATE := fnd_api.g_miss_date
178: , p6_a2 NUMBER := 0-1962.0724
179: , p6_a3 DATE := fnd_api.g_miss_date
180: , p6_a4 NUMBER := 0-1962.0724
181: , p6_a5 NUMBER := 0-1962.0724
182: , p6_a6 NUMBER := 0-1962.0724
183: , p6_a7 VARCHAR2 := fnd_api.g_miss_char

Line 183: , p6_a7 VARCHAR2 := fnd_api.g_miss_char

179: , p6_a3 DATE := fnd_api.g_miss_date
180: , p6_a4 NUMBER := 0-1962.0724
181: , p6_a5 NUMBER := 0-1962.0724
182: , p6_a6 NUMBER := 0-1962.0724
183: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a8 NUMBER := 0-1962.0724
185: , p6_a9 NUMBER := 0-1962.0724
186: , p6_a10 DATE := fnd_api.g_miss_date
187: , p6_a11 DATE := fnd_api.g_miss_date

Line 186: , p6_a10 DATE := fnd_api.g_miss_date

182: , p6_a6 NUMBER := 0-1962.0724
183: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a8 NUMBER := 0-1962.0724
185: , p6_a9 NUMBER := 0-1962.0724
186: , p6_a10 DATE := fnd_api.g_miss_date
187: , p6_a11 DATE := fnd_api.g_miss_date
188: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
190: )

Line 187: , p6_a11 DATE := fnd_api.g_miss_date

183: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a8 NUMBER := 0-1962.0724
185: , p6_a9 NUMBER := 0-1962.0724
186: , p6_a10 DATE := fnd_api.g_miss_date
187: , p6_a11 DATE := fnd_api.g_miss_date
188: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
190: )
191: as

Line 188: , p6_a12 VARCHAR2 := fnd_api.g_miss_char

184: , p6_a8 NUMBER := 0-1962.0724
185: , p6_a9 NUMBER := 0-1962.0724
186: , p6_a10 DATE := fnd_api.g_miss_date
187: , p6_a11 DATE := fnd_api.g_miss_date
188: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
190: )
191: as
192: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 189: , p6_a13 VARCHAR2 := fnd_api.g_miss_char

185: , p6_a9 NUMBER := 0-1962.0724
186: , p6_a10 DATE := fnd_api.g_miss_date
187: , p6_a11 DATE := fnd_api.g_miss_date
188: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
190: )
191: as
192: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
193: ddindx binary_integer; indx binary_integer;

Line 239: , p2_a1 DATE := fnd_api.g_miss_date

235:
236: procedure check_items(p_validation_mode VARCHAR2
237: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
238: , p2_a0 NUMBER := 0-1962.0724
239: , p2_a1 DATE := fnd_api.g_miss_date
240: , p2_a2 NUMBER := 0-1962.0724
241: , p2_a3 DATE := fnd_api.g_miss_date
242: , p2_a4 NUMBER := 0-1962.0724
243: , p2_a5 NUMBER := 0-1962.0724

Line 241: , p2_a3 DATE := fnd_api.g_miss_date

237: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
238: , p2_a0 NUMBER := 0-1962.0724
239: , p2_a1 DATE := fnd_api.g_miss_date
240: , p2_a2 NUMBER := 0-1962.0724
241: , p2_a3 DATE := fnd_api.g_miss_date
242: , p2_a4 NUMBER := 0-1962.0724
243: , p2_a5 NUMBER := 0-1962.0724
244: , p2_a6 NUMBER := 0-1962.0724
245: , p2_a7 VARCHAR2 := fnd_api.g_miss_char

Line 245: , p2_a7 VARCHAR2 := fnd_api.g_miss_char

241: , p2_a3 DATE := fnd_api.g_miss_date
242: , p2_a4 NUMBER := 0-1962.0724
243: , p2_a5 NUMBER := 0-1962.0724
244: , p2_a6 NUMBER := 0-1962.0724
245: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a8 NUMBER := 0-1962.0724
247: , p2_a9 NUMBER := 0-1962.0724
248: , p2_a10 DATE := fnd_api.g_miss_date
249: , p2_a11 DATE := fnd_api.g_miss_date

Line 248: , p2_a10 DATE := fnd_api.g_miss_date

244: , p2_a6 NUMBER := 0-1962.0724
245: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a8 NUMBER := 0-1962.0724
247: , p2_a9 NUMBER := 0-1962.0724
248: , p2_a10 DATE := fnd_api.g_miss_date
249: , p2_a11 DATE := fnd_api.g_miss_date
250: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
252: )

Line 249: , p2_a11 DATE := fnd_api.g_miss_date

245: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a8 NUMBER := 0-1962.0724
247: , p2_a9 NUMBER := 0-1962.0724
248: , p2_a10 DATE := fnd_api.g_miss_date
249: , p2_a11 DATE := fnd_api.g_miss_date
250: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
252: )
253: as

Line 250: , p2_a12 VARCHAR2 := fnd_api.g_miss_char

246: , p2_a8 NUMBER := 0-1962.0724
247: , p2_a9 NUMBER := 0-1962.0724
248: , p2_a10 DATE := fnd_api.g_miss_date
249: , p2_a11 DATE := fnd_api.g_miss_date
250: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
252: )
253: as
254: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 251: , p2_a13 VARCHAR2 := fnd_api.g_miss_char

247: , p2_a9 NUMBER := 0-1962.0724
248: , p2_a10 DATE := fnd_api.g_miss_date
249: , p2_a11 DATE := fnd_api.g_miss_date
250: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
252: )
253: as
254: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
255: ddindx binary_integer; indx binary_integer;

Line 289: , p1_a1 DATE := fnd_api.g_miss_date

285:
286: procedure check_req_items(p_validation_mode VARCHAR2
287: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
288: , p1_a0 NUMBER := 0-1962.0724
289: , p1_a1 DATE := fnd_api.g_miss_date
290: , p1_a2 NUMBER := 0-1962.0724
291: , p1_a3 DATE := fnd_api.g_miss_date
292: , p1_a4 NUMBER := 0-1962.0724
293: , p1_a5 NUMBER := 0-1962.0724

Line 291: , p1_a3 DATE := fnd_api.g_miss_date

287: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
288: , p1_a0 NUMBER := 0-1962.0724
289: , p1_a1 DATE := fnd_api.g_miss_date
290: , p1_a2 NUMBER := 0-1962.0724
291: , p1_a3 DATE := fnd_api.g_miss_date
292: , p1_a4 NUMBER := 0-1962.0724
293: , p1_a5 NUMBER := 0-1962.0724
294: , p1_a6 NUMBER := 0-1962.0724
295: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 295: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

291: , p1_a3 DATE := fnd_api.g_miss_date
292: , p1_a4 NUMBER := 0-1962.0724
293: , p1_a5 NUMBER := 0-1962.0724
294: , p1_a6 NUMBER := 0-1962.0724
295: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a8 NUMBER := 0-1962.0724
297: , p1_a9 NUMBER := 0-1962.0724
298: , p1_a10 DATE := fnd_api.g_miss_date
299: , p1_a11 DATE := fnd_api.g_miss_date

Line 298: , p1_a10 DATE := fnd_api.g_miss_date

294: , p1_a6 NUMBER := 0-1962.0724
295: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a8 NUMBER := 0-1962.0724
297: , p1_a9 NUMBER := 0-1962.0724
298: , p1_a10 DATE := fnd_api.g_miss_date
299: , p1_a11 DATE := fnd_api.g_miss_date
300: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
302: )

Line 299: , p1_a11 DATE := fnd_api.g_miss_date

295: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a8 NUMBER := 0-1962.0724
297: , p1_a9 NUMBER := 0-1962.0724
298: , p1_a10 DATE := fnd_api.g_miss_date
299: , p1_a11 DATE := fnd_api.g_miss_date
300: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
302: )
303: as

Line 300: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

296: , p1_a8 NUMBER := 0-1962.0724
297: , p1_a9 NUMBER := 0-1962.0724
298: , p1_a10 DATE := fnd_api.g_miss_date
299: , p1_a11 DATE := fnd_api.g_miss_date
300: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
302: )
303: as
304: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 301: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

297: , p1_a9 NUMBER := 0-1962.0724
298: , p1_a10 DATE := fnd_api.g_miss_date
299: , p1_a11 DATE := fnd_api.g_miss_date
300: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
302: )
303: as
304: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
305: ddindx binary_integer; indx binary_integer;

Line 338: , p0_a1 DATE := fnd_api.g_miss_date

334: end;
335:
336: procedure check_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
337: , p0_a0 NUMBER := 0-1962.0724
338: , p0_a1 DATE := fnd_api.g_miss_date
339: , p0_a2 NUMBER := 0-1962.0724
340: , p0_a3 DATE := fnd_api.g_miss_date
341: , p0_a4 NUMBER := 0-1962.0724
342: , p0_a5 NUMBER := 0-1962.0724

Line 340: , p0_a3 DATE := fnd_api.g_miss_date

336: procedure check_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
337: , p0_a0 NUMBER := 0-1962.0724
338: , p0_a1 DATE := fnd_api.g_miss_date
339: , p0_a2 NUMBER := 0-1962.0724
340: , p0_a3 DATE := fnd_api.g_miss_date
341: , p0_a4 NUMBER := 0-1962.0724
342: , p0_a5 NUMBER := 0-1962.0724
343: , p0_a6 NUMBER := 0-1962.0724
344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

340: , p0_a3 DATE := fnd_api.g_miss_date
341: , p0_a4 NUMBER := 0-1962.0724
342: , p0_a5 NUMBER := 0-1962.0724
343: , p0_a6 NUMBER := 0-1962.0724
344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a8 NUMBER := 0-1962.0724
346: , p0_a9 NUMBER := 0-1962.0724
347: , p0_a10 DATE := fnd_api.g_miss_date
348: , p0_a11 DATE := fnd_api.g_miss_date

Line 347: , p0_a10 DATE := fnd_api.g_miss_date

343: , p0_a6 NUMBER := 0-1962.0724
344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a8 NUMBER := 0-1962.0724
346: , p0_a9 NUMBER := 0-1962.0724
347: , p0_a10 DATE := fnd_api.g_miss_date
348: , p0_a11 DATE := fnd_api.g_miss_date
349: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
351: )

Line 348: , p0_a11 DATE := fnd_api.g_miss_date

344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a8 NUMBER := 0-1962.0724
346: , p0_a9 NUMBER := 0-1962.0724
347: , p0_a10 DATE := fnd_api.g_miss_date
348: , p0_a11 DATE := fnd_api.g_miss_date
349: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
351: )
352: as

Line 349: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

345: , p0_a8 NUMBER := 0-1962.0724
346: , p0_a9 NUMBER := 0-1962.0724
347: , p0_a10 DATE := fnd_api.g_miss_date
348: , p0_a11 DATE := fnd_api.g_miss_date
349: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
351: )
352: as
353: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 350: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

346: , p0_a9 NUMBER := 0-1962.0724
347: , p0_a10 DATE := fnd_api.g_miss_date
348: , p0_a11 DATE := fnd_api.g_miss_date
349: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
351: )
352: as
353: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
354: ddindx binary_integer; indx binary_integer;

Line 384: , p0_a1 DATE := fnd_api.g_miss_date

380: end;
381:
382: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
383: , p0_a0 NUMBER := 0-1962.0724
384: , p0_a1 DATE := fnd_api.g_miss_date
385: , p0_a2 NUMBER := 0-1962.0724
386: , p0_a3 DATE := fnd_api.g_miss_date
387: , p0_a4 NUMBER := 0-1962.0724
388: , p0_a5 NUMBER := 0-1962.0724

Line 386: , p0_a3 DATE := fnd_api.g_miss_date

382: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
383: , p0_a0 NUMBER := 0-1962.0724
384: , p0_a1 DATE := fnd_api.g_miss_date
385: , p0_a2 NUMBER := 0-1962.0724
386: , p0_a3 DATE := fnd_api.g_miss_date
387: , p0_a4 NUMBER := 0-1962.0724
388: , p0_a5 NUMBER := 0-1962.0724
389: , p0_a6 NUMBER := 0-1962.0724
390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

386: , p0_a3 DATE := fnd_api.g_miss_date
387: , p0_a4 NUMBER := 0-1962.0724
388: , p0_a5 NUMBER := 0-1962.0724
389: , p0_a6 NUMBER := 0-1962.0724
390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a8 NUMBER := 0-1962.0724
392: , p0_a9 NUMBER := 0-1962.0724
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 DATE := fnd_api.g_miss_date

Line 393: , p0_a10 DATE := fnd_api.g_miss_date

389: , p0_a6 NUMBER := 0-1962.0724
390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a8 NUMBER := 0-1962.0724
392: , p0_a9 NUMBER := 0-1962.0724
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 DATE := fnd_api.g_miss_date
395: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a0 NUMBER := 0-1962.0724

Line 394: , p0_a11 DATE := fnd_api.g_miss_date

390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a8 NUMBER := 0-1962.0724
392: , p0_a9 NUMBER := 0-1962.0724
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 DATE := fnd_api.g_miss_date
395: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a0 NUMBER := 0-1962.0724
398: , p1_a1 DATE := fnd_api.g_miss_date

Line 395: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

391: , p0_a8 NUMBER := 0-1962.0724
392: , p0_a9 NUMBER := 0-1962.0724
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 DATE := fnd_api.g_miss_date
395: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a0 NUMBER := 0-1962.0724
398: , p1_a1 DATE := fnd_api.g_miss_date
399: , p1_a2 NUMBER := 0-1962.0724

Line 396: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

392: , p0_a9 NUMBER := 0-1962.0724
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 DATE := fnd_api.g_miss_date
395: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a0 NUMBER := 0-1962.0724
398: , p1_a1 DATE := fnd_api.g_miss_date
399: , p1_a2 NUMBER := 0-1962.0724
400: , p1_a3 DATE := fnd_api.g_miss_date

Line 398: , p1_a1 DATE := fnd_api.g_miss_date

394: , p0_a11 DATE := fnd_api.g_miss_date
395: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a0 NUMBER := 0-1962.0724
398: , p1_a1 DATE := fnd_api.g_miss_date
399: , p1_a2 NUMBER := 0-1962.0724
400: , p1_a3 DATE := fnd_api.g_miss_date
401: , p1_a4 NUMBER := 0-1962.0724
402: , p1_a5 NUMBER := 0-1962.0724

Line 400: , p1_a3 DATE := fnd_api.g_miss_date

396: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a0 NUMBER := 0-1962.0724
398: , p1_a1 DATE := fnd_api.g_miss_date
399: , p1_a2 NUMBER := 0-1962.0724
400: , p1_a3 DATE := fnd_api.g_miss_date
401: , p1_a4 NUMBER := 0-1962.0724
402: , p1_a5 NUMBER := 0-1962.0724
403: , p1_a6 NUMBER := 0-1962.0724
404: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 404: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

400: , p1_a3 DATE := fnd_api.g_miss_date
401: , p1_a4 NUMBER := 0-1962.0724
402: , p1_a5 NUMBER := 0-1962.0724
403: , p1_a6 NUMBER := 0-1962.0724
404: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a8 NUMBER := 0-1962.0724
406: , p1_a9 NUMBER := 0-1962.0724
407: , p1_a10 DATE := fnd_api.g_miss_date
408: , p1_a11 DATE := fnd_api.g_miss_date

Line 407: , p1_a10 DATE := fnd_api.g_miss_date

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

Line 408: , p1_a11 DATE := fnd_api.g_miss_date

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

Line 409: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

405: , p1_a8 NUMBER := 0-1962.0724
406: , p1_a9 NUMBER := 0-1962.0724
407: , p1_a10 DATE := fnd_api.g_miss_date
408: , p1_a11 DATE := fnd_api.g_miss_date
409: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
411: )
412: as
413: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 410: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

406: , p1_a9 NUMBER := 0-1962.0724
407: , p1_a10 DATE := fnd_api.g_miss_date
408: , p1_a11 DATE := fnd_api.g_miss_date
409: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
411: )
412: as
413: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
414: ddp_complete_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 475: , p0_a1 DATE := fnd_api.g_miss_date

471: , p1_a11 OUT NOCOPY /* file.sql.39 change */ DATE
472: , p1_a12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
473: , p1_a13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
474: , p0_a0 NUMBER := 0-1962.0724
475: , p0_a1 DATE := fnd_api.g_miss_date
476: , p0_a2 NUMBER := 0-1962.0724
477: , p0_a3 DATE := fnd_api.g_miss_date
478: , p0_a4 NUMBER := 0-1962.0724
479: , p0_a5 NUMBER := 0-1962.0724

Line 477: , p0_a3 DATE := fnd_api.g_miss_date

473: , p1_a13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
474: , p0_a0 NUMBER := 0-1962.0724
475: , p0_a1 DATE := fnd_api.g_miss_date
476: , p0_a2 NUMBER := 0-1962.0724
477: , p0_a3 DATE := fnd_api.g_miss_date
478: , p0_a4 NUMBER := 0-1962.0724
479: , p0_a5 NUMBER := 0-1962.0724
480: , p0_a6 NUMBER := 0-1962.0724
481: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 481: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

477: , p0_a3 DATE := fnd_api.g_miss_date
478: , p0_a4 NUMBER := 0-1962.0724
479: , p0_a5 NUMBER := 0-1962.0724
480: , p0_a6 NUMBER := 0-1962.0724
481: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a8 NUMBER := 0-1962.0724
483: , p0_a9 NUMBER := 0-1962.0724
484: , p0_a10 DATE := fnd_api.g_miss_date
485: , p0_a11 DATE := fnd_api.g_miss_date

Line 484: , p0_a10 DATE := fnd_api.g_miss_date

480: , p0_a6 NUMBER := 0-1962.0724
481: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a8 NUMBER := 0-1962.0724
483: , p0_a9 NUMBER := 0-1962.0724
484: , p0_a10 DATE := fnd_api.g_miss_date
485: , p0_a11 DATE := fnd_api.g_miss_date
486: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
487: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
488: )

Line 485: , p0_a11 DATE := fnd_api.g_miss_date

481: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a8 NUMBER := 0-1962.0724
483: , p0_a9 NUMBER := 0-1962.0724
484: , p0_a10 DATE := fnd_api.g_miss_date
485: , p0_a11 DATE := fnd_api.g_miss_date
486: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
487: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
488: )
489: as

Line 486: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

482: , p0_a8 NUMBER := 0-1962.0724
483: , p0_a9 NUMBER := 0-1962.0724
484: , p0_a10 DATE := fnd_api.g_miss_date
485: , p0_a11 DATE := fnd_api.g_miss_date
486: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
487: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
488: )
489: as
490: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

Line 487: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

483: , p0_a9 NUMBER := 0-1962.0724
484: , p0_a10 DATE := fnd_api.g_miss_date
485: , p0_a11 DATE := fnd_api.g_miss_date
486: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
487: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
488: )
489: as
490: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
491: ddx_complete_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;