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_ATTACHMENT_PVT_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 31: , p7_a0 VARCHAR2 := fnd_api.g_miss_char

27: , x_msg_count out nocopy NUMBER
28: , x_msg_data out nocopy VARCHAR2
29: , x_document_id out nocopy NUMBER
30: , x_attached_document_id out nocopy NUMBER
31: , p7_a0 VARCHAR2 := fnd_api.g_miss_char
32: , p7_a1 NUMBER := 0-1962.0724
33: , p7_a2 NUMBER := 0-1962.0724
34: , p7_a3 NUMBER := 0-1962.0724
35: , p7_a4 NUMBER := 0-1962.0724

Line 36: , p7_a5 VARCHAR := fnd_api.g_miss_char

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

Line 37: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

33: , p7_a2 NUMBER := 0-1962.0724
34: , p7_a3 NUMBER := 0-1962.0724
35: , p7_a4 NUMBER := 0-1962.0724
36: , p7_a5 VARCHAR := fnd_api.g_miss_char
37: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a8 NUMBER := 0-1962.0724
40: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a10 NUMBER := 0-1962.0724

Line 38: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

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

Line 40: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 43: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

39: , p7_a8 NUMBER := 0-1962.0724
40: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a10 NUMBER := 0-1962.0724
42: , p7_a11 NUMBER := 0-1962.0724
43: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a16 DATE := fnd_api.g_miss_date

Line 44: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

40: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a10 NUMBER := 0-1962.0724
42: , p7_a11 NUMBER := 0-1962.0724
43: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a16 DATE := fnd_api.g_miss_date
48: , p7_a17 NUMBER := 0-1962.0724

Line 45: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

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

Line 46: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

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

Line 47: , p7_a16 DATE := fnd_api.g_miss_date

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

Line 49: , p7_a18 DATE := fnd_api.g_miss_date

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

Line 52: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

48: , p7_a17 NUMBER := 0-1962.0724
49: , p7_a18 DATE := fnd_api.g_miss_date
50: , p7_a19 NUMBER := 0-1962.0724
51: , p7_a20 NUMBER := 0-1962.0724
52: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a24 DATE := fnd_api.g_miss_date
56: )

Line 53: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

49: , p7_a18 DATE := fnd_api.g_miss_date
50: , p7_a19 NUMBER := 0-1962.0724
51: , p7_a20 NUMBER := 0-1962.0724
52: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a24 DATE := fnd_api.g_miss_date
56: )
57:

Line 54: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

50: , p7_a19 NUMBER := 0-1962.0724
51: , p7_a20 NUMBER := 0-1962.0724
52: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a24 DATE := fnd_api.g_miss_date
56: )
57:
58: as

Line 55: , p7_a24 DATE := fnd_api.g_miss_date

51: , p7_a20 NUMBER := 0-1962.0724
52: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a24 DATE := fnd_api.g_miss_date
56: )
57:
58: as
59: ddp_fnd_attachment_rec ams_attachment_pvt.fnd_attachment_rec_type;

Line 130: , p7_a0 VARCHAR2 := fnd_api.g_miss_char

126: , p_validation_level NUMBER
127: , x_return_status out nocopy VARCHAR2
128: , x_msg_count out nocopy NUMBER
129: , x_msg_data out nocopy VARCHAR2
130: , p7_a0 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a1 NUMBER := 0-1962.0724
132: , p7_a2 NUMBER := 0-1962.0724
133: , p7_a3 NUMBER := 0-1962.0724
134: , p7_a4 NUMBER := 0-1962.0724

Line 135: , p7_a5 VARCHAR := fnd_api.g_miss_char

131: , p7_a1 NUMBER := 0-1962.0724
132: , p7_a2 NUMBER := 0-1962.0724
133: , p7_a3 NUMBER := 0-1962.0724
134: , p7_a4 NUMBER := 0-1962.0724
135: , p7_a5 VARCHAR := fnd_api.g_miss_char
136: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a8 NUMBER := 0-1962.0724
139: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

Line 136: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

