DBA Data[Home] [Help]

APPS.PVX_TIMEOUT_SETUP_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_timeout_setup(p_api_version NUMBER

Line 31: , p7_a1 DATE := fnd_api.g_miss_date

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

Line 33: , p7_a3 DATE := fnd_api.g_miss_date

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

Line 38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: )
41: as
42: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;

Line 39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: )
41: as
42: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;
43: ddindx binary_integer; indx binary_integer;

Line 96: , p7_a1 DATE := fnd_api.g_miss_date

92: , x_return_status out nocopy VARCHAR2
93: , x_msg_count out nocopy NUMBER
94: , x_msg_data out nocopy VARCHAR2
95: , p7_a0 NUMBER := 0-1962.0724
96: , p7_a1 DATE := fnd_api.g_miss_date
97: , p7_a2 NUMBER := 0-1962.0724
98: , p7_a3 DATE := fnd_api.g_miss_date
99: , p7_a4 NUMBER := 0-1962.0724
100: , p7_a5 NUMBER := 0-1962.0724

Line 98: , p7_a3 DATE := fnd_api.g_miss_date

94: , x_msg_data out nocopy VARCHAR2
95: , p7_a0 NUMBER := 0-1962.0724
96: , p7_a1 DATE := fnd_api.g_miss_date
97: , p7_a2 NUMBER := 0-1962.0724
98: , p7_a3 DATE := fnd_api.g_miss_date
99: , p7_a4 NUMBER := 0-1962.0724
100: , p7_a5 NUMBER := 0-1962.0724
101: , p7_a6 NUMBER := 0-1962.0724
102: , p7_a7 NUMBER := 0-1962.0724

Line 103: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

99: , p7_a4 NUMBER := 0-1962.0724
100: , p7_a5 NUMBER := 0-1962.0724
101: , p7_a6 NUMBER := 0-1962.0724
102: , p7_a7 NUMBER := 0-1962.0724
103: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
105: )
106: as
107: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;

Line 104: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

100: , p7_a5 NUMBER := 0-1962.0724
101: , p7_a6 NUMBER := 0-1962.0724
102: , p7_a7 NUMBER := 0-1962.0724
103: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
105: )
106: as
107: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;
108: ddindx binary_integer; indx binary_integer;

Line 157: , p6_a1 DATE := fnd_api.g_miss_date

153: , x_return_status out nocopy VARCHAR2
154: , x_msg_count out nocopy NUMBER
155: , x_msg_data out nocopy VARCHAR2
156: , p6_a0 NUMBER := 0-1962.0724
157: , p6_a1 DATE := fnd_api.g_miss_date
158: , p6_a2 NUMBER := 0-1962.0724
159: , p6_a3 DATE := fnd_api.g_miss_date
160: , p6_a4 NUMBER := 0-1962.0724
161: , p6_a5 NUMBER := 0-1962.0724

Line 159: , p6_a3 DATE := fnd_api.g_miss_date

155: , x_msg_data out nocopy VARCHAR2
156: , p6_a0 NUMBER := 0-1962.0724
157: , p6_a1 DATE := fnd_api.g_miss_date
158: , p6_a2 NUMBER := 0-1962.0724
159: , p6_a3 DATE := fnd_api.g_miss_date
160: , p6_a4 NUMBER := 0-1962.0724
161: , p6_a5 NUMBER := 0-1962.0724
162: , p6_a6 NUMBER := 0-1962.0724
163: , p6_a7 NUMBER := 0-1962.0724

Line 164: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

160: , p6_a4 NUMBER := 0-1962.0724
161: , p6_a5 NUMBER := 0-1962.0724
162: , p6_a6 NUMBER := 0-1962.0724
163: , p6_a7 NUMBER := 0-1962.0724
164: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
165: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
166: )
167: as
168: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;

Line 165: , p6_a9 VARCHAR2 := fnd_api.g_miss_char

