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 586: x_lot_attr_tbl OUT NOCOPY Inv_Lot_Sel_Attr.Lot_Sel_Attributes_Tbl_Type,

582: x_return_status OUT NOCOPY VARCHAR2,
583: x_msg_count OUT NOCOPY NUMBER,
584: x_msg_data OUT NOCOPY VARCHAR2,
585: x_validation_status OUT NOCOPY VARCHAR2,
586: x_lot_attr_tbl OUT NOCOPY Inv_Lot_Sel_Attr.Lot_Sel_Attributes_Tbl_Type,
587: p_lot_number IN VARCHAR2,
588: p_organization_id IN NUMBER,
589: p_inventory_item_id IN NUMBER,
590: p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,

Line 590: p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,

586: x_lot_attr_tbl OUT NOCOPY Inv_Lot_Sel_Attr.Lot_Sel_Attributes_Tbl_Type,
587: p_lot_number IN VARCHAR2,
588: p_organization_id IN NUMBER,
589: p_inventory_item_id IN NUMBER,
590: p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
591: p_result_lot_attr_tbl IN
592: inv_lot_sel_attr.lot_sel_attributes_tbl_type,
593: p_transaction_type_id IN NUMBER
594: );

Line 592: inv_lot_sel_attr.lot_sel_attributes_tbl_type,

588: p_organization_id IN NUMBER,
589: p_inventory_item_id IN NUMBER,
590: p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
591: p_result_lot_attr_tbl IN
592: inv_lot_sel_attr.lot_sel_attributes_tbl_type,
593: p_transaction_type_id IN NUMBER
594: );
595:
596:

Line 634: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

630: x_return_status OUT NOCOPY VARCHAR2
631: , x_msg_count OUT NOCOPY NUMBER
632: , x_msg_data OUT NOCOPY VARCHAR2
633: , x_validation_status OUT NOCOPY VARCHAR2
634: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
635: , p_ser_number IN VARCHAR2
636: , p_organization_id IN NUMBER
637: , p_inventory_item_id IN NUMBER
638: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 638: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

634: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
635: , p_ser_number IN VARCHAR2
636: , p_organization_id IN NUMBER
637: , p_inventory_item_id IN NUMBER
638: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
639: );
640:
641: --************************************************************************************************
642: -- Procedure