5: , x_msg_data out nocopy VARCHAR2
6: , p0_a0 NUMBER := 0-1962.0724
7: , p0_a1 NUMBER := 0-1962.0724
8: , p0_a2 NUMBER := 0-1962.0724
9: , p0_a3 DATE := fnd_api.g_miss_date
10: , p0_a4 NUMBER := 0-1962.0724
11: , p0_a5 DATE := fnd_api.g_miss_date
12: , p0_a6 NUMBER := 0-1962.0724
13: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
7: , p0_a1 NUMBER := 0-1962.0724
8: , p0_a2 NUMBER := 0-1962.0724
9: , p0_a3 DATE := fnd_api.g_miss_date
10: , p0_a4 NUMBER := 0-1962.0724
11: , p0_a5 DATE := fnd_api.g_miss_date
12: , p0_a6 NUMBER := 0-1962.0724
13: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
14: , p0_a8 NUMBER := 0-1962.0724
15: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
9: , p0_a3 DATE := fnd_api.g_miss_date
10: , p0_a4 NUMBER := 0-1962.0724
11: , p0_a5 DATE := fnd_api.g_miss_date
12: , p0_a6 NUMBER := 0-1962.0724
13: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
14: , p0_a8 NUMBER := 0-1962.0724
15: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
16: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
17: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
11: , p0_a5 DATE := fnd_api.g_miss_date
12: , p0_a6 NUMBER := 0-1962.0724
13: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
14: , p0_a8 NUMBER := 0-1962.0724
15: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
16: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
17: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
18: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
12: , p0_a6 NUMBER := 0-1962.0724
13: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
14: , p0_a8 NUMBER := 0-1962.0724
15: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
16: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
17: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
18: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
13: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
14: , p0_a8 NUMBER := 0-1962.0724
15: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
16: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
17: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
18: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
14: , p0_a8 NUMBER := 0-1962.0724
15: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
16: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
17: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
18: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
15: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
16: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
17: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
18: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
16: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
17: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
18: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
17: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
18: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
18: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
19: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
20: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
30: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
23: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
30: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
31: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
24: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
30: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
31: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
32: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
25: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
30: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
31: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
32: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
26: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
30: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
31: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
32: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
34: );
27: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
30: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
31: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
32: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
34: );
35: procedure update_preference(x_return_status out nocopy VARCHAR2
28: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
30: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
31: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
32: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
34: );
35: procedure update_preference(x_return_status out nocopy VARCHAR2
36: , x_msg_count out nocopy NUMBER
29: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
30: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
31: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
32: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
34: );
35: procedure update_preference(x_return_status out nocopy VARCHAR2
36: , x_msg_count out nocopy NUMBER
37: , x_msg_data out nocopy VARCHAR2
37: , x_msg_data out nocopy VARCHAR2
38: , p0_a0 NUMBER := 0-1962.0724
39: , p0_a1 NUMBER := 0-1962.0724
40: , p0_a2 NUMBER := 0-1962.0724
41: , p0_a3 DATE := fnd_api.g_miss_date
42: , p0_a4 NUMBER := 0-1962.0724
43: , p0_a5 DATE := fnd_api.g_miss_date
44: , p0_a6 NUMBER := 0-1962.0724
45: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a1 NUMBER := 0-1962.0724
40: , p0_a2 NUMBER := 0-1962.0724
41: , p0_a3 DATE := fnd_api.g_miss_date
42: , p0_a4 NUMBER := 0-1962.0724
43: , p0_a5 DATE := fnd_api.g_miss_date
44: , p0_a6 NUMBER := 0-1962.0724
45: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a8 NUMBER := 0-1962.0724
47: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a3 DATE := fnd_api.g_miss_date
42: , p0_a4 NUMBER := 0-1962.0724
43: , p0_a5 DATE := fnd_api.g_miss_date
44: , p0_a6 NUMBER := 0-1962.0724
45: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a8 NUMBER := 0-1962.0724
47: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a5 DATE := fnd_api.g_miss_date
44: , p0_a6 NUMBER := 0-1962.0724
45: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a8 NUMBER := 0-1962.0724
47: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a6 NUMBER := 0-1962.0724
45: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a8 NUMBER := 0-1962.0724
47: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a8 NUMBER := 0-1962.0724
47: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a8 NUMBER := 0-1962.0724
47: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
66: );
59: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure delete_preference(x_return_status out nocopy VARCHAR2
60: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure delete_preference(x_return_status out nocopy VARCHAR2
68: , x_msg_count out nocopy NUMBER
61: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure delete_preference(x_return_status out nocopy VARCHAR2
68: , x_msg_count out nocopy NUMBER
69: , x_msg_data out nocopy VARCHAR2
69: , x_msg_data out nocopy VARCHAR2
70: , p0_a0 NUMBER := 0-1962.0724
71: , p0_a1 NUMBER := 0-1962.0724
72: , p0_a2 NUMBER := 0-1962.0724
73: , p0_a3 DATE := fnd_api.g_miss_date
74: , p0_a4 NUMBER := 0-1962.0724
75: , p0_a5 DATE := fnd_api.g_miss_date
76: , p0_a6 NUMBER := 0-1962.0724
77: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
71: , p0_a1 NUMBER := 0-1962.0724
72: , p0_a2 NUMBER := 0-1962.0724
73: , p0_a3 DATE := fnd_api.g_miss_date
74: , p0_a4 NUMBER := 0-1962.0724
75: , p0_a5 DATE := fnd_api.g_miss_date
76: , p0_a6 NUMBER := 0-1962.0724
77: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p0_a8 NUMBER := 0-1962.0724
79: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
73: , p0_a3 DATE := fnd_api.g_miss_date
74: , p0_a4 NUMBER := 0-1962.0724
75: , p0_a5 DATE := fnd_api.g_miss_date
76: , p0_a6 NUMBER := 0-1962.0724
77: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p0_a8 NUMBER := 0-1962.0724
79: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
75: , p0_a5 DATE := fnd_api.g_miss_date
76: , p0_a6 NUMBER := 0-1962.0724
77: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p0_a8 NUMBER := 0-1962.0724
79: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
76: , p0_a6 NUMBER := 0-1962.0724
77: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p0_a8 NUMBER := 0-1962.0724
79: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
77: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p0_a8 NUMBER := 0-1962.0724
79: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
78: , p0_a8 NUMBER := 0-1962.0724
79: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
79: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
95: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
95: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
96: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
95: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
96: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
95: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
96: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
98: );
91: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
95: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
96: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
98: );
99: end asf_user_preference_pub_w;
92: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
95: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
96: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
98: );
99: end asf_user_preference_pub_w;
93: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
95: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
96: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
98: );
99: end asf_user_preference_pub_w;