DBA Data[Home] [Help]

APPS.WSM_WIP_LOT_TXN_PVT_W dependencies on WSM_WIP_LOT_TXN_PVT

Line 1: package body wsm_wip_lot_txn_pvt_w as

1: package body wsm_wip_lot_txn_pvt_w as
2: /* $Header: WSMVWLTB.pls 120.0 2005/07/26 23:53 nlal noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type, a0 JTF_NUMBER_TABLE

1: package body wsm_wip_lot_txn_pvt_w as
2: /* $Header: WSMVWLTB.pls 120.0 2005/07/26 23:53 nlal noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 32: procedure rosetta_table_copy_out_p5(t wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

28: end loop;
29: end if;
30: end if;
31: end rosetta_table_copy_in_p5;
32: procedure rosetta_table_copy_out_p5(t wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_300
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_VARCHAR2_TABLE_100
36: , a4 out nocopy JTF_NUMBER_TABLE

Line 81: procedure rosetta_table_copy_in_p6(t out nocopy wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type, a0 JTF_NUMBER_TABLE

77: end if;
78: end if;
79: end rosetta_table_copy_out_p5;
80:
81: procedure rosetta_table_copy_in_p6(t out nocopy wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_VARCHAR2_TABLE_300
83: , a2 JTF_NUMBER_TABLE
84: , a3 JTF_NUMBER_TABLE
85: , a4 JTF_VARCHAR2_TABLE_300

Line 216: procedure rosetta_table_copy_out_p6(t wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

212: end loop;
213: end if;
214: end if;
215: end rosetta_table_copy_in_p6;
216: procedure rosetta_table_copy_out_p6(t wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
217: , a1 out nocopy JTF_VARCHAR2_TABLE_300
218: , a2 out nocopy JTF_NUMBER_TABLE
219: , a3 out nocopy JTF_NUMBER_TABLE
220: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 530: procedure rosetta_table_copy_in_p7(t out nocopy wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 JTF_VARCHAR2_TABLE_300

526: end if;
527: end if;
528: end rosetta_table_copy_out_p6;
529:
530: procedure rosetta_table_copy_in_p7(t out nocopy wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 JTF_VARCHAR2_TABLE_300
531: , a1 JTF_NUMBER_TABLE
532: , a2 JTF_VARCHAR2_TABLE_300
533: , a3 JTF_NUMBER_TABLE
534: , a4 JTF_NUMBER_TABLE

Line 665: procedure rosetta_table_copy_out_p7(t wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

661: end loop;
662: end if;
663: end if;
664: end rosetta_table_copy_in_p7;
665: procedure rosetta_table_copy_out_p7(t wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
666: , a1 out nocopy JTF_NUMBER_TABLE
667: , a2 out nocopy JTF_VARCHAR2_TABLE_300
668: , a3 out nocopy JTF_NUMBER_TABLE
669: , a4 out nocopy JTF_NUMBER_TABLE

Line 1823: ddp_txn_header_rec wsm_wip_lot_txn_pvt.wltx_transactions_rec_type;

1819: , x_error_msg out nocopy VARCHAR2
1820: )
1821:
1822: as
1823: ddp_txn_header_rec wsm_wip_lot_txn_pvt.wltx_transactions_rec_type;
1824: ddp_starting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type;
1825: ddp_resulting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type;
1826: ddp_wsm_serial_num_tbl wsm_serial_support_grp.wsm_serial_num_tbl;
1827: ddp_secondary_qty_tbl wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type;

Line 1824: ddp_starting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type;

1820: )
1821:
1822: as
1823: ddp_txn_header_rec wsm_wip_lot_txn_pvt.wltx_transactions_rec_type;
1824: ddp_starting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type;
1825: ddp_resulting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type;
1826: ddp_wsm_serial_num_tbl wsm_serial_support_grp.wsm_serial_num_tbl;
1827: ddp_secondary_qty_tbl wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type;
1828: ddindx binary_integer; indx binary_integer;

Line 1825: ddp_resulting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type;

1821:
1822: as
1823: ddp_txn_header_rec wsm_wip_lot_txn_pvt.wltx_transactions_rec_type;
1824: ddp_starting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type;
1825: ddp_resulting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type;
1826: ddp_wsm_serial_num_tbl wsm_serial_support_grp.wsm_serial_num_tbl;
1827: ddp_secondary_qty_tbl wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type;
1828: ddindx binary_integer; indx binary_integer;
1829: begin

Line 1827: ddp_secondary_qty_tbl wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type;

1823: ddp_txn_header_rec wsm_wip_lot_txn_pvt.wltx_transactions_rec_type;
1824: ddp_starting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type;
1825: ddp_resulting_jobs_tbl wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type;
1826: ddp_wsm_serial_num_tbl wsm_serial_support_grp.wsm_serial_num_tbl;
1827: ddp_secondary_qty_tbl wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type;
1828: ddindx binary_integer; indx binary_integer;
1829: begin
1830:
1831: -- copy data to the local IN or IN-OUT args, if any

Line 1863: wsm_wip_lot_txn_pvt_w.rosetta_table_copy_in_p6(ddp_starting_jobs_tbl, p6_a0

1859: ddp_txn_header_rec.attribute13 := p5_a22;
1860: ddp_txn_header_rec.attribute14 := p5_a23;
1861: ddp_txn_header_rec.attribute15 := p5_a24;
1862:
1863: wsm_wip_lot_txn_pvt_w.rosetta_table_copy_in_p6(ddp_starting_jobs_tbl, p6_a0
1864: , p6_a1
1865: , p6_a2
1866: , p6_a3
1867: , p6_a4

Line 1924: wsm_wip_lot_txn_pvt_w.rosetta_table_copy_in_p7(ddp_resulting_jobs_tbl, p7_a0

1920: , p6_a57
1921: , p6_a58
1922: );
1923:
1924: wsm_wip_lot_txn_pvt_w.rosetta_table_copy_in_p7(ddp_resulting_jobs_tbl, p7_a0
1925: , p7_a1
1926: , p7_a2
1927: , p7_a3
1928: , p7_a4

Line 1985: wsm_wip_lot_txn_pvt_w.rosetta_table_copy_in_p8(ddp_wsm_serial_num_tbl, p8_a0

1981: , p7_a57
1982: , p7_a58
1983: );
1984:
1985: wsm_wip_lot_txn_pvt_w.rosetta_table_copy_in_p8(ddp_wsm_serial_num_tbl, p8_a0
1986: , p8_a1
1987: , p8_a2
1988: , p8_a3
1989: , p8_a4

Line 2068: wsm_wip_lot_txn_pvt_w.rosetta_table_copy_in_p5(ddp_secondary_qty_tbl, p9_a0

2064: , p8_a79
2065: , p8_a80
2066: );
2067:
2068: wsm_wip_lot_txn_pvt_w.rosetta_table_copy_in_p5(ddp_secondary_qty_tbl, p9_a0
2069: , p9_a1
2070: , p9_a2
2071: , p9_a3
2072: , p9_a4

Line 2080: wsm_wip_lot_txn_pvt.invoke_txn_api(p_api_version,

2076:
2077:
2078:
2079: -- here's the delegated call to the old PL/SQL routine
2080: wsm_wip_lot_txn_pvt.invoke_txn_api(p_api_version,
2081: p_commit,
2082: p_validation_level,
2083: p_init_msg_list,
2084: p_calling_mode,

Line 2109: end wsm_wip_lot_txn_pvt_w;

2105:
2106:
2107: end;
2108:
2109: end wsm_wip_lot_txn_pvt_w;