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.

[Home] [Help]

APPS.OZF_ACT_OFFERS_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_act_offer(p_api_version NUMBER

Line 30: , p7_a1 DATE := fnd_api.g_miss_date

26: , x_return_status out NOCOPY VARCHAR2
27: , x_msg_count out NOCOPY NUMBER
28: , x_msg_data out NOCOPY VARCHAR2
29: , p7_a0 NUMBER := 0-1962.0724
30: , p7_a1 DATE := fnd_api.g_miss_date
31: , p7_a2 NUMBER := 0-1962.0724
32: , p7_a3 DATE := fnd_api.g_miss_date
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724

Line 32: , p7_a3 DATE := fnd_api.g_miss_date

28: , x_msg_data out NOCOPY VARCHAR2
29: , p7_a0 NUMBER := 0-1962.0724
30: , p7_a1 DATE := fnd_api.g_miss_date
31: , p7_a2 NUMBER := 0-1962.0724
32: , p7_a3 DATE := fnd_api.g_miss_date
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 NUMBER := 0-1962.0724

Line 37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 39: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 NUMBER := 0-1962.0724
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a12 NUMBER := 0-1962.0724
42: , p7_a13 NUMBER := 0-1962.0724
43: , x_act_offer_id out NOCOPY NUMBER

Line 40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

36: , p7_a7 NUMBER := 0-1962.0724
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a12 NUMBER := 0-1962.0724
42: , p7_a13 NUMBER := 0-1962.0724
43: , x_act_offer_id out NOCOPY NUMBER
44: )

Line 104: , p7_a1 DATE := fnd_api.g_miss_date

100: , x_return_status out NOCOPY VARCHAR2
101: , x_msg_count out NOCOPY NUMBER
102: , x_msg_data out NOCOPY VARCHAR2
103: , p7_a0 NUMBER := 0-1962.0724
104: , p7_a1 DATE := fnd_api.g_miss_date
105: , p7_a2 NUMBER := 0-1962.0724
106: , p7_a3 DATE := fnd_api.g_miss_date
107: , p7_a4 NUMBER := 0-1962.0724
108: , p7_a5 NUMBER := 0-1962.0724

Line 106: , p7_a3 DATE := fnd_api.g_miss_date

102: , x_msg_data out NOCOPY VARCHAR2
103: , p7_a0 NUMBER := 0-1962.0724
104: , p7_a1 DATE := fnd_api.g_miss_date
105: , p7_a2 NUMBER := 0-1962.0724
106: , p7_a3 DATE := fnd_api.g_miss_date
107: , p7_a4 NUMBER := 0-1962.0724
108: , p7_a5 NUMBER := 0-1962.0724
109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 NUMBER := 0-1962.0724

Line 111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

107: , p7_a4 NUMBER := 0-1962.0724
108: , p7_a5 NUMBER := 0-1962.0724
109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 NUMBER := 0-1962.0724
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 NUMBER := 0-1962.0724

Line 112: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

108: , p7_a5 NUMBER := 0-1962.0724
109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 NUMBER := 0-1962.0724
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 NUMBER := 0-1962.0724

Line 113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 NUMBER := 0-1962.0724
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 NUMBER := 0-1962.0724
117: )

Line 114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

110: , p7_a7 NUMBER := 0-1962.0724
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 NUMBER := 0-1962.0724
117: )
118: as

Line 173: , p6_a1 DATE := fnd_api.g_miss_date

169: , x_return_status out NOCOPY VARCHAR2
170: , x_msg_count out NOCOPY NUMBER
171: , x_msg_data out NOCOPY VARCHAR2
172: , p6_a0 NUMBER := 0-1962.0724
173: , p6_a1 DATE := fnd_api.g_miss_date
174: , p6_a2 NUMBER := 0-1962.0724
175: , p6_a3 DATE := fnd_api.g_miss_date
176: , p6_a4 NUMBER := 0-1962.0724
177: , p6_a5 NUMBER := 0-1962.0724

Line 175: , p6_a3 DATE := fnd_api.g_miss_date

171: , x_msg_data out NOCOPY VARCHAR2
172: , p6_a0 NUMBER := 0-1962.0724
173: , p6_a1 DATE := fnd_api.g_miss_date
174: , p6_a2 NUMBER := 0-1962.0724
175: , p6_a3 DATE := fnd_api.g_miss_date
176: , p6_a4 NUMBER := 0-1962.0724
177: , p6_a5 NUMBER := 0-1962.0724
178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 NUMBER := 0-1962.0724

Line 180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

176: , p6_a4 NUMBER := 0-1962.0724
177: , p6_a5 NUMBER := 0-1962.0724
178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 NUMBER := 0-1962.0724
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 NUMBER := 0-1962.0724

Line 181: , p6_a9 VARCHAR2 := fnd_api.g_miss_char

177: , p6_a5 NUMBER := 0-1962.0724
178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 NUMBER := 0-1962.0724
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 NUMBER := 0-1962.0724

Line 182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char

178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 NUMBER := 0-1962.0724
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 NUMBER := 0-1962.0724
186: )

Line 183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

179: , p6_a7 NUMBER := 0-1962.0724
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 NUMBER := 0-1962.0724
186: )
187: as

Line 235: , p2_a1 DATE := fnd_api.g_miss_date

231:
232: procedure check_items(p_validation_mode VARCHAR2
233: , x_return_status out NOCOPY VARCHAR2
234: , p2_a0 NUMBER := 0-1962.0724
235: , p2_a1 DATE := fnd_api.g_miss_date
236: , p2_a2 NUMBER := 0-1962.0724
237: , p2_a3 DATE := fnd_api.g_miss_date
238: , p2_a4 NUMBER := 0-1962.0724
239: , p2_a5 NUMBER := 0-1962.0724

Line 237: , p2_a3 DATE := fnd_api.g_miss_date

233: , x_return_status out NOCOPY VARCHAR2
234: , p2_a0 NUMBER := 0-1962.0724
235: , p2_a1 DATE := fnd_api.g_miss_date
236: , p2_a2 NUMBER := 0-1962.0724
237: , p2_a3 DATE := fnd_api.g_miss_date
238: , p2_a4 NUMBER := 0-1962.0724
239: , p2_a5 NUMBER := 0-1962.0724
240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 NUMBER := 0-1962.0724

Line 242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char

238: , p2_a4 NUMBER := 0-1962.0724
239: , p2_a5 NUMBER := 0-1962.0724
240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 NUMBER := 0-1962.0724
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 NUMBER := 0-1962.0724

Line 243: , p2_a9 VARCHAR2 := fnd_api.g_miss_char

239: , p2_a5 NUMBER := 0-1962.0724
240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 NUMBER := 0-1962.0724
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 NUMBER := 0-1962.0724

Line 244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char

240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 NUMBER := 0-1962.0724
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 NUMBER := 0-1962.0724
248: )

Line 245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char

241: , p2_a7 NUMBER := 0-1962.0724
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 NUMBER := 0-1962.0724
248: )
249: as