20: , p6_a12 out nocopy DATE
21: , p6_a13 out nocopy NUMBER
22: , p5_a0 NUMBER := 0-1962.0724
23: , p5_a1 NUMBER := 0-1962.0724
24: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
25: , p5_a3 NUMBER := 0-1962.0724
26: , p5_a4 NUMBER := 0-1962.0724
27: , p5_a5 NUMBER := 0-1962.0724
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
24: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
25: , p5_a3 NUMBER := 0-1962.0724
26: , p5_a4 NUMBER := 0-1962.0724
27: , p5_a5 NUMBER := 0-1962.0724
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
25: , p5_a3 NUMBER := 0-1962.0724
26: , p5_a4 NUMBER := 0-1962.0724
27: , p5_a5 NUMBER := 0-1962.0724
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
33: , p5_a11 NUMBER := 0-1962.0724
26: , p5_a4 NUMBER := 0-1962.0724
27: , p5_a5 NUMBER := 0-1962.0724
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
33: , p5_a11 NUMBER := 0-1962.0724
34: , p5_a12 DATE := fnd_api.g_miss_date
28: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
33: , p5_a11 NUMBER := 0-1962.0724
34: , p5_a12 DATE := fnd_api.g_miss_date
35: , p5_a13 NUMBER := 0-1962.0724
36: );
30: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
31: , p5_a9 NUMBER := 0-1962.0724
32: , p5_a10 DATE := fnd_api.g_miss_date
33: , p5_a11 NUMBER := 0-1962.0724
34: , p5_a12 DATE := fnd_api.g_miss_date
35: , p5_a13 NUMBER := 0-1962.0724
36: );
37: procedure insert_fnctn_prmtrs(p_api_version NUMBER
38: , p_init_msg_list VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p5_a0 NUMBER := 0-1962.0724
77: , p5_a1 NUMBER := 0-1962.0724
78: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a3 NUMBER := 0-1962.0724
80: , p5_a4 NUMBER := 0-1962.0724
81: , p5_a5 NUMBER := 0-1962.0724
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a3 NUMBER := 0-1962.0724
80: , p5_a4 NUMBER := 0-1962.0724
81: , p5_a5 NUMBER := 0-1962.0724
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
79: , p5_a3 NUMBER := 0-1962.0724
80: , p5_a4 NUMBER := 0-1962.0724
81: , p5_a5 NUMBER := 0-1962.0724
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
87: , p5_a11 NUMBER := 0-1962.0724
80: , p5_a4 NUMBER := 0-1962.0724
81: , p5_a5 NUMBER := 0-1962.0724
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
87: , p5_a11 NUMBER := 0-1962.0724
88: , p5_a12 DATE := fnd_api.g_miss_date
82: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
87: , p5_a11 NUMBER := 0-1962.0724
88: , p5_a12 DATE := fnd_api.g_miss_date
89: , p5_a13 NUMBER := 0-1962.0724
90: );
84: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a9 NUMBER := 0-1962.0724
86: , p5_a10 DATE := fnd_api.g_miss_date
87: , p5_a11 NUMBER := 0-1962.0724
88: , p5_a12 DATE := fnd_api.g_miss_date
89: , p5_a13 NUMBER := 0-1962.0724
90: );
91: procedure lock_fnctn_prmtrs(p_api_version NUMBER
92: , p_init_msg_list VARCHAR2
128: , p6_a12 out nocopy DATE
129: , p6_a13 out nocopy NUMBER
130: , p5_a0 NUMBER := 0-1962.0724
131: , p5_a1 NUMBER := 0-1962.0724
132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a3 NUMBER := 0-1962.0724
134: , p5_a4 NUMBER := 0-1962.0724
135: , p5_a5 NUMBER := 0-1962.0724
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a3 NUMBER := 0-1962.0724
134: , p5_a4 NUMBER := 0-1962.0724
135: , p5_a5 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 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a9 NUMBER := 0-1962.0724
140: , p5_a10 DATE := fnd_api.g_miss_date
133: , p5_a3 NUMBER := 0-1962.0724
134: , p5_a4 NUMBER := 0-1962.0724
135: , p5_a5 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 VARCHAR2 := fnd_api.g_miss_char
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 NUMBER := 0-1962.0724
135: , p5_a5 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 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
136: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
143: , p5_a13 NUMBER := 0-1962.0724
144: );
138: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
143: , p5_a13 NUMBER := 0-1962.0724
144: );
145: procedure update_fnctn_prmtrs(p_api_version NUMBER
146: , p_init_msg_list VARCHAR2
182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 NUMBER := 0-1962.0724
185: , p5_a1 NUMBER := 0-1962.0724
186: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a3 NUMBER := 0-1962.0724
188: , p5_a4 NUMBER := 0-1962.0724
189: , p5_a5 NUMBER := 0-1962.0724
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a3 NUMBER := 0-1962.0724
188: , p5_a4 NUMBER := 0-1962.0724
189: , p5_a5 NUMBER := 0-1962.0724
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
187: , p5_a3 NUMBER := 0-1962.0724
188: , p5_a4 NUMBER := 0-1962.0724
189: , p5_a5 NUMBER := 0-1962.0724
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
195: , p5_a11 NUMBER := 0-1962.0724
188: , p5_a4 NUMBER := 0-1962.0724
189: , p5_a5 NUMBER := 0-1962.0724
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
195: , p5_a11 NUMBER := 0-1962.0724
196: , p5_a12 DATE := fnd_api.g_miss_date
190: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
195: , p5_a11 NUMBER := 0-1962.0724
196: , p5_a12 DATE := fnd_api.g_miss_date
197: , p5_a13 NUMBER := 0-1962.0724
198: );
192: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a9 NUMBER := 0-1962.0724
194: , p5_a10 DATE := fnd_api.g_miss_date
195: , p5_a11 NUMBER := 0-1962.0724
196: , p5_a12 DATE := fnd_api.g_miss_date
197: , p5_a13 NUMBER := 0-1962.0724
198: );
199: procedure delete_fnctn_prmtrs(p_api_version NUMBER
200: , p_init_msg_list VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 NUMBER := 0-1962.0724
225: , p5_a1 NUMBER := 0-1962.0724
226: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a3 NUMBER := 0-1962.0724
228: , p5_a4 NUMBER := 0-1962.0724
229: , p5_a5 NUMBER := 0-1962.0724
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a3 NUMBER := 0-1962.0724
228: , p5_a4 NUMBER := 0-1962.0724
229: , p5_a5 NUMBER := 0-1962.0724
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
227: , p5_a3 NUMBER := 0-1962.0724
228: , p5_a4 NUMBER := 0-1962.0724
229: , p5_a5 NUMBER := 0-1962.0724
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
235: , p5_a11 NUMBER := 0-1962.0724
228: , p5_a4 NUMBER := 0-1962.0724
229: , p5_a5 NUMBER := 0-1962.0724
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
235: , p5_a11 NUMBER := 0-1962.0724
236: , p5_a12 DATE := fnd_api.g_miss_date
230: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
235: , p5_a11 NUMBER := 0-1962.0724
236: , p5_a12 DATE := fnd_api.g_miss_date
237: , p5_a13 NUMBER := 0-1962.0724
238: );
232: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a9 NUMBER := 0-1962.0724
234: , p5_a10 DATE := fnd_api.g_miss_date
235: , p5_a11 NUMBER := 0-1962.0724
236: , p5_a12 DATE := fnd_api.g_miss_date
237: , p5_a13 NUMBER := 0-1962.0724
238: );
239: procedure validate_fnctn_prmtrs(p_api_version NUMBER
240: , p_init_msg_list VARCHAR2