APPS.AMS_GEO_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_geo_area(p_api_version NUMBER

Line 31: , p7_a1 DATE := fnd_api.g_miss_date

27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , x_geo_area_id OUT NOCOPY 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_geo_area_id OUT NOCOPY 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 38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

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
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

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

Line 43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

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

Line 44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

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

Line 45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 NUMBER := 0-1962.0724

Line 53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 NUMBER := 0-1962.0724
57: )

Line 54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 NUMBER := 0-1962.0724
57: )
58: as

Line 55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 NUMBER := 0-1962.0724
57: )
58: as
59: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

Line 130: , p7_a1 DATE := fnd_api.g_miss_date

126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2
129: , p7_a0 NUMBER := 0-1962.0724
130: , p7_a1 DATE := fnd_api.g_miss_date
131: , p7_a2 NUMBER := 0-1962.0724
132: , p7_a3 DATE := fnd_api.g_miss_date
133: , p7_a4 NUMBER := 0-1962.0724
134: , p7_a5 NUMBER := 0-1962.0724

Line 132: , p7_a3 DATE := fnd_api.g_miss_date

128: , x_msg_data OUT NOCOPY VARCHAR2
129: , p7_a0 NUMBER := 0-1962.0724
130: , p7_a1 DATE := fnd_api.g_miss_date
131: , p7_a2 NUMBER := 0-1962.0724
132: , p7_a3 DATE := fnd_api.g_miss_date
133: , p7_a4 NUMBER := 0-1962.0724
134: , p7_a5 NUMBER := 0-1962.0724
135: , p7_a6 NUMBER := 0-1962.0724
136: , p7_a7 NUMBER := 0-1962.0724

Line 137: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

133: , p7_a4 NUMBER := 0-1962.0724
134: , p7_a5 NUMBER := 0-1962.0724
135: , p7_a6 NUMBER := 0-1962.0724
136: , p7_a7 NUMBER := 0-1962.0724
137: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 138: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

134: , p7_a5 NUMBER := 0-1962.0724
135: , p7_a6 NUMBER := 0-1962.0724
136: , p7_a7 NUMBER := 0-1962.0724
137: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 139: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

135: , p7_a6 NUMBER := 0-1962.0724
136: , p7_a7 NUMBER := 0-1962.0724
137: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

136: , p7_a7 NUMBER := 0-1962.0724
137: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

137: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

138: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

139: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

140: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

141: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

142: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

143: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

144: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

145: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

146: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

147: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a26 NUMBER := 0-1962.0724

Line 152: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

148: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a26 NUMBER := 0-1962.0724
156: )

Line 153: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

149: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a26 NUMBER := 0-1962.0724
156: )
157: as

Line 154: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

150: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a26 NUMBER := 0-1962.0724
156: )
157: as
158: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

Line 225: , p6_a1 DATE := fnd_api.g_miss_date

221: , x_return_status OUT NOCOPY VARCHAR2
222: , x_msg_count OUT NOCOPY NUMBER
223: , x_msg_data OUT NOCOPY VARCHAR2
224: , p6_a0 NUMBER := 0-1962.0724
225: , p6_a1 DATE := fnd_api.g_miss_date
226: , p6_a2 NUMBER := 0-1962.0724
227: , p6_a3 DATE := fnd_api.g_miss_date
228: , p6_a4 NUMBER := 0-1962.0724
229: , p6_a5 NUMBER := 0-1962.0724

Line 227: , p6_a3 DATE := fnd_api.g_miss_date

223: , x_msg_data OUT NOCOPY VARCHAR2
224: , p6_a0 NUMBER := 0-1962.0724
225: , p6_a1 DATE := fnd_api.g_miss_date
226: , p6_a2 NUMBER := 0-1962.0724
227: , p6_a3 DATE := fnd_api.g_miss_date
228: , p6_a4 NUMBER := 0-1962.0724
229: , p6_a5 NUMBER := 0-1962.0724
230: , p6_a6 NUMBER := 0-1962.0724
231: , p6_a7 NUMBER := 0-1962.0724

Line 232: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

