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;
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_contact_point(p_api_version_number NUMBER
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , x_contact_point_id OUT NOCOPY NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
32: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , x_contact_point_id OUT NOCOPY NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
32: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
29: , x_contact_point_id OUT NOCOPY NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
32: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
31: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
32: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
32: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 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
33: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 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
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 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
35: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 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
36: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 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
37: , p7_a7 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
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
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
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
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
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
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
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
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
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
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
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 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 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 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 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 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 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 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 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 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 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 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 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
65: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
65: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
66: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
67: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
65: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
66: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
67: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
68: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
65: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
66: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
67: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
68: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
69: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
65: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
66: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
67: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
68: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
69: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
70: , p8_a6 NUMBER := 0-1962.0724
63: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
65: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
66: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
67: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
68: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
69: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
70: , p8_a6 NUMBER := 0-1962.0724
71: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
64: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
65: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
66: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
67: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
68: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
69: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
70: , p8_a6 NUMBER := 0-1962.0724
71: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
72: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
65: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
66: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
67: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
68: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
69: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
70: , p8_a6 NUMBER := 0-1962.0724
71: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
72: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
73: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
67: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
68: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
69: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
70: , p8_a6 NUMBER := 0-1962.0724
71: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
72: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
73: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
74: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
75: , p10_a1 DATE := fnd_api.g_miss_date
68: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
69: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
70: , p8_a6 NUMBER := 0-1962.0724
71: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
72: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
73: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
74: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
75: , p10_a1 DATE := fnd_api.g_miss_date
76: , p10_a2 NUMBER := 0-1962.0724
69: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
70: , p8_a6 NUMBER := 0-1962.0724
71: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
72: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
73: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
74: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
75: , p10_a1 DATE := fnd_api.g_miss_date
76: , p10_a2 NUMBER := 0-1962.0724
77: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
70: , p8_a6 NUMBER := 0-1962.0724
71: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
72: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
73: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
74: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
75: , p10_a1 DATE := fnd_api.g_miss_date
76: , p10_a2 NUMBER := 0-1962.0724
77: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
71: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
72: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
73: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
74: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
75: , p10_a1 DATE := fnd_api.g_miss_date
76: , p10_a2 NUMBER := 0-1962.0724
77: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
74: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
75: , p10_a1 DATE := fnd_api.g_miss_date
76: , p10_a2 NUMBER := 0-1962.0724
77: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
74: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
75: , p10_a1 DATE := fnd_api.g_miss_date
76: , p10_a2 NUMBER := 0-1962.0724
77: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
82: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
75: , p10_a1 DATE := fnd_api.g_miss_date
76: , p10_a2 NUMBER := 0-1962.0724
77: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
82: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
76: , p10_a2 NUMBER := 0-1962.0724
77: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
82: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
84: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
77: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
82: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
84: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
85: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
78: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
82: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
84: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
85: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
86: )
79: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
80: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
82: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
84: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
85: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
86: )
87: as
80: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
82: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
84: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
85: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
86: )
87: as
88: ddp_ams_contact_point_rec ams_contact_point_pvt.contact_point_rec_type;
81: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
82: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
84: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
85: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
86: )
87: as
88: ddp_ams_contact_point_rec ams_contact_point_pvt.contact_point_rec_type;
89: ddp_ams_edi_rec ams_contact_point_pvt.edi_rec_type;
205: , x_msg_count OUT NOCOPY NUMBER
206: , x_msg_data OUT NOCOPY VARCHAR2
207: , px_object_version_number in OUT NOCOPY NUMBER
208: , p7_a0 NUMBER := 0-1962.0724
209: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a4 NUMBER := 0-1962.0724
213: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
206: , x_msg_data OUT NOCOPY VARCHAR2
207: , px_object_version_number in OUT NOCOPY NUMBER
208: , p7_a0 NUMBER := 0-1962.0724
209: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a4 NUMBER := 0-1962.0724
213: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
207: , px_object_version_number in OUT NOCOPY NUMBER
208: , p7_a0 NUMBER := 0-1962.0724
209: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a4 NUMBER := 0-1962.0724
213: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a4 NUMBER := 0-1962.0724
213: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a4 NUMBER := 0-1962.0724
213: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a4 NUMBER := 0-1962.0724
213: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a4 NUMBER := 0-1962.0724
213: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
213: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a32 NUMBER := 0-1962.0724
233: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a32 NUMBER := 0-1962.0724
241: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a32 NUMBER := 0-1962.0724
241: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
242: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a32 NUMBER := 0-1962.0724
241: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
242: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
243: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a32 NUMBER := 0-1962.0724
241: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
242: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
243: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
244: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
245: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a32 NUMBER := 0-1962.0724
241: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
242: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
243: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
244: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
245: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
246: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a32 NUMBER := 0-1962.0724
241: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
242: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
243: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
244: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
245: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
246: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
247: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a32 NUMBER := 0-1962.0724
241: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
242: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
243: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
244: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
245: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
246: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
247: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
248: , p8_a6 NUMBER := 0-1962.0724
241: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
242: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
243: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
244: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
245: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
246: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
247: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
248: , p8_a6 NUMBER := 0-1962.0724
249: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p8_a0 VARCHAR2 := fnd_api.g_miss_char
243: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
244: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
245: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
246: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
247: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
248: , p8_a6 NUMBER := 0-1962.0724
249: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
250: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
243: , p8_a1 VARCHAR2 := fnd_api.g_miss_char
244: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
245: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
246: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
247: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
248: , p8_a6 NUMBER := 0-1962.0724
249: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
250: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
251: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
245: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
246: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
247: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
248: , p8_a6 NUMBER := 0-1962.0724
249: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
250: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
251: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
252: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
253: , p10_a1 DATE := fnd_api.g_miss_date
246: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
247: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
248: , p8_a6 NUMBER := 0-1962.0724
249: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
250: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
251: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
252: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
253: , p10_a1 DATE := fnd_api.g_miss_date
254: , p10_a2 NUMBER := 0-1962.0724
247: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
248: , p8_a6 NUMBER := 0-1962.0724
249: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
250: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
251: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
252: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
253: , p10_a1 DATE := fnd_api.g_miss_date
254: , p10_a2 NUMBER := 0-1962.0724
255: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
248: , p8_a6 NUMBER := 0-1962.0724
249: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
250: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
251: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
252: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
253: , p10_a1 DATE := fnd_api.g_miss_date
254: , p10_a2 NUMBER := 0-1962.0724
255: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
249: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
250: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
251: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
252: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
253: , p10_a1 DATE := fnd_api.g_miss_date
254: , p10_a2 NUMBER := 0-1962.0724
255: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
251: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
252: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
253: , p10_a1 DATE := fnd_api.g_miss_date
254: , p10_a2 NUMBER := 0-1962.0724
255: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
252: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
253: , p10_a1 DATE := fnd_api.g_miss_date
254: , p10_a2 NUMBER := 0-1962.0724
255: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
253: , p10_a1 DATE := fnd_api.g_miss_date
254: , p10_a2 NUMBER := 0-1962.0724
255: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
254: , p10_a2 NUMBER := 0-1962.0724
255: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
262: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
255: , p10_a3 VARCHAR2 := fnd_api.g_miss_char
256: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
262: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
263: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
256: , p10_a4 VARCHAR2 := fnd_api.g_miss_char
257: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
262: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
263: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
264: )
257: , p10_a5 VARCHAR2 := fnd_api.g_miss_char
258: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
262: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
263: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
264: )
265: as
258: , p10_a6 VARCHAR2 := fnd_api.g_miss_char
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
262: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
263: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
264: )
265: as
266: ddp_ams_contact_point_rec ams_contact_point_pvt.contact_point_rec_type;
259: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
260: , p10_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p11_a0 VARCHAR2 := fnd_api.g_miss_char
262: , p12_a0 VARCHAR2 := fnd_api.g_miss_char
263: , p12_a1 VARCHAR2 := fnd_api.g_miss_char
264: )
265: as
266: ddp_ams_contact_point_rec ams_contact_point_pvt.contact_point_rec_type;
267: ddp_ams_edi_rec ams_contact_point_pvt.edi_rec_type;