161: , p6_a5 NUMBER := 0-1962.0724
162: , p6_a6 NUMBER := 0-1962.0724
163: , p6_a7 NUMBER := 0-1962.0724
164: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
165: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
166: )
167: as
168: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;
169: ddindx binary_integer; indx binary_integer;

Line 211: , p2_a1 DATE := fnd_api.g_miss_date

207:
208: procedure check_timeout_items(p_validation_mode VARCHAR2
209: , x_return_status out nocopy VARCHAR2
210: , p2_a0 NUMBER := 0-1962.0724
211: , p2_a1 DATE := fnd_api.g_miss_date
212: , p2_a2 NUMBER := 0-1962.0724
213: , p2_a3 DATE := fnd_api.g_miss_date
214: , p2_a4 NUMBER := 0-1962.0724
215: , p2_a5 NUMBER := 0-1962.0724

Line 213: , p2_a3 DATE := fnd_api.g_miss_date

209: , x_return_status out nocopy VARCHAR2
210: , p2_a0 NUMBER := 0-1962.0724
211: , p2_a1 DATE := fnd_api.g_miss_date
212: , p2_a2 NUMBER := 0-1962.0724
213: , p2_a3 DATE := fnd_api.g_miss_date
214: , p2_a4 NUMBER := 0-1962.0724
215: , p2_a5 NUMBER := 0-1962.0724
216: , p2_a6 NUMBER := 0-1962.0724
217: , p2_a7 NUMBER := 0-1962.0724

Line 218: , p2_a8 VARCHAR2 := fnd_api.g_miss_char

214: , p2_a4 NUMBER := 0-1962.0724
215: , p2_a5 NUMBER := 0-1962.0724
216: , p2_a6 NUMBER := 0-1962.0724
217: , p2_a7 NUMBER := 0-1962.0724
218: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
219: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
220: )
221: as
222: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;

Line 219: , p2_a9 VARCHAR2 := fnd_api.g_miss_char

215: , p2_a5 NUMBER := 0-1962.0724
216: , p2_a6 NUMBER := 0-1962.0724
217: , p2_a7 NUMBER := 0-1962.0724
218: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
219: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
220: )
221: as
222: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;
223: ddindx binary_integer; indx binary_integer;

Line 253: , p0_a1 DATE := fnd_api.g_miss_date

