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;
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
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
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
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;
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;
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
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
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;
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;
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
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
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;
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;
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
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
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;
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;
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
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
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
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
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
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
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;
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;
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
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
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;
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;