12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 JTF_DATE_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
59: , a43 JTF_VARCHAR2_TABLE_100
60: , a44 JTF_VARCHAR2_TABLE_100
61: , a45 JTF_NUMBER_TABLE
62: , a46 JTF_VARCHAR2_TABLE_100
63: , a47 JTF_DATE_TABLE
64: , a48 JTF_VARCHAR2_TABLE_100
65: , a49 JTF_VARCHAR2_TABLE_100
66: , a50 JTF_VARCHAR2_TABLE_100
67: , a51 JTF_NUMBER_TABLE
171: end loop;
172: end if;
173: end if;
174: end rosetta_table_copy_in_p2;
175: procedure rosetta_table_copy_out_p2(t ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 out nocopy JTF_DATE_TABLE
176: , a1 out nocopy JTF_NUMBER_TABLE
177: , a2 out nocopy JTF_VARCHAR2_TABLE_100
178: , a3 out nocopy JTF_NUMBER_TABLE
179: , a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , a43 out nocopy JTF_VARCHAR2_TABLE_100
219: , a44 out nocopy JTF_VARCHAR2_TABLE_100
220: , a45 out nocopy JTF_NUMBER_TABLE
221: , a46 out nocopy JTF_VARCHAR2_TABLE_100
222: , a47 out nocopy JTF_DATE_TABLE
223: , a48 out nocopy JTF_VARCHAR2_TABLE_100
224: , a49 out nocopy JTF_VARCHAR2_TABLE_100
225: , a50 out nocopy JTF_VARCHAR2_TABLE_100
226: , a51 out nocopy JTF_NUMBER_TABLE
246: ) as
247: ddindx binary_integer; indx binary_integer;
248: begin
249: if t is null or t.count = 0 then
250: a0 := JTF_DATE_TABLE();
251: a1 := JTF_NUMBER_TABLE();
252: a2 := JTF_VARCHAR2_TABLE_100();
253: a3 := JTF_NUMBER_TABLE();
254: a4 := JTF_VARCHAR2_TABLE_100();
293: a43 := JTF_VARCHAR2_TABLE_100();
294: a44 := JTF_VARCHAR2_TABLE_100();
295: a45 := JTF_NUMBER_TABLE();
296: a46 := JTF_VARCHAR2_TABLE_100();
297: a47 := JTF_DATE_TABLE();
298: a48 := JTF_VARCHAR2_TABLE_100();
299: a49 := JTF_VARCHAR2_TABLE_100();
300: a50 := JTF_VARCHAR2_TABLE_100();
301: a51 := JTF_NUMBER_TABLE();
318: a68 := JTF_VARCHAR2_TABLE_200();
319: a69 := JTF_VARCHAR2_TABLE_200();
320: a70 := JTF_VARCHAR2_TABLE_200();
321: else
322: a0 := JTF_DATE_TABLE();
323: a1 := JTF_NUMBER_TABLE();
324: a2 := JTF_VARCHAR2_TABLE_100();
325: a3 := JTF_NUMBER_TABLE();
326: a4 := JTF_VARCHAR2_TABLE_100();
365: a43 := JTF_VARCHAR2_TABLE_100();
366: a44 := JTF_VARCHAR2_TABLE_100();
367: a45 := JTF_NUMBER_TABLE();
368: a46 := JTF_VARCHAR2_TABLE_100();
369: a47 := JTF_DATE_TABLE();
370: a48 := JTF_VARCHAR2_TABLE_100();
371: a49 := JTF_VARCHAR2_TABLE_100();
372: a50 := JTF_VARCHAR2_TABLE_100();
373: a51 := JTF_NUMBER_TABLE();
659: , p_module_type VARCHAR2
660: , x_return_status out nocopy VARCHAR2
661: , x_msg_count out nocopy NUMBER
662: , x_msg_data out nocopy VARCHAR2
663: , p8_a0 in out nocopy JTF_DATE_TABLE
664: , p8_a1 in out nocopy JTF_NUMBER_TABLE
665: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
666: , p8_a3 in out nocopy JTF_NUMBER_TABLE
667: , p8_a4 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p8_a43 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p8_a44 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p8_a45 in out nocopy JTF_NUMBER_TABLE
709: , p8_a46 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p8_a47 in out nocopy JTF_DATE_TABLE
711: , p8_a48 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p8_a49 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p8_a50 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p8_a51 in out nocopy JTF_NUMBER_TABLE