228: , p6_a4 NUMBER := 0-1962.0724
229: , p6_a5 NUMBER := 0-1962.0724
230: , p6_a6 NUMBER := 0-1962.0724
231: , p6_a7 NUMBER := 0-1962.0724
232: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
234: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char

Line 233: , p6_a9 VARCHAR2 := fnd_api.g_miss_char

229: , p6_a5 NUMBER := 0-1962.0724
230: , p6_a6 NUMBER := 0-1962.0724
231: , p6_a7 NUMBER := 0-1962.0724
232: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
234: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char

Line 234: , p6_a10 VARCHAR2 := fnd_api.g_miss_char

230: , p6_a6 NUMBER := 0-1962.0724
231: , p6_a7 NUMBER := 0-1962.0724
232: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
234: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

Line 235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

231: , p6_a7 NUMBER := 0-1962.0724
232: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
234: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

Line 236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char

232: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
234: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

Line 237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char

233: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
234: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char

Line 238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

234: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

Line 239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

235: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char

Line 240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

236: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char

Line 241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char

237: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char

Line 242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

238: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char

Line 243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char

239: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a23 VARCHAR2 := fnd_api.g_miss_char

Line 244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char

240: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a24 VARCHAR2 := fnd_api.g_miss_char

Line 245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char

241: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a25 VARCHAR2 := fnd_api.g_miss_char

Line 246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char

242: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a26 NUMBER := 0-1962.0724

Line 247: , p6_a23 VARCHAR2 := fnd_api.g_miss_char

243: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a26 NUMBER := 0-1962.0724
251: )

Line 248: , p6_a24 VARCHAR2 := fnd_api.g_miss_char

244: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a26 NUMBER := 0-1962.0724
251: )
252: as

Line 249: , p6_a25 VARCHAR2 := fnd_api.g_miss_char

245: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a26 NUMBER := 0-1962.0724
251: )
252: as
253: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

Line 313: , p2_a1 DATE := fnd_api.g_miss_date

309:
310: procedure check_items(p_validation_mode VARCHAR2
311: , x_return_status OUT NOCOPY VARCHAR2
312: , p2_a0 NUMBER := 0-1962.0724
313: , p2_a1 DATE := fnd_api.g_miss_date
314: , p2_a2 NUMBER := 0-1962.0724
315: , p2_a3 DATE := fnd_api.g_miss_date
316: , p2_a4 NUMBER := 0-1962.0724
317: , p2_a5 NUMBER := 0-1962.0724

Line 315: , p2_a3 DATE := fnd_api.g_miss_date

311: , x_return_status OUT NOCOPY VARCHAR2
312: , p2_a0 NUMBER := 0-1962.0724
313: , p2_a1 DATE := fnd_api.g_miss_date
314: , p2_a2 NUMBER := 0-1962.0724
315: , p2_a3 DATE := fnd_api.g_miss_date
316: , p2_a4 NUMBER := 0-1962.0724
317: , p2_a5 NUMBER := 0-1962.0724
318: , p2_a6 NUMBER := 0-1962.0724
319: , p2_a7 NUMBER := 0-1962.0724

Line 320: , p2_a8 VARCHAR2 := fnd_api.g_miss_char

316: , p2_a4 NUMBER := 0-1962.0724
317: , p2_a5 NUMBER := 0-1962.0724
318: , p2_a6 NUMBER := 0-1962.0724
319: , p2_a7 NUMBER := 0-1962.0724
320: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
321: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
322: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char

Line 321: , p2_a9 VARCHAR2 := fnd_api.g_miss_char

317: , p2_a5 NUMBER := 0-1962.0724
318: , p2_a6 NUMBER := 0-1962.0724
319: , p2_a7 NUMBER := 0-1962.0724
320: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
321: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
322: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char

Line 322: , p2_a10 VARCHAR2 := fnd_api.g_miss_char

318: , p2_a6 NUMBER := 0-1962.0724
319: , p2_a7 NUMBER := 0-1962.0724
320: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
321: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
322: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char

Line 323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char

319: , p2_a7 NUMBER := 0-1962.0724
320: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
321: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
322: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char

Line 324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char

320: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
321: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
322: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char

Line 325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char

321: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
322: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char

Line 326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char

322: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char

Line 327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char

323: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char

Line 328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char

324: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char

Line 329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char

325: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char

Line 330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char

326: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char

Line 331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char

327: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
335: , p2_a23 VARCHAR2 := fnd_api.g_miss_char

Line 332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char

328: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
335: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
336: , p2_a24 VARCHAR2 := fnd_api.g_miss_char

Line 333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char

329: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
335: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
336: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
337: , p2_a25 VARCHAR2 := fnd_api.g_miss_char

Line 334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char

330: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
335: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
336: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
337: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
338: , p2_a26 NUMBER := 0-1962.0724

Line 335: , p2_a23 VARCHAR2 := fnd_api.g_miss_char

331: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
335: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
336: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
337: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
338: , p2_a26 NUMBER := 0-1962.0724
339: )

