PACKAGE: APPS.INV_OA_GEN_PVT

Source

1 PACKAGE INV_OA_GEN_PVT AS
2   /* $Header: INVOAGES.pls 120.1 2005/10/10 07:18 methomas noship $ */
3   -- Record Type for the lot number attributes columns
4   TYPE assembly_lot_sel_rec_type IS RECORD
5   (
6 -- Increased lot size to 80 Char - Mercy Thomas - B4625329
7           Lot_number      VARCHAR2(80)    :=NULL
8           , serial_number VARCHAR2(30)   :=NULL
9   );
10    -- Table type definition for an array of cb_chart_status_rec_type
11    --   records.
12   TYPE assembly_lot_sel_tbl_type is TABLE OF
13   assembly_lot_sel_rec_type
14     INDEX BY BINARY_INTEGER;
15 
16  PROCEDURE BUILD_ASSEMBLY_LOT_SERIAL_TBL(
17           x_return_status out nocopy  VARCHAR2
18 	, x_msg_count out nocopy  NUMBER
19         , x_msg_data out nocopy  VARCHAR2
20         , p_assembly_lot_serial_tbl assembly_lot_sel_tbl_type
21           );
22 
23   procedure rosetta_table_copy_in_p1(t out nocopy inv_oa_gen_pvt.assembly_lot_sel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
24     , a1 JTF_VARCHAR2_TABLE_100
25     );
26   procedure rosetta_table_copy_out_p1(t inv_oa_gen_pvt.assembly_lot_sel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
27     , a1 out nocopy JTF_VARCHAR2_TABLE_100
28     );
29 
30   procedure build_assembly_lot_serial_tbl(x_return_status out nocopy  VARCHAR2
31     , x_msg_count out nocopy  NUMBER
32     , x_msg_data out nocopy  VARCHAR2
33     , p3_a0 JTF_VARCHAR2_TABLE_100
34     , p3_a1 JTF_VARCHAR2_TABLE_100
35   );
36 
37 END INV_OA_GEN_PVT;