1: package body eam_est_datastructures_pub_w as
2: /* $Header: EAMPEDWB.pls 120.0.12010000.3 2009/01/03 00:09:24 devijay noship $ */
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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p3(t out nocopy eam_est_datastructures_pub.eam_ce_message_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_2000
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_100
50: end loop;
51: end if;
52: end if;
53: end rosetta_table_copy_in_p3;
54: procedure rosetta_table_copy_out_p3(t eam_est_datastructures_pub.eam_ce_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: end if;
100: end if;
101: end rosetta_table_copy_out_p3;
102:
103: procedure rosetta_table_copy_in_p7(t out nocopy eam_est_datastructures_pub.eam_construction_estimate_tbl, a0 JTF_NUMBER_TABLE
104: , a1 JTF_NUMBER_TABLE
105: , a2 JTF_VARCHAR2_TABLE_100
106: , a3 JTF_VARCHAR2_TABLE_300
107: , a4 JTF_NUMBER_TABLE
162: end loop;
163: end if;
164: end if;
165: end rosetta_table_copy_in_p7;
166: procedure rosetta_table_copy_out_p7(t eam_est_datastructures_pub.eam_construction_estimate_tbl, a0 out nocopy JTF_NUMBER_TABLE
167: , a1 out nocopy JTF_NUMBER_TABLE
168: , a2 out nocopy JTF_VARCHAR2_TABLE_100
169: , a3 out nocopy JTF_VARCHAR2_TABLE_300
170: , a4 out nocopy JTF_NUMBER_TABLE
296: end if;
297: end if;
298: end rosetta_table_copy_out_p7;
299:
300: procedure rosetta_table_copy_in_p9(t out nocopy eam_est_datastructures_pub.eam_construction_units_tbl, a0 JTF_NUMBER_TABLE
301: , a1 JTF_VARCHAR2_TABLE_100
302: , a2 JTF_VARCHAR2_TABLE_300
303: , a3 JTF_NUMBER_TABLE
304: , a4 JTF_DATE_TABLE
325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p9;
329: procedure rosetta_table_copy_out_p9(t eam_est_datastructures_pub.eam_construction_units_tbl, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_VARCHAR2_TABLE_100
331: , a2 out nocopy JTF_VARCHAR2_TABLE_300
332: , a3 out nocopy JTF_NUMBER_TABLE
333: , a4 out nocopy JTF_DATE_TABLE
374: end if;
375: end if;
376: end rosetta_table_copy_out_p9;
377:
378: procedure rosetta_table_copy_in_p11(t out nocopy eam_est_datastructures_pub.eam_estimate_associations_tbl, a0 JTF_NUMBER_TABLE
379: , a1 JTF_NUMBER_TABLE
380: , a2 JTF_NUMBER_TABLE
381: , a3 JTF_NUMBER_TABLE
382: , a4 JTF_NUMBER_TABLE
419: end loop;
420: end if;
421: end if;
422: end rosetta_table_copy_in_p11;
423: procedure rosetta_table_copy_out_p11(t eam_est_datastructures_pub.eam_estimate_associations_tbl, a0 out nocopy JTF_NUMBER_TABLE
424: , a1 out nocopy JTF_NUMBER_TABLE
425: , a2 out nocopy JTF_NUMBER_TABLE
426: , a3 out nocopy JTF_NUMBER_TABLE
427: , a4 out nocopy JTF_NUMBER_TABLE
508: end if;
509: end if;
510: end rosetta_table_copy_out_p11;
511:
512: procedure rosetta_table_copy_in_p13(t out nocopy eam_est_datastructures_pub.eam_ce_work_order_lines_tbl, a0 JTF_NUMBER_TABLE
513: , a1 JTF_NUMBER_TABLE
514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_NUMBER_TABLE
657: end loop;
658: end if;
659: end if;
660: end rosetta_table_copy_in_p13;
661: procedure rosetta_table_copy_out_p13(t eam_est_datastructures_pub.eam_ce_work_order_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
662: , a1 out nocopy JTF_NUMBER_TABLE
663: , a2 out nocopy JTF_NUMBER_TABLE
664: , a3 out nocopy JTF_NUMBER_TABLE
665: , a4 out nocopy JTF_NUMBER_TABLE
1006: end if;
1007: end if;
1008: end rosetta_table_copy_out_p13;
1009:
1010: end eam_est_datastructures_pub_w;