eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_CONTACT_PREFERENCE_PVT_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;

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

14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure create_contact_preference(p_api_version_number NUMBER

Line 32: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

28: , x_msg_data OUT NOCOPY VARCHAR2
29: , p_request_id NUMBER
30: , x_contact_preference_id OUT NOCOPY NUMBER
31: , p7_a0 NUMBER := 0-1962.0724
32: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a2 NUMBER := 0-1962.0724
34: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

Line 34: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

30: , x_contact_preference_id OUT NOCOPY NUMBER
31: , p7_a0 NUMBER := 0-1962.0724
32: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a2 NUMBER := 0-1962.0724
34: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a6 NUMBER := 0-1962.0724
38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 35: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

31: , p7_a0 NUMBER := 0-1962.0724
32: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a2 NUMBER := 0-1962.0724
34: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a6 NUMBER := 0-1962.0724
38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a8 DATE := fnd_api.g_miss_date

Line 36: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

32: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a2 NUMBER := 0-1962.0724
34: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a6 NUMBER := 0-1962.0724
38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a8 DATE := fnd_api.g_miss_date
40: , p7_a9 DATE := fnd_api.g_miss_date

Line 38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

34: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a6 NUMBER := 0-1962.0724
38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a8 DATE := fnd_api.g_miss_date
40: , p7_a9 DATE := fnd_api.g_miss_date
41: , p7_a10 NUMBER := 0-1962.0724
42: , p7_a11 NUMBER := 0-1962.0724

Line 39: , p7_a8 DATE := fnd_api.g_miss_date

35: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a6 NUMBER := 0-1962.0724
38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a8 DATE := fnd_api.g_miss_date
40: , p7_a9 DATE := fnd_api.g_miss_date
41: , p7_a10 NUMBER := 0-1962.0724
42: , p7_a11 NUMBER := 0-1962.0724
43: , p7_a12 NUMBER := 0-1962.0724

Line 40: , p7_a9 DATE := fnd_api.g_miss_date

36: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a6 NUMBER := 0-1962.0724
38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a8 DATE := fnd_api.g_miss_date
40: , p7_a9 DATE := fnd_api.g_miss_date
41: , p7_a10 NUMBER := 0-1962.0724
42: , p7_a11 NUMBER := 0-1962.0724
43: , p7_a12 NUMBER := 0-1962.0724
44: , p7_a13 NUMBER := 0-1962.0724

Line 46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

42: , p7_a11 NUMBER := 0-1962.0724
43: , p7_a12 NUMBER := 0-1962.0724
44: , p7_a13 NUMBER := 0-1962.0724
45: , p7_a14 NUMBER := 0-1962.0724
46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 47: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

43: , p7_a12 NUMBER := 0-1962.0724
44: , p7_a13 NUMBER := 0-1962.0724
45: , p7_a14 NUMBER := 0-1962.0724
46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a20 NUMBER := 0-1962.0724

Line 48: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

44: , p7_a13 NUMBER := 0-1962.0724
45: , p7_a14 NUMBER := 0-1962.0724
46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a20 NUMBER := 0-1962.0724
52: )

Line 49: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

45: , p7_a14 NUMBER := 0-1962.0724
46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a20 NUMBER := 0-1962.0724
52: )
53: as

Line 50: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a20 NUMBER := 0-1962.0724
52: )
53: as
54: ddp_ams_contact_pref_rec ams_contact_preference_pvt.contact_preference_rec_type;

Line 124: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

120: , x_msg_data OUT NOCOPY VARCHAR2
121: , p_request_id NUMBER
122: , px_object_version_number in OUT NOCOPY NUMBER
123: , p7_a0 NUMBER := 0-1962.0724
124: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a2 NUMBER := 0-1962.0724
126: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

Line 126: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

122: , px_object_version_number in OUT NOCOPY NUMBER
123: , p7_a0 NUMBER := 0-1962.0724
124: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a2 NUMBER := 0-1962.0724
126: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a6 NUMBER := 0-1962.0724
130: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 127: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

123: , p7_a0 NUMBER := 0-1962.0724
124: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a2 NUMBER := 0-1962.0724
126: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a6 NUMBER := 0-1962.0724
130: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a8 DATE := fnd_api.g_miss_date

Line 128: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

124: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a2 NUMBER := 0-1962.0724
126: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a6 NUMBER := 0-1962.0724
130: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a8 DATE := fnd_api.g_miss_date
132: , p7_a9 DATE := fnd_api.g_miss_date

Line 130: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

126: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a6 NUMBER := 0-1962.0724
130: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a8 DATE := fnd_api.g_miss_date
132: , p7_a9 DATE := fnd_api.g_miss_date
133: , p7_a10 NUMBER := 0-1962.0724
134: , p7_a11 NUMBER := 0-1962.0724

Line 131: , p7_a8 DATE := fnd_api.g_miss_date

127: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a6 NUMBER := 0-1962.0724
130: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a8 DATE := fnd_api.g_miss_date
132: , p7_a9 DATE := fnd_api.g_miss_date
133: , p7_a10 NUMBER := 0-1962.0724
134: , p7_a11 NUMBER := 0-1962.0724
135: , p7_a12 NUMBER := 0-1962.0724

Line 132: , p7_a9 DATE := fnd_api.g_miss_date

128: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a6 NUMBER := 0-1962.0724
130: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a8 DATE := fnd_api.g_miss_date
132: , p7_a9 DATE := fnd_api.g_miss_date
133: , p7_a10 NUMBER := 0-1962.0724
134: , p7_a11 NUMBER := 0-1962.0724
135: , p7_a12 NUMBER := 0-1962.0724
136: , p7_a13 NUMBER := 0-1962.0724

Line 138: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

134: , p7_a11 NUMBER := 0-1962.0724
135: , p7_a12 NUMBER := 0-1962.0724
136: , p7_a13 NUMBER := 0-1962.0724
137: , p7_a14 NUMBER := 0-1962.0724
138: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 139: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

135: , p7_a12 NUMBER := 0-1962.0724
136: , p7_a13 NUMBER := 0-1962.0724
137: , p7_a14 NUMBER := 0-1962.0724
138: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a20 NUMBER := 0-1962.0724

Line 140: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

136: , p7_a13 NUMBER := 0-1962.0724
137: , p7_a14 NUMBER := 0-1962.0724
138: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a20 NUMBER := 0-1962.0724
144: )

Line 141: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

137: , p7_a14 NUMBER := 0-1962.0724
138: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a20 NUMBER := 0-1962.0724
144: )
145: as

Line 142: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

138: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a20 NUMBER := 0-1962.0724
144: )
145: as
146: ddp_ams_contact_pref_rec ams_contact_preference_pvt.contact_preference_rec_type;