DBA Data[Home] [Help]

APPS.WMS_ASN_LOT_ATT dependencies on MTL_LOT_NUMBERS

Line 19: TYPE n_attribute_table_type IS TABLE OF mtl_lot_numbers.n_attribute1%TYPE INDEX BY BINARY_INTEGER;

15: -- Table type definition for an array of cb_chart_status_rec_type records.
16: TYPE lot_sel_attributes_tbl_type is TABLE OF lot_sel_attributes_rec_type
17: INDEX BY BINARY_INTEGER;
18:
19: TYPE n_attribute_table_type IS TABLE OF mtl_lot_numbers.n_attribute1%TYPE INDEX BY BINARY_INTEGER;
20: TYPE d_attribute_table_type IS TABLE OF mtl_lot_numbers.d_attribute1%TYPE INDEX BY BINARY_INTEGER;
21: TYPE c_attribute_table_type IS TABLE OF mtl_lot_numbers.c_attribute1%TYPE INDEX BY BINARY_INTEGER;
22:
23: g_lot_attributes_tbl lot_sel_attributes_tbl_type;

Line 20: TYPE d_attribute_table_type IS TABLE OF mtl_lot_numbers.d_attribute1%TYPE INDEX BY BINARY_INTEGER;

16: TYPE lot_sel_attributes_tbl_type is TABLE OF lot_sel_attributes_rec_type
17: INDEX BY BINARY_INTEGER;
18:
19: TYPE n_attribute_table_type IS TABLE OF mtl_lot_numbers.n_attribute1%TYPE INDEX BY BINARY_INTEGER;
20: TYPE d_attribute_table_type IS TABLE OF mtl_lot_numbers.d_attribute1%TYPE INDEX BY BINARY_INTEGER;
21: TYPE c_attribute_table_type IS TABLE OF mtl_lot_numbers.c_attribute1%TYPE INDEX BY BINARY_INTEGER;
22:
23: g_lot_attributes_tbl lot_sel_attributes_tbl_type;
24:

Line 21: TYPE c_attribute_table_type IS TABLE OF mtl_lot_numbers.c_attribute1%TYPE INDEX BY BINARY_INTEGER;

17: INDEX BY BINARY_INTEGER;
18:
19: TYPE n_attribute_table_type IS TABLE OF mtl_lot_numbers.n_attribute1%TYPE INDEX BY BINARY_INTEGER;
20: TYPE d_attribute_table_type IS TABLE OF mtl_lot_numbers.d_attribute1%TYPE INDEX BY BINARY_INTEGER;
21: TYPE c_attribute_table_type IS TABLE OF mtl_lot_numbers.c_attribute1%TYPE INDEX BY BINARY_INTEGER;
22:
23: g_lot_attributes_tbl lot_sel_attributes_tbl_type;
24:
25: g_serial_attributes_tbl lot_sel_attributes_tbl_type;

Line 31: -- mtl_lot_numbers from wms_lpn_contents_interface

27:
28: --
29: -- Validate Lot sets the default values
30: -- validates and inserts rows into
31: -- mtl_lot_numbers from wms_lpn_contents_interface
32: --
33:
34: procedure validate_lot (
35: x_return_status OUT NOCOPY VARCHAR2