DBA Data[Home] [Help]

APPS.WMS_ENGINE_PVT dependencies on USER_PKG_LOT

Line 2997: l_value_from_user_pkg_lot BOOLEAN := FALSE;

2993: FUNCTION check_exp_lot_txn_allowed (p_mol_id NUMBER)
2994: RETURN BOOLEAN IS
2995:
2996: l_allow_expired_lot_txn NUMBER;
2997: l_value_from_user_pkg_lot BOOLEAN := FALSE;
2998:
2999: l_organization_id NUMBER;
3000: l_inventory_item_id NUMBER;
3001: l_transaction_source_type_id NUMBER;

Line 3070: l_value_from_user_pkg_lot := USER_PKG_LOT.use_expired_lots (

3066: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside check_exp_lot_txn_allowed ', 9);
3067: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3068: END IF;
3069:
3070: l_value_from_user_pkg_lot := USER_PKG_LOT.use_expired_lots (
3071: p_organization_id => l_organization_id
3072: , p_inventory_item_id => l_inventory_item_id
3073: , p_demand_source_type_id => l_transaction_source_type_id
3074: , p_demand_source_line_id => l_txn_source_line_id

Line 3077: --Condition to check user_pkg_lot for expired lot allocation

3073: , p_demand_source_type_id => l_transaction_source_type_id
3074: , p_demand_source_line_id => l_txn_source_line_id
3075: );
3076:
3077: --Condition to check user_pkg_lot for expired lot allocation
3078: IF (l_value_from_user_pkg_lot) THEN --IF the use hook returns TRUE means they want expired lots to be allocated
3079:
3080: IF(l_debug = 1) THEN
3081: inv_log_util.trace( 'The USER_PKG_LOT returned TRUE and so we will allow expired lots to be transaced::: ' , 'Coming from USER_PKG_LOT.use_expired_lots ', 9);

Line 3078: IF (l_value_from_user_pkg_lot) THEN --IF the use hook returns TRUE means they want expired lots to be allocated

3074: , p_demand_source_line_id => l_txn_source_line_id
3075: );
3076:
3077: --Condition to check user_pkg_lot for expired lot allocation
3078: IF (l_value_from_user_pkg_lot) THEN --IF the use hook returns TRUE means they want expired lots to be allocated
3079:
3080: IF(l_debug = 1) THEN
3081: inv_log_util.trace( 'The USER_PKG_LOT returned TRUE and so we will allow expired lots to be transaced::: ' , 'Coming from USER_PKG_LOT.use_expired_lots ', 9);
3082: END IF;

Line 3081: inv_log_util.trace( 'The USER_PKG_LOT returned TRUE and so we will allow expired lots to be transaced::: ' , 'Coming from USER_PKG_LOT.use_expired_lots ', 9);

3077: --Condition to check user_pkg_lot for expired lot allocation
3078: IF (l_value_from_user_pkg_lot) THEN --IF the use hook returns TRUE means they want expired lots to be allocated
3079:
3080: IF(l_debug = 1) THEN
3081: inv_log_util.trace( 'The USER_PKG_LOT returned TRUE and so we will allow expired lots to be transaced::: ' , 'Coming from USER_PKG_LOT.use_expired_lots ', 9);
3082: END IF;
3083: l_allow_expired_lot_txn := 1;
3084: RETURN TRUE;
3085: END IF;