DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on INV_CACHE

Line 4323: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id

4319: WHERE ROWID = l_wlpn_row_id;
4320:
4321: ELSIF p_clear_containter_item_id = 'N'
4322: AND l_container_item_id IS NOT NULL THEN
4323: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id
4324: , p_item_id => l_container_item_id ) ) THEN
4325: IF l_debug = 1 THEN
4326: mdebug('Error calling inv_cache.set_item_rec');
4327: END IF;

Line 4326: mdebug('Error calling inv_cache.set_item_rec');

4322: AND l_container_item_id IS NOT NULL THEN
4323: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id
4324: , p_item_id => l_container_item_id ) ) THEN
4325: IF l_debug = 1 THEN
4326: mdebug('Error calling inv_cache.set_item_rec');
4327: END IF;
4328: RAISE fnd_api.g_exc_unexpected_error;
4329: END IF;
4330:

Line 4332: SET gross_weight = inv_cache.item_rec.unit_weight

4328: RAISE fnd_api.g_exc_unexpected_error;
4329: END IF;
4330:
4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume

Line 4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code

4329: END IF;
4330:
4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code

Line 4334: , tare_weight = inv_cache.item_rec.unit_weight

4330:
4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4338: WHERE ROWID = l_wlpn_row_id;

Line 4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code

4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4338: WHERE ROWID = l_wlpn_row_id;
4339: END IF;

Line 4336: , container_volume = inv_cache.item_rec.unit_volume

4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4338: WHERE ROWID = l_wlpn_row_id;
4339: END IF;
4340:

Line 4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code

4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4338: WHERE ROWID = l_wlpn_row_id;
4339: END IF;
4340:
4341: ELSIF p_unpack_inner_lpns = 'Y' THEN

Line 4552: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id

4548: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4549:
4550: ELSIF p_clear_containter_item_id = 'N'
4551: AND l_container_item_id IS NOT NULL THEN
4552: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id
4553: , p_item_id => l_container_item_id ) ) THEN
4554: IF l_debug = 1 THEN
4555: mdebug('Error calling inv_cache.set_item_rec');
4556: END IF;

Line 4555: mdebug('Error calling inv_cache.set_item_rec');

4551: AND l_container_item_id IS NOT NULL THEN
4552: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id
4553: , p_item_id => l_container_item_id ) ) THEN
4554: IF l_debug = 1 THEN
4555: mdebug('Error calling inv_cache.set_item_rec');
4556: END IF;
4557: RAISE fnd_api.g_exc_unexpected_error;
4558: END IF;
4559:

Line 4561: SET gross_weight = inv_cache.item_rec.unit_weight

4557: RAISE fnd_api.g_exc_unexpected_error;
4558: END IF;
4559:
4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume

Line 4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code

4558: END IF;
4559:
4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code

Line 4563: , tare_weight = inv_cache.item_rec.unit_weight

4559:
4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4567: WHERE lpn_id = all_child_wlpn_rec.lpn_id;

Line 4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code

4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4567: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4568: END IF;

Line 4565: , container_volume = inv_cache.item_rec.unit_volume

4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4567: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4568: END IF;
4569:

Line 4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code

4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4567: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4568: END IF;
4569:
4570: END LOOP;