249:
250: procedure check_timeout_rec(p_mode VARCHAR2
251: , x_return_status out nocopy VARCHAR2
252: , p0_a0 NUMBER := 0-1962.0724
253: , p0_a1 DATE := fnd_api.g_miss_date
254: , p0_a2 NUMBER := 0-1962.0724
255: , p0_a3 DATE := fnd_api.g_miss_date
256: , p0_a4 NUMBER := 0-1962.0724
257: , p0_a5 NUMBER := 0-1962.0724

Line 255: , p0_a3 DATE := fnd_api.g_miss_date

251: , x_return_status out nocopy VARCHAR2
252: , p0_a0 NUMBER := 0-1962.0724
253: , p0_a1 DATE := fnd_api.g_miss_date
254: , p0_a2 NUMBER := 0-1962.0724
255: , p0_a3 DATE := fnd_api.g_miss_date
256: , p0_a4 NUMBER := 0-1962.0724
257: , p0_a5 NUMBER := 0-1962.0724
258: , p0_a6 NUMBER := 0-1962.0724
259: , p0_a7 NUMBER := 0-1962.0724

Line 260: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

256: , p0_a4 NUMBER := 0-1962.0724
257: , p0_a5 NUMBER := 0-1962.0724
258: , p0_a6 NUMBER := 0-1962.0724
259: , p0_a7 NUMBER := 0-1962.0724
260: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
262: , p1_a0 NUMBER := 0-1962.0724
263: , p1_a1 DATE := fnd_api.g_miss_date
264: , p1_a2 NUMBER := 0-1962.0724

Line 261: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

257: , p0_a5 NUMBER := 0-1962.0724
258: , p0_a6 NUMBER := 0-1962.0724
259: , p0_a7 NUMBER := 0-1962.0724
260: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
262: , p1_a0 NUMBER := 0-1962.0724
263: , p1_a1 DATE := fnd_api.g_miss_date
264: , p1_a2 NUMBER := 0-1962.0724
265: , p1_a3 DATE := fnd_api.g_miss_date

Line 263: , p1_a1 DATE := fnd_api.g_miss_date

259: , p0_a7 NUMBER := 0-1962.0724
260: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
261: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
262: , p1_a0 NUMBER := 0-1962.0724
263: , p1_a1 DATE := fnd_api.g_miss_date
264: , p1_a2 NUMBER := 0-1962.0724
265: , p1_a3 DATE := fnd_api.g_miss_date
266: , p1_a4 NUMBER := 0-1962.0724
267: , p1_a5 NUMBER := 0-1962.0724

Line 265: , p1_a3 DATE := fnd_api.g_miss_date

261: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
262: , p1_a0 NUMBER := 0-1962.0724
263: , p1_a1 DATE := fnd_api.g_miss_date
264: , p1_a2 NUMBER := 0-1962.0724
265: , p1_a3 DATE := fnd_api.g_miss_date
266: , p1_a4 NUMBER := 0-1962.0724
267: , p1_a5 NUMBER := 0-1962.0724
268: , p1_a6 NUMBER := 0-1962.0724
269: , p1_a7 NUMBER := 0-1962.0724

Line 270: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

266: , p1_a4 NUMBER := 0-1962.0724
267: , p1_a5 NUMBER := 0-1962.0724
268: , p1_a6 NUMBER := 0-1962.0724
269: , p1_a7 NUMBER := 0-1962.0724
270: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
272: )
273: as
274: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;

Line 271: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

267: , p1_a5 NUMBER := 0-1962.0724
268: , p1_a6 NUMBER := 0-1962.0724
269: , p1_a7 NUMBER := 0-1962.0724
270: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
272: )
273: as
274: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;
275: ddp_complete_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;

Line 361: , p0_a1 DATE := fnd_api.g_miss_date

357: , p1_a7 out nocopy NUMBER
358: , p1_a8 out nocopy VARCHAR2
359: , p1_a9 out nocopy VARCHAR2
360: , p0_a0 NUMBER := 0-1962.0724
361: , p0_a1 DATE := fnd_api.g_miss_date
362: , p0_a2 NUMBER := 0-1962.0724
363: , p0_a3 DATE := fnd_api.g_miss_date
364: , p0_a4 NUMBER := 0-1962.0724
365: , p0_a5 NUMBER := 0-1962.0724

Line 363: , p0_a3 DATE := fnd_api.g_miss_date

359: , p1_a9 out nocopy VARCHAR2
360: , p0_a0 NUMBER := 0-1962.0724
361: , p0_a1 DATE := fnd_api.g_miss_date
362: , p0_a2 NUMBER := 0-1962.0724
363: , p0_a3 DATE := fnd_api.g_miss_date
364: , p0_a4 NUMBER := 0-1962.0724
365: , p0_a5 NUMBER := 0-1962.0724
366: , p0_a6 NUMBER := 0-1962.0724
367: , p0_a7 NUMBER := 0-1962.0724

Line 368: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

364: , p0_a4 NUMBER := 0-1962.0724
365: , p0_a5 NUMBER := 0-1962.0724
366: , p0_a6 NUMBER := 0-1962.0724
367: , p0_a7 NUMBER := 0-1962.0724
368: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
370: )
371: as
372: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;

Line 369: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

365: , p0_a5 NUMBER := 0-1962.0724
366: , p0_a6 NUMBER := 0-1962.0724
367: , p0_a7 NUMBER := 0-1962.0724
368: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
370: )
371: as
372: ddp_timeout_setup_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;
373: ddx_complete_rec pvx_timeout_setup_pvt.timeout_setup_rec_type;