DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on INV_LOT_SEL_ATTR

Line 26: g_lot_ser_attributes_tbl INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;

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: --********************************************************************************************

Line 27: g_lot_attributes_tbl INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;

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

Line 585: x_lot_attr_tbl OUT NOCOPY Inv_Lot_Sel_Attr.Lot_Sel_Attributes_Tbl_Type,

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,

Line 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: );

Line 591: inv_lot_sel_attr.lot_sel_attributes_tbl_type,

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:

Line 633: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

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

Line 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