DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on INV_GLOBALS

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

2323: /** Bug 2403417 - add a check of the lpn context. If the lpn Context is "Picked"
2324: and transaction is subtransfer, return error INV_LPN_DELIVERY_ASSOC
2325: **/
2326:
2327: if( p_source_type_id = INV_GLOBALS.G_SourceType_Inventory ) then
2328: select transaction_action_id
2329: into l_action_id
2330: From mtl_transaction_types
2331: where transaction_type_id = p_transaction_Type_id

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

2330: From mtl_transaction_types
2331: where transaction_type_id = p_transaction_Type_id
2332: And transaction_Source_Type_id = p_source_type_id;
2333:
2334: if( l_action_id = INV_GLOBALS.G_Action_Subxfr ) then
2335: select count(wdd.delivery_detail_id)
2336: into l_count
2337: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn
2338: WHere wdd.lpn_id = wlpn.lpn_id