34: , p6_a26 out nocopy DATE
35: , p6_a27 out nocopy DATE
36: , p6_a28 out nocopy NUMBER
37: , p5_a0 NUMBER := 0-1962.0724
38: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
35: , p6_a27 out nocopy DATE
36: , p6_a28 out nocopy NUMBER
37: , p5_a0 NUMBER := 0-1962.0724
38: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
36: , p6_a28 out nocopy NUMBER
37: , p5_a0 NUMBER := 0-1962.0724
38: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p5_a0 NUMBER := 0-1962.0724
38: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
43: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a23 NUMBER := 0-1962.0724
53: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a23 NUMBER := 0-1962.0724
61: , p5_a24 NUMBER := 0-1962.0724
54: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a23 NUMBER := 0-1962.0724
61: , p5_a24 NUMBER := 0-1962.0724
62: , p5_a25 NUMBER := 0-1962.0724
55: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a23 NUMBER := 0-1962.0724
61: , p5_a24 NUMBER := 0-1962.0724
62: , p5_a25 NUMBER := 0-1962.0724
63: , p5_a26 DATE := fnd_api.g_miss_date
59: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a23 NUMBER := 0-1962.0724
61: , p5_a24 NUMBER := 0-1962.0724
62: , p5_a25 NUMBER := 0-1962.0724
63: , p5_a26 DATE := fnd_api.g_miss_date
64: , p5_a27 DATE := fnd_api.g_miss_date
65: , p5_a28 NUMBER := 0-1962.0724
66: );
67: procedure insert_sif_ret_errors(p_api_version NUMBER
60: , p5_a23 NUMBER := 0-1962.0724
61: , p5_a24 NUMBER := 0-1962.0724
62: , p5_a25 NUMBER := 0-1962.0724
63: , p5_a26 DATE := fnd_api.g_miss_date
64: , p5_a27 DATE := fnd_api.g_miss_date
65: , p5_a28 NUMBER := 0-1962.0724
66: );
67: procedure insert_sif_ret_errors(p_api_version NUMBER
68: , p_init_msg_list VARCHAR2
133: , x_return_status out nocopy VARCHAR2
134: , x_msg_count out nocopy NUMBER
135: , x_msg_data out nocopy VARCHAR2
136: , p5_a0 NUMBER := 0-1962.0724
137: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a5 NUMBER := 0-1962.0724
134: , x_msg_count out nocopy NUMBER
135: , x_msg_data out nocopy VARCHAR2
136: , p5_a0 NUMBER := 0-1962.0724
137: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a5 NUMBER := 0-1962.0724
142: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
135: , x_msg_data out nocopy VARCHAR2
136: , p5_a0 NUMBER := 0-1962.0724
137: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a5 NUMBER := 0-1962.0724
142: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a0 NUMBER := 0-1962.0724
137: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a5 NUMBER := 0-1962.0724
142: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a5 NUMBER := 0-1962.0724
142: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a5 NUMBER := 0-1962.0724
142: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a5 NUMBER := 0-1962.0724
142: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a5 NUMBER := 0-1962.0724
142: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a23 NUMBER := 0-1962.0724
152: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a23 NUMBER := 0-1962.0724
160: , p5_a24 NUMBER := 0-1962.0724
153: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a23 NUMBER := 0-1962.0724
160: , p5_a24 NUMBER := 0-1962.0724
161: , p5_a25 NUMBER := 0-1962.0724
154: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a23 NUMBER := 0-1962.0724
160: , p5_a24 NUMBER := 0-1962.0724
161: , p5_a25 NUMBER := 0-1962.0724
162: , p5_a26 DATE := fnd_api.g_miss_date
158: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a23 NUMBER := 0-1962.0724
160: , p5_a24 NUMBER := 0-1962.0724
161: , p5_a25 NUMBER := 0-1962.0724
162: , p5_a26 DATE := fnd_api.g_miss_date
163: , p5_a27 DATE := fnd_api.g_miss_date
164: , p5_a28 NUMBER := 0-1962.0724
165: );
166: procedure lock_sif_ret_errors(p_api_version NUMBER
159: , p5_a23 NUMBER := 0-1962.0724
160: , p5_a24 NUMBER := 0-1962.0724
161: , p5_a25 NUMBER := 0-1962.0724
162: , p5_a26 DATE := fnd_api.g_miss_date
163: , p5_a27 DATE := fnd_api.g_miss_date
164: , p5_a28 NUMBER := 0-1962.0724
165: );
166: procedure lock_sif_ret_errors(p_api_version NUMBER
167: , p_init_msg_list VARCHAR2
232: , p6_a26 out nocopy DATE
233: , p6_a27 out nocopy DATE
234: , p6_a28 out nocopy NUMBER
235: , p5_a0 NUMBER := 0-1962.0724
236: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a5 NUMBER := 0-1962.0724
233: , p6_a27 out nocopy DATE
234: , p6_a28 out nocopy NUMBER
235: , p5_a0 NUMBER := 0-1962.0724
236: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a5 NUMBER := 0-1962.0724
241: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
234: , p6_a28 out nocopy NUMBER
235: , p5_a0 NUMBER := 0-1962.0724
236: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a5 NUMBER := 0-1962.0724
241: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a0 NUMBER := 0-1962.0724
236: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a5 NUMBER := 0-1962.0724
241: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a5 NUMBER := 0-1962.0724
241: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a5 NUMBER := 0-1962.0724
241: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a5 NUMBER := 0-1962.0724
241: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a5 NUMBER := 0-1962.0724
241: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a23 NUMBER := 0-1962.0724
251: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a23 NUMBER := 0-1962.0724
259: , p5_a24 NUMBER := 0-1962.0724
252: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a23 NUMBER := 0-1962.0724
259: , p5_a24 NUMBER := 0-1962.0724
260: , p5_a25 NUMBER := 0-1962.0724
253: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a23 NUMBER := 0-1962.0724
259: , p5_a24 NUMBER := 0-1962.0724
260: , p5_a25 NUMBER := 0-1962.0724
261: , p5_a26 DATE := fnd_api.g_miss_date
257: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a23 NUMBER := 0-1962.0724
259: , p5_a24 NUMBER := 0-1962.0724
260: , p5_a25 NUMBER := 0-1962.0724
261: , p5_a26 DATE := fnd_api.g_miss_date
262: , p5_a27 DATE := fnd_api.g_miss_date
263: , p5_a28 NUMBER := 0-1962.0724
264: );
265: procedure update_sif_ret_errors(p_api_version NUMBER
258: , p5_a23 NUMBER := 0-1962.0724
259: , p5_a24 NUMBER := 0-1962.0724
260: , p5_a25 NUMBER := 0-1962.0724
261: , p5_a26 DATE := fnd_api.g_miss_date
262: , p5_a27 DATE := fnd_api.g_miss_date
263: , p5_a28 NUMBER := 0-1962.0724
264: );
265: procedure update_sif_ret_errors(p_api_version NUMBER
266: , p_init_msg_list VARCHAR2
360: , p6_a26 out nocopy DATE
361: , p6_a27 out nocopy DATE
362: , p6_a28 out nocopy NUMBER
363: , p5_a0 NUMBER := 0-1962.0724
364: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a5 NUMBER := 0-1962.0724
361: , p6_a27 out nocopy DATE
362: , p6_a28 out nocopy NUMBER
363: , p5_a0 NUMBER := 0-1962.0724
364: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a5 NUMBER := 0-1962.0724
369: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
362: , p6_a28 out nocopy NUMBER
363: , p5_a0 NUMBER := 0-1962.0724
364: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a5 NUMBER := 0-1962.0724
369: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a0 NUMBER := 0-1962.0724
364: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a5 NUMBER := 0-1962.0724
369: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a5 NUMBER := 0-1962.0724
369: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a5 NUMBER := 0-1962.0724
369: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a5 NUMBER := 0-1962.0724
369: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a5 NUMBER := 0-1962.0724
369: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a23 NUMBER := 0-1962.0724
379: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a23 NUMBER := 0-1962.0724
387: , p5_a24 NUMBER := 0-1962.0724
380: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a23 NUMBER := 0-1962.0724
387: , p5_a24 NUMBER := 0-1962.0724
388: , p5_a25 NUMBER := 0-1962.0724
381: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a23 NUMBER := 0-1962.0724
387: , p5_a24 NUMBER := 0-1962.0724
388: , p5_a25 NUMBER := 0-1962.0724
389: , p5_a26 DATE := fnd_api.g_miss_date
385: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a23 NUMBER := 0-1962.0724
387: , p5_a24 NUMBER := 0-1962.0724
388: , p5_a25 NUMBER := 0-1962.0724
389: , p5_a26 DATE := fnd_api.g_miss_date
390: , p5_a27 DATE := fnd_api.g_miss_date
391: , p5_a28 NUMBER := 0-1962.0724
392: );
393: procedure delete_sif_ret_errors(p_api_version NUMBER
386: , p5_a23 NUMBER := 0-1962.0724
387: , p5_a24 NUMBER := 0-1962.0724
388: , p5_a25 NUMBER := 0-1962.0724
389: , p5_a26 DATE := fnd_api.g_miss_date
390: , p5_a27 DATE := fnd_api.g_miss_date
391: , p5_a28 NUMBER := 0-1962.0724
392: );
393: procedure delete_sif_ret_errors(p_api_version NUMBER
394: , p_init_msg_list VARCHAR2
488: , p6_a26 out nocopy DATE
489: , p6_a27 out nocopy DATE
490: , p6_a28 out nocopy NUMBER
491: , p5_a0 NUMBER := 0-1962.0724
492: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a5 NUMBER := 0-1962.0724
489: , p6_a27 out nocopy DATE
490: , p6_a28 out nocopy NUMBER
491: , p5_a0 NUMBER := 0-1962.0724
492: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a5 NUMBER := 0-1962.0724
497: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
490: , p6_a28 out nocopy NUMBER
491: , p5_a0 NUMBER := 0-1962.0724
492: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a5 NUMBER := 0-1962.0724
497: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a0 NUMBER := 0-1962.0724
492: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a5 NUMBER := 0-1962.0724
497: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a5 NUMBER := 0-1962.0724
497: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a5 NUMBER := 0-1962.0724
497: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a5 NUMBER := 0-1962.0724
497: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a5 NUMBER := 0-1962.0724
497: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a23 NUMBER := 0-1962.0724
507: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a23 NUMBER := 0-1962.0724
515: , p5_a24 NUMBER := 0-1962.0724
508: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a23 NUMBER := 0-1962.0724
515: , p5_a24 NUMBER := 0-1962.0724
516: , p5_a25 NUMBER := 0-1962.0724
509: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a23 NUMBER := 0-1962.0724
515: , p5_a24 NUMBER := 0-1962.0724
516: , p5_a25 NUMBER := 0-1962.0724
517: , p5_a26 DATE := fnd_api.g_miss_date
513: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a23 NUMBER := 0-1962.0724
515: , p5_a24 NUMBER := 0-1962.0724
516: , p5_a25 NUMBER := 0-1962.0724
517: , p5_a26 DATE := fnd_api.g_miss_date
518: , p5_a27 DATE := fnd_api.g_miss_date
519: , p5_a28 NUMBER := 0-1962.0724
520: );
521: procedure validate_sif_ret_errors(p_api_version NUMBER
514: , p5_a23 NUMBER := 0-1962.0724
515: , p5_a24 NUMBER := 0-1962.0724
516: , p5_a25 NUMBER := 0-1962.0724
517: , p5_a26 DATE := fnd_api.g_miss_date
518: , p5_a27 DATE := fnd_api.g_miss_date
519: , p5_a28 NUMBER := 0-1962.0724
520: );
521: procedure validate_sif_ret_errors(p_api_version NUMBER
522: , p_init_msg_list VARCHAR2