72: , p6_a10 out nocopy DATE
73: , p6_a11 out nocopy NUMBER
74: , p5_a0 NUMBER := 0-1962.0724
75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 DATE := fnd_api.g_miss_date
80: , p5_a6 DATE := fnd_api.g_miss_date
73: , p6_a11 out nocopy NUMBER
74: , p5_a0 NUMBER := 0-1962.0724
75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 DATE := fnd_api.g_miss_date
80: , p5_a6 DATE := fnd_api.g_miss_date
81: , p5_a7 NUMBER := 0-1962.0724
74: , p5_a0 NUMBER := 0-1962.0724
75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 DATE := fnd_api.g_miss_date
80: , p5_a6 DATE := fnd_api.g_miss_date
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date
75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 DATE := fnd_api.g_miss_date
80: , p5_a6 DATE := fnd_api.g_miss_date
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date
83: , p5_a9 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 DATE := fnd_api.g_miss_date
80: , p5_a6 DATE := fnd_api.g_miss_date
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date
83: , p5_a9 NUMBER := 0-1962.0724
84: , p5_a10 DATE := fnd_api.g_miss_date
78: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a5 DATE := fnd_api.g_miss_date
80: , p5_a6 DATE := fnd_api.g_miss_date
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date
83: , p5_a9 NUMBER := 0-1962.0724
84: , p5_a10 DATE := fnd_api.g_miss_date
85: , p5_a11 NUMBER := 0-1962.0724
86: );
80: , p5_a6 DATE := fnd_api.g_miss_date
81: , p5_a7 NUMBER := 0-1962.0724
82: , p5_a8 DATE := fnd_api.g_miss_date
83: , p5_a9 NUMBER := 0-1962.0724
84: , p5_a10 DATE := fnd_api.g_miss_date
85: , p5_a11 NUMBER := 0-1962.0724
86: );
87: procedure insert_row(p_api_version NUMBER
88: , p_init_msg_list VARCHAR2
120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p5_a0 NUMBER := 0-1962.0724
123: , p5_a1 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 DATE := fnd_api.g_miss_date
128: , p5_a6 DATE := fnd_api.g_miss_date
121: , x_msg_data out nocopy VARCHAR2
122: , p5_a0 NUMBER := 0-1962.0724
123: , p5_a1 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 DATE := fnd_api.g_miss_date
128: , p5_a6 DATE := fnd_api.g_miss_date
129: , p5_a7 NUMBER := 0-1962.0724
122: , p5_a0 NUMBER := 0-1962.0724
123: , p5_a1 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 DATE := fnd_api.g_miss_date
128: , p5_a6 DATE := fnd_api.g_miss_date
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date
123: , p5_a1 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 DATE := fnd_api.g_miss_date
128: , p5_a6 DATE := fnd_api.g_miss_date
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date
131: , p5_a9 NUMBER := 0-1962.0724
124: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 DATE := fnd_api.g_miss_date
128: , p5_a6 DATE := fnd_api.g_miss_date
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date
131: , p5_a9 NUMBER := 0-1962.0724
132: , p5_a10 DATE := fnd_api.g_miss_date
126: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a5 DATE := fnd_api.g_miss_date
128: , p5_a6 DATE := fnd_api.g_miss_date
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date
131: , p5_a9 NUMBER := 0-1962.0724
132: , p5_a10 DATE := fnd_api.g_miss_date
133: , p5_a11 NUMBER := 0-1962.0724
134: );
128: , p5_a6 DATE := fnd_api.g_miss_date
129: , p5_a7 NUMBER := 0-1962.0724
130: , p5_a8 DATE := fnd_api.g_miss_date
131: , p5_a9 NUMBER := 0-1962.0724
132: , p5_a10 DATE := fnd_api.g_miss_date
133: , p5_a11 NUMBER := 0-1962.0724
134: );
135: procedure lock_row(p_api_version NUMBER
136: , p_init_msg_list VARCHAR2
168: , p6_a10 out nocopy DATE
169: , p6_a11 out nocopy NUMBER
170: , p5_a0 NUMBER := 0-1962.0724
171: , p5_a1 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 DATE := fnd_api.g_miss_date
176: , p5_a6 DATE := fnd_api.g_miss_date
169: , p6_a11 out nocopy NUMBER
170: , p5_a0 NUMBER := 0-1962.0724
171: , p5_a1 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 DATE := fnd_api.g_miss_date
176: , p5_a6 DATE := fnd_api.g_miss_date
177: , p5_a7 NUMBER := 0-1962.0724
170: , p5_a0 NUMBER := 0-1962.0724
171: , p5_a1 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 DATE := fnd_api.g_miss_date
176: , p5_a6 DATE := fnd_api.g_miss_date
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date
171: , p5_a1 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 DATE := fnd_api.g_miss_date
176: , p5_a6 DATE := fnd_api.g_miss_date
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date
179: , p5_a9 NUMBER := 0-1962.0724
172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 DATE := fnd_api.g_miss_date
176: , p5_a6 DATE := fnd_api.g_miss_date
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date
179: , p5_a9 NUMBER := 0-1962.0724
180: , p5_a10 DATE := fnd_api.g_miss_date
174: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a5 DATE := fnd_api.g_miss_date
176: , p5_a6 DATE := fnd_api.g_miss_date
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date
179: , p5_a9 NUMBER := 0-1962.0724
180: , p5_a10 DATE := fnd_api.g_miss_date
181: , p5_a11 NUMBER := 0-1962.0724
182: );
176: , p5_a6 DATE := fnd_api.g_miss_date
177: , p5_a7 NUMBER := 0-1962.0724
178: , p5_a8 DATE := fnd_api.g_miss_date
179: , p5_a9 NUMBER := 0-1962.0724
180: , p5_a10 DATE := fnd_api.g_miss_date
181: , p5_a11 NUMBER := 0-1962.0724
182: );
183: procedure update_row(p_api_version NUMBER
184: , p_init_msg_list VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 NUMBER := 0-1962.0724
219: , p5_a1 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 DATE := fnd_api.g_miss_date
224: , p5_a6 DATE := fnd_api.g_miss_date
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 NUMBER := 0-1962.0724
219: , p5_a1 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 DATE := fnd_api.g_miss_date
224: , p5_a6 DATE := fnd_api.g_miss_date
225: , p5_a7 NUMBER := 0-1962.0724
218: , p5_a0 NUMBER := 0-1962.0724
219: , p5_a1 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 DATE := fnd_api.g_miss_date
224: , p5_a6 DATE := fnd_api.g_miss_date
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date
219: , p5_a1 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 DATE := fnd_api.g_miss_date
224: , p5_a6 DATE := fnd_api.g_miss_date
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date
227: , p5_a9 NUMBER := 0-1962.0724
220: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 DATE := fnd_api.g_miss_date
224: , p5_a6 DATE := fnd_api.g_miss_date
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date
227: , p5_a9 NUMBER := 0-1962.0724
228: , p5_a10 DATE := fnd_api.g_miss_date
222: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a5 DATE := fnd_api.g_miss_date
224: , p5_a6 DATE := fnd_api.g_miss_date
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date
227: , p5_a9 NUMBER := 0-1962.0724
228: , p5_a10 DATE := fnd_api.g_miss_date
229: , p5_a11 NUMBER := 0-1962.0724
230: );
224: , p5_a6 DATE := fnd_api.g_miss_date
225: , p5_a7 NUMBER := 0-1962.0724
226: , p5_a8 DATE := fnd_api.g_miss_date
227: , p5_a9 NUMBER := 0-1962.0724
228: , p5_a10 DATE := fnd_api.g_miss_date
229: , p5_a11 NUMBER := 0-1962.0724
230: );
231: procedure delete_row(p_api_version NUMBER
232: , p_init_msg_list VARCHAR2
252: , x_msg_count out nocopy NUMBER
253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 NUMBER := 0-1962.0724
255: , p5_a1 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 DATE := fnd_api.g_miss_date
260: , p5_a6 DATE := fnd_api.g_miss_date
253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 NUMBER := 0-1962.0724
255: , p5_a1 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 DATE := fnd_api.g_miss_date
260: , p5_a6 DATE := fnd_api.g_miss_date
261: , p5_a7 NUMBER := 0-1962.0724
254: , p5_a0 NUMBER := 0-1962.0724
255: , p5_a1 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 DATE := fnd_api.g_miss_date
260: , p5_a6 DATE := fnd_api.g_miss_date
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date
255: , p5_a1 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 DATE := fnd_api.g_miss_date
260: , p5_a6 DATE := fnd_api.g_miss_date
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date
263: , p5_a9 NUMBER := 0-1962.0724
256: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 DATE := fnd_api.g_miss_date
260: , p5_a6 DATE := fnd_api.g_miss_date
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date
263: , p5_a9 NUMBER := 0-1962.0724
264: , p5_a10 DATE := fnd_api.g_miss_date
258: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a5 DATE := fnd_api.g_miss_date
260: , p5_a6 DATE := fnd_api.g_miss_date
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date
263: , p5_a9 NUMBER := 0-1962.0724
264: , p5_a10 DATE := fnd_api.g_miss_date
265: , p5_a11 NUMBER := 0-1962.0724
266: );
260: , p5_a6 DATE := fnd_api.g_miss_date
261: , p5_a7 NUMBER := 0-1962.0724
262: , p5_a8 DATE := fnd_api.g_miss_date
263: , p5_a9 NUMBER := 0-1962.0724
264: , p5_a10 DATE := fnd_api.g_miss_date
265: , p5_a11 NUMBER := 0-1962.0724
266: );
267: procedure validate_row(p_api_version NUMBER
268: , p_init_msg_list VARCHAR2