DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT_W dependencies on CSP_SCH_INT_PVT_W

Line 1: package body csp_sch_int_pvt_w as

1: package body csp_sch_int_pvt_w as
2: /* $Header: cspvscib.pls 120.6.12020000.2 2012/07/17 08:03:20 htank 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 968: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

964: end if;
965: end if;
966: end rosetta_table_copy_out_p20;
967:
968: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
969: , a1 JTF_VARCHAR2_TABLE_100
970: , a2 JTF_NUMBER_TABLE
971: , a3 JTF_VARCHAR2_TABLE_100
972: , a4 JTF_VARCHAR2_TABLE_100

Line 993: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();

989: ) as
990: ddindx binary_integer; indx binary_integer;
991: begin
992: if a0 is not null and a0.count=0 then
993: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();
994: elsif a0 is not null and a0.count > 0 then
995: if a0.count > 0 then
996: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();
997: t.extend(a0.count);

Line 996: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();

992: if a0 is not null and a0.count=0 then
993: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();
994: elsif a0 is not null and a0.count > 0 then
995: if a0.count > 0 then
996: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();
997: t.extend(a0.count);
998: indx := a0.first;
999: ddindx := 1;
1000: while true loop

Line 1031: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

1027: end loop;
1028: end if;
1029: end if;
1030: end rosetta_table_copy_in_p21;
1031: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
1032: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1033: , a2 out nocopy JTF_NUMBER_TABLE
1034: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1410: csp_sch_int_pvt_w.rosetta_table_copy_in_p13(ddp_resources, p2_a0

1406:
1407: -- copy data to the local IN or IN-OUT args, if any
1408:
1409:
1410: csp_sch_int_pvt_w.rosetta_table_copy_in_p13(ddp_resources, p2_a0
1411: , p2_a1
1412: );
1413:
1414: ddp_interval.earliest_time := rosetta_g_miss_date_in_map(p3_a0);

Line 1475: csp_sch_int_pvt_w.rosetta_table_copy_out_p14(ddx_options, p9_a0

1471:
1472:
1473:
1474:
1475: csp_sch_int_pvt_w.rosetta_table_copy_out_p14(ddx_options, p9_a0
1476: , p9_a1
1477: , p9_a2
1478: , p9_a3
1479: , p9_a4

Line 1635: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p4_a0

1631:
1632:
1633: ddp_need_by_date := rosetta_g_miss_date_in_map(p_need_by_date);
1634:
1635: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p4_a0
1636: , p4_a1
1637: , p4_a2
1638: , p4_a3
1639: , p4_a4

Line 1671: csp_sch_int_pvt_w.rosetta_table_copy_out_p19(ddx_availability, p6_a0

1667:
1668:
1669:
1670:
1671: csp_sch_int_pvt_w.rosetta_table_copy_out_p19(ddx_availability, p6_a0
1672: , p6_a1
1673: , p6_a2
1674: , p6_a3
1675: , p6_a4

Line 1779: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;

1775:
1776: as
1777: ddp_resource_list csp_sch_int_pvt.csp_ws_resource_table_type;
1778: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1779: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1780: ddindx binary_integer; indx binary_integer;
1781: begin
1782:
1783: -- copy data to the local IN or IN-OUT args, if any

Line 1784: csp_sch_int_pvt_w.rosetta_table_copy_in_p22(ddp_resource_list, p0_a0

1780: ddindx binary_integer; indx binary_integer;
1781: begin
1782:
1783: -- copy data to the local IN or IN-OUT args, if any
1784: csp_sch_int_pvt_w.rosetta_table_copy_in_p22(ddp_resource_list, p0_a0
1785: , p0_a1
1786: , p0_a2
1787: , p0_a3
1788: , p0_a4

Line 1792: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p1_a0

1788: , p0_a4
1789: , p0_a5
1790: );
1791:
1792: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p1_a0
1793: , p1_a1
1794: , p1_a2
1795: , p1_a3
1796: , p1_a4

Line 1806: csp_sch_int_pvt.ws_check_other_eng_subinv(ddp_resource_list,

1802:
1803:
1804:
1805: -- here's the delegated call to the old PL/SQL routine
1806: csp_sch_int_pvt.ws_check_other_eng_subinv(ddp_resource_list,
1807: ddp_parts_list,
1808: p_include_alternate,
1809: ddx_available_list,
1810: x_return_status,

Line 1818: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p3_a0

1814: -- copy data back from the local variables to OUT or IN-OUT args, if any
1815:
1816:
1817:
1818: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p3_a0
1819: , p3_a1
1820: , p3_a2
1821: , p3_a3
1822: , p3_a4

Line 1882: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;

1878: )
1879:
1880: as
1881: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1882: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1883: ddindx binary_integer; indx binary_integer;
1884: begin
1885:
1886: -- copy data to the local IN or IN-OUT args, if any

Line 1889: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p2_a0

1885:
1886: -- copy data to the local IN or IN-OUT args, if any
1887:
1888:
1889: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p2_a0
1890: , p2_a1
1891: , p2_a2
1892: , p2_a3
1893: , p2_a4

Line 1903: csp_sch_int_pvt.ws_check_engineers_subinv(p_resource_type,

1899:
1900:
1901:
1902: -- here's the delegated call to the old PL/SQL routine
1903: csp_sch_int_pvt.ws_check_engineers_subinv(p_resource_type,
1904: p_resource_id,
1905: ddp_parts_list,
1906: p_include_alternate,
1907: ddx_available_list,

Line 1917: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p4_a0

1913:
1914:
1915:
1916:
1917: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p4_a0
1918: , p4_a1
1919: , p4_a2
1920: , p4_a3
1921: , p4_a4

Line 1981: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;

1977: )
1978:
1979: as
1980: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1981: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1982: ddindx binary_integer; indx binary_integer;
1983: begin
1984:
1985: -- copy data to the local IN or IN-OUT args, if any

Line 1988: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p2_a0

1984:
1985: -- copy data to the local IN or IN-OUT args, if any
1986:
1987:
1988: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p2_a0
1989: , p2_a1
1990: , p2_a2
1991: , p2_a3
1992: , p2_a4

Line 2002: csp_sch_int_pvt.ws_check_organizations(p_resource_type,

1998:
1999:
2000:
2001: -- here's the delegated call to the old PL/SQL routine
2002: csp_sch_int_pvt.ws_check_organizations(p_resource_type,
2003: p_resource_id,
2004: ddp_parts_list,
2005: p_include_alternate,
2006: ddx_available_list,

Line 2016: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p4_a0

2012:
2013:
2014:
2015:
2016: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p4_a0
2017: , p4_a1
2018: , p4_a2
2019: , p4_a3
2020: , p4_a4

Line 2078: csp_sch_int_pvt_w.rosetta_table_copy_in_p23(ddpx_alternate_items, p2_a0

2074: ddp_parts_rec.ship_set_name := p0_a4;
2075: ddp_parts_rec.line_id := p0_a5;
2076:
2077:
2078: csp_sch_int_pvt_w.rosetta_table_copy_in_p23(ddpx_alternate_items, p2_a0
2079: , p2_a1
2080: , p2_a2
2081: , p2_a3
2082: , p2_a4

Line 2102: csp_sch_int_pvt_w.rosetta_table_copy_out_p23(ddpx_alternate_items, p2_a0

2098:
2099: -- copy data back from the local variables to OUT or IN-OUT args, if any
2100:
2101:
2102: csp_sch_int_pvt_w.rosetta_table_copy_out_p23(ddpx_alternate_items, p2_a0
2103: , p2_a1
2104: , p2_a2
2105: , p2_a3
2106: , p2_a4

Line 2218: csp_sch_int_pvt_w.rosetta_table_copy_in_p13(ddp_resources, p0_a0

2214: ddindx binary_integer; indx binary_integer;
2215: begin
2216:
2217: -- copy data to the local IN or IN-OUT args, if any
2218: csp_sch_int_pvt_w.rosetta_table_copy_in_p13(ddp_resources, p0_a0
2219: , p0_a1
2220: );
2221:
2222:

Line 2269: csp_sch_int_pvt_w.rosetta_table_copy_out_p14(ddx_options, p6_a0

2265:
2266:
2267:
2268:
2269: csp_sch_int_pvt_w.rosetta_table_copy_out_p14(ddx_options, p6_a0
2270: , p6_a1
2271: , p6_a2
2272: , p6_a3
2273: , p6_a4

Line 2284: end csp_sch_int_pvt_w;

2280:
2281:
2282: end;
2283:
2284: end csp_sch_int_pvt_w;