22: TYPE REVISION_TABLE IS TABLE of VARCHAR2(10);
23: TYPE UOM_TABLE IS TABLE OF VARCHAR2(3);
24: TYPE DATE_TABLE is Table of Date;
25: --Global table to hold attributes for Serialized Lot Items
26: g_lot_ser_attributes_tbl INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
27: g_lot_attributes_tbl INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
28:
29:
30: --********************************************************************************************
23: TYPE UOM_TABLE IS TABLE OF VARCHAR2(3);
24: TYPE DATE_TABLE is Table of Date;
25: --Global table to hold attributes for Serialized Lot Items
26: g_lot_ser_attributes_tbl INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
27: g_lot_attributes_tbl INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
28:
29:
30: --********************************************************************************************
31: -- Procedure
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,
583: x_msg_data OUT NOCOPY VARCHAR2,
584: x_validation_status OUT NOCOPY VARCHAR2,
585: x_lot_attr_tbl OUT NOCOPY Inv_Lot_Sel_Attr.Lot_Sel_Attributes_Tbl_Type,
586: p_lot_number IN VARCHAR2,
587: p_organization_id IN NUMBER,
588: p_inventory_item_id IN NUMBER,
589: p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
585: x_lot_attr_tbl OUT NOCOPY Inv_Lot_Sel_Attr.Lot_Sel_Attributes_Tbl_Type,
586: p_lot_number IN VARCHAR2,
587: p_organization_id IN NUMBER,
588: p_inventory_item_id IN NUMBER,
589: p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
590: p_result_lot_attr_tbl IN
591: inv_lot_sel_attr.lot_sel_attributes_tbl_type,
592: p_transaction_type_id IN NUMBER
593: );
587: p_organization_id IN NUMBER,
588: p_inventory_item_id IN NUMBER,
589: p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
590: p_result_lot_attr_tbl IN
591: inv_lot_sel_attr.lot_sel_attributes_tbl_type,
592: p_transaction_type_id IN NUMBER
593: );
594:
595:
629: x_return_status OUT NOCOPY VARCHAR2
630: , x_msg_count OUT NOCOPY NUMBER
631: , x_msg_data OUT NOCOPY VARCHAR2
632: , x_validation_status OUT NOCOPY VARCHAR2
633: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
634: , p_ser_number IN VARCHAR2
635: , p_organization_id IN NUMBER
636: , p_inventory_item_id IN NUMBER
637: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
633: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
634: , p_ser_number IN VARCHAR2
635: , p_organization_id IN NUMBER
636: , p_inventory_item_id IN NUMBER
637: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
638: );
639:
640: --************************************************************************************************
641: -- Procedure