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 rosetta_table_copy_in_p2(t OUT NOCOPY ams_imp_doc_pvt.imp_doc_tbl_type, a0 JTF_NUMBER_TABLE
137: , p7_a1 NUMBER := 0-1962.0724
138: , p7_a2 NUMBER := 0-1962.0724
139: , p7_a3 NUMBER := 0-1962.0724
140: , p7_a4 NUMBER := 0-1962.0724
141: , p7_a5 DATE := fnd_api.g_miss_date
142: , p7_a6 DATE := fnd_api.g_miss_date
143: , p7_a7 NUMBER := 0-1962.0724
144: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a9 NUMBER := 0-1962.0724
138: , p7_a2 NUMBER := 0-1962.0724
139: , p7_a3 NUMBER := 0-1962.0724
140: , p7_a4 NUMBER := 0-1962.0724
141: , p7_a5 DATE := fnd_api.g_miss_date
142: , p7_a6 DATE := fnd_api.g_miss_date
143: , p7_a7 NUMBER := 0-1962.0724
144: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a9 NUMBER := 0-1962.0724
146: )
140: , p7_a4 NUMBER := 0-1962.0724
141: , p7_a5 DATE := fnd_api.g_miss_date
142: , p7_a6 DATE := fnd_api.g_miss_date
143: , p7_a7 NUMBER := 0-1962.0724
144: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a9 NUMBER := 0-1962.0724
146: )
147: as
148: ddp_imp_doc_rec ams_imp_doc_pvt.imp_doc_rec_type;
203: , p7_a1 NUMBER := 0-1962.0724
204: , p7_a2 NUMBER := 0-1962.0724
205: , p7_a3 NUMBER := 0-1962.0724
206: , p7_a4 NUMBER := 0-1962.0724
207: , p7_a5 DATE := fnd_api.g_miss_date
208: , p7_a6 DATE := fnd_api.g_miss_date
209: , p7_a7 NUMBER := 0-1962.0724
210: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a9 NUMBER := 0-1962.0724
204: , p7_a2 NUMBER := 0-1962.0724
205: , p7_a3 NUMBER := 0-1962.0724
206: , p7_a4 NUMBER := 0-1962.0724
207: , p7_a5 DATE := fnd_api.g_miss_date
208: , p7_a6 DATE := fnd_api.g_miss_date
209: , p7_a7 NUMBER := 0-1962.0724
210: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a9 NUMBER := 0-1962.0724
212: )
206: , p7_a4 NUMBER := 0-1962.0724
207: , p7_a5 DATE := fnd_api.g_miss_date
208: , p7_a6 DATE := fnd_api.g_miss_date
209: , p7_a7 NUMBER := 0-1962.0724
210: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a9 NUMBER := 0-1962.0724
212: )
213: as
214: ddp_imp_doc_rec ams_imp_doc_pvt.imp_doc_rec_type;
268: , p3_a1 NUMBER := 0-1962.0724
269: , p3_a2 NUMBER := 0-1962.0724
270: , p3_a3 NUMBER := 0-1962.0724
271: , p3_a4 NUMBER := 0-1962.0724
272: , p3_a5 DATE := fnd_api.g_miss_date
273: , p3_a6 DATE := fnd_api.g_miss_date
274: , p3_a7 NUMBER := 0-1962.0724
275: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
276: , p3_a9 NUMBER := 0-1962.0724
269: , p3_a2 NUMBER := 0-1962.0724
270: , p3_a3 NUMBER := 0-1962.0724
271: , p3_a4 NUMBER := 0-1962.0724
272: , p3_a5 DATE := fnd_api.g_miss_date
273: , p3_a6 DATE := fnd_api.g_miss_date
274: , p3_a7 NUMBER := 0-1962.0724
275: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
276: , p3_a9 NUMBER := 0-1962.0724
277: )
271: , p3_a4 NUMBER := 0-1962.0724
272: , p3_a5 DATE := fnd_api.g_miss_date
273: , p3_a6 DATE := fnd_api.g_miss_date
274: , p3_a7 NUMBER := 0-1962.0724
275: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
276: , p3_a9 NUMBER := 0-1962.0724
277: )
278: as
279: ddp_imp_doc_rec ams_imp_doc_pvt.imp_doc_rec_type;
325: , p0_a1 NUMBER := 0-1962.0724
326: , p0_a2 NUMBER := 0-1962.0724
327: , p0_a3 NUMBER := 0-1962.0724
328: , p0_a4 NUMBER := 0-1962.0724
329: , p0_a5 DATE := fnd_api.g_miss_date
330: , p0_a6 DATE := fnd_api.g_miss_date
331: , p0_a7 NUMBER := 0-1962.0724
332: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
333: , p0_a9 NUMBER := 0-1962.0724
326: , p0_a2 NUMBER := 0-1962.0724
327: , p0_a3 NUMBER := 0-1962.0724
328: , p0_a4 NUMBER := 0-1962.0724
329: , p0_a5 DATE := fnd_api.g_miss_date
330: , p0_a6 DATE := fnd_api.g_miss_date
331: , p0_a7 NUMBER := 0-1962.0724
332: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
333: , p0_a9 NUMBER := 0-1962.0724
334: )
328: , p0_a4 NUMBER := 0-1962.0724
329: , p0_a5 DATE := fnd_api.g_miss_date
330: , p0_a6 DATE := fnd_api.g_miss_date
331: , p0_a7 NUMBER := 0-1962.0724
332: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
333: , p0_a9 NUMBER := 0-1962.0724
334: )
335: as
336: ddp_imp_doc_rec ams_imp_doc_pvt.imp_doc_rec_type;
370: , p5_a1 NUMBER := 0-1962.0724
371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 NUMBER := 0-1962.0724
373: , p5_a4 NUMBER := 0-1962.0724
374: , p5_a5 DATE := fnd_api.g_miss_date
375: , p5_a6 DATE := fnd_api.g_miss_date
376: , p5_a7 NUMBER := 0-1962.0724
377: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a9 NUMBER := 0-1962.0724
371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 NUMBER := 0-1962.0724
373: , p5_a4 NUMBER := 0-1962.0724
374: , p5_a5 DATE := fnd_api.g_miss_date
375: , p5_a6 DATE := fnd_api.g_miss_date
376: , p5_a7 NUMBER := 0-1962.0724
377: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a9 NUMBER := 0-1962.0724
379: )
373: , p5_a4 NUMBER := 0-1962.0724
374: , p5_a5 DATE := fnd_api.g_miss_date
375: , p5_a6 DATE := fnd_api.g_miss_date
376: , p5_a7 NUMBER := 0-1962.0724
377: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a9 NUMBER := 0-1962.0724
379: )
380: as
381: ddp_imp_doc_rec ams_imp_doc_pvt.imp_doc_rec_type;