Line 336: , p2_a24 VARCHAR2 := fnd_api.g_miss_char

332: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
335: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
336: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
337: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
338: , p2_a26 NUMBER := 0-1962.0724
339: )
340: as

Line 337: , p2_a25 VARCHAR2 := fnd_api.g_miss_char

333: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
334: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
335: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
336: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
337: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
338: , p2_a26 NUMBER := 0-1962.0724
339: )
340: as
341: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

Line 389: , p1_a1 DATE := fnd_api.g_miss_date

385:
386: procedure check_geo_area_req_items(p_validation_mode VARCHAR2
387: , x_return_status OUT NOCOPY VARCHAR2
388: , p1_a0 NUMBER := 0-1962.0724
389: , p1_a1 DATE := fnd_api.g_miss_date
390: , p1_a2 NUMBER := 0-1962.0724
391: , p1_a3 DATE := fnd_api.g_miss_date
392: , p1_a4 NUMBER := 0-1962.0724
393: , p1_a5 NUMBER := 0-1962.0724

Line 391: , p1_a3 DATE := fnd_api.g_miss_date

387: , x_return_status OUT NOCOPY VARCHAR2
388: , p1_a0 NUMBER := 0-1962.0724
389: , p1_a1 DATE := fnd_api.g_miss_date
390: , p1_a2 NUMBER := 0-1962.0724
391: , p1_a3 DATE := fnd_api.g_miss_date
392: , p1_a4 NUMBER := 0-1962.0724
393: , p1_a5 NUMBER := 0-1962.0724
394: , p1_a6 NUMBER := 0-1962.0724
395: , p1_a7 NUMBER := 0-1962.0724

Line 396: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

392: , p1_a4 NUMBER := 0-1962.0724
393: , p1_a5 NUMBER := 0-1962.0724
394: , p1_a6 NUMBER := 0-1962.0724
395: , p1_a7 NUMBER := 0-1962.0724
396: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

Line 397: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

393: , p1_a5 NUMBER := 0-1962.0724
394: , p1_a6 NUMBER := 0-1962.0724
395: , p1_a7 NUMBER := 0-1962.0724
396: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

Line 398: , p1_a10 VARCHAR2 := fnd_api.g_miss_char

394: , p1_a6 NUMBER := 0-1962.0724
395: , p1_a7 NUMBER := 0-1962.0724
396: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

395: , p1_a7 NUMBER := 0-1962.0724
396: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

Line 400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

396: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

397: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char

Line 402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

398: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

399: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

Line 404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

400: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char

Line 405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char

401: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char

Line 406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

402: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char

Line 407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

403: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
411: , p1_a23 VARCHAR2 := fnd_api.g_miss_char

Line 408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char

404: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
411: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
412: , p1_a24 VARCHAR2 := fnd_api.g_miss_char

Line 409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char

405: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
411: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
412: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a25 VARCHAR2 := fnd_api.g_miss_char

Line 410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char

406: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
411: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
412: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
414: , p1_a26 NUMBER := 0-1962.0724

Line 411: , p1_a23 VARCHAR2 := fnd_api.g_miss_char

407: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
411: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
412: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
414: , p1_a26 NUMBER := 0-1962.0724
415: )

Line 412: , p1_a24 VARCHAR2 := fnd_api.g_miss_char

