APPS.ASF_USER_PREFERENCE_PUB_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as

Line 14: a number := fnd_api.g_miss_num;

10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;

Line 28: , p0_a3 DATE := fnd_api.g_miss_date

24: , x_msg_data out nocopy VARCHAR2
25: , p0_a0 NUMBER := 0-1962.0724
26: , p0_a1 NUMBER := 0-1962.0724
27: , p0_a2 NUMBER := 0-1962.0724
28: , p0_a3 DATE := fnd_api.g_miss_date
29: , p0_a4 NUMBER := 0-1962.0724
30: , p0_a5 DATE := fnd_api.g_miss_date
31: , p0_a6 NUMBER := 0-1962.0724
32: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 30: , p0_a5 DATE := fnd_api.g_miss_date

26: , p0_a1 NUMBER := 0-1962.0724
27: , p0_a2 NUMBER := 0-1962.0724
28: , p0_a3 DATE := fnd_api.g_miss_date
29: , p0_a4 NUMBER := 0-1962.0724
30: , p0_a5 DATE := fnd_api.g_miss_date
31: , p0_a6 NUMBER := 0-1962.0724
32: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a8 NUMBER := 0-1962.0724
34: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

Line 32: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

28: , p0_a3 DATE := fnd_api.g_miss_date
29: , p0_a4 NUMBER := 0-1962.0724
30: , p0_a5 DATE := fnd_api.g_miss_date
31: , p0_a6 NUMBER := 0-1962.0724
32: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a8 NUMBER := 0-1962.0724
34: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
35: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 34: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

30: , p0_a5 DATE := fnd_api.g_miss_date
31: , p0_a6 NUMBER := 0-1962.0724
32: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a8 NUMBER := 0-1962.0724
34: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
35: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 35: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

31: , p0_a6 NUMBER := 0-1962.0724
32: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a8 NUMBER := 0-1962.0724
34: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
35: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

32: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
33: , p0_a8 NUMBER := 0-1962.0724
34: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
35: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

33: , p0_a8 NUMBER := 0-1962.0724
34: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
35: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

34: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
35: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

35: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

36: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

Line 41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

37: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

38: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

Line 43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

39: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

40: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

Line 45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

41: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

Line 46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

42: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

Line 47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

43: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

Line 48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

44: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

Line 49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

45: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
53: )

Line 50: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

46: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
53: )
54:

Line 51: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

47: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
53: )
54:
55: as

Line 52: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

48: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
49: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
50: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
53: )
54:
55: as
56: ddp_user_preference_rec asf_user_preference_pub.user_preference_rec_type;

Line 111: , p0_a3 DATE := fnd_api.g_miss_date

107: , x_msg_data out nocopy VARCHAR2
108: , p0_a0 NUMBER := 0-1962.0724
109: , p0_a1 NUMBER := 0-1962.0724
110: , p0_a2 NUMBER := 0-1962.0724
111: , p0_a3 DATE := fnd_api.g_miss_date
112: , p0_a4 NUMBER := 0-1962.0724
113: , p0_a5 DATE := fnd_api.g_miss_date
114: , p0_a6 NUMBER := 0-1962.0724
115: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 113: , p0_a5 DATE := fnd_api.g_miss_date

109: , p0_a1 NUMBER := 0-1962.0724
110: , p0_a2 NUMBER := 0-1962.0724
111: , p0_a3 DATE := fnd_api.g_miss_date
112: , p0_a4 NUMBER := 0-1962.0724
113: , p0_a5 DATE := fnd_api.g_miss_date
114: , p0_a6 NUMBER := 0-1962.0724
115: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

Line 115: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

111: , p0_a3 DATE := fnd_api.g_miss_date
112: , p0_a4 NUMBER := 0-1962.0724
113: , p0_a5 DATE := fnd_api.g_miss_date
114: , p0_a6 NUMBER := 0-1962.0724
115: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

113: , p0_a5 DATE := fnd_api.g_miss_date
114: , p0_a6 NUMBER := 0-1962.0724
115: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

114: , p0_a6 NUMBER := 0-1962.0724
115: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

115: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

Line 124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

Line 126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

123: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

Line 128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

124: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

Line 129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

125: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
133: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

Line 130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

126: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
133: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

Line 131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

127: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
133: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

Line 132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

128: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
133: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
136: )

Line 133: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

129: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
133: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
136: )
137:

Line 134: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

130: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
133: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
136: )
137:
138: as

Line 135: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

131: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
133: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
134: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
136: )
137:
138: as
139: ddp_user_preference_rec asf_user_preference_pub.user_preference_rec_type;

Line 194: , p0_a3 DATE := fnd_api.g_miss_date

190: , x_msg_data out nocopy VARCHAR2
191: , p0_a0 NUMBER := 0-1962.0724
192: , p0_a1 NUMBER := 0-1962.0724
193: , p0_a2 NUMBER := 0-1962.0724
194: , p0_a3 DATE := fnd_api.g_miss_date
195: , p0_a4 NUMBER := 0-1962.0724
196: , p0_a5 DATE := fnd_api.g_miss_date
197: , p0_a6 NUMBER := 0-1962.0724
198: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 196: , p0_a5 DATE := fnd_api.g_miss_date

192: , p0_a1 NUMBER := 0-1962.0724
193: , p0_a2 NUMBER := 0-1962.0724
194: , p0_a3 DATE := fnd_api.g_miss_date
195: , p0_a4 NUMBER := 0-1962.0724
196: , p0_a5 DATE := fnd_api.g_miss_date
197: , p0_a6 NUMBER := 0-1962.0724
198: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a8 NUMBER := 0-1962.0724
200: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

Line 198: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

194: , p0_a3 DATE := fnd_api.g_miss_date
195: , p0_a4 NUMBER := 0-1962.0724
196: , p0_a5 DATE := fnd_api.g_miss_date
197: , p0_a6 NUMBER := 0-1962.0724
198: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a8 NUMBER := 0-1962.0724
200: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 200: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

196: , p0_a5 DATE := fnd_api.g_miss_date
197: , p0_a6 NUMBER := 0-1962.0724
198: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a8 NUMBER := 0-1962.0724
200: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 201: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

197: , p0_a6 NUMBER := 0-1962.0724
198: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a8 NUMBER := 0-1962.0724
200: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

198: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a8 NUMBER := 0-1962.0724
200: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

199: , p0_a8 NUMBER := 0-1962.0724
200: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

200: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

201: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

202: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

Line 207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

203: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

204: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

Line 209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

205: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

206: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

Line 211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

207: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

Line 212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

208: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

Line 213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

209: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

Line 214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

210: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

Line 215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

211: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
219: )

Line 216: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

212: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
219: )
220:

Line 217: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

213: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
219: )
220:
221: as

Line 218: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

214: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
219: )
220:
221: as
222: ddp_user_preference_rec asf_user_preference_pub.user_preference_rec_type;