eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_PUB_W dependencies on OE_ORDER_PUB

Line 1: package body oe_order_pub_w as

1: package body oe_order_pub_w as
2: /* $Header: ONTRORDB.pls 120.1 2005/07/01 13:02:59 appldev ship $ */
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:

Line 22: procedure rosetta_table_copy_in_p1(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_VARCHAR2_TABLE_300

Line 471: procedure rosetta_table_copy_out_p1(t oe_order_pub.header_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

467: end loop;
468: end if;
469: end if;
470: end rosetta_table_copy_in_p1;
471: procedure rosetta_table_copy_out_p1(t oe_order_pub.header_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
472: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
473: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
474: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
475: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 1570: procedure rosetta_table_copy_in_p3(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300

1566: end if;
1567: end if;
1568: end rosetta_table_copy_out_p1;
1569:
1570: procedure rosetta_table_copy_in_p3(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300
1571: , a1 JTF_VARCHAR2_TABLE_300
1572: , a2 JTF_VARCHAR2_TABLE_300
1573: , a3 JTF_VARCHAR2_TABLE_300
1574: , a4 JTF_VARCHAR2_TABLE_300

Line 1871: procedure rosetta_table_copy_out_p3(t oe_order_pub.header_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

1867: end loop;
1868: end if;
1869: end if;
1870: end rosetta_table_copy_in_p3;
1871: procedure rosetta_table_copy_out_p3(t oe_order_pub.header_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1872: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1873: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1874: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1875: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 2600: procedure rosetta_table_copy_in_p5(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_adj_tbl_type, a0 JTF_VARCHAR2_TABLE_300

2596: end if;
2597: end if;
2598: end rosetta_table_copy_out_p3;
2599:
2600: procedure rosetta_table_copy_in_p5(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_adj_tbl_type, a0 JTF_VARCHAR2_TABLE_300
2601: , a1 JTF_VARCHAR2_TABLE_300
2602: , a2 JTF_VARCHAR2_TABLE_300
2603: , a3 JTF_VARCHAR2_TABLE_300
2604: , a4 JTF_VARCHAR2_TABLE_300

Line 2829: procedure rosetta_table_copy_out_p5(t oe_order_pub.header_adj_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

2825: end loop;
2826: end if;
2827: end if;
2828: end rosetta_table_copy_in_p5;
2829: procedure rosetta_table_copy_out_p5(t oe_order_pub.header_adj_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
2830: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
2831: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
2832: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
2833: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 3378: procedure rosetta_table_copy_in_p7(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_adj_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300

3374: end if;
3375: end if;
3376: end rosetta_table_copy_out_p5;
3377:
3378: procedure rosetta_table_copy_in_p7(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_adj_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300
3379: , a1 JTF_VARCHAR2_TABLE_300
3380: , a2 JTF_VARCHAR2_TABLE_100
3381: ) as
3382: ddindx binary_integer; indx binary_integer;

Line 3401: procedure rosetta_table_copy_out_p7(t oe_order_pub.header_adj_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

3397: end loop;
3398: end if;
3399: end if;
3400: end rosetta_table_copy_in_p7;
3401: procedure rosetta_table_copy_out_p7(t oe_order_pub.header_adj_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
3402: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
3403: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
3404: ) as
3405: ddindx binary_integer; indx binary_integer;

Line 3435: procedure rosetta_table_copy_in_p9(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_price_att_tbl_type, a0 JTF_NUMBER_TABLE

3431: end if;
3432: end if;
3433: end rosetta_table_copy_out_p7;
3434:
3435: procedure rosetta_table_copy_in_p9(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_price_att_tbl_type, a0 JTF_NUMBER_TABLE
3436: , a1 JTF_NUMBER_TABLE
3437: , a2 JTF_NUMBER_TABLE
3438: , a3 JTF_DATE_TABLE
3439: , a4 JTF_NUMBER_TABLE

Line 3726: procedure rosetta_table_copy_out_p9(t oe_order_pub.header_price_att_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

3722: end loop;
3723: end if;
3724: end if;
3725: end rosetta_table_copy_in_p9;
3726: procedure rosetta_table_copy_out_p9(t oe_order_pub.header_price_att_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
3727: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
3728: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
3729: , a3 out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
3730: , a4 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 4430: procedure rosetta_table_copy_in_p11(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_adj_att_tbl_type, a0 JTF_NUMBER_TABLE

4426: end if;
4427: end if;
4428: end rosetta_table_copy_out_p9;
4429:
4430: procedure rosetta_table_copy_in_p11(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_adj_att_tbl_type, a0 JTF_NUMBER_TABLE
4431: , a1 JTF_NUMBER_TABLE
4432: , a2 JTF_NUMBER_TABLE
4433: , a3 JTF_VARCHAR2_TABLE_100
4434: , a4 JTF_VARCHAR2_TABLE_100

Line 4491: procedure rosetta_table_copy_out_p11(t oe_order_pub.header_adj_att_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

4487: end loop;
4488: end if;
4489: end if;
4490: end rosetta_table_copy_in_p11;
4491: procedure rosetta_table_copy_out_p11(t oe_order_pub.header_adj_att_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
4492: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
4493: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
4494: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
4495: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 4620: procedure rosetta_table_copy_in_p13(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_adj_assoc_tbl_type, a0 JTF_NUMBER_TABLE

4616: end if;
4617: end if;
4618: end rosetta_table_copy_out_p11;
4619:
4620: procedure rosetta_table_copy_in_p13(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_adj_assoc_tbl_type, a0 JTF_NUMBER_TABLE
4621: , a1 JTF_NUMBER_TABLE
4622: , a2 JTF_NUMBER_TABLE
4623: , a3 JTF_NUMBER_TABLE
4624: , a4 JTF_NUMBER_TABLE

Line 4677: procedure rosetta_table_copy_out_p13(t oe_order_pub.header_adj_assoc_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

4673: end loop;
4674: end if;
4675: end if;
4676: end rosetta_table_copy_in_p13;
4677: procedure rosetta_table_copy_out_p13(t oe_order_pub.header_adj_assoc_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
4678: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
4679: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
4680: , a3 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
4681: , a4 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 4796: procedure rosetta_table_copy_in_p15(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_scredit_tbl_type, a0 JTF_VARCHAR2_TABLE_300

4792: end if;
4793: end if;
4794: end rosetta_table_copy_out_p13;
4795:
4796: procedure rosetta_table_copy_in_p15(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_scredit_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4797: , a1 JTF_VARCHAR2_TABLE_300
4798: , a2 JTF_VARCHAR2_TABLE_300
4799: , a3 JTF_VARCHAR2_TABLE_300
4800: , a4 JTF_VARCHAR2_TABLE_300

Line 4893: procedure rosetta_table_copy_out_p15(t oe_order_pub.header_scredit_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

4889: end loop;
4890: end if;
4891: end if;
4892: end rosetta_table_copy_in_p15;
4893: procedure rosetta_table_copy_out_p15(t oe_order_pub.header_scredit_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
4894: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
4895: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
4896: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
4897: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 5112: procedure rosetta_table_copy_in_p17(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_scredit_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300

5108: end if;
5109: end if;
5110: end rosetta_table_copy_out_p15;
5111:
5112: procedure rosetta_table_copy_in_p17(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_scredit_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300
5113: , a1 JTF_VARCHAR2_TABLE_300
5114: , a2 JTF_VARCHAR2_TABLE_300
5115: ) as
5116: ddindx binary_integer; indx binary_integer;

Line 5135: procedure rosetta_table_copy_out_p17(t oe_order_pub.header_scredit_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

5131: end loop;
5132: end if;
5133: end if;
5134: end rosetta_table_copy_in_p17;
5135: procedure rosetta_table_copy_out_p17(t oe_order_pub.header_scredit_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
5136: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
5137: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
5138: ) as
5139: ddindx binary_integer; indx binary_integer;

Line 5169: procedure rosetta_table_copy_in_p19(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_tbl_type, a0 JTF_NUMBER_TABLE

5165: end if;
5166: end if;
5167: end rosetta_table_copy_out_p17;
5168:
5169: procedure rosetta_table_copy_in_p19(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
5170: , a1 JTF_DATE_TABLE
5171: , a2 JTF_DATE_TABLE
5172: , a3 JTF_NUMBER_TABLE
5173: , a4 JTF_NUMBER_TABLE

Line 5753: procedure rosetta_table_copy_out_p19(t oe_order_pub.line_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

5749: end loop;
5750: end if;
5751: end if;
5752: end rosetta_table_copy_in_p19;
5753: procedure rosetta_table_copy_out_p19(t oe_order_pub.line_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
5754: , a1 out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
5755: , a2 out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
5756: , a3 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
5757: , a4 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 7182: procedure rosetta_table_copy_in_p21(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300

7178: end if;
7179: end if;
7180: end rosetta_table_copy_out_p19;
7181:
7182: procedure rosetta_table_copy_in_p21(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300
7183: , a1 JTF_VARCHAR2_TABLE_300
7184: , a2 JTF_VARCHAR2_TABLE_300
7185: , a3 JTF_NUMBER_TABLE
7186: , a4 JTF_VARCHAR2_TABLE_300

Line 7491: procedure rosetta_table_copy_out_p21(t oe_order_pub.line_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

7487: end loop;
7488: end if;
7489: end if;
7490: end rosetta_table_copy_in_p21;
7491: procedure rosetta_table_copy_out_p21(t oe_order_pub.line_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
7492: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
7493: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
7494: , a3 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
7495: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 8240: procedure rosetta_table_copy_in_p23(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_adj_tbl_type, a0 JTF_VARCHAR2_TABLE_300

8236: end if;
8237: end if;
8238: end rosetta_table_copy_out_p21;
8239:
8240: procedure rosetta_table_copy_in_p23(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_adj_tbl_type, a0 JTF_VARCHAR2_TABLE_300
8241: , a1 JTF_VARCHAR2_TABLE_300
8242: , a2 JTF_VARCHAR2_TABLE_300
8243: , a3 JTF_VARCHAR2_TABLE_300
8244: , a4 JTF_VARCHAR2_TABLE_300

Line 8475: procedure rosetta_table_copy_out_p23(t oe_order_pub.line_adj_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

8471: end loop;
8472: end if;
8473: end if;
8474: end rosetta_table_copy_in_p23;
8475: procedure rosetta_table_copy_out_p23(t oe_order_pub.line_adj_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
8476: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
8477: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
8478: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
8479: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 9039: procedure rosetta_table_copy_in_p25(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_adj_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300

9035: end if;
9036: end if;
9037: end rosetta_table_copy_out_p23;
9038:
9039: procedure rosetta_table_copy_in_p25(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_adj_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300
9040: , a1 JTF_VARCHAR2_TABLE_300
9041: , a2 JTF_VARCHAR2_TABLE_100
9042: ) as
9043: ddindx binary_integer; indx binary_integer;

Line 9062: procedure rosetta_table_copy_out_p25(t oe_order_pub.line_adj_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

9058: end loop;
9059: end if;
9060: end if;
9061: end rosetta_table_copy_in_p25;
9062: procedure rosetta_table_copy_out_p25(t oe_order_pub.line_adj_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
9063: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
9064: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
9065: ) as
9066: ddindx binary_integer; indx binary_integer;

Line 9096: procedure rosetta_table_copy_in_p27(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_price_att_tbl_type, a0 JTF_NUMBER_TABLE

9092: end if;
9093: end if;
9094: end rosetta_table_copy_out_p25;
9095:
9096: procedure rosetta_table_copy_in_p27(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_price_att_tbl_type, a0 JTF_NUMBER_TABLE
9097: , a1 JTF_NUMBER_TABLE
9098: , a2 JTF_NUMBER_TABLE
9099: , a3 JTF_NUMBER_TABLE
9100: , a4 JTF_DATE_TABLE

Line 9389: procedure rosetta_table_copy_out_p27(t oe_order_pub.line_price_att_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

9385: end loop;
9386: end if;
9387: end if;
9388: end rosetta_table_copy_in_p27;
9389: procedure rosetta_table_copy_out_p27(t oe_order_pub.line_price_att_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
9390: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
9391: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
9392: , a3 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
9393: , a4 out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 10098: procedure rosetta_table_copy_in_p29(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_adj_att_tbl_type, a0 JTF_NUMBER_TABLE

10094: end if;
10095: end if;
10096: end rosetta_table_copy_out_p27;
10097:
10098: procedure rosetta_table_copy_in_p29(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_adj_att_tbl_type, a0 JTF_NUMBER_TABLE
10099: , a1 JTF_NUMBER_TABLE
10100: , a2 JTF_NUMBER_TABLE
10101: , a3 JTF_VARCHAR2_TABLE_100
10102: , a4 JTF_VARCHAR2_TABLE_100

Line 10159: procedure rosetta_table_copy_out_p29(t oe_order_pub.line_adj_att_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

10155: end loop;
10156: end if;
10157: end if;
10158: end rosetta_table_copy_in_p29;
10159: procedure rosetta_table_copy_out_p29(t oe_order_pub.line_adj_att_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10160: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10161: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10162: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
10163: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 10288: procedure rosetta_table_copy_in_p31(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_adj_assoc_tbl_type, a0 JTF_NUMBER_TABLE

10284: end if;
10285: end if;
10286: end rosetta_table_copy_out_p29;
10287:
10288: procedure rosetta_table_copy_in_p31(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_adj_assoc_tbl_type, a0 JTF_NUMBER_TABLE
10289: , a1 JTF_NUMBER_TABLE
10290: , a2 JTF_NUMBER_TABLE
10291: , a3 JTF_NUMBER_TABLE
10292: , a4 JTF_NUMBER_TABLE

Line 10345: procedure rosetta_table_copy_out_p31(t oe_order_pub.line_adj_assoc_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

10341: end loop;
10342: end if;
10343: end if;
10344: end rosetta_table_copy_in_p31;
10345: procedure rosetta_table_copy_out_p31(t oe_order_pub.line_adj_assoc_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10346: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10347: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10348: , a3 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10349: , a4 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 10464: procedure rosetta_table_copy_in_p33(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_scredit_tbl_type, a0 JTF_VARCHAR2_TABLE_300

10460: end if;
10461: end if;
10462: end rosetta_table_copy_out_p31;
10463:
10464: procedure rosetta_table_copy_in_p33(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_scredit_tbl_type, a0 JTF_VARCHAR2_TABLE_300
10465: , a1 JTF_VARCHAR2_TABLE_300
10466: , a2 JTF_VARCHAR2_TABLE_300
10467: , a3 JTF_VARCHAR2_TABLE_300
10468: , a4 JTF_VARCHAR2_TABLE_300

Line 10563: procedure rosetta_table_copy_out_p33(t oe_order_pub.line_scredit_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

10559: end loop;
10560: end if;
10561: end if;
10562: end rosetta_table_copy_in_p33;
10563: procedure rosetta_table_copy_out_p33(t oe_order_pub.line_scredit_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10564: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10565: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10566: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10567: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 10787: procedure rosetta_table_copy_in_p35(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_scredit_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300

10783: end if;
10784: end if;
10785: end rosetta_table_copy_out_p33;
10786:
10787: procedure rosetta_table_copy_in_p35(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_scredit_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300
10788: , a1 JTF_VARCHAR2_TABLE_300
10789: , a2 JTF_VARCHAR2_TABLE_300
10790: ) as
10791: ddindx binary_integer; indx binary_integer;

Line 10810: procedure rosetta_table_copy_out_p35(t oe_order_pub.line_scredit_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

10806: end loop;
10807: end if;
10808: end if;
10809: end rosetta_table_copy_in_p35;
10810: procedure rosetta_table_copy_out_p35(t oe_order_pub.line_scredit_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10811: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10812: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10813: ) as
10814: ddindx binary_integer; indx binary_integer;

Line 10844: procedure rosetta_table_copy_in_p37(t out NOCOPY /* file.sql.39 change */ oe_order_pub.lot_serial_tbl_type, a0 JTF_VARCHAR2_TABLE_300

10840: end if;
10841: end if;
10842: end rosetta_table_copy_out_p35;
10843:
10844: procedure rosetta_table_copy_in_p37(t out NOCOPY /* file.sql.39 change */ oe_order_pub.lot_serial_tbl_type, a0 JTF_VARCHAR2_TABLE_300
10845: , a1 JTF_VARCHAR2_TABLE_300
10846: , a2 JTF_VARCHAR2_TABLE_300
10847: , a3 JTF_VARCHAR2_TABLE_300
10848: , a4 JTF_VARCHAR2_TABLE_300

Line 10937: procedure rosetta_table_copy_out_p37(t oe_order_pub.lot_serial_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

10933: end loop;
10934: end if;
10935: end if;
10936: end rosetta_table_copy_in_p37;
10937: procedure rosetta_table_copy_out_p37(t oe_order_pub.lot_serial_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10938: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10939: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10940: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
10941: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 11146: procedure rosetta_table_copy_in_p39(t out NOCOPY /* file.sql.39 change */ oe_order_pub.lot_serial_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300

11142: end if;
11143: end if;
11144: end rosetta_table_copy_out_p37;
11145:
11146: procedure rosetta_table_copy_in_p39(t out NOCOPY /* file.sql.39 change */ oe_order_pub.lot_serial_val_tbl_type, a0 JTF_VARCHAR2_TABLE_300
11147: , a1 JTF_VARCHAR2_TABLE_300
11148: ) as
11149: ddindx binary_integer; indx binary_integer;
11150: begin

Line 11167: procedure rosetta_table_copy_out_p39(t oe_order_pub.lot_serial_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

11163: end loop;
11164: end if;
11165: end if;
11166: end rosetta_table_copy_in_p39;
11167: procedure rosetta_table_copy_out_p39(t oe_order_pub.lot_serial_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
11168: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
11169: ) as
11170: ddindx binary_integer; indx binary_integer;
11171: begin

Line 11196: procedure rosetta_table_copy_in_p41(t out NOCOPY /* file.sql.39 change */ oe_order_pub.reservation_tbl_type, a0 JTF_VARCHAR2_TABLE_100

11192: end if;
11193: end if;
11194: end rosetta_table_copy_out_p39;
11195:
11196: procedure rosetta_table_copy_in_p41(t out NOCOPY /* file.sql.39 change */ oe_order_pub.reservation_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11197: , a1 JTF_VARCHAR2_TABLE_100
11198: , a2 JTF_NUMBER_TABLE
11199: , a3 JTF_NUMBER_TABLE
11200: , a4 JTF_NUMBER_TABLE

Line 11265: procedure rosetta_table_copy_out_p41(t oe_order_pub.reservation_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

11261: end loop;
11262: end if;
11263: end if;
11264: end rosetta_table_copy_in_p41;
11265: procedure rosetta_table_copy_out_p41(t oe_order_pub.reservation_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11266: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11267: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11268: , a3 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11269: , a4 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 11414: procedure rosetta_table_copy_in_p43(t out NOCOPY /* file.sql.39 change */ oe_order_pub.reservation_val_tbl_type, a0 JTF_VARCHAR2_TABLE_100

11410: end if;
11411: end if;
11412: end rosetta_table_copy_out_p41;
11413:
11414: procedure rosetta_table_copy_in_p43(t out NOCOPY /* file.sql.39 change */ oe_order_pub.reservation_val_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11415: , a1 JTF_VARCHAR2_TABLE_100
11416: ) as
11417: ddindx binary_integer; indx binary_integer;
11418: begin

Line 11435: procedure rosetta_table_copy_out_p43(t oe_order_pub.reservation_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

11431: end loop;
11432: end if;
11433: end if;
11434: end rosetta_table_copy_in_p43;
11435: procedure rosetta_table_copy_out_p43(t oe_order_pub.reservation_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11436: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11437: ) as
11438: ddindx binary_integer; indx binary_integer;
11439: begin

Line 11464: procedure rosetta_table_copy_in_p47(t out NOCOPY /* file.sql.39 change */ oe_order_pub.request_tbl_type, a0 JTF_VARCHAR2_TABLE_100

11460: end if;
11461: end if;
11462: end rosetta_table_copy_out_p43;
11463:
11464: procedure rosetta_table_copy_in_p47(t out NOCOPY /* file.sql.39 change */ oe_order_pub.request_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11465: , a1 JTF_NUMBER_TABLE
11466: , a2 JTF_NUMBER_TABLE
11467: , a3 JTF_VARCHAR2_TABLE_100
11468: , a4 JTF_VARCHAR2_TABLE_100

Line 11571: procedure rosetta_table_copy_out_p47(t oe_order_pub.request_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

11567: end loop;
11568: end if;
11569: end if;
11570: end rosetta_table_copy_in_p47;
11571: procedure rosetta_table_copy_out_p47(t oe_order_pub.request_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11572: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11573: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11574: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11575: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 11815: procedure rosetta_table_copy_in_p49(t out NOCOPY /* file.sql.39 change */ oe_order_pub.requesting_entity_tbl_type, a0 JTF_VARCHAR2_TABLE_100

11811: end if;
11812: end if;
11813: end rosetta_table_copy_out_p47;
11814:
11815: procedure rosetta_table_copy_in_p49(t out NOCOPY /* file.sql.39 change */ oe_order_pub.requesting_entity_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11816: , a1 JTF_NUMBER_TABLE
11817: , a2 JTF_NUMBER_TABLE
11818: ) as
11819: ddindx binary_integer; indx binary_integer;

Line 11838: procedure rosetta_table_copy_out_p49(t oe_order_pub.requesting_entity_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

11834: end loop;
11835: end if;
11836: end if;
11837: end rosetta_table_copy_in_p49;
11838: procedure rosetta_table_copy_out_p49(t oe_order_pub.requesting_entity_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11839: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11840: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11841: ) as
11842: ddindx binary_integer; indx binary_integer;

Line 11872: procedure rosetta_table_copy_in_p51(t out NOCOPY /* file.sql.39 change */ oe_order_pub.cancel_line_tbl_type, a0 JTF_NUMBER_TABLE

11868: end if;
11869: end if;
11870: end rosetta_table_copy_out_p49;
11871:
11872: procedure rosetta_table_copy_in_p51(t out NOCOPY /* file.sql.39 change */ oe_order_pub.cancel_line_tbl_type, a0 JTF_NUMBER_TABLE
11873: , a1 JTF_NUMBER_TABLE
11874: , a2 JTF_VARCHAR2_TABLE_100
11875: , a3 JTF_NUMBER_TABLE
11876: , a4 JTF_VARCHAR2_TABLE_100

Line 11921: procedure rosetta_table_copy_out_p51(t oe_order_pub.cancel_line_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

11917: end loop;
11918: end if;
11919: end if;
11920: end rosetta_table_copy_in_p51;
11921: procedure rosetta_table_copy_out_p51(t oe_order_pub.cancel_line_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11922: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11923: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11924: , a3 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11925: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 12020: procedure rosetta_table_copy_in_p53(t out NOCOPY /* file.sql.39 change */ oe_order_pub.payment_types_tbl_type, a0 JTF_NUMBER_TABLE

12016: end if;
12017: end if;
12018: end rosetta_table_copy_out_p51;
12019:
12020: procedure rosetta_table_copy_in_p53(t out NOCOPY /* file.sql.39 change */ oe_order_pub.payment_types_tbl_type, a0 JTF_NUMBER_TABLE
12021: , a1 JTF_NUMBER_TABLE
12022: , a2 JTF_NUMBER_TABLE
12023: , a3 JTF_VARCHAR2_TABLE_100
12024: , a4 JTF_NUMBER_TABLE

Line 12105: procedure rosetta_table_copy_out_p53(t oe_order_pub.payment_types_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

12101: end loop;
12102: end if;
12103: end if;
12104: end rosetta_table_copy_in_p53;
12105: procedure rosetta_table_copy_out_p53(t oe_order_pub.payment_types_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
12106: , a1 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
12107: , a2 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
12108: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12109: , a4 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 12294: procedure rosetta_table_copy_in_p55(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_payment_tbl_type, a0 JTF_VARCHAR2_TABLE_300

12290: end if;
12291: end if;
12292: end rosetta_table_copy_out_p53;
12293:
12294: procedure rosetta_table_copy_in_p55(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_payment_tbl_type, a0 JTF_VARCHAR2_TABLE_300
12295: , a1 JTF_VARCHAR2_TABLE_300
12296: , a2 JTF_VARCHAR2_TABLE_300
12297: , a3 JTF_VARCHAR2_TABLE_300
12298: , a4 JTF_VARCHAR2_TABLE_300

Line 12417: procedure rosetta_table_copy_out_p55(t oe_order_pub.header_payment_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

12413: end loop;
12414: end if;
12415: end if;
12416: end rosetta_table_copy_in_p55;
12417: procedure rosetta_table_copy_out_p55(t oe_order_pub.header_payment_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
12418: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
12419: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
12420: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
12421: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 12701: procedure rosetta_table_copy_in_p57(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_payment_val_tbl_type, a0 JTF_VARCHAR2_TABLE_100

12697: end if;
12698: end if;
12699: end rosetta_table_copy_out_p55;
12700:
12701: procedure rosetta_table_copy_in_p57(t out NOCOPY /* file.sql.39 change */ oe_order_pub.header_payment_val_tbl_type, a0 JTF_VARCHAR2_TABLE_100
12702: , a1 JTF_VARCHAR2_TABLE_100
12703: , a2 JTF_VARCHAR2_TABLE_100
12704: , a3 JTF_VARCHAR2_TABLE_100
12705: , a4 JTF_NUMBER_TABLE

Line 12728: procedure rosetta_table_copy_out_p57(t oe_order_pub.header_payment_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

12724: end loop;
12725: end if;
12726: end if;
12727: end rosetta_table_copy_in_p57;
12728: procedure rosetta_table_copy_out_p57(t oe_order_pub.header_payment_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12729: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12730: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12731: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12732: , a4 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 12772: procedure rosetta_table_copy_in_p59(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_payment_tbl_type, a0 JTF_VARCHAR2_TABLE_300

12768: end if;
12769: end if;
12770: end rosetta_table_copy_out_p57;
12771:
12772: procedure rosetta_table_copy_in_p59(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_payment_tbl_type, a0 JTF_VARCHAR2_TABLE_300
12773: , a1 JTF_VARCHAR2_TABLE_300
12774: , a2 JTF_VARCHAR2_TABLE_300
12775: , a3 JTF_VARCHAR2_TABLE_300
12776: , a4 JTF_VARCHAR2_TABLE_300

Line 12897: procedure rosetta_table_copy_out_p59(t oe_order_pub.line_payment_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

12893: end loop;
12894: end if;
12895: end if;
12896: end rosetta_table_copy_in_p59;
12897: procedure rosetta_table_copy_out_p59(t oe_order_pub.line_payment_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
12898: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
12899: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
12900: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
12901: , a4 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 13186: procedure rosetta_table_copy_in_p61(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_payment_val_tbl_type, a0 JTF_VARCHAR2_TABLE_100

13182: end if;
13183: end if;
13184: end rosetta_table_copy_out_p59;
13185:
13186: procedure rosetta_table_copy_in_p61(t out NOCOPY /* file.sql.39 change */ oe_order_pub.line_payment_val_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13187: , a1 JTF_VARCHAR2_TABLE_100
13188: , a2 JTF_VARCHAR2_TABLE_100
13189: , a3 JTF_VARCHAR2_TABLE_100
13190: , a4 JTF_NUMBER_TABLE

Line 13213: procedure rosetta_table_copy_out_p61(t oe_order_pub.line_payment_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

13209: end loop;
13210: end if;
13211: end if;
13212: end rosetta_table_copy_in_p61;
13213: procedure rosetta_table_copy_out_p61(t oe_order_pub.line_payment_val_tbl_type, a0 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13214: , a1 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13215: , a2 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13216: , a3 out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13217: , a4 out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 13257: end oe_order_pub_w;

13253: end if;
13254: end if;
13255: end rosetta_table_copy_out_p61;
13256:
13257: end oe_order_pub_w;