408: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
411: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
412: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
414: , p1_a26 NUMBER := 0-1962.0724
415: )
416: as

Line 413: , p1_a25 VARCHAR2 := fnd_api.g_miss_char

409: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
411: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
412: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
413: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
414: , p1_a26 NUMBER := 0-1962.0724
415: )
416: as
417: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

Line 465: , p1_a1 DATE := fnd_api.g_miss_date

461:
462: procedure check_geo_area_uk_items(p_validation_mode VARCHAR2
463: , x_return_status OUT NOCOPY VARCHAR2
464: , p1_a0 NUMBER := 0-1962.0724
465: , p1_a1 DATE := fnd_api.g_miss_date
466: , p1_a2 NUMBER := 0-1962.0724
467: , p1_a3 DATE := fnd_api.g_miss_date
468: , p1_a4 NUMBER := 0-1962.0724
469: , p1_a5 NUMBER := 0-1962.0724

Line 467: , p1_a3 DATE := fnd_api.g_miss_date

463: , x_return_status OUT NOCOPY VARCHAR2
464: , p1_a0 NUMBER := 0-1962.0724
465: , p1_a1 DATE := fnd_api.g_miss_date
466: , p1_a2 NUMBER := 0-1962.0724
467: , p1_a3 DATE := fnd_api.g_miss_date
468: , p1_a4 NUMBER := 0-1962.0724
469: , p1_a5 NUMBER := 0-1962.0724
470: , p1_a6 NUMBER := 0-1962.0724
471: , p1_a7 NUMBER := 0-1962.0724

Line 472: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

468: , p1_a4 NUMBER := 0-1962.0724
469: , p1_a5 NUMBER := 0-1962.0724
470: , p1_a6 NUMBER := 0-1962.0724
471: , p1_a7 NUMBER := 0-1962.0724
472: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

Line 473: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

469: , p1_a5 NUMBER := 0-1962.0724
470: , p1_a6 NUMBER := 0-1962.0724
471: , p1_a7 NUMBER := 0-1962.0724
472: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

Line 474: , p1_a10 VARCHAR2 := fnd_api.g_miss_char

470: , p1_a6 NUMBER := 0-1962.0724
471: , p1_a7 NUMBER := 0-1962.0724
472: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

471: , p1_a7 NUMBER := 0-1962.0724
472: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

Line 476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

472: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

473: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char

Line 478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

474: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

475: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

Line 480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

476: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char

Line 481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char

477: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char

Line 482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

478: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char

Line 483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

479: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a23 VARCHAR2 := fnd_api.g_miss_char

Line 484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char

480: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a24 VARCHAR2 := fnd_api.g_miss_char

Line 485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char

481: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a25 VARCHAR2 := fnd_api.g_miss_char

Line 486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char

482: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a26 NUMBER := 0-1962.0724

Line 487: , p1_a23 VARCHAR2 := fnd_api.g_miss_char

483: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a26 NUMBER := 0-1962.0724
491: )

Line 488: , p1_a24 VARCHAR2 := fnd_api.g_miss_char

484: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a26 NUMBER := 0-1962.0724
491: )
492: as

Line 489: , p1_a25 VARCHAR2 := fnd_api.g_miss_char

485: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a26 NUMBER := 0-1962.0724
491: )
492: as
493: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

Line 540: , p0_a1 DATE := fnd_api.g_miss_date

