DBA Data[Home] [Help]

APPS.CSE_DATASTRUCTURES_PUB_W dependencies on CSE_DATASTRUCTURES_PUB

Line 1: package body cse_datastructures_pub_w as

1: package body cse_datastructures_pub_w as
2: /* $Header: CSEDATWB.pls 120.1 2008/01/16 21:31:52 devijay 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p24(t out nocopy cse_datastructures_pub.mtl_item_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p24(t out nocopy cse_datastructures_pub.mtl_item_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE

Line 106: procedure rosetta_table_copy_out_p24(t cse_datastructures_pub.mtl_item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

102: end loop;
103: end if;
104: end if;
105: end rosetta_table_copy_in_p24;
106: procedure rosetta_table_copy_out_p24(t cse_datastructures_pub.mtl_item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE

Line 285: procedure rosetta_table_copy_in_p26(t out nocopy cse_datastructures_pub.mtl_instance_tbl_type, a0 JTF_NUMBER_TABLE

281: end if;
282: end if;
283: end rosetta_table_copy_out_p24;
284:
285: procedure rosetta_table_copy_in_p26(t out nocopy cse_datastructures_pub.mtl_instance_tbl_type, a0 JTF_NUMBER_TABLE
286: , a1 JTF_VARCHAR2_TABLE_100
287: , a2 JTF_NUMBER_TABLE
288: , a3 JTF_VARCHAR2_TABLE_100
289: , a4 JTF_NUMBER_TABLE

Line 344: procedure rosetta_table_copy_out_p26(t cse_datastructures_pub.mtl_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

340: end loop;
341: end if;
342: end if;
343: end rosetta_table_copy_in_p26;
344: procedure rosetta_table_copy_out_p26(t cse_datastructures_pub.mtl_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
345: , a1 out nocopy JTF_VARCHAR2_TABLE_100
346: , a2 out nocopy JTF_NUMBER_TABLE
347: , a3 out nocopy JTF_VARCHAR2_TABLE_100
348: , a4 out nocopy JTF_NUMBER_TABLE

Line 468: procedure rosetta_table_copy_in_p29(t out nocopy cse_datastructures_pub.proj_item_uninst_attr_tbl_type, a0 JTF_NUMBER_TABLE

464: end if;
465: end if;
466: end rosetta_table_copy_out_p26;
467:
468: procedure rosetta_table_copy_in_p29(t out nocopy cse_datastructures_pub.proj_item_uninst_attr_tbl_type, a0 JTF_NUMBER_TABLE
469: , a1 JTF_VARCHAR2_TABLE_100
470: , a2 JTF_VARCHAR2_TABLE_100
471: , a3 JTF_VARCHAR2_TABLE_100
472: , a4 JTF_NUMBER_TABLE

Line 511: procedure rosetta_table_copy_out_p29(t cse_datastructures_pub.proj_item_uninst_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

507: end loop;
508: end if;
509: end if;
510: end rosetta_table_copy_in_p29;
511: procedure rosetta_table_copy_out_p29(t cse_datastructures_pub.proj_item_uninst_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
512: , a1 out nocopy JTF_VARCHAR2_TABLE_100
513: , a2 out nocopy JTF_VARCHAR2_TABLE_100
514: , a3 out nocopy JTF_VARCHAR2_TABLE_100
515: , a4 out nocopy JTF_NUMBER_TABLE

Line 595: procedure rosetta_table_copy_in_p31(t out nocopy cse_datastructures_pub.proj_item_inst_attr_tbl_type, a0 JTF_NUMBER_TABLE

591: end if;
592: end if;
593: end rosetta_table_copy_out_p29;
594:
595: procedure rosetta_table_copy_in_p31(t out nocopy cse_datastructures_pub.proj_item_inst_attr_tbl_type, a0 JTF_NUMBER_TABLE
596: , a1 JTF_VARCHAR2_TABLE_100
597: , a2 JTF_VARCHAR2_TABLE_100
598: , a3 JTF_VARCHAR2_TABLE_100
599: , a4 JTF_NUMBER_TABLE

Line 638: procedure rosetta_table_copy_out_p31(t cse_datastructures_pub.proj_item_inst_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

634: end loop;
635: end if;
636: end if;
637: end rosetta_table_copy_in_p31;
638: procedure rosetta_table_copy_out_p31(t cse_datastructures_pub.proj_item_inst_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
639: , a1 out nocopy JTF_VARCHAR2_TABLE_100
640: , a2 out nocopy JTF_VARCHAR2_TABLE_100
641: , a3 out nocopy JTF_VARCHAR2_TABLE_100
642: , a4 out nocopy JTF_NUMBER_TABLE

Line 722: procedure rosetta_table_copy_in_p33(t out nocopy cse_datastructures_pub.out_of_service_attr_tbl_type, a0 JTF_NUMBER_TABLE

718: end if;
719: end if;
720: end rosetta_table_copy_out_p31;
721:
722: procedure rosetta_table_copy_in_p33(t out nocopy cse_datastructures_pub.out_of_service_attr_tbl_type, a0 JTF_NUMBER_TABLE
723: , a1 JTF_VARCHAR2_TABLE_100
724: , a2 JTF_VARCHAR2_TABLE_100
725: , a3 JTF_VARCHAR2_TABLE_100
726: , a4 JTF_NUMBER_TABLE

Line 761: procedure rosetta_table_copy_out_p33(t cse_datastructures_pub.out_of_service_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

757: end loop;
758: end if;
759: end if;
760: end rosetta_table_copy_in_p33;
761: procedure rosetta_table_copy_out_p33(t cse_datastructures_pub.out_of_service_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
762: , a1 out nocopy JTF_VARCHAR2_TABLE_100
763: , a2 out nocopy JTF_VARCHAR2_TABLE_100
764: , a3 out nocopy JTF_VARCHAR2_TABLE_100
765: , a4 out nocopy JTF_NUMBER_TABLE

Line 835: procedure rosetta_table_copy_in_p35(t out nocopy cse_datastructures_pub.in_service_attr_tbl_type, a0 JTF_NUMBER_TABLE

831: end if;
832: end if;
833: end rosetta_table_copy_out_p33;
834:
835: procedure rosetta_table_copy_in_p35(t out nocopy cse_datastructures_pub.in_service_attr_tbl_type, a0 JTF_NUMBER_TABLE
836: , a1 JTF_VARCHAR2_TABLE_100
837: , a2 JTF_VARCHAR2_TABLE_100
838: , a3 JTF_VARCHAR2_TABLE_100
839: , a4 JTF_NUMBER_TABLE

Line 874: procedure rosetta_table_copy_out_p35(t cse_datastructures_pub.in_service_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

870: end loop;
871: end if;
872: end if;
873: end rosetta_table_copy_in_p35;
874: procedure rosetta_table_copy_out_p35(t cse_datastructures_pub.in_service_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
875: , a1 out nocopy JTF_VARCHAR2_TABLE_100
876: , a2 out nocopy JTF_VARCHAR2_TABLE_100
877: , a3 out nocopy JTF_VARCHAR2_TABLE_100
878: , a4 out nocopy JTF_NUMBER_TABLE

Line 948: procedure rosetta_table_copy_in_p37(t out nocopy cse_datastructures_pub.item_move_attr_tbl_type, a0 JTF_NUMBER_TABLE

944: end if;
945: end if;
946: end rosetta_table_copy_out_p35;
947:
948: procedure rosetta_table_copy_in_p37(t out nocopy cse_datastructures_pub.item_move_attr_tbl_type, a0 JTF_NUMBER_TABLE
949: , a1 JTF_VARCHAR2_TABLE_100
950: , a2 JTF_VARCHAR2_TABLE_100
951: , a3 JTF_VARCHAR2_TABLE_100
952: , a4 JTF_NUMBER_TABLE

Line 991: procedure rosetta_table_copy_out_p37(t cse_datastructures_pub.item_move_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

987: end loop;
988: end if;
989: end if;
990: end rosetta_table_copy_in_p37;
991: procedure rosetta_table_copy_out_p37(t cse_datastructures_pub.item_move_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
992: , a1 out nocopy JTF_VARCHAR2_TABLE_100
993: , a2 out nocopy JTF_VARCHAR2_TABLE_100
994: , a3 out nocopy JTF_VARCHAR2_TABLE_100
995: , a4 out nocopy JTF_NUMBER_TABLE

Line 1075: procedure rosetta_table_copy_in_p39(t out nocopy cse_datastructures_pub.proj_itm_insv_attr_tbl_type, a0 JTF_NUMBER_TABLE

1071: end if;
1072: end if;
1073: end rosetta_table_copy_out_p37;
1074:
1075: procedure rosetta_table_copy_in_p39(t out nocopy cse_datastructures_pub.proj_itm_insv_attr_tbl_type, a0 JTF_NUMBER_TABLE
1076: , a1 JTF_VARCHAR2_TABLE_100
1077: , a2 JTF_VARCHAR2_TABLE_100
1078: , a3 JTF_VARCHAR2_TABLE_100
1079: , a4 JTF_NUMBER_TABLE

Line 1120: procedure rosetta_table_copy_out_p39(t cse_datastructures_pub.proj_itm_insv_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1116: end loop;
1117: end if;
1118: end if;
1119: end rosetta_table_copy_in_p39;
1120: procedure rosetta_table_copy_out_p39(t cse_datastructures_pub.proj_itm_insv_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1121: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1122: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1123: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1124: , a4 out nocopy JTF_NUMBER_TABLE

Line 1209: procedure rosetta_table_copy_in_p41(t out nocopy cse_datastructures_pub.proj_itm_insv_pa_attr_tbl_type, a0 JTF_NUMBER_TABLE

1205: end if;
1206: end if;
1207: end rosetta_table_copy_out_p39;
1208:
1209: procedure rosetta_table_copy_in_p41(t out nocopy cse_datastructures_pub.proj_itm_insv_pa_attr_tbl_type, a0 JTF_NUMBER_TABLE
1210: , a1 JTF_NUMBER_TABLE
1211: , a2 JTF_VARCHAR2_TABLE_100
1212: , a3 JTF_NUMBER_TABLE
1213: , a4 JTF_NUMBER_TABLE

Line 1256: procedure rosetta_table_copy_out_p41(t cse_datastructures_pub.proj_itm_insv_pa_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1252: end loop;
1253: end if;
1254: end if;
1255: end rosetta_table_copy_in_p41;
1256: procedure rosetta_table_copy_out_p41(t cse_datastructures_pub.proj_itm_insv_pa_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1257: , a1 out nocopy JTF_NUMBER_TABLE
1258: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1259: , a3 out nocopy JTF_NUMBER_TABLE
1260: , a4 out nocopy JTF_NUMBER_TABLE

Line 1350: procedure rosetta_table_copy_in_p43(t out nocopy cse_datastructures_pub.rcv_txn_tbl_type, a0 JTF_NUMBER_TABLE

1346: end if;
1347: end if;
1348: end rosetta_table_copy_out_p41;
1349:
1350: procedure rosetta_table_copy_in_p43(t out nocopy cse_datastructures_pub.rcv_txn_tbl_type, a0 JTF_NUMBER_TABLE
1351: , a1 JTF_NUMBER_TABLE
1352: , a2 JTF_NUMBER_TABLE
1353: , a3 JTF_NUMBER_TABLE
1354: , a4 JTF_NUMBER_TABLE

Line 1415: procedure rosetta_table_copy_out_p43(t cse_datastructures_pub.rcv_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1411: end loop;
1412: end if;
1413: end if;
1414: end rosetta_table_copy_in_p43;
1415: procedure rosetta_table_copy_out_p43(t cse_datastructures_pub.rcv_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1416: , a1 out nocopy JTF_NUMBER_TABLE
1417: , a2 out nocopy JTF_NUMBER_TABLE
1418: , a3 out nocopy JTF_NUMBER_TABLE
1419: , a4 out nocopy JTF_NUMBER_TABLE

Line 1554: procedure rosetta_table_copy_in_p45(t out nocopy cse_datastructures_pub.ipv_txn_tbl_type, a0 JTF_NUMBER_TABLE

1550: end if;
1551: end if;
1552: end rosetta_table_copy_out_p43;
1553:
1554: procedure rosetta_table_copy_in_p45(t out nocopy cse_datastructures_pub.ipv_txn_tbl_type, a0 JTF_NUMBER_TABLE
1555: , a1 JTF_NUMBER_TABLE
1556: , a2 JTF_NUMBER_TABLE
1557: , a3 JTF_VARCHAR2_TABLE_100
1558: , a4 JTF_VARCHAR2_TABLE_100

Line 1615: procedure rosetta_table_copy_out_p45(t cse_datastructures_pub.ipv_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1611: end loop;
1612: end if;
1613: end if;
1614: end rosetta_table_copy_in_p45;
1615: procedure rosetta_table_copy_out_p45(t cse_datastructures_pub.ipv_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1616: , a1 out nocopy JTF_NUMBER_TABLE
1617: , a2 out nocopy JTF_NUMBER_TABLE
1618: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1619: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1744: procedure rosetta_table_copy_in_p47(t out nocopy cse_datastructures_pub.asset_query_tbl, a0 JTF_NUMBER_TABLE

1740: end if;
1741: end if;
1742: end rosetta_table_copy_out_p45;
1743:
1744: procedure rosetta_table_copy_in_p47(t out nocopy cse_datastructures_pub.asset_query_tbl, a0 JTF_NUMBER_TABLE
1745: , a1 JTF_NUMBER_TABLE
1746: , a2 JTF_NUMBER_TABLE
1747: , a3 JTF_VARCHAR2_TABLE_100
1748: , a4 JTF_VARCHAR2_TABLE_100

Line 1817: procedure rosetta_table_copy_out_p47(t cse_datastructures_pub.asset_query_tbl, a0 out nocopy JTF_NUMBER_TABLE

1813: end loop;
1814: end if;
1815: end if;
1816: end rosetta_table_copy_in_p47;
1817: procedure rosetta_table_copy_out_p47(t cse_datastructures_pub.asset_query_tbl, a0 out nocopy JTF_NUMBER_TABLE
1818: , a1 out nocopy JTF_NUMBER_TABLE
1819: , a2 out nocopy JTF_NUMBER_TABLE
1820: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1821: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1976: procedure rosetta_table_copy_in_p49(t out nocopy cse_datastructures_pub.asset_attrib_tbl, a0 JTF_NUMBER_TABLE

1972: end if;
1973: end if;
1974: end rosetta_table_copy_out_p47;
1975:
1976: procedure rosetta_table_copy_in_p49(t out nocopy cse_datastructures_pub.asset_attrib_tbl, a0 JTF_NUMBER_TABLE
1977: , a1 JTF_NUMBER_TABLE
1978: , a2 JTF_VARCHAR2_TABLE_100
1979: , a3 JTF_NUMBER_TABLE
1980: , a4 JTF_NUMBER_TABLE

Line 2033: procedure rosetta_table_copy_out_p49(t cse_datastructures_pub.asset_attrib_tbl, a0 out nocopy JTF_NUMBER_TABLE

2029: end loop;
2030: end if;
2031: end if;
2032: end rosetta_table_copy_in_p49;
2033: procedure rosetta_table_copy_out_p49(t cse_datastructures_pub.asset_attrib_tbl, a0 out nocopy JTF_NUMBER_TABLE
2034: , a1 out nocopy JTF_NUMBER_TABLE
2035: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2036: , a3 out nocopy JTF_NUMBER_TABLE
2037: , a4 out nocopy JTF_NUMBER_TABLE

Line 2152: procedure rosetta_table_copy_in_p51(t out nocopy cse_datastructures_pub.distribution_tbl, a0 JTF_NUMBER_TABLE

2148: end if;
2149: end if;
2150: end rosetta_table_copy_out_p49;
2151:
2152: procedure rosetta_table_copy_in_p51(t out nocopy cse_datastructures_pub.distribution_tbl, a0 JTF_NUMBER_TABLE
2153: , a1 JTF_VARCHAR2_TABLE_100
2154: , a2 JTF_NUMBER_TABLE
2155: , a3 JTF_NUMBER_TABLE
2156: , a4 JTF_NUMBER_TABLE

Line 2185: procedure rosetta_table_copy_out_p51(t cse_datastructures_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE

2181: end loop;
2182: end if;
2183: end if;
2184: end rosetta_table_copy_in_p51;
2185: procedure rosetta_table_copy_out_p51(t cse_datastructures_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
2186: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2187: , a2 out nocopy JTF_NUMBER_TABLE
2188: , a3 out nocopy JTF_NUMBER_TABLE
2189: , a4 out nocopy JTF_NUMBER_TABLE

Line 2244: procedure rosetta_table_copy_in_p56(t out nocopy cse_datastructures_pub.wfm_trx_values_tbl, a0 JTF_NUMBER_TABLE

2240: end if;
2241: end if;
2242: end rosetta_table_copy_out_p51;
2243:
2244: procedure rosetta_table_copy_in_p56(t out nocopy cse_datastructures_pub.wfm_trx_values_tbl, a0 JTF_NUMBER_TABLE
2245: , a1 JTF_VARCHAR2_TABLE_100
2246: , a2 JTF_VARCHAR2_TABLE_100
2247: , a3 JTF_VARCHAR2_TABLE_100
2248: , a4 JTF_NUMBER_TABLE

Line 2303: procedure rosetta_table_copy_out_p56(t cse_datastructures_pub.wfm_trx_values_tbl, a0 out nocopy JTF_NUMBER_TABLE

2299: end loop;
2300: end if;
2301: end if;
2302: end rosetta_table_copy_in_p56;
2303: procedure rosetta_table_copy_out_p56(t cse_datastructures_pub.wfm_trx_values_tbl, a0 out nocopy JTF_NUMBER_TABLE
2304: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2305: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2306: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2307: , a4 out nocopy JTF_NUMBER_TABLE

Line 2427: end cse_datastructures_pub_w;

2423: end if;
2424: end if;
2425: end rosetta_table_copy_out_p56;
2426:
2427: end cse_datastructures_pub_w;