67: , p6_a9 out nocopy DATE
68: , p6_a10 out nocopy NUMBER
69: , p5_a0 NUMBER := 0-1962.0724
70: , p5_a1 NUMBER := 0-1962.0724
71: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 DATE := fnd_api.g_miss_date
74: , p5_a5 DATE := fnd_api.g_miss_date
75: , p5_a6 NUMBER := 0-1962.0724
68: , p6_a10 out nocopy NUMBER
69: , p5_a0 NUMBER := 0-1962.0724
70: , p5_a1 NUMBER := 0-1962.0724
71: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 DATE := fnd_api.g_miss_date
74: , p5_a5 DATE := fnd_api.g_miss_date
75: , p5_a6 NUMBER := 0-1962.0724
76: , p5_a7 DATE := fnd_api.g_miss_date
69: , p5_a0 NUMBER := 0-1962.0724
70: , p5_a1 NUMBER := 0-1962.0724
71: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 DATE := fnd_api.g_miss_date
74: , p5_a5 DATE := fnd_api.g_miss_date
75: , p5_a6 NUMBER := 0-1962.0724
76: , p5_a7 DATE := fnd_api.g_miss_date
77: , p5_a8 NUMBER := 0-1962.0724
70: , p5_a1 NUMBER := 0-1962.0724
71: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 DATE := fnd_api.g_miss_date
74: , p5_a5 DATE := fnd_api.g_miss_date
75: , p5_a6 NUMBER := 0-1962.0724
76: , p5_a7 DATE := fnd_api.g_miss_date
77: , p5_a8 NUMBER := 0-1962.0724
78: , p5_a9 DATE := fnd_api.g_miss_date
72: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a4 DATE := fnd_api.g_miss_date
74: , p5_a5 DATE := fnd_api.g_miss_date
75: , p5_a6 NUMBER := 0-1962.0724
76: , p5_a7 DATE := fnd_api.g_miss_date
77: , p5_a8 NUMBER := 0-1962.0724
78: , p5_a9 DATE := fnd_api.g_miss_date
79: , p5_a10 NUMBER := 0-1962.0724
80: );
74: , p5_a5 DATE := fnd_api.g_miss_date
75: , p5_a6 NUMBER := 0-1962.0724
76: , p5_a7 DATE := fnd_api.g_miss_date
77: , p5_a8 NUMBER := 0-1962.0724
78: , p5_a9 DATE := fnd_api.g_miss_date
79: , p5_a10 NUMBER := 0-1962.0724
80: );
81: procedure insert_row(p_api_version NUMBER
82: , p_init_msg_list VARCHAR2
112: , x_msg_count out nocopy NUMBER
113: , x_msg_data out nocopy VARCHAR2
114: , p5_a0 NUMBER := 0-1962.0724
115: , p5_a1 NUMBER := 0-1962.0724
116: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a4 DATE := fnd_api.g_miss_date
119: , p5_a5 DATE := fnd_api.g_miss_date
120: , p5_a6 NUMBER := 0-1962.0724
113: , x_msg_data out nocopy VARCHAR2
114: , p5_a0 NUMBER := 0-1962.0724
115: , p5_a1 NUMBER := 0-1962.0724
116: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a4 DATE := fnd_api.g_miss_date
119: , p5_a5 DATE := fnd_api.g_miss_date
120: , p5_a6 NUMBER := 0-1962.0724
121: , p5_a7 DATE := fnd_api.g_miss_date
114: , p5_a0 NUMBER := 0-1962.0724
115: , p5_a1 NUMBER := 0-1962.0724
116: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a4 DATE := fnd_api.g_miss_date
119: , p5_a5 DATE := fnd_api.g_miss_date
120: , p5_a6 NUMBER := 0-1962.0724
121: , p5_a7 DATE := fnd_api.g_miss_date
122: , p5_a8 NUMBER := 0-1962.0724
115: , p5_a1 NUMBER := 0-1962.0724
116: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a4 DATE := fnd_api.g_miss_date
119: , p5_a5 DATE := fnd_api.g_miss_date
120: , p5_a6 NUMBER := 0-1962.0724
121: , p5_a7 DATE := fnd_api.g_miss_date
122: , p5_a8 NUMBER := 0-1962.0724
123: , p5_a9 DATE := fnd_api.g_miss_date
117: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a4 DATE := fnd_api.g_miss_date
119: , p5_a5 DATE := fnd_api.g_miss_date
120: , p5_a6 NUMBER := 0-1962.0724
121: , p5_a7 DATE := fnd_api.g_miss_date
122: , p5_a8 NUMBER := 0-1962.0724
123: , p5_a9 DATE := fnd_api.g_miss_date
124: , p5_a10 NUMBER := 0-1962.0724
125: );
119: , p5_a5 DATE := fnd_api.g_miss_date
120: , p5_a6 NUMBER := 0-1962.0724
121: , p5_a7 DATE := fnd_api.g_miss_date
122: , p5_a8 NUMBER := 0-1962.0724
123: , p5_a9 DATE := fnd_api.g_miss_date
124: , p5_a10 NUMBER := 0-1962.0724
125: );
126: procedure lock_row(p_api_version NUMBER
127: , p_init_msg_list VARCHAR2
157: , p6_a9 out nocopy DATE
158: , p6_a10 out nocopy NUMBER
159: , p5_a0 NUMBER := 0-1962.0724
160: , p5_a1 NUMBER := 0-1962.0724
161: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a4 DATE := fnd_api.g_miss_date
164: , p5_a5 DATE := fnd_api.g_miss_date
165: , p5_a6 NUMBER := 0-1962.0724
158: , p6_a10 out nocopy NUMBER
159: , p5_a0 NUMBER := 0-1962.0724
160: , p5_a1 NUMBER := 0-1962.0724
161: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a4 DATE := fnd_api.g_miss_date
164: , p5_a5 DATE := fnd_api.g_miss_date
165: , p5_a6 NUMBER := 0-1962.0724
166: , p5_a7 DATE := fnd_api.g_miss_date
159: , p5_a0 NUMBER := 0-1962.0724
160: , p5_a1 NUMBER := 0-1962.0724
161: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a4 DATE := fnd_api.g_miss_date
164: , p5_a5 DATE := fnd_api.g_miss_date
165: , p5_a6 NUMBER := 0-1962.0724
166: , p5_a7 DATE := fnd_api.g_miss_date
167: , p5_a8 NUMBER := 0-1962.0724
160: , p5_a1 NUMBER := 0-1962.0724
161: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a4 DATE := fnd_api.g_miss_date
164: , p5_a5 DATE := fnd_api.g_miss_date
165: , p5_a6 NUMBER := 0-1962.0724
166: , p5_a7 DATE := fnd_api.g_miss_date
167: , p5_a8 NUMBER := 0-1962.0724
168: , p5_a9 DATE := fnd_api.g_miss_date
162: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a4 DATE := fnd_api.g_miss_date
164: , p5_a5 DATE := fnd_api.g_miss_date
165: , p5_a6 NUMBER := 0-1962.0724
166: , p5_a7 DATE := fnd_api.g_miss_date
167: , p5_a8 NUMBER := 0-1962.0724
168: , p5_a9 DATE := fnd_api.g_miss_date
169: , p5_a10 NUMBER := 0-1962.0724
170: );
164: , p5_a5 DATE := fnd_api.g_miss_date
165: , p5_a6 NUMBER := 0-1962.0724
166: , p5_a7 DATE := fnd_api.g_miss_date
167: , p5_a8 NUMBER := 0-1962.0724
168: , p5_a9 DATE := fnd_api.g_miss_date
169: , p5_a10 NUMBER := 0-1962.0724
170: );
171: procedure update_row(p_api_version NUMBER
172: , p_init_msg_list VARCHAR2
202: , x_msg_count out nocopy NUMBER
203: , x_msg_data out nocopy VARCHAR2
204: , p5_a0 NUMBER := 0-1962.0724
205: , p5_a1 NUMBER := 0-1962.0724
206: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a4 DATE := fnd_api.g_miss_date
209: , p5_a5 DATE := fnd_api.g_miss_date
210: , p5_a6 NUMBER := 0-1962.0724
203: , x_msg_data out nocopy VARCHAR2
204: , p5_a0 NUMBER := 0-1962.0724
205: , p5_a1 NUMBER := 0-1962.0724
206: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a4 DATE := fnd_api.g_miss_date
209: , p5_a5 DATE := fnd_api.g_miss_date
210: , p5_a6 NUMBER := 0-1962.0724
211: , p5_a7 DATE := fnd_api.g_miss_date
204: , p5_a0 NUMBER := 0-1962.0724
205: , p5_a1 NUMBER := 0-1962.0724
206: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a4 DATE := fnd_api.g_miss_date
209: , p5_a5 DATE := fnd_api.g_miss_date
210: , p5_a6 NUMBER := 0-1962.0724
211: , p5_a7 DATE := fnd_api.g_miss_date
212: , p5_a8 NUMBER := 0-1962.0724
205: , p5_a1 NUMBER := 0-1962.0724
206: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a4 DATE := fnd_api.g_miss_date
209: , p5_a5 DATE := fnd_api.g_miss_date
210: , p5_a6 NUMBER := 0-1962.0724
211: , p5_a7 DATE := fnd_api.g_miss_date
212: , p5_a8 NUMBER := 0-1962.0724
213: , p5_a9 DATE := fnd_api.g_miss_date
207: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a4 DATE := fnd_api.g_miss_date
209: , p5_a5 DATE := fnd_api.g_miss_date
210: , p5_a6 NUMBER := 0-1962.0724
211: , p5_a7 DATE := fnd_api.g_miss_date
212: , p5_a8 NUMBER := 0-1962.0724
213: , p5_a9 DATE := fnd_api.g_miss_date
214: , p5_a10 NUMBER := 0-1962.0724
215: );
209: , p5_a5 DATE := fnd_api.g_miss_date
210: , p5_a6 NUMBER := 0-1962.0724
211: , p5_a7 DATE := fnd_api.g_miss_date
212: , p5_a8 NUMBER := 0-1962.0724
213: , p5_a9 DATE := fnd_api.g_miss_date
214: , p5_a10 NUMBER := 0-1962.0724
215: );
216: procedure delete_row(p_api_version NUMBER
217: , p_init_msg_list VARCHAR2
236: , x_msg_count out nocopy NUMBER
237: , x_msg_data out nocopy VARCHAR2
238: , p5_a0 NUMBER := 0-1962.0724
239: , p5_a1 NUMBER := 0-1962.0724
240: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a4 DATE := fnd_api.g_miss_date
243: , p5_a5 DATE := fnd_api.g_miss_date
244: , p5_a6 NUMBER := 0-1962.0724
237: , x_msg_data out nocopy VARCHAR2
238: , p5_a0 NUMBER := 0-1962.0724
239: , p5_a1 NUMBER := 0-1962.0724
240: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a4 DATE := fnd_api.g_miss_date
243: , p5_a5 DATE := fnd_api.g_miss_date
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
238: , p5_a0 NUMBER := 0-1962.0724
239: , p5_a1 NUMBER := 0-1962.0724
240: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a4 DATE := fnd_api.g_miss_date
243: , p5_a5 DATE := fnd_api.g_miss_date
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 NUMBER := 0-1962.0724
239: , p5_a1 NUMBER := 0-1962.0724
240: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a4 DATE := fnd_api.g_miss_date
243: , p5_a5 DATE := fnd_api.g_miss_date
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 NUMBER := 0-1962.0724
247: , p5_a9 DATE := fnd_api.g_miss_date
241: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a4 DATE := fnd_api.g_miss_date
243: , p5_a5 DATE := fnd_api.g_miss_date
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 NUMBER := 0-1962.0724
247: , p5_a9 DATE := fnd_api.g_miss_date
248: , p5_a10 NUMBER := 0-1962.0724
249: );
243: , p5_a5 DATE := fnd_api.g_miss_date
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 NUMBER := 0-1962.0724
247: , p5_a9 DATE := fnd_api.g_miss_date
248: , p5_a10 NUMBER := 0-1962.0724
249: );
250: procedure validate_row(p_api_version NUMBER
251: , p_init_msg_list VARCHAR2