8: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
9: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10: , x_postal_code_id OUT NOCOPY /* file.sql.39 change */ NUMBER
11: , p7_a0 NUMBER := 0-1962.0724
12: , p7_a1 DATE := fnd_api.g_miss_date
13: , p7_a2 NUMBER := 0-1962.0724
14: , p7_a3 DATE := fnd_api.g_miss_date
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
10: , x_postal_code_id OUT NOCOPY /* file.sql.39 change */ NUMBER
11: , p7_a0 NUMBER := 0-1962.0724
12: , p7_a1 DATE := fnd_api.g_miss_date
13: , p7_a2 NUMBER := 0-1962.0724
14: , p7_a3 DATE := fnd_api.g_miss_date
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
14: , p7_a3 DATE := fnd_api.g_miss_date
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 NUMBER := 0-1962.0724
20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 DATE := fnd_api.g_miss_date
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 NUMBER := 0-1962.0724
20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 DATE := fnd_api.g_miss_date
23: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
24: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
25: );
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 NUMBER := 0-1962.0724
20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 DATE := fnd_api.g_miss_date
23: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
24: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
25: );
26: procedure update_postal_code(p_api_version NUMBER
19: , p7_a8 NUMBER := 0-1962.0724
20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 DATE := fnd_api.g_miss_date
23: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
24: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
25: );
26: procedure update_postal_code(p_api_version NUMBER
27: , p_init_msg_list VARCHAR2
20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 DATE := fnd_api.g_miss_date
23: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
24: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
25: );
26: procedure update_postal_code(p_api_version NUMBER
27: , p_init_msg_list VARCHAR2
28: , p_commit VARCHAR2
31: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
32: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33: , p_remove_flag VARCHAR2
34: , p7_a0 NUMBER := 0-1962.0724
35: , p7_a1 DATE := fnd_api.g_miss_date
36: , p7_a2 NUMBER := 0-1962.0724
37: , p7_a3 DATE := fnd_api.g_miss_date
38: , p7_a4 NUMBER := 0-1962.0724
39: , p7_a5 NUMBER := 0-1962.0724
33: , p_remove_flag VARCHAR2
34: , p7_a0 NUMBER := 0-1962.0724
35: , p7_a1 DATE := fnd_api.g_miss_date
36: , p7_a2 NUMBER := 0-1962.0724
37: , p7_a3 DATE := fnd_api.g_miss_date
38: , p7_a4 NUMBER := 0-1962.0724
39: , p7_a5 NUMBER := 0-1962.0724
40: , p7_a6 NUMBER := 0-1962.0724
41: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a3 DATE := fnd_api.g_miss_date
38: , p7_a4 NUMBER := 0-1962.0724
39: , p7_a5 NUMBER := 0-1962.0724
40: , p7_a6 NUMBER := 0-1962.0724
41: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a8 NUMBER := 0-1962.0724
43: , p7_a9 NUMBER := 0-1962.0724
44: , p7_a10 DATE := fnd_api.g_miss_date
45: , p7_a11 DATE := fnd_api.g_miss_date
40: , p7_a6 NUMBER := 0-1962.0724
41: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a8 NUMBER := 0-1962.0724
43: , p7_a9 NUMBER := 0-1962.0724
44: , p7_a10 DATE := fnd_api.g_miss_date
45: , p7_a11 DATE := fnd_api.g_miss_date
46: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
48: );
41: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a8 NUMBER := 0-1962.0724
43: , p7_a9 NUMBER := 0-1962.0724
44: , p7_a10 DATE := fnd_api.g_miss_date
45: , p7_a11 DATE := fnd_api.g_miss_date
46: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
48: );
49: procedure validate_postal_code(p_api_version NUMBER
42: , p7_a8 NUMBER := 0-1962.0724
43: , p7_a9 NUMBER := 0-1962.0724
44: , p7_a10 DATE := fnd_api.g_miss_date
45: , p7_a11 DATE := fnd_api.g_miss_date
46: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
48: );
49: procedure validate_postal_code(p_api_version NUMBER
50: , p_init_msg_list VARCHAR2
43: , p7_a9 NUMBER := 0-1962.0724
44: , p7_a10 DATE := fnd_api.g_miss_date
45: , p7_a11 DATE := fnd_api.g_miss_date
46: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
48: );
49: procedure validate_postal_code(p_api_version NUMBER
50: , p_init_msg_list VARCHAR2
51: , p_validation_level NUMBER
52: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
54: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55: , p6_a0 NUMBER := 0-1962.0724
56: , p6_a1 DATE := fnd_api.g_miss_date
57: , p6_a2 NUMBER := 0-1962.0724
58: , p6_a3 DATE := fnd_api.g_miss_date
59: , p6_a4 NUMBER := 0-1962.0724
60: , p6_a5 NUMBER := 0-1962.0724
54: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55: , p6_a0 NUMBER := 0-1962.0724
56: , p6_a1 DATE := fnd_api.g_miss_date
57: , p6_a2 NUMBER := 0-1962.0724
58: , p6_a3 DATE := fnd_api.g_miss_date
59: , p6_a4 NUMBER := 0-1962.0724
60: , p6_a5 NUMBER := 0-1962.0724
61: , p6_a6 NUMBER := 0-1962.0724
62: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p6_a3 DATE := fnd_api.g_miss_date
59: , p6_a4 NUMBER := 0-1962.0724
60: , p6_a5 NUMBER := 0-1962.0724
61: , p6_a6 NUMBER := 0-1962.0724
62: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a8 NUMBER := 0-1962.0724
64: , p6_a9 NUMBER := 0-1962.0724
65: , p6_a10 DATE := fnd_api.g_miss_date
66: , p6_a11 DATE := fnd_api.g_miss_date
61: , p6_a6 NUMBER := 0-1962.0724
62: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a8 NUMBER := 0-1962.0724
64: , p6_a9 NUMBER := 0-1962.0724
65: , p6_a10 DATE := fnd_api.g_miss_date
66: , p6_a11 DATE := fnd_api.g_miss_date
67: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
68: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
69: );
62: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a8 NUMBER := 0-1962.0724
64: , p6_a9 NUMBER := 0-1962.0724
65: , p6_a10 DATE := fnd_api.g_miss_date
66: , p6_a11 DATE := fnd_api.g_miss_date
67: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
68: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
69: );
70: procedure check_items(p_validation_mode VARCHAR2
63: , p6_a8 NUMBER := 0-1962.0724
64: , p6_a9 NUMBER := 0-1962.0724
65: , p6_a10 DATE := fnd_api.g_miss_date
66: , p6_a11 DATE := fnd_api.g_miss_date
67: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
68: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
69: );
70: procedure check_items(p_validation_mode VARCHAR2
71: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p6_a9 NUMBER := 0-1962.0724
65: , p6_a10 DATE := fnd_api.g_miss_date
66: , p6_a11 DATE := fnd_api.g_miss_date
67: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
68: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
69: );
70: procedure check_items(p_validation_mode VARCHAR2
71: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72: , p2_a0 NUMBER := 0-1962.0724
69: );
70: procedure check_items(p_validation_mode VARCHAR2
71: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72: , p2_a0 NUMBER := 0-1962.0724
73: , p2_a1 DATE := fnd_api.g_miss_date
74: , p2_a2 NUMBER := 0-1962.0724
75: , p2_a3 DATE := fnd_api.g_miss_date
76: , p2_a4 NUMBER := 0-1962.0724
77: , p2_a5 NUMBER := 0-1962.0724
71: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72: , p2_a0 NUMBER := 0-1962.0724
73: , p2_a1 DATE := fnd_api.g_miss_date
74: , p2_a2 NUMBER := 0-1962.0724
75: , p2_a3 DATE := fnd_api.g_miss_date
76: , p2_a4 NUMBER := 0-1962.0724
77: , p2_a5 NUMBER := 0-1962.0724
78: , p2_a6 NUMBER := 0-1962.0724
79: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
75: , p2_a3 DATE := fnd_api.g_miss_date
76: , p2_a4 NUMBER := 0-1962.0724
77: , p2_a5 NUMBER := 0-1962.0724
78: , p2_a6 NUMBER := 0-1962.0724
79: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
80: , p2_a8 NUMBER := 0-1962.0724
81: , p2_a9 NUMBER := 0-1962.0724
82: , p2_a10 DATE := fnd_api.g_miss_date
83: , p2_a11 DATE := fnd_api.g_miss_date
78: , p2_a6 NUMBER := 0-1962.0724
79: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
80: , p2_a8 NUMBER := 0-1962.0724
81: , p2_a9 NUMBER := 0-1962.0724
82: , p2_a10 DATE := fnd_api.g_miss_date
83: , p2_a11 DATE := fnd_api.g_miss_date
84: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
85: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
86: );
79: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
80: , p2_a8 NUMBER := 0-1962.0724
81: , p2_a9 NUMBER := 0-1962.0724
82: , p2_a10 DATE := fnd_api.g_miss_date
83: , p2_a11 DATE := fnd_api.g_miss_date
84: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
85: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
86: );
87: procedure check_req_items(p_validation_mode VARCHAR2
80: , p2_a8 NUMBER := 0-1962.0724
81: , p2_a9 NUMBER := 0-1962.0724
82: , p2_a10 DATE := fnd_api.g_miss_date
83: , p2_a11 DATE := fnd_api.g_miss_date
84: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
85: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
86: );
87: procedure check_req_items(p_validation_mode VARCHAR2
88: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81: , p2_a9 NUMBER := 0-1962.0724
82: , p2_a10 DATE := fnd_api.g_miss_date
83: , p2_a11 DATE := fnd_api.g_miss_date
84: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
85: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
86: );
87: procedure check_req_items(p_validation_mode VARCHAR2
88: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89: , p1_a0 NUMBER := 0-1962.0724
86: );
87: procedure check_req_items(p_validation_mode VARCHAR2
88: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89: , p1_a0 NUMBER := 0-1962.0724
90: , p1_a1 DATE := fnd_api.g_miss_date
91: , p1_a2 NUMBER := 0-1962.0724
92: , p1_a3 DATE := fnd_api.g_miss_date
93: , p1_a4 NUMBER := 0-1962.0724
94: , p1_a5 NUMBER := 0-1962.0724
88: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89: , p1_a0 NUMBER := 0-1962.0724
90: , p1_a1 DATE := fnd_api.g_miss_date
91: , p1_a2 NUMBER := 0-1962.0724
92: , p1_a3 DATE := fnd_api.g_miss_date
93: , p1_a4 NUMBER := 0-1962.0724
94: , p1_a5 NUMBER := 0-1962.0724
95: , p1_a6 NUMBER := 0-1962.0724
96: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
92: , p1_a3 DATE := fnd_api.g_miss_date
93: , p1_a4 NUMBER := 0-1962.0724
94: , p1_a5 NUMBER := 0-1962.0724
95: , p1_a6 NUMBER := 0-1962.0724
96: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
97: , p1_a8 NUMBER := 0-1962.0724
98: , p1_a9 NUMBER := 0-1962.0724
99: , p1_a10 DATE := fnd_api.g_miss_date
100: , p1_a11 DATE := fnd_api.g_miss_date
95: , p1_a6 NUMBER := 0-1962.0724
96: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
97: , p1_a8 NUMBER := 0-1962.0724
98: , p1_a9 NUMBER := 0-1962.0724
99: , p1_a10 DATE := fnd_api.g_miss_date
100: , p1_a11 DATE := fnd_api.g_miss_date
101: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
103: );
96: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
97: , p1_a8 NUMBER := 0-1962.0724
98: , p1_a9 NUMBER := 0-1962.0724
99: , p1_a10 DATE := fnd_api.g_miss_date
100: , p1_a11 DATE := fnd_api.g_miss_date
101: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
103: );
104: procedure check_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: , p1_a8 NUMBER := 0-1962.0724
98: , p1_a9 NUMBER := 0-1962.0724
99: , p1_a10 DATE := fnd_api.g_miss_date
100: , p1_a11 DATE := fnd_api.g_miss_date
101: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
103: );
104: procedure check_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105: , p0_a0 NUMBER := 0-1962.0724
98: , p1_a9 NUMBER := 0-1962.0724
99: , p1_a10 DATE := fnd_api.g_miss_date
100: , p1_a11 DATE := fnd_api.g_miss_date
101: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
103: );
104: procedure check_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105: , p0_a0 NUMBER := 0-1962.0724
106: , p0_a1 DATE := fnd_api.g_miss_date
102: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
103: );
104: procedure check_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105: , p0_a0 NUMBER := 0-1962.0724
106: , p0_a1 DATE := fnd_api.g_miss_date
107: , p0_a2 NUMBER := 0-1962.0724
108: , p0_a3 DATE := fnd_api.g_miss_date
109: , p0_a4 NUMBER := 0-1962.0724
110: , p0_a5 NUMBER := 0-1962.0724
104: procedure check_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105: , p0_a0 NUMBER := 0-1962.0724
106: , p0_a1 DATE := fnd_api.g_miss_date
107: , p0_a2 NUMBER := 0-1962.0724
108: , p0_a3 DATE := fnd_api.g_miss_date
109: , p0_a4 NUMBER := 0-1962.0724
110: , p0_a5 NUMBER := 0-1962.0724
111: , p0_a6 NUMBER := 0-1962.0724
112: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a3 DATE := fnd_api.g_miss_date
109: , p0_a4 NUMBER := 0-1962.0724
110: , p0_a5 NUMBER := 0-1962.0724
111: , p0_a6 NUMBER := 0-1962.0724
112: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a8 NUMBER := 0-1962.0724
114: , p0_a9 NUMBER := 0-1962.0724
115: , p0_a10 DATE := fnd_api.g_miss_date
116: , p0_a11 DATE := fnd_api.g_miss_date
111: , p0_a6 NUMBER := 0-1962.0724
112: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a8 NUMBER := 0-1962.0724
114: , p0_a9 NUMBER := 0-1962.0724
115: , p0_a10 DATE := fnd_api.g_miss_date
116: , p0_a11 DATE := fnd_api.g_miss_date
117: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
119: );
112: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a8 NUMBER := 0-1962.0724
114: , p0_a9 NUMBER := 0-1962.0724
115: , p0_a10 DATE := fnd_api.g_miss_date
116: , p0_a11 DATE := fnd_api.g_miss_date
117: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
119: );
120: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p0_a8 NUMBER := 0-1962.0724
114: , p0_a9 NUMBER := 0-1962.0724
115: , p0_a10 DATE := fnd_api.g_miss_date
116: , p0_a11 DATE := fnd_api.g_miss_date
117: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
119: );
120: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121: , p0_a0 NUMBER := 0-1962.0724
114: , p0_a9 NUMBER := 0-1962.0724
115: , p0_a10 DATE := fnd_api.g_miss_date
116: , p0_a11 DATE := fnd_api.g_miss_date
117: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
119: );
120: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121: , p0_a0 NUMBER := 0-1962.0724
122: , p0_a1 DATE := fnd_api.g_miss_date
118: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
119: );
120: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121: , p0_a0 NUMBER := 0-1962.0724
122: , p0_a1 DATE := fnd_api.g_miss_date
123: , p0_a2 NUMBER := 0-1962.0724
124: , p0_a3 DATE := fnd_api.g_miss_date
125: , p0_a4 NUMBER := 0-1962.0724
126: , p0_a5 NUMBER := 0-1962.0724
120: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121: , p0_a0 NUMBER := 0-1962.0724
122: , p0_a1 DATE := fnd_api.g_miss_date
123: , p0_a2 NUMBER := 0-1962.0724
124: , p0_a3 DATE := fnd_api.g_miss_date
125: , p0_a4 NUMBER := 0-1962.0724
126: , p0_a5 NUMBER := 0-1962.0724
127: , p0_a6 NUMBER := 0-1962.0724
128: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a3 DATE := fnd_api.g_miss_date
125: , p0_a4 NUMBER := 0-1962.0724
126: , p0_a5 NUMBER := 0-1962.0724
127: , p0_a6 NUMBER := 0-1962.0724
128: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a8 NUMBER := 0-1962.0724
130: , p0_a9 NUMBER := 0-1962.0724
131: , p0_a10 DATE := fnd_api.g_miss_date
132: , p0_a11 DATE := fnd_api.g_miss_date
127: , p0_a6 NUMBER := 0-1962.0724
128: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a8 NUMBER := 0-1962.0724
130: , p0_a9 NUMBER := 0-1962.0724
131: , p0_a10 DATE := fnd_api.g_miss_date
132: , p0_a11 DATE := fnd_api.g_miss_date
133: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
135: , p1_a0 NUMBER := 0-1962.0724
128: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a8 NUMBER := 0-1962.0724
130: , p0_a9 NUMBER := 0-1962.0724
131: , p0_a10 DATE := fnd_api.g_miss_date
132: , p0_a11 DATE := fnd_api.g_miss_date
133: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
135: , p1_a0 NUMBER := 0-1962.0724
136: , p1_a1 DATE := fnd_api.g_miss_date
129: , p0_a8 NUMBER := 0-1962.0724
130: , p0_a9 NUMBER := 0-1962.0724
131: , p0_a10 DATE := fnd_api.g_miss_date
132: , p0_a11 DATE := fnd_api.g_miss_date
133: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
135: , p1_a0 NUMBER := 0-1962.0724
136: , p1_a1 DATE := fnd_api.g_miss_date
137: , p1_a2 NUMBER := 0-1962.0724
130: , p0_a9 NUMBER := 0-1962.0724
131: , p0_a10 DATE := fnd_api.g_miss_date
132: , p0_a11 DATE := fnd_api.g_miss_date
133: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
135: , p1_a0 NUMBER := 0-1962.0724
136: , p1_a1 DATE := fnd_api.g_miss_date
137: , p1_a2 NUMBER := 0-1962.0724
138: , p1_a3 DATE := fnd_api.g_miss_date
132: , p0_a11 DATE := fnd_api.g_miss_date
133: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
135: , p1_a0 NUMBER := 0-1962.0724
136: , p1_a1 DATE := fnd_api.g_miss_date
137: , p1_a2 NUMBER := 0-1962.0724
138: , p1_a3 DATE := fnd_api.g_miss_date
139: , p1_a4 NUMBER := 0-1962.0724
140: , p1_a5 NUMBER := 0-1962.0724
134: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
135: , p1_a0 NUMBER := 0-1962.0724
136: , p1_a1 DATE := fnd_api.g_miss_date
137: , p1_a2 NUMBER := 0-1962.0724
138: , p1_a3 DATE := fnd_api.g_miss_date
139: , p1_a4 NUMBER := 0-1962.0724
140: , p1_a5 NUMBER := 0-1962.0724
141: , p1_a6 NUMBER := 0-1962.0724
142: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p1_a3 DATE := fnd_api.g_miss_date
139: , p1_a4 NUMBER := 0-1962.0724
140: , p1_a5 NUMBER := 0-1962.0724
141: , p1_a6 NUMBER := 0-1962.0724
142: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
143: , p1_a8 NUMBER := 0-1962.0724
144: , p1_a9 NUMBER := 0-1962.0724
145: , p1_a10 DATE := fnd_api.g_miss_date
146: , p1_a11 DATE := fnd_api.g_miss_date
141: , p1_a6 NUMBER := 0-1962.0724
142: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
143: , p1_a8 NUMBER := 0-1962.0724
144: , p1_a9 NUMBER := 0-1962.0724
145: , p1_a10 DATE := fnd_api.g_miss_date
146: , p1_a11 DATE := fnd_api.g_miss_date
147: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
149: );
142: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
143: , p1_a8 NUMBER := 0-1962.0724
144: , p1_a9 NUMBER := 0-1962.0724
145: , p1_a10 DATE := fnd_api.g_miss_date
146: , p1_a11 DATE := fnd_api.g_miss_date
147: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
149: );
150: procedure complete_rec(p1_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
143: , p1_a8 NUMBER := 0-1962.0724
144: , p1_a9 NUMBER := 0-1962.0724
145: , p1_a10 DATE := fnd_api.g_miss_date
146: , p1_a11 DATE := fnd_api.g_miss_date
147: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
149: );
150: procedure complete_rec(p1_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
151: , p1_a1 OUT NOCOPY /* file.sql.39 change */ DATE
144: , p1_a9 NUMBER := 0-1962.0724
145: , p1_a10 DATE := fnd_api.g_miss_date
146: , p1_a11 DATE := fnd_api.g_miss_date
147: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
149: );
150: procedure complete_rec(p1_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
151: , p1_a1 OUT NOCOPY /* file.sql.39 change */ DATE
152: , p1_a2 OUT NOCOPY /* file.sql.39 change */ NUMBER
161: , p1_a11 OUT NOCOPY /* file.sql.39 change */ DATE
162: , p1_a12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
163: , p1_a13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
164: , p0_a0 NUMBER := 0-1962.0724
165: , p0_a1 DATE := fnd_api.g_miss_date
166: , p0_a2 NUMBER := 0-1962.0724
167: , p0_a3 DATE := fnd_api.g_miss_date
168: , p0_a4 NUMBER := 0-1962.0724
169: , p0_a5 NUMBER := 0-1962.0724
163: , p1_a13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
164: , p0_a0 NUMBER := 0-1962.0724
165: , p0_a1 DATE := fnd_api.g_miss_date
166: , p0_a2 NUMBER := 0-1962.0724
167: , p0_a3 DATE := fnd_api.g_miss_date
168: , p0_a4 NUMBER := 0-1962.0724
169: , p0_a5 NUMBER := 0-1962.0724
170: , p0_a6 NUMBER := 0-1962.0724
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a3 DATE := fnd_api.g_miss_date
168: , p0_a4 NUMBER := 0-1962.0724
169: , p0_a5 NUMBER := 0-1962.0724
170: , p0_a6 NUMBER := 0-1962.0724
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a8 NUMBER := 0-1962.0724
173: , p0_a9 NUMBER := 0-1962.0724
174: , p0_a10 DATE := fnd_api.g_miss_date
175: , p0_a11 DATE := fnd_api.g_miss_date
170: , p0_a6 NUMBER := 0-1962.0724
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a8 NUMBER := 0-1962.0724
173: , p0_a9 NUMBER := 0-1962.0724
174: , p0_a10 DATE := fnd_api.g_miss_date
175: , p0_a11 DATE := fnd_api.g_miss_date
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
178: );
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a8 NUMBER := 0-1962.0724
173: , p0_a9 NUMBER := 0-1962.0724
174: , p0_a10 DATE := fnd_api.g_miss_date
175: , p0_a11 DATE := fnd_api.g_miss_date
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
178: );
179: procedure init_rec(p0_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
172: , p0_a8 NUMBER := 0-1962.0724
173: , p0_a9 NUMBER := 0-1962.0724
174: , p0_a10 DATE := fnd_api.g_miss_date
175: , p0_a11 DATE := fnd_api.g_miss_date
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
178: );
179: procedure init_rec(p0_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
180: , p0_a1 OUT NOCOPY /* file.sql.39 change */ DATE
173: , p0_a9 NUMBER := 0-1962.0724
174: , p0_a10 DATE := fnd_api.g_miss_date
175: , p0_a11 DATE := fnd_api.g_miss_date
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
178: );
179: procedure init_rec(p0_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
180: , p0_a1 OUT NOCOPY /* file.sql.39 change */ DATE
181: , p0_a2 OUT NOCOPY /* file.sql.39 change */ NUMBER