132: , p7_a2 NUMBER := 0-1962.0724
133: , p7_a3 NUMBER := 0-1962.0724
134: , p7_a4 NUMBER := 0-1962.0724
135: , p7_a5 VARCHAR := fnd_api.g_miss_char
136: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a8 NUMBER := 0-1962.0724
139: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a10 NUMBER := 0-1962.0724

Line 137: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

133: , p7_a3 NUMBER := 0-1962.0724
134: , p7_a4 NUMBER := 0-1962.0724
135: , p7_a5 VARCHAR := fnd_api.g_miss_char
136: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a8 NUMBER := 0-1962.0724
139: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a10 NUMBER := 0-1962.0724
141: , p7_a11 NUMBER := 0-1962.0724

Line 139: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

135: , p7_a5 VARCHAR := fnd_api.g_miss_char
136: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a8 NUMBER := 0-1962.0724
139: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a10 NUMBER := 0-1962.0724
141: , p7_a11 NUMBER := 0-1962.0724
142: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 142: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

138: , p7_a8 NUMBER := 0-1962.0724
139: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a10 NUMBER := 0-1962.0724
141: , p7_a11 NUMBER := 0-1962.0724
142: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a16 DATE := fnd_api.g_miss_date

Line 143: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

139: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a10 NUMBER := 0-1962.0724
141: , p7_a11 NUMBER := 0-1962.0724
142: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a16 DATE := fnd_api.g_miss_date
147: , p7_a17 NUMBER := 0-1962.0724

Line 144: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

140: , p7_a10 NUMBER := 0-1962.0724
141: , p7_a11 NUMBER := 0-1962.0724
142: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a16 DATE := fnd_api.g_miss_date
147: , p7_a17 NUMBER := 0-1962.0724
148: , p7_a18 DATE := fnd_api.g_miss_date

Line 145: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

141: , p7_a11 NUMBER := 0-1962.0724
142: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a16 DATE := fnd_api.g_miss_date
147: , p7_a17 NUMBER := 0-1962.0724
148: , p7_a18 DATE := fnd_api.g_miss_date
149: , p7_a19 NUMBER := 0-1962.0724

Line 146: , p7_a16 DATE := fnd_api.g_miss_date

142: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a16 DATE := fnd_api.g_miss_date
147: , p7_a17 NUMBER := 0-1962.0724
148: , p7_a18 DATE := fnd_api.g_miss_date
149: , p7_a19 NUMBER := 0-1962.0724
150: , p7_a20 NUMBER := 0-1962.0724

Line 148: , p7_a18 DATE := fnd_api.g_miss_date

144: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a16 DATE := fnd_api.g_miss_date
147: , p7_a17 NUMBER := 0-1962.0724
148: , p7_a18 DATE := fnd_api.g_miss_date
149: , p7_a19 NUMBER := 0-1962.0724
150: , p7_a20 NUMBER := 0-1962.0724
151: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 151: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

147: , p7_a17 NUMBER := 0-1962.0724
148: , p7_a18 DATE := fnd_api.g_miss_date
149: , p7_a19 NUMBER := 0-1962.0724
150: , p7_a20 NUMBER := 0-1962.0724
151: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a24 DATE := fnd_api.g_miss_date
155: )

Line 152: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

148: , p7_a18 DATE := fnd_api.g_miss_date
149: , p7_a19 NUMBER := 0-1962.0724
150: , p7_a20 NUMBER := 0-1962.0724
151: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a24 DATE := fnd_api.g_miss_date
155: )
156:

Line 153: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

149: , p7_a19 NUMBER := 0-1962.0724
150: , p7_a20 NUMBER := 0-1962.0724
151: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a24 DATE := fnd_api.g_miss_date
155: )
156:
157: as

Line 154: , p7_a24 DATE := fnd_api.g_miss_date

150: , p7_a20 NUMBER := 0-1962.0724
151: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a24 DATE := fnd_api.g_miss_date
155: )
156:
157: as
158: ddp_fnd_attachment_rec ams_attachment_pvt.fnd_attachment_rec_type;