20: , p5_a0 NUMBER := 0-1962.0724
21: , p5_a1 NUMBER := 0-1962.0724
22: , p5_a2 NUMBER := 0-1962.0724
23: , p5_a3 NUMBER := 0-1962.0724
24: , p5_a4 DATE := fnd_api.g_miss_date
25: , p5_a5 DATE := fnd_api.g_miss_date
26: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
27: , p5_a7 NUMBER := 0-1962.0724
28: , p5_a8 DATE := fnd_api.g_miss_date
21: , p5_a1 NUMBER := 0-1962.0724
22: , p5_a2 NUMBER := 0-1962.0724
23: , p5_a3 NUMBER := 0-1962.0724
24: , p5_a4 DATE := fnd_api.g_miss_date
25: , p5_a5 DATE := fnd_api.g_miss_date
26: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
27: , p5_a7 NUMBER := 0-1962.0724
28: , p5_a8 DATE := fnd_api.g_miss_date
29: , p5_a9 NUMBER := 0-1962.0724
22: , p5_a2 NUMBER := 0-1962.0724
23: , p5_a3 NUMBER := 0-1962.0724
24: , p5_a4 DATE := fnd_api.g_miss_date
25: , p5_a5 DATE := fnd_api.g_miss_date
26: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
27: , p5_a7 NUMBER := 0-1962.0724
28: , p5_a8 DATE := fnd_api.g_miss_date
29: , p5_a9 NUMBER := 0-1962.0724
30: , p5_a10 DATE := fnd_api.g_miss_date
24: , p5_a4 DATE := fnd_api.g_miss_date
25: , p5_a5 DATE := fnd_api.g_miss_date
26: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
27: , p5_a7 NUMBER := 0-1962.0724
28: , p5_a8 DATE := fnd_api.g_miss_date
29: , p5_a9 NUMBER := 0-1962.0724
30: , p5_a10 DATE := fnd_api.g_miss_date
31: , p5_a11 NUMBER := 0-1962.0724
32: );
26: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
27: , p5_a7 NUMBER := 0-1962.0724
28: , p5_a8 DATE := fnd_api.g_miss_date
29: , p5_a9 NUMBER := 0-1962.0724
30: , p5_a10 DATE := fnd_api.g_miss_date
31: , p5_a11 NUMBER := 0-1962.0724
32: );
33: procedure insert_product_options(p_api_version NUMBER
34: , p_init_msg_list VARCHAR2
68: , p5_a0 NUMBER := 0-1962.0724
69: , p5_a1 NUMBER := 0-1962.0724
70: , p5_a2 NUMBER := 0-1962.0724
71: , p5_a3 NUMBER := 0-1962.0724
72: , p5_a4 DATE := fnd_api.g_miss_date
73: , p5_a5 DATE := fnd_api.g_miss_date
74: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a7 NUMBER := 0-1962.0724
76: , p5_a8 DATE := fnd_api.g_miss_date
69: , p5_a1 NUMBER := 0-1962.0724
70: , p5_a2 NUMBER := 0-1962.0724
71: , p5_a3 NUMBER := 0-1962.0724
72: , p5_a4 DATE := fnd_api.g_miss_date
73: , p5_a5 DATE := fnd_api.g_miss_date
74: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a7 NUMBER := 0-1962.0724
76: , p5_a8 DATE := fnd_api.g_miss_date
77: , p5_a9 NUMBER := 0-1962.0724
70: , p5_a2 NUMBER := 0-1962.0724
71: , p5_a3 NUMBER := 0-1962.0724
72: , p5_a4 DATE := fnd_api.g_miss_date
73: , p5_a5 DATE := fnd_api.g_miss_date
74: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a7 NUMBER := 0-1962.0724
76: , p5_a8 DATE := fnd_api.g_miss_date
77: , p5_a9 NUMBER := 0-1962.0724
78: , p5_a10 DATE := fnd_api.g_miss_date
72: , p5_a4 DATE := fnd_api.g_miss_date
73: , p5_a5 DATE := fnd_api.g_miss_date
74: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a7 NUMBER := 0-1962.0724
76: , p5_a8 DATE := fnd_api.g_miss_date
77: , p5_a9 NUMBER := 0-1962.0724
78: , p5_a10 DATE := fnd_api.g_miss_date
79: , p5_a11 NUMBER := 0-1962.0724
80: );
74: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a7 NUMBER := 0-1962.0724
76: , p5_a8 DATE := fnd_api.g_miss_date
77: , p5_a9 NUMBER := 0-1962.0724
78: , p5_a10 DATE := fnd_api.g_miss_date
79: , p5_a11 NUMBER := 0-1962.0724
80: );
81: procedure lock_product_options(p_api_version NUMBER
82: , p_init_msg_list VARCHAR2
116: , p5_a0 NUMBER := 0-1962.0724
117: , p5_a1 NUMBER := 0-1962.0724
118: , p5_a2 NUMBER := 0-1962.0724
119: , p5_a3 NUMBER := 0-1962.0724
120: , p5_a4 DATE := fnd_api.g_miss_date
121: , p5_a5 DATE := fnd_api.g_miss_date
122: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 DATE := fnd_api.g_miss_date
117: , p5_a1 NUMBER := 0-1962.0724
118: , p5_a2 NUMBER := 0-1962.0724
119: , p5_a3 NUMBER := 0-1962.0724
120: , p5_a4 DATE := fnd_api.g_miss_date
121: , p5_a5 DATE := fnd_api.g_miss_date
122: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 DATE := fnd_api.g_miss_date
125: , p5_a9 NUMBER := 0-1962.0724
118: , p5_a2 NUMBER := 0-1962.0724
119: , p5_a3 NUMBER := 0-1962.0724
120: , p5_a4 DATE := fnd_api.g_miss_date
121: , p5_a5 DATE := fnd_api.g_miss_date
122: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 DATE := fnd_api.g_miss_date
125: , p5_a9 NUMBER := 0-1962.0724
126: , p5_a10 DATE := fnd_api.g_miss_date
120: , p5_a4 DATE := fnd_api.g_miss_date
121: , p5_a5 DATE := fnd_api.g_miss_date
122: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 DATE := fnd_api.g_miss_date
125: , p5_a9 NUMBER := 0-1962.0724
126: , p5_a10 DATE := fnd_api.g_miss_date
127: , p5_a11 NUMBER := 0-1962.0724
128: );
122: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 DATE := fnd_api.g_miss_date
125: , p5_a9 NUMBER := 0-1962.0724
126: , p5_a10 DATE := fnd_api.g_miss_date
127: , p5_a11 NUMBER := 0-1962.0724
128: );
129: procedure update_product_options(p_api_version NUMBER
130: , p_init_msg_list VARCHAR2
164: , p5_a0 NUMBER := 0-1962.0724
165: , p5_a1 NUMBER := 0-1962.0724
166: , p5_a2 NUMBER := 0-1962.0724
167: , p5_a3 NUMBER := 0-1962.0724
168: , p5_a4 DATE := fnd_api.g_miss_date
169: , p5_a5 DATE := fnd_api.g_miss_date
170: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 DATE := fnd_api.g_miss_date
165: , p5_a1 NUMBER := 0-1962.0724
166: , p5_a2 NUMBER := 0-1962.0724
167: , p5_a3 NUMBER := 0-1962.0724
168: , p5_a4 DATE := fnd_api.g_miss_date
169: , p5_a5 DATE := fnd_api.g_miss_date
170: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 DATE := fnd_api.g_miss_date
173: , p5_a9 NUMBER := 0-1962.0724
166: , p5_a2 NUMBER := 0-1962.0724
167: , p5_a3 NUMBER := 0-1962.0724
168: , p5_a4 DATE := fnd_api.g_miss_date
169: , p5_a5 DATE := fnd_api.g_miss_date
170: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 DATE := fnd_api.g_miss_date
173: , p5_a9 NUMBER := 0-1962.0724
174: , p5_a10 DATE := fnd_api.g_miss_date
168: , p5_a4 DATE := fnd_api.g_miss_date
169: , p5_a5 DATE := fnd_api.g_miss_date
170: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 DATE := fnd_api.g_miss_date
173: , p5_a9 NUMBER := 0-1962.0724
174: , p5_a10 DATE := fnd_api.g_miss_date
175: , p5_a11 NUMBER := 0-1962.0724
176: );
170: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 DATE := fnd_api.g_miss_date
173: , p5_a9 NUMBER := 0-1962.0724
174: , p5_a10 DATE := fnd_api.g_miss_date
175: , p5_a11 NUMBER := 0-1962.0724
176: );
177: procedure delete_product_options(p_api_version NUMBER
178: , p_init_msg_list VARCHAR2
200: , p5_a0 NUMBER := 0-1962.0724
201: , p5_a1 NUMBER := 0-1962.0724
202: , p5_a2 NUMBER := 0-1962.0724
203: , p5_a3 NUMBER := 0-1962.0724
204: , p5_a4 DATE := fnd_api.g_miss_date
205: , p5_a5 DATE := fnd_api.g_miss_date
206: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a8 DATE := fnd_api.g_miss_date
201: , p5_a1 NUMBER := 0-1962.0724
202: , p5_a2 NUMBER := 0-1962.0724
203: , p5_a3 NUMBER := 0-1962.0724
204: , p5_a4 DATE := fnd_api.g_miss_date
205: , p5_a5 DATE := fnd_api.g_miss_date
206: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a8 DATE := fnd_api.g_miss_date
209: , p5_a9 NUMBER := 0-1962.0724
202: , p5_a2 NUMBER := 0-1962.0724
203: , p5_a3 NUMBER := 0-1962.0724
204: , p5_a4 DATE := fnd_api.g_miss_date
205: , p5_a5 DATE := fnd_api.g_miss_date
206: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a8 DATE := fnd_api.g_miss_date
209: , p5_a9 NUMBER := 0-1962.0724
210: , p5_a10 DATE := fnd_api.g_miss_date
204: , p5_a4 DATE := fnd_api.g_miss_date
205: , p5_a5 DATE := fnd_api.g_miss_date
206: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a8 DATE := fnd_api.g_miss_date
209: , p5_a9 NUMBER := 0-1962.0724
210: , p5_a10 DATE := fnd_api.g_miss_date
211: , p5_a11 NUMBER := 0-1962.0724
212: );
206: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a8 DATE := fnd_api.g_miss_date
209: , p5_a9 NUMBER := 0-1962.0724
210: , p5_a10 DATE := fnd_api.g_miss_date
211: , p5_a11 NUMBER := 0-1962.0724
212: );
213: procedure validate_product_options(p_api_version NUMBER
214: , p_init_msg_list VARCHAR2