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.CSP_PARTS_REQUIREMENT_W dependencies on CSP_PARTS_REQUIREMENT

Line 1: package body csp_parts_requirement_w as

1: package body csp_parts_requirement_w as
2: /* $Header: cspwprqb.pls 120.1.12020000.2 2012/07/18 08:11:12 kgambhir 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 16: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE

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 csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_300

Line 115: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 339: procedure rosetta_table_copy_in_p4(t out nocopy csp_parts_requirement.line_detail_tbl_type, a0 JTF_NUMBER_TABLE

335: end if;
336: end if;
337: end rosetta_table_copy_out_p2;
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy csp_parts_requirement.line_detail_tbl_type, a0 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_VARCHAR2_TABLE_100
342: , a3 JTF_NUMBER_TABLE
343: ) as

Line 364: procedure rosetta_table_copy_out_p4(t csp_parts_requirement.line_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

360: end loop;
361: end if;
362: end if;
363: end rosetta_table_copy_in_p4;
364: procedure rosetta_table_copy_out_p4(t csp_parts_requirement.line_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
365: , a1 out nocopy JTF_NUMBER_TABLE
366: , a2 out nocopy JTF_VARCHAR2_TABLE_100
367: , a3 out nocopy JTF_NUMBER_TABLE
368: ) as

Line 403: procedure rosetta_table_copy_in_p6(t out nocopy csp_parts_requirement.rqmt_line_tbl_type, a0 JTF_NUMBER_TABLE

399: end if;
400: end if;
401: end rosetta_table_copy_out_p4;
402:
403: procedure rosetta_table_copy_in_p6(t out nocopy csp_parts_requirement.rqmt_line_tbl_type, a0 JTF_NUMBER_TABLE
404: ) as
405: ddindx binary_integer; indx binary_integer;
406: begin
407: if a0 is not null and a0.count > 0 then

Line 422: procedure rosetta_table_copy_out_p6(t csp_parts_requirement.rqmt_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

418: end loop;
419: end if;
420: end if;
421: end rosetta_table_copy_in_p6;
422: procedure rosetta_table_copy_out_p6(t csp_parts_requirement.rqmt_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
423: ) as
424: ddindx binary_integer; indx binary_integer;
425: begin
426: if t is null or t.count = 0 then

Line 446: procedure rosetta_table_copy_in_p8(t out nocopy csp_parts_requirement.order_tbl_type, a0 JTF_VARCHAR2_TABLE_100

442: end if;
443: end if;
444: end rosetta_table_copy_out_p6;
445:
446: procedure rosetta_table_copy_in_p8(t out nocopy csp_parts_requirement.order_tbl_type, a0 JTF_VARCHAR2_TABLE_100
447: , a1 JTF_NUMBER_TABLE
448: ) as
449: ddindx binary_integer; indx binary_integer;
450: begin

Line 467: procedure rosetta_table_copy_out_p8(t csp_parts_requirement.order_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

463: end loop;
464: end if;
465: end if;
466: end rosetta_table_copy_in_p8;
467: procedure rosetta_table_copy_out_p8(t csp_parts_requirement.order_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
468: , a1 out nocopy JTF_NUMBER_TABLE
469: ) as
470: ddindx binary_integer; indx binary_integer;
471: begin

Line 591: ddpx_header_rec csp_parts_requirement.header_rec_type;

587: , x_msg_data out nocopy VARCHAR2
588: )
589:
590: as
591: ddpx_header_rec csp_parts_requirement.header_rec_type;
592: ddpx_line_table csp_parts_requirement.line_tbl_type;
593: ddindx binary_integer; indx binary_integer;
594: begin
595:

Line 592: ddpx_line_table csp_parts_requirement.line_tbl_type;

588: )
589:
590: as
591: ddpx_header_rec csp_parts_requirement.header_rec_type;
592: ddpx_line_table csp_parts_requirement.line_tbl_type;
593: ddindx binary_integer; indx binary_integer;
594: begin
595:
596: -- copy data to the local IN or IN-OUT args, if any

Line 645: csp_parts_requirement_w.rosetta_table_copy_in_p2(ddpx_line_table, p4_a0

641: ddpx_header_rec.attribute14 := p3_a41;
642: ddpx_header_rec.attribute15 := p3_a42;
643: ddpx_header_rec.ship_to_contact_id := p3_a43;
644:
645: csp_parts_requirement_w.rosetta_table_copy_in_p2(ddpx_line_table, p4_a0
646: , p4_a1
647: , p4_a2
648: , p4_a3
649: , p4_a4

Line 693: csp_parts_requirement.process_requirement(p_api_version,

689:
690:
691:
692: -- here's the delegated call to the old PL/SQL routine
693: csp_parts_requirement.process_requirement(p_api_version,
694: p_init_msg_list,
695: p_commit,
696: ddpx_header_rec,
697: ddpx_line_table,

Line 752: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddpx_line_table, p4_a0

748: p3_a41 := ddpx_header_rec.attribute14;
749: p3_a42 := ddpx_header_rec.attribute15;
750: p3_a43 := ddpx_header_rec.ship_to_contact_id;
751:
752: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddpx_line_table, p4_a0
753: , p4_a1
754: , p4_a2
755: , p4_a3
756: , p4_a4

Line 894: ddpx_header_rec csp_parts_requirement.header_rec_type;

890: , x_msg_data out nocopy VARCHAR2
891: )
892:
893: as
894: ddpx_header_rec csp_parts_requirement.header_rec_type;
895: ddpx_line_table csp_parts_requirement.line_tbl_type;
896: ddindx binary_integer; indx binary_integer;
897: begin
898:

Line 895: ddpx_line_table csp_parts_requirement.line_tbl_type;

891: )
892:
893: as
894: ddpx_header_rec csp_parts_requirement.header_rec_type;
895: ddpx_line_table csp_parts_requirement.line_tbl_type;
896: ddindx binary_integer; indx binary_integer;
897: begin
898:
899: -- copy data to the local IN or IN-OUT args, if any

Line 948: csp_parts_requirement_w.rosetta_table_copy_in_p2(ddpx_line_table, p4_a0

944: ddpx_header_rec.attribute14 := p3_a41;
945: ddpx_header_rec.attribute15 := p3_a42;
946: ddpx_header_rec.ship_to_contact_id := p3_a43;
947:
948: csp_parts_requirement_w.rosetta_table_copy_in_p2(ddpx_line_table, p4_a0
949: , p4_a1
950: , p4_a2
951: , p4_a3
952: , p4_a4

Line 995: csp_parts_requirement.csptrreq_fm_order(p_api_version,

991:
992:
993:
994: -- here's the delegated call to the old PL/SQL routine
995: csp_parts_requirement.csptrreq_fm_order(p_api_version,
996: p_init_msg_list,
997: p_commit,
998: ddpx_header_rec,
999: ddpx_line_table,

Line 1053: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddpx_line_table, p4_a0

1049: p3_a41 := ddpx_header_rec.attribute14;
1050: p3_a42 := ddpx_header_rec.attribute15;
1051: p3_a43 := ddpx_header_rec.ship_to_contact_id;
1052:
1053: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddpx_line_table, p4_a0
1054: , p4_a1
1055: , p4_a2
1056: , p4_a3
1057: , p4_a4

Line 1194: ddpx_header_rec csp_parts_requirement.header_rec_type;

1190: , x_msg_data out nocopy VARCHAR2
1191: )
1192:
1193: as
1194: ddpx_header_rec csp_parts_requirement.header_rec_type;
1195: ddpx_line_table csp_parts_requirement.line_tbl_type;
1196: ddindx binary_integer; indx binary_integer;
1197: begin
1198:

Line 1195: ddpx_line_table csp_parts_requirement.line_tbl_type;

1191: )
1192:
1193: as
1194: ddpx_header_rec csp_parts_requirement.header_rec_type;
1195: ddpx_line_table csp_parts_requirement.line_tbl_type;
1196: ddindx binary_integer; indx binary_integer;
1197: begin
1198:
1199: -- copy data to the local IN or IN-OUT args, if any

Line 1248: csp_parts_requirement_w.rosetta_table_copy_in_p2(ddpx_line_table, p4_a0

1244: ddpx_header_rec.attribute14 := p3_a41;
1245: ddpx_header_rec.attribute15 := p3_a42;
1246: ddpx_header_rec.ship_to_contact_id := p3_a43;
1247:
1248: csp_parts_requirement_w.rosetta_table_copy_in_p2(ddpx_line_table, p4_a0
1249: , p4_a1
1250: , p4_a2
1251: , p4_a3
1252: , p4_a4

Line 1295: csp_parts_requirement.csptrreq_order_res(p_api_version,

1291:
1292:
1293:
1294: -- here's the delegated call to the old PL/SQL routine
1295: csp_parts_requirement.csptrreq_order_res(p_api_version,
1296: p_init_msg_list,
1297: p_commit,
1298: ddpx_header_rec,
1299: ddpx_line_table,

Line 1353: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddpx_line_table, p4_a0

1349: p3_a41 := ddpx_header_rec.attribute14;
1350: p3_a42 := ddpx_header_rec.attribute15;
1351: p3_a43 := ddpx_header_rec.ship_to_contact_id;
1352:
1353: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddpx_line_table, p4_a0
1354: , p4_a1
1355: , p4_a2
1356: , p4_a3
1357: , p4_a4

Line 1494: ddpx_header_rec csp_parts_requirement.header_rec_type;

1490: , x_msg_data out nocopy VARCHAR2
1491: )
1492:
1493: as
1494: ddpx_header_rec csp_parts_requirement.header_rec_type;
1495: ddpx_line_tbl csp_parts_requirement.line_tbl_type;
1496: ddindx binary_integer; indx binary_integer;
1497: begin
1498:

Line 1495: ddpx_line_tbl csp_parts_requirement.line_tbl_type;

1491: )
1492:
1493: as
1494: ddpx_header_rec csp_parts_requirement.header_rec_type;
1495: ddpx_line_tbl csp_parts_requirement.line_tbl_type;
1496: ddindx binary_integer; indx binary_integer;
1497: begin
1498:
1499: -- copy data to the local IN or IN-OUT args, if any

Line 1548: csp_parts_requirement_w.rosetta_table_copy_in_p2(ddpx_line_tbl, p4_a0

1544: ddpx_header_rec.attribute14 := p3_a41;
1545: ddpx_header_rec.attribute15 := p3_a42;
1546: ddpx_header_rec.ship_to_contact_id := p3_a43;
1547:
1548: csp_parts_requirement_w.rosetta_table_copy_in_p2(ddpx_line_tbl, p4_a0
1549: , p4_a1
1550: , p4_a2
1551: , p4_a3
1552: , p4_a4

Line 1595: csp_parts_requirement.save_rqmt_line(p_api_version,

1591:
1592:
1593:
1594: -- here's the delegated call to the old PL/SQL routine
1595: csp_parts_requirement.save_rqmt_line(p_api_version,
1596: p_init_msg_list,
1597: p_commit,
1598: ddpx_header_rec,
1599: ddpx_line_tbl,

Line 1653: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddpx_line_tbl, p4_a0

1649: p3_a41 := ddpx_header_rec.attribute14;
1650: p3_a42 := ddpx_header_rec.attribute15;
1651: p3_a43 := ddpx_header_rec.ship_to_contact_id;
1652:
1653: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddpx_line_tbl, p4_a0
1654: , p4_a1
1655: , p4_a2
1656: , p4_a3
1657: , p4_a4

Line 1710: ddp_line_tbl csp_parts_requirement.rqmt_line_tbl_type;

1706: , x_msg_data out nocopy VARCHAR2
1707: )
1708:
1709: as
1710: ddp_line_tbl csp_parts_requirement.rqmt_line_tbl_type;
1711: ddindx binary_integer; indx binary_integer;
1712: begin
1713:
1714: -- copy data to the local IN or IN-OUT args, if any

Line 1718: csp_parts_requirement_w.rosetta_table_copy_in_p6(ddp_line_tbl, p3_a0

1714: -- copy data to the local IN or IN-OUT args, if any
1715:
1716:
1717:
1718: csp_parts_requirement_w.rosetta_table_copy_in_p6(ddp_line_tbl, p3_a0
1719: );
1720:
1721:
1722:

Line 1725: csp_parts_requirement.delete_rqmt_line(p_api_version,

1721:
1722:
1723:
1724: -- here's the delegated call to the old PL/SQL routine
1725: csp_parts_requirement.delete_rqmt_line(p_api_version,
1726: p_init_msg_list,
1727: p_commit,
1728: ddp_line_tbl,
1729: x_return_status,

Line 1737: csp_parts_requirement_w.rosetta_table_copy_out_p6(ddp_line_tbl, p3_a0

1733: -- copy data back from the local variables to OUT or IN-OUT args, if any
1734:
1735:
1736:
1737: csp_parts_requirement_w.rosetta_table_copy_out_p6(ddp_line_tbl, p3_a0
1738: );
1739:
1740:
1741:

Line 1796: ddx_line_tbl csp_parts_requirement.line_tbl_type;

1792: , x_msg_data out nocopy VARCHAR2
1793: )
1794:
1795: as
1796: ddx_line_tbl csp_parts_requirement.line_tbl_type;
1797: ddindx binary_integer; indx binary_integer;
1798: begin
1799:
1800: -- copy data to the local IN or IN-OUT args, if any

Line 1811: csp_parts_requirement.check_availability(p_api_version,

1807:
1808:
1809:
1810: -- here's the delegated call to the old PL/SQL routine
1811: csp_parts_requirement.check_availability(p_api_version,
1812: p_init_msg_list,
1813: p_commit,
1814: p_header_id,
1815: ddx_line_tbl,

Line 1826: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddx_line_tbl, p4_a0

1822:
1823:
1824:
1825:
1826: csp_parts_requirement_w.rosetta_table_copy_out_p2(ddx_line_tbl, p4_a0
1827: , p4_a1
1828: , p4_a2
1829: , p4_a3
1830: , p4_a4

Line 1886: ddx_order_tbl csp_parts_requirement.order_tbl_type;

1882: , x_msg_data out nocopy VARCHAR2
1883: )
1884:
1885: as
1886: ddx_order_tbl csp_parts_requirement.order_tbl_type;
1887: ddindx binary_integer; indx binary_integer;
1888: begin
1889:
1890: -- copy data to the local IN or IN-OUT args, if any

Line 1900: csp_parts_requirement.create_order(p_api_version,

1896:
1897:
1898:
1899: -- here's the delegated call to the old PL/SQL routine
1900: csp_parts_requirement.create_order(p_api_version,
1901: p_init_msg_list,
1902: p_commit,
1903: p_header_id,
1904: ddx_order_tbl,

Line 1914: csp_parts_requirement_w.rosetta_table_copy_out_p8(ddx_order_tbl, p4_a0

1910:
1911:
1912:
1913:
1914: csp_parts_requirement_w.rosetta_table_copy_out_p8(ddx_order_tbl, p4_a0
1915: , p4_a1
1916: );
1917:
1918:

Line 1922: end csp_parts_requirement_w;

1918:
1919:
1920: end;
1921:
1922: end csp_parts_requirement_w;