DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on INV_GLOBALS

Line 2101: if( p_source_type_id = INV_GLOBALS.G_SourceType_Inventory ) then

2097: /** Bug 2403417 - add a check of the lpn context. If the lpn Context is "Picked"
2098: and transaction is subtransfer, return error INV_LPN_DELIVERY_ASSOC
2099: **/
2100:
2101: if( p_source_type_id = INV_GLOBALS.G_SourceType_Inventory ) then
2102: select transaction_action_id
2103: into l_action_id
2104: From mtl_transaction_types
2105: where transaction_type_id = p_transaction_Type_id

Line 2108: if( l_action_id = INV_GLOBALS.G_Action_Subxfr ) then

2104: From mtl_transaction_types
2105: where transaction_type_id = p_transaction_Type_id
2106: And transaction_Source_Type_id = p_source_type_id;
2107:
2108: if( l_action_id = INV_GLOBALS.G_Action_Subxfr ) then
2109: select count(wdd.delivery_detail_id)
2110: into l_count
2111: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn
2112: WHere wdd.lpn_id = wlpn.lpn_id