536: end;
537:
538: procedure check_geo_area_fk_items(x_return_status OUT NOCOPY VARCHAR2
539: , p0_a0 NUMBER := 0-1962.0724
540: , p0_a1 DATE := fnd_api.g_miss_date
541: , p0_a2 NUMBER := 0-1962.0724
542: , p0_a3 DATE := fnd_api.g_miss_date
543: , p0_a4 NUMBER := 0-1962.0724
544: , p0_a5 NUMBER := 0-1962.0724

Line 542: , p0_a3 DATE := fnd_api.g_miss_date

538: procedure check_geo_area_fk_items(x_return_status OUT NOCOPY VARCHAR2
539: , p0_a0 NUMBER := 0-1962.0724
540: , p0_a1 DATE := fnd_api.g_miss_date
541: , p0_a2 NUMBER := 0-1962.0724
542: , p0_a3 DATE := fnd_api.g_miss_date
543: , p0_a4 NUMBER := 0-1962.0724
544: , p0_a5 NUMBER := 0-1962.0724
545: , p0_a6 NUMBER := 0-1962.0724
546: , p0_a7 NUMBER := 0-1962.0724

Line 547: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

543: , p0_a4 NUMBER := 0-1962.0724
544: , p0_a5 NUMBER := 0-1962.0724
545: , p0_a6 NUMBER := 0-1962.0724
546: , p0_a7 NUMBER := 0-1962.0724
547: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 548: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

544: , p0_a5 NUMBER := 0-1962.0724
545: , p0_a6 NUMBER := 0-1962.0724
546: , p0_a7 NUMBER := 0-1962.0724
547: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 549: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

545: , p0_a6 NUMBER := 0-1962.0724
546: , p0_a7 NUMBER := 0-1962.0724
547: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

546: , p0_a7 NUMBER := 0-1962.0724
547: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

547: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

548: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

549: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

550: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

Line 555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

551: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

552: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

Line 557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

553: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

554: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

Line 559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

555: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

Line 560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

556: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

Line 561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

557: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a26 NUMBER := 0-1962.0724

Line 562: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

558: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a26 NUMBER := 0-1962.0724
566: )

Line 563: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

559: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a26 NUMBER := 0-1962.0724
566: )
567: as

Line 564: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

560: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a26 NUMBER := 0-1962.0724
566: )
567: as
568: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

Line 638: , p0_a1 DATE := fnd_api.g_miss_date

634: , p1_a24 OUT NOCOPY VARCHAR2
635: , p1_a25 OUT NOCOPY VARCHAR2
636: , p1_a26 OUT NOCOPY NUMBER
637: , p0_a0 NUMBER := 0-1962.0724
638: , p0_a1 DATE := fnd_api.g_miss_date
639: , p0_a2 NUMBER := 0-1962.0724
640: , p0_a3 DATE := fnd_api.g_miss_date
641: , p0_a4 NUMBER := 0-1962.0724
642: , p0_a5 NUMBER := 0-1962.0724

Line 640: , p0_a3 DATE := fnd_api.g_miss_date

636: , p1_a26 OUT NOCOPY NUMBER
637: , p0_a0 NUMBER := 0-1962.0724
638: , p0_a1 DATE := fnd_api.g_miss_date
639: , p0_a2 NUMBER := 0-1962.0724
640: , p0_a3 DATE := fnd_api.g_miss_date
641: , p0_a4 NUMBER := 0-1962.0724
642: , p0_a5 NUMBER := 0-1962.0724
643: , p0_a6 NUMBER := 0-1962.0724
644: , p0_a7 NUMBER := 0-1962.0724

Line 645: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

641: , p0_a4 NUMBER := 0-1962.0724
642: , p0_a5 NUMBER := 0-1962.0724
643: , p0_a6 NUMBER := 0-1962.0724
644: , p0_a7 NUMBER := 0-1962.0724
645: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 646: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

642: , p0_a5 NUMBER := 0-1962.0724
643: , p0_a6 NUMBER := 0-1962.0724
644: , p0_a7 NUMBER := 0-1962.0724
645: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 647: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

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

Line 648: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

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

Line 649: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

645: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 650: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

646: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 651: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

647: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

648: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

Line 653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

649: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

650: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

Line 655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

651: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

652: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
660: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

Line 657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

653: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
660: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
661: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

Line 658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

654: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
660: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
661: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
662: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

Line 659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

655: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
660: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
661: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
662: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
663: , p0_a26 NUMBER := 0-1962.0724

Line 660: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

656: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
660: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
661: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
662: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
663: , p0_a26 NUMBER := 0-1962.0724
664: )

Line 661: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

657: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
660: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
661: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
662: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
663: , p0_a26 NUMBER := 0-1962.0724
664: )
665: as

Line 662: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

658: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
659: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
660: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
661: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
662: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
663: , p0_a26 NUMBER := 0-1962.0724
664: )
665: as
666: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;