42: , x_msg_data out nocopy VARCHAR2
43: , p7_a0 NUMBER := 0-1962.0724
44: , p7_a1 NUMBER := 0-1962.0724
45: , p7_a2 NUMBER := 0-1962.0724
46: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a0 NUMBER := 0-1962.0724
44: , p7_a1 NUMBER := 0-1962.0724
45: , p7_a2 NUMBER := 0-1962.0724
46: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a8 DATE := fnd_api.g_miss_date
44: , p7_a1 NUMBER := 0-1962.0724
45: , p7_a2 NUMBER := 0-1962.0724
46: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a8 DATE := fnd_api.g_miss_date
52: , p7_a9 NUMBER := 0-1962.0724
45: , p7_a2 NUMBER := 0-1962.0724
46: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a8 DATE := fnd_api.g_miss_date
52: , p7_a9 NUMBER := 0-1962.0724
53: , p7_a10 DATE := fnd_api.g_miss_date
46: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a8 DATE := fnd_api.g_miss_date
52: , p7_a9 NUMBER := 0-1962.0724
53: , p7_a10 DATE := fnd_api.g_miss_date
54: , p7_a11 NUMBER := 0-1962.0724
47: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a8 DATE := fnd_api.g_miss_date
52: , p7_a9 NUMBER := 0-1962.0724
53: , p7_a10 DATE := fnd_api.g_miss_date
54: , p7_a11 NUMBER := 0-1962.0724
55: , p7_a12 NUMBER := 0-1962.0724
49: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a8 DATE := fnd_api.g_miss_date
52: , p7_a9 NUMBER := 0-1962.0724
53: , p7_a10 DATE := fnd_api.g_miss_date
54: , p7_a11 NUMBER := 0-1962.0724
55: , p7_a12 NUMBER := 0-1962.0724
56: , p7_a13 NUMBER := 0-1962.0724
57: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a10 DATE := fnd_api.g_miss_date
54: , p7_a11 NUMBER := 0-1962.0724
55: , p7_a12 NUMBER := 0-1962.0724
56: , p7_a13 NUMBER := 0-1962.0724
57: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
58: , x_offer_adj_new_product_id out nocopy NUMBER
59: );
60: procedure update_adj_new_prod(p_api_version_number NUMBER
61: , p_init_msg_list VARCHAR2
66: , x_msg_data out nocopy VARCHAR2
67: , p7_a0 NUMBER := 0-1962.0724
68: , p7_a1 NUMBER := 0-1962.0724
69: , p7_a2 NUMBER := 0-1962.0724
70: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a0 NUMBER := 0-1962.0724
68: , p7_a1 NUMBER := 0-1962.0724
69: , p7_a2 NUMBER := 0-1962.0724
70: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a8 DATE := fnd_api.g_miss_date
68: , p7_a1 NUMBER := 0-1962.0724
69: , p7_a2 NUMBER := 0-1962.0724
70: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a8 DATE := fnd_api.g_miss_date
76: , p7_a9 NUMBER := 0-1962.0724
69: , p7_a2 NUMBER := 0-1962.0724
70: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a8 DATE := fnd_api.g_miss_date
76: , p7_a9 NUMBER := 0-1962.0724
77: , p7_a10 DATE := fnd_api.g_miss_date
70: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a8 DATE := fnd_api.g_miss_date
76: , p7_a9 NUMBER := 0-1962.0724
77: , p7_a10 DATE := fnd_api.g_miss_date
78: , p7_a11 NUMBER := 0-1962.0724
71: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a8 DATE := fnd_api.g_miss_date
76: , p7_a9 NUMBER := 0-1962.0724
77: , p7_a10 DATE := fnd_api.g_miss_date
78: , p7_a11 NUMBER := 0-1962.0724
79: , p7_a12 NUMBER := 0-1962.0724
73: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a8 DATE := fnd_api.g_miss_date
76: , p7_a9 NUMBER := 0-1962.0724
77: , p7_a10 DATE := fnd_api.g_miss_date
78: , p7_a11 NUMBER := 0-1962.0724
79: , p7_a12 NUMBER := 0-1962.0724
80: , p7_a13 NUMBER := 0-1962.0724
81: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a10 DATE := fnd_api.g_miss_date
78: , p7_a11 NUMBER := 0-1962.0724
79: , p7_a12 NUMBER := 0-1962.0724
80: , p7_a13 NUMBER := 0-1962.0724
81: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
82: , x_object_version_number out nocopy NUMBER
83: );
84: procedure validate_adj_new_prod(p_api_version_number NUMBER
85: , p_init_msg_list VARCHAR2
90: , x_msg_data out nocopy VARCHAR2
91: , p4_a0 NUMBER := 0-1962.0724
92: , p4_a1 NUMBER := 0-1962.0724
93: , p4_a2 NUMBER := 0-1962.0724
94: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
91: , p4_a0 NUMBER := 0-1962.0724
92: , p4_a1 NUMBER := 0-1962.0724
93: , p4_a2 NUMBER := 0-1962.0724
94: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p4_a8 DATE := fnd_api.g_miss_date
92: , p4_a1 NUMBER := 0-1962.0724
93: , p4_a2 NUMBER := 0-1962.0724
94: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p4_a8 DATE := fnd_api.g_miss_date
100: , p4_a9 NUMBER := 0-1962.0724
93: , p4_a2 NUMBER := 0-1962.0724
94: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p4_a8 DATE := fnd_api.g_miss_date
100: , p4_a9 NUMBER := 0-1962.0724
101: , p4_a10 DATE := fnd_api.g_miss_date
94: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p4_a8 DATE := fnd_api.g_miss_date
100: , p4_a9 NUMBER := 0-1962.0724
101: , p4_a10 DATE := fnd_api.g_miss_date
102: , p4_a11 NUMBER := 0-1962.0724
95: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p4_a8 DATE := fnd_api.g_miss_date
100: , p4_a9 NUMBER := 0-1962.0724
101: , p4_a10 DATE := fnd_api.g_miss_date
102: , p4_a11 NUMBER := 0-1962.0724
103: , p4_a12 NUMBER := 0-1962.0724
97: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p4_a8 DATE := fnd_api.g_miss_date
100: , p4_a9 NUMBER := 0-1962.0724
101: , p4_a10 DATE := fnd_api.g_miss_date
102: , p4_a11 NUMBER := 0-1962.0724
103: , p4_a12 NUMBER := 0-1962.0724
104: , p4_a13 NUMBER := 0-1962.0724
105: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
101: , p4_a10 DATE := fnd_api.g_miss_date
102: , p4_a11 NUMBER := 0-1962.0724
103: , p4_a12 NUMBER := 0-1962.0724
104: , p4_a13 NUMBER := 0-1962.0724
105: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
106: );
107: procedure check_adj_new_prod_items(p_validation_mode VARCHAR2
108: , x_return_status out nocopy VARCHAR2
109: , p0_a0 NUMBER := 0-1962.0724
108: , x_return_status out nocopy VARCHAR2
109: , p0_a0 NUMBER := 0-1962.0724
110: , p0_a1 NUMBER := 0-1962.0724
111: , p0_a2 NUMBER := 0-1962.0724
112: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
114: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
115: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
109: , p0_a0 NUMBER := 0-1962.0724
110: , p0_a1 NUMBER := 0-1962.0724
111: , p0_a2 NUMBER := 0-1962.0724
112: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
114: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
115: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
117: , p0_a8 DATE := fnd_api.g_miss_date
110: , p0_a1 NUMBER := 0-1962.0724
111: , p0_a2 NUMBER := 0-1962.0724
112: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
114: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
115: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
117: , p0_a8 DATE := fnd_api.g_miss_date
118: , p0_a9 NUMBER := 0-1962.0724
111: , p0_a2 NUMBER := 0-1962.0724
112: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
114: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
115: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
117: , p0_a8 DATE := fnd_api.g_miss_date
118: , p0_a9 NUMBER := 0-1962.0724
119: , p0_a10 DATE := fnd_api.g_miss_date
112: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
114: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
115: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
117: , p0_a8 DATE := fnd_api.g_miss_date
118: , p0_a9 NUMBER := 0-1962.0724
119: , p0_a10 DATE := fnd_api.g_miss_date
120: , p0_a11 NUMBER := 0-1962.0724
113: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
114: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
115: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
117: , p0_a8 DATE := fnd_api.g_miss_date
118: , p0_a9 NUMBER := 0-1962.0724
119: , p0_a10 DATE := fnd_api.g_miss_date
120: , p0_a11 NUMBER := 0-1962.0724
121: , p0_a12 NUMBER := 0-1962.0724
115: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
117: , p0_a8 DATE := fnd_api.g_miss_date
118: , p0_a9 NUMBER := 0-1962.0724
119: , p0_a10 DATE := fnd_api.g_miss_date
120: , p0_a11 NUMBER := 0-1962.0724
121: , p0_a12 NUMBER := 0-1962.0724
122: , p0_a13 NUMBER := 0-1962.0724
123: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a10 DATE := fnd_api.g_miss_date
120: , p0_a11 NUMBER := 0-1962.0724
121: , p0_a12 NUMBER := 0-1962.0724
122: , p0_a13 NUMBER := 0-1962.0724
123: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
124: );
125: procedure validate_adj_new_prod_rec(p_api_version_number NUMBER
126: , p_init_msg_list VARCHAR2
127: , x_return_status out nocopy VARCHAR2
129: , x_msg_data out nocopy VARCHAR2
130: , p5_a0 NUMBER := 0-1962.0724
131: , p5_a1 NUMBER := 0-1962.0724
132: , p5_a2 NUMBER := 0-1962.0724
133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a0 NUMBER := 0-1962.0724
131: , p5_a1 NUMBER := 0-1962.0724
132: , p5_a2 NUMBER := 0-1962.0724
133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 DATE := fnd_api.g_miss_date
131: , p5_a1 NUMBER := 0-1962.0724
132: , p5_a2 NUMBER := 0-1962.0724
133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 DATE := fnd_api.g_miss_date
139: , p5_a9 NUMBER := 0-1962.0724
132: , p5_a2 NUMBER := 0-1962.0724
133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 DATE := fnd_api.g_miss_date
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 DATE := fnd_api.g_miss_date
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
141: , p5_a11 NUMBER := 0-1962.0724
134: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 DATE := fnd_api.g_miss_date
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
141: , p5_a11 NUMBER := 0-1962.0724
142: , p5_a12 NUMBER := 0-1962.0724
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 DATE := fnd_api.g_miss_date
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
141: , p5_a11 NUMBER := 0-1962.0724
142: , p5_a12 NUMBER := 0-1962.0724
143: , p5_a13 NUMBER := 0-1962.0724
144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a10 DATE := fnd_api.g_miss_date
141: , p5_a11 NUMBER := 0-1962.0724
142: , p5_a12 NUMBER := 0-1962.0724
143: , p5_a13 NUMBER := 0-1962.0724
144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
145: );
146: end ozf_adj_new_prod_pvt_w;