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_list_word_replace(p_api_version NUMBER
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , x_wrd_rpl_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_wrd_rpl_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 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: )
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: )
42: as
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: )
42: as
43: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: )
42: as
43: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
44: ddindx binary_integer; indx binary_integer;
94: , x_return_status OUT NOCOPY VARCHAR2
95: , x_msg_count OUT NOCOPY NUMBER
96: , x_msg_data OUT NOCOPY VARCHAR2
97: , p7_a0 NUMBER := 0-1962.0724
98: , p7_a1 DATE := fnd_api.g_miss_date
99: , p7_a2 NUMBER := 0-1962.0724
100: , p7_a3 DATE := fnd_api.g_miss_date
101: , p7_a4 NUMBER := 0-1962.0724
102: , p7_a5 NUMBER := 0-1962.0724
96: , x_msg_data OUT NOCOPY VARCHAR2
97: , p7_a0 NUMBER := 0-1962.0724
98: , p7_a1 DATE := fnd_api.g_miss_date
99: , p7_a2 NUMBER := 0-1962.0724
100: , p7_a3 DATE := fnd_api.g_miss_date
101: , p7_a4 NUMBER := 0-1962.0724
102: , p7_a5 NUMBER := 0-1962.0724
103: , p7_a6 NUMBER := 0-1962.0724
104: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a3 DATE := fnd_api.g_miss_date
101: , p7_a4 NUMBER := 0-1962.0724
102: , p7_a5 NUMBER := 0-1962.0724
103: , p7_a6 NUMBER := 0-1962.0724
104: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
108: )
101: , p7_a4 NUMBER := 0-1962.0724
102: , p7_a5 NUMBER := 0-1962.0724
103: , p7_a6 NUMBER := 0-1962.0724
104: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
108: )
109: as
102: , p7_a5 NUMBER := 0-1962.0724
103: , p7_a6 NUMBER := 0-1962.0724
104: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
108: )
109: as
110: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
103: , p7_a6 NUMBER := 0-1962.0724
104: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
108: )
109: as
110: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
111: ddindx binary_integer; indx binary_integer;
157: , x_return_status OUT NOCOPY VARCHAR2
158: , x_msg_count OUT NOCOPY NUMBER
159: , x_msg_data OUT NOCOPY VARCHAR2
160: , p6_a0 NUMBER := 0-1962.0724
161: , p6_a1 DATE := fnd_api.g_miss_date
162: , p6_a2 NUMBER := 0-1962.0724
163: , p6_a3 DATE := fnd_api.g_miss_date
164: , p6_a4 NUMBER := 0-1962.0724
165: , p6_a5 NUMBER := 0-1962.0724
159: , x_msg_data OUT NOCOPY VARCHAR2
160: , p6_a0 NUMBER := 0-1962.0724
161: , p6_a1 DATE := fnd_api.g_miss_date
162: , p6_a2 NUMBER := 0-1962.0724
163: , p6_a3 DATE := fnd_api.g_miss_date
164: , p6_a4 NUMBER := 0-1962.0724
165: , p6_a5 NUMBER := 0-1962.0724
166: , p6_a6 NUMBER := 0-1962.0724
167: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
163: , p6_a3 DATE := fnd_api.g_miss_date
164: , p6_a4 NUMBER := 0-1962.0724
165: , p6_a5 NUMBER := 0-1962.0724
166: , p6_a6 NUMBER := 0-1962.0724
167: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
168: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
169: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
171: )
164: , p6_a4 NUMBER := 0-1962.0724
165: , p6_a5 NUMBER := 0-1962.0724
166: , p6_a6 NUMBER := 0-1962.0724
167: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
168: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
169: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
171: )
172: as
165: , p6_a5 NUMBER := 0-1962.0724
166: , p6_a6 NUMBER := 0-1962.0724
167: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
168: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
169: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
171: )
172: as
173: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
166: , p6_a6 NUMBER := 0-1962.0724
167: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
168: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
169: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
171: )
172: as
173: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
174: ddindx binary_integer; indx binary_integer;
213:
214: procedure check_items(p_validation_mode VARCHAR2
215: , x_return_status OUT NOCOPY VARCHAR2
216: , p2_a0 NUMBER := 0-1962.0724
217: , p2_a1 DATE := fnd_api.g_miss_date
218: , p2_a2 NUMBER := 0-1962.0724
219: , p2_a3 DATE := fnd_api.g_miss_date
220: , p2_a4 NUMBER := 0-1962.0724
221: , p2_a5 NUMBER := 0-1962.0724
215: , x_return_status OUT NOCOPY VARCHAR2
216: , p2_a0 NUMBER := 0-1962.0724
217: , p2_a1 DATE := fnd_api.g_miss_date
218: , p2_a2 NUMBER := 0-1962.0724
219: , p2_a3 DATE := fnd_api.g_miss_date
220: , p2_a4 NUMBER := 0-1962.0724
221: , p2_a5 NUMBER := 0-1962.0724
222: , p2_a6 NUMBER := 0-1962.0724
223: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
219: , p2_a3 DATE := fnd_api.g_miss_date
220: , p2_a4 NUMBER := 0-1962.0724
221: , p2_a5 NUMBER := 0-1962.0724
222: , p2_a6 NUMBER := 0-1962.0724
223: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
224: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
225: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
226: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
227: )
220: , p2_a4 NUMBER := 0-1962.0724
221: , p2_a5 NUMBER := 0-1962.0724
222: , p2_a6 NUMBER := 0-1962.0724
223: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
224: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
225: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
226: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
227: )
228: as
221: , p2_a5 NUMBER := 0-1962.0724
222: , p2_a6 NUMBER := 0-1962.0724
223: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
224: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
225: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
226: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
227: )
228: as
229: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
222: , p2_a6 NUMBER := 0-1962.0724
223: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
224: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
225: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
226: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
227: )
228: as
229: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
230: ddindx binary_integer; indx binary_integer;
257:
258: procedure check_req_items(p_validation_mode VARCHAR2
259: , x_return_status OUT NOCOPY VARCHAR2
260: , p1_a0 NUMBER := 0-1962.0724
261: , p1_a1 DATE := fnd_api.g_miss_date
262: , p1_a2 NUMBER := 0-1962.0724
263: , p1_a3 DATE := fnd_api.g_miss_date
264: , p1_a4 NUMBER := 0-1962.0724
265: , p1_a5 NUMBER := 0-1962.0724
259: , x_return_status OUT NOCOPY VARCHAR2
260: , p1_a0 NUMBER := 0-1962.0724
261: , p1_a1 DATE := fnd_api.g_miss_date
262: , p1_a2 NUMBER := 0-1962.0724
263: , p1_a3 DATE := fnd_api.g_miss_date
264: , p1_a4 NUMBER := 0-1962.0724
265: , p1_a5 NUMBER := 0-1962.0724
266: , p1_a6 NUMBER := 0-1962.0724
267: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
263: , p1_a3 DATE := fnd_api.g_miss_date
264: , p1_a4 NUMBER := 0-1962.0724
265: , p1_a5 NUMBER := 0-1962.0724
266: , p1_a6 NUMBER := 0-1962.0724
267: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
268: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
269: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
270: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
271: )
264: , p1_a4 NUMBER := 0-1962.0724
265: , p1_a5 NUMBER := 0-1962.0724
266: , p1_a6 NUMBER := 0-1962.0724
267: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
268: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
269: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
270: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
271: )
272: as
265: , p1_a5 NUMBER := 0-1962.0724
266: , p1_a6 NUMBER := 0-1962.0724
267: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
268: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
269: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
270: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
271: )
272: as
273: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
266: , p1_a6 NUMBER := 0-1962.0724
267: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
268: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
269: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
270: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
271: )
272: as
273: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
274: ddindx binary_integer; indx binary_integer;
301:
302: procedure check_uk_items(p_validation_mode VARCHAR2
303: , x_return_status OUT NOCOPY VARCHAR2
304: , p1_a0 NUMBER := 0-1962.0724
305: , p1_a1 DATE := fnd_api.g_miss_date
306: , p1_a2 NUMBER := 0-1962.0724
307: , p1_a3 DATE := fnd_api.g_miss_date
308: , p1_a4 NUMBER := 0-1962.0724
309: , p1_a5 NUMBER := 0-1962.0724
303: , x_return_status OUT NOCOPY VARCHAR2
304: , p1_a0 NUMBER := 0-1962.0724
305: , p1_a1 DATE := fnd_api.g_miss_date
306: , p1_a2 NUMBER := 0-1962.0724
307: , p1_a3 DATE := fnd_api.g_miss_date
308: , p1_a4 NUMBER := 0-1962.0724
309: , p1_a5 NUMBER := 0-1962.0724
310: , p1_a6 NUMBER := 0-1962.0724
311: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a3 DATE := fnd_api.g_miss_date
308: , p1_a4 NUMBER := 0-1962.0724
309: , p1_a5 NUMBER := 0-1962.0724
310: , p1_a6 NUMBER := 0-1962.0724
311: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
314: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
315: )
308: , p1_a4 NUMBER := 0-1962.0724
309: , p1_a5 NUMBER := 0-1962.0724
310: , p1_a6 NUMBER := 0-1962.0724
311: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
314: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
315: )
316: as
309: , p1_a5 NUMBER := 0-1962.0724
310: , p1_a6 NUMBER := 0-1962.0724
311: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
314: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
315: )
316: as
317: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
310: , p1_a6 NUMBER := 0-1962.0724
311: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
312: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
313: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
314: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
315: )
316: as
317: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
318: ddindx binary_integer; indx binary_integer;
354: , p1_a8 OUT NOCOPY VARCHAR2
355: , p1_a9 OUT NOCOPY VARCHAR2
356: , p1_a10 OUT NOCOPY VARCHAR2
357: , p0_a0 NUMBER := 0-1962.0724
358: , p0_a1 DATE := fnd_api.g_miss_date
359: , p0_a2 NUMBER := 0-1962.0724
360: , p0_a3 DATE := fnd_api.g_miss_date
361: , p0_a4 NUMBER := 0-1962.0724
362: , p0_a5 NUMBER := 0-1962.0724
356: , p1_a10 OUT NOCOPY VARCHAR2
357: , p0_a0 NUMBER := 0-1962.0724
358: , p0_a1 DATE := fnd_api.g_miss_date
359: , p0_a2 NUMBER := 0-1962.0724
360: , p0_a3 DATE := fnd_api.g_miss_date
361: , p0_a4 NUMBER := 0-1962.0724
362: , p0_a5 NUMBER := 0-1962.0724
363: , p0_a6 NUMBER := 0-1962.0724
364: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a3 DATE := fnd_api.g_miss_date
361: , p0_a4 NUMBER := 0-1962.0724
362: , p0_a5 NUMBER := 0-1962.0724
363: , p0_a6 NUMBER := 0-1962.0724
364: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
366: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
368: )
361: , p0_a4 NUMBER := 0-1962.0724
362: , p0_a5 NUMBER := 0-1962.0724
363: , p0_a6 NUMBER := 0-1962.0724
364: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
366: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
368: )
369: as
362: , p0_a5 NUMBER := 0-1962.0724
363: , p0_a6 NUMBER := 0-1962.0724
364: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
366: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
368: )
369: as
370: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
363: , p0_a6 NUMBER := 0-1962.0724
364: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
366: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
368: )
369: as
370: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
371: ddx_complete_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;